PostGIS

Crunchy Bridge comes equipped with PostgreSQL extensions that allow for storing, processing, and analyzing geospatial data:

Enable PostGIS

The PostGIS extension must first be enabled before enabling the Raster and pgRouting extensions.

CREATE EXTENSION postgis;

PostGIS needs to be enabled in every database where you want to work with geospatial data.

Tip: You can check the full PostGIS version that has been installed by running the following:

SELECT PostGIS_Full_Version();

Loading Vector Data

There are a variety of ways to load vector data. Common tools used are:

shp2pgsql
ogr2ogr
QGIS

For more details as well as an interactive tutorial, see:
Loading Data into PostGIS: An Overview
Load Data into PostGIS (Crunchy Data Learning Portal)

Raster Data Storage and Processing with PostGIS Raster

Enable the PostGIS Raster extension:

CREATE EXTENSION postgis_raster;

Out-DB raster storage

Because Bridge is hosted in the cloud, you can connect your Bridge PostgreSQL & PostGIS to remote object storage where the raster data is uploaded. This is also known as “out-db” storage, where a pointer (which includes bounds and a reference to the external location) is saved in PostGIS for the raster files. The raster files themselves could be stored in the cloud, such as in an Amazon S3 bucket.

More details are available in PostGIS Raster and Crunchy Bridge.

Working with PostGIS

Many third-party tools are compatible with PostgreSQL/PostGIS as a spatial database:

Desktop GIS

QGIS
ArcGIS
ArcGIS Pro

Web Map Servers

GeoServer
MapServer
MapNik
pg_tileserv & pg_featureserv