Community

ModelBuilder will not overwrite output

1493
7
10-21-2021 01:40 PM
TychoGranville
by
Occasional Contributor II
‎10-21-2021 01:40 PM

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
7 Replies
ABishop
by MVP Regular Contributor
MVP Regular Contributor
‎10-21-2021 01:50 PM

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
by
Occasional Contributor II
‎10-21-2021 02:25 PM

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
by MVP Esteemed Contributor
MVP Esteemed Contributor
‎10-21-2021 03:00 PM

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...
TychoGranville
by
Occasional Contributor II
‎10-22-2021 09:13 AM

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
VincentLaunstorfer
by
Occasional Contributor III
‎11-27-2023 01:10 PM

Thanks Dan for the quotation "models set overwriteOutputs to False"!

It helped me to understand why a model could not overwrite outputs, despite having correct Geoprocessing settings for the ArcGIS Pro application...

For info, if a model embeds some custom Python tools and without explicitly setting overwriteOutputs = True, as models set overwriteOutputs to False by default, it also defaults the entire model to False (not only the python script). Good to know!

0 Kudos
JohnGargiulo
by
New Contributor III
‎04-20-2022 06:28 AM

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
by
Occasional Contributor II
‎04-20-2022 10:54 AM

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

 

Preview file
57 KB
0 Kudos