Broadening Access to Transportation Safety Data with Generative AI: A Schema-Grounded Framework for Spatial Natural Language Queries

In three linesA framework uses an LLM to translate natural language queries into deterministic spatial operations against a PostGIS database. Tested on Massachusetts transportation safety data (crash records, roadway attributes, schools, bus stops), the system validates 29% of erroneous queries through a rule-based layer, preserving reproducibility while democratizing data access.

Summary generated by Claude — human-verified