TCAD/WCAD Land Values Data Process

Jurisidiction Layer

• Definition query for only COA Full Purpose

• Select by Location (have their center in)

  • WCAD SVW to jurisdictions

    • Export layer

  • TCAD SVW to jurisdictions

    • Export layer

• TCAD Calculations on new layer

  • Turn of all fields except:

    • PARCEL_ID

    • PROP_ID

    • LAND_HSTD_VAL

    • LAND_NON_HSTD_VAL

    • IMPRV_HSTD_VAL

    • MPRV_NON_HSTD_VAL

    • APPRAISED_VAL

    • ASSESSED_VAL

    • HS_EXEMPT

    • EX_EXEMPT

    • LAND_ACRES

  • Select records where all VALUE fields are null and delete

  • Select records where the land value fields are 0 and delete

    • LAND_HSTD_VAL = 0 and LAND_NON_HSTD_VAL = 0

  • Select records where both the homestead and non-homestead land values are not zero. These records are being removed as the exemption is being applied to a portion of the land/improvement, making it difficult to determine what percentage would be applied

    • LAND_HSTD_VAL <> 0 and LAND_NON_HSTD_VAL <> 0

  • Add new fields for calculations

    • LAND_VALUE_TOTAL (double)

    • ASSE_TO_APPR_VAL_PERCENT (double, numeric: 4 decimal places)

    • LAND_VALUE_PERCENT (double, numeric: 0 decimal places)

    • LAND_ACRES_ACTUAL (double, numeric: 4 decimal places)

    • LAND_SQ_FT (double, numeric: 4 decimal places)

      • based on LAND_ACRES field, not geometry

  • Calculate LAND_VALUE_TOTAL field

    • LAND_HSTD_VAL + LAND_NON_HSTD_VAL

  • Calculate ASSES_TO_APPR_VAL_PERCENT field

    • ASSESSED_VAL / APPRAISED_VAL

  • Calculate LAND_VALUE_PERCENT field

    • LAND_VALUE_TOTAL * ASSES_TO_APPR_VAL_PERCENT

  • Calculate LAND_ACRES_ACTUAL field

    • LAND_ACRES / 10000 (the LAND_ACRES field is not showing actual land acres with the decimal, Matt Leach at WPD verified, double checked on TCAD website looking at parcel land acres)

  • Calculate LAND_SQ_FT field

    • LAND_ACRES * 43560

  • Table to Excel to create export

    • Must create export as .xlsx as there are 64k+ records

• WCAD Calculations

• WCAD Calculations on new layer

  • Turn off all fields except:

    • PARCEL_ID

    • PROP_ID

    • AG_USE_VALUE

    • ASSESSED_VALUE

    • IMP_MKT_VALUE

    • LAND_MKT_VALUE

    • PROPERTY_MARKET_VALUE

  • Select records where Value fields are null and delete

  • Select records where Value fields are 0 and delete

  • Select records where the Ag. Use Value is not zero and delete. There are currently only 14 records in COA FP. These records don’t follow the standard for exemptions, therefore removing them to remove the anomalies.

    • AG_USE_VALUE <> 0

    • Hide this field after deleting records

  • Add new fields for calculations

    • LAND_VALUE_TOTAL (double)

    • ASSE_TO_APPR_VAL_PERCENT (double, numeric: 4 decimal places)

    • LAND_VALUE_PERCENT (double, numeric: 0 decimal places)

    • LAND_SQ_FT (double, numeric: 4 decimal places)

      • based on LAND_ACRES field, not geometry

  • Calculate LAND_VALUE_TOTAL field

    • LAND_MKT_VALUE (adding new field to match TCAD fields)

  • Calculate ASSE_TO_APPR_VAL_PERCENT field

    • ASSESSED_VALUE / PROPERTY_MARKET_VALUE

  • Calculate LAND_VALUE_PERCENT field

    • LAND_VALUE_TOTAL * ASSES_TO_APPR_VAL_PERCENT

  • Calculate LAND_SQ_FT field

    • Calculate geometry to area, square feet, state plane

    • WCAD does not share land acres in data, therefore must use parcel geometry

  • Table to Excel to create export

  • Create export as .xlsx to match the TCAD export