pg_polyline
Fast Google Encoded Polyline encoding & decoding for postgres
Repository
yihong0618/pg_polyline
https://github.com/yihong0618/pg_polyline
Source
pg_polyline-0.0.1.tar.gz
pg_polyline-0.0.1.tar.gz
Overview
| Package | Version | Category | License | Language |
|---|---|---|---|---|
pg_polyline | 0.0.1 | GIS | MIT | Rust |
| ID | Extension | Bin | Lib | Load | Create | Trust | Reloc | Schema |
|---|---|---|---|---|---|---|---|---|
| 1570 | pg_polyline | No | Yes | No | Yes | Yes | No | - |
| Related | postgis pgrouting pg_geohash postgis_topology postgis_raster postgis_sfcgal postgis_tiger_geocoder address_standardizer |
|---|
Version
| Type | Repo | Version | PG Ver | Package | Deps |
|---|---|---|---|---|---|
| EXT | PIGSTY | 0.0.1 | 1817161514 | pg_polyline | - |
| RPM | PIGSTY | 0.0.1 | 1817161514 | pg_polyline_$v | - |
| DEB | PIGSTY | 0.0.1 | 1817161514 | postgresql-$v-pg-polyline | - |
Build
You can build the RPM / DEB packages for pg_polyline using pig build:
pig build pkg pg_polyline # build RPM / DEB packages
Install
You can install pg_polyline directly. First, make sure the PGDG and PIGSTY repositories are added and enabled:
pig repo add pgsql -u # Add repo and update cache
Install the extension using pig or apt/yum/dnf:
pig install pg_polyline; # Install for current active PG version
pig ext install -y pg_polyline -v 18 # PG 18
pig ext install -y pg_polyline -v 17 # PG 17
pig ext install -y pg_polyline -v 16 # PG 16
pig ext install -y pg_polyline -v 15 # PG 15
pig ext install -y pg_polyline -v 14 # PG 14
dnf install -y pg_polyline_18 # PG 18
dnf install -y pg_polyline_17 # PG 17
dnf install -y pg_polyline_16 # PG 16
dnf install -y pg_polyline_15 # PG 15
dnf install -y pg_polyline_14 # PG 14
apt install -y postgresql-18-pg-polyline # PG 18
apt install -y postgresql-17-pg-polyline # PG 17
apt install -y postgresql-16-pg-polyline # PG 16
apt install -y postgresql-15-pg-polyline # PG 15
apt install -y postgresql-14-pg-polyline # PG 14
Create Extension:
CREATE EXTENSION pg_polyline;
Usage
pg_polyline: Google Encoded Polyline encoding & decoding for PostgreSQL
Fast Google Encoded Polyline encoding & decoding as a PostgreSQL extension. Built with pgrx.
CREATE EXTENSION pg_polyline;
-- Encode an array of points to a polyline string
SELECT polyline_encode(
ARRAY[point(-120.2, 38.5), point(-120.95, 40.7), point(-126.453, 43.252)], 6
);
-- polyline_encode
-- ----------------------------------
-- _izlhA~rlgdF_{geC~ywl@_kwzCn`{nI
-- Decode a polyline string back to points
SELECT polyline_decode('_ibE_seK_seK_seK', 6);
-- polyline_decode
-- ---------------------------
-- {"(0.2,0.1)","(0.4,0.3)"}
The second parameter is the precision (number of decimal places).
Feedback
Was this page helpful?
Thanks for the feedback! Please let us know how we can improve.
Sorry to hear that. Please let us know how we can improve.