stevevance
/ socrata_dates_for_postgresql.txt
Last active
August 29, 2015 14:01
Changing date formats from Socrata for PostgreSQL
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
| PostgreSQL prefers dates in YYYY-MM-DD format but Socrata-hosted datasets may instead use MM/DD/YYYY. You can easily use OpenRefine to change between date formats. | |
| * Click on the drop down arrow next to the date column that needs to change. | |
| * Click Edit Cells>Transform | |
| * In the Expression box, input smartSplit(value,"/")[2]+"-"+smartSplit(value,"/")[0]+"-"+smartSplit(value,"/")[1] | |
| Then you can copy the CSV file into PostgreSQL with the COPY command: | |
| COPY table_name FROM '/path/to/file.csv' WITH CSV HEADER DELIMITER AS ','; |
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
| 1 - existing bike lane | |
| 2 - existing shared-lane | |
| 3 - proposed on-street bikeway | |
| 4 - recommended bike route | |
| 5 - existing trail | |
| 6 - proposed off-street trail | |
| 7 - access path | |
| 8 - cycle track | |
| 9 - buffered bike lane |
stevevance
/ nlsd population.txt
Created
July 16, 2014 21:32
Community area population along North Lake Shore Drive
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
| number name 2010 2000 difference | |
| 1 Rogers Park 54991 63484 -13.38% | |
| 77 Edgewater 56521 62198 -9.13% | |
| 3 Uptown 56362 63551 -11.31% | |
| 6 Lake View 94368 94817 -0.47% | |
| 7 Lincoln Park 64116 64320 -0.32% | |
| 8 Near North Side 80484 72811 10.54% | |
| Total 406842 421181 -3.40% | |
| Based on http://www.cityofchicago.org/content/dam/city/depts/zlup/Zoning_Main_Page/Publications/Census_2010_Community_Area_Profiles/Census_2010_and_2000_CA_Populations.pdf |
stevevance
/ gist:13a27dc2d223807ef334
Created
September 5, 2014 18:44
valid GeoJSON but Leaflet disagrees
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
| {"type": "FeatureCollection","features": [{"type": "Feature","properties": {"name": "NEAR NORTH SIDE","costs": 1206508572.98,"permits": 1552},"geometry":{"type":"MultiPolygon","coordinates":[[[[-87.6244647669346,41.9115669996125],[-87.6250951520475,41.9102652329892],[-87.6250896861335,41.9091113337303],[-87.6237226841407,41.9040491746411],[-87.6225911471491,41.9031881439963],[-87.6218682654193,41.9020458545896],[-87.6198760401314,41.9015463921376],[-87.6192348549954,41.9010987193827],[-87.6136862075977,41.8931290179181],[-87.612623187077,41.8934092335876],[-87.6120301409595,41.8933268876794],[-87.6101544949093,41.8962276569595],[-87.6024259846732,41.8963713151519],[-87.6023519555048,41.8932645909451],[-87.6098223454677,41.8931457649556],[-87.6097959852677,41.8922205996266],[-87.6007146644317,41.8924429611157],[-87.6005821145244,41.8922403863906],[-87.5985493195876,41.892274296187],[-87.5985243875776,41.8914502903218],[-87.6005668647662,41.8914152346919],[-87.6007190591409,41.8910749323238],[-87.609535445724,4 |
stevevance
/ 90-day Chicago teardowns.tsv
Last active
August 29, 2015 14:07
Suspected teardowns in Chicago for 2012-2014 as of 9-30-2014
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
| Community Area | 2012 | 2013 | 2014 | |
|---|---|---|---|---|
| ALBANY PARK | 0 | 2 | 2 | |
| AUBURN GRESHAM | 1 | 1 | 0 | |
| AUSTIN | 0 | 1 | 0 | |
| AVONDALE | 0 | 6 | 5 | |
| BELMONT CRAGIN | 1 | 0 | 1 | |
| BEVERLY | 2 | 0 | 0 | |
| BRIDGEPORT | 5 | 5 | 6 | |
| BRIGHTON PARK | 1 | 4 | 0 | |
| DUNNING | 4 | 2 | 0 |
stevevance
/ forestcity.geojson
Last active
August 29, 2015 14:08
Central Station expansion by Forest City and pappageorge haymes
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
stevevance
/ chicago vmt 2005-2013
Created
December 24, 2014 06:17
Chicago citywide VMT - vehicle miles traveled for 2005 to 2013; data from Illinois DOT
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
| year VMT | |
| 2005 8,379,390,000 | |
| 2006 7,886,500,000 | |
| 2007 7,906,194,000 | |
| 2008 7,790,795,000 | |
| 2009 7,783,079,000 | |
| 2010 7,490,567,000 | |
| 2011 7,208,792,000 | |
| 2012 7,127,674,000 | |
| 2013 7,178,589,000 |
stevevance
/ uchicago_campus.geojson
Created
December 31, 2014 20:57
University of Chicago campus map
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
stevevance
/ uic_campus.geojson
Last active
August 29, 2015 14:12
University of Illinois at Chicago campus map
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
OlderNewer