Building an SDG Data Dashboard for San José, California Derek Ouyang (douyang1@stanford.edu), Lecturer, Stanford University 2017 American Planning Association Conference New York, NY -- May 7, 2017
? ? ? Population 8.4 million 620,000 1.0 million Population Density 28,000/sqmi 7,700/sqmi 5,700/sqmi city-data.com
NYC Baltimore San Jose Population 8.4 million 620,000 1.0 million Population Density 28,000/sqmi 7,700/sqmi 5,700/sqmi city-data.com
NYC Baltimore San Jose Population 8.4 million 620,000 1.0 million Population Density 28,000/sqmi 7,700/sqmi 5,700/sqmi 1.1 1.5 0.86 8.4% 38% 50% 22% 70% 77% 15% 32% 19% city-data.com
NYC Baltimore San Jose Population 8.4 million 620,000 1.0 million Population Density 28,000/sqmi 7,700/sqmi 5,700/sqmi Jobs/Employed Residents Ratio 1.1 1.5 0.86 8.4% 38% 50% 22% 70% 77% 15% 32% 19% city-data.com
NYC Baltimore San Jose Population 8.4 million 620,000 1.0 million Population Density 28,000/sqmi 7,700/sqmi 5,700/sqmi Jobs/Employed Residents Ratio 1.1 1.5 0.86 Work in another city 8.4% 38% 50% 22% 70% 77% 15% 32% 19% city-data.com
NYC Baltimore San Jose Population 8.4 million 620,000 1.0 million Population Density 28,000/sqmi 7,700/sqmi 5,700/sqmi Jobs/Employed Residents Ratio 1.1 1.5 0.86 Work in another city 8.4% 38% 50% Commute by single occupant vehicle 22% 70% 77% 15% 32% 19% city-data.com
NYC Baltimore San Jose Population 8.4 million 620,000 1.0 million Population Density 28,000/sqmi 7,700/sqmi 5,700/sqmi Jobs/Employed Residents Ratio 1.1 1.5 0.86 Work in another city 8.4% 38% 50% Commute by single occupant vehicle 22% 70% 77% Adult obesity rate 15% 32% 19% city-data.com
NYC Baltimore San Jose Population 8.4 million 620,000 1.0 million Population Density 28,000/sqmi 7,700/sqmi 5,700/sqmi Jobs/Employed Residents Ratio 1.1 1.5 0.86 Work in another city 8.4% 38% 50% Commute by single occupant vehicle 22% 70% 77% Adult obesity rate 15% 32% 19% $52,000 $42,000 $81,000 $1300 $980 $1700 21% 23% 13% $1500 $900 $290 390,000 24,000 4,700 city-data.com
NYC Baltimore San Jose Population 8.4 million 620,000 1.0 million Population Density 28,000/sqmi 7,700/sqmi 5,700/sqmi Jobs/Employed Residents Ratio 1.1 1.5 0.86 Work in another city 8.4% 38% 50% Commute by single occupant vehicle 22% 70% 77% Adult obesity rate 15% 32% 19% Household median income $52,000 $42,000 $81,000 $1300 $980 $1700 21% 23% 13% $1500 $900 $290 390,000 24,000 4,700 city-data.com
NYC Baltimore San Jose Population 8.4 million 620,000 1.0 million Population Density 28,000/sqmi 7,700/sqmi 5,700/sqmi Jobs/Employed Residents Ratio 1.1 1.5 0.86 Work in another city 8.4% 38% 50% Commute by single occupant vehicle 22% 70% 77% Adult obesity rate 15% 32% 19% Household median income $52,000 $42,000 $81,000 Monthly housing costs $1300 $980 $1700 21% 23% 13% $1500 $900 $290 390,000 24,000 4,700 city-data.com
NYC Baltimore San Jose Population 8.4 million 620,000 1.0 million Population Density 28,000/sqmi 7,700/sqmi 5,700/sqmi Jobs/Employed Residents Ratio 1.1 1.5 0.86 Work in another city 8.4% 38% 50% Commute by single occupant vehicle 22% 70% 77% Adult obesity rate 15% 32% 19% Household median income $52,000 $42,000 $81,000 Monthly housing costs $1300 $980 $1700 Poverty 21% 23% 13% $1500 $900 $290 390,000 24,000 4,700 city-data.com
NYC Baltimore San Jose Population 8.4 million 620,000 1.0 million Population Density 28,000/sqmi 7,700/sqmi 5,700/sqmi Jobs/Employed Residents Ratio 1.1 1.5 0.86 Work in another city 8.4% 38% 50% Commute by single occupant vehicle 22% 70% 77% Adult obesity rate 15% 32% 19% Household median income $52,000 $42,000 $81,000 Monthly housing costs $1300 $980 $1700 Poverty 21% 23% 13% Property tax per resident $1500 $900 $290 390,000 24,000 4,700 city-data.com
NYC Baltimore San Jose Population 8.4 million 620,000 1.0 million Population Density 28,000/sqmi 7,700/sqmi 5,700/sqmi Jobs/Employed Residents Ratio 1.1 1.5 0.86 Work in another city 8.4% 38% 50% Commute by single occupant vehicle 22% 70% 77% Adult obesity rate 15% 32% 19% Household median income $52,000 $42,000 $81,000 Monthly housing costs $1300 $980 $1700 Poverty 21% 23% 13% Property tax per resident $1500 $900 $290 Government full-time employees 390,000 24,000 4,700 city-data.com
San José’s Sustainability Challenges & Opportunities → Sprawl Inefficient services → Prop 13 Low property tax → Bedroom community High service cost → Great Recession Understaffed city → Silicon Valley → → →
?
How can we engage urban stakeholders directly in the Sustainable Development Goals?
1 2 3 Raise Inspire Motivate Awareness Change Action How can we engage communities directly in the Sustainable Development Goals?
Emissions Total City- per Capita in Transportation Goods Electricity Food Wide each Emissions Blockgroup Annual Blockgroup Electric Annual Annual Gas and Level Proxy Data Utility Beef Apparel Airfare Payments Purchases Purchases Purchases
Additional SDG Metrics
Additional SDG’s: Metrics SDG-1: No Poverty % Households under $15,000/yr SDG-4: Quality Education % Children age 3-25 enrolled in school SDG-5: Gender Equality Ratio of female/male employment SDG-8: Economic Growth Total % Employed SDG-10: Reduced Inequalities
What’s next? Continue iterating on design with community stakeholders District 3 Community Add tools: Leadership Council Meeting, April 2017 Raise Awareness → Inspire Change → Motivate Action Expand vertically to include more metrics, more SDGs Expand horizontally to include coolblock.org the entire Bay Area
What’s next? Continue iterating on design with community stakeholders Add tools: Raise Awareness → Inspire Change → Motivate Action Expand vertically to include more metrics, more SDGs Expand horizontally to include the entire Bay Area
Building an SDG Data Dashboard for San José, California Derek Ouyang (douyang1@stanford.edu), Lecturer, Stanford University 2017 American Planning Association Conference New York, NY -- May 7, 2017
Recommend
More recommend