Washington DC Crime Lab

This week we worked on statistics on crime in Washington, DC.  We created 3 maps and a bar graph with the following objectives:
- Create maps showing crime distribution in  Washington, DC
- Create graphs to demonstrate crime distribution
- Use Kernel Density to display crime clusters
- Geocode addresses in ArcMap to map police stations
- Create multiple dataframe maps in ArcMap to show various crime distributions across DC
- Use Field Calculator to calculate attribute table values
- Utilize Swipe Tool to allow crime cluster distributions to be displayed over census block data.

Process Summary Details

Step 2:

1)      Set the environments and predefined Projected Coordinate Systems to NAD 1983_Zone_18N, the current workspace as WashingtonDC\data and scratch workspace as \results\DC_results.gdb.

2)      Set the cell size to 73 and limited the analysis by setting the mask to ‘WashingtonDC’

3)      Added layers: ‘police_stations.csv’, WashingtonDC.shp and DC-streets

4)      Selected the geocode address ‘North America Geocode Service, saved the output layer as “police_stations” as a geodatabase feature class in the DC_results.gdb folder.

5)      Added excel file ‘DC_Jan2011.csv’ and added the coordinate system GCS_North_American_1983

6)      The scale is 1:160,978.

7)      There is no Object_ID Field

8)      Added the new table “Crime”

9)      Symbolized the police stations and made them much larger.

10)  Symbolized the DC_Streets layer.

11)  Summarized the ‘Offense’ data and saved as a dBASE table and changed the labels in the attribute table.

12)  Created graph

13)  I worked on the graph to make it look right because it was totally messed up, fields on top of eachother, font all out of order, etc

14)  Saved as Crime1.mxd and exported as jpg.

STEP 3: Produce a Map of Police Stations with Crime Proximity

1)      Set the environments and predefined Projected Coordinate Systems to NAD 1983_Zone_18N, the current workspace as WashingtonDC\data and scratch workspace as \results\DC_results.gdb.

2)      Set the cell size to 73 and limited the analysis by setting the mask to ‘WashingtonDC’

3)      Added the WashingtonDC boundary, police_stations, DCstreets and crime layers.

4)      Created a Multiple Ring Buffer around the police stations at 0.5, 1 and 2 miles.

5)      Performed a spatial join between buffer and crime.

6)      Added an Event field in Crime attribute table with a value as 1.

7)      Joined the Buffer and Crime layers

8)      Had an issue with the attribute table not being populated – many of the columns were set as “null”.  I deleted the laters and tried again with the same result.

9)      Used “joins and relates” tool to join the police_stations layer with the crime layer with an output name “pol_sta_crimes” – This did not work either.

10) 

11)  I could not get any further. I asked on the board for help and email Tanya.

STEP 4: Produce Density Maps of Burglaries, Homicide, and Sex Abuse Crimes

1)      Set the environments and predefined Projected Coordinate Systems to NAD 1983_Zone_18N, the current workspace as WashingtonDC\data and scratch workspace as \results\DC_results.gdb.

2)      Set the cell size to 73 and limited the analysis by setting the mask to ‘WashingtonDC’

3)      Added WashingtonDC and Crime layers.

4)      Ran a Selection Query for burglaries and crime.

5)      Used the Kernel Density on the crime layer and the population field Event. The Kernel Density actually seemed to work.

6)      Everything seems set as it should be but the results are not coming out right…this is he screen I am getting when I try to classify the crime density:

7)     

I don’t know what to do from here. Once again I am at the end of the assignment, I have worked nearly every hour available outside of work and I am not done because I keep having issue after issue.