datamade / crimearound.us

:police_car: A tool for browsing crime reports from the Chicago Police Department.
http://crimearound.us
MIT License
5 stars 3 forks source link

Create groupings for 'Location description' #8

Closed derekeder closed 10 years ago

derekeder commented 10 years ago
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

Related to #1

evz commented 10 years ago

Shared a Google doc with @derekeder and @fgregg where I'm starting to, however naively, group these things.

evz commented 10 years ago

...and here it is: https://docs.google.com/spreadsheet/ccc?key=0AuoM6JPZJ7xIdG9QdEs0YlhtMW5yZm41UENTZEdMNWc&usp=sharing

evz commented 10 years ago

@fgregg I've gone ahead and put preliminary groupings into that file above. I think the only thing that might not be clear is the distinction between "Business - Retail" and "Business - Office". The difference I am attempting to bring out there is the one between a place where the public engages with a business and a place where a business just does, well, business and there are typically only employees on premise. If you can think of a better way of describing that, I am all for it cause I think that kinda stinks.

@derekeder thought we might preliminarily share this with LISC (once we're good with it) to see if there is any feedback they might have.

fgregg commented 10 years ago

Looks like a good first cut. Let's wait before going back to Taryn with questions. Other issues are definitely going, to arise, and we should batch them up.

On Wed, Feb 5, 2014 at 4:32 PM, Eric van Zanten notifications@github.comwrote:

@fgregg https://github.com/fgregg I've gone ahead and put preliminary groupings into that file above. I think the only thing that might not be clear is the distinction between "Business - Retail" and "Business - Office". The difference I am attempting to bring out there is the one between a place where the public engages with a business and a place where a business just does, well, business and there are typically only employees on premise. If you can think of a better way of describing that, I am all for it cause I think that kinda stinks.

@derekeder https://github.com/derekeder thought we might preliminarily share this with LISC (once we're good with it) to see if there is any feedback they might have.

— Reply to this email directly or view it on GitHubhttps://github.com/datamade/crimearound.us/issues/8#issuecomment-34263877 .

773.888.2718 2231 N. Monticello Ave Chicago, IL 60647

derekeder commented 10 years ago

Closing for now until we get feedback.