Not logged in
Talk
Contributions
Create account
Log in
Navigation
Main page
About
People
Publications
Teaching
Resources
Research Blog
Wiki Functions
Recent changes
Help
Licensing
Page
Discussion
Edit
View history
Editing
Community Data Science Workshops (Spring 2015)/Day 3 Projects/Civic data
From CommunityData
Jump to:
navigation
,
search
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.
Anti-spam check. Do
not
fill this in!
[[File:Seattle_building_cost_heatmap.png|right|250px]] [[File:Socrata-square-color.png|right|150px]] [[File:SeattleGovLogoHome.png|right|150px]] __NOTOC__ == 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. ;Today's dataset: [https://data.seattle.gov/Permitting/Building-Permits-Current/mags-97de Click here to view the Seattle Building Permits database] ;Today's scripts: [http://jtmorgan.net/cdsw/may9cdsw2.zip Click here to download the today's scripts] === 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 [https://support.google.com/fusiontables/answer/2571232 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 === # 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 === ''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 ;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 * 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 ;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/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://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 * https://data.austintexas.gov/ * https://data.cityofchicago.org/ * https://data.cityofnewyork.us/ [[Category:Spring_2015_series]]
Summary:
Please note that all contributions to CommunityData are considered to be released under the Attribution-Share Alike 3.0 Unported (see
CommunityData:Copyrights
for details). If you do not want your writing to be edited mercilessly and redistributed at will, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource.
Do not submit copyrighted work without permission!
To protect the wiki against automated edit spam, we kindly ask you to solve the following CAPTCHA:
Cancel
Editing help
(opens in new window)
Tools
What links here
Related changes
Special pages
Page information