PostGIS Surprise, the Sequel
Regina Obe
Buy our books! https://postgis.us/page_buy_book
Latest books
|
 |
|
 |
Mastodon: https://mapstodon.space/@robe
| pgRouting (a practical guide) 2nd Ed (Locate Press) in Progress.
|
The Book of PostgreSQL (No Starch Press) In Progress |
Fund OSGeo projects: https://www.osgeo.org/about/how-to-become-a-sponsor/
If you want to donate to the pgRouting Project
Fund options here: https://pgrouting.org/support.html
- Open Collective: https://opencollective.com/pgrouting
- Community Bridge: https://crowdfunding.lfx.linuxfoundation.org/projects/pgrouting
A big THANK YOU to OSGeo.UK for their continual funding of pgRouting.
- postgis (for loading shp2pgsql, pgsql2shp, shp2pgsql-gui)
- postgis_raster (raster2pgsql for loading)
- postgis_sfcgal
- postgis_topology
- postgis_tiger_geocoder
- address_standardizer, address_standardizer_data_us
- ogr_fdw
- pgrouting (osm2pgrouting for loading osm data)
- pointcloud, pointcloud_postgis
- h3, h3_postgis
- mobilitydb 1.2
Can't enable in database with CREATE EXTENSION unless have binaries
Available from packagers: (apt.postgresql.org, yum.postgresql.org, ubuntugis, Windows Stackbuilder, bsd ports, homebrew) postgis packaged extensions, pointcloud/pointcloud_postgis, pgrouting, ogr_fdw, oracle_fdw
h3 for newer OS also available on apt.postgresql.org and yum.postgresql.org
mobilitydb for newer now available on apt.postgresql.org
Support via Database As a Service (DBaaS): postgis extensions (except sometimes not postgis_sfcgal), pgrouting, oracle_fdw (sometimes), ogr_fdw (sometimes)
Live demo
https://postgis.us/presentations/postgisday_2024.sql