Seattle open data: Difference between revisions

Revision as of 21:16, 13 February 2020

In this project, we will gather civic data from data.seattle.gov and use it to ask and answer important questions about the Emerald City!. We will start with a series of analyses of bike and pedestrian traffic patterns on the [1]. We will learn how to collect that data from the Seattle's open data portal's API, filter and transform this data, and create timeseries graphs that show daily, weekly, and yearly traffic trends.

TO FILL IN Jtmorgan (talk) 16:57, 20 January 2020 (EST)

Goals

In this session, we will focus on...

Familiarizing ourselves with a new API
Learn how to pose useful research questions that can be asked and answered with civic data
Learn how to filter, bucket, and format data for building timeseries graphs in a spreadsheet program
Practice reading and extending other people's code

Setup

If you are confused by these steps, go back and refresh your memory with the Day 0 setup and tutorial.

Download the Seattle open data project

Click the following link and save the file to your computer: TODOLINK
Unzip FIXME.zip folder and place the folder in your CDSW working directory (or just your desktop)

Test the Seattle open data API

Test an API call to data.seattle.gov

Open the Jupyter notebook FOO

Run the first X cells in the notebook in order

The output of cell FIXME should be

example output

Test downloading a CSV file and opening it in a notebook

Open FIXMELINK in your browser

CLICK on DOWNLOADBUTTON FIXME

SAVE FIXME.csv to the FIXME directory with your notebooks

OPEN the Juypyter notebook FOO

Run the first X cells of the notebook in order

The output of the cell FIXME should be

example output

Socrata API tutorial

Datasets to explore

External links

@@ Line 1: / Line 1: @@
 [[File:Burke_gilman.jpg|thumb|right|250px|Who's riding on the Burke Gilman trail this week?]]
-In this project, we will explore a few ways to gather data from [https://data.seattle.gov data.seattle.gov]. Once we've done that, we will extend this to code to create our own datasets of civic data that will allow us to ask and answer questions about the Emerald City!
+In this project, we will gather civic data from [https://data.seattle.gov data.seattle.gov] and use it to ask and answer important questions about the Emerald City!. We will start with a series of analyses of bike and pedestrian traffic patterns on the [https://en.wikipedia.org/wiki/Burke-Gilman_Trail]. We will learn how to collect that data from the Seattle's open data portal's API, filter and transform this data, and create timeseries graphs that show daily, weekly, and yearly traffic trends.
 TO FILL IN [[User:Jtmorgan|Jtmorgan]] ([[User talk:Jtmorgan|talk]]) 16:57, 20 January 2020 (EST)
@@ Line 8: / Line 8: @@
 [[File:SeattleGovLogoHome.png|right|250px]]
-* Learn how to gather datasets from data.seattle.gov with the Socrata API and the Open Data Portal
+In this session, we will focus on...
-* Identify interesting datasets and research questions that can be asked and answered with those datasets
+* Familiarizing ourselves with a new API
+* Learn how to pose useful research questions that can be asked and answered with civic data
+* Learn how to filter, bucket, and format data for building timeseries graphs in a spreadsheet program
 * Practice reading and extending other people's code
-* Create a few collections of different types of data from data.seattle.gov that you can do research with in the final section
 == Setup ==
@@ Line 17: / Line 19: @@
 === Download the Seattle open data project ===
-# Click the following link and save the file to your Desktop directory: TODOLINK
+# Click the following link and save the file to your computer: TODOLINK
-# Unzip FIXME.zip file
+# Unzip FIXME.zip folder and place the folder in your CDSW working directory (or just your desktop)
-=== Test the Seattle open data project ===
+=== Test the Seattle open data API ===
 ;Test an API call to data.seattle.gov