Hi Streamlit folks 
,
Sharing a small but end-to-end demo I’ve been working on that combines geospatial data, analytics, and forecasting in a Streamlit app.
The project simulates smart city street-light maintenance using:
-
* PostGIS for spatial queries
-
* Snowflake** Openflow (managed** * Apache NiFi) + * Snowflake Cortex + ML for CDC, analytics, and forecasting
-
Streamlit for the interactive dashboard
Code & setup:
https://github.com/kameshsampath/postgis-snowflake-intelligence-demo
Quick walkthrough (2–3 mins):
https://youtu.be/fbCA06cdUTU?si=bFhsVZDiOXQRWUcS
The app lets you explore street lights on a city map, filter by area and status, search maintenance logs, and view failure forecasts with cost impact — all with simulated data.
I’m sharing this mainly to:
-
Get feedback/improvements on the Streamlit UX
-
Learn how others approach geospatial apps in Streamlit
-
Spark ideas around new features, extensions, or alternative use cases, and learn from how others would approach it
If this sparks any thoughts, suggestions, or collaboration ideas, I’d love to hear them. Please feel free to PR, happy to look and merge.
CC: @dataprofessor @Jessica_Smith @Elsa_Mayer
Thanks!
Kamesh