Socrata Open Data API (SODA) Tutorial Using NYC Open Data

Author: Mark Bauer

Table of Contents

• Introduction
• Tutorials
• Data
• Additional Resources
  • Socrata Open Data API
  • Sodapy
• Say Hello!

Introduction

This project demonstrates how to:

• Use the Socrata Open Data API
• Use sodapy (i.e. the python client for the Socrata API)

And provides:

• Examples of the Socrata Query Language (also known as SoQL)
• A sample analysis notebook using datasets from NYC Open Data

Inspiration for this project came from the sodapy GitHub page. Much of what I learned about sodapy, as well as working with the Socrata API, came from these developers. I encourage you to review the official sodapy GitHub page to have a better and more complete understanding of sodapy (e.g. installation, requirements, available methods, basic SoQL queries, etc.). This tutorial is meant to complement the official sodapy docs.

Tutorials

• The Socrata Query Language (SoQL) notebook can be found here socrata-query-language.ipynb.
• The sodapy tutorial notebook can be found here sodapy-basics.ipynb.
• A sample analysis notebook can be found here sample-analysis.ipynb.

Data

The dataset used in this project is 311 Service Requests from 2010 to Present from NYC Open Data.

Additional Resources

Socrata Open Data API

The official Socrata Open Data API docs: https://dev.socrata.com/
Queries using SODA: https://dev.socrata.com/docs/queries/

Sodapy

The official sodapy docs: https://github.com/xmunoz/sodapy
PyPI: https://pypi.org/project/sodapy/
Inspiration for this project: https://github.com/xmunoz/sodapy/blob/master/examples/soql_queries.ipynb

Say Hello!

Contact information:
Twitter: markbauerwater
LinkedIn: markebauer
GitHub: mebauer