stevevance
/ ALBANY_DIVERSEY_PEDESTRIAN.csv
Created
April 13, 2021 01:21
Pedestrian crashes on Diversey or Albany since September 2017
We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 49 columns, instead of 12. in line 1.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CRASH_RECORD_ID,RD_NO,CRASH_DATE_EST_I,CRASH_DATE,POSTED_SPEED_LIMIT,TRAFFIC_CONTROL_DEVICE,DEVICE_CONDITION,WEATHER_CONDITION,LIGHTING_CONDITION,FIRST_CRASH_TYPE,TRAFFICWAY_TYPE,LANE_CNT,ALIGNMENT,ROADWAY_SURFACE_COND,ROAD_DEFECT,REPORT_TYPE,CRASH_TYPE,INTERSECTION_RELATED_I,NOT_RIGHT_OF_WAY_I,HIT_AND_RUN_I,DAMAGE,DATE_POLICE_NOTIFIED,PRIM_CONTRIBUTORY_CAUSE,SEC_CONTRIBUTORY_CAUSE,STREET_NO,STREET_DIRECTION,STREET_NAME,BEAT_OF_OCCURRENCE,PHOTOS_TAKEN_I,STATEMENTS_TAKEN_I,DOORING_I,WORK_ZONE_I,WORK_ZONE_TYPE,WORKERS_PRESENT_I,NUM_UNITS,MOST_SEVERE_INJURY,INJURIES_TOTAL,INJURIES_FATAL,INJURIES_INCAPACITATING,INJURIES_NON_INCAPACITATING,INJURIES_REPORTED_NOT_EVIDENT,INJURIES_NO_INDICATION,INJURIES_UNKNOWN,CRASH_HOUR,CRASH_DAY_OF_WEEK,CRASH_MONTH,LATITUDE,LONGITUDE,LOCATION | |
| bacbcf3442c8f6c595c790a2ed777880ba043e3df354e8640f7f3fc9977870f5906f7e6c88b663ce781e4111586c6f29217afbb4cad80f2142c236895887198e,JB465068,,10/06/2018 03:50:00 PM,30,STOP SIGN/FLASHER,FUNCTIONING PROPERLY,RAIN,DAYLIGHT,PEDESTRIAN,NOT DIVIDED,0 |
stevevance
/ red_line_extension.geojson
Created
March 5, 2021 03:05
Bike route for Old Fashioned Donuts and Red Line Extension
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
stevevance
/ array_trim.sql
Last active
May 11, 2023 15:26
Trim the string elements of an array in PostgreSQL (wrap this function around an array or another function that returns an array, like string_to_array).
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE OR REPLACE FUNCTION array_trim(text[]) | |
| RETURNS text[] | |
| AS | |
| $$ | |
| DECLARE | |
| text ALIAS FOR $1; | |
| retVal text[]; | |
| BEGIN | |
| FOR I IN array_lower(text, 1)..array_upper(text, 1) LOOP | |
| retVal[I] := trim(text[I]); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [ | |
| { | |
| "id": "2-11,2-12,2-13,2-25,2-99,3-13,3-14,3-15,3-18,3-91,3-96,4-18,9-00,9-13,9-14,9-15,9-18,9-91,9-96,9-97", | |
| "text": "Multi-family buildings: apartments & condos (residential)" | |
| }, | |
| { | |
| "id": "2-11,2-12,2-13,2-25,3-13,3-14,3-15,3-18,3-91,3-96,4-18,9-00,9-13,9-14,9-15,9-18,9-91,9-96,9-97", | |
| "text": "Multi-family buildings: apartments, no condos (residential)" | |
| }, | |
| { |
stevevance
/ forestry_districts_021819.geojson
Created
February 18, 2019 19:28
Chicago forestry districts as of 2/18/19
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
stevevance
/ cdot_asphalt_districts_021819.geojson
Created
February 18, 2019 19:26
CDOT asphalt districts as of 2/18/19
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
stevevance
/ m_colleges_in_opportunity_zones_012319.geojson
Created
January 29, 2019 17:11
Map of colleges and universities in Opportunity Zones
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
stevevance
/ m_new_construction_since_2015_no_tents_mina_bloom_wicker_park.csv
Created
January 24, 2019 02:30
Planned Developments and New Construction Permits in Wicker Park
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 5.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| work_description,address,issue_date,_estimated_cost,alder | |
| "FULL BUILDING PERMIT FOR NEW CONSTRUCTION OF 2-STORY WITH BASEMENT SINGLE FAMILY HOME, 599 S.F. 2-CAR DETACHED PRIVATE GARAGE, AND 5 FT HIGH ORNAMENTAL FENCE AT FRONT YARD AND 6 FT HIGH WOOD FENCE AT SIDE/REAR YARD. CURRENT USE: VACANT LOT/PROPOSED USE: SINGLE FAMILY RESIDENTIAL",2118 W Evergreen Ave,2016-05-02,700000,"2nd Ward, Alder Brian Hopkins" | |
| ERECT NEW THREE STORY THREE UNITS MASONRY BUILDING WITH FULL BASEMENT. NEW THREE STORY STEEL REAR PORCH. NEW REAR 3RD FLR ROOF TOP DECK AND ACCESS ROOF PENTHOUSE AS PER PLANS. **CERTIFIED PLANS CORRECTIONS: CONDITIONAL PERMIT SUBJECT TO FIELD INSPECTIONS **,1349 N Leavitt St,2015-07-14,300000,"2nd Ward, Alder Brian Hopkins" | |
| "SELF CERTIFICATION REVIEW: ERECT FRAME SINGLE FAMILY RESIDENCE (4A CONSTRUCTION) WITH ROOF TOP DECK, ATTACHED 2 CAR MASONRY GARAGE (3B CONSTRUCTION) WITH ROOF TOP DECK AS PER PLAN.",1624 W Pierce Ave,2016-11-29,333600,"2nd Ward, Alder Brian Hopkins" | |
| "ERECT NEW 3 STORY, III-B, 2DU APAR |
stevevance
/ bucktown.geojson
Created
January 24, 2019 02:25
Planned Development and New Construction Permits in Bucktown
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
stevevance
/ custom-logan-square-mb-boundary.geojson
Last active
January 24, 2019 02:11
Planned Developments and New Construction permits in Logan Square
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.