PostGIS

An open-source extension to Postgres that spatially enables your database server.

PostGIS is an open-source extension for the PostgreSQL object relational database that adds support for geographic objects, allowing location queries to be run in SQL. Providing spatial objects and functions, it enables storage and query of location and mapping information.

Once connected through EDB Postgres, PostGIS assumes the native features of the database deployment, and can take advantage of the power of the underlying database system—scalability, ACID compliance, rules, triggers, partial indexes, materialised views, partitioning, multiple table spaces, multi-layer security, etc.

Graphic of globe

Features

PostGIS’s capabilities include:

 
Icon data in

Importing of data

From a desktop GIS to a new or existing table

Icon boundry

Boundary and buffer

Easily create common spatial definitions

Icon data out

Returning data

For a given radius with a single function call

Data Types

PostGIS has four main spatial data types:

  •  

    Geometry for flat-earth, uses a Cartesian grid

  •  

    Geography for round-earth, especially useful for organizations that that collect data from all over the globe

  •  

    Raster type, where each cell can contain values that provide additional context to your vector data

  •  

    Topology types, for modelling the real-world rules of your vector features

Graphic of spatial data types