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