<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Python Runtime Error in Python Questions</title>
    <link>https://community.esri.com/t5/python-questions/python-runtime-error/m-p/602896#M47117</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Full disclosure, I don't know too much about the exact commands or the nature of field mapping syntax you're using but - just off the cuff - the following looks like it could use some quotes and commas around various parameters... e.g. "true true true" looks weird&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;PRE class="lia-code-sample line-numbers language-none"&gt;&lt;SPAN style="color: #3d3d3d; background-color: #ffffff;"&gt;field_mapping="BUSINESS_NO \"BUSINESS_NO\" true true false 4 Long 0 0,First,#,
P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,BUSINESS_NO,-1,-1;SITE_APN \"SITE_APN\" true true false 8000 Text 0 0,First,#,
P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,SITE_APN,0,8000;COMPANY \"COMPANY\" true true false 8000 Text 0 0,First,#,
P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,COMPANY,0,8000;LOC_ADDRESS1 \"LOC_ADDRESS1\" true true false 8000 Text 0 0,First,#,
P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,LOC_ADDRESS1,0,8000;INSPECTIONTYPE \"INSPECTIONTYPE\" true true false 8000 Text 0 0,First,#,
P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,INSPECTIONTYPE,0,8000;INSPECTOR \"INSPECTOR\" true true false 8000 Text 0 0,First,#,
P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,INSPECTOR,0,8000;BUS_LIC_NO \"BUS_LIC_NO\" true true false 8000 Text 0 0,First,#,
P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,BUS_LIC_NO,0,8000;STATUS \"STATUS\" true true false 8000 Text 0 0,First,#,
P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,STATUS,0,8000;LATEST_REVIEW_DATE \"LATEST_REVIEW_DATE\" true true false 8 Date 0 0,First,#,
P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,LATEST_REVIEW_DATE,-1,-1;LATEST_SCORE \"LATEST_SCORE\" true true false 8000 Text 0 0,First,#,
P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,LATEST_SCORE,0,8000;RECORDID \"RECORDID\" true true false 8000 Text 0 0,First,#,
P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,RECORDID,0,8000;PREVIOUS_REVIEW_DATE \"PREVIOUS_REVIEW_DATE\" true true false 8000 Text 0 0,First,#,
P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,PREVIOUS_REVIEW_DATE,0,8000;PREVIOUS_SCORE \"PREVIOUS_SCORE\" true true false 8000 Text 0 0,First,#,
P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,PREVIOUS_SCORE,0,8000"&lt;/SPAN&gt;&lt;/PRE&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Sun, 12 Dec 2021 01:51:16 GMT</pubDate>
    <dc:creator>Arne_Gelfert</dc:creator>
    <dc:date>2021-12-12T01:51:16Z</dc:date>
    <item>
      <title>Python Runtime Error</title>
      <link>https://community.esri.com/t5/python-questions/python-runtime-error/m-p/602893#M47114</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Greetings,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I'm trying to run my python script (from which I've just exported a ModelBuilder model) and I keep getting this Runtime error.&amp;nbsp; Here is the script:&lt;/P&gt;&lt;P&gt;import arcpy&lt;/P&gt;&lt;P&gt;def Model(): # Model&lt;/P&gt;&lt;P&gt;# To allow overwriting outputs change overwriteOutput option to True.&lt;BR /&gt; arcpy.env.overwriteOutput = True&lt;/P&gt;&lt;P&gt;restaurant_scores_csv = "P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv"&lt;BR /&gt; ReastaurantInspections_gdb = "C:\\arcgisserver\\arcgisresources\\Code\\ReastaurantInspections.gdb"&lt;BR /&gt; CompositeSubStreet_loc = "S:\\Police\\GIS\\AddressLocators\\CompositeSubStreet.loc"&lt;/P&gt;&lt;P&gt;# Process: Table To Table (Table To Table) &lt;BR /&gt; Scores = arcpy.TableToTable_conversion(in_rows=restaurant_scores_csv, out_path=ReastaurantInspections_gdb, out_name="Scores", where_clause="", field_mapping="BUSINESS_NO \"BUSINESS_NO\" true true false 4 Long 0 0,First,#,P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,BUSINESS_NO,-1,-1;SITE_APN \"SITE_APN\" true true false 8000 Text 0 0,First,#,P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,SITE_APN,0,8000;COMPANY \"COMPANY\" true true false 8000 Text 0 0,First,#,P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,COMPANY,0,8000;LOC_ADDRESS1 \"LOC_ADDRESS1\" true true false 8000 Text 0 0,First,#,P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,LOC_ADDRESS1,0,8000;INSPECTIONTYPE \"INSPECTIONTYPE\" true true false 8000 Text 0 0,First,#,P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,INSPECTIONTYPE,0,8000;INSPECTOR \"INSPECTOR\" true true false 8000 Text 0 0,First,#,P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,INSPECTOR,0,8000;BUS_LIC_NO \"BUS_LIC_NO\" true true false 8000 Text 0 0,First,#,P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,BUS_LIC_NO,0,8000;STATUS \"STATUS\" true true false 8000 Text 0 0,First,#,P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,STATUS,0,8000;LATEST_REVIEW_DATE \"LATEST_REVIEW_DATE\" true true false 8 Date 0 0,First,#,P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,LATEST_REVIEW_DATE,-1,-1;LATEST_SCORE \"LATEST_SCORE\" true true false 8000 Text 0 0,First,#,P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,LATEST_SCORE,0,8000;RECORDID \"RECORDID\" true true false 8000 Text 0 0,First,#,P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,RECORDID,0,8000;PREVIOUS_REVIEW_DATE \"PREVIOUS_REVIEW_DATE\" true true false 8000 Text 0 0,First,#,P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,PREVIOUS_REVIEW_DATE,0,8000;PREVIOUS_SCORE \"PREVIOUS_SCORE\" true true false 8000 Text 0 0,First,#,P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,PREVIOUS_SCORE,0,8000", config_keyword="")[0]&lt;/P&gt;&lt;P&gt;# Process: Geocode Addresses (Geocode Addresses) &lt;BR /&gt; Scores_Geocoded = "C:\\arcgisserver\\arcgisresources\\Code\\ReastaurantInspections.gdb\\Scores_Geocoded"&lt;BR /&gt; arcpy.GeocodeAddresses_geocoding(in_table=Scores, address_locator=CompositeSubStreet_loc, in_address_fields="'Single Line Input' LOC_ADDRESS1 VISIBLE NONE", out_feature_class=Scores_Geocoded, out_relationship_type="STATIC", country=[], location_type="", category=[])&lt;/P&gt;&lt;P&gt;# Process: Add Field (Add Field) &lt;BR /&gt; Scores_Geocoded_2_ = arcpy.AddField_management(in_table=Scores_Geocoded, field_name="establishmentname", field_type="TEXT", field_precision=None, field_scale=None, field_length=200, field_alias="Establishment Name", field_is_nullable="NULLABLE", field_is_required="NON_REQUIRED", field_domain="")[0]&lt;/P&gt;&lt;P&gt;# Process: Add Field (2) (Add Field) &lt;BR /&gt; Scores_Geocoded_3_ = arcpy.AddField_management(in_table=Scores_Geocoded_2_, field_name="address", field_type="TEXT", field_precision=None, field_scale=None, field_length=200, field_alias="Full Address", field_is_nullable="NULLABLE", field_is_required="NON_REQUIRED", field_domain="")[0]&lt;/P&gt;&lt;P&gt;# Process: Add Field (3) (Add Field) &lt;BR /&gt; Scores_Geocoded_4_ = arcpy.AddField_management(in_table=Scores_Geocoded_3_, field_name="identifier", field_type="TEXT", field_precision=None, field_scale=None, field_length=50, field_alias="Identifier", field_is_nullable="NULLABLE", field_is_required="NON_REQUIRED", field_domain="")[0]&lt;/P&gt;&lt;P&gt;# Process: Add Field (4) (Add Field) &lt;BR /&gt; Scores_Geocoded_5_ = arcpy.AddField_management(in_table=Scores_Geocoded_4_, field_name="permnum", field_type="TEXT", field_precision=None, field_scale=None, field_length=50, field_alias="Permit Number", field_is_nullable="NULLABLE", field_is_required="NON_REQUIRED", field_domain="")[0]&lt;/P&gt;&lt;P&gt;# Process: Add Field (5) (Add Field) &lt;BR /&gt; Scores_Geocoded_6_ = arcpy.AddField_management(in_table=Scores_Geocoded_5_, field_name="inspdate", field_type="DATE", field_precision=None, field_scale=None, field_length=50, field_alias="Inspection Date", field_is_nullable="NULLABLE", field_is_required="NON_REQUIRED", field_domain="")[0]&lt;/P&gt;&lt;P&gt;# Process: Add Field (6) (Add Field) &lt;BR /&gt; Scores_Geocoded_11_ = arcpy.AddField_management(in_table=Scores_Geocoded_6_, field_name="latestscore", field_type="TEXT", field_precision=None, field_scale=None, field_length=100, field_alias="Latest Score", field_is_nullable="NULLABLE", field_is_required="NON_REQUIRED", field_domain="")[0]&lt;/P&gt;&lt;P&gt;# Process: Add Field (7) (Add Field) &lt;BR /&gt; Scores_Geocoded_8_ = arcpy.AddField_management(in_table=Scores_Geocoded_11_, field_name="PreviousTempDate", field_type="TEXT", field_precision=None, field_scale=None, field_length=50, field_alias="Previous Inspection Date", field_is_nullable="NULLABLE", field_is_required="NON_REQUIRED", field_domain="")[0]&lt;/P&gt;&lt;P&gt;# Process: Add Field (8) (Add Field) &lt;BR /&gt; Scores_Geocoded_7_ = arcpy.AddField_management(in_table=Scores_Geocoded_8_, field_name="previnspscore", field_type="TEXT", field_precision=None, field_scale=None, field_length=50, field_alias="Previous Inspection Score", field_is_nullable="NULLABLE", field_is_required="NON_REQUIRED", field_domain="")[0]&lt;/P&gt;&lt;P&gt;# Process: Calculate Field (Calculate Field) &lt;BR /&gt; Scores_Geocoded_9_ = arcpy.CalculateField_management(in_table=Scores_Geocoded_7_, field="establishmentname", expression="!USER_COMPANY!", expression_type="PYTHON3", code_block="", field_type="TEXT")[0]&lt;/P&gt;&lt;P&gt;# Process: Calculate Field (2) (Calculate Field) &lt;BR /&gt; Scores_Geocoded_18_ = arcpy.CalculateField_management(in_table=Scores_Geocoded_9_, field="address", expression="!USER_LOC_ADDRESS1!", expression_type="PYTHON3", code_block="", field_type="TEXT")[0]&lt;/P&gt;&lt;P&gt;# Process: Calculate Field (3) (Calculate Field) &lt;BR /&gt; Scores_Geocoded_12_ = arcpy.CalculateField_management(in_table=Scores_Geocoded_18_, field="identifier", expression="!USER_INSPECTOR!", expression_type="PYTHON3", code_block="", field_type="TEXT")[0]&lt;/P&gt;&lt;P&gt;# Process: Calculate Field (4) (Calculate Field) &lt;BR /&gt; Scores_Geocoded_10_ = arcpy.CalculateField_management(in_table=Scores_Geocoded_12_, field="inspdate", expression="!USER_LATEST_REVIEW_DATE!", expression_type="PYTHON3", code_block="", field_type="TEXT")[0]&lt;/P&gt;&lt;P&gt;# Process: Calculate Field (5) (Calculate Field) &lt;BR /&gt; Scores_Geocoded_13_ = arcpy.CalculateField_management(in_table=Scores_Geocoded_10_, field="latestscore", expression="!USER_LATEST_SCORE!", expression_type="PYTHON3", code_block="", field_type="TEXT")[0]&lt;/P&gt;&lt;P&gt;# Process: Calculate Field (6) (Calculate Field) &lt;BR /&gt; Scores_Geocoded_14_ = arcpy.CalculateField_management(in_table=Scores_Geocoded_13_, field="PreviousTempDate", expression="!USER_PREVIOUS_REVIEW_DATE!", expression_type="PYTHON3", code_block="", field_type="TEXT")[0]&lt;/P&gt;&lt;P&gt;# Process: Calculate Field (7) (Calculate Field) &lt;BR /&gt; Scores_Geocoded_15_ = arcpy.CalculateField_management(in_table=Scores_Geocoded_14_, field="permnum", expression="!USER_BUS_LIC_NO!", expression_type="PYTHON3", code_block="", field_type="TEXT")[0]&lt;/P&gt;&lt;P&gt;# Process: Calculate Field (8) (Calculate Field) &lt;BR /&gt; Scores_Geocoded_16_ = arcpy.CalculateField_management(in_table=Scores_Geocoded_15_, field="previnspscore", expression="!USER_PREVIOUS_SCORE!", expression_type="PYTHON3", code_block="", field_type="TEXT")[0]&lt;/P&gt;&lt;P&gt;# Process: Delete Field (Delete Field) &lt;BR /&gt; Scores_Geocoded_17_ = arcpy.DeleteField_management(in_table=Scores_Geocoded_16_, drop_field=["Loc_name", "Status", "Score", "Match_type", "Match_addr", "User_fld", "Addr_type", "Side", "IN_SingleLine", "USER_BUSINESS_NO", "USER_SITE_APN", "USER_COMPANY", "USER_LOC_ADDRESS1", "USER_INSPECTIONTYPE", "USER_INSPECTOR", "USER_BUS_LIC_NO", "USER_STATUS", "USER_LATEST_SCORE", "USER_LATEST_REVIEW_DATE", "USER_RECORDID", "USER_PREVIOUS_REVIEW_DATE", "USER_PREVIOUS_SCORE"])[0]&lt;/P&gt;&lt;P&gt;if __name__ == '__main__':&lt;BR /&gt; # Global Environment settings&lt;BR /&gt; with arcpy.EnvManager(scratchWorkspace=r"C:\Users\pforrest\Documents\ArcGIS\Projects\Restaurant Inspections\Restaurant Inspections.gdb", workspace=r"C:\Users\pforrest\Documents\ArcGIS\Projects\Restaurant Inspections\Restaurant Inspections.gdb"):&lt;BR /&gt; Model()&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;The error I get is:&lt;/P&gt;&lt;P&gt;RuntimeError: Object: Error in executing tool&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;No other messages that I can work off of.&amp;nbsp; Any help would be much appreciated!&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 24 Jul 2020 17:24:09 GMT</pubDate>
      <guid>https://community.esri.com/t5/python-questions/python-runtime-error/m-p/602893#M47114</guid>
      <dc:creator>PatrickForrest1</dc:creator>
      <dc:date>2020-07-24T17:24:09Z</dc:date>
    </item>
    <item>
      <title>Re: Python Runtime Error</title>
      <link>https://community.esri.com/t5/python-questions/python-runtime-error/m-p/602894#M47115</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;PRE class="lia-code-sample line-numbers language-none"&gt;&lt;CODE&gt;&lt;SPAN class="keyword token"&gt;import&lt;/SPAN&gt; arcpy

