Editing Community Data Science Workshops (Fall 2015)/Day 3 Projects/Civic data
From CommunityData
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then publish the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 1: | Line 1: | ||
[[File:Seattle_building_cost_heatmap.png | [[File:Seattle_building_cost_heatmap.png|right|250px]] | ||
[[File:SeattleGovLogoHome.png|right|150px]] | |||
__NOTOC__ | __NOTOC__ | ||
Line 17: | Line 18: | ||
* Graphing and mapping data | * Graphing and mapping data | ||
We will also explore an important non-technical part of data science: thinking critically about data. Thinking critically about the data you have, and what conclusions you can draw from it, is especially important when you are visualizing data, because its easy to mislead people with visualizations. We'll discuss how visualizations based on incorrect data can lead people to make false conclusions, using an example from a recent visualization of building demolitions published in the Northwest design magazine ''Arcade''. | |||
== Preparation == | |||
;Step 1: Download today's scripts and sample datasets: [http://jtmorgan.net/cdsw/may9cdsw2.zip FIXME] | |||
;Today's dataset: [https://data.seattle.gov/Permitting/Building-Permits-Current/mags-97de Click here to view the Seattle Building Permits database] | |||
;Step 1: Download today's scripts: [http://jtmorgan.net/cdsw/ | |||
; | |||
== Visualizing new home construction in Seattle over time == | |||
;Question: Has the rate of apartment construction increased since 2010? | |||
== Visualizing new home construction in Seattle by neighborhood == | |||
== | |||
;Question: which Seattle neighborhoods have had the most multifamily residential construction (apartments and townhomes) since 2010? | ;Question: which Seattle neighborhoods have had the most multifamily residential construction (apartments and townhomes) since 2010? | ||
== | == Mapping new home construction in Seattle == | ||
;Question: what locations have experienced the highest density of new construction since 2010? | ;Question: what locations have experienced the highest density of new construction since 2010? | ||
== Challenge questions == | |||
''Try to answer these additional questions that draw on the data and methods we're learning today. Ask a mentor if you get stuck!'' | ''Try to answer these additional questions that draw on the data and methods we're learning today. Ask a mentor if you get stuck!'' | ||
# | #In which Seattle neighborhood is the cost of new construction projects highest, on average? | ||
#Where in Seattle are the most commercial buildings being constructed in 2015? | |||
#Where in Seattle are the most | #How does the rate of residential construction in Seattle from 2010-2015 compare to the previous 5 years? | ||
#How does the rate of residential construction in Seattle from 2010-2015 compare to | #How many townhouses have been constructed in Seattle since 2011? | ||
=== Resources === | |||
''If you are confused by anything today, go back and refresh your memory with the [[Community Data Science Workshops (Fall 2015)/Day 0 setup and tutorial|Day 0 setup and tutorial]] and [[Community Data Science Workshops (Fall 2015)/Day 0 tutorial|Day 0 tutorial]]'' | |||
=== | |||
;Sample API queries | ;Sample API queries | ||
Line 104: | Line 55: | ||
* Google maps location (using lat/long): http://maps.googleapis.com/maps/api/geocode/json?latlng=47.66979666%2C-122.38570052 | * Google maps location (using lat/long): http://maps.googleapis.com/maps/api/geocode/json?latlng=47.66979666%2C-122.38570052 | ||
;Sample charts/maps | |||
* Google Fusion table map of permits 2010-2015 [https://www.google.com/fusiontables/DataSource?docid=1aOSWYuXXqh7U2bnUsBH7mM2w3JfsYHzjk29ihbi8] | |||
;Help resources and inspiration | |||
* About Google maps API: https://developers.google.com/maps/documentation/geocoding/#ReverseGeocoding | |||
* About Google Fusion tables: https://support.google.com/fusiontables/answer/2571232 | |||
*About Fusion | * Google Fusion Tables mapmaking tutorial: https://support.google.com/fusiontables/answer/2527132?hl=en&topic=2573107&ctx=topic | ||
* | * API sandbox tool: https://www.hurl.it | ||
* API-powered app: http://web6.seattle.gov/mnm/ | |||
* | |||
* Socrata API help resources: http://dev.socrata.com/consumers/getting-started.html | * Socrata API help resources: http://dev.socrata.com/consumers/getting-started.html | ||
:* filtering results: http://dev.socrata.com/docs/filtering.html | :* filtering results: http://dev.socrata.com/docs/filtering.html | ||
Line 118: | Line 69: | ||
:* writing API queries: http://dev.socrata.com/docs/queries.html | :* writing API queries: http://dev.socrata.com/docs/queries.html | ||
; | ;Other data.seattle.gov datasets with neighborhood, timeseries, and/or location data | ||
*https:// | *[https://data.seattle.gov/Community/Seattle-Cultural-Space-Inventory/vsxr-aydq Seattle Cultural Space Inventory] | ||
* | *[https://data.seattle.gov/Transportation/MTS-Trail-west-of-I-90-Bridge/u38e-ybnc MTS trail bike/ped traffic] | ||
*[https://data.seattle.gov/Transportation/Burke-Gilman-Trail-north-of-NE-70th-St-Bike-and-Pe/2z5v-ecg8 Burke Gilman trail bike/ped traffic] | |||
*[https://data.seattle.gov/Transportation/Road-Weather-Information-Stations/egc4-d24i Road temps in Seattle] | |||
*[https://data.seattle.gov/Public-Safety/Seattle-Police-Department-911-Incident-Response/3k2p-39jp SPD 911 incident respose] | |||
; | ;Instructional videos | ||
* https://data.seattle.gov/videos | * https://data.seattle.gov/videos | ||
* https://www.youtube.com/watch?v=YlKzXTrTLOQ | * https://www.youtube.com/watch?v=YlKzXTrTLOQ | ||
Line 128: | Line 82: | ||
* https://www.youtube.com/watch?v=Vd6bwz3ivVA | * https://www.youtube.com/watch?v=Vd6bwz3ivVA | ||
; | ;Other Socrata sites that use this API | ||
* https://data.austintexas.gov/ | * https://data.austintexas.gov/ | ||
* https://data.cityofchicago.org/ | * https://data.cityofchicago.org/ |