Analyze Street Sweeping GPS Data

Project Description

When Wendy Fry, a reporter with NBC 7 San Diego, requested data for a story about street sweeping, the city sent her a dump from their dispatch system’s GPS logs, a dozen files with several million records. Civic Knowledge, working under its nonprofit San Diego Regional Data Library, processed the records to determine which streets had been swept. By merging the reduced data with records of traffic tickets, we determined where residents had been ticketed for parking on a street that was not swept, to support a series of NBC 7 stories and television segments.

( Photo: Screenshot of NBC 7 web story based on data provided by the San Diego Regional Data Library . )