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
- US States: https://gerardrbentley-streamlit-state-guesser-streamlit-app-owl1sn.streamlit.app/
- Country Guesser: https://country-guesser.streamlit.app/
Last game starts exploring GeoPandas and I’m definitely liking it for querying into a dataframe.
- Worldle Clone: https://st-worldle.streamlit.app/?locale=en