stevevance

1. Judith Rice, 1999-2000
2. Miguel D’Escoto
3. Cheri Heramb, acting commissioner in June 2005, might have been there for more than two years
4. Don Grabowski
5. Tom Powers
6. Tom Byrne
7. Bobby Ware
8. Gabe Klein, May 2011 to November 2013
9. Rebekah Scheinfeld, January 2014

stevevance

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 ','; 

stevevance

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

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

{"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

stevevance

stevevance

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

stevevance