Data Dictionary

CROSS_REF The parcel account number

ABSTRACT the abstract number from older parcels

SUP

OVLY Any Overlay Districts the parcel falls in

DBA_NAME Doing Business As - generally for commercial properties

ZONE_CODE1 City of Rockwall Base zoning

ZONE_CODE2 Flood plain (FP-Yes, FP-No)

GENERAL_PL <Null>

PARENT_SIT <Null>

DEFLT_INSP NORTH

HISTORICAL The last account number associated with the parcel

CENSUS

prop_id (from RCAD) The RCAD property ID

owner_tax_yr (from RCAD)<Null>

file_as_name (from RCAD) Owner Name

legal_acreage (from RCAD) acerage

hood_cd (from RCAD) Neighborhood CD

school (from RCAD) SRW

city (from RCAD) CRW (unless in the ETJ)

county (from RCAD) GRW

next_appraisal_dt(from RCAD) <Null>

legal_desc (from RCAD) Legal Description

tract_or_lot (from RCAD) tracks

abs_subdv_cd (from RCAD) Abstract or Subdivision Number

land_val (from RCAD) Land Value

imprv_val (from RCAD) Improvement Value

market (from RCAD) Total land and improvement Value

block (from RCAD) Block

map_id (from RCAD) older ID for parcels from abstracts, for the book and page

geo_id (from RCAD) Account Number from RCAD

situs_num (from RCAD) parcel address number

situs_street_prefx(from RCAD) parcel street prefix

situs_street (from RCAD) parcel street name

situs_street_sufix (from RCAD) parcel street suffix

situs_city (from RCAD) parcel city

situs_state (from RCAD) parcel state

situs_zip (from RCAD) parcel zip code

addr_line1 (from RCAD) owner address line 1

addr_line2 (from RCAD) owner address line 2

addr_line3 (from RCAD) owner address line 3

addr_city (from RCAD) owner city

addr_state (from RCAD) owner state

zip (from RCAD) owner zip code

land_type_cd (from RCAD) Property Use Code/Description

yr_blt (from RCAD) the year improvements were built on the parcel

living_area (from RCAD) Total living area

ag_app_filed (from RCAD)

Hyperlink the link for the property to RCAD's website

ASSETID the asset ID, automatically filled in by the unique ID tool

AGENCY Standard field, not currently used for parcels

LIFECYCLE Standard field, ACTIVE

BUILT STATUS The current Improvement status for the land - BUILT, VACANT

Shape.STArea() 415857.505379

Shape.STLength() 3518.088577

Subdivision Status The current status of the subdivision - COMPLETE, UNDER CONSTRUCTION, ZONED, ESTABLISHED, ETJ