Community Data Science Workshops (Spring 2015)/Day 3 Projects/Civic data: Difference between revisions

From CommunityData
(questions and topics)
(moar resources)
Line 5: Line 5:


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.
;Today's dataset: [https://data.seattle.gov/Permitting/Building-Permits-Current/mags-97de Seattle Building Permits database]
<!--< font size="+1">[http://jtmorgan.net/cdsw/may9scripts.zip Click here to download the Socrata scripts]</font> -->


=== Goals ===
=== Goals ===
Line 14: Line 18:




=== Download the Day 3 Socrata project ===
=== Topics we will cover ===
<!--< 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 25:
* 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 (attempt to) answer with our data ===
# 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 ===
''If you are confused by anything today, 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]]''
;Sample API queries
* Building permit data: https://data.seattle.gov/resource/mags-97de.json?$where=issue_date%20IS%20NOT%20NULL%20&action_type=NEW&category=MULTIFAMILY&$limit=100
* Google maps location (using street address): http://maps.googleapis.com/maps/api/geocode/json?address=5601+22ND+AVE+NW+Seattle+WA
* Google maps location (using lat/long): http://maps.googleapis.com/maps/api/geocode/json?latlng=47.66979666%2C-122.38570052
;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 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 47: Line 56:
:* 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
;Other data.seattle.gov datasets with neighborhood, timeseries, and/or location data
*[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]

Revision as of 01:45, 9 May 2015

Socrata-square-color.png
SeattleGovLogoHome.png

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.

Today's dataset
Seattle Building Permits database


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


Topics we will 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 (attempt to) answer with our data

  1. which Seattle neighborhoods have had the most multifamily residential construction (apartments and townhomes) since 2010?
  2. how much has the rate of apartment construction increased since 2010?
  3. where are the most expensive construction projects currently being built?


Other questions you can answer with these data

  1. which Seattle developer has built the most apartments and townhomes since 2010?
  2. where in Seattle are the most single-family homes being constructed?


Resources

If you are confused by anything today, go back and refresh your memory with the Day 0 setup and tutorial and Day 0 tutorial

Sample API queries
Help resources and inspiration
Other data.seattle.gov datasets with neighborhood, timeseries, and/or location data
Instructional videos
Other Socrata sites that use this API