CountyParcels


Deprecated: Constant E_STRICT is deprecated in /home/dogtaton/public_html/giswiki/includes/exception/MWExceptionHandler.php on line 179

Deprecated: Creation of dynamic property PPDStack::$accum is deprecated in /home/dogtaton/public_html/giswiki/includes/parser/Preprocessor_DOM.php on line 803

Deprecated: Constant E_STRICT is deprecated in /home/dogtaton/public_html/giswiki/includes/exception/MWExceptionHandler.php on line 179

Deprecated: Constant E_STRICT is deprecated in /home/dogtaton/public_html/giswiki/vendor/mediawiki/at-ease/src/Functions.php on line 48
From GIS Wiki
Revision as of 22:29, 6 December 2012 by 129.120.6.150 (talk) (→‎Table Composition)
Jump to: navigation, search

The CountyParcels layer is assembled using data from DCAD.

Components

From DCADs GIS Downloads page

  • Denton County Parcels Map (shapefile)
  • GIS DCAD Data

Then contact J.M. for the situs info and property value tables.

Table Composition

CountyParcels
targetOBJECTID_1OBJECTIDABSTORSUBNABSTORSU_1PROP_IDPROP_TYPE_BLOCKLOTLAND_SQFTLIVINGAREAEXEMPTIONPROPERTYSITUSOWNER_NAMEADDR_LINE1ADDR_LINE2ADDR_LINE3CITYSTATEZIPLEGAL_DESCSTATE_CDCD_DESCRIPTAXENTITYSITUS_PREFSITUS_NUMSITUS_STSITUS_SUFIYR_BLTAG_MARKETAPPRAISED_AG_USE_VALROLL_ASSDT_IMPROVETOTALLANDTOTAL_PROPShape_areaShape_len
11SL0802ATHE HIGHLANDS PH 4236721RZ12.0000013328.000001794.00000HS, OV65R2367212021 WOLF CREEKGOURLIE, RONALD A & CONNIE M2021 WOLF CREEK PASSLEWISVILLETX75077-7546THE HIGHLANDS PH 4 BLK Z LOT 12A1Single FamilyC12, CAD, G01, S092021WOLF CREEKPASS2004.000000.00000187600.000000.00000184232.00000137463.0000050137.00000187600.0000013193.84953020000456.78393052800
Parcel Shapefile
sourceOBJECTID_1OBJECTIDABSTORSUBNABSTORSU_1PROP_IDShape_areaShape_len
DCAD Data
join PROP_IDPROP_IDPROP_TYPEBLOCKLOTLAND_SQFTLIVINGAREAEXEMPTIONSITUSOWNER_NAMEADDR_LINE1ADDR_LINE2ADDR_LINE3CITYSTATEZIPLEGAL_DESCSTATE_CDTAXENTITYLAND_TYPEYR_BLT
TONYSMIT
join PROP_IDDISPLAYPROP_IDFILE_AS_NAADDR_LINE1ADDR_LINE2ADDR_LINE3ADDR_CITYADDR_STATELEGAL_DESCSTATE_CDENTITYCODESITUS_PREFSITUS_NUMSITUS_STRESITUS_SUFIYR_BLT
VALUESIMPRV_HSTDLAND_HSTD_
join PROP_IDPROP_IDAG_MARKETAPPRAISED_AG_USE_VALASSESSED_VIMPRV_NON_LAND_NON_HMARKETTIMBER_MARTIMBER_USE
state-codes-3
join STATE_CDSTATE_CDCD_DESCRIP
Other sourcecalc from PROP_ID
Legenddirect matchpartial matchunneeded


T_IMPROVE and TOTTALLAND are calculated by "IMPRV_HSTD + IMPRV_NON_" and "LAND_HSTD_ + LAND_NON_H", respectively.
SITUS_STRE is changed to SITUS_ST.
PROPERTY is calculated with the following input to Field Calculator:

Pre-Logic Script Code:

tval = Len ( [PROP_ID] )
if tval > 4 then rval = "R"
elseif tval > 3 then rval = "R0"
elseif tval > 2 then rval = "R00"
else rval = "R000"
end if

PROPERTY =
rval& [PROP_ID]