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
San Jos, California Derek Ouyang (douyang1@stanford.edu), Lecturer, - - PowerPoint PPT Presentation
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
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
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
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
Food Goods Transportation Electricity Total City- Wide Emissions Blockgroup Level Proxy Data
Electric Utility Payments Annual Beef Purchases Annual Apparel Purchases Annual Gas and Airfare Purchases
Emissions per Capita in each Blockgroup
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
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
coolblock.org District 3 Community Leadership Council Meeting, April 2017
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
Derek Ouyang (douyang1@stanford.edu), Lecturer, Stanford University 2017 American Planning Association Conference New York, NY -- May 7, 2017