Data Wrangling

Analyze Street Sweeping GPS Data

by

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

HMDA Summary Reports

by

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

Linking Student Analysts and Nonprofits

by

The Challenge When recently graduated students told us that it was difficult to land data analysis jobs without experience, we realized there was an opportunity to simultaneously give students experience and aid local nonprofits with answering data questions. The Solution In spring of 2015, operating as the San Diego Regional Data Library, we ran a data contest with … Read more

Health Reporter

by

The Challenge While more data is available than ever before, it is still difficult to use, and journalists have a particularly difficult time finding data to support stories within their time and cost constraints. The California Health Care Foundation asked us for ideas about making health data more widely available and useful to journalists. The Solution The … Read more