Dependable Erection

Monday, November 05, 2007

Fun new toys

The N&O's interactive crime tracking map.

So far it's only functional for Raleigh and Cary, which, if it isn't paradoxical, is surely ironic. And their definition of "Other" crimes (besides Assault, burglary, drugs, murder, rape, robbery, sex Crimes, and vandalism, which i assume are police definitions and not something made up by the N&O) is broad enough to include this:
2007-11-01 16:13 7807 S COLORADO DR P07133354 MISC/DECEASED PERSON OTHER 2206 RALEIGH

Miscellaneous/Deceased person = Other (type of crime.)

Other "Other" crimes include suicide attempts, missing persons, mental commitment, and the ubiquitous "no offense committed."

Have fun.



  • Having done this kind of thing, figuring out how to integrate data from multiple departments can be a serious bear. I know lots of departments in Cary follow Raleigh's lead on how they implement government services, so it's possible they're using the same incident tracking system. But having seen data from both departments, there's a lot of differences between Raleigh and Durham in how the data is collected.

    This isn't a matter of quality or anything like that, it's more a matter of format, categories, information provided. My guess is they got dumps of data from Raleigh and Cary, then wrote an application to appropriately draw on that data. (It's how I would have done it.) Now, to expand that to Durham, they then have to go get a dump from Durham, which likely has completely different fields, tables, codes, and is grouped in different ways. You either have to write a second app dedicated to the Durham data, or write a big translator, which probably puts several round pegs in square holes to make it work.

    And aside from that, Durham's already got a high quality crime mapper.

    By Blogger Michael Bacon, at 11:29 AM  

  • And aside from that, Durham's already got a high quality crime mapper.

    how about a link for that? having two will be much more fun than just one.

    By Blogger Barry Ragin, at 11:35 AM  

  • I visit a blog called "Dependable Erection" and an entry called "Fun new toys"...I'm so disappointed...

    By Blogger beau-jan, at 5:36 PM  

  • Oh, do come back. You've caught us on a slow day.

    By Blogger Barry Ragin, at 5:50 PM  

  • I've got that Durham crime map bookmarked. I checked it obsessively before I moved here last year. Now, I'd rather not know.

    Durham Crime Mapper

    Fun party game, to compare your personal 500-foot-radius crime map to that of your friends...

    By Blogger toastie, at 9:18 PM  

  • And somehow I missed when I posted last (did you edit this thing, or was I asleep?), probably their definition of "Other" crimes is those categorized as "Type II" rather than "Type I" for Uniform Crime Reports, which go to the FBI and get reported nationally. Type I can be broken down into violent and property crimes. Violent crimes are homicide, assault (sexual, aggravated, and simple), and robbery. Property crimes, if I recall correctly, are burglary, larceny, arson, and vandalism. Everything else gets lumped into Type II, like fraud, drug possession, and all that.

    If no foul play was suspected about the "deceased corpse found," it goes into type II.

    By Blogger Michael Bacon, at 12:10 PM  

Post a Comment

<< Home