PostGIS

PostGIS is a spatial extension for the PostgreSQL relational database that was created by Refractions Research Inc, as a spatial database technology research project. Refractions is a GIS and database consulting company in Victoria, British Columbia, Canada, specializing in data integration and custom software development.

PostGIS is now a project of the OSGeo Foundation and is developed and funded by many FOSS4G developers and organizations all over the world that gain great benefit from its functionality and versatility.

The PostGIS project development group plans on supporting and enhancing PostGIS to better support a range of important GIS functionality in the areas of OpenGIS and SQL/MM spatial standards, advanced topological constructs (coverages, surfaces, networks), data source for desktop user interface tools for viewing and editing GIS data, and web-based access tools.

SELECT superhero.name
FROM city, superhero
WHERE ST_Contains(city.geom, superhero.geom)
AND city.name = 'Gotham';

PostGIS Installation

Link

Using PostGIS: Data Management and Queries

Link

  • GIS Objects
  • PostGIS Geography Type
  • Using OpenGIS Standards
  • Loading GIS (Vector) Data
  • Retrieving GIS Data
  • Building Indexes
  • Complex Queries

Raster Data Management, Queries, and Applications

Link

  • Loading and Creating Rasters
  • Raster Catalogs
  • Building Custom Applications with PostGIS Raster

Using PostGIS Geometry: Building Applications

Link

Performance tips

Link

  • Small tables of large geometries
  • CLUSTERing on geometry indices
  • Avoiding dimension conversion
  • Tuning your configuration

PostGIS Reference

Link

  • PostGIS Geometry/Geography/Box Data Types
  • Table Management Functions
  • Geometry Constructors
  • Geometry Accessors
  • Geometry Editors
  • Geometry Validation
  • Spatial Reference System Functions
  • Geometry Input
  • Geometry Output
  • Operators
  • Spatial Relationships
  • Measurement Functions
  • Geometry Processing
  • Affine Transformations
  • Clustering Functions
  • Bounding Box Functions
  • Linear Referencing
  • Trajectory Functions
  • SFCGAL Functions
  • Long Transaction Support
  • Version Functions
  • Grand Unified Custom Variables (GUCs)
  • Troubleshooting Functions

Raster Reference

Link

  • Raster Support Data types
  • Raster Management
  • Raster Constructors
  • Raster Accessors
  • Raster Band Accessors
  • Raster Pixel Accessors and Setters
  • Raster Editors
  • Raster Band Editors
  • Raster Band Statistics and Analytics
  • Raster Inputs
  • Raster Outputs
  • Raster Processing
  • Raster Operators
  • Raster and Raster Band Spatial Relationships
  • Raster Tips

Topology

Link

  • Topology Types
  • Topology Domains
  • Topology and TopoGeometry Management
  • Topology Constructors
  • Topology Editors
  • Topology Accessors
  • Topology Processing
  • TopoGeometry Constructors
  • TopoGeometry Editors
  • TopoGeometry Accessors
  • TopoGeometry Outputs
  • Topology Spatial Relationships

Address Standardizer

Link

This is a fork of the PAGC standardizer (original code for this portion was PAGC PostgreSQL Address Standardizer).

PostGIS Extras

Link

PostGIS Special Functions Index

Link

  • PostGIS Aggregate Functions
  • PostGIS Window Functions
  • PostGIS SQL-MM Compliant Functions
  • PostGIS Geography Support Functions
  • PostGIS Raster Support Functions
  • PostGIS Geometry / Geography / Raster Dump Functions
  • PostGIS Box Functions
  • PostGIS Functions that support 3D
  • PostGIS Curved Geometry Support Functions
  • PostGIS Polyhedral Surface Support Functions
  • PostGIS Function Support Matrix
  • New, Enhanced or changed PostGIS Functions

Appendix

Link