&lt;SPAN class="keyword token"&gt;def&lt;/SPAN&gt; &lt;SPAN class="token function"&gt;Model&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;(&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;)&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;:&lt;/SPAN&gt; &lt;SPAN class="comment token"&gt;# Model&lt;/SPAN&gt;

&lt;SPAN class="comment token"&gt;# To allow overwriting outputs change overwriteOutput option to True.&lt;/SPAN&gt;
arcpy&lt;SPAN class="punctuation token"&gt;.&lt;/SPAN&gt;env&lt;SPAN class="punctuation token"&gt;.&lt;/SPAN&gt;overwriteOutput &lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt; &lt;SPAN class="token boolean"&gt;True&lt;/SPAN&gt;

restaurant_scores_csv &lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt; &lt;SPAN class="string token"&gt;"P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv"&lt;/SPAN&gt;
ReastaurantInspections_gdb &lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt; &lt;SPAN class="string token"&gt;"C:\\arcgisserver\\arcgisresources\\Code\\ReastaurantInspections.gdb"&lt;/SPAN&gt;
CompositeSubStreet_loc &lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt; &lt;SPAN class="string token"&gt;"S:\\Police\\GIS\\AddressLocators\\CompositeSubStreet.loc"&lt;/SPAN&gt;

&lt;SPAN class="comment token"&gt;# Process: Table To Table (Table To Table)&lt;/SPAN&gt;
Scores &lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt; arcpy&lt;SPAN class="punctuation token"&gt;.&lt;/SPAN&gt;TableToTable_conversion&lt;SPAN class="punctuation token"&gt;(&lt;/SPAN&gt;in_rows&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;restaurant_scores_csv&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; out_path&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;ReastaurantInspections_gdb&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; out_name&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"Scores"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; where_clause&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;""&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_mapping&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"BUSINESS_NO \"BUSINESS_NO\"&lt;/SPAN&gt; true true false &lt;SPAN class="number token"&gt;4&lt;/SPAN&gt; Long &lt;SPAN class="number token"&gt;0&lt;/SPAN&gt; &lt;SPAN class="number token"&gt;0&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt;First&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt;&lt;SPAN class="comment token"&gt;#,P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,BUSINESS_NO,-1,-1;SITE_APN \"SITE_APN\" true true false 8000 Text 0 0,First,#,P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,SITE_APN,0,8000;COMPANY \"COMPANY\" true true false 8000 Text 0 0,First,#,P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,COMPANY,0,8000;LOC_ADDRESS1 \"LOC_ADDRESS1\" true true false 8000 Text 0 0,First,#,P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,LOC_ADDRESS1,0,8000;INSPECTIONTYPE \"INSPECTIONTYPE\" true true false 8000 Text 0 0,First,#,P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,INSPECTIONTYPE,0,8000;INSPECTOR \"INSPECTOR\" true true false 8000 Text 0 0,First,#,P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,INSPECTOR,0,8000;BUS_LIC_NO \"BUS_LIC_NO\" true true false 8000 Text 0 0,First,#,P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,BUS_LIC_NO,0,8000;STATUS \"STATUS\" true true false 8000 Text 0 0,First,#,P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,STATUS,0,8000;LATEST_REVIEW_DATE \"LATEST_REVIEW_DATE\" true true false 8 Date 0 0,First,#,P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,LATEST_REVIEW_DATE,-1,-1;LATEST_SCORE \"LATEST_SCORE\" true true false 8000 Text 0 0,First,#,P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,LATEST_SCORE,0,8000;RECORDID \"RECORDID\" true true false 8000 Text 0 0,First,#,P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,RECORDID,0,8000;PREVIOUS_REVIEW_DATE \"PREVIOUS_REVIEW_DATE\" true true false 8000 Text 0 0,First,#,P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,PREVIOUS_REVIEW_DATE,0,8000;PREVIOUS_SCORE \"PREVIOUS_SCORE\" true true false 8000 Text 0 0,First,#,P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,PREVIOUS_SCORE,0,8000", config_keyword="")[0]&lt;/SPAN&gt;

