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…

1: postgis
2: pgrouting
3: pointcloud
4: h3
5: q3c
6: ogr_fdw
7: geoip
8: pg_polyline
9: pg_geohash
10: mobilitydb
11: earthdistance

GIS category has 11 available extensions:

Extension (URL)	Alias	Repo	Version	Category	License	Description
postgis	`postgis`	PGDG	3.5.0	`GIS`	GPLv2	PostGIS geometry and geography spatial types and functions
postgis_topology	`postgis`	PGDG	3.5.0	`GIS`	GPLv2	PostGIS topology spatial types and functions
postgis_raster	`postgis`	PGDG	3.5.0	`GIS`	GPLv2	PostGIS raster types and functions
postgis_sfcgal	`postgis`	PGDG	3.5.0	`GIS`	GPLv2	PostGIS SFCGAL functions
postgis_tiger_geocoder	`postgis`	PGDG	3.5.0	`GIS`	GPLv2	PostGIS tiger geocoder and reverse geocoder
address_standardizer	`postgis`	PGDG	3.5.0	`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.5.0	`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_polyline	`pg_polyline`	PIGSTY	0.0.0	`GIS`	MIT	Fast Google Encoded Polyline encoding & decoding for postgres
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

ID: 1100
Name: postgis
Alias: postgis
Category: GIS
Website: https://git.osgeo.org/gitea/postgis/postgis
License: GPLv2 License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 3.5.0
PG Vers: 17,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.5.0
RPM Deps: Nil
DEB Repo: PGDG
DEB Name: postgresql-$v-postgis-3*
DEB Ver : 3.5.0
DEB Deps: Nil

Details

2 - pgrouting

pgRouting Extension

Overview

PGDG 1st Party Extension: pgrouting : pgRouting Extension

Information

ID: 1110
Name: pgrouting
Alias: pgrouting
Category: GIS
Website: https://github.com/pgRouting/pgrouting
License: GPLv2 License
Language: Unknown
Tags: N/A
Comment:

Metadata

Version: 3.6.0
PG Vers: 17,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

ID: 1120
Name: pointcloud
Alias: pointcloud
Category: GIS
Website: https://github.com/pgpointcloud/pointcloud
License: BSD 3 License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 1.2.5
PG Vers: 17,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

ID: 1130
Name: h3
Alias: pg_h3
Category: GIS
Website: https://github.com/zachasme/h3-pg
License: Apache-2.0 License
Language: Unknown
Tags: N/A
Comment:

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

ID: 1140
Name: q3c
Alias: q3c
Category: GIS
Website: https://github.com/segasai/q3c
License: GPLv2 License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 2.0.1
PG Vers: 17,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

ID: 1150
Name: ogr_fdw
Alias: ogr_fdw
Category: GIS
Website: https://github.com/pramsey/pgsql-ogr-fdw
License: MIT License
Language: Unknown
Tags: N/A
Comment: 无

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

ID: 1155
Name: geoip
Alias: geoip
Category: GIS
Website: https://github.com/tvondra/geoip
License: BSD 2 License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 0.3.0
PG Vers: 17,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_polyline

Fast Google Encoded Polyline encoding & decoding for postgres

Overview

PIGSTY 3rd Party Extension: pg_polyline : Fast Google Encoded Polyline encoding & decoding for postgres

Information

ID: 1160
Name: pg_polyline
Alias: pg_polyline
Category: GIS
Website: https://github.com/yihong0618/pg_polyline
License: MIT License
Language: Rust
Tags: pgrx
Comment:

Metadata

Version: 0.0.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Relocatable
Trusted: Trusted, Can be created by user with CREATE Privilege
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: pg_polyline_$v
RPM Ver : 0.0.0
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-polyline
DEB Ver : 0.0.0
DEB Deps: Nil

Details

9 - pg_geohash

Handle geohash based functionality for spatial coordinates

Overview

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

Information

ID: 1170
Name: pg_geohash
Alias: pg_geohash
Category: GIS
Website: https://github.com/jistok/pg_geohash
License: MIT License
Language: C
Tags: nil-lic
Comment: 无

Metadata

Version: 1.0
PG Vers: 17,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: pg_geohash_$v*
RPM Ver : 1.0
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-geohash
DEB Ver : 1.0
DEB Deps: Nil

Details

10 - mobilitydb

MobilityDB geospatial trajectory data management & analysis platform

Overview

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

Information

ID: 1180
Name: mobilitydb
Alias: mobilitydb
Category: GIS
Website: https://github.com/MobilityDB/MobilityDB
License: GPLv3 License
Language: Unknown
Tags: N/A
Comment:

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

11 - 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

ID: 1190
Name: earthdistance
Alias: earthdistance
Category: GIS
Website: https://www.postgresql.org/docs/current/earthdistance.html
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.1
PG Vers: 17,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