PigBoy

Okay, as the Madison resident, I guess I have to ask: what do you mean?

Hey, whaddayaknow, one of the UW libraries has them! I'll have to check them out. I thought I had searched before and not found them... guess I was wrong. University libraries rule! Columbusite, as little use as the books have apparently seen at the Columbus library, I'll bet they've seen even less usage at the Wisconsin Historical Society library. :wink: I'll probably still want to buy them, though, so thanks for that tip, ink. I thought of buying elsewhere online but didn't notice a cheaper price than Amazon.

In case anyone is too lazy to follow the link to the article and/or register at the DDN site, I though the image accompanying that article might be of interest. By the way, check out the street names they've got on there. Walnut, Chestnut, Plum, etc... so original. (Glengarry is actually an existing street coming across from Kettering, not one of their invented names.) One of these days the DDN is going to catch on to this hotlinking and screw up my posting of their images...

I want to buy those books, but I've been waiting until Amazon stops saying there's only one left of the urban one, because I get the feeling that if I ordered it they'd tell me it's out of stock, and waiting for it after I'd placed the order would just make me more impatient. So instead I'll wait in the way that allows me to be patient.

Good question. I'd better figure it out by Friday, after which the cost of registration goes up. I'm new to this world of conferences and such, and at the moment I'm not sure what to take away from something like the AAG meeting, but then it's probably a good idea to go, especially when it's so close. I'll have to check back in later.

Great photos! Those under-viaduct shots really contribute to that gritty feeling.

