nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }
ModelBuilder will not overwrite output

TychoGranville
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:
and I get this error:
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
タグ付けされた投稿をもっと見る

Analysis
Content Management
Accepted answers

All comments

VincentLaunstorfer
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!
TychoGranville
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:
I changed the toggle on Pro's main page:
and my model ran successfully.
Thanks,
Tycho
Capture.JPG
JohnGargiulo
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?
TychoGranville
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.
danretired
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
TychoGranville
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.
ABishop
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))
会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。
クイックリンク

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.