Community Data Science Workshops (Spring 2015)/Day 2 Projects/Socrata: Difference between revisions
From CommunityData
No edit summary |
(update links) |
||
(11 intermediate revisions by 3 users not shown) | |||
Line 14: | Line 14: | ||
=== Download the Socrata project === | === Download the Socrata project === | ||
<font size="+1">[http:// | <font size="+1">[http://jtmorgan.net/cdsw/april25scripts.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 ( | 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]] | ||
(Estimated time: 10 minutes) | (Estimated time: 10 minutes) | ||
Line 27: | Line 27: | ||
=== Example questions === | === Example questions === | ||
* What Seattle neighborhood has the most art galleries? | * What Seattle neighborhood has the most art galleries? - [http://jtmorgan.net/cdsw/neighborhood_culture1.py neighborhood_culture1.py] | ||
* What Seattle neighborhood has the most square feet devoted to arts & culture? | * What Seattle neighborhood has the most square feet devoted to arts & culture? - [http://jtmorgan.net/cdsw/neighborhood_culture2.py neighborhood_culture2.py] | ||
* Which trail gets more bike traffic per month--the [[w:Mountains_to_Sound_Greenway|Mountain to Sound Trail]] | * Which trail gets more bike traffic per month--the [[w:Burke-Gilman_Trail|Burke Gilman]] or the [[w:Mountains_to_Sound_Greenway|Mountain to Sound Trail]]? - [http://jtmorgan.net/cdsw/traffic_counter1.py traffic_counter1.py], [http://jtmorgan.net/cdsw/traffic_counter2.py traffic_counter2.py] | ||
* 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? | * Do people use the trails less when it's cold? [http://jtmorgan.net/cdsw/monthly_weather.py monthly_weather.py] | ||
* Does the Burke-Gilman get more bike or pedestrian traffic? [http://jtmorgan.net/cdsw/bike_and_peds1.py bike_and_peds1.py] | |||
* What is the primary commute direction on the Burke Gilman? [http://jtmorgan.net/cdsw/bike_and_peds1.py 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 === | === Resources === | ||
* [https://www.hurl.it API Sandbox] | * [https://www.hurl.it API Sandbox] | ||
* [http://web6.seattle.gov/mnm/ API-powered app] | * [http://web6.seattle.gov/mnm/ API-powered app] | ||
[http://dev.socrata.com/consumers/getting-started. | [http://dev.socrata.com/consumers/getting-started.html API resources] | ||
*[http://dev.socrata.com/docs/filtering.html filtering results] | *[http://dev.socrata.com/docs/filtering.html filtering results] | ||
*[http://dev.socrata.com/docs/datatypes/timestamp.html dealing with timestamps] | *[http://dev.socrata.com/docs/datatypes/timestamp.html dealing with timestamps] | ||
*http://dev.socrata.com/docs/queries.html writing API queries] | *[http://dev.socrata.com/docs/queries.html writing API queries] | ||
;Datasets | ;Datasets | ||
Line 46: | Line 54: | ||
*[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] | ||
*[https://data.seattle.gov/Public-Safety/Seattle-Police-Department-911-Incident-Response/3k2p-39jp SPD 911 incident respose] | *[https://data.seattle.gov/Public-Safety/Seattle-Police-Department-911-Incident-Response/3k2p-39jp SPD 911 incident respose] | ||
;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 | |||
* https://data.austintexas.gov/ | |||
* https://data.cityofchicago.org/ | |||
* https://data.cityofnewyork.us/ | |||
[[Category:Spring_2015_series]] |
Latest revision as of 00:21, 19 October 2015
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 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
Download the Socrata project[edit]
Click here to download the Socrata 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
- Seattle Cultural Space Inventory
- MTS trail bike/ped traffic
- Burke Gilman trail bike/ped traffic
- Road temps in Seattle
- SPD 911 incident respose
- 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