Opengeo

PostGIS Community

About PostGIS

PostGIS “spatially enables” the PostgreSQL open source relational database. The database can then be used to store and query spatial data (points, lines and polygons).

  • OGC standards compliant (SFSQL)
  • Hundreds of spatial functions
    • Buffers, unions, overlays, distance and more
  • ACID transactional integrity
  • R-Tree spatial index
  • Multi-user support
  • Row-level locking
  • Replication
  • Partitioning
  • Role-based security
  • Table-spaces, schemas

PostGIS Apps

PostGIS is widely supported as a spatial database back-end to client and server software.

PostGIS @ OpenGeo

Recent Contributions

OpenGeo funds ongoing development of PostGIS as part of our larger mission to make public geodata more accessible and usable to civil society. Recent contributions include:

  • Addition of a "geography" type, allowing native indexing and functions on spherical (latitude/longitude) coordinates.
  • Performance improvements to the ST_Union() aggregate and all other geometry aggregates.
  • Addition of a GUI for Shape file loading.
  • Upgrading the underlying geometry libraries.
  • Coordination of the release of PostGIS 1.5.
  • Coordination and maintenance work around the release of GEOS 3.2.2.
  • Organization of a second code sprint for PostGIS.

Our PostGIS Team

Paul Ramsey

Paul Ramsey

Paul has worked on geospatial software for over 13 years, as a programmer and consultant. He co-founded the PostGIS spatial database project in 2001, and is an active developer and project steering committee member.

PostGIS

PostGIS Resources

OpenGeo Services

OpenGeo offers PostGIS training, including introductory and advanced sessions.

OpenGeo offers PostGIS core development to add new features to the project.