PIGSTY

GIS

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

GIS category contains 20 PostgreSQL extensions.

IDExtensionPackageVersionDescription
1500postgispostgis3.6.0PostGIS geometry and geography spatial types and functions
1501postgis_topologypostgis3.6.0PostGIS topology spatial types and functions
1502postgis_rasterpostgis3.6.0PostGIS raster types and functions
1503postgis_sfcgalpostgis3.6.0PostGIS SFCGAL functions
1504postgis_tiger_geocoderpostgis3.6.0PostGIS tiger geocoder and reverse geocoder
1505address_standardizerpostgis3.6.0Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
1506address_standardizer_data_uspostgis3.6.0Address Standardizer US dataset example
1510pgroutingpgrouting3.8.0pgRouting Extension
1520pointcloudpointcloud1.2.5data type for lidar point clouds
1521pointcloud_postgispointcloud1.2.5integration for pointcloud LIDAR data and PostGIS geometry data
1530h3pg_h34.2.3H3 bindings for PostgreSQL
1531h3_postgispg_h34.2.3H3 PostGIS integration
1540q3cq3c2.0.1q3c sky indexing plugin
1550ogr_fdwogr_fdw1.1.7foreign-data wrapper for GIS data access
1560geoipgeoip0.3.0IP-based geolocation query
1570pg_polylinepg_polyline0.0.1Fast Google Encoded Polyline encoding & decoding for postgres
1590pg_geohashpg_geohash1.0Handle geohash based functionality for spatial coordinates
1650mobilitydbmobilitydb1.2.0MobilityDB geospatial trajectory data management & analysis platform
1680tzfpg_tzf0.2.2Fast lookup timezone name by GPS coordinates
1690earthdistanceearthdistance1.2calculate great-circle distances on the surface of the Earth

postgis - 3.6.0

PostGIS geometry and geography spatial types and functions

ExtensionWebsiteAttributes
Packagepostgis
RPMpostgis36_$v*
DDL
DEBpostgresql-$v-postgis-3 postgresql-$v-postgis-3-scripts
LIB
Language
C
License
GPL-2.0
OS/Archx86_64aarch64
el8
18
17
16
15
14
18
17
16
15
14
el9
18
17
16
15
14
18
17
16
15
14
d12
18
17
16
15
14
18
17
16
15
14
u22
18
17
16
15
14
18
17
16
15
14
u24
18
17
16
15
14
18
17
16
15
14

postgis_topology - 3.6.0

PostGIS topology spatial types and functions

ExtensionWebsiteAttributes
Packagepostgis
RPMpostgis35_$v*
DDL
DEBpostgresql-$v-postgis-3 postgresql-$v-postgis-3-scripts
LIB
Language
C
License
GPL-2.0
OS/Archx86_64aarch64
el8
18
17
16
15
14
18
17
16
15
14
el9
18
17
16
15
14
18
17
16
15
14
d12
18
17
16
15
14
18
17
16
15
14
u22
18
17
16
15
14
18
17
16
15
14
u24
18
17
16
15
14
18
17
16
15
14

postgis_raster - 3.6.0

PostGIS raster types and functions

ExtensionWebsiteAttributes
Packagepostgis
RPMpostgis35_$v*
DDL
DEBpostgresql-$v-postgis-3 postgresql-$v-postgis-3-scripts
LIB
Language
C
License
GPL-2.0
OS/Archx86_64aarch64
el8
18
17
16
15
14
18
17
16
15
14
el9
18
17
16
15
14
18
17
16
15
14
d12
18
17
16
15
14
18
17
16
15
14
u22
18
17
16
15
14
18
17
16
15
14
u24
18
17
16
15
14
18
17
16
15
14

postgis_sfcgal - 3.6.0

PostGIS SFCGAL functions

ExtensionWebsiteAttributes
Packagepostgis
RPMpostgis35_$v*
DDL
DEBpostgresql-$v-postgis-3 postgresql-$v-postgis-3-scripts
LIB
Language
C
License
GPL-2.0
OS/Archx86_64aarch64
el8
18
17
16
15
14
18
17
16
15
14
el9
18
17
16
15
14
18
17
16
15
14
d12
18
17
16
15
14
18
17
16
15
14
u22
18
17
16
15
14
18
17
16
15
14
u24
18
17
16
15
14
18
17
16
15
14

postgis_tiger_geocoder - 3.6.0

PostGIS tiger geocoder and reverse geocoder

