Name: CCAD Tax Parcels
Display Field: GIS_DBO_AD_Entity_file_as_name
Type: Feature Layer
Geometry Type: esriGeometryPolygon
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
Service Item Id: 8e2b9246198f416ab173dba06f39436c
Copyright Text: Collin County Appraisal District
Default Visibility: false
MaxRecordCount: 2000
Supported Query Formats: JSON, geoJSON, PBF
Min Scale: 0
Max Scale: 0
Supports Advanced Queries: true
Supports Statistics: true
Has Labels: false
Can Modify Layer: true
Can Scale Symbols: false
Use Standardized Queries: true
Supports Datum Transformation: true
Extent:
XMin: 2470571.3604077995
YMin: 7046135.464490235
XMax: 2645327.1654230505
YMax: 7199275.804534391
Spatial Reference: 102738
(2276)
Drawing Info:
Renderer:
Simple Renderer:
Symbol: Style: esriSFSSolid
Color: [130, 130, 130, 0]
Outline:
Style: esriSLSSolid
Color: [76, 230, 0, 255]
Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Type ID Field: null
Fields:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID
)
-
GIS_DBO_Parcel_PROP_ID
(
type: esriFieldTypeInteger, alias: Property ID (key#)
)
-
GIS_DBO_Parcel_GEO_ID
(
type: esriFieldTypeString, alias: Geographic ID, length: 50
)
-
GIS_DBO_Parcel_created_user
(
type: esriFieldTypeString, alias: DBO.Parcel.created_user, length: 255
)
-
GIS_DBO_Parcel_created_date
(
type: esriFieldTypeDate, alias: DBO.Parcel.created_date, length: 8
)
-
GIS_DBO_Parcel_last_edited_user
(
type: esriFieldTypeString, alias: DBO.Parcel.last_edited_user, length: 255
)
-
GIS_DBO_Parcel_last_edited_date
(
type: esriFieldTypeDate, alias: DBO.Parcel.last_edited_date, length: 8
)
-
GIS_DBO_Parcel_GlobalID
(
type: esriFieldTypeGlobalID, alias: DBO.Parcel.GlobalID, length: 38
)
-
GIS_DBO_AD_Entity_prop_id
(
type: esriFieldTypeInteger, alias: DBO.AD_Entity.prop_id
)
-
GIS_DBO_AD_Entity_geo_id
(
type: esriFieldTypeString, alias: DBO.AD_Entity.geo_id, length: 50
)
-
GIS_DBO_AD_Entity_file_as_name
(
type: esriFieldTypeString, alias: Property Owner Name, length: 70
)
-
GIS_DBO_AD_Entity_confidential_
(
type: esriFieldTypeString, alias: Confidential Flag (t/f), length: 1
)
-
GIS_DBO_AD_Entity_pct_ownership
(
type: esriFieldTypeDouble, alias: Property Owner Percentage of Ownership
)
-
GIS_DBO_AD_Entity_dba_name
(
type: esriFieldTypeString, alias: "Doing Business As" Name, length: 50
)
-
GIS_DBO_AD_Entity_addr_line1
(
type: esriFieldTypeString, alias: Mailing Address Line 1 / Additional Owner Name, length: 60
)
-
GIS_DBO_AD_Entity_addr_line2
(
type: esriFieldTypeString, alias: Mailing Address Line 2, length: 60
)
-
GIS_DBO_AD_Entity_addr_line3
(
type: esriFieldTypeString, alias: Mailing Address Line 3, length: 60
)
-
GIS_DBO_AD_Entity_addr_city
(
type: esriFieldTypeString, alias: Mailing Address City, length: 50
)
-
GIS_DBO_AD_Entity_addr_state
(
type: esriFieldTypeString, alias: Mailing Address State, length: 50
)
-
GIS_DBO_AD_Entity_addr_zip
(
type: esriFieldTypeString, alias: Mailing Address Zip Code, length: 10
)
-
GIS_DBO_AD_Entity_ml_deliverabl
(
type: esriFieldTypeString, alias: Mail Deliverable to Address Indicator (y/n), length: 1
)
-
GIS_DBO_AD_Entity_abs_subdv_cd
(
type: esriFieldTypeString, alias: CCAD Abstract / Subdivision Code, length: 10
)
-
GIS_DBO_AD_Entity_abs_subdv_ref
(
type: esriFieldTypeString, alias: CCAD Reference Number of Scanned Plat Image, length: 50
)
-
GIS_DBO_AD_Entity_abs_subdv_des
(
type: esriFieldTypeString, alias: Abstract / Subdivision Name, length: 60
)
-
GIS_DBO_AD_Entity_block
(
type: esriFieldTypeString, alias: Subdivision Block Number, length: 50
)
-
GIS_DBO_AD_Entity_tract_or_lot
(
type: esriFieldTypeString, alias: Abstract Tract / Subdivision Lot Number, length: 50
)
-
GIS_DBO_AD_Entity_legal_desc
(
type: esriFieldTypeString, alias: Property Legal Description, length: 255
)
-
GIS_DBO_AD_Entity_legal_desc_2
(
type: esriFieldTypeString, alias: Additional Property Legal Description (notes), length: 255
)
-
GIS_DBO_AD_Entity_mapsco
(
type: esriFieldTypeString, alias: Dallas and/or Collin Grayson Mapsco ID, length: 20
)
-
GIS_DBO_AD_Entity_udi_parent_pr
(
type: esriFieldTypeInteger, alias: UDI Parent Parcel (DO NOT USE)
)
-
GIS_DBO_AD_Entity_condo_pct
(
type: esriFieldTypeDouble, alias: Condominium Common Area Interest Percentage
)
-
GIS_DBO_AD_Entity_situs_num
(
type: esriFieldTypeString, alias: Property Address Bldg/House Number, length: 15
)
-
GIS_DBO_AD_Entity_situs_street_
(
type: esriFieldTypeString, alias: Property Address Street Prefix, length: 10
)
-
GIS_DBO_AD_Entity_situs_street
(
type: esriFieldTypeString, alias: Property Address Street Name, length: 50
)
-
GIS_DBO_AD_Entity_situs_street1
(
type: esriFieldTypeString, alias: Property Address Street Suffix, length: 10
)
-
GIS_DBO_AD_Entity_situs_city
(
type: esriFieldTypeString, alias: Property Address City, length: 30
)
-
GIS_DBO_AD_Entity_situs_state
(
type: esriFieldTypeString, alias: Property Address State, length: 2
)
-
GIS_DBO_AD_Entity_situs_zip
(
type: esriFieldTypeString, alias: Property Address Zip Code, length: 10
)
-
GIS_DBO_AD_Entity_situs_display
(
type: esriFieldTypeString, alias: Property Address Display (1 line address), length: 141
)
-
GIS_DBO_AD_Entity_city
(
type: esriFieldTypeString, alias: City Taxing Entity, length: 5
)
-
GIS_DBO_AD_Entity_school
(
type: esriFieldTypeString, alias: School Taxing Entity, length: 5
)
-
GIS_DBO_AD_Entity_tif
(
type: esriFieldTypeString, alias: Tax Increment Finance Zone/District (aka TIRZ or Reinvestment Zone), length: 5
)
-
GIS_DBO_AD_Entity_exemptions
(
type: esriFieldTypeString, alias: Exemptions (current exemptions on property, see "exemption code" list), length: 100
)
-
GIS_DBO_AD_Entity_all_entities
(
type: esriFieldTypeString, alias: Taxing Entities (current entities on property, see "entity code" list), length: 100
)
-
GIS_DBO_AD_Entity_deed_book_id
(
type: esriFieldTypeString, alias: County Clerk Deed Book ID (most recent), length: 20
)
-
GIS_DBO_AD_Entity_deed_book_pag
(
type: esriFieldTypeString, alias: County Clerk Deed Page Number (most recent), length: 20
)
-
GIS_DBO_AD_Entity_deed_num
(
type: esriFieldTypeString, alias: County Clerk Instrument Number (most recent), length: 50
)
-
GIS_DBO_AD_Entity_deed_dt
(
type: esriFieldTypeDate, alias: Deed Effective Date (most recent), length: 8
)
-
GIS_DBO_AD_Entity_deed_type_cd
(
type: esriFieldTypeString, alias: CCAD Deed Type Code (internal CAD use), length: 10
)
-
GIS_DBO_AD_Entity_legal_acreage
(
type: esriFieldTypeDouble, alias: Property Legal Acreage (per deed/plat)
)
-
GIS_DBO_AD_Entity_eff_size_acre
(
type: esriFieldTypeDouble, alias: Property Effective/Useable Acreage
)
-
GIS_DBO_AD_Entity_land_sqft
(
type: esriFieldTypeDouble, alias: Land sqft (DO NOT USE)
)
-
GIS_DBO_AD_Entity_land_total_sq
(
type: esriFieldTypeDouble, alias: Total Land Area in Square Feet
)
-
GIS_DBO_AD_Entity_living_area
(
type: esriFieldTypeDouble, alias: Improvement Main Area SqFt Total (of all bldgs)
)
-
GIS_DBO_AD_Entity_hood_cd
(
type: esriFieldTypeString, alias: Hood CD (DO NOT USE), length: 10
)
-
GIS_DBO_AD_Entity_state_cd
(
type: esriFieldTypeString, alias: State Property Classification Code (see "state code" list), length: 10
)
-
GIS_DBO_AD_Entity_class_cd
(
type: esriFieldTypeString, alias: CCAD Improvement Classification Code (internal CAD use), length: 10
)
-
GIS_DBO_AD_Entity_property_use_
(
type: esriFieldTypeString, alias: Property Use Code (see "property use code" list), length: 10
)
-
GIS_DBO_AD_Entity_prop_type_cd
(
type: esriFieldTypeString, alias: Property Type Code (R=Residential, P=Business Personal Property, MH=Manufactured Home, MN=Mineral), length: 5
)
-
GIS_DBO_AD_Entity_commercial_fl
(
type: esriFieldTypeString, alias: Commercial Property Indicator (t/f), length: 1
)
-
GIS_DBO_AD_Entity_eff_yr_blt
(
type: esriFieldTypeSmallInteger, alias: Improvement/Building Effective Year Built (year used for appraisal of bldg)
)
-
GIS_DBO_AD_Entity_yr_blt
(
type: esriFieldTypeSmallInteger, alias: Improvement/Building Actual Year Built (actual year bldg was built)
)
-
GIS_DBO_AD_Entity_zoning
(
type: esriFieldTypeString, alias: CCAD Property Zoning Code (internal CAD use), length: 50
)
-
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_pool
(
type: esriFieldTypeString, alias: Pool Indicator (y/n), length: 1
)
-
GIS_DBO_AD_Entity_prop_create_d
(
type: esriFieldTypeDate, alias: Account Creation Date, length: 8
)
-
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)
)
-
GIS_DBO_AD_Entity_cert_val_yr
(
type: esriFieldTypeSmallInteger, alias: DBO.AD_Entity.cert_val_yr
)
-
GIS_DBO_AD_Entity_cert_imprv_hs
(
type: esriFieldTypeDouble, alias: Certified Improvement Homesite Value
)
-
GIS_DBO_AD_Entity_cert_imprv_no
(
type: esriFieldTypeDouble, alias: Certified Improvement Non-Homesite Value
)
-
GIS_DBO_AD_Entity_cert_land_hst
(
type: esriFieldTypeDouble, alias: Certified Land Homesite Value
)
-
GIS_DBO_AD_Entity_cert_land_non
(
type: esriFieldTypeDouble, alias: Certified Land Non-Homesite Value
)
-
GIS_DBO_AD_Entity_cert_ag_use_v
(
type: esriFieldTypeDouble, alias: Certified Land Ag Use Value
)
-
GIS_DBO_AD_Entity_cert_ag_marke
(
type: esriFieldTypeDouble, alias: Certified Land Ag Market Value
)
-
GIS_DBO_AD_Entity_cert_market
(
type: esriFieldTypeDouble, alias: Certified total Market Value
)
-
GIS_DBO_AD_Entity_cert_ag_loss
(
type: esriFieldTypeDouble, alias: Certified Land Ag Loss Value
)
-
GIS_DBO_AD_Entity_cert_appraise
(
type: esriFieldTypeDouble, alias: Certified Appraised Value (Market - Ag Loss)
)
-
GIS_DBO_AD_Entity_cert_ten_perc
(
type: esriFieldTypeDouble, alias: Certified HS Cap (10% Homestead Limitation)
)
-
GIS_DBO_AD_Entity_cert_assessed
(
type: esriFieldTypeDouble, alias: Certified Assessed Value (Appraised - HS Cap)
)
-
GIS_DBO_AD_Entity_parent_year
(
type: esriFieldTypeSmallInteger, alias: First Year Account was Active
)
-
GIS_DBO_AD_Entity_parent_id
(
type: esriFieldTypeInteger, alias: Parent Property ID (acct property was split from)
)
-
GIS_DBO_AD_Entity_parent_block
(
type: esriFieldTypeString, alias: Parent Property Block Number, length: 50
)
-
GIS_DBO_AD_Entity_parent_tract
(
type: esriFieldTypeString, alias: Parent Property Lot/Tract Number, length: 50
)
-
GIS_DBO_AD_Entity_parent_acres
(
type: esriFieldTypeDouble, alias: Parent Property Acreage
)
-
Shape
(
type: esriFieldTypeGeometry, alias: Shape
)
-
Shape.STArea()
(
type: esriFieldTypeDouble, alias: Shape.STArea()
)
-
Shape.STLength()
(
type: esriFieldTypeDouble, alias: Shape.STLength()
)
Supported Operations:
Query
Query Attachments
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata