PostGIS 2.2.0dev开发手册:安装、空间支持与常见问题

需积分: 17 43 下载量 39 浏览量 更新于2024-07-20 收藏 10.9MB PDF 举报
PostGIS文档是一份详细的指南,针对PostGIS 2.2.0dev版本的开发和安装过程,以及与之相关的空间数据管理、查询和问题解决方案。PostGIS是PostgreSQL的关系型数据库管理系统中用于处理地理空间数据的扩展模块,它遵循OpenGIS标准,支持GIS对象的操作和地理数据类型的管理。 文档首先介绍了PostGIS的背景,包括项目指导委员会、核心和非核心贡献者,以及获取更多关于项目的资源。安装部分是文档的核心,详细描述了安装的步骤,包括: 1. **安装要求**:明确了安装PostGIS所需的最低 PostgreSQL 版本。 2. **获取源码**:提供了获取源代码的方式,可能涉及到下载和克隆版本控制仓库。 3. **编译与安装**: - **简版安装**:适用于快速安装,但可能没有所有特性。 - **详细步骤**:涉及配置环境,编译扩展,并进行部署。 - **配置**:设置编译选项,确保兼容性和性能。 - **测试**:确保安装成功并通过测试。 - **使用TigerGeocoder插件**:介绍了安装和升级Tiger地理编码插件的方法,以及地址标准化工具的安装。 对于在不同版本的PostgreSQL上安装和管理空间支持也有专门章节,比如如何在9.1以下版本中添加支持,以及在9.1及以上版本中利用插件进行升级。此外,文档还涵盖了从模板库创建空间数据库的升级方法,区分了软升级(对数据库结构的平滑更新)和硬升级(可能涉及数据迁移)。 4. **数据管理和查询**:介绍了PostGIS中的GIS对象、OpenGIS WKB/WKT规范,以及SQL-MM(Mapnik Mapnik Markup Language)的使用。这部分重点讲解了地理数据类型,如geometry和geography的区别,以及何时选择哪一种类型。 5. **常见问题与解决方案**:列出了安装过程中可能遇到的问题,以及如何通过JDBC连接和数据装载/导出来处理这些问题。 这份PostGIS文档为用户提供了全面的指南,覆盖从基础安装到高级空间数据操作的各个环节,旨在帮助用户充分利用PostGIS的强大功能进行地理空间数据分析和应用。
2019-12-17 上传
PostGIS is a spatial database that integrates advanced storage and analysis of vector and raster data, and is remarkably flexible and powerful. PostGIS provides support for geographic objects to the PostgreSQL object-relational database and is currently the most popular open source spatial databases. If you want to explore the complete range of PostGIS techniques and expose the related extensions, this book is a must-have. This book is a deep-dive into the full range of PostGIS topics, with practical applications of the concepts and code. It is a comprehensive guide on PostGIS tools and concepts which are required to manage, manipulate, and analyse spatial data in PostGIS. This book is packed with systematic instructions of hands-on examples and in-depth explanations. Even for experienced users, this book will serve as a great source of reference by providing new ways of working with PostGIS through the book’s easy-to-follow approach. This hands-on guide looks at key spatial data manipulation tasks, explaining not only how each task is performed, but also why. It provides practical guidance allowing you to safely take advantage of the advanced technology in PostGIS in order to simplify your spatial database administration tasks. This practical book will help you take advantage of basic and advanced vector, raster, and routing approaches. You will learn to use the concepts of data maintenance, optimization, and performance, which will help you to integrate these into a large ecosystem of desktop and web tools. With this comprehensive guide, you will be armed with all the tools and instructions you need to both manage the spatial database system and make better decisions as your project’s requirements evolve.
2018-04-23 上传
Create and manage spatial data with PostGIS Key Features Import and export geographic data from the PostGIS database using the available tools Maintain, optimize, and fine-tune spatial data for long-term viability Utilize the parallel support functionality that was introduced in PostgreSQL 9.6 Book Description PostGIS is a spatial database that integrates the advanced storage and analysis of vector and raster data, and is remarkably flexible and powerful. PostGIS provides support for geographic objects to the PostgreSQL object-relational database and is currently the most popular open source spatial databases. If you want to explore the complete range of PostGIS techniques and expose related extensions, then this book is for you. This book is a comprehensive guide to PostGIS tools and concepts which are required to manage, manipulate, and analyze spatial data in PostGIS. It covers key spatial data manipulation tasks, explaining not only how each task is performed, but also why. It provides practical guidance allowing you to safely take advantage of the advanced technology in PostGIS in order to simplify your spatial database administration tasks. Furthermore, you will learn to take advantage of basic and advanced vector, raster, and routing approaches along with the concepts of data maintenance, optimization, and performance, and will help you to integrate these into a large ecosystem of desktop and web tools. By the end, you will be armed with all the tools and instructions you need to both manage the spatial database system and make better decisions as your project's requirements evolve. What you will learn Import and export geographic data from the PostGIS database using the available tools Structure spatial data using the functionality provided by a combination of PostgreSQL and PostGIS Work with a set of PostGIS functions to perform basic and advanced vector analyses Connect PostGIS with Python Learn to use programming frameworks around PostGIS Maintain, optimize, and fine-tune spatial data for long-term viability Explore the 3D capabilities of PostGIS, including LiDAR point clouds and point clouds derived from Structure from Motion (SfM) techniques Distribute 3D models through the Web using the X3D standard Use PostGIS to develop powerful GIS web applications using Open Geospatial Consortium web standards Master PostGIS Raster Who This Book Is For This book is for developers who need some quick solutions for PostGIS. Prior knowledge of PostgreSQL and spatial concepts would be an added advantage. Table of Contents Chapter 1. MOVING DATA IN AND OUT OF POSTGIS Chapter 2. STRUCTURES THAT WORK Chapter 3. WORKING WITH VECTOR DATA THE BASICS Chapter 4. WORKING WITH VECTOR DATA ADVANCED RECIPES Chapter 5. WORKING WITH RASTER DATA Chapter 6. WORKING WITH PGROUTING Chapter 7. Into the Nth Dimension Chapter 8. POSTGIS PROGRAMMING Chapter 9. POSTGIS AND THE WEB Chapter 10. MAINTENANCE OPTIMIZATION AND PERFORMANCE TUNING Chapter 11. USING DESKTOP CLIENTS Chapter 12. Introduction to Location Privacy Protection Mechanisms