Playback speed
×
Share post
Share post at current time
0:00
/
0:00
Transcript

Crunchy Data

Openly saucy backends

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:

This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode characters
#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
view raw gistfile1.txt hosted with ❤ by GitHub

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:

Discussion about this podcast

The Geospatial Index
Geospatial Index Podcast
Obsessed with compounding via publicly listed geospatial equities.
Listen on
Substack App
Spotify
RSS Feed
Appears in episode
The Geospatial Index