Difference between revisions of "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
Jump to: navigation, search
(→‎Components)
(→‎Table Composition)
Line 12: Line 12:
 
<table bgcolor=white border=.1><tr><td colspan=39><b>CountyParcels</b></td></tr>
 
<table bgcolor=white border=.1><tr><td colspan=39><b>CountyParcels</b></td></tr>
 
<tr><td>target</td><td bgcolor=#00cc33>OBJECTID_1</td><td bgcolor=#00cc33>OBJECTID</td><td bgcolor=#00cc33>ABSTORSUBN</td><td bgcolor=#00cc33>ABSTORSU_1</td><td bgcolor=#00cc33>PROP_ID</td><td bgcolor=#00cc33>PROP_TYPE_</td><td bgcolor=#00cc33>BLOCK</td><td bgcolor=#00cc33>LOT</td><td bgcolor=#00cc33>LAND_SQFT</td><td bgcolor=#00cc33>LIVINGAREA</td><td bgcolor=#00cc33>EXEMPTION</td><td bgcolor=#00cc33>PROPERTY</td><td bgcolor=#00cc33>SITUS</td><td bgcolor=#00cc33>OWNER_NAME</td><td bgcolor=#00cc33>ADDR_LINE1</td><td bgcolor=#00cc33>ADDR_LINE2</td><td bgcolor=#00cc33>ADDR_LINE3</td><td bgcolor=#00cc33>CITY</td><td bgcolor=#00cc33>STATE</td><td bgcolor=#00cc33>ZIP</td><td bgcolor=#00cc33>LEGAL_DESC</td><td bgcolor=#00cc33>STATE_CD</td><td bgcolor=#00cc33>CD_DESCRIP</td><td bgcolor=#00cc33>TAXENTITY</td><td bgcolor=#00cc33>SITUS_PREF</td><td bgcolor=#00cc33>SITUS_NUM</td><td bgcolor=#ccffcc>SITUS_ST</td><td bgcolor=#00cc33>SITUS_SUFI</td><td bgcolor=#00cc33>YR_BLT</td><td bgcolor=#00cc33>AG_MARKET</td><td bgcolor=#00cc33>APPRAISED_</td><td bgcolor=#00cc33>AG_USE_VAL</td><td bgcolor=#ccffcc>ROLL_ASSD</td><td bgcolor=#ccffcc>T_IMPROVE</td><td bgcolor=#ccffcc>TOTALLAND</td><td bgcolor=#ccffcc>TOTAL_PROP</td><td bgcolor=#00cc33>Shape_area</td><td bgcolor=#00cc33>Shape_len</td></tr>
 
