Provides easier interaction with Socrata open data portals http://dev.socrata.com. Users can provide a 'Socrata' data set resource URL, or a 'Socrata' Open Data API (SoDA) web query, or a 'Socrata' "human-friendly" URL, returns an R data frame. Converts dates to 'POSIX' format. Manages throttling by 'Socrata'.
Use Pentaho's open source data integration tool (Kettle) to create Extract-Transform-Load (ETL) processes to update a Socrata open data portal. Documentation is available at http://open-data-etl-utility-kit.readthedocs.io/en/stable
The Melbourne Open Data Playground GitHub community page is a part of the Melbourne Open Data Playground (MOP), an industry capstone project sponsored by Deakin University for the City of Melbourne.
Currently, the ReadSocrata procedure does not provide informative error messages, particularly messages for when the calls to the Socrata API don't return a 200 response code.
This tutorial demonstrates how to use sodapy and provides examples of querying data using Socrata Query Language or SoQL. The data set analyzed is 311 Service Requests from 2010 to Present from NYC Open Data.
The Sustainable Green Infrastructure Monitoring (SGIM) project uses sensors, provided by Opti, that measures water diverted into the ground. This repo contains the ETL code which updates Chicago's open data portal. It can be reused to connect Opti sensors to Socrata open data portals. Depends on the "open-data-etl-utility-kit" repo.
KnockoutJS Map Project for Udacity FEND program. This map shows the locations and information of the lots of the International Parking Management company.
Currently, the
ReadSocrataprocedure does not provide informative error messages, particularly messages for when the calls to the Socrata API don't return a200response code.Can you update
ReadSocrataerror handling to account for the following response codes?https://dev.socrata.com/docs/response-codes.html