&lt;SPAN class="comment token"&gt;# Process: Geocode Addresses (Geocode Addresses)&lt;/SPAN&gt;
Scores_Geocoded &lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt; &lt;SPAN class="string token"&gt;"C:\\arcgisserver\\arcgisresources\\Code\\ReastaurantInspections.gdb\\Scores_Geocoded"&lt;/SPAN&gt;
arcpy&lt;SPAN class="punctuation token"&gt;.&lt;/SPAN&gt;GeocodeAddresses_geocoding&lt;SPAN class="punctuation token"&gt;(&lt;/SPAN&gt;in_table&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;Scores&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; address_locator&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;CompositeSubStreet_loc&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; in_address_fields&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"'Single Line Input' LOC_ADDRESS1 VISIBLE NONE"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; out_feature_class&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;Scores_Geocoded&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; out_relationship_type&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"STATIC"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; country&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;[&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;]&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; location_type&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;""&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; category&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;[&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;]&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;)&lt;/SPAN&gt;

&lt;SPAN class="comment token"&gt;# Process: Add Field (Add Field)&lt;/SPAN&gt;
Scores_Geocoded_2_ &lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt; arcpy&lt;SPAN class="punctuation token"&gt;.&lt;/SPAN&gt;AddField_management&lt;SPAN class="punctuation token"&gt;(&lt;/SPAN&gt;in_table&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;Scores_Geocoded&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_name&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"establishmentname"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_type&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"TEXT"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_precision&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;None&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_scale&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;None&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_length&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="number token"&gt;200&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_alias&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"Establishment Name"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_is_nullable&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"NULLABLE"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_is_required&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"NON_REQUIRED"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_domain&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;""&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;)&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;[&lt;/SPAN&gt;&lt;SPAN class="number token"&gt;0&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;]&lt;/SPAN&gt;

