Add various other filters

[evz]

Administrative geographies - beats, wards, school attendance, police districts Where the crime occurred - street, abandoned buildings, or vacant lots "indoor versus outdoor"

[derekeder]

Let's add the following filters. Once we have them implemented, we can play around with putting them in to an accordion for 'advanced search'

Location Description

Come up with a set of groupings (inside, street, vacant property, etc) and display in a multi-select with Chosen

Crime type

Same as above - come up with a set of groupings based on what we already have (violent, property, quality of life) and list all types under each.

[evz]

We might want to weed through these a bit this is a:

SELECT count(location_description) AS loc_count, location_description 
    FROM dat_chicago_crimes_all 
    GROUP BY location_description 
    ORDER BY loc_count DESC;

Count	Location Description
1473808	STREET
923045	RESIDENCE
543269	SIDEWALK
528677	APARTMENT
202372	OTHER
155665	PARKING LOT/GARAGE(NON.RESID.)
124164	ALLEY
122657	SCHOOL, PUBLIC, BUILDING
109357	RESIDENCE-GARAGE
95111	RESIDENCE PORCH/HALLWAY
89214	SMALL RETAIL STORE
84737	VEHICLE NON-COMMERCIAL
76719	RESTAURANT
71715	GROCERY FOOD STORE
62781	DEPARTMENT STORE
55956	GAS STATION
52222	CHA PARKING LOT/GROUNDS
43030	RESIDENTIAL YARD (FRONT/BACK)
41891	PARK PROPERTY
41802	COMMERCIAL / BUSINESS OFFICE
32342	CHA APARTMENT
32160	CTA PLATFORM
26718	BAR OR TAVERN
25235	DRUG STORE
24002	CHA HALLWAY/STAIRWELL/ELEVATOR
23616	SCHOOL, PUBLIC, GROUNDS
22516	BANK
21459	HOTEL/MOTEL
19238	TAVERN/LIQUOR STORE
19094	VACANT LOT/LAND
16827	CTA BUS
16773	CTA TRAIN
15970	DRIVEWAY - RESIDENTIAL
15703	AIRPORT/AIRCRAFT
15074	HOSPITAL BUILDING/GROUNDS
13168	POLICE FACILITY/VEH PARKING LOT
12087	CHURCH/SYNAGOGUE/PLACE OF WORSHIP
11332	GOVERNMENT BUILDING/PROPERTY
11254	CONSTRUCTION SITE
10659	SCHOOL PRIVATE BUILDING
9886	NURSING HOME/RETIREMENT HOME
8857	ABANDONED BUILDING
8675	CURRENCY EXCHANGE
8527	CTA GARAGE / OTHER PROPERTY
8134	CONVENIENCE STORE
7874	WAREHOUSE
6581	BARBERSHOP
6118	FACTORY/MANUFACTURING BUILDING
5757	MEDICAL/DENTAL OFFICE
5498	ATHLETIC CLUB
5232	ATM (AUTOMATIC TELLER MACHINE)
5191	TAXICAB
4757	COLLEGE/UNIVERSITY GROUNDS
4739	OTHER RAILROAD PROP / TRAIN DEPOT
4699	LIBRARY
4287	CLEANING STORE
4160	VEHICLE-COMMERCIAL
3611	SPORTS ARENA/STADIUM
3262	CTA BUS STOP
3167	"SCHOOL
2275	OTHER COMMERCIAL TRANSPORTATION
2187	CAR WASH
2067	AIRPORT TERMINAL UPPER LEVEL - SECURE AREA
2059	MOVIE HOUSE/THEATER
1948	DAY CARE CENTER
1416	APPLIANCE STORE
1129	COLLEGE/UNIVERSITY RESIDENCE HALL
947	DELIVERY TRUCK
892	COIN OPERATED MACHINE
826	AUTO
811	FIRE STATION
799	HIGHWAY/EXPRESSWAY
773	LAKEFRONT/WATERFRONT/RIVERBANK
679	AIRPORT TERMINAL LOWER LEVEL - NON-SECURE AREA
642	JAIL / LOCK-UP FACILITY
589	POOL ROOM
586	FEDERAL BUILDING
524	BOWLING ALLEY
499	ANIMAL HOSPITAL
492	BOAT/WATERCRAFT
393	CREDIT UNION
362	HOUSE
339	FOREST PRESERVE
327	AIRPORT EXTERIOR - NON-SECURE AREA
313	AIRPORT BUILDING NON-TERMINAL - NON-SECURE AREA
295	SAVINGS AND LOAN
288	AIRPORT TERMINAL UPPER LEVEL - NON-SECURE AREA
282	PAWN SHOP
278	AIRPORT PARKING LOT
272	AIRPORT TERMINAL LOWER LEVEL - SECURE AREA
270	CEMETARY
268	BRIDGE
234	AIRPORT VENDING ESTABLISHMENT
200	NEWSSTAND
195	PORCH
191	AIRCRAFT
186	AIRPORT BUILDING NON-TERMINAL - SECURE AREA
127	YARD
114	PARKING LOT
113	AIRPORT EXTERIOR - SECURE AREA
80	VACANT LOT
68	HALLWAY
57	RETAIL STORE
55	GANGWAY
40	GARAGE
39	AIRPORT TRANSPORTATION SYSTEM (ATS)
38	CHA GROUNDS
38	GAS STATION DRIVE/PROP.
36	AIRPORT TERMINAL MEZZANINE - NON-SECURE AREA
34	CHA HALLWAY
29	CHA PARKING LOT
28	BASEMENT
25	TAVERN
14	VESTIBULE
14	CLUB
14	HOTEL
13	STAIRWELL
12	RAILROAD PROPERTY
12	OFFICE
9	GARAGE/AUTO REPAIR
9	BARBER SHOP/BEAUTY SALON
8	DRIVEWAY
8	SCHOOL YARD
8	CHA STAIRWELL
7	DUMPSTER
7	TRUCK
6	CHA LOBBY
6	TAXI CAB
5	WOODED AREA
5	MOTEL
5	LIQUOR STORE
4	RIVER
4	CHURCH
3	CTA L PLATFORM
3	LAKE
3	HOSPITAL
3	CHA BREEZEWAY
3	CHA PLAY LOT
3	TRAILER
3	COACH HOUSE
2	CTA PROPERTY
2	CHURCH PROPERTY
2	NURSING HOME
2	FACTORY
2	LIVERY STAND OFFICE
2	PUBLIC HIGH SCHOOL
2	CHA ELEVATOR
2	COUNTY JAIL
2	SEWER
2	PRAIRIE
2	RIVER BANK
2	YMCA
1	FUNERAL PARLOR
1	BANQUET HALL
1	CTA L TRAIN
1	LOADING DOCK
1	PUBLIC GRAMMAR SCHOOL
1	LAUNDRY ROOM
1	ROOMING HOUSE
1	JUNK YARD/GARBAGE DUMP
1	LIVERY AUTO
1	TRUCKING TERMINAL

