Elizabeth Christensen of Crunchy Data walks us through how to use open source tooling to avoid paying the Esri tax.
It was a great tour of the options and also a nice vibe check of the industry. A headline here is she echoes former guest Stephanie May in endorsing DuckDB. She also wanted to pass on that a great way to find out more is to attend PostGIS Day! More here. On the topic of resources, Elizabeth has been very helpful and provided the following set of links:
#PostgreSQL, open source relational database | |
https://www.postgresql.org/ | |
#PostGIS, open source GIS data store | |
https://postgis.net/ | |
# PostGIS Day 2024 | |
https://www.crunchydata.com/community/events/postgis-day-2024 | |
#Crunchy Data, Postgres and PostGIS services provider | |
https://www.crunchydata.com/ | |
# Open Source Geospatial Foundation | |
https://www.osgeo.org/ | |
#QGIS download, open source mapping | |
https://www.qgis.org/ | |
#Simple map SQL queries as QGIS layers | |
https://www.crunchydata.com/blog/connecting-qgis-to-postgres-and-postgis | |
#pg_tileserv - Tile server for PostGIS | |
https://github.com/CrunchyData/pg_tileserv | |
#pg_featureserv - API JSON server for PostGIS | |
https://github.com/CrunchyData/pg_featureserv/ | |
#OpenLayers project | |
https://openlayers.org/ | |
#OpenLayers + PgRouting + pg_tileserv + pg_featureserv sample code | |
https://github.com/CrunchyData/pg_featureserv/tree/master/demo | |
#PostGIS day videos | |
https://www.youtube.com/@CrunchyDataPostgres | |
#Crunchy Data’s Postgres Playground | |
https://www.crunchydata.com/developers/tutorials | |
#Really cool open source GIS people to follow | |
Paul Ramsey @ Crunchy Data / cleverelephant | |
Regina Obe @ Paragon | |
Ryan Lambert @ RustProofLabs | |
Cliff Patterson @ Luna Geospatial | |
Matt Forrest @ Whereabots | |
#Elizabeth's crunchy blogs | |
https://www.crunchydata.com/blog/author/elizabeth-christensen | |
#Elizabeth's LinkedIn | |
https://www.linkedin.com/in/elizabeth-garrett-christensen/ | |
#Elizabeth's Twitter | |
https://twitter.com/sqlliz |
THE GEOSPATIAL INDEX
The Geospatial Index is a comprehensive listing of all publicly traded geospatial businesses worldwide. Why? The industry is growing at ~5% annually (after inflation and after adjusting for base rates). This rate varies significantly, however, by sub index. For $480,000 to start, this growth rate is $5,000,000 over a working life. This channel, Bluesky account, newsletter, watchlist and podcast express the view that you are serious about geospatial if you take the view of an investor, venture capitalist or entrepreneur. You are expected to do your own research. This is not a replacement for that. This is not investment advice. Consider it entertainment.
NOT THE OPINION OF MY EMPLOYER
NOT YOUR FIDUCIARY
NOT INVESTMENT ADVICE
Bluesky: https://bsky.app/profile/geospatialindex.bsky.social
LinkedIn: https://uk.linkedin.com/in/geospatialindex
Watchlist: https://www.tradingview.com/watchlists/123254792/
Newsletter:
Podcast:
Crunchy Data