To help you get started with your ETL project, we've provided these helpful templates, pre-built workflows, and guides for a number of different platforms. If you have code, Safe FME workflows, or guides that you think others might find useful please consider contributing them!
To help you get started, we've also provided a number of pre-built ETL templates for common use cases. Starting from these templates, you can build out your own self-hosted workflows customized to your particular needs.
NOTE: these are Safe FME templates. Find more information on getting started with FME and Socrata here.
Extracts data from an ArcGIS Online and publishes it to Socrata.
Extracts data from an ArcGIS Server endpoint (Esri-JSON) and publishes it to Socrata.
Reads data from a CSV, transform date from dd/mm/yyyy to yyyy/mm/dd, reproject X/Y to Lat/Lon and publish the result as a Socrata.
Allows publishing data from a Kana LAGAN system to Socrata in the schemea needed for the ServiceConnect app.
Extracts data from an Open311 HTTP endpoint and publishes to Socrata.
Pulls data from the See Click Fix API and publishes to Socrata dataset
Shows how to publish data from a shapefile to a Socrata dataset, including optionally filtering by geometry type.
Reads data from an existing Socrata dataset, transform the data, and publish the result to another Socrata dataset.
NOTE: these are Pentaho workflows. Find more information on getting started with Pentaho here.
Reads data from 1 csv, pivots columns to rows and other transformations then publishes to Socrata.
Reads data from 2 excel (XLS) files of Restaurant and Violation data and transforms the data to meet the LIVES schema into a csv file.
NOTE: these are RSocrata workflows. Find more information on getting started with Rsocrata here.
Reads data from a MySQL database, load data into R as a data.frame, then write to Socrata using RSocrata
Reads data over an ODBC connection, load data into R as a data.frame, then write to Socrata using RSocrata
Reads data from Salesforce instance via API, load data into R as a data.frame, then write to Socrata using RSocrata