SQL0109
AREA_INC_COUNT.SQL
November 20, 2007
TUCSON POLICE DEPARTMENT
Records Management System
Crime Counts, SPECIFIC AREA
PARAMETERS:
Dates: 11/13/2007 - 11/19/2007
Times: 0000 - 2359 HRS
Crimes: ALL TYPES
South Range: 0400 - 1100
East Range: 3900 - 4200
For: ANNE WATSON
Comment: SAN GABRIEL WEEKLY STATS
Major Type Subtype Count
---------------------------------------- ---------------------- ----------
05-BURGLARY 0501-BURGLARY/FORCE 1
**************************************** ----------
sum 1
06-LARCENY 0607-LARCENY/RESIDENCE 1
0610-LARCENY/OTHER 1
**************************************** ----------
sum 2
17-SEX OFFENSES 1706-SEX OFS/OTHER 1
**************************************** ----------
sum 1
18-NARCOTIC DRUG LAWS 1801-NARC DRUG/POSS 1
**************************************** ----------
sum 1
27-ARREST FOR OTHER JURISDICTION 2702-OTHR JURS/MSD CRM 1
**************************************** ----------
sum 1
32-PROP DAMAGE MV TRAFFIC ACCIDENT 3212-PROP DMG/AUTO H&R 1
**************************************** ----------
sum 1
50-FIRE 5015-FIRE/OTHR-ORG UNK 1
**************************************** ----------
sum 1
51-LOST 5101-LOST/PERSON 1
**************************************** ----------
sum 1
52-FOUND 5203-FOUND/PROPERTY 1
**************************************** ----------
sum 1
53-PUBLIC ASSIST 5304-PBLC ASST-OTHER 1
**************************************** ----------
sum 1
54-CIVIL MATTER 5401-CIVL/CRT ORDR ENF 1
5403-CIVL/OTHER 1
**************************************** ----------
sum 2
56-SUSPICIOUS ACTIVITY 5603-SUSP ACT/OTHER 1
5604-SUSP ACT/NO LOC 1
**************************************** ----------
sum 2
61-MISCELLANEOUS 6101-MISC/OFFICER 1
**************************************** ----------
sum 1
----------
Major Type Subtype Count
---------------------------------------- ---------------------- ----------
sum 16