Editing Community Data Science Workshops (Spring 2015)/Day 2 Projects/Socrata
From CommunityData
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then publish the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 14: | Line 14: | ||
=== Download the Socrata project === | === Download the Socrata project === | ||
<font size="+1">[http:// | <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 ( | 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]] | ||
(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? | ||
* What Seattle neighborhood has the most square feet devoted to arts & culture? | * What Seattle neighborhood has the most square feet devoted to arts & culture? | ||
* Which trail gets more bike traffic per month-- | * 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? | |||
* What day of the week does the Burke Gilman have the most total traffic? | |||
=== 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.htm 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] | ||
;Datasets | ;Datasets | ||
Line 54: | Line 46: | ||
*[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] | ||