Tracking City Department Performance

Andy Keatts, a reporter for Voice of San Diego, had been working for months with the City’s Development Services Department to release hundreds of thousands of development permit records, but working with XML data  was beyond a reporter’s typical skill set. Civic Knowledge extracted the records from the City’s API and converted the XML records … Read more

Plotting San Diego Streetlights

 The Challenge After writing a series of stories about San Diego city infrastructure, Voice of San Diego reporter Liam Dillon turned his attention to street lamps. Although the city published GIS data for the locations of street lamps, Liam wanted to understand how the number of lamps varied by community. The Solution Working through our non profit project, … Read more

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 … Read more