Make Ingest Work With Open Data
There are currently two options to select data for the modeling sandbox:
label: "Where would you like to pull data from?"
choices:
- SQL Server (Needed if modeling townships different from last time)
- Data Saved Locally (Faster)
Please add a third option: "Cook County Open Data Portal"
I have included a placeholder for this option:
if (database == 3) {
stop("This feature is not currently available.")
# PULL SALES DATA FROM SOCRATA
# RENAME COLUMNS USING A CROSSWALK
}
For renaming variables, please create a .csv crosswalk from the Socrata names to the names we use in the pipeline. This will allow us to easily update this crosswalk in the future. Save the crosswalk in data.dictionary.constituents.
Edited by Robert Ross