PostGIS adds support for geographic objects to the PostgreSQL object-relational database. In effect, PostGIS "spatially enables" the PostgreSQL server, allowing it to be used as a backend spatial database for geographic information systems (GIS), much like ESRI's SDE or Oracle's Spatial extension.
| Tags | Database Database Engines/Servers |
|---|---|
| Licenses | GPL |
| Operating Systems | POSIX Windows Windows Windows |
Recent releases


Changes: This release fixes an important bug introduced in previous release that broke the ability to use Mapserver LINE layers with PostGIS.


Changes: This release added an ST_AsGeoJSON() function, PostgreSQL 8.4 support, performance improvements with GEOS 3.1, memory leak fixes, documentation improvements, and more reliable handling of curve types.


Changes: Improvements in the shp2pgsql/pgsql2shp utilities (better Windows support, DBF-only loading support, support for OS X 10.5, and output for Date types in DBF). A new function ST_SimplifyPreserveTopology(geometry, float8) to simplify polygons without creating invalid geometry. KML support updates and SVG support updates.


Changes: Improvements in the TIGER geocoder. A fix for an ST_EndPoint() crash bug. ST_AsGML() has been modified, improving v2 and adding v3 support. A fix to ensure ST_Envelope() returns valid geometries. The JDBC build has been changed to use Ant. A fix for better OS X support. A fix to the WKB parser to do simple validity checks.


Changes: A bug in Within() caused by a point-in-polygon performance shortcut was fixed. A bug in indexes with null on PostgreSQL 8.2 was fixed. JTS handling of multi-dimensional data was fixed. GCJ Java support was fixed. A fix was made for JDBC compatibility in PostgreSQL 8.2. The AsKML() function was added. Transform() performance was improved when no transform is actually required.