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

From CommunityData
(+resources)
No edit summary
Line 14: Line 14:


=== Download the Socrata project ===
=== Download the Socrata project ===
<font size="+1">[http://www.jtmorgan.net Click here to download the Socrata scripts]</font>
<font size="+1">[http://www.FIXME 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 (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]]
Line 20: Line 20:
(Estimated time: 10 minutes)
(Estimated time: 10 minutes)


=== Example topics to cover ===
=== Topics to cover ===


* explain Socrata open data platform, exists on other government websites
* explain Socrata open data platform, exists on other government websites
* navigate to [http://en.wikipedia.org/w/api.php api page] and show the documentation, point out examples
* navigate to [http://en.wikipedia.org/w/api.php api page] and show the documentation, point out examples
* introduce the [https://www.hurl.it API sandbox] as a tool for building queries
* introduce the [https://www.hurl.it API sandbox] as a tool for building queries
=== Example questions ===
* What Seattle neighborhood has the most art galleries?
* What Seattle neighborhood has the most square feet devoted to arts & culture?
* Which trail gets more bike traffic per month--the [[w:Mountains_to_Sound_Greenway|Mountain to Sound Trail]] or the [[w:Burke-Gilman_Trail|Burke Gilman]]?
* 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?


=== Resources ===
=== Resources ===

Revision as of 16:04, 25 April 2015

Socrata-square-color.png
SeattleGovLogoHome.png

Building a Dataset using the Socrata API and data.seattle.gov

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

  • 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

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

  • 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

  • What Seattle neighborhood has the most art galleries?
  • What Seattle neighborhood has the most square feet devoted to arts & culture?
  • Which trail gets more bike traffic per month--the Mountain to Sound Trail or the Burke Gilman?
  • 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?

Resources

API resources

Datasets