Community Data Science Workshops (Spring 2015)/Day 3 Projects/Civic data: Difference between revisions
From CommunityData
(creating resources page for Day 3) |
(questions and topics) |
||
Line 11: | Line 11: | ||
* Combine those data with neighborhood data from the Google Maps API | * Combine those data with neighborhood data from the Google Maps API | ||
* Download the results in a CSV file | * Download the results in a CSV file | ||
* Upload results to Google's | * Upload results to Google's [https://support.google.com/fusiontables/answer/2571232 Fusion Table] visualization engine | ||
=== Download the Day 3 Socrata project === | === Download the Day 3 Socrata project === | ||
<font size="+1">[http://jtmorgan.net/cdsw/may9scripts.zip Click here to download the Socrata scripts]</font> | <!--< 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]] | 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 === | === Topics to cover === | ||
* | * creating API queries and filtering and grouping the results | ||
* | * combining results from multiple APIs | ||
* | * downloading API results as CSV files | ||
* building visualizations of timeseries and geolocated data | |||
=== | === Questions we will try to answer with our data === | ||
# 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? | |||
# where are the most expensive construction projects currently being built? | |||
=== Other questions you can answer with these data === | |||
# which Seattle developer has built the most apartments and townhomes since 2010? | |||
# where in Seattle are the most single-family homes being constructed? | |||
=== Resources === | === Resources === |
Revision as of 02:38, 9 May 2015
Building and visualizing datasets using data.seattle.gov and Google apps
In this project, we will explore a few ways to gather data from data.seattle.gov using the Socrata API, the Google Maps API, and Google Fusion tables.
Goals
- Collect data on building permits in Seattle, by neighborhood and by year awarded.
- Combine those data with neighborhood data from the Google Maps API
- Download the results in a CSV file
- Upload results to Google's Fusion Table visualization engine
Download the Day 3 Socrata project
If you are confused by these steps, go back and refresh your memory with the Day 0 setup and tutorial and Day 0 tutorial
- Today's dataset
- Seattle Building Permits database
Topics to cover
- creating API queries and filtering and grouping the results
- combining results from multiple APIs
- downloading API results as CSV files
- building visualizations of timeseries and geolocated data
Questions we will try to answer with our data
- 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?
- where are the most expensive construction projects currently being built?
Other questions you can answer with these data
- which Seattle developer has built the most apartments and townhomes since 2010?
- where in Seattle are the most single-family homes being constructed?
Resources
- 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
- 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
- filtering results: http://dev.socrata.com/docs/filtering.html
- dealing with timestamps: http://dev.socrata.com/docs/datatypes/timestamp.html
- writing API queries: http://dev.socrata.com/docs/queries.html
- Data.seattle.gov datasets with lat/long or street addresses
- Seattle Cultural Space Inventory
- MTS trail bike/ped traffic
- Burke Gilman trail bike/ped traffic
- Road temps in Seattle
- SPD 911 incident respose
- Instructional videos
- https://data.seattle.gov/videos
- https://www.youtube.com/watch?v=YlKzXTrTLOQ
- https://www.youtube.com/watch?v=Whfp8ojMf0U
- https://www.youtube.com/watch?v=Vd6bwz3ivVA
- Other Socrata sites that use this API