https://community.esri.com/t5/arcgis-pro-questions/modelbuilder-will-not-overwrite-output/m-p/1110004#M47015 <P>You can verify the environment settings for models when you run them from the modelbuilder window or from a model contained in a toolbox.&nbsp; I would verify your settings against the application level setting that you show in the image in your first post.&nbsp; Do note, that models set overwriteOutputs to False if exported to a script so you will have to enable it again in your scripts.</P><P>&nbsp;</P><P><A href="https://pro.arcgis.com/en/pro-app/latest/tool-reference/environment-settings/what-is-a-geoprocessing-environment.htm" target="_blank">What is a geoprocessing environment setting?—ArcGIS Pro | Documentation</A></P> Thu, 21 Oct 2021 22:00:11 GMT DanPatterson 2021-10-21T22:00:11Z https://community.esri.com/t5/arcgis-pro-questions/modelbuilder-will-not-overwrite-output/m-p/1109955#M47008 <P>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<EM> file already exists</EM> (see below) instead of overwriting the file. The setting is correct in my options:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="setting.PNG" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/25804i8CDC27C584141EEF/image-size/medium?v=v2&amp;px=400" role="button" title="setting.PNG" alt="setting.PNG" /></span></P><P>and I get this error:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="tabletotable.PNG" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/25806iDA6D9A724E930356/image-size/medium?v=v2&amp;px=400" role="button" title="tabletotable.PNG" alt="tabletotable.PNG" /></span></P><P>If I remove the CSV file using the catalog pane&nbsp;(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.</P><P>Any ideas?</P><P>Thanks,</P><P>Tycho</P><P> </P><P> </P> Thu, 21 Oct 2021 20:40:38 GMT https://community.esri.com/t5/arcgis-pro-questions/modelbuilder-will-not-overwrite-output/m-p/1109955#M47008 TychoGranville 2021-10-21T20:40:38Z https://community.esri.com/t5/arcgis-pro-questions/modelbuilder-will-not-overwrite-output/m-p/1109967#M47010 <P>Can you export the model to a python script and then modify the arcpy.env.overwriteOutput to equal "True"?&nbsp; This is how I run my model scripts and it works each time.&nbsp; 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.</P><LI-CODE lang="python">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))</LI-CODE><P>&nbsp;</P> Thu, 21 Oct 2021 20:50:04 GMT https://community.esri.com/t5/arcgis-pro-questions/modelbuilder-will-not-overwrite-output/m-p/1109967#M47010 ABishop 2021-10-21T20:50:04Z https://community.esri.com/t5/arcgis-pro-questions/modelbuilder-will-not-overwrite-output/m-p/1109985#M47013 <P>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.</P> Thu, 21 Oct 2021 21:25:06 GMT https://community.esri.com/t5/arcgis-pro-questions/modelbuilder-will-not-overwrite-output/m-p/1109985#M47013 TychoGranville 2021-10-21T21:25:06Z https://community.esri.com/t5/arcgis-pro-questions/modelbuilder-will-not-overwrite-output/m-p/1110004#M47015 <P>You can verify the environment settings for models when you run them from the modelbuilder window or from a model contained in a toolbox.&nbsp; I would verify your settings against the application level setting that you show in the image in your first post.&nbsp; Do note, that models set overwriteOutputs to False if exported to a script so you will have to enable it again in your scripts.</P><P>&nbsp;</P><P><A href="https://pro.arcgis.com/en/pro-app/latest/tool-reference/environment-settings/what-is-a-geoprocessing-environment.htm" target="_blank">What is a geoprocessing environment setting?—ArcGIS Pro | Documentation</A></P> Thu, 21 Oct 2021 22:00:11 GMT https://community.esri.com/t5/arcgis-pro-questions/modelbuilder-will-not-overwrite-output/m-p/1110004#M47015 DanPatterson 2021-10-21T22:00:11Z https://community.esri.com/t5/arcgis-pro-questions/modelbuilder-will-not-overwrite-output/m-p/1110329#M47056 <P>Bah,&nbsp; guess I'm blind... I checked...</P><P>toolbox (in the catalog pane)--&gt; properties, no box for overwrite<BR />model in the toolbox (in the catalog pane) --&gt; properties, no box for overwrite<BR />ModelBuilder tab --&gt; Environments, no box for overwrite<BR />ModelBuilder tab --&gt; Properties, no box for overwrite<BR />Main Pro page --&gt; Options --&gt; Geoprocessing, set to allow overwrite<BR />In the model's window --&gt; right-click, just model stuff</P><P>I don't know where else to look.&nbsp;</P> Fri, 22 Oct 2021 16:13:45 GMT https://community.esri.com/t5/arcgis-pro-questions/modelbuilder-will-not-overwrite-output/m-p/1110329#M47056 TychoGranville 2021-10-22T16:13:45Z https://community.esri.com/t5/arcgis-pro-questions/modelbuilder-will-not-overwrite-output/m-p/1166080#M54236 <P>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?&nbsp;</P> Wed, 20 Apr 2022 13:28:53 GMT https://community.esri.com/t5/arcgis-pro-questions/modelbuilder-will-not-overwrite-output/m-p/1166080#M54236 JohnGargiulo 2022-04-20T13:28:53Z https://community.esri.com/t5/arcgis-pro-questions/modelbuilder-will-not-overwrite-output/m-p/1166272#M54255 <P>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:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="modelbuilder.JPG" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/39450i70909476013B0096/image-size/medium?v=v2&amp;px=400" role="button" title="modelbuilder.JPG" alt="modelbuilder.JPG" /></span></P><P>&nbsp;</P><P>I changed the toggle on Pro's main page:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.JPG" style="width: 720px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/39451i140BDBF4657424FE/image-size/large?v=v2&amp;px=999" role="button" title="Capture.JPG" alt="Capture.JPG" /></span></P><P>and my model ran successfully.</P><P>Thanks,</P><P>Tycho</P><P> </P> Wed, 20 Apr 2022 17:54:59 GMT https://community.esri.com/t5/arcgis-pro-questions/modelbuilder-will-not-overwrite-output/m-p/1166272#M54255 TychoGranville 2022-04-20T17:54:59Z https://community.esri.com/t5/arcgis-pro-questions/modelbuilder-will-not-overwrite-output/m-p/1353793#M75593 <P>Thanks Dan for the quotation <EM>"models set overwriteOutputs to False"</EM>!</P><P>It helped me to understand why a model could not overwrite outputs, despite having correct Geoprocessing settings for the ArcGIS Pro application...</P><P>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!</P> Mon, 27 Nov 2023 21:10:43 GMT https://community.esri.com/t5/arcgis-pro-questions/modelbuilder-will-not-overwrite-output/m-p/1353793#M75593 VincentLaunstorfer 2023-11-27T21:10:43Z