Never miss the bus with Azure Function, IFTTT, AzureSQL and GeoSpatial data
summary
Polls the King County GTFS real-time feed every 15 seconds with an Azure Function, parses vehicle positions to latitude/longitude, and stores them as geography points in Azure SQL. Uses STContains against a user-drawn polygon geofence, keeps an active-geofence temporal table and a geofence log, and calls an IFTTT webhook when a vehicle enters or exits. Client plots the last 50 points; author reports ~99% chance to catch the bus and publishes code on GitHub.
AI-written summary · about
chapters (10)
- 0:00Introduction and overview
- 2:28Real-world challenge and solution
- 6:42Geospatial data complexity
- 9:33Setting up the database
- 17:39Creating geofence with geography
- 22:58Azure Function setup and code
- 30:01Running the solution live
- 34:12Checking geofence with ST_Contains
- 44:46Sending notifications with IFTTT
- 46:50Deployment and conclusion
related talks
46mBuild serverless, full stack applications in Azure with Azure SQL
28mReal Time GeoJSON APIs
47mWorking with data using Azure Functions
28m"Where, When, Why, and How: Directi
15mThe turf wars on data - can be a matter of life and death
57mEasy Data Processing With Azure Fun
23mHandling geo located data in real time using Python
21mPoint-in-polygon lookups with vector tiles: quick, effective, and no server needed!