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

Revision as of 16:58, 25 April 2015

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)

Example 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

Resources

API resources

filtering results
dealing with timestamps
http://dev.socrata.com/docs/queries.html writing API queries]

Datasets

@@ Line 20: / Line 20: @@
 (Estimated time: 10 minutes)
-=== Example topics to cover in Lecture ===
+=== Example topics to cover ===
 * 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
-* introduce the [https://en.wikipedia.org/wiki/Special:ApiSandbox API sandbox] as a tool for building queries
+* introduce the [https://www.hurl.it API sandbox] as a tool for building queries
-* looking at the images within a page http://en.wikipedia.org/w/api.php?action=query&titles=Seattle&prop=images&imlimit=20&format=jsonfm
-* change the city with a custom URL
-* edit count http://en.wikipedia.org/w/api.php?action=query&list=users&ususers=Benjamin_Mako_Hill|Jtmorgan|Sj|Mindspillage&usprop=editcount&format=jsonfm
-* get the content of the main page http://en.wikipedia.org/w/api.php?format=json&action=query&titles=Main%20Page&prop=revisions&rvprop=content
-* example programs: [http://mako.cc/teaching/2014/cdsw-autumn/wikipedia-raw1-unicode-problems-example.py wikipedia-raw1-unicode-problems-example.py] (note: this is an example of Unicode problems when running this on Windows), [http://mako.cc/teaching/2014/cdsw-autumn/wikipedia-raw2-mudslide-edit.py wikipedia-raw2-mudslide-edit.py]
 === Resources ===
-* [https://en.wikipedia.org/w/api.php?action=help&modules=query API documentation for the query module]
+* [https://www.hurl.it API Sandbox]
-* [https://en.wikipedia.org/wiki/Special:ApiSandbox API Sandbox]
+* [http://web6.seattle.gov/mnm/ API-powered app]
-* [[Sample API queries]]
+[http://dev.socrata.com/consumers/getting-started.htm API resources]
-* Example that saves command-line output into a text file: <code>python wikipedia-raw2-mudslide-edit.py > OsoRevisionData.txt</code>
+*[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/queries.html writing API queries]
+;Datasets
+*[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]