&lt;SPAN class="comment token"&gt;# Process: Add Field (2) (Add Field)&lt;/SPAN&gt;
Scores_Geocoded_3_ &lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt; arcpy&lt;SPAN class="punctuation token"&gt;.&lt;/SPAN&gt;AddField_management&lt;SPAN class="punctuation token"&gt;(&lt;/SPAN&gt;in_table&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;Scores_Geocoded_2_&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_name&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"address"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_type&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"TEXT"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_precision&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;None&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_scale&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;None&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_length&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="number token"&gt;200&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_alias&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"Full Address"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_is_nullable&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"NULLABLE"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_is_required&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"NON_REQUIRED"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_domain&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;""&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;)&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;[&lt;/SPAN&gt;&lt;SPAN class="number token"&gt;0&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;]&lt;/SPAN&gt;

&lt;SPAN class="comment token"&gt;# Process: Add Field (3) (Add Field)&lt;/SPAN&gt;
Scores_Geocoded_4_ &lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt; arcpy&lt;SPAN class="punctuation token"&gt;.&lt;/SPAN&gt;AddField_management&lt;SPAN class="punctuation token"&gt;(&lt;/SPAN&gt;in_table&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;Scores_Geocoded_3_&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_name&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"identifier"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_type&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"TEXT"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_precision&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;None&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_scale&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;None&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_length&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="number token"&gt;50&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_alias&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"Identifier"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_is_nullable&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"NULLABLE"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_is_required&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"NON_REQUIRED"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_domain&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;""&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;)&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;[&lt;/SPAN&gt;&lt;SPAN class="number token"&gt;0&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;]&lt;/SPAN&gt;

