ModelBuilder will not overwrite output

463
6
10-21-2021 01:40 PM
Labels (2)
TychoGranville
Occasional Contributor II

I have a simple model that exports records from a feature class to a CSV file. It works the first time, after that it gives me the error file already exists (see below) instead of overwriting the file. The setting is correct in my options:

setting.PNG

and I get this error:

tabletotable.PNG

If I remove the CSV file using the catalog pane (or even go into File Explorer and remove both the CSV and XML) and refresh the model still fails, stating the CSV already exists. I have to completely exit out of Pro and restart for it to work.

Any ideas?

Thanks,

Tycho

0 Kudos
6 Replies
ABishop
Regular Contributor III

Can you export the model to a python script and then modify the arcpy.env.overwriteOutput to equal "True"?  This is how I run my model scripts and it works each time.  I think there is also a way to create a model tool to run, but I haven't explored that yet. See below code for one of my model scripts exported from ModelBuilder.

import arcpy

#start timer
startTime = time.perf_counter()

def MerlinGISUpdateDaily():  # MerlinGIS UpdateDaily

    # To allow overwriting outputs change overwriteOutput option to True.
    arcpy.env.overwriteOutput = True

    mcpagis_DBO_ParcelPolys_2_ = "C:\\Users\\abishop\\AppData\\Roaming\\Esri\\ArcGISPro\\Favorites\\arcgis2.sde\\mcpagis.DBO.ParcelPolys"
    parcel_shp_2_ = "W:\\MiscLayerData\\Parcel\\parcel.shp"
    mcpagis_DBO_papoly_2_ = "C:\\Users\\abishop\\AppData\\Roaming\\Esri\\ArcGISPro\\Favorites\\arcgis2.sde\\mcpagis.DBO.papoly"
    papoly_shp_2_ = "W:\\MiscLayerData\\Parcel\\papoly.shp"
    mcpagis_DBO_Freepapoly_2_ = "C:\\Users\\abishop\\AppData\\Roaming\\Esri\\ArcGISPro\\Favorites\\arcgis2.sde\\mcpagis.DBO.Freepapoly"
    freepapoly_shp_2_ = "W:\\MiscLayerData\\Parcel\\freepapoly.shp"
    mcpagis_DBO_Futurepapoly_2_ = "C:\\Users\\abishop\\AppData\\Roaming\\Esri\\ArcGISPro\\Favorites\\arcgis2.sde\\mcpagis.DBO.Futurepapoly"
    Futurepapoly_shp_2_ = "W:\\MiscLayerData\\Parcel\\Futurepapoly.shp"
    mcpagis_DBO_FutureFreepapoly_2_ = "C:\\Users\\abishop\\AppData\\Roaming\\Esri\\ArcGISPro\\Favorites\\arcgis2.sde\\mcpagis.DBO.FutureFreepapoly"
    FutureFreepapoly_shp_2_ = "W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp"
    mcpagis_DBO_Sales2020Imp_2_ = "C:\\Users\\abishop\\AppData\\Roaming\\Esri\\ArcGISPro\\Favorites\\arcgis2.sde\\mcpagis.DBO.Sales2020Imp"
    qisales2020_shp = "W:\\MiscLayerData\\Parcel\\qisales2020.shp"
    mcpagis_DBO_Sales2020Vac_2_ = "C:\\Users\\abishop\\AppData\\Roaming\\Esri\\ArcGISPro\\Favorites\\arcgis2.sde\\mcpagis.DBO.Sales2020Vac"
    qvsales2020_shp = "W:\\MiscLayerData\\Parcel\\qvsales2020.shp"
    mcpagis_DBO_Sales2021Imp_2_ = "C:\\Users\\abishop\\AppData\\Roaming\\Esri\\ArcGISPro\\Favorites\\arcgis2.sde\\mcpagis.DBO.Sales2021Imp"
    mcpagis_DBO_Sales2021Vac_2_ = "C:\\Users\\abishop\\AppData\\Roaming\\Esri\\ArcGISPro\\Favorites\\arcgis2.sde\\mcpagis.DBO.Sales2021Vac"
    qisales2021_shp = "W:\\MiscLayerData\\Parcel\\qisales2021.shp"
    qvsales2021_shp = "W:\\MiscLayerData\\Parcel\\qvsales2021.shp"
    mcpagis_DBO_Commercial_Sales_2_ = "C:\\Users\\abishop\\AppData\\Roaming\\Esri\\ArcGISPro\\Favorites\\arcgis2.sde\\mcpagis.DBO.Commercial_Sales"
    COMM_SALES_shp_2_ = "W:\\MiscLayerData\\Parcel\\COMM_SALES.shp"
    mcpagis_DBO_Exempt21_2_ = "C:\\Users\\abishop\\AppData\\Roaming\\Esri\\ArcGISPro\\Favorites\\arcgis2.sde\\mcpagis.DBO.Exempt21"
    Exempt21_shp_2_ = "W:\\MiscLayerData\\Parcel\\Exempt21.shp"
    mcpagis_DBO_LandRateAC_2_ = "C:\\Users\\abishop\\AppData\\Roaming\\Esri\\ArcGISPro\\Favorites\\arcgis2.sde\\mcpagis.DBO.LandRateAC"
    mcpagis_DBO_LandRateNoAC_2_ = "C:\\Users\\abishop\\AppData\\Roaming\\Esri\\ArcGISPro\\Favorites\\arcgis2.sde\\mcpagis.DBO.LandRateNoAC"
    mcpagis_DBO_No_lndRTEchg_19_to_21_All_2_ = "C:\\Users\\abishop\\AppData\\Roaming\\Esri\\ArcGISPro\\Favorites\\arcgis2.sde\\mcpagis.DBO.No_lndRTEchg_19_to_21_All"
    lrateac_shp_2_ = "W:\\MiscLayerData\\Parcel\\lrateac.shp"
    lratenoac_shp_2_ = "W:\\MiscLayerData\\Parcel\\lratenoac.shp"
    No_lndRTEchg_19_to_21_All_shp_2_ = "W:\\MiscLayerData\\Parcel\\No_lndRTEchg_19_to_21_All.shp"
    mcpagis_DBO_Tangible_2_ = "C:\\Users\\abishop\\AppData\\Roaming\\Esri\\ArcGISPro\\Favorites\\arcgis2.sde\\mcpagis.DBO.Tangible"
    tang_shp_2_ = "W:\\MiscLayerData\\Parcel\\tang.shp"
    mcpagis_DBO_LandValueChange2022_2_ = "C:\\Users\\abishop\\AppData\\Roaming\\Esri\\ArcGISPro\\Favorites\\arcgis2.sde\\mcpagis.DBO.LandValueChange2022"
    Valchg22_shp = "K:\\GIS_UPDATE\\DATA\\SHP\\Valchg22.shp"
    mcpagis_DBO_LandRateChange2022_2_ = "C:\\Users\\abishop\\AppData\\Roaming\\Esri\\ArcGISPro\\Favorites\\arcgis2.sde\\mcpagis.DBO.LandRateChange2022"
    lndchg22_shp = "K:\\GIS_UPDATE\\DATA\\SHP\\lndchg22.shp"
    mcpagis_DBO_LandModel_2_2_ = "C:\\Users\\abishop\\AppData\\Roaming\\Esri\\ArcGISPro\\Favorites\\arcgis2.sde\\mcpagis.DBO.LandModel_2"
    LandModel_shp = "W:\\MiscLayerData\\Parcel\\LandModel.shp"

    # Process: Truncate Table (Truncate Table) (management)
    mcpagis_DBO_ParcelPolys_4_ = arcpy.management.TruncateTable(in_table=mcpagis_DBO_ParcelPolys_2_)[0]

    # Process: Append (Append) (management)
    mcpagis_DBO_ParcelPolys_5_ = arcpy.management.Append(inputs=[parcel_shp_2_], target=mcpagis_DBO_ParcelPolys_2_, schema_type="NO_TEST", field_mapping="PARCEL \"PARCEL\" true true false 12 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\parcel.shp,PARCEL,0,12;PREFIX \"PREFIX\" true true false 6 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\parcel.shp,PREFIX,0,6;SUFFIX1 \"SUFFIX1\" true true false 5 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\parcel.shp,SUFFIX1,0,5;SUFFIX2 \"SUFFIX2\" true true false 5 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\parcel.shp,SUFFIX2,0,5;GIS_ACRES \"GIS_ACRES\" true true false 8 Double 8 18,First,#,W:\\MiscLayerData\\Parcel\\parcel.shp,GIS_ACRES,-1,-1;KIND \"KIND\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\parcel.shp,KIND,-1,-1;ANGLE \"ANGLE\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\parcel.shp,ANGLE,-1,-1;SIZE_ \"SIZE_\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\parcel.shp,SIZE_,-1,-1;DATE_CREAT \"DATE_CREAT\" true true false 8 Date 0 0,First,#,W:\\MiscLayerData\\Parcel\\parcel.shp,DATE_CREAT,-1,-1;DATE_UPDAT \"DATE_UPDAT\" true true false 8 Date 0 0,First,#,W:\\MiscLayerData\\Parcel\\parcel.shp,DATE_UPDAT,-1,-1;FIC \"FIC\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\parcel.shp,FIC,0,1", subtype="", expression="")[0]

    # Process: Truncate Table (2) (Truncate Table) (management)
    mcpagis_DBO_papoly_4_ = arcpy.management.TruncateTable(in_table=mcpagis_DBO_papoly_2_)[0]

    # Process: Append (2) (Append) (management)
    mcpagis_DBO_papoly_5_ = arcpy.management.Append(inputs=[papoly_shp_2_], target=mcpagis_DBO_papoly_2_, schema_type="NO_TEST", field_mapping="PARCEL \"PARCEL\" true true false 12 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,PARCEL,0,12;PREFIX \"PREFIX\" true true false 6 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,PREFIX,0,6;SUFFIX1 \"SUFFIX1\" true true false 5 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,SUFFIX1,0,5;SUFFIX2 \"SUFFIX2\" true true false 5 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,SUFFIX2,0,5;GIS_ACRES \"GIS_ACRES\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,GIS_ACRES,-1,-1;KIND \"KIND\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,KIND,-1,-1;ANGLE \"ANGLE\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,ANGLE,-1,-1;SIZE_ \"SIZE_\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,SIZE_,-1,-1;DATE_CREAT \"DATE_CREAT\" true true false 8 Date 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,DATE_CREAT,-1,-1;DATE_UPDAT \"DATE_UPDAT\" true true false 8 Date 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,DATE_UPDAT,-1,-1;FIC \"FIC\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,FIC,0,1;ALT_KEY \"ALT_KEY\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,ALT_KEY,0,10;PC \"PC\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,PC,0,10;HX \"HX\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,HX,0,10;AG \"AG\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,AG,0,10;NAME \"NAME\" true true false 100 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,NAME,0,100;ADD_1 \"ADD_1\" true true false 100 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,ADD_1,0,100;ADD_2 \"ADD_2\" true true false 100 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,ADD_2,0,100;ADD_3 \"ADD_3\" true true false 100 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,ADD_3,0,100;ADD_4 \"ADD_4\" true true false 100 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,ADD_4,0,100;ZIP \"ZIP\" true true false 20 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,ZIP,0,20;SITUS_1 \"SITUS_1\" true true false 100 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,SITUS_1,0,100;SITUS_2 \"SITUS_2\" true true false 100 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,SITUS_2,0,100;MILL_GRP \"MILL_GRP\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,MILL_GRP,-1,-1;NABRHD \"NABRHD\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,NABRHD,0,10;BK1 \"BK1\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,BK1,0,10;PG1 \"PG1\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,PG1,0,10;MO1 \"MO1\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,MO1,-1,-1;YR1 \"YR1\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,YR1,-1,-1;Q1 \"Q1\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,Q1,0,1;VI1 \"VI1\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,VI1,0,1;INST1 \"INST1\" true true false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,INST1,0,2;PR_1 \"PR_1\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,PR_1,-1,-1;MAP_NBR \"MAP_NBR\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,MAP_NBR,-1,-1;TWP \"TWP\" true true false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,TWP,0,2;RGE \"RGE\" true true false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,RGE,0,2;SEC \"SEC\" true true false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,SEC,0,2;ACRES \"ACRES\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,ACRES,-1,-1;LND1 \"LND1\" true true false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,LND1,0,4;LND2 \"LND2\" true true false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,LND2,0,4;LND3 \"LND3\" true true false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,LND3,0,4;ZONE1 \"ZONE1\" true true false 5 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,ZONE1,0,5;ZONE2 \"ZONE2\" true true false 5 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,ZONE2,0,5;ZONE3 \"ZONE3\" true true false 5 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,ZONE3,0,5;BLDS \"BLDS\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,BLDS,-1,-1;WALL \"WALL\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,WALL,-1,-1;AGE \"AGE\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,AGE,-1,-1;COND \"COND\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,COND,-1,-1;ARCH \"ARCH\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,ARCH,0,1;USE_SF \"USE_SF\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,USE_SF,-1,-1;YRBLT1 \"YRBLT1\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,YRBLT1,-1,-1;QUAL1 \"QUAL1\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,QUAL1,-1,-1;TYPE1 \"TYPE1\" true true false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,TYPE1,0,2;POOL \"POOL\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,POOL,0,1;STRY \"STRY\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,STRY,-1,-1;BLD1_SF \"BLD1_SF\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,BLD1_SF,-1,-1;WELL \"WELL\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,WELL,0,1;SEPTIC \"SEPTIC\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,SEPTIC,0,1;ASSD_VAL \"ASSD_VAL\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,ASSD_VAL,-1,-1;TOT_VAL \"TOT_VAL\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,TOT_VAL,-1,-1;TOT_LND_VA \"TOT_LND_VA\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,TOT_LND_VA,-1,-1;TOT_BLD_VA \"TOT_BLD_VA\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,TOT_BLD_VA,-1,-1;TOT_MISC_V \"TOT_MISC_V\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,TOT_MISC_V,-1,-1;TOT_TAX_VA \"TOT_TAX_VA\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,TOT_TAX_VA,-1,-1;TOT_TAXES \"TOT_TAXES\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,TOT_TAXES,-1,-1;APP_DATE \"APP_DATE\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,APP_DATE,-1,-1;APP_ID \"APP_ID\" true true false 3 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,APP_ID,0,3;SOS \"SOS\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,SOS,0,1;SU \"SU\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,SU,0,1;HX_YR \"HX_YR\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,HX_YR,-1,-1;STR \"STR\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,STR,-1,-1;GRP \"GRP\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,GRP,-1,-1;CITY \"CITY\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,CITY,-1,-1;VM \"VM\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,VM,-1,-1;CF \"CF\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,CF,0,1;CL_VAL \"CL_VAL\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,CL_VAL,-1,-1;N_CONS \"N_CONS\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,N_CONS,-1,-1;MKT_ADJ \"MKT_ADJ\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,MKT_ADJ,-1,-1;DATE_CRE_1 \"DATE_CRE_1\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,DATE_CRE_1,0,10;DATE_L_UPD \"DATE_L_UPD\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,DATE_L_UPD,0,10;B_UP \"B_UP\" true true false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,B_UP,0,4;PPAR \"PPAR\" true true false 12 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,PPAR,0,12;RESUSESF \"RESUSESF\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,RESUSESF,-1,-1;RESTOTSF \"RESTOTSF\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,RESTOTSF,-1,-1;COMUSESF \"COMUSESF\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,COMUSESF,-1,-1;COMTOTSF \"COMTOTSF\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,COMTOTSF,-1,-1;RESBLDS \"RESBLDS\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,RESBLDS,-1,-1;COMBLDS \"COMBLDS\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,COMBLDS,-1,-1;LAVALUE \"LAVALUE\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,LAVALUE,-1,-1;MRKT_AREA \"MRKT_AREA\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,MRKT_AREA,-1,-1;BEDS \"BEDS\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,BEDS,-1,-1;BATHS \"BATHS\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,BATHS,-1,-1;GARAGE \"GARAGE\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,GARAGE,0,1;FIRE \"FIRE\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,FIRE,0,1;LOCOBS \"LOCOBS\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,LOCOBS,-1,-1;FUNCOBS \"FUNCOBS\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,FUNCOBS,-1,-1;SEC_5 \"SEC_5\" true true false 3 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,SEC_5,0,3;LANDREV \"LANDREV\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,LANDREV,0,1;NBRUNITS \"NBRUNITS\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,NBRUNITS,-1,-1;MH \"MH\" true true false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,MH,0,4;RTE \"RTE\" true true false 25 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,RTE,0,25;HXUNDELIVE \"HXUNDELIVE\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,HXUNDELIVE,0,1;ROADTYPE \"ROADTYPE\" true true false 3 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,ROADTYPE,0,3;SUBTYPE \"SUBTYPE\" true true false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,SUBTYPE,0,2;SINKHOLE \"SINKHOLE\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,SINKHOLE,0,1;A \"A\" true true false 3 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,A,0,3;B \"B\" true true false 3 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,B,0,3;C \"C\" true true false 3 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,C,0,3;D \"D\" true true false 3 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,D,0,3;E \"E\" true true false 5 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,E,0,5;F \"F\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\papoly.shp,F,0,10", subtype="", expression="")[0]

    # Process: Truncate Table (3) (Truncate Table) (management)
    mcpagis_DBO_Freepapoly_4_ = arcpy.management.TruncateTable(in_table=mcpagis_DBO_Freepapoly_2_)[0]

    # Process: Append (3) (Append) (management)
    mcpagis_DBO_Freepapoly_5_ = arcpy.management.Append(inputs=[freepapoly_shp_2_], target=mcpagis_DBO_Freepapoly_2_, schema_type="NO_TEST", field_mapping="PARCEL \"PARCEL\" true true false 12 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,PARCEL,0,12;PREFIX \"PREFIX\" true true false 6 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,PREFIX,0,6;SUFFIX1 \"SUFFIX1\" true true false 5 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,SUFFIX1,0,5;SUFFIX2 \"SUFFIX2\" true true false 5 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,SUFFIX2,0,5;GIS_ACRES \"GIS_ACRES\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,GIS_ACRES,-1,-1;KIND \"KIND\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,KIND,-1,-1;ANGLE \"ANGLE\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,ANGLE,-1,-1;SIZE_ \"SIZE_\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,SIZE_,-1,-1;DATE_CREAT \"DATE_CREAT\" true true false 8 Date 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,DATE_CREAT,-1,-1;DATE_UPDAT \"DATE_UPDAT\" true true false 8 Date 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,DATE_UPDAT,-1,-1;FIC \"FIC\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,FIC,0,1;ALT_KEY \"ALT_KEY\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,ALT_KEY,0,10;PC \"PC\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,PC,0,10;HX \"HX\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,HX,0,10;AG \"AG\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,AG,0,10;NAME \"NAME\" true true false 100 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,NAME,0,100;ADD_1 \"ADD_1\" true true false 100 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,ADD_1,0,100;ADD_2 \"ADD_2\" true true false 100 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,ADD_2,0,100;ADD_3 \"ADD_3\" true true false 100 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,ADD_3,0,100;ADD_4 \"ADD_4\" true true false 100 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,ADD_4,0,100;ZIP \"ZIP\" true true false 20 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,ZIP,0,20;SITUS_1 \"SITUS_1\" true true false 100 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,SITUS_1,0,100;SITUS_2 \"SITUS_2\" true true false 100 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,SITUS_2,0,100;MILL_GRP \"MILL_GRP\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,MILL_GRP,-1,-1;NABRHD \"NABRHD\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,NABRHD,0,10;BK1 \"BK1\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,BK1,0,10;PG1 \"PG1\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,PG1,0,10;MO1 \"MO1\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,MO1,-1,-1;YR1 \"YR1\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,YR1,-1,-1;Q1 \"Q1\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,Q1,0,1;VI1 \"VI1\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,VI1,0,1;INST1 \"INST1\" true true false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,INST1,0,2;PR_1 \"PR_1\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,PR_1,-1,-1;MAP_NBR \"MAP_NBR\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,MAP_NBR,-1,-1;TWP \"TWP\" true true false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,TWP,0,2;RGE \"RGE\" true true false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,RGE,0,2;SEC \"SEC\" true true false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,SEC,0,2;ACRES \"ACRES\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,ACRES,-1,-1;LND1 \"LND1\" true true false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,LND1,0,4;LND2 \"LND2\" true true false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,LND2,0,4;LND3 \"LND3\" true true false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,LND3,0,4;ZONE1 \"ZONE1\" true true false 5 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,ZONE1,0,5;ZONE2 \"ZONE2\" true true false 5 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,ZONE2,0,5;ZONE3 \"ZONE3\" true true false 5 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,ZONE3,0,5;BLDS \"BLDS\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,BLDS,-1,-1;WALL \"WALL\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,WALL,-1,-1;AGE \"AGE\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,AGE,-1,-1;COND \"COND\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,COND,-1,-1;ARCH \"ARCH\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,ARCH,0,1;USE_SF \"USE_SF\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,USE_SF,-1,-1;YRBLT1 \"YRBLT1\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,YRBLT1,-1,-1;QUAL1 \"QUAL1\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,QUAL1,-1,-1;TYPE1 \"TYPE1\" true true false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,TYPE1,0,2;POOL \"POOL\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,POOL,0,1;STRY \"STRY\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,STRY,-1,-1;BLD1_SF \"BLD1_SF\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,BLD1_SF,-1,-1;WELL \"WELL\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,WELL,0,1;SEPTIC \"SEPTIC\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,SEPTIC,0,1;ASSD_VAL \"ASSD_VAL\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,ASSD_VAL,-1,-1;TOT_VAL \"TOT_VAL\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,TOT_VAL,-1,-1;TOT_LND_VA \"TOT_LND_VA\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,TOT_LND_VA,-1,-1;TOT_BLD_VA \"TOT_BLD_VA\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,TOT_BLD_VA,-1,-1;TOT_MISC_V \"TOT_MISC_V\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,TOT_MISC_V,-1,-1;TOT_TAX_VA \"TOT_TAX_VA\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,TOT_TAX_VA,-1,-1;TOT_TAXES \"TOT_TAXES\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,TOT_TAXES,-1,-1;APP_DATE \"APP_DATE\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,APP_DATE,-1,-1;APP_ID \"APP_ID\" true true false 3 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,APP_ID,0,3;SOS \"SOS\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,SOS,0,1;SU \"SU\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,SU,0,1;HX_YR \"HX_YR\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,HX_YR,-1,-1;STR \"STR\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,STR,-1,-1;GRP \"GRP\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,GRP,-1,-1;CITY \"CITY\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,CITY,-1,-1;VM \"VM\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,VM,-1,-1;CF \"CF\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,CF,0,1;CL_VAL \"CL_VAL\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,CL_VAL,-1,-1;N_CONS \"N_CONS\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,N_CONS,-1,-1;MKT_ADJ \"MKT_ADJ\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,MKT_ADJ,-1,-1;DATE_CRE_1 \"DATE_CRE_1\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,DATE_CRE_1,0,10;DATE_L_UPD \"DATE_L_UPD\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,DATE_L_UPD,0,10;B_UP \"B_UP\" true true false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,B_UP,0,4;PPAR \"PPAR\" true true false 12 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,PPAR,0,12;RESUSESF \"RESUSESF\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,RESUSESF,-1,-1;RESTOTSF \"RESTOTSF\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,RESTOTSF,-1,-1;COMUSESF \"COMUSESF\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,COMUSESF,-1,-1;COMTOTSF \"COMTOTSF\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,COMTOTSF,-1,-1;RESBLDS \"RESBLDS\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,RESBLDS,-1,-1;COMBLDS \"COMBLDS\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,COMBLDS,-1,-1;LAVALUE \"LAVALUE\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,LAVALUE,-1,-1;MRKT_AREA \"MRKT_AREA\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,MRKT_AREA,-1,-1;BEDS \"BEDS\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,BEDS,-1,-1;BATHS \"BATHS\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,BATHS,-1,-1;GARAGE \"GARAGE\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,GARAGE,0,1;FIRE \"FIRE\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,FIRE,0,1;LOCOBS \"LOCOBS\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,LOCOBS,-1,-1;FUNCOBS \"FUNCOBS\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,FUNCOBS,-1,-1;SEC_5 \"SEC_5\" true true false 3 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,SEC_5,0,3;LANDREV \"LANDREV\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,LANDREV,0,1;NBRUNITS \"NBRUNITS\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,NBRUNITS,-1,-1;MH \"MH\" true true false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,MH,0,4;RTE \"RTE\" true true false 25 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,RTE,0,25;HXUNDELIVE \"HXUNDELIVE\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,HXUNDELIVE,0,1;ROADTYPE \"ROADTYPE\" true true false 3 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,ROADTYPE,0,3;SUBTYPE \"SUBTYPE\" true true false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,SUBTYPE,0,2;SINKHOLE \"SINKHOLE\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,SINKHOLE,0,1;A \"A\" true true false 3 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,A,0,3;B \"B\" true true false 3 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,B,0,3;C \"C\" true true false 3 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,C,0,3;D \"D\" true true false 3 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,D,0,3;E \"E\" true true false 5 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,E,0,5;F \"F\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\freepapoly.shp,F,0,10", subtype="", expression="")[0]

    # Process: Truncate Table (4) (Truncate Table) (management)
    mcpagis_DBO_Futurepapoly_3_ = arcpy.management.TruncateTable(in_table=mcpagis_DBO_Futurepapoly_2_)[0]

    # Process: Append (4) (Append) (management)
    mcpagis_DBO_Futurepapoly_5_ = arcpy.management.Append(inputs=[Futurepapoly_shp_2_], target=mcpagis_DBO_Futurepapoly_2_, schema_type="NO_TEST", field_mapping="PARCEL \"PARCEL\" true true false 12 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,PARCEL,0,12;PREFIX \"PREFIX\" true true false 6 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,PREFIX,0,6;SUFFIX1 \"SUFFIX1\" true true false 5 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,SUFFIX1,0,5;SUFFIX2 \"SUFFIX2\" true true false 5 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,SUFFIX2,0,5;GIS_ACRES \"GIS_ACRES\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,GIS_ACRES,-1,-1;KIND \"KIND\" true true false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,KIND,0,2;ANGLE \"ANGLE\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,ANGLE,-1,-1;SIZE_ \"SIZE_\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,SIZE_,-1,-1;DATE_CREAT \"DATE_CREAT\" true true false 8 Date 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,DATE_CREAT,-1,-1;DATE_UPDAT \"DATE_UPDAT\" true true false 8 Date 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,DATE_UPDAT,-1,-1;FIC \"FIC\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,FIC,0,1;ALT_KEY \"ALT_KEY\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,ALT_KEY,0,10;PC \"PC\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,PC,0,10;HX \"HX\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,HX,0,10;AG \"AG\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,AG,0,10;NAME \"NAME\" true true false 100 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,NAME,0,100;ADD_1 \"ADD_1\" true true false 100 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,ADD_1,0,100;ADD_2 \"ADD_2\" true true false 100 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,ADD_2,0,100;ADD_3 \"ADD_3\" true true false 100 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,ADD_3,0,100;ADD_4 \"ADD_4\" true true false 100 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,ADD_4,0,100;ZIP \"ZIP\" true true false 20 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,ZIP,0,20;SITUS_1 \"SITUS_1\" true true false 100 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,SITUS_1,0,100;SITUS_2 \"SITUS_2\" true true false 100 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,SITUS_2,0,100;MILL_GRP \"MILL_GRP\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,MILL_GRP,-1,-1;NABRHD \"NABRHD\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,NABRHD,0,10;BK1 \"BK1\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,BK1,0,10;PG1 \"PG1\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,PG1,0,10;MO1 \"MO1\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,MO1,-1,-1;YR1 \"YR1\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,YR1,-1,-1;Q1 \"Q1\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,Q1,0,1;VI1 \"VI1\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,VI1,0,1;INST1 \"INST1\" true true false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,INST1,0,2;PR_1 \"PR_1\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,PR_1,-1,-1;MAP_NBR \"MAP_NBR\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,MAP_NBR,-1,-1;TWP \"TWP\" true true false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,TWP,0,2;RGE \"RGE\" true true false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,RGE,0,2;SEC \"SEC\" true true false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,SEC,0,2;ACRES \"ACRES\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,ACRES,-1,-1;LND1 \"LND1\" true true false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,LND1,0,4;LND2 \"LND2\" true true false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,LND2,0,4;LND3 \"LND3\" true true false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,LND3,0,4;ZONE1 \"ZONE1\" true true false 5 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,ZONE1,0,5;ZONE2 \"ZONE2\" true true false 5 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,ZONE2,0,5;ZONE3 \"ZONE3\" true true false 5 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,ZONE3,0,5;BLDS \"BLDS\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,BLDS,-1,-1;WALL \"WALL\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,WALL,-1,-1;AGE \"AGE\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,AGE,-1,-1;COND \"COND\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,COND,-1,-1;ARCH \"ARCH\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,ARCH,0,1;USE_SF \"USE_SF\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,USE_SF,-1,-1;YRBLT1 \"YRBLT1\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,YRBLT1,-1,-1;QUAL1 \"QUAL1\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,QUAL1,-1,-1;TYPE1 \"TYPE1\" true true false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,TYPE1,0,2;POOL \"POOL\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,POOL,0,1;STRY \"STRY\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,STRY,-1,-1;BLD1_SF \"BLD1_SF\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,BLD1_SF,-1,-1;WELL \"WELL\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,WELL,0,1;SEPTIC \"SEPTIC\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,SEPTIC,0,1;ASSD_VAL \"ASSD_VAL\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,ASSD_VAL,-1,-1;TOT_VAL \"TOT_VAL\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,TOT_VAL,-1,-1;TOT_LND_VA \"TOT_LND_VA\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,TOT_LND_VA,-1,-1;TOT_BLD_VA \"TOT_BLD_VA\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,TOT_BLD_VA,-1,-1;TOT_MISC_V \"TOT_MISC_V\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,TOT_MISC_V,-1,-1;TOT_TAX_VA \"TOT_TAX_VA\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,TOT_TAX_VA,-1,-1;TOT_TAXES \"TOT_TAXES\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,TOT_TAXES,-1,-1;APP_DATE \"APP_DATE\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,APP_DATE,-1,-1;APP_ID \"APP_ID\" true true false 3 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,APP_ID,0,3;SOS \"SOS\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,SOS,0,1;SU \"SU\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,SU,0,1;HX_YR \"HX_YR\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,HX_YR,-1,-1;STR \"STR\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,STR,-1,-1;GRP \"GRP\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,GRP,-1,-1;CITY \"CITY\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,CITY,-1,-1;VM \"VM\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,VM,-1,-1;CF \"CF\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,CF,0,1;CL_VAL \"CL_VAL\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,CL_VAL,-1,-1;N_CONS \"N_CONS\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,N_CONS,-1,-1;MKT_ADJ \"MKT_ADJ\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,MKT_ADJ,-1,-1;DATE_CRE_1 \"DATE_CRE_1\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,DATE_CRE_1,0,10;DATE_L_UPD \"DATE_L_UPD\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,DATE_L_UPD,0,10;B_UP \"B_UP\" true true false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,B_UP,0,4;PPAR \"PPAR\" true true false 12 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,PPAR,0,12;RESUSESF \"RESUSESF\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,RESUSESF,-1,-1;RESTOTSF \"RESTOTSF\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,RESTOTSF,-1,-1;COMUSESF \"COMUSESF\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,COMUSESF,-1,-1;COMTOTSF \"COMTOTSF\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,COMTOTSF,-1,-1;RESBLDS \"RESBLDS\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,RESBLDS,-1,-1;COMBLDS \"COMBLDS\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,COMBLDS,-1,-1;LAVALUE \"LAVALUE\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,LAVALUE,-1,-1;MRKT_AREA \"MRKT_AREA\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,MRKT_AREA,-1,-1;BEDS \"BEDS\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,BEDS,-1,-1;BATHS \"BATHS\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,BATHS,-1,-1;GARAGE \"GARAGE\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,GARAGE,0,1;FIRE \"FIRE\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,FIRE,0,1;LOCOBS \"LOCOBS\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,LOCOBS,-1,-1;FUNCOBS \"FUNCOBS\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,FUNCOBS,-1,-1;SEC_5 \"SEC_5\" true true false 3 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,SEC_5,0,3;LANDREV \"LANDREV\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,LANDREV,0,1;NBRUNITS \"NBRUNITS\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,NBRUNITS,-1,-1;MH \"MH\" true true false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,MH,0,4;RTE \"RTE\" true true false 25 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,RTE,0,25;HXUNDELIVE \"HXUNDELIVE\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,HXUNDELIVE,0,1;ROADTYPE \"ROADTYPE\" true true false 3 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,ROADTYPE,0,3;SUBTYPE \"SUBTYPE\" true true false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,SUBTYPE,0,2;SINKHOLE \"SINKHOLE\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,SINKHOLE,0,1;A \"A\" true true false 3 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,A,0,3;B \"B\" true true false 3 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,B,0,3;C \"C\" true true false 3 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,C,0,3;D \"D\" true true false 3 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,D,0,3;E \"E\" true true false 5 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,E,0,5;F \"F\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Futurepapoly.shp,F,0,10", subtype="", expression="")[0]

    # Process: Truncate Table (5) (Truncate Table) (management)
    mcpagis_DBO_FutureFreepapoly_4_ = arcpy.management.TruncateTable(in_table=mcpagis_DBO_FutureFreepapoly_2_)[0]

    # Process: Append (5) (Append) (management)
    mcpagis_DBO_FutureFreepapoly_5_ = arcpy.management.Append(inputs=[FutureFreepapoly_shp_2_], target=mcpagis_DBO_FutureFreepapoly_2_, schema_type="NO_TEST", field_mapping="PARCEL \"PARCEL\" true false false 12 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,PARCEL,0,12;PREFIX \"PREFIX\" true false false 6 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,PREFIX,0,6;SUFFIX1 \"SUFFIX1\" true false false 5 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,SUFFIX1,0,5;SUFFIX2 \"SUFFIX2\" true false false 5 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,SUFFIX2,0,5;GIS_ACRES \"GIS_ACRES\" true false false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,GIS_ACRES,-1,-1;KIND \"KIND\" true false false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,KIND,0,2;ANGLE \"ANGLE\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,ANGLE,-1,-1;SIZE_ \"SIZE_\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,SIZE_,-1,-1;DATE_CREAT \"DATE_CREAT\" true true false 8 Date 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,DATE_CREAT,-1,-1;DATE_UPDAT \"DATE_UPDAT\" true true false 8 Date 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,DATE_UPDAT,-1,-1;FIC \"FIC\" true false false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,FIC,0,1;ALT_KEY \"ALT_KEY\" true false false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,ALT_KEY,0,10;PC \"PC\" true false false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,PC,0,10;HX \"HX\" true false false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,HX,0,10;AG \"AG\" true false false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,AG,0,10;NAME \"NAME\" true false false 100 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,NAME,0,100;ADD_1 \"ADD_1\" true false false 100 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,ADD_1,0,100;ADD_2 \"ADD_2\" true false false 100 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,ADD_2,0,100;ADD_3 \"ADD_3\" true false false 100 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,ADD_3,0,100;ADD_4 \"ADD_4\" true false false 100 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,ADD_4,0,100;ZIP \"ZIP\" true false false 20 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,ZIP,0,20;SITUS_1 \"SITUS_1\" true false false 100 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,SITUS_1,0,100;SITUS_2 \"SITUS_2\" true false false 100 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,SITUS_2,0,100;MILL_GRP \"MILL_GRP\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,MILL_GRP,-1,-1;NABRHD \"NABRHD\" true false false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,NABRHD,0,10;BK1 \"BK1\" true false false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,BK1,0,10;PG1 \"PG1\" true false false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,PG1,0,10;MO1 \"MO1\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,MO1,-1,-1;YR1 \"YR1\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,YR1,-1,-1;Q1 \"Q1\" true false false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,Q1,0,1;VI1 \"VI1\" true false false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,VI1,0,1;INST1 \"INST1\" true false false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,INST1,0,2;PR_1 \"PR_1\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,PR_1,-1,-1;MAP_NBR \"MAP_NBR\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,MAP_NBR,-1,-1;TWP \"TWP\" true false false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,TWP,0,2;RGE \"RGE\" true false false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,RGE,0,2;SEC \"SEC\" true false false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,SEC,0,2;ACRES \"ACRES\" true false false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,ACRES,-1,-1;LND1 \"LND1\" true false false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,LND1,0,4;LND2 \"LND2\" true false false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,LND2,0,4;LND3 \"LND3\" true false false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,LND3,0,4;ZONE1 \"ZONE1\" true false false 5 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,ZONE1,0,5;ZONE2 \"ZONE2\" true false false 5 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,ZONE2,0,5;ZONE3 \"ZONE3\" true false false 5 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,ZONE3,0,5;BLDS \"BLDS\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,BLDS,-1,-1;WALL \"WALL\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,WALL,-1,-1;AGE \"AGE\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,AGE,-1,-1;COND \"COND\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,COND,-1,-1;ARCH \"ARCH\" true false false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,ARCH,0,1;USE_SF \"USE_SF\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,USE_SF,-1,-1;YRBLT1 \"YRBLT1\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,YRBLT1,-1,-1;QUAL1 \"QUAL1\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,QUAL1,-1,-1;TYPE1 \"TYPE1\" true false false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,TYPE1,0,2;POOL \"POOL\" true false false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,POOL,0,1;STRY \"STRY\" true false false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,STRY,-1,-1;BLD1_SF \"BLD1_SF\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,BLD1_SF,-1,-1;WELL \"WELL\" true false false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,WELL,0,1;SEPTIC \"SEPTIC\" true false false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,SEPTIC,0,1;ASSD_VAL \"ASSD_VAL\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,ASSD_VAL,-1,-1;TOT_VAL \"TOT_VAL\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,TOT_VAL,-1,-1;TOT_LND_VA \"TOT_LND_VA\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,TOT_LND_VA,-1,-1;TOT_BLD_VA \"TOT_BLD_VA\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,TOT_BLD_VA,-1,-1;TOT_MISC_V \"TOT_MISC_V\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,TOT_MISC_V,-1,-1;TOT_TAX_VA \"TOT_TAX_VA\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,TOT_TAX_VA,-1,-1;TOT_TAXES \"TOT_TAXES\" true false false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,TOT_TAXES,-1,-1;APP_DATE \"APP_DATE\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,APP_DATE,-1,-1;APP_ID \"APP_ID\" true false false 3 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,APP_ID,0,3;SOS \"SOS\" true false false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,SOS,0,1;SU \"SU\" true false false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,SU,0,1;HX_YR \"HX_YR\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,HX_YR,-1,-1;STR \"STR\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,STR,-1,-1;GRP \"GRP\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,GRP,-1,-1;CITY \"CITY\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,CITY,-1,-1;VM \"VM\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,VM,-1,-1;CF \"CF\" true false false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,CF,0,1;CL_VAL \"CL_VAL\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,CL_VAL,-1,-1;N_CONS \"N_CONS\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,N_CONS,-1,-1;MKT_ADJ \"MKT_ADJ\" true false false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,MKT_ADJ,-1,-1;DATE_CRE_1 \"DATE_CRE_1\" true false false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,DATE_CRE_1,0,10;DATE_L_UPD \"DATE_L_UPD\" true false false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,DATE_L_UPD,0,10;B_UP \"B_UP\" true false false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,B_UP,0,4;PPAR \"PPAR\" true false false 12 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,PPAR,0,12;RESUSESF \"RESUSESF\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,RESUSESF,-1,-1;RESTOTSF \"RESTOTSF\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,RESTOTSF,-1,-1;COMUSESF \"COMUSESF\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,COMUSESF,-1,-1;COMTOTSF \"COMTOTSF\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,COMTOTSF,-1,-1;RESBLDS \"RESBLDS\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,RESBLDS,-1,-1;COMBLDS \"COMBLDS\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,COMBLDS,-1,-1;LAVALUE \"LAVALUE\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,LAVALUE,-1,-1;MRKT_AREA \"MRKT_AREA\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,MRKT_AREA,-1,-1;BEDS \"BEDS\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,BEDS,-1,-1;BATHS \"BATHS\" true false false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,BATHS,-1,-1;GARAGE \"GARAGE\" true false false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,GARAGE,0,1;FIRE \"FIRE\" true false false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,FIRE,0,1;LOCOBS \"LOCOBS\" true false false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,LOCOBS,-1,-1;FUNCOBS \"FUNCOBS\" true false false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,FUNCOBS,-1,-1;SEC_5 \"SEC_5\" true false false 3 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,SEC_5,0,3;LANDREV \"LANDREV\" true false false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,LANDREV,0,1;NBRUNITS \"NBRUNITS\" true false false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,NBRUNITS,-1,-1;MH \"MH\" true false false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,MH,0,4;RTE \"RTE\" true false false 25 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,RTE,0,25;HXUNDELIVE \"HXUNDELIVE\" true false false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,HXUNDELIVE,0,1;ROADTYPE \"ROADTYPE\" true false false 3 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,ROADTYPE,0,3;SUBTYPE \"SUBTYPE\" true false false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,SUBTYPE,0,2;SINKHOLE \"SINKHOLE\" true false false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,SINKHOLE,0,1;A \"A\" true false false 3 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,A,0,3;B \"B\" true false false 3 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,B,0,3;C \"C\" true false false 3 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,C,0,3;D \"D\" true false false 3 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,D,0,3;E \"E\" true false false 5 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,E,0,5;F \"F\" true false false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\FutureFreepapoly.shp,F,0,10", subtype="", expression="")[0]

    # Process: Truncate Table (6) (Truncate Table) (management)
    mcpagis_DBO_Sales2020Imp_4_ = arcpy.management.TruncateTable(in_table=mcpagis_DBO_Sales2020Imp_2_)[0]

    # Process: Append (6) (Append) (management)
    mcpagis_DBO_Sales2020Imp_5_ = arcpy.management.Append(inputs=[qisales2020_shp], target=mcpagis_DBO_Sales2020Imp_2_, schema_type="NO_TEST", field_mapping="PNBR \"PNBR\" true true false 12 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\qisales2020.shp,PNBR,0,12;RNBR \"RNBR\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qisales2020.shp,RNBR,-1,-1;BOOK \"BOOK\" true true false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\qisales2020.shp,BOOK,0,4;PAGE \"PAGE\" true true false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\qisales2020.shp,PAGE,0,4;MTH \"MTH\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qisales2020.shp,MTH,-1,-1;YR \"YR\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qisales2020.shp,YR,-1,-1;IMP \"IMP\" true true false 5 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\qisales2020.shp,IMP,0,5;QUAL \"QUAL\" true true false 5 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\qisales2020.shp,QUAL,0,5;PRICE \"PRICE\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qisales2020.shp,PRICE,-1,-1;QUALCODE \"QUALCODE\" true true false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\qisales2020.shp,QUALCODE,0,2;RATIO_CALC \"RATIO_CALC\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\qisales2020.shp,RATIO_CALC,-1,-1;CF \"CF\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\qisales2020.shp,CF,0,1;PC \"PC\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\qisales2020.shp,PC,0,10;ACRES \"ACRES\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\qisales2020.shp,ACRES,-1,-1;TOT_VAL \"TOT_VAL\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qisales2020.shp,TOT_VAL,-1,-1;TOT_LND_VA \"TOT_LND_VA\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qisales2020.shp,TOT_LND_VA,-1,-1;STR \"STR\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qisales2020.shp,STR,-1,-1;GRP \"GRP\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qisales2020.shp,GRP,-1,-1;RESUSESF \"RESUSESF\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qisales2020.shp,RESUSESF,-1,-1;RESBLDS \"RESBLDS\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qisales2020.shp,RESBLDS,-1,-1;COMBLDS \"COMBLDS\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qisales2020.shp,COMBLDS,-1,-1", subtype="", expression="")[0]

    # Process: Truncate Table (7) (Truncate Table) (management)
    mcpagis_DBO_Sales2020Vac_4_ = arcpy.management.TruncateTable(in_table=mcpagis_DBO_Sales2020Vac_2_)[0]

    # Process: Append (7) (Append) (management)
    mcpagis_DBO_Sales2020Vac_5_ = arcpy.management.Append(inputs=[qvsales2020_shp], target=mcpagis_DBO_Sales2020Vac_2_, schema_type="NO_TEST", field_mapping="PNBR \"PNBR\" true true false 12 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\qvsales2020.shp,PNBR,0,12;RNBR \"RNBR\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qvsales2020.shp,RNBR,-1,-1;BOOK \"BOOK\" true true false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\qvsales2020.shp,BOOK,0,4;PAGE \"PAGE\" true true false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\qvsales2020.shp,PAGE,0,4;MTH \"MTH\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qvsales2020.shp,MTH,-1,-1;YR \"YR\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qvsales2020.shp,YR,-1,-1;IMP \"IMP\" true true false 5 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\qvsales2020.shp,IMP,0,5;QUAL \"QUAL\" true true false 5 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\qvsales2020.shp,QUAL,0,5;PRICE \"PRICE\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qvsales2020.shp,PRICE,-1,-1;QUALCODE \"QUALCODE\" true true false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\qvsales2020.shp,QUALCODE,0,2;RATIO_CALC \"RATIO_CALC\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\qvsales2020.shp,RATIO_CALC,-1,-1;CF \"CF\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\qvsales2020.shp,CF,0,1;PC \"PC\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\qvsales2020.shp,PC,0,10;ACRES \"ACRES\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\qvsales2020.shp,ACRES,-1,-1;TOT_VAL \"TOT_VAL\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qvsales2020.shp,TOT_VAL,-1,-1;TOT_LND_VA \"TOT_LND_VA\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qvsales2020.shp,TOT_LND_VA,-1,-1;STR \"STR\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qvsales2020.shp,STR,-1,-1;GRP \"GRP\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qvsales2020.shp,GRP,-1,-1;RESUSESF \"RESUSESF\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qvsales2020.shp,RESUSESF,-1,-1;RESBLDS \"RESBLDS\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qvsales2020.shp,RESBLDS,-1,-1;COMBLDS \"COMBLDS\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qvsales2020.shp,COMBLDS,-1,-1", subtype="", expression="")[0]

    # Process: Truncate Table (8) (Truncate Table) (management)
    mcpagis_DBO_Sales2021Imp_4_ = arcpy.management.TruncateTable(in_table=mcpagis_DBO_Sales2021Imp_2_)[0]

    # Process: Truncate Table (9) (Truncate Table) (management)
    mcpagis_DBO_Sales2021Vac_4_ = arcpy.management.TruncateTable(in_table=mcpagis_DBO_Sales2021Vac_2_)[0]

    # Process: Append (8) (Append) (management)
    mcpagis_DBO_Sales2021Imp = arcpy.management.Append(inputs=[qisales2021_shp], target=mcpagis_DBO_Sales2021Imp_2_, schema_type="NO_TEST", field_mapping="PNBR \"PNBR\" true true false 12 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\qisales2021.shp,PNBR,0,12;RNBR \"RNBR\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qisales2021.shp,RNBR,-1,-1;BOOK \"BOOK\" true true false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\qisales2021.shp,BOOK,0,4;PAGE \"PAGE\" true true false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\qisales2021.shp,PAGE,0,4;MTH \"MTH\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qisales2021.shp,MTH,-1,-1;YR \"YR\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qisales2021.shp,YR,-1,-1;IMP \"IMP\" true true false 5 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\qisales2021.shp,IMP,0,5;QUAL \"QUAL\" true true false 5 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\qisales2021.shp,QUAL,0,5;PRICE \"PRICE\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qisales2021.shp,PRICE,-1,-1;QUALCODE \"QUALCODE\" true true false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\qisales2021.shp,QUALCODE,0,2;RATIO_CALC \"RATIO_CALC\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\qisales2021.shp,RATIO_CALC,-1,-1;CF \"CF\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\qisales2021.shp,CF,0,1;PC \"PC\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\qisales2021.shp,PC,0,10;ACRES \"ACRES\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\qisales2021.shp,ACRES,-1,-1;TOT_VAL \"TOT_VAL\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qisales2021.shp,TOT_VAL,-1,-1;TOT_LND_VA \"TOT_LND_VA\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qisales2021.shp,TOT_LND_VA,-1,-1;STR \"STR\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qisales2021.shp,STR,-1,-1;GRP \"GRP\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qisales2021.shp,GRP,-1,-1;RESUSESF \"RESUSESF\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qisales2021.shp,RESUSESF,-1,-1;RESBLDS \"RESBLDS\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qisales2021.shp,RESBLDS,-1,-1;COMBLDS \"COMBLDS\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qisales2021.shp,COMBLDS,-1,-1", subtype="", expression="")[0]

    # Process: Append (9) (Append) (management)
    mcpagis_DBO_Sales2021Vac = arcpy.management.Append(inputs=[qvsales2021_shp], target=mcpagis_DBO_Sales2021Vac_2_, schema_type="NO_TEST", field_mapping="PNBR \"PNBR\" true true false 12 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\qvsales2021.shp,PNBR,0,12;RNBR \"RNBR\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qvsales2021.shp,RNBR,-1,-1;BOOK \"BOOK\" true true false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\qvsales2021.shp,BOOK,0,4;PAGE \"PAGE\" true true false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\qvsales2021.shp,PAGE,0,4;MTH \"MTH\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qvsales2021.shp,MTH,-1,-1;YR \"YR\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qvsales2021.shp,YR,-1,-1;IMP \"IMP\" true true false 5 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\qvsales2021.shp,IMP,0,5;QUAL \"QUAL\" true true false 5 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\qvsales2021.shp,QUAL,0,5;PRICE \"PRICE\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qvsales2021.shp,PRICE,-1,-1;QUALCODE \"QUALCODE\" true true false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\qvsales2021.shp,QUALCODE,0,2;RATIO_CALC \"RATIO_CALC\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\qvsales2021.shp,RATIO_CALC,-1,-1;CF \"CF\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\qvsales2021.shp,CF,0,1;PC \"PC\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\qvsales2021.shp,PC,0,10;ACRES \"ACRES\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\qvsales2021.shp,ACRES,-1,-1;TOT_VAL \"TOT_VAL\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qvsales2021.shp,TOT_VAL,-1,-1;TOT_LND_VA \"TOT_LND_VA\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qvsales2021.shp,TOT_LND_VA,-1,-1;STR \"STR\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qvsales2021.shp,STR,-1,-1;GRP \"GRP\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qvsales2021.shp,GRP,-1,-1;RESUSESF \"RESUSESF\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qvsales2021.shp,RESUSESF,-1,-1;RESBLDS \"RESBLDS\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qvsales2021.shp,RESBLDS,-1,-1;COMBLDS \"COMBLDS\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\qvsales2021.shp,COMBLDS,-1,-1", subtype="", expression="")[0]

    # Process: Truncate Table (10) (Truncate Table) (management)
    mcpagis_DBO_Commercial_Sales_4_ = arcpy.management.TruncateTable(in_table=mcpagis_DBO_Commercial_Sales_2_)[0]

    # Process: Append (10) (Append) (management)
    mcpagis_DBO_Commercial_Sales = arcpy.management.Append(inputs=[COMM_SALES_shp_2_], target=mcpagis_DBO_Commercial_Sales_2_, schema_type="NO_TEST", field_mapping="PARCEL \"PARCEL\" true true false 12 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\COMM_SALES.shp,PARCEL,0,12;RNBR \"RNBR\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\COMM_SALES.shp,RNBR,-1,-1;BOOK \"BOOK\" true true false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\COMM_SALES.shp,BOOK,0,4;PAGE \"PAGE\" true true false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\COMM_SALES.shp,PAGE,0,4;MTH \"MTH\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\COMM_SALES.shp,MTH,-1,-1;YR \"YR\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\COMM_SALES.shp,YR,-1,-1;IMP \"IMP\" true true false 5 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\COMM_SALES.shp,IMP,0,5;QUAL \"QUAL\" true true false 5 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\COMM_SALES.shp,QUAL,0,5;PRICE \"PRICE\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\COMM_SALES.shp,PRICE,-1,-1;QUALCODE \"QUALCODE\" true true false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\COMM_SALES.shp,QUALCODE,0,2;RATIO_CALC \"RATIO_CALC\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\COMM_SALES.shp,RATIO_CALC,-1,-1;CF \"CF\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\COMM_SALES.shp,CF,0,1;PC \"PC\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\COMM_SALES.shp,PC,0,10;ACRES \"ACRES\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\COMM_SALES.shp,ACRES,-1,-1;TOT_VAL \"TOT_VAL\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\COMM_SALES.shp,TOT_VAL,-1,-1;TOT_LND_VA \"TOT_LND_VA\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\COMM_SALES.shp,TOT_LND_VA,-1,-1;STR \"STR\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\COMM_SALES.shp,STR,-1,-1;GRP \"GRP\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\COMM_SALES.shp,GRP,-1,-1;COMUSESF \"COMUSESF\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\COMM_SALES.shp,COMUSESF,-1,-1;RESBLDS \"RESBLDS\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\COMM_SALES.shp,RESBLDS,-1,-1;COMBLDS \"COMBLDS\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\COMM_SALES.shp,COMBLDS,-1,-1", subtype="", expression="")[0]

    # Process: Truncate Table (11) (Truncate Table) (management)
    mcpagis_DBO_Exempt21_4_ = arcpy.management.TruncateTable(in_table=mcpagis_DBO_Exempt21_2_)[0]

    # Process: Append (11) (Append) (management)
    mcpagis_DBO_Exempt21 = arcpy.management.Append(inputs=[Exempt21_shp_2_], target=mcpagis_DBO_Exempt21_2_, schema_type="NO_TEST", field_mapping="PARCEL \"PARCEL\" true true false 12 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Exempt21.shp,PARCEL,0,12;ROLL \"ROLL\" true true false 3 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Exempt21.shp,ROLL,0,3;STATUS \"STATUS\" true true false 3 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Exempt21.shp,STATUS,0,3;SPECIALUSE \"SPECIALUSE\" true true false 3 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Exempt21.shp,SPECIALUSE,0,3;PRIMEKEY \"PRIMEKEY\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Exempt21.shp,PRIMEKEY,0,10;RECORD \"RECORD\" true true false 3 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Exempt21.shp,RECORD,0,3;CODE \"CODE\" true true false 3 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Exempt21.shp,CODE,0,3;VALUE \"VALUE\" true true false 12 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Exempt21.shp,VALUE,0,12;YEARAPP \"YEARAPP\" true true false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Exempt21.shp,YEARAPP,0,4;RENEWCODE \"RENEWCODE\" true true false 3 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\Exempt21.shp,RENEWCODE,0,3", subtype="", expression="")[0]

    # Process: Truncate Table (14) (Truncate Table) (management)
    mcpagis_DBO_LandRateAC_4_ = arcpy.management.TruncateTable(in_table=mcpagis_DBO_LandRateAC_2_)[0]

    # Process: Truncate Table (15) (Truncate Table) (management)
    mcpagis_DBO_LandRateNoAC_4_ = arcpy.management.TruncateTable(in_table=mcpagis_DBO_LandRateNoAC_2_)[0]

    # Process: Truncate Table (16) (Truncate Table) (management)
    mcpagis_DBO_No_lndRTEchg_19_to_21_All_4_ = arcpy.management.TruncateTable(in_table=mcpagis_DBO_No_lndRTEchg_19_to_21_All_2_)[0]

    # Process: Append (14) (Append) (management)
    mcpagis_DBO_LandRateAC = arcpy.management.Append(inputs=[lrateac_shp_2_], target=mcpagis_DBO_LandRateAC_2_, schema_type="NO_TEST", field_mapping="PARCEL \"PARCEL\" true true false 12 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\lrateac.shp,PARCEL,0,12;ROLL \"ROLL\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\lrateac.shp,ROLL,-1,-1;STATUS \"STATUS\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\lrateac.shp,STATUS,0,1;SU \"SU\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\lrateac.shp,SU,0,1;PKEY \"PKEY\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\lrateac.shp,PKEY,-1,-1;LNBR \"LNBR\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\lrateac.shp,LNBR,-1,-1;LNDUSE \"LNDUSE\" true true false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\lrateac.shp,LNDUSE,0,4;UNITTYPE \"UNITTYPE\" true true false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\lrateac.shp,UNITTYPE,0,2;UNITS \"UNITS\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\lrateac.shp,UNITS,-1,-1;FRONTAGE \"FRONTAGE\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\lrateac.shp,FRONTAGE,-1,-1;DEPTH \"DEPTH\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\lrateac.shp,DEPTH,-1,-1;NOTE \"NOTE\" true true false 254 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\lrateac.shp,NOTE,0,254;ZONING \"ZONING\" true true false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\lrateac.shp,ZONING,0,4;CURT \"CURT\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\lrateac.shp,CURT,-1,-1;SHPE \"SHPE\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\lrateac.shp,SHPE,-1,-1;LOCAT \"LOCAT\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\lrateac.shp,LOCAT,-1,-1;PHYS \"PHYS\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\lrateac.shp,PHYS,-1,-1;RATE \"RATE\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\lrateac.shp,RATE,-1,-1;TOTVALUE \"TOTVALUE\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\lrateac.shp,TOTVALUE,-1,-1;CLASVALUE \"CLASVALUE\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\lrateac.shp,CLASVALUE,-1,-1;ROLLYR \"ROLLYR\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\lrateac.shp,ROLLYR,-1,-1;VERIFY \"VERIFY\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\lrateac.shp,VERIFY,-1,-1;ADDPERCENT \"ADDPERCENT\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\lrateac.shp,ADDPERCENT,-1,-1;USEMODEL \"USEMODEL\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\lrateac.shp,USEMODEL,-1,-1;CURRENTUSE \"CURRENTUSE\" true true false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\lrateac.shp,CURRENTUSE,0,4;MODELYEAR \"MODELYEAR\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\lrateac.shp,MODELYEAR,-1,-1;EFFECTIVER \"EFFECTIVER\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\lrateac.shp,EFFECTIVER,-1,-1;MODELADJ \"MODELADJ\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\lrateac.shp,MODELADJ,-1,-1", subtype="", expression="")[0]

    # Process: Append (15) (Append) (management)
    mcpagis_DBO_LandRateNoAC = arcpy.management.Append(inputs=[lratenoac_shp_2_], target=mcpagis_DBO_LandRateNoAC_2_, schema_type="NO_TEST", field_mapping="PARCEL \"PARCEL\" true true false 12 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\lratenoac.shp,PARCEL,0,12;ROLL \"ROLL\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\lratenoac.shp,ROLL,-1,-1;STATUS \"STATUS\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\lratenoac.shp,STATUS,0,1;SU \"SU\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\lratenoac.shp,SU,0,1;PKEY \"PKEY\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\lratenoac.shp,PKEY,-1,-1;LNBR \"LNBR\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\lratenoac.shp,LNBR,-1,-1;LNDUSE \"LNDUSE\" true true false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\lratenoac.shp,LNDUSE,0,4;UNITTYPE \"UNITTYPE\" true true false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\lratenoac.shp,UNITTYPE,0,2;UNITS \"UNITS\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\lratenoac.shp,UNITS,-1,-1;FRONTAGE \"FRONTAGE\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\lratenoac.shp,FRONTAGE,-1,-1;DEPTH \"DEPTH\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\lratenoac.shp,DEPTH,-1,-1;NOTE \"NOTE\" true true false 254 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\lratenoac.shp,NOTE,0,254;ZONING \"ZONING\" true true false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\lratenoac.shp,ZONING,0,4;CURT \"CURT\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\lratenoac.shp,CURT,-1,-1;SHPE \"SHPE\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\lratenoac.shp,SHPE,-1,-1;LOCAT \"LOCAT\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\lratenoac.shp,LOCAT,-1,-1;PHYS \"PHYS\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\lratenoac.shp,PHYS,-1,-1;RATE \"RATE\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\lratenoac.shp,RATE,-1,-1;TOTVALUE \"TOTVALUE\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\lratenoac.shp,TOTVALUE,-1,-1;CLASVALUE \"CLASVALUE\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\lratenoac.shp,CLASVALUE,-1,-1;ROLLYR \"ROLLYR\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\lratenoac.shp,ROLLYR,-1,-1;VERIFY \"VERIFY\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\lratenoac.shp,VERIFY,-1,-1;ADDPERCENT \"ADDPERCENT\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\lratenoac.shp,ADDPERCENT,-1,-1;USEMODEL \"USEMODEL\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\lratenoac.shp,USEMODEL,-1,-1;CURRENTUSE \"CURRENTUSE\" true true false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\lratenoac.shp,CURRENTUSE,0,4;MODELYEAR \"MODELYEAR\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\lratenoac.shp,MODELYEAR,-1,-1;EFFECTIVER \"EFFECTIVER\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\lratenoac.shp,EFFECTIVER,-1,-1;MODELADJ \"MODELADJ\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\lratenoac.shp,MODELADJ,-1,-1", subtype="", expression="")[0]

    # Process: Append (16) (Append) (management)
    mcpagis_DBO_No_lndRTEchg_19_to_21_All = arcpy.management.Append(inputs=[No_lndRTEchg_19_to_21_All_shp_2_], target=mcpagis_DBO_No_lndRTEchg_19_to_21_All_2_, schema_type="NO_TEST", field_mapping="PARCEL \"PARCEL\" true true false 12 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\No_lndRTEchg_19_to_21_All.shp,PARCEL,0,12;UNITTYPE \"UNITTYPE\" true true false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\No_lndRTEchg_19_to_21_All.shp,UNITTYPE,0,2;RATE \"RATE\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\No_lndRTEchg_19_to_21_All.shp,RATE,-1,-1;RTE19 \"RTE19\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\No_lndRTEchg_19_to_21_All.shp,RTE19,-1,-1", subtype="", expression="")[0]

    # Process: Truncate Table (17) (Truncate Table) (management)
    mcpagis_DBO_Tangible_4_ = arcpy.management.TruncateTable(in_table=mcpagis_DBO_Tangible_2_)[0]

    # Process: Append (17) (Append) (management)
    mcpagis_DBO_Tangible = arcpy.management.Append(inputs=[tang_shp_2_], target=mcpagis_DBO_Tangible_2_, schema_type="NO_TEST", field_mapping="PARCEL \"PARCEL\" true true false 12 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,PARCEL,0,12;T_ALT_KEY \"T_ALT_KEY\" true true false 7 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,T_ALT_KEY,0,7;T_PC \"T_PC\" true true false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,T_PC,0,2;T_NAME \"T_NAME\" true true false 254 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,T_NAME,0,254;T_ADDRESS_ \"T_ADDRESS_\" true true false 254 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,T_ADDRESS_,0,254;T_ADDRESS2 \"T_ADDRESS2\" true true false 254 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,T_ADDRESS2,0,254;T_ADDRESS3 \"T_ADDRESS3\" true true false 254 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,T_ADDRESS3,0,254;T_ADDRESS4 \"T_ADDRESS4\" true true false 254 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,T_ADDRESS4,0,254;T_ZIP_CODE \"T_ZIP_CODE\" true true false 9 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,T_ZIP_CODE,0,9;T_SITUS_1 \"T_SITUS_1\" true true false 254 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,T_SITUS_1,0,254;T_SITUS_2 \"T_SITUS_2\" true true false 254 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,T_SITUS_2,0,254;T_MILL_GRP \"T_MILL_GRP\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,T_MILL_GRP,-1,-1;T_SIC_CD \"T_SIC_CD\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,T_SIC_CD,-1,-1;T_NAICS \"T_NAICS\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,T_NAICS,-1,-1;T_PARENT \"T_PARENT\" true true false 12 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,T_PARENT,0,12;T_VALUE \"T_VALUE\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,T_VALUE,-1,-1;T_TAXES \"T_TAXES\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,T_TAXES,-1,-1;T_SU \"T_SU\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,T_SU,0,1;T_CITY \"T_CITY\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,T_CITY,-1,-1;YR1 \"YR1\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,YR1,-1,-1;EX1 \"EX1\" true true false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,EX1,0,2;YR2 \"YR2\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,YR2,-1,-1;EX2 \"EX2\" true true false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,EX2,0,2;YR3 \"YR3\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,YR3,-1,-1;EX3 \"EX3\" true true false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,EX3,0,2;YR4 \"YR4\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,YR4,-1,-1;EX4 \"EX4\" true true false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,EX4,0,2;YR5 \"YR5\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,YR5,-1,-1;EX5 \"EX5\" true true false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,EX5,0,2;YR6 \"YR6\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,YR6,-1,-1;EX6 \"EX6\" true true false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,EX6,0,2;YR7 \"YR7\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,YR7,-1,-1;EX7 \"EX7\" true true false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,EX7,0,2;YR8 \"YR8\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,YR8,-1,-1;EX8 \"EX8\" true true false 2 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,EX8,0,2;T_FDATE \"T_FDATE\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,T_FDATE,0,10;T_STR \"T_STR\" true true false 6 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,T_STR,0,6;T_PEN \"T_PEN\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,T_PEN,-1,-1;T_CTL \"T_CTL\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,T_CTL,-1,-1;T_ASSD_VA \"T_ASSD_VA\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,T_ASSD_VA,-1,-1;T_FREE \"T_FREE\" true true false 8 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,T_FREE,0,8;T_PMAP \"T_PMAP\" true true false 6 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\tang.shp,T_PMAP,0,6", subtype="", expression="")[0]

    # Process: Truncate Table (13) (Truncate Table) (management)
    mcpagis_DBO_LandValueChange2022 = arcpy.management.TruncateTable(in_table=mcpagis_DBO_LandValueChange2022_2_)[0]

    # Process: Append (13) (Append) (management)
    mcpagis_DBO_LandValueChange2022_3_ = arcpy.management.Append(inputs=[Valchg22_shp], target=mcpagis_DBO_LandValueChange2022_2_, schema_type="NO_TEST", field_mapping="PARCEL \"PARCEL\" true true false 12 Text 0 0,First,#,K:\\GIS_UPDATE\\DATA\\SHP\\Valchg22.shp,PARCEL,0,12;TOT_LND_VA \"TOT_LND_VA\" true true false 4 Long 0 10,First,#,K:\\GIS_UPDATE\\DATA\\SHP\\Valchg22.shp,TOT_LND_VA,-1,-1;TOT_LND_VA_1 \"TOT_LND_VA\" true true false 4 Long 0 10,First,#,K:\\GIS_UPDATE\\DATA\\SHP\\Valchg22.shp,TOT_LND__1,-1,-1", subtype="", expression="")[0]

    # Process: Truncate Table (18) (Truncate Table) (management)
    mcpagis_DBO_LandRateChange2022 = arcpy.management.TruncateTable(in_table=mcpagis_DBO_LandRateChange2022_2_)[0]

    # Process: Append (18) (Append) (management)
    mcpagis_DBO_LandRateChange2022_3_ = arcpy.management.Append(inputs=[lndchg22_shp], target=mcpagis_DBO_LandRateChange2022_2_, schema_type="NO_TEST", field_mapping="PARCEL \"PARCEL\" true true false 12 Text 0 0,First,#,K:\\GIS_UPDATE\\DATA\\SHP\\lndchg22.shp,PARCEL,0,12;LNDUSE \"LNDUSE\" true true false 4 Text 0 0,First,#,K:\\GIS_UPDATE\\DATA\\SHP\\lndchg22.shp,LNDUSE,0,4;UNITTYPE \"UNITTYPE\" true true false 2 Text 0 0,First,#,K:\\GIS_UPDATE\\DATA\\SHP\\lndchg22.shp,UNITTYPE,0,2;RATE \"RATE\" true true false 8 Double 8 38,First,#,K:\\GIS_UPDATE\\DATA\\SHP\\lndchg22.shp,RATE,-1,-1;USE21 \"USE21\" true true false 4 Text 0 0,First,#,K:\\GIS_UPDATE\\DATA\\SHP\\lndchg22.shp,USE21,0,4;TYP21 \"TYP21\" true true false 2 Text 0 0,First,#,K:\\GIS_UPDATE\\DATA\\SHP\\lndchg22.shp,TYP21,0,2;RTE21 \"RTE21\" true true false 8 Double 8 38,First,#,K:\\GIS_UPDATE\\DATA\\SHP\\lndchg22.shp,RTE21,-1,-1", subtype="", expression="")[0]

    # Process: Truncate Table (12) (Truncate Table) (management)
    mcpagis_DBO_LandModel_2 = arcpy.management.TruncateTable(in_table=mcpagis_DBO_LandModel_2_2_)[0]

    # Process: Append (12) (Append) (management)
    mcpagis_DBO_LandModel_2_3_ = arcpy.management.Append(inputs=[LandModel_shp], target=mcpagis_DBO_LandModel_2_2_, schema_type="NO_TEST", field_mapping="PARCEL \"PARCEL\" true true false 12 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\LandModel.shp,PARCEL,0,12;ROLL \"ROLL\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\LandModel.shp,ROLL,-1,-1;STATUS \"STATUS\" true true false 4 Long 0 10,First,#,W:\\MiscLayerData\\Parcel\\LandModel.shp,STATUS,-1,-1;SU \"SU\" true true false 1 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\LandModel.shp,SU,0,1;PRIMEKEY \"PRIMEKEY\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\LandModel.shp,PRIMEKEY,0,10;USECODE \"USECODE\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\LandModel.shp,USECODE,0,10;UNITTYPE \"UNITTYPE\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\LandModel.shp,UNITTYPE,0,10;FRONTAGE \"FRONTAGE\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\LandModel.shp,FRONTAGE,0,10;DEPTH \"DEPTH\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\LandModel.shp,DEPTH,0,10;ZONING \"ZONING\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\LandModel.shp,ZONING,0,10;CURTILAGE \"CURTILAGE\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\LandModel.shp,CURTILAGE,0,10;SHAPE_LND \"SHAPE_LND\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\LandModel.shp,SHAPE_LND,0,10;LOCATION \"LOCATION\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\LandModel.shp,LOCATION,0,10;PHYSICAL \"PHYSICAL\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\LandModel.shp,PHYSICAL,0,10;RATE \"RATE\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\LandModel.shp,RATE,-1,-1;TOTALVALUE \"TOTALVALUE\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\LandModel.shp,TOTALVALUE,0,10;CLASSIFIED \"CLASSIFIED\" true true false 25 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\LandModel.shp,CLASSIFIED,0,25;USEMODEL \"USEMODEL\" true true false 10 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\LandModel.shp,USEMODEL,0,10;CURRENTUSE \"CURRENTUSE\" true true false 4 Text 0 0,First,#,W:\\MiscLayerData\\Parcel\\LandModel.shp,CURRENTUSE,0,4;EFFECTIVER \"EFFECTIVER\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\LandModel.shp,EFFECTIVER,-1,-1;MODEL_ADJ \"MODEL_ADJ\" true true false 8 Double 8 38,First,#,W:\\MiscLayerData\\Parcel\\LandModel.shp,MODEL_ADJ,-1,-1", subtype="", expression="")[0]

