Live data from Hacker News

San Francisco's Drug Geography

lmart999.github.io

11–20 of 22 posts

Re: San Francisco's Drug Geography

#15
I am impressed by how quickly the notebook goes from raw data to interesting patterns. Nice.

If I wanted to be picky about statistics (I generally do), I'd note:

1. Equating enforcement-related statistics with usage-related statistics is a dangerous thing to do. For example:

a. The rate of non-CRACK incidents in TENDERLOIN is probably low (disproportionate with actual use) due to the focus limited police resources put on crack.

b. I would bet that the high rate of WEED incidents in INGLESIDE / BAYVIEW vs, say, MISSION, is due to police using weed enforcement as a weapon against gangs (and minorities). I mean, people smoke a lot of weed in the Mission.

2. Putting "AMPHETAMINE"-related crimes under "METH" is inaccurate, as is putting "OPIUM"/"OPIATE"-related crimes under "HALLUCINOGENIC".

Re: San Francisco's Drug Geography

#17

Are there any resources on how to properly format raw data t make it most useful for display on a map? I'm hoping to do a crime map for my city and haven't quite found a good place to start.

Look into d3.js if you want it in a browser, there are a lot of examples. You'll have to re-format the data probably which might be annoying on a large data set, but I think there are tools out there.

Re: San Francisco's Drug Geography

#18
post #2

http://lmart999.github.io/assets/drug_agg.png Looking at this chart and being a bit assumptive, is it safe to say crack use has declined and meth has increased? Maybe meth isn't really a new epidemic with a new user group, crack users just transferred to meth. Basically, those looking for cheap escapist drugs targeted at the very poor have moved onto a new product. I'm curious which one is worse for society and the u…

Crack is a drug popular among blacks. Blacks leave, so does crack.

Re: San Francisco's Drug Geography

#20

Are there any resources on how to properly format raw data t make it most useful for display on a map? I'm hoping to do a crime map for my city and haven't quite found a good place to start.

Look into d3.js if you want it in a browser, there are a lot of examples. You'll have to re-format the data probably which might be annoying on a large data set, but I think there are tools out there.

I've been playing around with cartodb but am more looking for how to first format the datasets to then display them in a meaningful way
Post reply on HN