Description: This feature class is utilized by Tyler's Energov system. It contains the property boundaries of the certified tax roll from the Collin County Appraisal District (CCAD). A script runs every Friday that updates this feature class with the certified geometry and attributes from CCAD data.Field NameDescriptionprop_idProperty ID (key#)geo_idGeographic IDfile_as_nameProperty Owner Namepct_ownershipProperty Owner Percentage of Ownershipdba_name"Doing Business As" Nameaddr_line1Mailing Address Line 1 / Additional Owner Nameaddr_line2Mailing Address Line 2addr_line3Mailing Address Line 3addr_cityMailing Address Cityaddr_stateMailing Address Stateaddr_zipMailing Address Zip Codeml_deliverableMail Deliverable to Address Indicator (y/n)abs_subdv_cdCCAD Abstract / Subdivision Codeabs_subdv_refCCAD Reference Number of Scanned Plat Imageabs_subdv_descAbstract / Subdivision NameblockSubdivision Block Numbertract_or_lotAbstract Tract / Subdivision Lot Numberlegal_descProperty Legal Descriptionlegal_desc_2Additional Property Legal Description (notes)mapscoDallas and/or Collin Grayson Mapsco IDcondo_pctCondominium Common Area Interest Percentagesitus_numProperty Address Bldg/House Numbersitus_street_prefxProperty Address Street Prefixsitus_streetProperty Address Street Namesitus_street_sufixProperty Address Street Suffixsitus_cityProperty Address Citysitus_stateProperty Address Statesitus_zipProperty Address Zip Codesitus_displayProperty Address Display (1 line address)cityCity Taxing EntityschoolSchool Taxing EntitytifTax Increment Finance Zone/District (aka TIRZ or Reinvestment Zone)exemptionsExemptions (current exemptions on property, see "exemption code" list)all_entitiesTaxing Entities (current entities on property, see "entity code" list)deed_book_idCounty Clerk Deed Book ID (most recent)deed_book_pageCounty Clerk Deed Page Number (most recent)deed_numCounty Clerk Instrument Number (most recent)deed_dtDeed Effective Date (most recent)deed_type_cdCCAD Deed Type Code (internal CAD use)legal_acreageProperty Legal Acreage (per deed/plat)eff_size_acresProperty Effective/Useable Acreageland_sqft(DO NOT USE)land_total_sqftTotal Land Area in Square Feetliving_areaImprovement Main Area SqFt Total (of all bldgs)state_cdState Property Classification Code (see "state code" list)class_cdCCAD Improvement Classification Code (internal CAD use)property_use_cdProperty Use Code (see "property use code" list)prop_type_cdProperty Type Code (R=Residential, P=Business Personal Property, MH=Manufactured Home, MN=Mineral)commercial_flagCommercial Property Indicator (t/f)eff_yr_bltImprovement/Building Effective Year Built (year used for appraisal of bldg)yr_bltImprovement/Building Actual Year Built (actual year bldg was built)zoningCCAD Property Zoning Code (internal CAD use)land_type_cdLand Type Code (see "land type code" list)bedsNumber of Bedrooms (if data is available; informational only, not used for appraisal)bathsNumber of Bathrooms (if data is available; informational only, not used for appraisal)storiesNumber of Stories (if data is available)unitsNumber of Units (if data is available)percent_completeImprovement/Building Percent Construction CompletepoolPool Indicator (y/n)prop_create_dtAccount Creation Dateproperty_statusCurrent Status of Property Appraisal (InProgress, Preliminary, Certified)curr_val_yrCurrent Appraisal Yearcurr_imprv_hstd_valCurrent Year Improvement Homesite Value (only available during Preliminary status)curr_imprv_non_hstd_valCurrent Year Improvement Non-Homesite Value (only available during Preliminary status)curr_land_hstd_valCurrent Year Land Homesite Value (only available during Preliminary status)curr_land_non_hstd_valCurrent Year Land Non-Homesite Value (only available during Preliminary status)curr_ag_use_valCurrent Year Land Ag Use Value (only available during Preliminary status)curr_ag_marketCurrent Year Land Ag Market Value (only available during Preliminary status)curr_marketCurrent Year Total Market Value (only available during Preliminary status)curr_ag_lossCurrent Year Land Ag Loss Value (only available during Preliminary status)curr_appraised_valCurrent Year Appraised Value (Market - Ag Loss) (only available during Preliminary status)curr_ten_percent_capCurrent Year HS Cap (10% Homestead Limitation) (only available during Preliminary status)curr_assessed_valCurrent Year Assessed Value (Appraised - HS Cap) (only available during Preliminary status)cert_val_yrCertified Appraisal Yearcert_imprv_hstd_valCertified Improvement Homesite Valuecert_imprv_non_hstd_valCertified Improvement Non-Homesite Valuecert_land_hstd_valCertified Land Homesite Valuecert_land_non_hstd_valCertified Land Non-Homesite Valuecert_ag_use_valCertified Land Ag Use Valuecert_ag_marketCertified Land Ag Market Valuecert_marketCertified total Market Valuecert_ag_lossCertified Land Ag Loss Valuecert_appraised_valCertified Appraised Value (Market - Ag Loss)cert_ten_percent_capCertified HS Cap (10% Homestead Limitation)cert_assessed_valCertified Assessed Value (Appraised - HS Cap)parent_yearFirst Year Account was Activeparent_idParent Property ID (acct property was split from)parent_blockParent Property Block Numberparent_tractParent Property Lot/Tract Numberparent_acresParent Property AcreageMetadata updated: 2/2023
GIS_DBO_AD_Entity_land_type_cd
(
type: esriFieldTypeString, alias: Land Type Code (see "land type code" list), length: 10
)
GIS_DBO_AD_Entity_beds
(
type: esriFieldTypeString, alias: Number of Bedrooms (if data is available; informational only, not used for appraisal), length: 20
)
GIS_DBO_AD_Entity_baths
(
type: esriFieldTypeString, alias: Number of Bathrooms (if data is available; informational only, not used for appraisal), length: 20
)
GIS_DBO_AD_Entity_stories
(
type: esriFieldTypeInteger, alias: Number of Stories (if data is available)
)
GIS_DBO_AD_Entity_units
(
type: esriFieldTypeInteger, alias: Number of Units (if data is available)
)
GIS_DBO_AD_Entity_percent_compl
(
type: esriFieldTypeDouble, alias: Improvement/Building Percent Construction Complete
)
GIS_DBO_AD_Entity_property_stat
(
type: esriFieldTypeString, alias: Current Status of Property Appraisal (InProgress, Preliminary, Certified), length: 50
)
GIS_DBO_AD_Entity_curr_val_yr
(
type: esriFieldTypeSmallInteger, alias: Current Appraisal Year
)
GIS_DBO_AD_Entity_curr_imprv_hs
(
type: esriFieldTypeDouble, alias: Current Year Improvement Homesite Value (only available during Preliminary status)
)
GIS_DBO_AD_Entity_curr_imprv_no
(
type: esriFieldTypeDouble, alias: Current Year Improvement Non-Homesite Value (only available during Preliminary status)
)
GIS_DBO_AD_Entity_curr_land_hst
(
type: esriFieldTypeDouble, alias: Current Year Land Homesite Value (only available during Preliminary status)
)
GIS_DBO_AD_Entity_curr_land_non
(
type: esriFieldTypeDouble, alias: Current Year Land Non-Homesite Value (only available during Preliminary status)
)
GIS_DBO_AD_Entity_curr_ag_use_v
(
type: esriFieldTypeDouble, alias: Current Year Land Ag Use Value (only available during Preliminary status)
)
GIS_DBO_AD_Entity_curr_ag_marke
(
type: esriFieldTypeDouble, alias: Current Year Land Ag Market Value (only available during Preliminary status)
)
GIS_DBO_AD_Entity_curr_market
(
type: esriFieldTypeDouble, alias: Current Year Total Market Value (only available during Preliminary status)
)
GIS_DBO_AD_Entity_curr_ag_loss
(
type: esriFieldTypeDouble, alias: Current Year Land Ag Loss Value (only available during Preliminary status)
)
GIS_DBO_AD_Entity_curr_appraise
(
type: esriFieldTypeDouble, alias: Current Year Appraised Value (Market - Ag Loss) (only available during Preliminary status)
)
GIS_DBO_AD_Entity_curr_ten_perc
(
type: esriFieldTypeDouble, alias: Current Year HS Cap (10% Homestead Limitation) (only available during Preliminary status)
)
GIS_DBO_AD_Entity_curr_assessed
(
type: esriFieldTypeDouble, alias: Current Year Assessed Value (Appraised - HS Cap) (only available during Preliminary status)
)