Bridge Database App
About
This is a demo application that implements a natural language interface on top of a database of bridges in New York State Region 8 (Lower Hudson).
It uses a fine-tuned Google T5-Small model (60M parameters) to parse plain English queries into REST API endpoints.
The model was trained on ~700 synthetic examples and is lightweight enough to run offline without cloud dependencies.
The source can be found here: https://github.com/bya0845/bridge-app
To get started, use
AI Search
to query the database in natural language,
Bridge Lookup
to explore the database via traditional filters, or click on
View Statistics
to get bridge count and span stats by county.
The database includes bridges from the following counties:
- Columbia
- Dutchess
- Orange
- Putnam
- Rockland
- Ulster
- Westchester
Other App Features
- SQL Search: Find bridges by ID, county, features carried/crossed, and span count
- Map Integration: View bridge locations in browser with OpenStreeMaps or via Google Maps link
AI Search
Log Bridge Inspection
Drag & drop photos here or click to browse
Images will be uploaded locally
View Inspection History
Manage Inspection Logs
View Inspection Logs by Bridge
Delete Inspections by Bridge
This will permanently delete all inspection records for the specified bridge.
Delete All Inspections