DEV (Sun 27 Oct 2024 10:41:31 PM UTC rev. 3779b5a )
The PostGIS Development Group
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 3.4.4dev
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 https://postgis.net.
Table of Contents
- 1. Introduction
- 2. PostGIS Installation
- 3. PostGIS Administration
- 4. Data Management
- 5. Spatial Queries
- 6. Performance Tips
- 7. PostGIS Reference
- 7.1. PostGIS Geometry/Geography/Box Data Types
- 7.2. Table Management Functions
- 7.3. Geometry Constructors
- 7.4. Geometry Accessors
- 7.5. Geometry Editors
- 7.6. Geometry Validation
- 7.7. Spatial Reference System Functions
- 7.8. Geometry Input
- 7.9. Geometry Output
- 7.10. Operators
- 7.11. Spatial Relationships
- 7.12. Measurement Functions
- 7.13. Overlay Functions
- 7.14. Geometry Processing
- 7.15. Coverages
- 7.16. Affine Transformations
- 7.17. Clustering Functions
- 7.18. Bounding Box Functions
- 7.19. Linear Referencing
- 7.20. Trajectory Functions
- 7.21. SFCGAL Functions
- 7.22. Long Transaction Support
- 7.23. Version Functions
- 7.24. Grand Unified Custom Variables (GUCs)
- 7.25. Troubleshooting Functions
- 8. Topology
- 8.1. Topology Types
- 8.2. Topology Domains
- 8.3. Topology and TopoGeometry Management
- 8.4. Topology Statistics Management
- 8.5. Topology Constructors
- 8.6. Topology Editors
- 8.7. Topology Accessors
- 8.8. Topology Processing
- 8.9. TopoGeometry Constructors
- 8.10. TopoGeometry Editors
- 8.11. TopoGeometry Accessors
- 8.12. TopoGeometry Outputs
- 8.13. Topology Spatial Relationships
- 8.14. Importing and exporting Topologies
- 9. Raster Data Management, Queries, and Applications
- 9.1. Loading and Creating Rasters
- 9.2. Raster Catalogs
- 9.3. Building Custom Applications with PostGIS Raster
- 9.3.1. PHP Example Outputting using ST_AsPNG in concert with other raster functions
- 9.3.2. ASP.NET C# Example Outputting using ST_AsPNG in concert with other raster functions
- 9.3.3. Java console app that outputs raster query as Image file
- 9.3.4. Use PLPython to dump out images via SQL
- 9.3.5. Outputting Rasters with PSQL
- 10. Raster Reference
- 10.1. Raster Support Data types
- 10.2. Raster Management
- 10.3. Raster Constructors
- 10.4. Raster Accessors
- 10.5. Raster Band Accessors
- 10.6. Raster Pixel Accessors and Setters
- 10.7. Raster Editors
- 10.8. Raster Band Editors
- 10.9. Raster Band Statistics and Analytics
- 10.10. Raster Inputs
- 10.11. Raster Outputs
- 10.12. Raster Processing: Map Algebra
- 10.13. Built-in Map Algebra Callback Functions
- 10.14. Raster Processing: DEM (Elevation)
- 10.15. Raster Processing: Raster to Geometry
- 10.16. Raster Operators
- 10.17. Raster and Raster Band Spatial Relationships
- 10.18. Raster Tips
- 11. PostGIS Extras
- 12. PostGIS Special Functions Index
- 12.1. PostGIS Aggregate Functions
- 12.2. PostGIS Window Functions
- 12.3. PostGIS SQL-MM Compliant Functions
- 12.4. PostGIS Geography Support Functions
- 12.5. PostGIS Raster Support Functions
- 12.6. PostGIS Geometry / Geography / Raster Dump Functions
- 12.7. PostGIS Box Functions
- 12.8. PostGIS Functions that support 3D
- 12.9. PostGIS Curved Geometry Support Functions
- 12.10. PostGIS Polyhedral Surface Support Functions
- 12.11. PostGIS Function Support Matrix
- 12.12. New, Enhanced or changed PostGIS Functions
- 12.12.1. PostGIS Functions new or enhanced in 3.4
- 12.12.2. PostGIS Functions new or enhanced in 3.3
- 12.12.3. PostGIS Functions new or enhanced in 3.2
- 12.12.4. PostGIS Functions new or enhanced in 3.1
- 12.12.5. PostGIS Functions new or enhanced in 3.0
- 12.12.6. PostGIS Functions new or enhanced in 2.5
- 12.12.7. PostGIS Functions new or enhanced in 2.4
- 12.12.8. PostGIS Functions new or enhanced in 2.3
- 12.12.9. PostGIS Functions new or enhanced in 2.2
- 12.12.10. PostGIS Functions new or enhanced in 2.1
- 12.12.11. PostGIS Functions new or enhanced in 2.0
- 12.12.12. PostGIS Functions new or enhanced in 1.5
- 12.12.13. PostGIS Functions new or enhanced in 1.4
- 12.12.14. PostGIS Functions new or enhanced in 1.3
- 13. Reporting Problems
- A. Appendix