Community Data Science Workshops (Spring 2015)/Day 2 Projects/Socrata: Difference between revisions

From CommunityData
(working on day 3 curriculum)
(update links)
 
(2 intermediate revisions by the same user not shown)
Line 16: Line 16:
<font size="+1">[http://jtmorgan.net/cdsw/april25scripts.zip Click here to download the Socrata scripts]</font>
<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 (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 (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 41: Line 41:


=== Resources ===
=== Resources ===
* About Google Fusion tables: https://support.google.com/fusiontables/answer/2571232
* [https://www.hurl.it API Sandbox]
* Google Fusion Tables mapmaking tutorial: https://support.google.com/fusiontables/answer/2527132?hl=en&topic=2573107&ctx=topic
* [http://web6.seattle.gov/mnm/ API-powered app]
* API sandbox tool: https://www.hurl.it
[http://dev.socrata.com/consumers/getting-started.html API resources]
* API-powered app: http://web6.seattle.gov/mnm/
*[http://dev.socrata.com/docs/filtering.html filtering results]
* Socrata API help resources: http://dev.socrata.com/consumers/getting-started.html
*[http://dev.socrata.com/docs/datatypes/timestamp.html dealing with timestamps]
:* filtering results: http://dev.socrata.com/docs/filtering.html
*[http://dev.socrata.com/docs/queries.html writing API queries]
:* 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
;Datasets
*[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]
Line 57: Line 55:
*[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]


;Instructional videos
;Videos
* https://data.seattle.gov/videos
* https://data.seattle.gov/videos
* https://www.youtube.com/watch?v=YlKzXTrTLOQ
* https://www.youtube.com/watch?v=YlKzXTrTLOQ
Line 67: Line 65:
* https://data.cityofchicago.org/
* https://data.cityofchicago.org/
* https://data.cityofnewyork.us/
* https://data.cityofnewyork.us/
[[Category:Spring_2015_series]]

Latest revision as of 01:21, 19 October 2015

Socrata-square-color.png
SeattleGovLogoHome.png

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]

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]

API resources

Datasets
Videos
Other Socrata sites