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:
- Performance improvements to the ST_Union() aggregate and all other geometry aggregates.
- Addition of a GUI for Shape file loading.
- Re-working of the version upgrade script.
- Coordination of the release of PostGIS 1.4.
- Coordination and maintenance work around the release of GEOS 3.1.0.
- Organization of a code sprint for PostGIS.
Our PostGIS Team
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 Resources
- PostGIS Community Site
- PostGIS Issue Tracker
- PostGIS SVN Repository
- Spatial Database Tips & Tricks
- PostGIS Chat Room
OpenGeo Services
OpenGeo offers PostGIS training, including introductory and advanced sessions.
OpenGeo offers PostGIS core development to add new features to the project.