PostGIS stores and queries for information about location and mapping and provides spatial objects (geometry, geography, and raster as well as others) for the PostgreSQL object-relational database. It also adds functions, operators, and index enhancements to these spatial types that augment the power of the core PostgreSQL DBMS, making it a fast, featureful, and robust spatial database management system.

  • Support for common and advanced spatial operations such as geometry creation and conversion, reprojection, buffer, convex hull, generalization, union, and more
  • Rendering and importing vector data formats such as Shapefiles KML, GML, GeoJSON, GeoHash and WKT using SQL
  • Rendering and importing raster data formats such as GeoTIFF, PNG, JPG, NetCDF, etc.
  • Geodetic support for measurements across the globe/dateline
  • 3D object support, spatial index, and functions
  • Network topology support
  • Command-line and graphical tools for flexible management

Open Source, Open Standards

PostGIS is open source software, released under the GNU General Public License, that implements the Open Geospatial Consortium’sSimple Features for SQL Specification”. PostGIS also works well as a data source for GeoServer, which provides services like WMS, WFS, WCS, and WPS.

Case Studies

One thought on “PostGIS

  1. Pingback: - GISCafe Guest - Thoughts from State of the Map US 2014

Comments are closed.

Featured Team Members


David Winslow

Software Engineer

David has committed to every component of OpenGeo Suite. He is a core committer to GeoServer and GeoTools, as well as a contributor to OpenLayers, GeoExt and PostGIS. David has been working with open-source software for nearly a decade, as both an user and a developer.

Jody Garnett

Jody Garnett

Senior Software Engineer

Jody develops Boundless’ training program and mentors outside developers in the open source community. He is a committer and Project Steering Committee Member for GeoServer and GeoTools. Jody is a teacher, a programmer and a very effective problem solver.

Paul Ramsey

Paul Ramsey

Senior Strategist & Evangelist

Paul has been working with geospatial software for over ten years, as programmer and consultant. He founded the PostGIS spatial database project in 2001 and is currently an active developer and member of the project steering committee. Paul evangelizes for our OpenGeo Suite product, works with our business development team to improve communication about our offerings, and speaks and teaches regularly at conferences around the world.