Murders (red) and rapes (blue) citywide, except for a few rapes way out in Sayler Park (if I've got that neighborhood name correct). These are city of Cincinnati stats, remember, so there are holes for St. Bernard and Norwood (although there seems to be one rape recorded in St. Bernard, which could possibly be an error in the geocoding).

Moving beyond OTR now, I'll post some crime maps in this thread. These are from the 2005 police reports, in case anyone hasn't been following the OTR thread. First, one of the areas requested by RiverViewer- Walnut Hills and Evanston, and whatever else is near there. There are a lot of streets on these maps, so I wasn't sure of the good ones to label. Sorry if it's still confusing. Murders (red) and rapes (blue) Felonious assault

^ I can post more maps of other hoods later today. I'll put them in the "Cincy's crime problem" thread, since this one's about OTR. I don't have Norwood, though, because they're just city of Cincinnati stats.

Columbus, Cleveland? Find me some crime stats and I'd love to. :wink: Cincinnati has that nice Excel file on the police department web page.

^ I think identifying where a victim (or any other subject of a news story) is from is a pretty standard thing to do.

Any other crimes I should map? Misuse of credit card? Telephone harassment? This is good stuff! Actually there are some others that would be interesting to see, such as vehicle theft. Speaking of east to west, it just occurred to me that these maps have a big hole where City West is being built, so anything going on there isn't going to show up (because there are no street lines on which to place the addresses). But maybe nobody cares about that West End stuff in this thread anyway.

Robberies Vine Street stands out again, but notice also how it all extends well into the CBD.

Address in OTR with the most assaults: 1700 Vine, with 7 of them.

12th Street seems pretty well defined by these points, too, although it's not as strong as Vine.

Sheesh. Don't you have school that you should be attending rather than running off to Pennsylvania? But at least you bring back some great photos. Always great photos!

Assaults... The map below shows what were called "felonious assault" (plus a couple of apparently related crimes). I'm not up on my criminal terms, but I believe in general that's an assault with a deadly weapon, as opposed to just plain "assault," which I think can be just a threat and of which there are a ton (not shown). So I think this would often include muggings. In this map, although a few hot spots stand out, it's almost easier to remark on the areas that don't have a lot. Oh, and I've added a couple labels. :wink: By the way, the street lines are likely to include things you don't normally consider streets or that so far as I can tell sometimes don't even exist, so keep that in mind if you're trying to figure out which street is which. One thing to bear in mind with these maps is that each point is necessarily right on the street even if the crime actually occurred somewhere inside the block. The points are placed on the lines according to their address. Another caveat: as I think I mentioned before somewhere, 1500-1600 data points (of nearly 44,000) were not successfully placed on the map. So some crimes may be missing, and if a murder is missing, that might have an impact on what we see as the pattern.

I don't think I'll get around to retrieving my "nice" maps today, so screw it... here's a screen capture for those who don't want to bother downloading all that stuff I linked to earlier. I can post more showing different things if anyone has requests. Here's OTR (and nearby areas) with the biggies- murder (red) and rape (blue). I had some things in mind to make a clearer, less crude map, but I can't do it here at home without ArcMap. There are also other variables that can be looked at. For example, the records make note of where the crime was- street, parking lot, yard, bar, residence, etc. But that, too, is difficult to get at without ArcMap.

Celina's looks interesting. It almost looks like a firehouse with a tower. Here's a wide shot of Dayton's, just to see the whole thing.

Nice! Looks like lots of good stuff in that hood.

As suggested by mrnyc in the courthouses thread, let's post photos of city halls in Ohio and marvel at their architecture. Either that or look away in horror. I'll start with the three I seem to have any pictures of. Dayton Delaware Xenia (well, the doorway...)

^ Well, not traffic violations, but I did just mean that a lot of the stuff is not the violent crime that people tend to worry about most. (Although I don't want to deny that there is still a lot of violent crime.) It's about the power of maps. I was just imagining that as a map from some city-hating group saying: "Look, there are nearly 44,000 crimes a year! You can't even walk down the street!" Or for a better evil map, they could use little symbols of handguns instead of just dots, and maybe people would flee Cincinnati for their lives. I suppose this would be better suited to the general Cincy crime thread...

I keep editing the above post, but I'll just put this in a new one. Since you guys are probably interested in looking at the data yourselves, I thought I'd upload my files so you can get them. You can find them all here: http://mywebspace.wisc.edu/awoodruff/cincycrimemap I think if you click on the "Launch WFS WebUI" link there you can get to a checklist and then download everything at once as a zip file. The "all crimes" shapefile has the points for every incident like what I showed above. (Actually, the thing was unable to match about 4% of the records to addresses on the map, but I assume that's not too big a deal at least in terms of seeing patterns.) The others--murders, rapes, robberies, and felonious assaults--are just subsets that I separated out, but "all crimes" still contains those data too. By the way, I was going by the code numbers for the type of crime, so there is some fuzziness, such as felonious assaults including "ethnic intimidation," but I didn't notice that until after they were all done. The tgr39061lkA stuff is Hamilton County streets. If you don't have something, download a GIS viewer like ArcExplorer and then add those shapefiles as layers to have a look. (If you get ArcExplorer and haven't used something like it before, basically all you need to know for this is to click the button with the plus sign, and you should be able to figure it out well enough from there.) I'm posting this while still uploading stuff, so if you read this and try to get there within the next few minutes it probably won't work yet, but it should be there soon. Enjoy. :-) :shoot:

Yes! Those will be the maps that I said I'd show in the next couple of days. Patience! As for the reason I don't have them at the moment, it's because what I originally had as point symbols got turned into crazy things like letters when I opened it on my own computer... some kind of font issue or something. I could get some screen captures now, but I wanted to use the nicer-looking maps I had made.

I mapped out the crime incidents from 2005... but there was a problem in trying to use some of the symbols I wanted when I transferred the stuff to my home computer. So I'll post images when next I go in to school. For now, a little description of what I saw: Although I mapped all police incident reports, I concentrated on what seem like more serious crimes- murder, rape, robbery, and felonious assault. The observations don't do much to answer the "most dangerous intersection" question, but here's a little summary of each type. Muder- about 5 were within a couple blocks of Washington Park. Rape- the most clustering seems to be in the vicinity of Vine and Race around 15th Street Robbery- all over the place (especially along Vine Street), and a little hard to identify hot spots, but a couple that maybe stand out are Vine between Liberty and McMicken, and Main between 12th and Woodward St. Felonious assault- Vine and McMicken, Vine near 14th and 15th (these are also all over the place) By the way, look what you can do with maps. Title- "Cincinnati is infested with crime! 42,000 of the 43,722 crimes reported by police in 2005." :wink: (I assume you all can figure out why that's an unfair map.)