Crunchy Data

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 databasehttps://www.postgresql.org/#PostGIS, open source GIS data storehttps://postgis.net/# PostGIS Day 2024https://www.crunchydata.com/community/events/postgis-day-2024#Crunchy Data, Postgres and PostGIS services providerhttps://www.crunchydata.com/# Open Source Geospatial Foundationhttps://www.osgeo.org/#QGIS download, open source mappinghttps://www.qgis.org/#Simple map SQL queries as QGIS layershttps://www.crunchydata.com/blog/connecting-qgis-to-postgres-and-postgis#pg_tileserv - Tile server for PostGIShttps://github.com/CrunchyData/pg_tileserv#pg_featureserv - API JSON server for PostGIShttps://github.com/CrunchyData/pg_featureserv/#OpenLayers projecthttps://openlayers.org/#OpenLayers + PgRouting + pg_tileserv + pg_featureserv sample codehttps://github.com/CrunchyData/pg_featureserv/tree/master/demo#PostGIS day videoshttps://www.youtube.com/@CrunchyDataPostgres#Crunchy Data’s Postgres Playgroundhttps://www.crunchydata.com/developers/tutorials#Really cool open source GIS people to followPaul Ramsey @ Crunchy Data / cleverelephant Regina Obe @ ParagonRyan Lambert @ RustProofLabsCliff Patterson @ Luna GeospatialMatt Forrest @ Whereabots#Elizabeth's crunchy blogshttps://www.crunchydata.com/blog/author/elizabeth-christensen#Elizabeth's LinkedInhttps://www.linkedin.com/in/elizabeth-garrett-christensen/#Elizabeth's Twitterhttps://twitter.com/sqllizTHE 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: https://www.geospatial.money/ Podcast: https://open.spotify.com/show/5gpQUsaWxEBpYCnypEdHFC