Editing Community Data Science Workshops (Spring 2015)/Day 3 Projects/Civic data
From CommunityData
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:Socrata-square-color.png|right|250px]] | |||
[[File:Socrata-square-color.png|right| | [[File:SeattleGovLogoHome.png|right|250px]] | ||
[[File:SeattleGovLogoHome.png|right| | |||
__NOTOC__ | __NOTOC__ | ||
== Building and visualizing datasets using data.seattle.gov and Google apps == | == Building and visualizing datasets using data.seattle.gov and Google apps == | ||
In this project, we will explore a few ways to gather data from [https://data.seattle.gov data.seattle.gov] using the [[w:Socrata|Socrata]] API, the Google Maps API, and Google Fusion tables. | In this project, we will explore a few ways to gather data from [https://data.seattle.gov data.seattle.gov] using the [[w:Socrata|Socrata]] API, the Google Maps API, and Google Fusion tables. | ||
=== Goals === | === Goals === | ||
Line 21: | Line 14: | ||
=== Topics | === Download the Day 3 Socrata project === | ||
<!--< font size="+1">[http://jtmorgan.net/cdsw/may9scripts.zip Click here to download the Socrata scripts]</font> --> | |||
If you are confused by these steps, go back and refresh your memory with the [[Community Data Science Workshops (Spring 2015)/Day 0 setup and tutorial|Day 0 setup and tutorial]] and [[Community Data Science Workshops (Spring 2015)/Day 0 tutorial|Day 0 tutorial]] | |||
;Today's dataset: [https://data.seattle.gov/Permitting/Building-Permits-Current/mags-97de Seattle Building Permits database] | |||
=== Topics to cover === | |||
* creating API queries and filtering and grouping the results | * creating API queries and filtering and grouping the results | ||
Line 28: | Line 28: | ||
* building visualizations of timeseries and geolocated data | * building visualizations of timeseries and geolocated data | ||
=== Questions we will try to answer with our data === | |||
=== Questions we will | |||
# which Seattle neighborhoods have had the most multifamily residential construction (apartments and townhomes) since 2010? | # which Seattle neighborhoods have had the most multifamily residential construction (apartments and townhomes) since 2010? | ||
# how much has the rate of apartment construction increased since 2010? | # how much has the rate of apartment construction increased since 2010? | ||
# where are the most expensive construction projects currently being built? | # where are the most expensive construction projects currently being built? | ||
=== Other questions you can answer with these data === | === Other questions you can answer with these data === | ||
# which Seattle developer has built the most apartments and townhomes since 2010? | # which Seattle developer has built the most apartments and townhomes since 2010? | ||
# where in Seattle are the most single-family homes being constructed? | # where in Seattle are the most single-family homes being constructed? | ||
=== Resources === | === Resources === | ||
* About Google Fusion tables: https://support.google.com/fusiontables/answer/2571232 | * About Google Fusion tables: https://support.google.com/fusiontables/answer/2571232 | ||
* Google Fusion Tables mapmaking tutorial: https://support.google.com/fusiontables/answer/2527132?hl=en&topic=2573107&ctx=topic | * Google Fusion Tables mapmaking tutorial: https://support.google.com/fusiontables/answer/2527132?hl=en&topic=2573107&ctx=topic | ||
Line 62: | Line 47: | ||
:* writing API queries: http://dev.socrata.com/docs/queries.html | :* writing API queries: http://dev.socrata.com/docs/queries.html | ||
; | ;Data.seattle.gov datasets with lat/long or street addresses | ||
*[https://data.seattle.gov/Community/Seattle-Cultural-Space-Inventory/vsxr-aydq Seattle Cultural Space Inventory] | *[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/MTS-Trail-west-of-I-90-Bridge/u38e-ybnc MTS trail bike/ped traffic] | ||
Line 79: | Line 64: | ||
* https://data.cityofchicago.org/ | * https://data.cityofchicago.org/ | ||
* https://data.cityofnewyork.us/ | * https://data.cityofnewyork.us/ | ||