ExtensionWebsiteAttributes
Packagepostgis
RPMpostgis35_$v*
DDL
DEBpostgresql-$v-postgis-3 postgresql-$v-postgis-3-scripts
LIB
Language
C
TRUST
License
GPL-2.0
OS/Archx86_64aarch64
el8
18
17
16
15
14
18
17
16
15
14
el9
18
17
16
15
14
18
17
16
15
14
d12
18
17
16
15
14
18
17
16
15
14
u22
18
17
16
15
14
18
17
16
15
14
u24
18
17
16
15
14
18
17
16
15
14

address_standardizer - 3.6.0

Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.

ExtensionWebsiteAttributes
Packagepostgis
RPMpostgis35_$v*
DDL
DEBpostgresql-$v-postgis-3 postgresql-$v-postgis-3-scripts
LIB
Language
C
License
GPL-2.0
OS/Archx86_64aarch64
el8
18
17
16
15
14
18
17
16
15
14
el9
18
17
16
15
14
18
17
16
15
14
d12
18
17
16
15
14
18
17
16
15
14
u22
18
17
16
15
14
18
17
16
15
14
u24
18
17
16
15
14
18
17
16
15
14

address_standardizer_data_us - 3.6.0

Address Standardizer US dataset example

ExtensionWebsiteAttributes
Packagepostgis
RPMpostgis35_$v*
DDL
DEBpostgresql-$v-postgis-3 postgresql-$v-postgis-3-scripts
LIB
Language
C
License
GPL-2.0
OS/Archx86_64aarch64
el8
18
17
16
15
14
18
17
16
15
14
el9
18
17
16
15
14
18
17
16
15
14
d12
18
17
16
15
14
18
17
16
15
14
u22
18
17
16
15
14
18
17
16
15
14
u24
18
17
16
15
14
18
17
16
15
14

pgrouting - 3.8.0

pgRouting Extension

ExtensionWebsiteAttributes
Packagepgrouting
RPMpgrouting_$v*
DDL
DEBpostgresql-$v-pgrouting postgresql-$v-pgrouting-scripts
LIB
Language
C++
License
GPL-2.0
OS/Archx86_64aarch64
el8
18
17
16
15
14
18
17
16
15
14
el9
18
17
16
15
14
18
17
16
15
14
d12
18
17
16
15
14
18
17
16
15
14
u22
18
17
16
15
14
18
17
16
15
14
u24
18
17
16
15
14
18
17
16
15
14

pointcloud - 1.2.5

data type for lidar point clouds

ExtensionWebsiteAttributes
Packagepointcloud
RPMpointcloud_$v*
DDL
DEBpostgresql-$v-pointcloud
LIB
Language
C
License
BSD 3-Clause
OS/Archx86_64aarch64
el8
18
17
16
15
14
18
17
16
15
14
el9
18
17
16
15
14
18
17
16
15
14
d12
18
17
16
15
14
18
17
16
15
14
u22
18
17
16
15
14
18
17
16
15
14
u24
18
17
16
15
14
18
17
16
15
14

pointcloud_postgis - 1.2.5

integration for pointcloud LIDAR data and PostGIS geometry data

ExtensionWebsiteAttributes
Packagepointcloud
RPMpointcloud_$v*
DDL
DEBpostgresql-$v-pointcloud
LIB
Language
C
TRUST
License
BSD 3-Clause
OS/Archx86_64aarch64
el8
18
17
16
15
14
18
17
16
15
14
el9
18
17
16
15
14
18
17
16
15
14
d12
18
17
16
15
14
18
17
16
15
14
u22
18
17
16
15
14
18
17
16
15
14
u24
18
17
16
15
14
18
17
16
15
14

h3 - 4.2.3

H3 bindings for PostgreSQL

ExtensionWebsiteAttributes
Packagepg_h3
RPMh3-pg_$v*
DDL
DEBpostgresql-$v-h3
LIB
Language
C
License
Apache-2.0
OS/Archx86_64aarch64
el8
18
17
16
15
14
18
17
16
15
14
el9
18
17
16
15
14
18
17
16
15
14
d12
18
17
16
15
14
18
17
16
15
14
u22
18
17
16
15
14
18
17
16
15
14
u24
18
17
16
15
14
18
17
16
15
14

h3_postgis - 4.2.3

H3 PostGIS integration

ExtensionWebsiteAttributes
Packagepg_h3
RPMh3-pg_$v*
DDL
DEBpostgresql-$v-h3
LIB
Language
C
License
Apache-2.0
OS/Archx86_64aarch64
el8
18
17
16
15
14
18
17
16
15
14
el9
18
17
16
15
14
18
17
16
15
14
d12
18
17
16
15
14
18
17
16
15
14
u22
18
17
16
15
14
18
17
16
15
14
u24
18
17
16
15
14
18
17
16
15
14

q3c - 2.0.1

q3c sky indexing plugin