if __name__ == '__main__':
    # Global Environment settings
    with arcpy.EnvManager(scratchWorkspace=r"C:\Users\abishop\AppData\Local\Temp\ArcGISProTemp9744\2d0c2f85-f124-4094-8fe6-9bceac207b7e\Default.gdb", workspace=r"C:\Users\abishop\AppData\Local\Temp\ArcGISProTemp9744\2d0c2f85-f124-4094-8fe6-9bceac207b7e\Default.gdb"):
        MerlinGISUpdateDaily()

print("Merlin GIS Update Completed")

#end timer
endTime = time.perf_counter()
elapsedTime = round((endTime - startTime) / 60, 2)
print("Script finished in {0} minutes".format(elapsedTime))

 

Amanda Bishop, GISP
0 Kudos
TychoGranville
Occasional Contributor II

Yep, I have set overwriteOutput = True in some of my scripts. I was hoping that was a "feature" of ArcMap and had been fixed in Pro. This is such a simple model I'd like to just leave ModelBuilder open instead of exporting another python script every time I make a change to a value.

0 Kudos
DanPatterson
MVP Esteemed Contributor

You can verify the environment settings for models when you run them from the modelbuilder window or from a model contained in a toolbox.  I would verify your settings against the application level setting that you show in the image in your first post.  Do note, that models set overwriteOutputs to False if exported to a script so you will have to enable it again in your scripts.

 

What is a geoprocessing environment setting?—ArcGIS Pro | Documentation


... sort of retired...
0 Kudos
TychoGranville
Occasional Contributor II

Bah,  guess I'm blind... I checked...

toolbox (in the catalog pane)--> properties, no box for overwrite
model in the toolbox (in the catalog pane) --> properties, no box for overwrite
ModelBuilder tab --> Environments, no box for overwrite
ModelBuilder tab --> Properties, no box for overwrite
Main Pro page --> Options --> Geoprocessing, set to allow overwrite
In the model's window --> right-click, just model stuff

I don't know where else to look. 

0 Kudos
JohnGargiulo
New Contributor III

I am seeing same issue, I am in ArcGIS Pro 2.7.2. It does not happen every time, but very frustrating when it does. I have all settings set to overwrite is OK. Any feedback from ESRI on this issue? 

0 Kudos
TychoGranville
Occasional Contributor II

Based on the link Dan Patterson provided above and the image on one of the help pages you have to change the setting on the main (application) page as the model refers to that, not anything inside. So, per this image:

modelbuilder.JPG

 

I changed the toggle on Pro's main page:

Capture.JPG

and my model ran successfully.

Thanks,

Tycho

0 Kudos