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\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel" "Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing" TaxParcel0 # "PARCELID "Parcel Identification Number" true true false 30 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,PARCELID,-1,-1;LOWPARCELID "Lowest Parcel Identification Number" true true false 30 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,LOWPARCELID,-1,-1;SITEADDRESS "Site Address" true true false 255 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,SITEADDRESS,-1,-1;SITECTSTZP "SITECTSTZP" true true false 32 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,SITECTSTZP,-1,-1;OWNERNME1 "First Owner Name" true true false 255 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,OWNERNME1,-1,-1;OWNERNME2 "Second Owner Name" true true false 255 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,OWNERNME2,-1,-1;PSTLADDRESS "Postal Address" true true false 255 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,PSTLADDRESS,-1,-1;PSTLCITY "Postal City" true true false 255 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,PSTLCITY,-1,-1;PSTLSTATE "Postal State" true true false 5 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,PSTLSTATE,-1,-1;PSTLZIP5 "Postal Zip 5" true true false 5 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,PSTLZIP5,-1,-1;PSTLZIP4 "Postal Zip +4" true true false 5 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,PSTLZIP4,-1,-1;FULL_POSTAL_ADDRESS "FULL_POSTAL_ADDRESS" true true false 150 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,FULL_POSTAL_ADDRESS,-1,-1;BUILDING "Building Number" true true false 50 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,BUILDING,-1,-1;UNIT "Unit Number" true true false 50 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,UNIT,-1,-1;CVTTXDSCRP "Tax District Description" true true false 100 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,CVTTXDSCRP,-1,-1;CVTTXCD "Tax District Code" true true false 4 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,CVTTXCD,-1,-1;SCHLDSCRP "School District Description" true true false 100 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,SCHLDSCRP,-1,-1;SCHLTXCD "School District Code" true true false 6 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,SCHLTXCD,-1,-1;PRE "PRE" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,PRE,-1,-1;STATEDAREA "Stated Area" true true false 50 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,STATEDAREA,-1,-1;ASSACRES "ASSACRES" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,ASSACRES,-1,-1;USECD "Assessing Use Code" true true false 4 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,USECD,-1,-1;USEDSCRP "Assessing Use Description" true true false 100 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,USEDSCRP,-1,-1;NGHBRHDCD "Assessing Neighbornood Code" true true false 10 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,NGHBRHDCD,-1,-1;CLASSCD "Property Class Code" true true false 10 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,CLASSCD,-1,-1;CLASSDSCRP "Property Class" true true false 100 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,CLASSDSCRP,-1,-1;CNVYNAME "Sub or Condo Name" true true false 250 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,CNVYNAME,-1,-1;FLOORCOUNT "Number of Floors" true true false 2 Short 0 5 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,FLOORCOUNT,-1,-1;BLDGAREA "Building Area" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,BLDGAREA,-1,-1;RESFLRAREA "Residential Floor Area" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,RESFLRAREA,-1,-1;RESYRBLT "Residential Year Built" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,RESYRBLT,-1,-1;RESSTRTYP "Residential Structure Type" true true false 50 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,RESSTRTYP,-1,-1;STRCLASS "Structure Class" true true false 5 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,STRCLASS,-1,-1;CLASSMOD "Structure Class Modifier" true true false 5 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,CLASSMOD,-1,-1;LNDVALUE "Land Value" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,LNDVALUE,-1,-1;IMPVALUE "IMPVALUE" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,IMPVALUE,-1,-1;PRVASSDVAL "Previous Assessed Value" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,PRVASSDVAL,-1,-1;CNTASSDVAL "Current Assessed Value" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,CNTASSDVAL,-1,-1;ASSDVALYRCG "Assessed Value Year Over Year Change" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,ASSDVALYRCG,-1,-1;ASSDPCNTCG "Assessed Value % Change" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,ASSDPCNTCG,-1,-1;PRVTXBLVAL "Previous Taxable Value" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,PRVTXBLVAL,-1,-1;CNTTXBLVAL "Current Taxable Value" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,CNTTXBLVAL,-1,-1;TXBLVALYRCHG "Taxable Value Year Over Year Change" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,TXBLVALYRCHG,-1,-1;TXBLPCNTCHG "Taxable Value % Change" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,TXBLPCNTCHG,-1,-1;PRVWNTTXOD "Previous Winter Taxes Owed" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,PRVWNTTXOD,-1,-1;PRVSMRTXOD "Previous Summer Taxes Owed" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,PRVSMRTXOD,-1,-1;TOTPRVTXTOD "Total Previous Taxes Owed" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,TOTPRVTXTOD,-1,-1;CNTWNTTXOD "Current Winter Taxes Owed" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,CNTWNTTXOD,-1,-1;CNTSMRTXOD "Current Summer Taxes Owed" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,CNTSMRTXOD,-1,-1;TOTCNTTXOD "Total Current Taxes Owed" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,TOTCNTTXOD,-1,-1;TXODYRCHG "Taxes Owed Year Over Year Change" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,TXODYRCHG,-1,-1;TXODPCNTCHG "Taxes Owed % Change" true true false 8 Double 8 38 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,TXODPCNTCHG,-1,-1;WATERSERV "Water Service Provider" true true false 50 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,WATERSERV,-1,-1;SEWERSERV "Sewer Service Provider" true true false 50 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,SEWERSERV,-1,-1;PRIMEZONE "PRIMEZONE" true true false 15 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,PRIMEZONE,-1,-1;PRPRTYDSCRP "Property Description" true true false 1073741822 Text 0 0 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,PRPRTYDSCRP,-1,-1;LGLSTARTDT "Legal Start Date" true true false 8 Date 0 0 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,LGLSTARTDT,-1,-1;LASTUPDATE "Last Update Date" true true false 8 Date 0 0 ,First,#,Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel,LASTUPDATE,-1,-1" #
Rename "Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\TaxParcel0" "Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel" FeatureClass
EnableEditorTracking "Database Connections\GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.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\GTCGIS.DBO.ParcelPublishing\GTCGIS.DBO.TaxParcel"
DeleteFeatures TaxParcel
DeleteFeatures TaxParcel
DeleteFeatures "Database Connections\DBO on GTCGISDB.sde\GTCGIS.DBO.ParcelPublishing\GTCGIS.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>GTCGIS.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>GTCGIS.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>GTCGIS.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>GTCGIS.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 #
GTCGIS.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
TaxParcel_Base
1
-85.829770
-85.327937
44.993077
44.507089
Tax parcels
full extent
Tax parcel layer zoomed out for use in other applications. Could be added to parcel viewer with visibility restricted in place of Tax Parcel Public.
SDE Feature Class
dataset
EPSG
5.3(9.0.0)
54494
Simple
FALSE
54494
TRUE
FALSE
GTCGIS.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
gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiimSyeWmcEnsBUVKkacHOb0Q0rleVw1
ztyflX+dRblK7styx4FIkeGJYHODkj1pjBRGWwfqT9a+Dr4mrO9WaSu29b+VvuWnY6UlsT2I3PI+
MdBV2qViWJbup6n0NXa+l4fs8BBrz/NmNX4wooor2jMKKKKACiiigAooooAKKKKACiiigAooooAK
KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooARiFBJqh5ks0h28HkFfQVdmjMsRQHB
PemW8Hkqc8sTk14uYYfE4rEQpK6prVtPr2/rTU0g1FN9SB28pwrgjdn5uO9Q7VcH5gTnPFS3hzMF
Iz8vAHr71DCmC7EH5cjpkV8xjG3jHh94pta9NFfy6ade5vH4blmykLmT0zmrdV7QDyi4H3iTVivr
8njOOCp87u3rf1d1+Bz1PiYUUUV6RAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRR
QAUUUUAFFFFABRRRQAUUUUAFFFFABQTgZNFIw3DGcVMr8rtuAisSSCMYpSQASTgCgKBk85PrVC6l
aSXy1Jwp5Fedj8f9Rw/PPWTdku76fgXGPM7IHIkd5sEqOBxTC+IT90Ak44yaaeTgMBntipi2VjiA
LAnnA4xXxqqOq5yvZu+2t5N+Tvb/AIB0WsXY1CxqF6Yp1FFfocIqEVFdDkCio2lAbavJ7+1Rrc7i
fkwB3zXLPH4eEuVy1+ZSi2WKKg+0fKGK4BzzUiSb1VsDDe9VTxlCo+WMtd9nt/TBxaH0UUV1EhRR
RQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQA122IzHsKy
0LId/XJ59Ku3b5URA8t1x2FVoE81zH/CGySO9fHZ3UliMbTo0nrHb/E9fy3+Z0U1aLbGhJZ5CVU4
3dfSrtvbLBkhiSalRFRQqjAFOr1cvySlhpKtVfNU3v0Te9v+CROo3otgpCQoJJwBS1WvSfs+Aep9
a9PGYj6vh51rX5VexnFXdhiSLcOwUHPdvalIEYXCjHX+VRoGSJcjlqOTEeRjHJ9elfKRxEnTvUX7
xq97W87W/N/8BG9tdNhhDuoCkkY4Gc4qzbNm2XjG01ApZcHcCQOh6kcdM1PafNa4+tGVJfW9G7uL
/C1rBP4SzRTQ4x1ApQwY4H8q+xVSDtruYWFoooqxBRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRR
QAUUUUAFFFFABRRRQAUUUUAFMlcRxlicelPqveyBICvduK5MfX9hhalW9rJ/f0KirySM9XYu3BJa
tWKMRRhQOe9ZKgHb83zEitmvluFIczqVJ6tWs+17t/8ABNq72QUUVBczGNQqcyN0FfW4jEQw9J1a
my/qy830MEm3ZEkkqRLljiq65un3umIwOAT+tQIBM3zAk+pycmpARApbBBYdM18zPMp4qSqVElRW
rXe3fTvbTTvdm3Jy6LceFPAYDI6fpSR5aPBjxx1P1qJcluVIwBnI9/pT4F2jewBB6DH/ANauejW9
pUikmlZ3v2030v8AqU1ZCANkYADe4+lTWgVdyrux1OfWq9yNqITuJYcYNFpKI5TuYBWHc1nh8VDD
ZjCnPTz7XX3K+l2Di3C6L78IxBwcdagtcm3Vs5IJzRcuJISI2Dc846YqCF2iQMAu0dcd69bF46EM
fF7xUXqtd2tflb+usRj7poA5GRRTIjuiUjuKfX0FOXPBS7oxYUUUVYBRRRQAUUUUAFFFFABRRRQA
UUUUAFFULmRvPZVZhgc4JpCzLtUzfMpIb5uteBPPoRqThyX5Xa9+t7f5v5M1VJ2uaFFZi3L7tpZu
uM7qehcbt0pJ6D5qilxFSqtKEG+/l/XkN0WtzQorLEjspbz2B9KkefGNrsT2GTShxHSlBzcbLfda
h7FmhRWYZ22DDvuzz14qTzC6/JK3HrnmnDiKjO6jHW3df1p1/wAw9i0WxPGWK7sEHHNSVjSZWTOQ
ec1oR3sTIMnaemDWeWcQQr1J0sU1BrbW1wnSsk4lms2/cmbZ2Aq+ZYx1dfzrMkBmuHYMCu7rntUc
T1+fCxoUndyey7L+kOiveuwhGZYwuQ2c1rVTs4gcyEk4JC59KuV0cN4SVDCucvtar0/4P5WJrSvK
wVTm3LdhioIIwCe1XKpagPuY+90rpz18mDdVbxaf4/8ABFS+KxCkL7WZBlT+dPeNtgymPYmnqriN
gdoPTaGwaZjlNoAAz3zk18x9Wp06ajZ6rbzv0TXns38rm122IC67WeMZ9+4qbe5AQIvAGDnioZFe
WUKAoKjtzQC6qTlWIAz7fpTpVpUZSinLl76a2WvS/b7rsGrgCylTtBOeMHmiLY7AGPgD/CohMxK7
kzgcYFEhZ2GAFbuBXCsZD44e8k1o1vt5d/yK5WXMERBV447f/qqASgRFXUEYzxR50qw5+XHTINLG
iHA2845JNejUxDrzjGjo+W1mtLPy+/sSlZal2L/VJ/uin02P/VJ9BTq+2oK1KPojme4UUUVqIKKK
KACiiigAooooAKKKKACiiigCpMgd3+XP4fWqLIxPQ5q5KjmRmVc9R0qJ0YxdQHHX1xivz3NaHt5y
bi1Zv56/mddN2K3G3GDnvTxydw5GQCKs2i27IVbBc9m/pUc9uYZBj7hPB9K83+za0cNDFRalF723
Xa/6/iXzq/KMkwCQmQp60hjZQM8KeuDU08SISpJ3H5hgfWok2uCHk4zxnNViMO413TnZS6JNJLyf
Zf5iT0uhBHyzSEgD1708qghAB2secYpZiQhOTtLYIPrVY5zmsK8qeFk4Rje63e+vp5bfO5SvLUna
3KqmRkv79KhcAOQOmam3kRJjORySefx+lNCI247snPA9feliaFOo1GirbPX0183rf8Egi2txkkRj
2c53DNLtLRg9hxUlwQ1xhmwBwCBVu3iXyMJJuGc5xXVhsqjicXUo0n7qut1fS3S99/kTKdopsW0n
jeNUGFYcYqzWY9m0fJeP2ycUNNIjBUl5HXnI/WvosNnVfB0lSxtKzjZaWu/ltf0Zi6ak7xZfmlEM
Zc8+grMZ3kzKTk5/KllMkiIWk3Z7elMz5e+M9+M14ucZrPGVUmnGmlp6tXTdvu8jWnTUV5kjSgZA
AOVA5HSh1MSITghh2qdVEzIwYfKM4PepRbnAPykY6EV0U8sr11KSd/5WumzbtfXqvxJc0hVjKHeO
AwAwPwqFrUdckZA6GpJMAD5QMDnH4e1OSRZkwFU4HQmvYqUMLWl7Ce+6Wu736foZpyWpSVMuvGMc
nPpThatxIzrs7nNTIMlcCPa3BB6nFNuFbYoAOCOg5rxfqFGFF1ZRcrbLbXS3lba/zNeZ3sI1mxQb
frnNNgaQyKFxheuD1q1HIyx7ZByPemOscceApRmHUHmu6eX0IOFeg3FJXkno9Nltpr3IU3syyn+r
X6CnU1PuL9BTq+xpfAvQwe4UUUVYgooooAKKKKACiiigAooooAKKKKAKSyMlzIcZHJqpu/e7ieCf
zFaCwkhmBALE9RniqcluAqsuST1z0r4DNcHi1SjJapNy+9rtqzqhKNyJMtIqg4zwD6VqbDu2k8bc
CssOVICqu4Hggc1ozyNFD5hI3YwBjvVcP1KVOjWnO75bN9ra6f15BVTbSRUaBzLtlOAF4PXNAgAV
ySQoHWo5p2lKFj0HYd6XepiQO3fnHpXlurgnVnyRulqnJ73srP0+/uXaVtRxiUIXOTjHA75qIJJn
5VYCpgwOHbmNeMjrUtvKCgGduPbtWkMJh8RVjDm5PTd+fp0WvQOZpFUEpkZByCKaqZIz3qxJHuRp
ARtA+XH4VFgjYxwQecDmuKvhZU5KM9YrVel7f16lKVxHjCqpBySMn2qxEG8gASlTnPB+lVySEBIH
J6GnI3lnKsQSPStsLUpUq7layaS3s1+P6ikm0SFFMRZ3ySP4qaSgjyQDJ05p0rsY0Un7y8DFNkyr
qDjAHUDNdVdQjdwWySba6vq9d7aq+xK8wKn7Kvbae3eopCrfMowfrUqBnyEI2Ack8VCRuwB15zzX
Di9aceVaNJerjpp/wN7dSo7l2NhJkqF+VemMU75kA4yewz/9aoRGvlKMbjg4wcZq2qOoZmwzEdc1
9VgVUqxXNukm2tVrr232tq110WhhKyIGDsSmEB9jToY5I9zqqYI6ZPH6VMVP3tq9PWgqdp+QY212
LActT2rbur20/wCB6k82litKzpsURoOMjHNSqZhjeitxxg1KSdpG3oPWkfeYvlXn3NUsG6c51FUk
9FZJdulrWfloHNfSxGSz5GNuBzg5NSqAiHCHp1oxhSdnJHJoct5ZwvauunS9nec23K3b/gaEt30H
r90fSlpB0FLXpw0iiAoooqgCiiigAooooAKKKKACiiigAooooAjVE8sEqOmc4qBQsluQOGOMZNKg
82L5V46E1FM6eXnADbRxXzOJxEFSVRxXLyv537O3T9TaK1sVAuG+fIrT3iK1DSHfx1HOazX3Fueu
O9Txxso2ueP7ueK+byjETwtSrGlC91a72Xa62f572Nqi5krg4Lq8rqv3eAKjEapjzTgNwcdquBF2
MuMgDOBVZopNhV1O0dD6VvjcC4tVOXmdm77q99ebbfZdhRl0EGw2UnIyG4qYKFgOOQVzx/8Aqqug
UZUuNp5DDoDTlndVwQACCM44IrDDYqlBL2qt7vLprs357O//AARuLewqPm1KAYNNK7VVcgE9BSQv
8pU4x3B71IFYy8jkDv3NZU74ilB7uyj6DejCSNyw2qHA9OnamyO4QADGBUm9iu0OoIHr16cVHkKs
bbgxz09K3xEYXm6ba5t9rbpadd/61Er9QcPIqllHyrwAc0zbK5Ykk4GDzUk7SbUZmBUgYANJLcSF
9zDAYdAa5q8aCnJ1JTW19N7rd20SWlu/Qav0AkiPcqAA+9AQSsWVflPUZ4FRK5KlTyCcmkDFT7Ed
xXP9apy5XJXj200f3Wtrt8uiK5WaKRCKJsbT8vXNK85DCPZywPOazyoAUq2Qep9DV0xsAJCSzAEc
n6+1fTYPH1KsHToQ5FHlvazVr69Oq2MJRSd3qOM+d6H5dvB560odcNs2/d5AqqUZ7iQ7Qc5xnPap
8bNw8r+EDIBrejjcRVk5T2TavZ3626aaWE4pbEx3hGJAPHrTiWCH5e3rSOzbGG3+H1pjTHBwOOn4
17M60KTacnt29e6M0mxzSYXBHJHTNK7MIz8h6eoqAuGbL4zj5cGp3Y+W3yHofSs6dd1YzfM9Fpp+
en9IbVrEnaiiivXRmFFFFABRRRQAUUUUAFFFFABRRRQAUHpRSHoaT2AzVuivy7VC+wocGLBf956Z
ORTHhIXIwccmmiY9HJcfWvy2WIqxXs8S9fsvovVfd00O6y3RJC8ZMjygkHjAq2xTaBhs44yaoR5L
FAOTzx7VNCAyksxYgcEHpXZleMmqapcqd76tebb/AAat2InHW4puQg/duc55yKW4ZpVRlLnAyeKj
WLYd4JPpgVYZgbdxgqQPTr+lbUpYivSqU8RLlTV0l5a6a21t1+W4OyaaKkbquQ2SCe1P+zk7j8xU
cjj+lVzjtn8aUO394j8a8CliqaSp148yW1nb+lc1cXuiZIhgYPP0p5j3EMjEccluPyqBJWjDBOjD
ByKtzylVjwQysMcV6mD+qzoSk9OWzfreys7/AH6dfvzlzJlVgZCuBlj6d6tRxKgwQucd6iZWdcrw
Bzjp+VRlmIGTlR09qzpOGFm6k4czez0t2f8Aw/yY3eSsiw77TtVQ25ckdqa8g7uOV4A5/ClEYJJW
TAC4xTWUx/KqBh6g131ZV+VyekX8/u5ddXff7iVYc0is2MKpIxkd6hZfLcOVDpn8DS+YGypTJJ4y
eQatrbuF2lgV7AcVNOhUzFtw1cdbpbPzTsmtP8+oNqBVRHnJZRhV52jpT2lkxvypzkYH8NWnPlxs
NgAweR/+qot0MhJVV3YPH+RXZLL1QSgq1pvfpd30svLa3noTz31toOSNvL3lcMV5yec0s4ZVB2jH
oPoafI7fd29uTmmZLqQpxs6jPPevVqU6dOm6MG727btavp82Zptu7InEhGWyvHQfj1oWNgpZyehO
O1WGVgjkgHg809yfLb5e3rUrLYuTnNu6V9b+e/QfOV0UOnmBOMccfWpiX2NuXtQcJHtChRjgZpXL
eW3y44rso0FRptXfNy62Wjdn5fcS3dklFFFewZhRRRQAUUUUAFFFFABRRRQAUUUUAFI3Cn6UtI33
D9KmfwsDLkCtyRg4/hH86mjggjYJIyuT0xTIwoXeWO7B6nr1qWGIKDPKwII9c18BgsOp1Y1HTi29
bvZRW7fTU65OytccYIkmBRipKkjmnxwJCDIxPqcngUsm2Ib+iAcexpLhGntx5Z6849a+g+r0aDqS
hSTnFcyivNWvb5dvxMbt210K88i7v3Z+U91PemNCCm8ODgdu9STKA0cK7VIGT9cU6SP90yqMD0H/
AOqvDq0JV6lV1EnbtfSVr2WvTrc1TslYrravvVW4BGaHt3I/gwo7U9lkO0g9uaidpF4LevTvXl1a
OFowadOVu9/JW/z/AALTk3uWEgMijc6nYMgrzmmyxqsSqrbse1SRzAAKCASpzkcipFwDwQTjt/8A
rr3KeFw1alyw3as3q30srX12X3Gbk09RdsiqMEkY5/zmkNsNu7gd+BThISMZXpSklcgsB8vevZdH
DzjdxbXn0fkZ3ZW+zDJcHgc4FDW4Me8Zyed3WrJJKv04XFV/30kYjcYI5znr1rya+Cw1L3VTbbTa
06379PL5lqUn1GMWwq7eVOc/jVxZSc5AA9apKrT7z90g9xVpoW8radhODziqyyeIXPVpJuNvLW10
vMJ22ZFJd7t0ezrwDmlFvJGjHKbick47elL5JVSDtJXHP+RU7l9jcL09a6qWGqVnKrjG3JLSytbe
+35kuSWkSMw4BO1cYP8AWgAKhEe3j7x7n9KeRJsbdggj1/8ArVGYWGTwB1wD/wDWrpqUlTd6UHtr
pqtxJ33HMsgVzxgg5Gac25YWGOx70shby2yo6etNd2KsAMcVvJU6Tkk3qvzv3ROrGhmEADrk885p
7SblYBT09RTC3mFvlOF4PP1qNtvIVgvsCOevvXJLETpxtB3ja3m7XXVdyrXLlFFFfQmQUUUUAFFF
FABRRRQAUUUUAFFFFABSN9w/SlpG+6fpUz+FgigQ2wKVG30VulXFCPAAo+QjjNUnjMETfvMk46Dp
1qxA3k2q55brivlMrqeyryp14293W9nazslp31dvl0N5q6uiuJJJcQq2COOnpUlu7wiVCchDx9ab
HkSGQZ5ySQOtPBZpjx8uDk4+tcmFUoyhWc3z3aXVcrWnXpu+mnzKl2Imw7FjyW54/H2qQJvMpV8A
c8rUQO53bdypwCo9qe6gRk7ifp+NZUpxalUcbrV727ro77tvr6ja6D1wJMZIBQnkVCyghvmUgcA0
/wApeNzndg/j1pjKVYhSMep9qWIc3BKUNLvrfdbWv3BEoEauzA8nuR9elSOcJwwORxUbc7iW6Dt3
p7fKp9hyB/8Arr06T5YzjFJLV6ed/MhkZLOVxJtX6/8A16laV8FcrjHX/JqtIhlCldvA556frTmV
kI+fdgf571xU8VWg52i7O2qej07f5FOKZNksjYJ9P880NlEfLBjjPTpQeGKlVHIPH86WU+VEfu/M
O1elJWhKctOVO7181t/ViDPU4fIbAzUwmZX3uAwPHTFNaJ1cPjIGCaezCeLgKvNfJ4enWoqUeZxk
tUtdf08v1N20xZpFYArjAIPHf2p5mIjOCFGRnPf26Uwx8AlQNowD7+tI8eV3AfMCM4HH8q9J1cVF
zmt2vTv/AF+pFo7FlbnzEOExxThPvDDYRj171BtJyChAC9hjtTZZDCihU9skV6f9pYinBzrS0S1d
t/lbzI5E9i3I/wC6OV4PFQs5yQdoBBx60nnq0K5H1AoKgoX9uOa2rYv6w70pX0T/AM+glG241W4c
jcQDyRimMDJMNoHr+GaGjA55wR39amZFU5T5c4HB615io1KseSa0Vr93u9NC7pbFuiiivujmCiii
gAooooAKKKKACiiigAooooAKRvuH6UUVFT4GCKcjh8xqAeuT+dMZ1RfLXKBh1oor4CviZ+zlW635
florfM60lexKFTYQoBHOOPr7U5EVUfllLZyMfWiivaoKLjGfKtrel10/IzZAypGCsRJ9ePr7UBXK
FiQQFOKKK8qjFVJtWsknottH/TLeiHFWDl93OPy4pNxZXJf3/n60UVrWXJPlWz5nu+wlqBXZG5LA
tj+KgyMVH7zHynPvRRWVZ+xlyQ0VvPuxrXcElVRx+g+vvSA+Zy2C2OC3brRRXPSxE6jjCW3b1sNq
2osk0gbLAEDjg1DNKZiqcYHeiisMzxNb2zoOTcZPX72OCVrkixnygnABYE8HmlaJiioNoyQKKK9a
nhKUouL7JfIhyY3DIpBIHGBim4Zvvqex/CiivPq0rTcLu0f+DuWmWCH2EqoU44PqKjlSRfvgE56j
miivXxWGj9XlO70t6dehmnrYZEXyw28E46dP/rVJlip+YEg88niiivMwqfs0m273/wAy5bkUzsAQ
T+R4pYSxde657miiuSm3PH8jei/zG9ImnRRRX6acYUUUUAFFFFABRRRQB//Z