[evz]

Same goes for Primary Type (used a similar query):

Count	Primary Type
1110750	THEFT
995853	BATTERY
631091	CRIMINAL DAMAGE
621190	NARCOTICS
334547	OTHER OFFENSE
327051	ASSAULT
322513	BURGLARY
262511	MOTOR VEHICLE THEFT
203854	ROBBERY
173539	DECEPTIVE PRACTICE
160346	CRIMINAL TRESPASS
63201	PROSTITUTION
51269	WEAPONS VIOLATION
38164	PUBLIC PEACE VIOLATION
32875	OFFENSE INVOLVING CHILDREN
19825	SEX OFFENSE
19277	CRIM SEXUAL ASSAULT
13126	GAMBLING
12707	LIQUOR LAW VIOLATION
9003	ARSON
6524	HOMICIDE
6172	INTERFERE WITH PUBLIC OFFICER
5749	KIDNAPPING
3290	INTIMIDATION
3120	INTERFERENCE WITH PUBLIC OFFICER
2535	STALKING
439	OFFENSES INVOLVING CHILDREN
269	OBSCENITY
107	PUBLIC INDECENCY
93	OTHER NARCOTIC VIOLATION
23	RITUALISM
12	NON-CRIMINAL
6	OTHER OFFENSE
2	NON-CRIMINAL (SUBJECT SPECIFIED)
2	NON - CRIMINAL
1	DOMESTIC VIOLENCE

[derekeder]

For the location description, this is a lot of fields. We should come up with some sensible groupings. Making a new issue for that.

[evz]

Related c9eb664bdd40237ef0ecc72d45e4fb24ab274f31

[evz]

So I think the last couple things here are the school attendance boundaries and the wards. Wards are pretty simple since they are within the crime data. We'll need to discuss what the best approach to making queries using attendance boundaries.

[derekeder]

First pass is done on this. Let's open new filters as their own issues