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.
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 (WIP): View bridge locations on Google Maps
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