Geography Games with Spatialite

post on some geography guessing games I’ve been building with streamlit + sqlite + spatialite + geopandas + folium (what a mouthful…)

Utilizing datasets from US Census and World Bank for shapefiles, I loaded them into SQLite database files with Spatialite. I really like this pattern for single user or read-only apps (no deploying and connecting to Postgres + PostGIS, but that is required for heavy multi-user context)

The first 2 use sqlite and GeoJSON pretty rawly to dump a random location, envelopes, and shapes to a Folium map (ANN: streamlit-folium, a Component for rendering Folium maps

Last game starts exploring GeoPandas and I’m definitely liking it for querying into a dataframe.


1 Like