&lt;SPAN class="comment token"&gt;# Process: Add Field (4) (Add Field)&lt;/SPAN&gt;
Scores_Geocoded_5_ &lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt; arcpy&lt;SPAN class="punctuation token"&gt;.&lt;/SPAN&gt;AddField_management&lt;SPAN class="punctuation token"&gt;(&lt;/SPAN&gt;in_table&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;Scores_Geocoded_4_&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_name&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"permnum"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_type&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"TEXT"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_precision&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;None&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_scale&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;None&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_length&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="number token"&gt;50&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_alias&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"Permit Number"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_is_nullable&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"NULLABLE"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_is_required&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"NON_REQUIRED"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_domain&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;""&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;)&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;[&lt;/SPAN&gt;&lt;SPAN class="number token"&gt;0&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;]&lt;/SPAN&gt;

&lt;SPAN class="comment token"&gt;# Process: Add Field (5) (Add Field)&lt;/SPAN&gt;
Scores_Geocoded_6_ &lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt; arcpy&lt;SPAN class="punctuation token"&gt;.&lt;/SPAN&gt;AddField_management&lt;SPAN class="punctuation token"&gt;(&lt;/SPAN&gt;in_table&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;Scores_Geocoded_5_&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_name&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"inspdate"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_type&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"DATE"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_precision&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;None&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_scale&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;None&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_length&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="number token"&gt;50&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_alias&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"Inspection Date"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_is_nullable&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"NULLABLE"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_is_required&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"NON_REQUIRED"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_domain&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;""&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;)&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;[&lt;/SPAN&gt;&lt;SPAN class="number token"&gt;0&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;]&lt;/SPAN&gt;

&lt;SPAN class="comment token"&gt;# Process: Add Field (6) (Add Field)&lt;/SPAN&gt;
Scores_Geocoded_11_ &lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt; arcpy&lt;SPAN class="punctuation token"&gt;.&lt;/SPAN&gt;AddField_management&lt;SPAN class="punctuation token"&gt;(&lt;/SPAN&gt;in_table&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;Scores_Geocoded_6_&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_name&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"latestscore"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_type&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"TEXT"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_precision&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;None&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_scale&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;None&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_length&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="number token"&gt;100&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_alias&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"Latest Score"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_is_nullable&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"NULLABLE"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_is_required&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"NON_REQUIRED"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_domain&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;""&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;)&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;[&lt;/SPAN&gt;&lt;SPAN class="number token"&gt;0&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;]&lt;/SPAN&gt;

&lt;SPAN class="comment token"&gt;# Process: Add Field (7) (Add Field)&lt;/SPAN&gt;
Scores_Geocoded_8_ &lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt; arcpy&lt;SPAN class="punctuation token"&gt;.&lt;/SPAN&gt;AddField_management&lt;SPAN class="punctuation token"&gt;(&lt;/SPAN&gt;in_table&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;Scores_Geocoded_11_&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_name&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"PreviousTempDate"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_type&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"TEXT"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_precision&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;None&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_scale&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;None&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_length&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="number token"&gt;50&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_alias&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"Previous Inspection Date"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_is_nullable&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"NULLABLE"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_is_required&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"NON_REQUIRED"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_domain&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;""&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;)&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;[&lt;/SPAN&gt;&lt;SPAN class="number token"&gt;0&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;]&lt;/SPAN&gt;

&lt;SPAN class="comment token"&gt;# Process: Add Field (8) (Add Field)&lt;/SPAN&gt;
Scores_Geocoded_7_ &lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt; arcpy&lt;SPAN class="punctuation token"&gt;.&lt;/SPAN&gt;AddField_management&lt;SPAN class="punctuation token"&gt;(&lt;/SPAN&gt;in_table&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;Scores_Geocoded_8_&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_name&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"previnspscore"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_type&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"TEXT"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_precision&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;None&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_scale&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;None&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_length&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="number token"&gt;50&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_alias&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"Previous Inspection Score"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_is_nullable&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"NULLABLE"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_is_required&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"NON_REQUIRED"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_domain&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;""&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;)&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;[&lt;/SPAN&gt;&lt;SPAN class="number token"&gt;0&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;]&lt;/SPAN&gt;

