20191127
11222900
1.0
FALSE
CreateFeatureclass P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing TaxParcel Polygon P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191104_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel No No "{B286C06B-0879-11D2-AACA-00C04FA33C20};-450359962737.049 -450359962737.049 10000;#;#;0.001;#;#;IsHighPrecision" # 0 0 0 #
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.4.0'><FeatureDataset>ParcelPublishing</FeatureDataset><WorkspaceConnectionString>DATABASE=P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>TaxParcel</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>TEMP_UNIQUE</field_name></DeleteField></workflow></operationSequence>
Copy "P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\TaxParcel " P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_1 FeatureClass #
Rename P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_1 P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder FeatureClass
FeatureClassToFeatureClass P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing TaxParcel_Reorder0 # "PARCELID "Parcel Identification Number" true true false 30 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,PARCELID,-1,-1;LOWPARCELID "Lowest Parcel Identification Number" true true false 30 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,LOWPARCELID,-1,-1;SITEADDRESS "Site Address" true true false 255 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,SITEADDRESS,-1,-1;SITECTSTZP "SITECTSTZP" true true false 32 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,SITECTSTZP,-1,-1;OWNERNME1 "First Owner Name" true true false 255 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,OWNERNME1,-1,-1;OWNERNME2 "Second Owner Name" true true false 255 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,OWNERNME2,-1,-1;PSTLADDRESS "Postal Address" true true false 255 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,PSTLADDRESS,-1,-1;PSTLCITY "Postal City" true true false 255 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,PSTLCITY,-1,-1;PSTLSTATE "Postal State" true true false 5 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,PSTLSTATE,-1,-1;PSTLZIP5 "Postal Zip 5" true true false 5 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,PSTLZIP5,-1,-1;PSTLZIP4 "Postal Zip +4" true true false 5 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,PSTLZIP4,-1,-1;BUILDING "Building Number" true true false 50 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,BUILDING,-1,-1;UNIT "Unit Number" true true false 50 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,UNIT,-1,-1;CVTTXDSCRP "Tax District Description" true true false 100 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,CVTTXDSCRP,-1,-1;CVTTXCD "Tax District Code" true true false 4 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,CVTTXCD,-1,-1;SCHLDSCRP "School District Description" true true false 100 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,SCHLDSCRP,-1,-1;SCHLTXCD "School District Code" true true false 6 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,SCHLTXCD,-1,-1;PRE "PRE" true true false 8 Double 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,PRE,-1,-1;STATEDAREA "Stated Area" true true false 50 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,STATEDAREA,-1,-1;ASSACRES "ASSACRES" true true false 8 Double 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,ASSACRES,-1,-1;USECD "Assessing Use Code" true true false 4 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,USECD,-1,-1;USEDSCRP "Assessing Use Description" true true false 100 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,USEDSCRP,-1,-1;NGHBRHDCD "Assessing Neighbornood Code" true true false 10 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,NGHBRHDCD,-1,-1;CLASSCD "Property Class Code" true true false 10 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,CLASSCD,-1,-1;CLASSDSCRP "Property Class" true true false 100 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,CLASSDSCRP,-1,-1;CNVYNAME "Sub or Condo Name" true true false 250 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,CNVYNAME,-1,-1;FLOORCOUNT "Number of Floors" true true false 2 Short 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,FLOORCOUNT,-1,-1;BLDGAREA "Building Area" true true false 8 Double 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,BLDGAREA,-1,-1;RESFLRAREA "Residential Floor Area" true true false 8 Double 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,RESFLRAREA,-1,-1;RESYRBLT "Residential Year Built" true true false 8 Double 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,RESYRBLT,-1,-1;RESSTRTYP "Residential Structure Type" true true false 50 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,RESSTRTYP,-1,-1;STRCLASS "Structure Class" true true false 5 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,STRCLASS,-1,-1;CLASSMOD "Structure Class Modifier" true true false 5 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,CLASSMOD,-1,-1;LNDVALUE "Land Value" true true false 8 Double 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,LNDVALUE,-1,-1;IMPVALUE "IMPVALUE" true true false 8 Double 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,IMPVALUE,-1,-1;PRVASSDVAL "Previous Assessed Value" true true false 8 Double 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,PRVASSDVAL,-1,-1;CNTASSDVAL "Current Assessed Value" true true false 8 Double 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,CNTASSDVAL,-1,-1;ASSDVALYRCG "Assessed Value Year Over Year Change" true true false 8 Double 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,ASSDVALYRCG,-1,-1;ASSDPCNTCG "Assessed Value % Change" true true false 8 Double 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,ASSDPCNTCG,-1,-1;PRVTXBLVAL "Previous Taxable Value" true true false 8 Double 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,PRVTXBLVAL,-1,-1;CNTTXBLVAL "Current Taxable Value" true true false 8 Double 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,CNTTXBLVAL,-1,-1;TXBLVALYRCHG "Taxable Value Year Over Year Change" true true false 8 Double 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,TXBLVALYRCHG,-1,-1;TXBLPCNTCHG "Taxable Value % Change" true true false 8 Double 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,TXBLPCNTCHG,-1,-1;PRVWNTTXOD "Previous Winter Taxes Owed" true true false 8 Double 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,PRVWNTTXOD,-1,-1;PRVSMRTXOD "Previous Summer Taxes Owed" true true false 8 Double 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,PRVSMRTXOD,-1,-1;TOTPRVTXTOD "Total Previous Taxes Owed" true true false 8 Double 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,TOTPRVTXTOD,-1,-1;CNTWNTTXOD "Current Winter Taxes Owed" true true false 8 Double 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,CNTWNTTXOD,-1,-1;CNTSMRTXOD "Current Summer Taxes Owed" true true false 8 Double 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,CNTSMRTXOD,-1,-1;TOTCNTTXOD "Total Current Taxes Owed" true true false 8 Double 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,TOTCNTTXOD,-1,-1;TXODYRCHG "Taxes Owed Year Over Year Change" true true false 8 Double 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,TXODYRCHG,-1,-1;TXODPCNTCHG "Taxes Owed % Change" true true false 8 Double 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,TXODPCNTCHG,-1,-1;WATERSERV "Water Service Provider" true true false 50 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,WATERSERV,-1,-1;SEWERSERV "Sewer Service Provider" true true false 50 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,SEWERSERV,-1,-1;PRIMEZONE "PRIMEZONE" true true false 15 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,PRIMEZONE,-1,-1;PRPRTYDSCRP "Property Description" true true false 1073741822 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,PRPRTYDSCRP,-1,-1;SITEFULLADDRESS "Site Full Addres" true true false 100 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,SITEFULLADDRESS,-1,-1;SITEHOUSENUMBER "Site House Number" true true false 10 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,SITEHOUSENUMBER,-1,-1;SITEROADNAME "Site Road Name" true true false 50 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,SITEROADNAME,-1,-1;SITECITY "Site City" true true false 25 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,SITECITY,-1,-1;SITESTATE "Site State" true true false 10 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,SITESTATE,-1,-1;SITEZIP "Site Zip" true true false 15 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,SITEZIP,-1,-1;SITEAPTUNITNUMBER "Site Apt/Unit Number" true true false 20 Text 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,SITEAPTUNITNUMBER,-1,-1;LGLSTARTDT "Legal Start Date" true true false 8 Date 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,LGLSTARTDT,-1,-1;LASTUPDATE "Last Update Date" true true false 8 Date 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,LASTUPDATE,-1,-1;SHAPE_Length "SHAPE_Length" false true true 8 Double 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,SHAPE_Length,-1,-1;SHAPE_Area "SHAPE_Area" false true true 8 Double 0 0 ,First,#,P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder,SHAPE_Area,-1,-1" #
Rename P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder0 P:\5000_5499\5061190010_Grand_Traverse_Co_GIS_\_GIS\_Working\Doezema\ConversionToLGM\c20191125_GTC_LGM_MISP_C.gdb\ParcelPublishing\TaxParcel_Reorder FeatureClass
Append 'Old GTC Database\GTCDB.GTC.parc19' "New GTC Database\TaxParcel" NO_TEST "PARCELID "Parcel Identification Number" true true false 30 Text 0 0 ,First,#,Old GTC Database\GTCDB.GTC.parc19,PARCELID,-1,-1;LOWPARCELID "Lowest Parcel Identification Number" true true false 30 Text 0 0 ,First,#,Old GTC Database\GTCDB.GTC.parc19,LOWPARCELID,-1,-1;SITEADDRESS "Site Address" true true false 255 Text 0 0 ,First,#,Old GTC Database\GTCDB.GTC.parc19,SITEADDRESS,-1,-1;SITECTSTZP "SITECTSTZP" true true false 32 Text 0 0 ,First,#,Old GTC Database\GTCDB.GTC.parc19,SITECTSTZP,-1,-1;OWNERNME1 "First Owner Name" true true false 255 Text 0 0 ,First,#,Old GTC Database\GTCDB.GTC.parc19,OWNERNME1,-1,-1;OWNERNME2 "Second Owner Name" true true false 255 Text 0 0 ,First,#,Old GTC Database\GTCDB.GTC.parc19,OWNERNME2,-1,-1;PSTLADDRESS "Postal Address" true true false 255 Text 0 0 ,First,#,Old GTC Database\GTCDB.GTC.parc19,PSTLADDRESS,-1,-1;PSTLCITY "Postal City" true true false 255 Text 0 0 ,First,#,Old GTC Database\GTCDB.GTC.parc19,PSTLCITY,-1,-1;PSTLSTATE "Postal State" true true false 5 Text 0 0 ,First,#,Old GTC Database\GTCDB.GTC.parc19,PSTLSTATE,-1,-1;PSTLZIP5 "Postal Zip 5" true true false 5 Text 0 0 ,First,#,Old GTC Database\GTCDB.GTC.parc19,PSTLZIP5,-1,-1;PSTLZIP4 "Postal Zip +4" true true false 5 Text 0 0 ,First,#,Old GTC Database\GTCDB.GTC.parc19,PSTLZIP4,-1,-1;BUILDING "Building Number" true true false 50 Text 0 0 ,First,#;UNIT "Unit Number" true true false 50 Text 0 0 ,First,#;CVTTXDSCRP "Tax District Description" true true false 100 Text 0 0 ,First,#,Old GTC Database\GTCDB.GTC.parc19,CVTTXDSCRP,-1,-1;CVTTXCD "Tax District Code" true true false 4 Text 0 0 ,First,#,Old GTC Database\GTCDB.GTC.parc19,CVTTXCD,-1,-1;SCHLDSCRP "School District Description" true true false 100 Text 0 0 ,First,#,Old GTC Database\GTCDB.GTC.parc19,SCHLDSCRP,-1,-1;SCHLTXCD "School District Code" true true false 6 Text 0 0 ,First,#,Old GTC Database\GTCDB.GTC.parc19,SCHLTXCD,-1,-1;PRE "PRE" true true false 8 Double 8 38 ,First,#,Old GTC Database\GTCDB.GTC.parc19,PRE,-1,-1;STATEDAREA "Stated Area" true true false 50 Text 0 0 ,First,#;ASSACRES "ASSACRES" true true false 8 Double 8 38 ,First,#,Old GTC Database\GTCDB.GTC.parc19,ASSACRES,-1,-1;USECD "Assessing Use Code" true true false 4 Text 0 0 ,First,#;USEDSCRP "Assessing Use Description" true true false 100 Text 0 0 ,First,#,Old GTC Database\GTCDB.GTC.parc19,USEDSCRP,-1,-1;NGHBRHDCD "Assessing Neighbornood Code" true true false 10 Text 0 0 ,First,#;CLASSCD "Property Class Code" true true false 10 Text 0 0 ,First,#,Old GTC Database\GTCDB.GTC.parc19,CLASSCD,-1,-1;CLASSDSCRP "Property Class" true true false 100 Text 0 0 ,First,#;CNVYNAME "Sub or Condo Name" true true false 250 Text 0 0 ,First,#;FLOORCOUNT "Number of Floors" true true false 2 Short 0 5 ,First,#;BLDGAREA "Building Area" true true false 8 Double 8 38 ,First,#;RESFLRAREA "Residential Floor Area" true true false 8 Double 8 38 ,First,#;RESYRBLT "Residential Year Built" true true false 8 Double 8 38 ,First,#;RESSTRTYP "Residential Structure Type" true true false 50 Text 0 0 ,First,#;STRCLASS "Structure Class" true true false 5 Text 0 0 ,First,#;CLASSMOD "Structure Class Modifier" true true false 5 Text 0 0 ,First,#;LNDVALUE "Land Value" true true false 8 Double 8 38 ,First,#,Old GTC Database\GTCDB.GTC.parc19,LANDVALUE,-1,-1;IMPVALUE "IMPVALUE" true true false 8 Double 8 38 ,First,#,Old GTC Database\GTCDB.GTC.parc19,IMPVALUE,-1,-1;PRVASSDVAL "Previous Assessed Value" true true false 8 Double 8 38 ,First,#,Old GTC Database\GTCDB.GTC.parc19,PRVASSDVAL,-1,-1;CNTASSDVAL "Current Assessed Value" true true false 8 Double 8 38 ,First,#,Old GTC Database\GTCDB.GTC.parc19,CNTASSDVAL,-1,-1;ASSDVALYRCG "Assessed Value Year Over Year Change" true true false 8 Double 8 38 ,First,#;ASSDPCNTCG "Assessed Value % Change" true true false 8 Double 8 38 ,First,#;PRVTXBLVAL "Previous Taxable Value" true true false 8 Double 8 38 ,First,#,Old GTC Database\GTCDB.GTC.parc19,PRVTXBLVAL,-1,-1;CNTTXBLVAL "Current Taxable Value" true true false 8 Double 8 38 ,First,#,Old GTC Database\GTCDB.GTC.parc19,CNTTXBLVAL,-1,-1;TXBLVALYRCHG "Taxable Value Year Over Year Change" true true false 8 Double 8 38 ,First,#;TXBLPCNTCHG "Taxable Value % Change" true true false 8 Double 8 38 ,First,#;PRVWNTTXOD "Previous Winter Taxes Owed" true true false 8 Double 8 38 ,First,#;PRVSMRTXOD "Previous Summer Taxes Owed" true true false 8 Double 8 38 ,First,#;TOTPRVTXTOD "Total Previous Taxes Owed" true true false 8 Double 8 38 ,First,#,Old GTC Database\GTCDB.GTC.parc19,TOTPRVTXTOD,-1,-1;CNTWNTTXOD "Current Winter Taxes Owed" true true false 8 Double 8 38 ,First,#;CNTSMRTXOD "Current Summer Taxes Owed" true true false 8 Double 8 38 ,First,#;TOTCNTTXOD "Total Current Taxes Owed" true true false 8 Double 8 38 ,First,#;TXODYRCHG "Taxes Owed Year Over Year Change" true true false 8 Double 8 38 ,First,#;TXODPCNTCHG "Taxes Owed % Change" true true false 8 Double 8 38 ,First,#;WATERSERV "Water Service Provider" true true false 50 Text 0 0 ,First,#;SEWERSERV "Sewer Service Provider" true true false 50 Text 0 0 ,First,#;PRIMEZONE "PRIMEZONE" true true false 15 Text 0 0 ,First,#,Old GTC Database\GTCDB.GTC.parc19,PRIMEZONE,-1,-1;PRPRTYDSCRP "Property Description" true true false 1073741822 Text 0 0 ,First,#,Old GTC Database\GTCDB.GTC.parc19,PRPRTYDSCRP,-1,-1;SITEFULLADDRESS "Site Full Addres" true true false 100 Text 0 0 ,First,#;SITEHOUSENUMBER "Site House Number" true true false 10 Text 0 0 ,First,#;SITEROADNAME "Site Road Name" true true false 50 Text 0 0 ,First,#;SITECITY "Site City" true true false 25 Text 0 0 ,First,#;SITESTATE "Site State" true true false 10 Text 0 0 ,First,#;SITEZIP "Site Zip" true true false 15 Text 0 0 ,First,#;SITEAPTUNITNUMBER "Site Apt/Unit Number" true true false 20 Text 0 0 ,First,#;LGLSTARTDT "Legal Start Date" true true false 8 Date 0 0 ,First,#;LASTUPDATE "Last Update Date" true true false 8 Date 0 0 ,First,#;Shape.STArea() "Shape.STArea()" false false true 0 Double 0 0 ,First,#;Shape.STLength() "Shape.STLength()" false false true 0 Double 0 0 ,First,#" #
CalculateField "New GTC Database\TaxParcel" FULL_POSTAL_ADDRESS "!PSTLADDRESS!+ ' ' + !PSTLCITY! + ' ' + !PSTLCITY!+ ' ' + !PSTLSTATE!+ ' ' + !PSTLZIP5!+ ' ' + !PSTLZIP4!" PYTHON_9.3 #
FeatureClassToFeatureClass "Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel" "Database Connections\GTCGISDB.sde\DBO.ParcelPublishing" TaxParcel0 # "PARCELID "Parcel Identification Number" true true false 30 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,PARCELID,-1,-1;LOWPARCELID "Lowest Parcel Identification Number" true true false 30 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,LOWPARCELID,-1,-1;SITEADDRESS "Site Address" true true false 255 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,SITEADDRESS,-1,-1;SITECTSTZP "SITECTSTZP" true true false 32 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,SITECTSTZP,-1,-1;OWNERNME1 "First Owner Name" true true false 255 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,OWNERNME1,-1,-1;OWNERNME2 "Second Owner Name" true true false 255 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,OWNERNME2,-1,-1;PSTLADDRESS "Postal Address" true true false 255 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,PSTLADDRESS,-1,-1;PSTLCITY "Postal City" true true false 255 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,PSTLCITY,-1,-1;PSTLSTATE "Postal State" true true false 5 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,PSTLSTATE,-1,-1;PSTLZIP5 "Postal Zip 5" true true false 5 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,PSTLZIP5,-1,-1;PSTLZIP4 "Postal Zip +4" true true false 5 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,PSTLZIP4,-1,-1;FULL_POSTAL_ADDRESS "FULL_POSTAL_ADDRESS" true true false 150 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,FULL_POSTAL_ADDRESS,-1,-1;BUILDING "Building Number" true true false 50 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,BUILDING,-1,-1;UNIT "Unit Number" true true false 50 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,UNIT,-1,-1;CVTTXDSCRP "Tax District Description" true true false 100 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,CVTTXDSCRP,-1,-1;CVTTXCD "Tax District Code" true true false 4 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,CVTTXCD,-1,-1;SCHLDSCRP "School District Description" true true false 100 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,SCHLDSCRP,-1,-1;SCHLTXCD "School District Code" true true false 6 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,SCHLTXCD,-1,-1;PRE "PRE" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,PRE,-1,-1;STATEDAREA "Stated Area" true true false 50 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,STATEDAREA,-1,-1;ASSACRES "ASSACRES" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,ASSACRES,-1,-1;USECD "Assessing Use Code" true true false 4 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,USECD,-1,-1;USEDSCRP "Assessing Use Description" true true false 100 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,USEDSCRP,-1,-1;NGHBRHDCD "Assessing Neighbornood Code" true true false 10 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,NGHBRHDCD,-1,-1;CLASSCD "Property Class Code" true true false 10 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,CLASSCD,-1,-1;CLASSDSCRP "Property Class" true true false 100 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,CLASSDSCRP,-1,-1;CNVYNAME "Sub or Condo Name" true true false 250 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,CNVYNAME,-1,-1;FLOORCOUNT "Number of Floors" true true false 2 Short 0 5 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,FLOORCOUNT,-1,-1;BLDGAREA "Building Area" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,BLDGAREA,-1,-1;RESFLRAREA "Residential Floor Area" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,RESFLRAREA,-1,-1;RESYRBLT "Residential Year Built" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,RESYRBLT,-1,-1;RESSTRTYP "Residential Structure Type" true true false 50 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,RESSTRTYP,-1,-1;STRCLASS "Structure Class" true true false 5 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,STRCLASS,-1,-1;CLASSMOD "Structure Class Modifier" true true false 5 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,CLASSMOD,-1,-1;LNDVALUE "Land Value" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,LNDVALUE,-1,-1;IMPVALUE "IMPVALUE" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,IMPVALUE,-1,-1;PRVASSDVAL "Previous Assessed Value" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,PRVASSDVAL,-1,-1;CNTASSDVAL "Current Assessed Value" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,CNTASSDVAL,-1,-1;ASSDVALYRCG "Assessed Value Year Over Year Change" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,ASSDVALYRCG,-1,-1;ASSDPCNTCG "Assessed Value % Change" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,ASSDPCNTCG,-1,-1;PRVTXBLVAL "Previous Taxable Value" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,PRVTXBLVAL,-1,-1;CNTTXBLVAL "Current Taxable Value" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,CNTTXBLVAL,-1,-1;TXBLVALYRCHG "Taxable Value Year Over Year Change" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,TXBLVALYRCHG,-1,-1;TXBLPCNTCHG "Taxable Value % Change" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,TXBLPCNTCHG,-1,-1;PRVWNTTXOD "Previous Winter Taxes Owed" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,PRVWNTTXOD,-1,-1;PRVSMRTXOD "Previous Summer Taxes Owed" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,PRVSMRTXOD,-1,-1;TOTPRVTXTOD "Total Previous Taxes Owed" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,TOTPRVTXTOD,-1,-1;CNTWNTTXOD "Current Winter Taxes Owed" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,CNTWNTTXOD,-1,-1;CNTSMRTXOD "Current Summer Taxes Owed" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,CNTSMRTXOD,-1,-1;TOTCNTTXOD "Total Current Taxes Owed" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,TOTCNTTXOD,-1,-1;TXODYRCHG "Taxes Owed Year Over Year Change" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,TXODYRCHG,-1,-1;TXODPCNTCHG "Taxes Owed % Change" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,TXODPCNTCHG,-1,-1;WATERSERV "Water Service Provider" true true false 50 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,WATERSERV,-1,-1;SEWERSERV "Sewer Service Provider" true true false 50 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,SEWERSERV,-1,-1;PRIMEZONE "PRIMEZONE" true true false 15 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,PRIMEZONE,-1,-1;PRPRTYDSCRP "Property Description" true true false 1073741822 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,PRPRTYDSCRP,-1,-1;LGLSTARTDT "Legal Start Date" true true false 8 Date 0 0 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,LGLSTARTDT,-1,-1;LASTUPDATE "Last Update Date" true true false 8 Date 0 0 ,First,#,Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel,LASTUPDATE,-1,-1" #
Rename "Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\TaxParcel0" "Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel" FeatureClass
EnableEditorTracking "Database Connections\GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel" # # LASTEDITOR LASTUPDATE ADD_FIELDS UTC
AddField "New GTC Database\TaxParcel" FULPSTLADDRESS TEXT # # 150 # NULLABLE NON_REQUIRED #
CalculateField "New GTC Database\TaxParcel" FULPSTLADDRESS [FULL_POSTAL_ADDRESS] VB #
CalculateField TaxParcel FULPSTLADDRESS remove_dups( !FULPSTLADDRESS!) PYTHON_9.3 "import collections\n\ndef remove_dups(address):\n address_lst = address.split(' ')\n keys = [key for key, value in collections.OrderedDict.fromkeys(address_lst).items()]\n return ' '.join(keys)"
CalculateField TaxParcel CLASSDSCRP [USEDSCRP] VB #
CalculateField TaxParcel USEDSCRP "1" VB #
CalculateField TaxParcel TOTPRVTXTOD "[PRVWNTTXOD]+ [PRVSMRTXOD]" VB #
DeleteFeatures "Database Connections\DBO on GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel"
DeleteFeatures TaxParcel
DeleteFeatures TaxParcel
DeleteFeatures "Database Connections\DBO on GTCGISDB.sde\DBO.ParcelPublishing\DBO.TaxParcel"
DeleteFeatures TaxParcel
CalculateField TaxParcel IMPVALUE "([CNTASSDVAL]*2)- [LNDVALUE]" VB #
DeleteFeatures TaxParcel
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.0.0'><FeatureDataset>DBO.ParcelPublishing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e687435444645557345666d3472676c4a6b6376372f665545322f633639766f4e5a6e45695a79354646544d6b3d2a00;ENCRYPTED_PASSWORD=00022e6837555a49435a452f4431536f4f644876616b5769627847464b4d67525965613353703661782b34545a65413d2a00;SERVER=gtcgisdb;INSTANCE=sde:sqlserver:gtcgisdb\gtcgisdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gtcgisdb\gtcgisdb;DATABASE=GTCGIS;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.TaxParcel</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>pnum</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>30</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.0.0'><FeatureDataset>DBO.ParcelPublishing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e687435444645557345666d3472676c4a6b6376372f665545322f633639766f4e5a6e45695a79354646544d6b3d2a00;ENCRYPTED_PASSWORD=00022e6837555a49435a452f4431536f4f644876616b5769627847464b4d67525965613353703661782b34545a65413d2a00;SERVER=gtcgisdb;INSTANCE=sde:sqlserver:gtcgisdb\gtcgisdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gtcgisdb\gtcgisdb;DATABASE=GTCGIS;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.TaxParcel</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>pnum</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>30</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
DeleteFeatures TaxParcel
DeleteFeatures TaxParcel
DeleteFeatures TaxParcel
DeleteFeatures TaxParcel
CalculateField TaxParcel PRE " " VB #
CalculateField TaxParcel PRE 0 VB #
DeleteFeatures TaxParcel
Append DBO.parc25 TaxParcel "Use the field map to reconcile field differences" "PARCELID "PARCELID" true true false 30 Text 0 0,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,PARCELID,0,29;LOWPARCELID "LOWPARCELID" true true false 30 Text 0 0,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,LOWPARCELID,0,29;SITEADDRESS "SITEADDRESS" true true false 255 Text 0 0,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,SITEADDRESS,0,254;SITECTSTZP "SITECTSTZP" true true false 32 Text 0 0,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,SITECTSTZP,0,31;OWNERNME1 "OWNERNME1" true true false 255 Text 0 0,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,OWNERNME1,0,254;OWNERNME2 "OWNERNME2" true true false 255 Text 0 0,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,OWNERNME2,0,254;PSTLADDRESS "PSTLADDRESS" true true false 255 Text 0 0,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,PSTLADDRESS,0,254;PSTLCITY "PSTLCITY" true true false 255 Text 0 0,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,PSTLCITY,0,254;PSTLSTATE "PSTLSTATE" true true false 5 Text 0 0,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,PSTLSTATE,0,4;PSTLZIP5 "PSTLZIP5" true true false 5 Text 0 0,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,PSTLZIP5,0,4;PSTLZIP4 "PSTLZIP4" true true false 5 Text 0 0,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,PSTLZIP4,0,4;BUILDING "Building Number" true true false 50 Text 0 0,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,BUILDING,0,49;UNIT "Unit Number" true true false 50 Text 0 0,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,UNIT,0,49;CVTTXDSCRP "Tax District Description" true true false 100 Text 0 0,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,CVTTXDSCRP,0,99;CVTTXCD "Tax District Code" true true false 4 Text 0 0,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,CVTTXCD,0,3;SCHLDSCRP "School District Description" true true false 100 Text 0 0,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,SCHLDSCRP,0,99;SCHLTXCD "School District Code" true true false 6 Text 0 0,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,SCHLTXCD,0,5;PRE "PRE" true true false 8 Double 8 38,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,PRE,-1,-1;STATEDAREA "Stated Area" true true false 50 Text 0 0,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,STATEDAREA,0,49;ASSACRES "ASSACRES" true true false 8 Double 8 38,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,ASSACRES,-1,-1;USECD "Assessing Use Code" true true false 4 Text 0 0,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,USECD,0,3;USEDSCRP "Assessing Use Description" true true false 100 Text 0 0,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,USEDSCRP,0,99;NGHBRHDCD "Assessing Neighbornood Code" true true false 10 Text 0 0,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,NGHBRHDCD,0,9;CLASSCD "Property Class Code" true true false 10 Text 0 0,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,CLASSCD,0,9;CLASSDSCRP "Property Class" true true false 100 Text 0 0,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,CLASSDSCRP,0,99;CNVYNAME "Sub or Condo Name" true true false 250 Text 0 0,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,CNVYNAME,0,249;FLOORCOUNT "Number of Floors" true true false 2 Short 0 5,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,FLOORCOUNT,-1,-1;BLDGAREA "Building Area" true true false 8 Double 8 38,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,BLDGAREA,-1,-1;RESFLRAREA "Residential Floor Area" true true false 8 Double 8 38,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,RESFLRAREA,-1,-1;RESYRBLT "Residential Year Built" true true false 8 Double 8 38,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,RESYRBLT,-1,-1;RESSTRTYP "Residential Structure Type" true true false 50 Text 0 0,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,RESSTRTYP,0,49;STRCLASS "Structure Class" true true false 5 Text 0 0,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,STRCLASS,0,4;CLASSMOD "Structure Class Modifier" true true false 5 Text 0 0,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,CLASSMOD,0,4;LNDVALUE "Land Value" true true false 8 Double 8 38,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,LNDVALUE,-1,-1;IMPVALUE "IMPVALUE" true true false 8 Double 8 38,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,IMPVALUE,-1,-1;PRVASSDVAL "Previous Assessed Value" true true false 8 Double 8 38,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,PRVASSDVAL,-1,-1;CNTASSDVAL "Current Assessed Value" true true false 8 Double 8 38,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,CNTASSDVAL,-1,-1;ASSDVALYRCG "Assessed Value Year Over Year Change" true true false 8 Double 8 38,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,ASSDVALYRCG,-1,-1;ASSDPCNTCG "Assessed Value % Change" true true false 8 Double 8 38,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,ASSDPCNTCG,-1,-1;PRVTXBLVAL "Previous Taxable Value" true true false 8 Double 8 38,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,PRVTXBLVAL,-1,-1;CNTTXBLVAL "Current Taxable Value" true true false 8 Double 8 38,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,CNTTXBLVAL,-1,-1;TXBLVALYRCHG "Taxable Value Year Over Year Change" true true false 8 Double 8 38,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,TXBLVALYRCHG,-1,-1;TXBLPCNTCHG "Taxable Value % Change" true true false 8 Double 8 38,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,TXBLPCNTCHG,-1,-1;PRVWNTTXOD "Previous Winter Taxes Owed" true true false 8 Double 8 38,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,PRVWNTTXOD,-1,-1;PRVSMRTXOD "Previous Summer Taxes Owed" true true false 8 Double 8 38,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,PRVSMRTXOD,-1,-1;TOTPRVTXTOD "Total Previous Taxes Owed" true true false 8 Double 8 38,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,TOTPRVTXTOD,-1,-1;CNTWNTTXOD "Current Winter Taxes Owed" true true false 8 Double 8 38,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,CNTWNTTXOD,-1,-1;CNTSMRTXOD "Current Summer Taxes Owed" true true false 8 Double 8 38,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,CNTSMRTXOD,-1,-1;TOTCNTTXOD "Total Current Taxes Owed" true true false 8 Double 8 38,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,TOTCNTTXOD,-1,-1;TXODYRCHG "Taxes Owed Year Over Year Change" true true false 8 Double 8 38,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,TXODYRCHG,-1,-1;TXODPCNTCHG "Taxes Owed % Change" true true false 8 Double 8 38,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,TXODPCNTCHG,-1,-1;WATERSERV "Water Service Provider" true true false 50 Text 0 0,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,WATERSERV,0,49;SEWERSERV "Sewer Service Provider" true true false 50 Text 0 0,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,SEWERSERV,0,49;PRIMEZONE "PRIMEZONE" true true false 15 Text 0 0,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,PRIMEZONE,0,14;PRPRTYDSCRP "Property Description" true true false 1073741822 Text 0 0,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,PRPRTYDSCRP,0,1073741821;LGLSTARTDT "Legal Start Date" true true false 8 Date 0 0,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,LGLSTARTDT,-1,-1;FULPSTLADDRESS "FULPSTLADDRESS" true true false 150 Text 0 0,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,FULPSTLADDRESS,0,149;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#;pnum "pnum" true true false 30 Text 0 0,First,#,C:\Users\jgreen\AppData\Local\Temp\ArcGISProTemp14780\bea197cd6de93b1cf69398f830d5e35c.sde\DBO.parc25,pnum,0,29" # # # NOT_UPDATE_GEOMETRY
RemoveSpatialIndex "C:\Users\jgreen\AppData\Roaming\Esri\ArcGISPro\Favorites\gtcgis admin.sde\DBO.ParcelPublishing\DBO.TaxParcel"
AddSpatialIndex "C:\Users\jgreen\AppData\Roaming\Esri\ArcGISPro\Favorites\gtcgis admin.sde\DBO.ParcelPublishing\DBO.TaxParcel" 0 0 0
RemoveSpatialIndex K:\GIS\USERS\JGREEN\Customers\Customer_projects\New_Database_ADMIN.sde\DBO.ParcelPublishing\DBO.TaxParcel
AddSpatialIndex K:\GIS\USERS\JGREEN\Customers\Customer_projects\New_Database_ADMIN.sde\DBO.ParcelPublishing\DBO.TaxParcel 0 0 0
DeleteFeatures TaxParcel
Append DBO.Parc26 TaxParcel "Input fields must match target fields" # # # # NOT_UPDATE_GEOMETRY
CalculateField TaxParcel BUILDING extract_number(!UNIT!) Python "def extract_number(adr):
numberlist = [i for i in adr if i.isdigit()]
if len(numberlist)>0:
return int(''.join(numberlist))" Text NO_ENFORCE_DOMAINS
CalculateField TaxParcel PSTLZIP5 left($feature.BUILDING,5) Arcade # Text NO_ENFORCE_DOMAINS
CalculateField TaxParcel PSTLZIP4 "-"+Mid( $feature.BUILDING,6,4 ) Arcade # Text NO_ENFORCE_DOMAINS
CalculateField TaxParcel PSTLZIP4 "-"+Mid( $feature.BUILDING,5,4 ) Arcade # Text NO_ENFORCE_DOMAINS
CalculateField TaxParcel PSTLZIP4 "-"+Mid($feature.BUILDING,5,4 ) Arcade # Text NO_ENFORCE_DOMAINS
CalculateField TaxParcel BUILDING extract_number(!UNIT!) Python "def extract_number(adr):
numberlist = [i for i in adr if i.isdigit()]
if len(numberlist)>0:
return int(''.join(numberlist))" Text NO_ENFORCE_DOMAINS
CalculateField TaxParcel PSTLZIP5 left($feature.BUILDING,5) Arcade # Text NO_ENFORCE_DOMAINS
CalculateField TaxParcel PSTLZIP4 "-"+mid($feature.BUILDING,5,4) Arcade # Text NO_ENFORCE_DOMAINS
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.3.0'><FeatureDataset>DBO.ParcelPublishing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68654576592f4e35537064486568616d37572b4a77732b4b3235496e7145307346492f76782b36326e6862513d2a00;ENCRYPTED_PASSWORD=00022e6845566b504532324258497850685655434152725a4867497570646a694a34534c69675053644d3551532f633d2a00;SERVER=GTC-GISDB;INSTANCE=sde:sqlserver:GTC-GISDB\GTCGISDB;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GTC-GISDB\GTCGISDB;DATABASE=GTCGIS;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.TaxParcel</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>Current_SEV</field_name><field_type>DOUBLE</field_type><field_precision>38</field_precision><field_scale>2</field_scale><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Current_summer_tax</field_name><field_type>DOUBLE</field_type><field_precision>38</field_precision><field_scale>2</field_scale><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Current_winter_tax</field_name><field_type>DOUBLE</field_type><field_precision>38</field_precision><field_scale>2</field_scale><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Previous_summer_tax</field_name><field_type>DOUBLE</field_type><field_precision>38</field_precision><field_scale>2</field_scale><field_alias>Current Summer Taxes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Previous_winter_tax</field_name><field_type>DOUBLE</field_type><field_precision>38</field_precision><field_scale>2</field_scale><field_alias>Current WInter Taxes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Previous2_summer_tax</field_name><field_type>DOUBLE</field_type><field_precision>38</field_precision><field_scale>2</field_scale><field_alias>Previoius Year Summer Taxes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Previous2_winter_tax</field_name><field_type>DOUBLE</field_type><field_precision>38</field_precision><field_scale>2</field_scale><field_alias>Previous Year WInter Taxes</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Previous3_summer_tax</field_name><field_type>DOUBLE</field_type><field_precision>38</field_precision><field_scale>2</field_scale><field_alias>Summer Taxes 2 years ago</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Previous3_winter_tax</field_name><field_type>DOUBLE</field_type><field_precision>38</field_precision><field_scale>2</field_scale><field_alias>WInter Taxes 2 years ago</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Last_Sale_Date</field_name><field_type>DATE</field_type><field_precision>0</field_precision><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Last_Sale_Price</field_name><field_type>DOUBLE</field_type><field_precision>38</field_precision><field_scale>2</field_scale><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Last_Sale_Liber_page</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>20</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Last2_Sale_Date</field_name><field_type>DATE</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_alias>Most Recent Sale Dates</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Last2_Sale_Price</field_name><field_type>DOUBLE</field_type><field_precision>38</field_precision><field_scale>2</field_scale><field_alias>Most Recent Sale Price</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Last2_Sale_Liber_page</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_scale>0</field_scale><field_length>255</field_length><field_alias>Most Recent Sale Liber and page Number</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>"
RemoveSpatialIndex "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><FeatureDataset>DBO.ParcelPublishing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e687a495a635073514f5862484253595476337550426269354f344c79556347325930685366336a36306f67383d2a00;ENCRYPTED_PASSWORD=00022e684f2b36734c6a486f384237585238386451775937425148794b6a2b72765347623073524451504c6a4671673d2a00;SERVER=GTC-GISDB;INSTANCE=sde:sqlserver:GTC-GISDB\GTCGISDB;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GTC-GISDB\GTCGISDB;DATABASE=GTCGIS;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.TaxParcel</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>"
AddSpatialIndex "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><FeatureDataset>DBO.ParcelPublishing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e687a495a635073514f5862484253595476337550426269354f344c79556347325930685366336a36306f67383d2a00;ENCRYPTED_PASSWORD=00022e684f2b36734c6a486f384237585238386451775937425148794b6a2b72765347623073524451504c6a4671673d2a00;SERVER=GTC-GISDB;INSTANCE=sde:sqlserver:GTC-GISDB\GTCGISDB;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=GTC-GISDB\GTCGISDB;DATABASE=GTCGIS;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.TaxParcel</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" 0 0 0
DBO.TaxParcel
002
Server=gtcgisdb; Service=sde:sqlserver:gtcgisdb\gtcgisdb; Database=GTCGIS; Version=dbo.DEFAULT
ArcSDE Connection
19306531.500000
19434294.439304
437376.898294
612661.490814
1
Projected
GCS_North_American_1983
Linear Unit: Foot (0.304800)
NAD_1983_StatePlane_Michigan_Central_FIPS_2112_Feet_Intl
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/10.6'><WKT>PROJCS["NAD_1983_StatePlane_Michigan_Central_FIPS_2112_Feet_Intl",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",19685039.37007874],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-84.36666666666666],PARAMETER["Standard_Parallel_1",44.18333333333333],PARAMETER["Standard_Parallel_2",45.7],PARAMETER["Latitude_Of_Origin",43.31666666666667],UNIT["Foot",0.3048],AUTHORITY["EPSG",2252]]</WKT><XOrigin>-99918900</XOrigin><YOrigin>-98010600</YOrigin><XYScale>3048</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808398950131198</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>2252</WKID><LatestWKID>2252</LatestWKID></ProjectedCoordinateSystem>
20230503
09335100
20230503
09335100
Version 6.2 (Build 9200) ; Esri ArcGIS 10.6.1.9328
Tax_Parcel_Public
1
-85.829770
-85.327937
44.993077
44.507089
This Service has globalIDs and is intended to be used for public facing web maps and web applications.
Parcel
Polygons
Tax
This Service has globalIDs and is intended to be used for public facing web maps and web applications.
GTC GIS
SDE Feature Class
dataset
EPSG
5.3(9.0.0)
54494
Simple
FALSE
54494
TRUE
FALSE
DBO.TaxParcel
Feature Class
54494
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
SHAPE
Shape
Geometry
4
0
0
Feature geometry.
Esri
Coordinates defining the features.
LOWPARCELID
LOWPARCELID
String
30
0
0
PARCELID
PARCELID
String
30
0
0
BUILDING
Building Number
String
50
0
0
UNIT
Unit Number
String
50
0
0
STATEDAREA
Stated Area
String
50
0
0
LGLSTARTDT
Legal Start Date
Date
8
0
0
CVTTXCD
Tax District Code
String
4
0
0
CVTTXDSCRP
Tax District Description
String
100
0
0
SCHLTXCD
School District Code
String
6
0
0
SCHLDSCRP
School District Description
String
100
0
0
USECD
Assessing Use Code
String
4
0
0
USEDSCRP
Assessing Use Description
String
100
0
0
NGHBRHDCD
Assessing Neighbornood Code
String
10
0
0
CLASSCD
Property Class Code
String
10
0
0
CLASSDSCRP
Property Class
String
100
0
0
SITEADDRESS
SITEADDRESS
String
255
0
0
PRPRTYDSCRP
Property Description
String
1073741822
0
0
CNVYNAME
Sub or Condo Name
String
250
0
0
OWNERNME1
OWNERNME1
String
255
0
0
OWNERNME2
OWNERNME2
String
255
0
0
PSTLADDRESS
PSTLADDRESS
String
255
0
0
PSTLCITY
PSTLCITY
String
255
0
0
PSTLSTATE
PSTLSTATE
String
5
0
0
PSTLZIP5
PSTLZIP5
String
5
0
0
PSTLZIP4
PSTLZIP4
String
5
0
0
FLOORCOUNT
Number of Floors
SmallInteger
2
5
0
BLDGAREA
Building Area
Double
8
38
8
RESFLRAREA
Residential Floor Area
Double
8
38
8
RESYRBLT
Residential Year Built
Double
8
38
8
RESSTRTYP
Residential Structure Type
String
50
0
0
STRCLASS
Structure Class
String
5
0
0
CLASSMOD
Structure Class Modifier
String
5
0
0
LNDVALUE
Land Value
Double
8
38
8
PRVASSDVAL
Previous Assessed Value
Double
8
38
8
CNTASSDVAL
Current Assessed Value
Double
8
38
8
ASSDVALYRCG
Assessed Value Year Over Year Change
Double
8
38
8
ASSDPCNTCG
Assessed Value % Change
Double
8
38
8
PRVTXBLVAL
Previous Taxable Value
Double
8
38
8
CNTTXBLVAL
Current Taxable Value
Double
8
38
8
TXBLVALYRCHG
Taxable Value Year Over Year Change
Double
8
38
8
TXBLPCNTCHG
Taxable Value % Change
Double
8
38
8
PRVWNTTXOD
Previous Winter Taxes Owed
Double
8
38
8
PRVSMRTXOD
Previous Summer Taxes Owed
Double
8
38
8
TOTPRVTXTOD
Total Previous Taxes Owed
Double
8
38
8
CNTWNTTXOD
Current Winter Taxes Owed
Double
8
38
8
CNTSMRTXOD
Current Summer Taxes Owed
Double
8
38
8
TOTCNTTXOD
Total Current Taxes Owed
Double
8
38
8
TXODYRCHG
Taxes Owed Year Over Year Change
Double
8
38
8
TXODPCNTCHG
Taxes Owed % Change
Double
8
38
8
WATERSERV
Water Service Provider
String
50
0
0
SEWERSERV
Sewer Service Provider
String
50
0
0
LASTUPDATE
Last Update Date
Date
8
0
0
ASSACRES
ASSACRES
Double
8
38
8
PRIMEZONE
PRIMEZONE
String
15
0
0
SITECTSTZP
SITECTSTZP
String
32
0
0
IMPVALUE
IMPVALUE
Double
8
38
8
PRE
PRE
Double
8
38
8
LASTEDITOR
LASTEDITOR
String
255
0
0
FULPSTLADDRESS
FULPSTLADDRESS
String
150
0
0
GlobalID
GlobalID
GlobalID
38
0
0
pnum
pnum
String
30
0
0
Shape.STArea()
Shape.STArea()
Double
0
0
0
Shape.STLength()
Shape.STLength()
Double
0
0
0
20230503
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii
gAooooAKKKKACiiigAooooAKKrXU4ghMjKzfMqhVxkkkADn3Ipv2qb/oH3P/AH1H/wDF0AW6Kqfa
pv8AoH3P/fUf/wAXR9qm/wCgfc/99R//ABdAFuiqn2qb/oH3P/fUf/xdH2qb/oH3P/fUf/xdAFui
qn2qb/oH3P8A31H/APF0fapv+gfc/wDfUf8A8XQBboqp9qm/6B9z/wB9R/8AxdH2qb/oH3P/AH1H
/wDF0AW6Kqfapv8AoH3P/fUf/wAXR9qm/wCgfc/99R//ABdAFuiqn2qb/oH3P/fUf/xdH2qb/oH3
P/fUf/xdAFuiqn2qb/oH3P8A31H/APF0fapv+gfc/wDfUf8A8XQBboqkt23nRRyWk8fmMVVmKEZw
T2YnoDV2gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAqaj/x7J/13h/9
GLVuqmo/8eyf9d4f/Ri1boAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAKl3/AMfNj/13P/ot
6t1Uu/8Aj5sf+u5/9FvVugAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooA
qaj/AMeyf9d4f/Ri1bqpqP8Ax7J/13h/9GLVugAooooAKKKKACiiigAooooAKKKKACiiigAooooA
qXf/AB82P/Xc/wDot6t1Uu/+Pmx/67n/ANFvVugAooooAKKKKACiiigAooooAKKKKACiiigAoooo
AKKKKACiiigAooooAqaj/wAeyf8AXeH/ANGLVuqmo/8AHsn/AF3h/wDRi1boAKKKKACiiigAoooo
AKKKKACiiigAooooAKKKKAKl3/x82P8A13P/AKLerdVLv/j5sf8Aruf/AEW9W6ACiiigAooooAKK
KKACiiigAooooAKKKKACiiigAooooAKKKKACiiigCpqP/Hsn/XeH/wBGLVuqmo/8eyf9d4f/AEYt
W6ACiiigAooooAKKKKACiiigAooooAKKKKACiiigCpd/8fNj/wBdz/6LerdVLv8A4+bH/ruf/Rb1
boAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAKmo/8eyf9d4f/Ri1bqpq
P/Hsn/XeH/0YtW6ACiiigAooooAKKKKACiiigAooooAKKKKACiiigCpd/wDHzY/9dz/6LerdVLv/
AI+bH/ruf/Rb1boAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAKmo/wDH
sn/XeH/0YtW6qaj/AMeyf9d4f/Ri1boAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAKl3/wAf
Nj/13P8A6LerdVLv/j5sf+u5/wDRb1boAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigA
ooooAKKKKAKmo/8AHsn/AF3h/wDRi1bqpqP/AB7J/wBd4f8A0YtW6ACiiigAooooAKKKKACiiigA
ooooAKKKKACiiigCpd/8fNj/ANdz/wCi3q3VS7/4+bH/AK7n/wBFvVugAooooAKKKKACiiigAooo
oAKKKKACiiigAooooAKKKKACiiigAooooAqaj/x7J/13h/8ARi1bqpqP/Hsn/XeH/wBGLVugAooo
oAKKKKACiiigAooooAKKKKACiiigAooooAqXf/HzY/8AXc/+i3q3VS7/AOPmx/67n/0W9W6ACiii
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigCpqP/Hsn/XeH/0YtW6qaj/x7J/1
3h/9GLVugAooooAKKKKACiiigAooooAKKKKACiiigAooooAqXf8Ax82P/Xc/+i3q3VS7/wCPmx/6
7n/0W9W6ACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigCpqP8Ax7J/13h/
9GLVuqmo/wDHsn/XeH/0YtW6ACiiigAooooAKKKKACiiigAooooAKKKKACiiigCpd/8AHzY/9dz/
AOi3q3VS7/4+bH/ruf8A0W9W6ACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACi
iigCpqP/AB7J/wBd4f8A0YtW6rXMP2iPyy7J8ysGXGQQQR1BHUU37JP/ANBG5/75j/8AiKALdFVP
sk//AEEbn/vmP/4ij7JP/wBBG5/75j/+IoAt0VU+yT/9BG5/75j/APiKPsk//QRuf++Y/wD4igC3
RVT7JP8A9BG5/wC+Y/8A4ij7JP8A9BG5/wC+Y/8A4igC3RVT7JP/ANBG5/75j/8AiKPsk/8A0Ebn
/vmP/wCIoAt0VU+yT/8AQRuf++Y//iKPsk//AEEbn/vmP/4igC3RVT7JP/0Ebn/vmP8A+Io+yT/9
BG5/75j/APiKALdFVPsk/wD0Ebn/AL5j/wDiKPsk/wD0Ebn/AL5j/wDiKAC7/wCPmx/67n/0W9W6
oLZMZopJLueXymLKrBAM7SvOFB6E1foAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAo
oooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACii
igAooooA/9k=