This is the multi-page printable view of this section. Click here to print.

Return to the regular view of this page.

Category: GIS

GIS: GeoSpatial Data Types, Operators, and Indexes, Hexagonal Indexing, OGR Data FDW, GeoIP & MobilityDB, etc…

GIS category has 10 available extensions:

Extension (URL) Alias Repo Version Category License LOAD DDL TRUST RELOC Description
postgis postgis PGDG 3.4.2 GIS GPLv2 PostGIS geometry and geography spatial types and functions
postgis_topology postgis PGDG 3.4.2 GIS GPLv2 PostGIS topology spatial types and functions
postgis_raster postgis PGDG 3.4.2 GIS GPLv2 PostGIS raster types and functions
postgis_sfcgal postgis PGDG 3.4.2 GIS GPLv2 PostGIS SFCGAL functions
postgis_tiger_geocoder postgis PGDG 3.4.2 GIS GPLv2 PostGIS tiger geocoder and reverse geocoder
address_standardizer postgis PGDG 3.4.2 GIS GPLv2 Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
address_standardizer_data_us postgis PGDG 3.4.2 GIS GPLv2 Address Standardizer US dataset example
pgrouting pgrouting PGDG 3.6.0 GIS GPLv2 pgRouting Extension
pointcloud pointcloud PIGSTY 1.2.5 GIS BSD 3 data type for lidar point clouds
pointcloud_postgis pointcloud PGDG 1.2.5 GIS BSD 3 integration for pointcloud LIDAR data and PostGIS geometry data
h3 pg_h3 PGDG 4.1.3 GIS Apache-2.0 H3 bindings for PostgreSQL
h3_postgis pg_h3 PGDG 4.1.3 GIS Apache-2.0 H3 PostGIS integration
q3c q3c PIGSTY 2.0.1 GIS GPLv2 q3c sky indexing plugin
ogr_fdw ogr_fdw PGDG 1.1 GIS MIT foreign-data wrapper for GIS data access
geoip geoip PGDG 0.3.0 GIS BSD 2 IP-based geolocation query
pg_geohash pg_geohash PIGSTY 1.0 GIS MIT Handle geohash based functionality for spatial coordinates
mobilitydb mobilitydb PGDG 1.1.1 GIS GPLv3 MobilityDB geospatial trajectory data management & analysis platform
earthdistance earthdistance CONTRIB 1.1 GIS PostgreSQL calculate great-circle distances on the surface of the Earth

1 - postgis

PostGIS geometry and geography spatial types and functions

Overview

PGDG 1st Party Extension: postgis : PostGIS geometry and geography spatial types and functions

Information

Metadata

  • Version: 3.4.2
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: postgis34_$v*
  • RPM Ver : 3.4.2
  • RPM Deps: Nil
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-postgis-3*
  • DEB Ver : 3.4.2
  • DEB Deps: Nil

Details

2 - pgrouting

pgRouting Extension

Overview

PGDG 1st Party Extension: pgrouting : pgRouting Extension

Information

Metadata

  • Version: 3.6.0
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: postgis

Packages

  • RPM Repo: PGDG
  • RPM Name: pgrouting_$v*
  • RPM Ver : 3.6.0
  • RPM Deps: Nil
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-pgrouting*
  • DEB Ver : 3.6.2
  • DEB Deps: Nil

Details

3 - pointcloud

data type for lidar point clouds

Overview

PIGSTY 3rd Party Extension: pointcloud : data type for lidar point clouds

Information

Metadata

  • Version: 1.2.5
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: pointcloud_$v*
  • RPM Ver : 1.2.5
  • RPM Deps: Nil
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-pointcloud
  • DEB Ver : 1.2.5
  • DEB Deps: Nil

Details

4 - h3

H3 bindings for PostgreSQL

Overview

PGDG 1st Party Extension: pg_h3 : H3 bindings for PostgreSQL

Information

Metadata

  • Version: 4.1.3
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: h3-pg_$v*
  • RPM Ver : 4.1.3
  • RPM Deps: Nil
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-h3
  • DEB Ver : 4.1.3
  • DEB Deps: Nil

Details

5 - q3c

q3c sky indexing plugin

Overview

PIGSTY 3rd Party Extension: q3c : q3c sky indexing plugin

Information

Metadata

  • Version: 2.0.1
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: q3c_$v*
  • RPM Ver : 2.0.1
  • RPM Deps: Nil
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-q3c
  • DEB Ver : 2.0.1
  • DEB Deps: Nil

Details

6 - ogr_fdw

foreign-data wrapper for GIS data access

Overview

PGDG 1st Party Extension: ogr_fdw : foreign-data wrapper for GIS data access

Information

Metadata

  • Version: 1.1
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: ogr_fdw_$v*
  • RPM Ver : 1.1
  • RPM Deps: Nil
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-ogr-fdw
  • DEB Ver : 1.1
  • DEB Deps: Nil

Details

7 - geoip

IP-based geolocation query

Overview

PGDG 3rd Party Extension: geoip : IP-based geolocation query

Information

Metadata

  • Version: 0.3.0
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: geoip
  • Requires: ip4r

Packages

  • RPM Repo: PGDG
  • RPM Name: geoip_$v*
  • RPM Ver : 0.3.0
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-geoip
  • DEB Ver : 0.3.0
  • DEB Deps: Nil

Details

8 - pg_geohash

Handle geohash based functionality for spatial coordinates

Overview

PIGSTY 3rd Party Extension: pg_geohash : Handle geohash based functionality for spatial coordinates

Information

Metadata

  • Version: 1.0
  • PG Vers: 15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Unknown
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: pg_geohash_$v*
  • RPM Ver : 1.0
  • RPM Deps: Nil
  • DEB Repo: N/A
  • DEB Name: N/A
  • DEB Ver : N/A
  • DEB Deps: Nil

Details

9 - mobilitydb

MobilityDB geospatial trajectory data management & analysis platform

Overview

PGDG 1st Party Extension: mobilitydb : MobilityDB geospatial trajectory data management & analysis platform

Information

Metadata

  • Version: 1.1.1
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: postgis

Packages

  • RPM Repo: N/A
  • RPM Name: N/A
  • RPM Ver : N/A
  • RPM Deps: Nil
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-mobilitydb
  • DEB Ver : 1.1.1
  • DEB Deps: Nil

Details

10 - earthdistance

calculate great-circle distances on the surface of the Earth

Overview

CONTRIB Built-in Extension: earthdistance : calculate great-circle distances on the surface of the Earth

Information

Metadata

  • Version: 1.1
  • PG Vers: 16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Unknown
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: cube

Packages

PostgreSQL Built-in Contrib Extension

Details