Natural Resource & Environmental Management 250

Module 3 Project 2

Q1) Investigate the metadata and complete this table:

Layer	Data Type	Publication Information: Who Created the Data?	Time Period Data is Relevant	Spatial Horizontal Coordinate System	Attribut Values
aug06.xls	Excel worksheet	http://www.houstontx.gov/police/stats.htm	2006	N/A	Crime Records
blkgrp	Line	Tele Atlas North America, Inc., ESRI	2005	GCS_WGS 1984	Census data
houston	Polygon	Census Bureau, ESRI	2003	GCS_WGS 1984	Census data
usa_sts	Line	Tele Atlas North America, Inc., ESRI	2003	Geographic	Street Data

Q2) Were all the police stations matched when they were geocoded?
Yes

Q3) How many crimes have the day of the week recorded? Not recorded?

Day of Week	Number of Crimes	Percentage
Mon	448	13.5%
Tue	539	16.24%
Wed	524	15.79%
Thu	459	13.83%
Fri	422	12.72%
Sat	477	14.38%
Sun	449	13.53%
Total Correctly Recorded	3,318	100%
NOT Recorded	166	5%
Total of All Recorded	3,484

Q4) What percent did not record the day of the week?
See above.

Q5) Looking at the graph of crime by days of the week, what day(s) would require more of a police presence?

Q6) How many total crimes are there?

Q7) Complete this table:

Distance in Mile	Number of Crimes	Percent
1	2074	59.6%
2	1086	31.2%
3	257	7.4%
More than 3 Miles	67	1.9%

Q8) What does this method tell the police department about the distribution of crime?
Using the days of the week is a very poor indicator of crime.

Q9) Complete this table:

Police Station	Number of Crimes	Percent
‘F’ Street Community Center	734	19.84%
Auld Recreation Center	258	6.97%
Bess Dobson Walt Library	65	1.76%
Bryan/LGH	553	14.95%
Headquarters	649	17.55%
Highlands	40	1.08%
LMEF Inc.	172	4.65%
LPD Center Team Station	416	11.25%
Northeast Team Station	236	6.38%
Team Station	414	11.19%
Union College	162	4.38%

Q12) Write a spatial analysis of crimes and police stations.

Q13) What are the code numbers for assault?
4111, 4112, 4121, 4122, 4131, 4132, 4141, 4142, 4151, 4152, 4211,
4212, 4212, 4221, 4222, 4231, 4232, 4241, 4242, 4251, 4252

Q14) What are the code numbers for burglary?
5111, 5112, 5113, 5121, 5122, 5123, 5131, 5132, 5133,
5211, 5212, 5213, 5221, 5222, 5223, 5231, 5232, 5233

Q15) What are the code numbers for shoplifting?
6201, 6202, 6203, 6204

Q16) How many assaults occurred? 349

Q17)How many burglaries?

Q18) How many instances of shoplifting? 159

Q19) Describe the spatial distribution of assault in Lincoln.

Q20) Describe the spatial distribution of burglary in Lincoln.

Q21 Describe the spatial distribution of shoplifting in Lincoln.

Q22) Complete this table:

Time	Name	24 Hour Clock	Crimes	Percentage
midnight–6 a.m.	Night	00-06	488	14.07%
6 a.m.–noon	Morning	06-12	961	27.07%
noon–6 p.m.	Afternoon	12-18	1127	32.49%
6 p.m.–midnight	Evening	18-24	893	25.74%

Q23) What is the total number of crimes with times?
3482 Because two entries have time of 8019 and 8022.

Q24) What time of day is crime the lowest?
Night (see chart above)

Q25) What time of day is crime the highest?
Afternoon (see chart above)

Back to Directory