Socrata Provider for Koop
This provider makes it possible to access Socrata's JSON API as either GeoJSON or an Esri FeatureService. This is particularly useful for making maps and doing analysis on the web.
To use this provider you first need a working installation of Koop. Then from within the koop directory you'll need to run the following:
npm install koop-socrata --save
koop-socrata needs to be registered as a provider in your Koop app in order to work.
var socrata =koop
If you are using Postgres you will need to then create a database and enable Postgis
createdb kooppsql -d "koop" -c "create extension postgis;"
Once that's done you can restart your server and the Socrata routes will be available.
If you're using the
koop-sample-app template, you can start the server like this:
Once this provider's been installed you need to register a particular instance of Socrata with your Koop instance. To do this you make
POST request to the
/socrata endpoint like so:
curl --data "host=" localhost:1337/socrata
for Windows users, download cURL from http://curl.haxx.se/download.html or use a tool of your choice to generate the POST request
What you'll need for that request to work is an ID and the URL of the Socrata instance. The ID is what you'll use to reference datasets that come from Socrata in Koop.
To make sure this works you can visit: http://localhost:1337/socrata and you should see all of the registered hosts.
Socrata allows 1,000 requests per rolling hour period if you have an app key. If not, there is no guarantee of the number of queries you can make. It is strongly recommended to include an app token if you plan to run Koop-Socrata in production. See:
To access a dataset hosted in Socrata you'll need a "Resource ID" from Socrata. Datasets in Socrata can be accessed as raw JSON like this:
And then the ID
fwm6-d78i can be referenced in Koop like so:
If your Socrata data has more than one location column, you can specify the desired location column in the http request like this:
Koop-Socrata will page through large datasets to gather all the rows. The default is set to 10,000 rows per request, but the Socrata API handles up to 50,000 requests very well. For production deployments it is recommended to set the Koop Configuration for the Socrata page limit to 50,000.
If you find yourself in a situation where Koop isn't returning data for a particular resource and you'd like to make sure it makes a fresh request, you can blow out the cobwebs by making the following request in the browser.
Here are a few examples of data hosted in Socrata and accessed via Koop.
Esri welcomes contributions from anyone and everyone. Please see our guidelines for contributing.