CJ636: Computer/Technology Applications in Criminal Justice
Below are links to the data that will be used in this class. Each of these data sets covers the arrests for the sale or possession of an illegal substance from 2009 through 2011. While coving the same time period, each data set will produce different results. The uniqueness of each data set is a kind of digital signature that I can track across assignments. Each of you have been assigned a specific data set so be sure to download and use the correct one when submitting your classwork.
These data have been generated for the purposes of this course and do not reflect actual crimes.
|
|
||||
|
|
ID: A
unique identification number (integer)
|
OffType: Offense
type P = Possession, S = Sale or intent to sell.
|
Longitude: The
decimal conversion of the Longitude of the arrest location is represented on
the X axis. The numbers are negative signifying that we are West of the Prime Meridian. High numbers to the right,
lower to the left.
|
Latitude:
The decimal conversion of Latitude of the arrest location is represented on
the Y axis. Numbers are positive, high
numbers represent North and low numbers South.
|
Female: While most are able to figure this
out on their own, the value of 0 means “no,” indicating male and a value of 1
indicates female.
|
Race/Eth: Race or Ethnicity codes where 1 =
Black, 2 = White, and 3 = Hispanic.
(Apologies to the “Others” these are excluded for simplicity and are a
very small number in Huntsville.)
|
DOB: Date of birth.
|
ArrDate: Date of arrest (or maybe date
the person became a pirate).
|
All active project demonstrations are avilable for download. They are in zipped format and organized by project. Note the size of the zip files and prepare for a lengthy download time. Once you have downloaded a project, you will need to unzip it. By hovering your mouse over a link in the electronic syllabus (Adobe Acrobat document), you will see the address of the file that the link would call. Note the name of the linked folder and file and locate these in the unziped demo folder. Drill down to the folder containing the media files and double-click on the html file. A window will open and a Flash video will load and play shortly thereafter.
|
Project |
Title |
1
|
Acquiring Data (28.3 meg)
|
2
|
Data Crunching with Pivot Tables (149.2 meg)
|
3
|
Maping Incidents (245.1 meg)
|
4
|
Maping Densities (179.6 meg)
|
5
|
Creating Performance Dashboards (112.1 meg)
|
6
|
Policy Analysis (157.6 meg)
|