Add population field to SanFran crime data

[jkoschinsky]

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]

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:

provided crime data:

[jkoschinsky]

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 ***@***.***> 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 <#20 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ANC8fz4fOMro7Y6nEBYLrpxP6H_lbrLyks5rqdhKgaJpZM4MZ03w> .

[YidanJ-Wu]

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]

Will do, thx

…

On Mar 31, 2017 11:21 PM, "YidanJ-Wu" ***@***.***> 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 <#20 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ANC8f4Uger-CIm1Sz-vtdCiX5kc9j3Mxks5rrdC5gaJpZM4MZ03w> .