Import data from Socrata into Datasette
Install this plugin in the same environment as Datasette.
datasette install datasette-socrata
Make sure you have enabled WAL mode on your database files before using this plugin.
Once installed, an interface for importing data from Socrata will become available at this URL:
Users will be able to paste in a URL to a dataset on Socrata in order to initialize an import.
You can also pre-fill the form by passing a
?url= parameter, for example:
Any database that is attached to Datasette, is NOT loaded as immutable (with the
-i option) and that has WAL mode enabled will be available for users to import data into.
import-socrata permission governs access. By default the
root actor (accessible using
datasette --root to start Datasette) is granted that permission.
You can use permission plugins such as datasette-permissions-sql to grant additional access to other users.
If you only want Socrata imports to be allowed to a specific database, you can configure that using plugin configration in
plugins: datasette-socrata: database: socrata
To set up this plugin locally, first checkout the code. Then create a new virtual environment:
cd datasette-socrata python3 -m venv venv source venv/bin/activate
Now install the dependencies and test dependencies:
pip install -e '.[test]'
To run the tests: