Imputation flags

• _: parcel not subject to geometry aggregation
• merged: parcel subject to geometry aggregation
• restype_flip: built space on parcel subject to a residential type flip from single to multi or vice-versa
• synthetic: parcel is synthetic because no existing parcel existed in taz
• estab_sqft: non-residential sqft imputed based on establishment point
• du_zonetarget: residential unit values manipulated as part of matching the aggregate target
• costar_type: development type imputed based on costar
• redfin_type: development type imputed based on redfin
• rf_yrblt: year-built imputed from Redfin
• rf_sqftunit: sqft_per_unit imputed from Redfin
• cs_yrblt: year-built imputed from Costar
• cs_nrsqft: non-residential sqft imputed from Costar
• cs_stories: Number of stories imputed from Costar
• add_synth_res_bldg: new synthetic residential structure added to meet zonal DU target by type
• add_synth_nonres_bldg: new synthetic non-residential structure added to meet zonal non-residential sqft target
• res_zone_yrblt: Residential building year_built field was null or out-of-bounds: replaced with observed zonal average of reasonable data points
• res_region_yrblt: Residential building year_built field was null or out-of-bounds, and no reasonable values existed in the zone. Applied the regional residential year_built average (this will subsequently be scaled to match the Redfin-based zonal average in hh/tazsumm_redfin.csv)
• nr_zone_yrblt: Non-residential building with out-of-bounds or null year_built- replace with zonal average of reasonable data points
• nr_region_yrblt: Non-residential building year_built field was null or out-of-bounds, and no reasonable values existed in the zone. Applied the regional non-residential year_built average.
• nrsqft_from_bsqft: If observed as a non-residential structure, and non_residential_sqft is zero, but building_sqft is positive, set non_residential_sqft to equal building_sqft
• bsqft_from_nrsqft: If observed as non-residential structure, and no residential units, building_sqft set to equal non_residential_sqft
• cnty_sq_du: If residential building and sqft_per_unit field is null or zero, then set sqft_per_unit to equal county average of reasonable values.
• sq_du_lower_bound: sqft_per_unit below reasonable lower bound, sqft_per_unit set to lower bound
• sq_du_upper_bound: sqft_per_unit above reasonable upper bound, sqft_per_unit set to upper bound
• stories1: building stories is null or less than 1, and n, set to 1
• stories3_cs_elevator: building stories is 1 or fewer, and stories not otherwise imputed, but Costar indicates that an elevator exists- set stories to 3.
• stories_corrected: county-specific fix to stories- manual correction when wrong values noticed (e.g. 99 story building in single-family neighborhood)