<tr><td>target</td><td bgcolor=#00cc33>OBJECTID_1</td><td bgcolor=#00cc33>OBJECTID</td><td bgcolor=#00cc33>ABSTORSUBN</td><td bgcolor=#00cc33>ABSTORSU_1</td><td bgcolor=#00cc33>PROP_ID</td><td bgcolor=#00cc33>PROP_TYPE_</td><td bgcolor=#00cc33>BLOCK</td><td bgcolor=#00cc33>LOT</td><td bgcolor=#00cc33>LAND_SQFT</td><td bgcolor=#00cc33>LIVINGAREA</td><td bgcolor=#00cc33>EXEMPTION</td><td bgcolor=#00cc33>PROPERTY</td><td bgcolor=#00cc33>SITUS</td><td bgcolor=#00cc33>OWNER_NAME</td><td bgcolor=#00cc33>ADDR_LINE1</td><td bgcolor=#00cc33>ADDR_LINE2</td><td bgcolor=#00cc33>ADDR_LINE3</td><td bgcolor=#00cc33>CITY</td><td bgcolor=#00cc33>STATE</td><td bgcolor=#00cc33>ZIP</td><td bgcolor=#00cc33>LEGAL_DESC</td><td bgcolor=#00cc33>STATE_CD</td><td bgcolor=#00cc33>CD_DESCRIP</td><td bgcolor=#00cc33>TAXENTITY</td><td bgcolor=#00cc33>SITUS_PREF</td><td bgcolor=#00cc33>SITUS_NUM</td><td bgcolor=#ccffcc>SITUS_ST</td><td bgcolor=#00cc33>SITUS_SUFI</td><td bgcolor=#00cc33>YR_BLT</td><td bgcolor=#00cc33>AG_MARKET</td><td bgcolor=#00cc33>APPRAISED_</td><td bgcolor=#00cc33>AG_USE_VAL</td><td bgcolor=#ccffcc>ROLL_ASSD</td><td bgcolor=#ccffcc>T_IMPROVE</td><td bgcolor=#ccffcc>TOTALLAND</td><td bgcolor=#ccffcc>TOTAL_PROP</td><td bgcolor=#00cc33>Shape_area</td><td bgcolor=#00cc33>Shape_len</td></tr>
−
<tr><td></td><td>1</td><td>1</td><td>SL0802A</td><td>THE HIGHLANDS PH 4</td><td>236721</td><td>R</td><td>Z</td><td>12.00000</td><td>13328.00000</td><td>1794.00000</td><td>HS, OV65</td><td>R236721</td><td>2021 WOLF CREEK</td><td>GOURLIE, RONALD A & CONNIE M</td><td></td><td>2021 WOLF CREEK PASS</td><td></td><td>LEWISVILLE</td><td>TX</td><td>75077-7546</td><td>THE HIGHLANDS PH 4 BLK Z LOT 12</td><td>A1</td><td>Single Family</td><td>C12, CAD, G01, S09</td><td>2021</td><td>WOLF CREEK</td><td>PASS</td><td>2004.00000</td><td>0.00000</td><td>187600.00000</td><td>0.00000</td><td>184232.00000</td><td>137463.00000</td><td>50137.00000</td><td>187600.00000</td><td>13193.84953020000</td><td>456.78393052800</td></tr>
+
<tr><td></td><td>1</td><td>1</td><td>SL0802A</td><td>THE HIGHLANDS PH 4</td><td>236721</td><td>R</td><td>Z</td><td>12</td><td>13328</td><td>1794</td><td>HS, OV65</td><td>R236721</td><td>2021 WOLF CREEK</td><td>GOURLIE, RONALD A & CONNIE M</td><td></td><td>2021 WOLF CREEK PASS</td><td></td><td>LEWISVILLE</td><td>TX</td><td>75077-7546</td><td>THE HIGHLANDS PH 4 BLK Z LOT 12</td><td>A1</td><td>Single Family</td><td>C12, CAD, G01, S09</td><td></td><td>2021</td><td>WOLF CREEK</td><td>PASS</td><td>2004</td><td>0</td><td>187600</td><td>0</td><td>184232</td><td>137463</td><td>50137</td><td>187600</td><td>13193.84953</td><td>456.78393</td></tr>
 
<tr><td colspan=39><b>Parcel Shapefile</b></td></tr>
 
<tr><td colspan=39><b>Parcel Shapefile</b></td></tr>
 
<tr><td>source</td><td bgcolor=#00cc33>OBJECTID_1</td><td bgcolor=#00cc33>OBJECTID</td><td bgcolor=#00cc33>ABSTORSUBN</td><td bgcolor=#00cc33>ABSTORSU_1</td><td bgcolor=#00cc33>PROP_ID</td><td colspan=31><td bgcolor=#00cc33>Shape_area</td><td bgcolor=#00cc33>Shape_len</td></tr>
 
<tr><td>source</td><td bgcolor=#00cc33>OBJECTID_1</td><td bgcolor=#00cc33>OBJECTID</td><td bgcolor=#00cc33>ABSTORSUBN</td><td bgcolor=#00cc33>ABSTORSU_1</td><td bgcolor=#00cc33>PROP_ID</td><td colspan=31><td bgcolor=#00cc33>Shape_area</td><td bgcolor=#00cc33>Shape_len</td></tr>

Revision as of 22:50, 6 December 2012

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 4236721RZ12133281794HS, OV65R2367212021 WOLF CREEKGOURLIE, RONALD A & CONNIE M2021 WOLF CREEK PASSLEWISVILLETX75077-7546THE HIGHLANDS PH 4 BLK Z LOT 12A1Single FamilyC12, CAD, G01, S092021WOLF CREEKPASS2004018760001842321374635013718760013193.84953456.78393
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]
Retrieved from "http://dogtato.net/giswiki/index.php?title=CountyParcels&oldid=5"