&lt;SPAN class="comment token"&gt;# Process: Calculate Field (Calculate Field)&lt;/SPAN&gt;
Scores_Geocoded_9_ &lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt; arcpy&lt;SPAN class="punctuation token"&gt;.&lt;/SPAN&gt;CalculateField_management&lt;SPAN class="punctuation token"&gt;(&lt;/SPAN&gt;in_table&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;Scores_Geocoded_7_&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"establishmentname"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; expression&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"!USER_COMPANY!"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; expression_type&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"PYTHON3"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; code_block&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;""&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_type&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"TEXT"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;)&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;[&lt;/SPAN&gt;&lt;SPAN class="number token"&gt;0&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;]&lt;/SPAN&gt;

&lt;SPAN class="comment token"&gt;# Process: Calculate Field (2) (Calculate Field)&lt;/SPAN&gt;
Scores_Geocoded_18_ &lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt; arcpy&lt;SPAN class="punctuation token"&gt;.&lt;/SPAN&gt;CalculateField_management&lt;SPAN class="punctuation token"&gt;(&lt;/SPAN&gt;in_table&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;Scores_Geocoded_9_&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"address"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; expression&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"!USER_LOC_ADDRESS1!"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; expression_type&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"PYTHON3"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; code_block&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;""&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_type&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"TEXT"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;)&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;[&lt;/SPAN&gt;&lt;SPAN class="number token"&gt;0&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;]&lt;/SPAN&gt;

&lt;SPAN class="comment token"&gt;# Process: Calculate Field (3) (Calculate Field)&lt;/SPAN&gt;
Scores_Geocoded_12_ &lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt; arcpy&lt;SPAN class="punctuation token"&gt;.&lt;/SPAN&gt;CalculateField_management&lt;SPAN class="punctuation token"&gt;(&lt;/SPAN&gt;in_table&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;Scores_Geocoded_18_&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"identifier"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; expression&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"!USER_INSPECTOR!"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; expression_type&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"PYTHON3"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; code_block&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;""&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_type&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"TEXT"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;)&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;[&lt;/SPAN&gt;&lt;SPAN class="number token"&gt;0&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;]&lt;/SPAN&gt;

&lt;SPAN class="comment token"&gt;# Process: Calculate Field (4) (Calculate Field)&lt;/SPAN&gt;
Scores_Geocoded_10_ &lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt; arcpy&lt;SPAN class="punctuation token"&gt;.&lt;/SPAN&gt;CalculateField_management&lt;SPAN class="punctuation token"&gt;(&lt;/SPAN&gt;in_table&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;Scores_Geocoded_12_&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"inspdate"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; expression&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"!USER_LATEST_REVIEW_DATE!"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; expression_type&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"PYTHON3"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; code_block&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;""&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_type&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"TEXT"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;)&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;[&lt;/SPAN&gt;&lt;SPAN class="number token"&gt;0&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;]&lt;/SPAN&gt;

&lt;SPAN class="comment token"&gt;# Process: Calculate Field (5) (Calculate Field)&lt;/SPAN&gt;
Scores_Geocoded_13_ &lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt; arcpy&lt;SPAN class="punctuation token"&gt;.&lt;/SPAN&gt;CalculateField_management&lt;SPAN class="punctuation token"&gt;(&lt;/SPAN&gt;in_table&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;Scores_Geocoded_10_&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"latestscore"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; expression&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"!USER_LATEST_SCORE!"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; expression_type&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"PYTHON3"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; code_block&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;""&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_type&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"TEXT"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;)&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;[&lt;/SPAN&gt;&lt;SPAN class="number token"&gt;0&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;]&lt;/SPAN&gt;

&lt;SPAN class="comment token"&gt;# Process: Calculate Field (6) (Calculate Field)&lt;/SPAN&gt;
Scores_Geocoded_14_ &lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt; arcpy&lt;SPAN class="punctuation token"&gt;.&lt;/SPAN&gt;CalculateField_management&lt;SPAN class="punctuation token"&gt;(&lt;/SPAN&gt;in_table&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;Scores_Geocoded_13_&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"PreviousTempDate"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; expression&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"!USER_PREVIOUS_REVIEW_DATE!"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; expression_type&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"PYTHON3"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; code_block&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;""&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_type&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"TEXT"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;)&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;[&lt;/SPAN&gt;&lt;SPAN class="number token"&gt;0&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;]&lt;/SPAN&gt;

&lt;SPAN class="comment token"&gt;# Process: Calculate Field (7) (Calculate Field)&lt;/SPAN&gt;
Scores_Geocoded_15_ &lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt; arcpy&lt;SPAN class="punctuation token"&gt;.&lt;/SPAN&gt;CalculateField_management&lt;SPAN class="punctuation token"&gt;(&lt;/SPAN&gt;in_table&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;Scores_Geocoded_14_&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"permnum"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; expression&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"!USER_BUS_LIC_NO!"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; expression_type&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"PYTHON3"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; code_block&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;""&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_type&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"TEXT"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;)&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;[&lt;/SPAN&gt;&lt;SPAN class="number token"&gt;0&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;]&lt;/SPAN&gt;

