Natural Resource & Environmental  Management 250

Module 3 Project 1
Q1)    What geographic area are you studying?
    Houston, Texas

Q2)    What decision do you need to make?
    Decision support for deployment of law enforcement assets.

Q3)    What information would help you make the decision?
    Current location of all assets.
    Geocoded location of past types, dates, location of criminal activity.

Q4)    Who are the key stakeholders for this issue? (This step is important. You need to know the audience for your analysis to help decide how to present your results.)
    The management of law enforcement.

Q5)    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 2006 N/A Crime Records
blkgrp Line Tele Atlas North America, Inc., ESRI 2005 GCS_WGS 1984 Census data
Polygon Census Bureau, ESRI 2003 GCS_WGS 1984 Census data 
usa_sts Line Tele Atlas North America, Inc., ESRI 2003 Geographic Street Data

Q6)    Were there any unmatched addresses?
    One tie.

Q7)    How many of the addresses were unmatched?

Q8)    How many total crimes were there?
    9,448 (regardless of date).

Q9)    What percentage of the crimes were unmatched?

Q10)    How many records are not from August 2006?

Q11)    How many crime records are listed?

Q12)    Can multiple records (crime incidents) occur at the same location?  Give an example.
    Yes.   11th ave. 8-11-06 Robbery / 11th ave. 8-9-06 Burglary of Vehicle

Q13)    Can you suggest a reason for this?
    Crimes may happen more than once at a location. Also large residential complex's may         have the same address.

Q14)    How is the Offense_Time represented?
    24 hour clock.

Q15)    What are the offenses recorded?

Old Name New Name
Aggravated Assault Assault
Auto Theft Auto Theft
Burglary of a Motor Vehicle Burglary/Auto
Narcotic Drug Laws Drugs
Driving While Intoxicated DWI
Murder & Non negligent Manslaughter Murder
Forcible Rape Rape
Robbery Robbery

Q16)    Complete this table on your worksheet:
    Hint: Use the Sum_event field. Remember, there are 6,834 crimes.
Distance 1st Attempt Percentage 2nd Attempt Percentage 3rd Attempt Percentage
2 Miles 1085 15.88% 1143 16.73% 1027 15.03%
4 Miles 1792 15.88% 1889 16.73% 1707 15.03%
6 Miles 1528 22.36% 1673 24.48% 1295 18.95%
More than 6 Miles 2429 35.54% 2129 31.15% 2805 41.04%
Total 6834 89.65% 6834 89.08% 6834 10.05%

Q17)    What do these results tell the police department about the distribution of crime?
    Crime increased in the four mile zone please see map.

Q18)    Use the attribute table of pol_sta_crimes to complete this table:
    Remember, there are 6,834 crimes.
Q19)    What does this method tell the police department about the distribution of crime?
    Areas such as Clear Lake, Fondren, And Southeast may need more support. While     Kingwood has such a statistically low rate of crime it might be able to give up some of     its assets.

Q20)    Compare the two methods of analysis.

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

Q22)    How many burglaries have been reported?

Q23)    What is the spatial distribution of burglaries in Houston?


Drug Crimes


Aggravated Assault Crimes


Q26)    What is the total number of crimes?


Q27)    Calculate crime for various time periods by completing this table:

Q28)    What time of day is crime the lowest? 
    Morning. (see above)

Q29)    What time of day is crime the highest? 
    Evening. (see above)

Q30)    How many schools do not have any crime within the 1,000-foot zone?

Q31)    What school has the highest number of crimes?

Q32)    Select that school and see which crimes were committed.
Name of Crime Number of Crimes
Aggravated Assault 4
Auto Theft 14
Burglary 14
Burglary of a Motor Vehicle 3
Narcotic Drug Laws 5
Robbery 13
Total 53

Q33)    Is the drug-free zone effective? 
    There were 241 various crimes out of 6,834. That is 3.53% of the crime in Houston.

Q34)    How could you design a study to find out what is going on just outside the zone?
Investigate what are the unanswered questions outside the zone. Also what are the particular issues that spatial information analysis can reveal. Once this is discovered then a design can be made and data procured.

Back to Directory