San Diego’s CityIQ system consists of about 4,400 smart street lamps, which use a variety of sensors to track parking, pedestrians, traffic and a variety of environmental conditions. This analysis reveals pedestrian paterns using time-oriented heatmaps.
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
A California Health Care Foundation sponsors projects to make health data more available.
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.
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
The Challenge The San Diego Housing Commission reviews data reports from the Home Mortgage Disclosure Act to ensure that San Diego area lenders are following the law. When they wanted to reduce costs of processing the data into summary reports, they turned to Civic Knowledge for help. The Solution Because we had already loaded HMDA data … Read more
