Help building a database with street segments; weekly crime/police data

Discussion created by mjdcm3 on Jan 17, 2013
Latest reply on Feb 5, 2013 by pmcatnip
I REALLY need help trying to figure out how to build this dataset! I'm tasked with constructing a database containing three core elements:

1) crime data for a mid-sized city from 2012
2) police dispatch data from 2012
3) census data from the 2010 decenniel census

My advisor wants each row (we'll do data analysis in Stata) to correspond to a "segement-week".

Row 1 = Segment 1, Week1
Row 2 = Segment 2, Week2
Row 9288 = Segment 258, Week36

I'm struggling with finding the quickest and easiest way to accomplish this task. I pull the data in Excel '.CSV' format and Geocode it in ArcMap10.1. The only thing I have come up with is building a giant model to put each segment-week in a new feature class, then merging all 9,000+ together into the database.

Can anyone help me wrap my head around this? Can it be done without a team of programmers with unlimited time and resources? I.e., can a graduate research assistant do it in a couple of days? :confused: