Community Data Science Workshops (Spring 2016)/Day 2 Projects/Socrata: Difference between revisions
From CommunityData
(mark as draft while I work) |
("do not use!") |
||
| (5 intermediate revisions by the same user not shown) | |||
| Line 10: | Line 10: | ||
|top color=FFF | |top color=FFF | ||
|line color=FFF | |line color=FFF | ||
|top text=This page is | |top text=This page is not up to date. Do not use! | ||
|bottom font-size= 1em | |bottom font-size= 1em | ||
|bottom color= FFF | |bottom color= FFF | ||
|bottom text= | |bottom text= 17:18, 22 April 2016 (EDT) | ||
|line= none | |line= none | ||
}}</div></div> | }}</div></div> | ||
<div style="clear:both;"></div> | <div style="clear:both;"></div> | ||
[[File:SeattleGovLogoHome.png|right|250px]] | [[File:SeattleGovLogoHome.png|right|250px]] | ||
[[File:Socrata-square-color.png|right|100px]] | |||
== Building a Dataset using the Socrata API and data.seattle.gov == | == Building a Dataset using the Socrata API and data.seattle.gov == | ||
In this project, we will explore a few ways to gather data from [https://data.seattle.gov data.seattle.gov] using the [[ | In this project, we will explore a few ways to gather data from [https://data.seattle.gov data.seattle.gov] using the [[http://www.socrata.com Socrata open data] API. Once we've done that, we will extend this to code to create our own datasets of civic data that we might be able to use to ask and answer questions in the final session. | ||
=== Goals === | === Goals === | ||
| Line 31: | Line 31: | ||
* Practice reading and extending other people's code | * Practice reading and extending other people's code | ||
* Create a few collections of different types of data from Socrata that you can do research with in the final workshop session | * Create a few collections of different types of data from Socrata that you can do research with in the final workshop session | ||
== Today's project: Analyzing traffic on the Burke-Gilman Trail == | |||
[[File:Burke-Gilman-Cat-3462.jpg|right|300px]] | |||
=== Download the Socrata project === | === Download the Socrata project === | ||
<font size="+1">[http://jtmorgan.net/cdsw/ | <font size="+1">[http://jtmorgan.net/cdsw/spring2016/week2.zip Click here to download the scripts]</font> | ||
If you are confused by these steps, 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]] | If you are confused by these steps, 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]] | ||
| Line 67: | Line 70: | ||
*[http://dev.socrata.com/docs/queries.html writing API queries] | *[http://dev.socrata.com/docs/queries.html writing API queries] | ||
=== Datasets used in this project === | |||
You don't need to download these, but you may want to open the links below to view them online, so that you understand the data we will be working with. | |||
*[https://data.seattle.gov/Transportation/ | |||
*[https://data.seattle.gov/Transportation/ | *[https://data.seattle.gov/Transportation/Burke-Gilman-Trail-north-of-NE-70th-St-Bike-and-Pe/2z5v-ecg8 Burke-Gilman trail bike and pedestrian traffic counts] — this is our primary dataset: hourly traffic counts on the BGT (measured at its intersection of NE 70th street in Northeast Seattle), broken down by bike vs ped, and northbound vs southbound. | ||
*[https://data.seattle.gov/Transportation/MTS-Trail-west-of-I-90-Bridge/u38e-ybnc Mountain-to-Sounds trail bike and pedestrian traffic counts] — this is a 'bonus' dataset which you will need to complete the 'bonus' coding challenges. | |||
<!-- | |||
*[https://data.seattle.gov/Transportation/Road-Weather-Information-Stations/egc4-d24i Road temps in Seattle] | *[https://data.seattle.gov/Transportation/Road-Weather-Information-Stations/egc4-d24i Road temps in Seattle] | ||
--> | |||
;Videos | ;Videos | ||
Latest revision as of 23:18, 22 April 2016
This page is not up to date. Do not use!
17:18, 22 April 2016 (EDT)
Building a Dataset using the Socrata API and data.seattle.gov[edit]
In this project, we will explore a few ways to gather data from data.seattle.gov using the [Socrata open data API. Once we've done that, we will extend this to code to create our own datasets of civic data that we might be able to use to ask and answer questions in the final session.
Goals[edit]
- Get set up to build datasets with the Socrata API
- Have fun collecting different types of data from data.seattle.gov
- Practice reading and extending other people's code
- Create a few collections of different types of data from Socrata that you can do research with in the final workshop session
Today's project: Analyzing traffic on the Burke-Gilman Trail[edit]
Download the Socrata project[edit]
Click here to download the scripts
If you are confused by these steps, go back and refresh your memory with the Day 0 setup and tutorial and Day 0 tutorial
(Estimated time: 10 minutes)
Topics to cover[edit]
- explain Socrata open data platform, exists on other government websites
- navigate to api page and show the documentation, point out examples
- introduce the API sandbox as a tool for building queries
Example questions[edit]
- What Seattle neighborhood has the most art galleries? - neighborhood_culture1.py
- What Seattle neighborhood has the most square feet devoted to arts & culture? - neighborhood_culture2.py
- Which trail gets more bike traffic per month--the Burke Gilman or the Mountain to Sound Trail? - traffic_counter1.py, traffic_counter2.py
- Do people use the trails less when it's cold? monthly_weather.py
- Does the Burke-Gilman get more bike or pedestrian traffic? bike_and_peds1.py
- What is the primary commute direction on the Burke Gilman? bike_and_peds2.py
- Other example questions
- What day of the week does the Burke Gilman have the most total traffic?
- What day has the most pedestrian traffic?
- What time of day has the most southbound traffic, on average?
- How many shoplifting calls has SPD responded to this month so far?
Resources[edit]
Datasets used in this project[edit]
You don't need to download these, but you may want to open the links below to view them online, so that you understand the data we will be working with.
- Burke-Gilman trail bike and pedestrian traffic counts — this is our primary dataset: hourly traffic counts on the BGT (measured at its intersection of NE 70th street in Northeast Seattle), broken down by bike vs ped, and northbound vs southbound.
- Mountain-to-Sounds trail bike and pedestrian traffic counts — this is a 'bonus' dataset which you will need to complete the 'bonus' coding challenges.
- 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
