Data dictionary for legacy CCAO data and variables

NOTE: This dictionary is deprecated for any processes that use current CCAO data infrastructure. Use vars_dict for the most up-to-date dictionary.

vars_dict_legacy

Format

A data frame with 202 rows and 14 variables:

var_name_sql

Column name of variable as stored in CCAO SQL servers

var_name_addchars

Column name of variable when stored in the ADDCHARS SQL table

var_name_socrata

Column name used for the Cook County Data Portal

var_name_standard

Column name used for flat files, open data, and modeling

var_name_pretty

Human-readable column name used for publication

var_type

Variable type: meta = identifying information; char = characteristics retrieved from SQL; time = calculated time variable; ind = calculated logical/indicator variable; econ = calculated economic information; geo = attached/calculated geographic information

var_data_type

R data type variable values should be stored as

var_is_published

Logical value indicating whether to publish in open data

var_is_clustered

Logical value indicating whether to use variable in comparables clustering algorithm

var_is_predictor

Logical value indicating whether to use variable in modeling on the right-hand side. Left-hand side is always sale price

var_code

Factor value for categorical variable. These are the values stored in the AS/400

var_value

Human-readable translation of factor value

var_value_short

Human-readable translation of factor value, but as short as possible

var_notes

Field descriptions and caveats

Source

This dictionary was manually created from paper forms as a translation of numeric variables. char_value_short is the equivalent of what is used on the AS/400 property info screens

Details

A crosswalk of CCAO variable names used in SQL, modeling, and open data. Also includes a translation of numeric character codes to their human-readable value (ROOF_CNST = 1 becomes ROOF_CNST = Shingle/Asphalt).