PIGSTY

GIS

GeoSpatial Data Types, Operators, and Indexes, Hexagonal Indexing, OGR Data FDW, GeoIP & MobilityDB

GIS category contains 20 PostgreSQL extensions.

IDExtensionPackageVersionDescription
1500postgispostgis3.5.2PostGIS geometry and geography spatial types and functions
1501postgis_topologypostgis3.5.2PostGIS topology spatial types and functions
1502postgis_rasterpostgis3.5.2PostGIS raster types and functions
1503postgis_sfcgalpostgis3.5.2PostGIS SFCGAL functions
1504postgis_tiger_geocoderpostgis3.5.2PostGIS tiger geocoder and reverse geocoder
1505address_standardizerpostgis3.5.2Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
1506address_standardizer_data_uspostgis3.5.2Address 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.2H3 bindings for PostgreSQL
1531h3_postgispg_h34.2.2H3 PostGIS integration
1540q3cq3c2.0.1q3c sky indexing plugin
1550ogr_fdwogr_fdw1.1.6foreign-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.5.2

PostGIS geometry and geography 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
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

postgis_topology - 3.5.2

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
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

postgis_raster - 3.5.2

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
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

postgis_sfcgal - 3.5.2

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
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

postgis_tiger_geocoder - 3.5.2

PostGIS tiger geocoder and reverse geocoder

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

address_standardizer - 3.5.2

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
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

address_standardizer_data_us - 3.5.2

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
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

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
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

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
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

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
License
BSD 3-Clause
TRUST
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

h3 - 4.2.2

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
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

h3_postgis - 4.2.2

H3 PostGIS integration

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

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
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

ogr_fdw - 1.1.6

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
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

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
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

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
License
MIT
TRUST
OS/Archx86_64aarch64
el8
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

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
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

mobilitydb - 1.2.0

MobilityDB geospatial trajectory data management & analysis platform

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

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
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13

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
17
16
15
14
13
17
16
15
14
13
el9
17
16
15
14
13
17
16
15
14
13
d12
17
16
15
14
13
17
16
15
14
13
u22
17
16
15
14
13
17
16
15
14
13
u24
17
16
15
14
13
17
16
15
14
13