PostGIS

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

Featured Team Members

DavidW

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.

Paul Ramsey

Paul Ramsey

Vice President, Product Management

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. In 2008, Paul received the Sol Katz Award for achievement in open source geospatial software.

As a team member with Boundless, Paul leads consulting engagements, software and support of the PostGIS database; he works with our business development team to improve communication about our open source offerings; and, he speaks and teaches regularly at conferences around the world.

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.