&lt;SPAN class="comment token"&gt;# Process: Calculate Field (8) (Calculate Field)&lt;/SPAN&gt;
Scores_Geocoded_16_ &lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt; arcpy&lt;SPAN class="punctuation token"&gt;.&lt;/SPAN&gt;CalculateField_management&lt;SPAN class="punctuation token"&gt;(&lt;/SPAN&gt;in_table&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;Scores_Geocoded_15_&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"previnspscore"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; expression&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"!USER_PREVIOUS_SCORE!"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; expression_type&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"PYTHON3"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; code_block&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;""&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; field_type&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"TEXT"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;)&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;[&lt;/SPAN&gt;&lt;SPAN class="number token"&gt;0&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;]&lt;/SPAN&gt;

&lt;SPAN class="comment token"&gt;# Process: Delete Field (Delete Field)&lt;/SPAN&gt;
Scores_Geocoded_17_ &lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt; arcpy&lt;SPAN class="punctuation token"&gt;.&lt;/SPAN&gt;DeleteField_management&lt;SPAN class="punctuation token"&gt;(&lt;/SPAN&gt;in_table&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;Scores_Geocoded_16_&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; drop_field&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;[&lt;/SPAN&gt;&lt;SPAN class="string token"&gt;"Loc_name"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; &lt;SPAN class="string token"&gt;"Status"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; &lt;SPAN class="string token"&gt;"Score"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; &lt;SPAN class="string token"&gt;"Match_type"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; &lt;SPAN class="string token"&gt;"Match_addr"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; &lt;SPAN class="string token"&gt;"User_fld"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; &lt;SPAN class="string token"&gt;"Addr_type"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; &lt;SPAN class="string token"&gt;"Side"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; &lt;SPAN class="string token"&gt;"IN_SingleLine"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; &lt;SPAN class="string token"&gt;"USER_BUSINESS_NO"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; &lt;SPAN class="string token"&gt;"USER_SITE_APN"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; &lt;SPAN class="string token"&gt;"USER_COMPANY"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; &lt;SPAN class="string token"&gt;"USER_LOC_ADDRESS1"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; &lt;SPAN class="string token"&gt;"USER_INSPECTIONTYPE"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; &lt;SPAN class="string token"&gt;"USER_INSPECTOR"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; &lt;SPAN class="string token"&gt;"USER_BUS_LIC_NO"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; &lt;SPAN class="string token"&gt;"USER_STATUS"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; &lt;SPAN class="string token"&gt;"USER_LATEST_SCORE"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; &lt;SPAN class="string token"&gt;"USER_LATEST_REVIEW_DATE"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; &lt;SPAN class="string token"&gt;"USER_RECORDID"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; &lt;SPAN class="string token"&gt;"USER_PREVIOUS_REVIEW_DATE"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; &lt;SPAN class="string token"&gt;"USER_PREVIOUS_SCORE"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;]&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;)&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;[&lt;/SPAN&gt;&lt;SPAN class="number token"&gt;0&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;]&lt;/SPAN&gt;

&lt;SPAN class="keyword token"&gt;if&lt;/SPAN&gt; __name__ &lt;SPAN class="operator token"&gt;==&lt;/SPAN&gt; &lt;SPAN class="string token"&gt;'__main__'&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;:&lt;/SPAN&gt;
&lt;SPAN class="comment token"&gt;# Global Environment settings&lt;/SPAN&gt;
&lt;SPAN class="keyword token"&gt;with&lt;/SPAN&gt; arcpy&lt;SPAN class="punctuation token"&gt;.&lt;/SPAN&gt;EnvManager&lt;SPAN class="punctuation token"&gt;(&lt;/SPAN&gt;scratchWorkspace&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;r&lt;SPAN class="string token"&gt;"C:\Users\pforrest\Documents\ArcGIS\Projects\Restaurant Inspections\Restaurant Inspections.gdb"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; workspace&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;r&lt;SPAN class="string token"&gt;"C:\Users\pforrest\Documents\ArcGIS\Projects\Restaurant Inspections\Restaurant Inspections.gdb"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;)&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;:&lt;/SPAN&gt;
Model&lt;SPAN class="punctuation token"&gt;(&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;)&lt;/SPAN&gt;&lt;SPAN class="line-numbers-rows"&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/CODE&gt;&lt;/PRE&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Check out the name of your GDB...&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;PRE class="lia-code-sample line-numbers language-none"&gt;&lt;CODE&gt;&lt;SPAN class="comment token"&gt;# this is line 9&lt;/SPAN&gt;

ReastaurantInspections_gdb &lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt; 
&lt;SPAN class="string token"&gt;"C:\\arcgisserver\\arcgisresources\\Code\\ReastaurantInspections.gdb"&lt;/SPAN&gt;

