PostGIS 1.5 Manual

SVN Revision (11757)

Abstract

PostGIS is an extension to the PostgreSQL object-relational database system which allows GIS (Geographic Information Systems) objects to be stored in the database. PostGIS includes support for GiST-based R-Tree spatial indexes, and functions for analysis and processing of GIS objects.

This is the manual for version 1.5.9SVN

This work is licensed under a Creative Commons Attribution-Share Alike 3.0 License. Feel free to use this material any way you like, but we ask that you attribute credit to the PostGIS Project and wherever possible, a link back to http://postgis.net.


Table of Contents

1. Introduction
1.1. Project Steering Committee
1.2. Contributors Past and Present
1.3. More Information
2. Installation
2.1. Short Version
2.2. Requirements
2.3. Getting the Source
2.4. Installation
2.4.1. Configuration
2.4.2. Building
2.4.3. Testing
2.4.4. Installation
2.5. Create a spatially-enabled database
2.6. Create a spatially-enabled database from a template
2.7. Upgrading
2.7.1. Soft upgrade
2.7.2. Hard upgrade
2.8. Common Problems
2.9. JDBC
2.10. Loader/Dumper
3. Frequently Asked Questions
4. Using PostGIS: Data Management and Queries
4.1. GIS Objects
4.1.1. OpenGIS WKB and WKT
4.1.2. PostGIS EWKB, EWKT and Canonical Forms
4.1.3. SQL-MM Part 3
4.2. PostGIS Geography Type
4.2.1. Geography Basics
4.2.2. When to use Geography Data type over Geometry data type
4.2.3. Geography Advanced FAQ
4.3. Using OpenGIS Standards
4.3.1. The SPATIAL_REF_SYS Table and Spatial Reference Systems
4.3.2. The GEOMETRY_COLUMNS Table
4.3.3. Creating a Spatial Table
4.3.4. Manually Registering Geometry Columns in geometry_columns
4.3.5. Ensuring OpenGIS compliancy of geometries
4.3.6. Dimensionally Extended 9 Intersection Model (DE-9IM)
4.4. Loading GIS Data
4.4.1. Using SQL
4.4.2. Using the Loader
4.5. Retrieving GIS Data
4.5.1. Using SQL
4.5.2. Using the Dumper
4.6. Building Indexes
4.6.1. GiST Indexes
4.6.2. Using Indexes
4.7. Complex Queries
4.7.1. Taking Advantage of Indexes
4.7.2. Examples of Spatial SQL
5. Using PostGIS: Building Applications
5.1. Using MapServer
5.1.1. Basic Usage
5.1.2. Frequently Asked Questions
5.1.3. Advanced Usage
5.1.4. Examples
5.2. Java Clients (JDBC)
5.3. C Clients (libpq)
5.3.1. Text Cursors
5.3.2. Binary Cursors
6. Performance tips
6.1. Small tables of large geometries
6.1.1. Problem description
6.1.2. Workarounds
6.2. CLUSTERing on geometry indices
6.3. Avoiding dimension conversion
6.4. Tuning your configuration
6.4.1. Startup
6.4.2. Runtime
7. PostGIS Reference
7.1. PostgreSQL PostGIS Types
7.2. Management Functions
7.3. Geometry Constructors
7.4. Geometry Accessors
7.5. Geometry Editors
7.6. Geometry Outputs
7.7. Operators
7.8. Spatial Relationships and Measurements
7.9. Geometry Processing Functions
7.10. Linear Referencing
7.11. Long Transactions Support
7.12. Miscellaneous Functions
7.13. Exceptional Functions
8. PostGIS Special Functions Index
8.1. PostGIS Aggregate Functions
8.2. PostGIS SQL-MM Compliant Functions
8.3. PostGIS Geography Support Functions
8.4. PostGIS Geometry Dump Functions
8.5. PostGIS Box Functions
8.6. PostGIS Functions that support 3D
8.7. PostGIS Curved Geometry Support Functions
8.8. PostGIS Function Support Matrix
8.9. New PostGIS Functions
8.9.1. PostGIS Functions new, behavior changed, or enhanced in 1.5
8.9.2. PostGIS Functions new, behavior changed, or enhanced in 1.4
8.9.3. PostGIS Functions new in 1.3
9. Reporting Problems
9.1. Reporting Software Bugs
9.2. Reporting Documentation Issues
A. Appendix
A.1. Release 1.5.8
A.2. Release 1.5.7
A.3. Release 1.5.6
A.4. Release 1.5.5
A.5. Release 1.5.4
A.6. Release 1.5.3
A.7. Release 1.5.2
A.8. Release 1.5.1
A.9. Release 1.5.0
A.10. Release 1.4.0
A.11. Release 1.3.6
A.12. Release 1.3.5
A.13. Release 1.3.4
A.14. Release 1.3.3
A.15. Release 1.3.2
A.16. Release 1.3.1
A.17. Release 1.3.0
A.18. Release 1.2.1
A.19. Release 1.2.0
A.20. Release 1.1.6
A.21. Release 1.1.5
A.22. Release 1.1.4
A.23. Release 1.1.3
A.24. Release 1.1.2
A.25. Release 1.1.1
A.26. Release 1.1.0
A.27. Release 1.0.6
A.28. Release 1.0.5
A.29. Release 1.0.4
A.30. Release 1.0.3
A.31. Release 1.0.2
A.32. Release 1.0.1
A.33. Release 1.0.0
A.34. Release 1.0.0RC6
A.35. Release 1.0.0RC5
A.36. Release 1.0.0RC4
A.37. Release 1.0.0RC3
A.38. Release 1.0.0RC2
A.39. Release 1.0.0RC1