Seattle open data

From CommunityData
Revision as of 20:56, 13 February 2020 by Jtmorgan (talk | contribs)

In this project, we will explore a few ways to gather data from 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!

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

Goals

  • Learn how to gather datasets from data.seattle.gov with the Socrata API and the Open Data Portal
  • Identify interesting datasets and research questions that can be asked and answered with those datasets
  • 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

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

  1. Click the following link and save the file to your Desktop directory: TODOLINK
  2. Unzip FIXME.zip file

Test the Seattle open data project

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