&lt;SPAN class="comment token"&gt;# this is line 72&lt;/SPAN&gt;
&lt;SPAN class="keyword token"&gt;with&lt;/SPAN&gt; arcpy&lt;SPAN class="punctuation token"&gt;.&lt;/SPAN&gt;EnvManager&lt;SPAN class="punctuation token"&gt;(&lt;/SPAN&gt;scratchWorkspace&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;r&lt;SPAN class="string token"&gt;"C:\Users\pforrest\Documents\ArcGIS\Projects\Restaurant Inspections\Restaurant Inspections.gdb"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;,&lt;/SPAN&gt; workspace&lt;SPAN class="operator token"&gt;=&lt;/SPAN&gt;r&lt;SPAN class="string token"&gt;"C:\Users\pforrest\Documents\ArcGIS\Projects\Restaurant Inspections\Restaurant Inspections.gdb"&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;)&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;:&lt;/SPAN&gt;
Model&lt;SPAN class="punctuation token"&gt;(&lt;/SPAN&gt;&lt;SPAN class="punctuation token"&gt;)&lt;/SPAN&gt;&lt;SPAN class="line-numbers-rows"&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;SPAN&gt;‍&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/CODE&gt;&lt;/PRE&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Do both lines need to&amp;nbsp;point to the same GDB?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Sun, 12 Dec 2021 01:51:14 GMT</pubDate>
      <guid>https://community.esri.com/t5/python-questions/python-runtime-error/m-p/602894#M47115</guid>
      <dc:creator>Arne_Gelfert</dc:creator>
      <dc:date>2021-12-12T01:51:14Z</dc:date>
    </item>
    <item>
      <title>Re: Python Runtime Error</title>
      <link>https://community.esri.com/t5/python-questions/python-runtime-error/m-p/602895#M47116</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;those are just the global env settings, and don't really apply to my model.&amp;nbsp; I copied the one form above to check and same error result.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 24 Jul 2020 18:26:41 GMT</pubDate>
      <guid>https://community.esri.com/t5/python-questions/python-runtime-error/m-p/602895#M47116</guid>
      <dc:creator>PatrickForrest1</dc:creator>
      <dc:date>2020-07-24T18:26:41Z</dc:date>
    </item>
    <item>
      <title>Re: Python Runtime Error</title>
      <link>https://community.esri.com/t5/python-questions/python-runtime-error/m-p/602896#M47117</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Full disclosure, I don't know too much about the exact commands or the nature of field mapping syntax you're using but - just off the cuff - the following looks like it could use some quotes and commas around various parameters... e.g. "true true true" looks weird&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;PRE class="lia-code-sample line-numbers language-none"&gt;&lt;SPAN style="color: #3d3d3d; background-color: #ffffff;"&gt;field_mapping="BUSINESS_NO \"BUSINESS_NO\" true true false 4 Long 0 0,First,#,
P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,BUSINESS_NO,-1,-1;SITE_APN \"SITE_APN\" true true false 8000 Text 0 0,First,#,
P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,SITE_APN,0,8000;COMPANY \"COMPANY\" true true false 8000 Text 0 0,First,#,
P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,COMPANY,0,8000;LOC_ADDRESS1 \"LOC_ADDRESS1\" true true false 8000 Text 0 0,First,#,
P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,LOC_ADDRESS1,0,8000;INSPECTIONTYPE \"INSPECTIONTYPE\" true true false 8000 Text 0 0,First,#,
P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,INSPECTIONTYPE,0,8000;INSPECTOR \"INSPECTOR\" true true false 8000 Text 0 0,First,#,
P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,INSPECTOR,0,8000;BUS_LIC_NO \"BUS_LIC_NO\" true true false 8000 Text 0 0,First,#,
P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,BUS_LIC_NO,0,8000;STATUS \"STATUS\" true true false 8000 Text 0 0,First,#,
P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,STATUS,0,8000;LATEST_REVIEW_DATE \"LATEST_REVIEW_DATE\" true true false 8 Date 0 0,First,#,
P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,LATEST_REVIEW_DATE,-1,-1;LATEST_SCORE \"LATEST_SCORE\" true true false 8000 Text 0 0,First,#,
P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,LATEST_SCORE,0,8000;RECORDID \"RECORDID\" true true false 8000 Text 0 0,First,#,
P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,RECORDID,0,8000;PREVIOUS_REVIEW_DATE \"PREVIOUS_REVIEW_DATE\" true true false 8000 Text 0 0,First,#,
P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,PREVIOUS_REVIEW_DATE,0,8000;PREVIOUS_SCORE \"PREVIOUS_SCORE\" true true false 8000 Text 0 0,First,#,
P:\\GIS\\Brad Simpson\\Python\\restaurant_scores.csv,PREVIOUS_SCORE,0,8000"&lt;/SPAN&gt;&lt;/PRE&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Sun, 12 Dec 2021 01:51:16 GMT</pubDate>
      <guid>https://community.esri.com/t5/python-questions/python-runtime-error/m-p/602896#M47117</guid>
      <dc:creator>Arne_Gelfert</dc:creator>
      <dc:date>2021-12-12T01:51:16Z</dc:date>
    </item>
    <item>
      <title>Re: Python Runtime Error</title>
      <link>https://community.esri.com/t5/python-questions/python-runtime-error/m-p/602897#M47118</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;It helps to provide the traceback and not just the error.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 24 Jul 2020 20:02:06 GMT</pubDate>
      <guid>https://community.esri.com/t5/python-questions/python-runtime-error/m-p/602897#M47118</guid>
      <dc:creator>JoshuaBixby</dc:creator>
      <dc:date>2020-07-24T20:02:06Z</dc:date>
    </item>
  </channel>
</rss>

