search

GeoDaCenter / data-and-lab

For CSDS: sample data, data cleaning, labs and miscellaneous
https://geodacenter.github.io/data-and-lab/
0 stars 2 forks source link

Add population field to SanFran crime data #20

Open jkoschinsky opened 7 years ago

jkoschinsky commented 7 years ago

Please spatially join population data from 2010 Census block-level data, so we have a denominator for the crime data:

https://s3.amazonaws.com/geoda/data/SFCrime_July_Dec2012.zip

and upload to the Box account afterwards.

YidanJ-Wu commented 7 years ago

I got the 2010 census from the American FactFinder website, but their numbering system for block groups seems to be different from the crime dataset. Is there a way to convert the numbers so that the two tables can be joined?

FactFinder data: image

provided crime data: image

jkoschinsky commented 7 years ago

the plots are police districts: It'll make most sense to go back to the point data (attached) and spatially join them the Census areas. Thx!

On 28 March 2017 at 23:04, YidanJ-Wu notifications@github.com wrote:

I got the 2010 census from the American FactFinder website, but their numbering system for block groups seems to be different from the crime dataset. Is there a way to convert the numbers so that the two tables can be joined?

FactFinder data: [image: image] https://cloud.githubusercontent.com/assets/22801047/24438107/adf20544-140a-11e7-9e1a-acc71b064159.png

provided crime data: [image: image] https://cloud.githubusercontent.com/assets/22801047/24438126/c8619aac-140a-11e7-8902-122fb1be65d2.png

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/GeoDaCenter/data-and-lab/issues/20#issuecomment-289976073, or mute the thread https://github.com/notifications/unsubscribe-auth/ANC8fz4fOMro7Y6nEBYLrpxP6H_lbrLyks5rqdhKgaJpZM4MZ03w .

YidanJ-Wu commented 7 years ago

I think I got it. Could you check the file I uploaded to Box ("San Francisco Crime Data" folder) to see if it was done correctly?

jkoschinsky commented 7 years ago

Will do, thx

On Mar 31, 2017 11:21 PM, "YidanJ-Wu" notifications@github.com wrote:

I think I got it. Could you check the file I uploaded to Box ("San Francisco Crime Data" folder) to see if it was done correctly?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/GeoDaCenter/data-and-lab/issues/20#issuecomment-290893772, or mute the thread https://github.com/notifications/unsubscribe-auth/ANC8f4Uger-CIm1Sz-vtdCiX5kc9j3Mxks5rrdC5gaJpZM4MZ03w .