New Crime Data

When we last requested crime data from SANDAG, 3 years ago, it took four months of negotiation to get them to admit they could produce it, and two more months to get the price down to a reasonable amount. Last week when I requested an update, I got one clarification...

Street Sweeping and GPS Data

Last week the Library worked with Wendy Fry at NBC7 to analyze GPS records of street sweeping and parking violations. We haven’t got the data online yet — it’s about 3GB, 11M GPS records — but let us know if you are interested in accessing it....

SANDAG / ARJIS Crime File Archive

For the last 5 months, SANDAG has been publishing their crime incident data to the web. The file they publish only stores the last 180 days, and it is a bit hard to find, so we’re archiving the files to our data repository .

Drugs and Alcohol in Downtown and East Villiage

For the last few months, a team of geography students at SDSU have been working with the crime data provided by the Library, producing analyses and visualizations of the data. Elias Issa has been looking at Drugs and Alcohol violations in Downtown San Diego and East...

SANDAG Is Now Publishing Crime Data Weekly

SANDAG, through its public safety division ARJIS, is now publishing crime data to the web. This is a major advance in accessibility, since previously crime incidents were only available through a Public Records Act request, and usually involved a fee. The download...

Visualizing Traffic Accidents

We recently converted the SWITRS database of traffic collisions in California, extracting the records for San Diego County and creating a basic visualization in Tableau Public. Tableau Public is a fantastic data analysis tool, although it takes a bit of training to do...