ExtensionWebsiteAttributes
Packageq3c
RPMq3c_$v*
DDL
DEBpostgresql-$v-q3c
LIB
Language
C
License
GPL-2.0
OS/Archx86_64aarch64
el8
18
17
16
15
14
18
17
16
15
14
el9
18
17
16
15
14
18
17
16
15
14
d12
18
17
16
15
14
18
17
16
15
14
u22
18
17
16
15
14
18
17
16
15
14
u24
18
17
16
15
14
18
17
16
15
14

ogr_fdw - 1.1.7

foreign-data wrapper for GIS data access

ExtensionWebsiteAttributes
Packageogr_fdw
RPMogr_fdw_$v*
DDL
DEBpostgresql-$v-ogr-fdw
LIB
Language
C
License
MIT
OS/Archx86_64aarch64
el8
18
17
16
15
14
18
17
16
15
14
el9
18
17
16
15
14
18
17
16
15
14
d12
18
17
16
15
14
18
17
16
15
14
u22
18
17
16
15
14
18
17
16
15
14
u24
18
17
16
15
14
18
17
16
15
14

geoip - 0.3.0

IP-based geolocation query

ExtensionWebsiteAttributes
Packagegeoip
RPMgeoip_$v
DDL
DEBpostgresql-$v-geoip
LIB
Language
SQL
License
BSD 2-Clause
OS/Archx86_64aarch64
el8
18
17
16
15
14
18
17
16
15
14
el9
18
17
16
15
14
18
17
16
15
14
d12
18
17
16
15
14
18
17
16
15
14
u22
18
17
16
15
14
18
17
16
15
14
u24
18
17
16
15
14
18
17
16
15
14

pg_polyline - 0.0.1

Fast Google Encoded Polyline encoding & decoding for postgres

ExtensionWebsiteAttributes
Packagepg_polyline
RPMpg_polyline_$v
DDL
DEBpostgresql-$v-pg-polyline
LIB
Language
Rust
TRUST
License
MIT
OS/Archx86_64aarch64
el8
18
17
16
15
14
18
17
16
15
14
el9
18
17
16
15
14
18
17
16
15
14
d12
18
17
16
15
14
18
17
16
15
14
u22
18
17
16
15
14
18
17
16
15
14
u24
18
17
16
15
14
18
17
16
15
14

pg_geohash - 1.0

Handle geohash based functionality for spatial coordinates

ExtensionWebsiteAttributes
Packagepg_geohash
RPMpg_geohash_$v*
DDL
DEBpostgresql-$v-pg-geohash
LIB
Language
C
License
MIT
OS/Archx86_64aarch64
el8
18
17
16
15
14
18
17
16
15
14
el9
18
17
16
15
14
18
17
16
15
14
d12
18
17
16
15
14
18
17
16
15
14
u22
18
17
16
15
14
18
17
16
15
14
u24
18
17
16
15
14
18
17
16
15
14

mobilitydb - 1.2.0

MobilityDB geospatial trajectory data management & analysis platform

ExtensionWebsiteAttributes
Packagemobilitydb
RPMmobilitydb_$v*
DDL
DEBpostgresql-$v-mobilitydb
LIB
Language
C
License
GPL-3.0
OS/Archx86_64aarch64
el8
18
17
16
15
14
18
17
16
15
14
el9
18
17
16
15
14
18
17
16
15
14
d12
18
17
16
15
14
18
17
16
15
14
u22
18
17
16
15
14
18
17
16
15
14
u24
18
17
16
15
14
18
17
16
15
14

tzf - 0.2.2

Fast lookup timezone name by GPS coordinates

ExtensionWebsiteAttributes
Packagepg_tzf
RPMpg_tzf_$v
DDL
DEBpostgresql-$v-tzf
LIB
Language
Rust
License
MIT
OS/Archx86_64aarch64
el8
18
17
16
15
14
18
17
16
15
14
el9
18
17
16
15
14
18
17
16
15
14
d12
18
17
16
15
14
18
17
16
15
14
u22
18
17
16
15
14
18
17
16
15
14
u24
18
17
16
15
14
18
17
16
15
14

earthdistance - 1.2

calculate great-circle distances on the surface of the Earth

ExtensionWebsiteAttributes
Packageearthdistance
RPMpostgresql$v-contrib
DDL
DEBpostgresql-$v
LIB
Language
C
License
PostgreSQL
OS/Archx86_64aarch64
el8
18
17
16
15
14
18
17
16
15
14
el9
18
17
16
15
14
18
17
16
15
14
d12
18
17
16
15
14
18
17
16
15
14
u22
18
17
16
15
14
18
17
16
15
14
u24
18
17
16
15
14
18
17
16
15
14