I have this code that performs a Summarize Within on all company stores for every month of the year. However, not all the stores were open in some of the early months so I need to write some code that will identify that the "USER_PatientVisits" is equal to zero and then skip that store and move on to the next. I'm thinking this can be accomplished using an "If" statement and probably a loop; however, I'm not sure what exactly to write and how to bring it all together. Here is the top portion of my code for January and February; the full code continues on through December: import arcpy import sys import os import datetime #now = datetime.datetime.now() arcpy . env . overwriteOutput = True #Set the workspace from arcpy import env env . workspace = r "C:\arcGIS_Shared\Python\CenterHeatMaps.gdb" #Declare variables fc = 'Open_Store_Centers' fields = [ 'USER_market_id' , 'USER_Store_ID' , 'USER_Store_Center_Name' ] fieldname = 'USER_market_id' #Define WHERE clause statement whereclause = """{} = 2000""" . format ( arcpy . AddFieldDelimiters ( fc , fieldname ) ) #Cursor to create list of centers to loop through cursor = arcpy . da . SearchCursor ( in_table = fc , field_names = fields , where_clause = whereclause , sql_clause = ( None , 'ORDER BY USER_market_id, USER_Store_ID' ) ) #Loop to run SummarizeWithin by center for row in ( cursor ) : # Set variables for SummarizeWithin # Specify type of summarization, either Blocks or ZIPS, as part of the polys argument polys = "Market{0}" . format ( row [ 0 ] ) + "Blocks" points = "Jan_NWPatientVisits{0}" . format ( row [ 0 ] ) + "{0}" . format ( row [ 2 ] ) outFeatureClass = "Jan_NWSumWithin{0}" . format ( row [ 0 ] ) + "{0}" . format ( row [ 2 ] ) keepAll = 'ONLY_INTERSECTING' sumFields = [ [ 'USER_VisitCount' , 'Sum' ] ] addShapeSum = 'ADD_SHAPE_SUM' arcpy . SummarizeWithin_analysis ( polys , points , outFeatureClass , keepAll , sumFields , addShapeSum , '' ) #Print Results print ( row [ 2 ] ) # print("SumWithin Elapsed Time:" + SumWithinruntime) # count = arcpy.GetMessageCount() # print (arcpy.GetMessage(count-2)) print ( arcpy . GetMessages ( ) ) #Declare variables fc = 'Open_Store_Centers' fields = [ 'USER_market_id' , 'USER_Store_ID' , 'USER_Store_Center_Name' ] fieldname = 'USER_market_id' #Define WHERE clause statement whereclause = """{} = 2000""" . format ( arcpy . AddFieldDelimiters ( fc , fieldname ) ) #Cursor to create list of centers to loop through cursor = arcpy . da . SearchCursor ( in_table = fc , field_names = fields , where_clause = whereclause , sql_clause = ( None , 'ORDER BY USER_market_id, USER_Store_ID' ) ) #Loop to run SummarizeWithin by center for row in ( cursor ) : # Set variables for SummarizeWithin # Specify type of summarization, either Blocks or ZIPS, as part of the polys argument polys = "Market{0}" . format ( row [ 0 ] ) + "Blocks" points = "Feb_NWPatientVisits{0}" . format ( row [ 0 ] ) + "{0}" . format ( row [ 2 ] ) outFeatureClass = "Feb_NWSumWithin{0}" . format ( row [ 0 ] ) + "{0}" . format ( row [ 2 ] ) keepAll = 'ONLY_INTERSECTING' sumFields = [ [ 'USER_VisitCount' , 'Sum' ] ] addShapeSum = 'ADD_SHAPE_SUM' arcpy . SummarizeWithin_analysis ( polys , points , outFeatureClass , keepAll , sumFields , addShapeSum , '' ) #Print Results print ( row [ 2 ] ) # print("SumWithin Elapsed Time:" + SumWithinruntime) # count = arcpy.GetMessageCount() # print (arcpy.GetMessage(count-2)) print ( arcpy . GetMessages ( ) )

Unfortunately I think I will have to put this project on the back burner for now. Thank you everyone for your help. Sorry for any confusion or inconvenience. If I figure out this problem I will post the solution. Thanks

And my final contribution will be regarding what 'row[0]' is If it is zero (0), None, , nadda... do you want to continue or not? row0 = None # pretend this is row[0] "May_CTPatientVisits{0}" . format ( row0 ) # ditto 'May_CTPatientVisitsNone' # ---- is this what you want? or do you want to bail

Okay maybe I need to take a step back and give some more details. So I have multiple steps of code each in its own document. Step 1 geocodes a table of all Patient Visits. Step 2 then takes the geocoded results and creates a feature class for each Store's visits for every month for 2017. Then Step 3 is what we have been working on with the Summarize Within. So maybe I should have led off with Step 2 instead of Step 3. Here is the code for Steps 1 and 2. Step 1 import arcpy from arcpy import env env . workspace = r "C:\arcGIS_Shared\Python\CenterHeatMaps.gdb" # Set local variables: address_table = "PatientVisits" address_locator = "C:/2016 US Data/ESRI_BA_2016_US_Data_Update/USA_LocalComposite" address_fields = "Address AddressLine1;City City;State State;ZIP_Code ZIP" geocode_result = "PatientVisitsGeocoded" arcpy . GeocodeAddresses_geocoding ( address_table , address_locator , address_fields , geocode_result , 'STATIC' ) Step 2 fc = 'Open_Store_Centers' fields = [ 'USER_market_id' , 'USER_Store_ID' , 'USER_Store_Center_Name' ] fieldname = 'USER_market_id' #Define WHERE clause statement whereclause = """{} = 4000""" . format ( arcpy . AddFieldDelimiters ( fc , fieldname ) ) #Cursor to create list of centers to loop through cursor = arcpy . da . SearchCursor ( in_table = fc , field_names = fields , where_clause = whereclause , sql_clause = ( None , 'ORDER BY USER_market_id, USER_Store_ID' ) ) #Loop through each row established in cursor for row in ( cursor ) : # Set local variables for FeatureClasstoFeatureClass inFeatures = "PatientVisitsGeocoded" outLocation = r "C:\arcGIS_Shared\Python\CenterHeatMaps.gdb" outFeatureClass = "May_CTPatientVisits{0}" . format ( row [ 0 ] ) + "{0}" . format ( row [ 2 ] ) delimitedfield = arcpy . AddFieldDelimiters ( arcpy . env . workspace , "USER_CenterID" ) expression = delimitedfield + "= {0}" . format ( row [ 1 ] ) + "AND USER_DOSYear = 2017 AND USER_DOSMonth = 'May'" # Where clause for Financial Class # + "AND USER_OrigFinClass = 'BCBS'" # Execute FeatureClassToFeatureClass arcpy . FeatureClassToFeatureClass_conversion ( inFeatures , outLocation , outFeatureClass , expression ) #Print Results print ( row [ 2 ] ) count = arcpy . GetMessageCount ( ) print ( arcpy . GetMessage ( count -1 ) ) Step 2 repeats the same code for every month so that is obviously something I need to change into a loop I hope this helps clear stuff up, because I think we are all a little confused

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

"If" Statement and Loop - ArcPy for ArcGIS Pro

Business_IntelligenceSoftware

I have this code that performs a Summarize Within on all company stores for every month of the year. However, not all the stores were open in some of the early months so I need to write some code that will identify that the "USER_PatientVisits" is equal to zero and then skip that store and move on to the next. I'm thinking this can be accomplished using an "If" statement and probably a loop; however, I'm not sure what exactly to write and how to bring it all together.

Here is the top portion of my code for January and February; the full code continues on through December:

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">import</SPAN> sys
<SPAN class="keyword token">import</SPAN> os
<SPAN class="keyword token">import</SPAN> datetime

<SPAN class="comment token">#now = datetime.datetime.now()</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>overwriteOutput <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN>

<SPAN class="comment token">#Set the workspace</SPAN>
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env
env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\arcGIS_Shared\Python\CenterHeatMaps.gdb"</SPAN>

<SPAN class="comment token">#Declare variables</SPAN>
fc <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Open_Store_Centers'</SPAN>
fields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'USER_market_id'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'USER_Store_ID'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'USER_Store_Center_Name'</SPAN><SPAN class="punctuation token">]</SPAN>
fieldname <SPAN class="operator token">=</SPAN> <SPAN class="string token">'USER_market_id'</SPAN>

<SPAN class="comment token">#Define WHERE clause statement</SPAN>
whereclause <SPAN class="operator token">=</SPAN> <SPAN class="string token">"""{} = 2000"""</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>AddFieldDelimiters<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> fieldname<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">#Cursor to create list of centers to loop through</SPAN>
cursor <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>in_table <SPAN class="operator token">=</SPAN> fc<SPAN class="punctuation token">,</SPAN> field_names <SPAN class="operator token">=</SPAN> fields<SPAN class="punctuation token">,</SPAN> where_clause<SPAN class="operator token">=</SPAN>whereclause<SPAN class="punctuation token">,</SPAN> sql_clause<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">(</SPAN>None<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ORDER BY USER_market_id, USER_Store_ID'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">#Loop to run SummarizeWithin by center</SPAN>
<SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> <SPAN class="punctuation token">(</SPAN>cursor<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#&nbsp; Set variables for SummarizeWithin</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#&nbsp; Specify type of summarization, either Blocks or ZIPS, as part of the polys argument</SPAN>
&nbsp;&nbsp;&nbsp; polys <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Market{0}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="operator token">+</SPAN><SPAN class="string token">"Blocks"</SPAN>
&nbsp;&nbsp;&nbsp; points <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Jan_NWPatientVisits{0}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="operator token">+</SPAN><SPAN class="string token">"{0}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; outFeatureClass <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Jan_NWSumWithin{0}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="operator token">+</SPAN><SPAN class="string token">"{0}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; keepAll <SPAN class="operator token">=</SPAN> <SPAN class="string token">'ONLY_INTERSECTING'</SPAN>
&nbsp;&nbsp;&nbsp; sumFields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'USER_VisitCount'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Sum'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; addShapeSum <SPAN class="operator token">=</SPAN> <SPAN class="string token">'ADD_SHAPE_SUM'</SPAN>

&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>SummarizeWithin_analysis<SPAN class="punctuation token">(</SPAN>polys<SPAN class="punctuation token">,</SPAN> points<SPAN class="punctuation token">,</SPAN> outFeatureClass<SPAN class="punctuation token">,</SPAN> keepAll<SPAN class="punctuation token">,</SPAN> sumFields<SPAN class="punctuation token">,</SPAN> addShapeSum<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">''</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#Print Results</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">#&nbsp;&nbsp;&nbsp; print("SumWithin Elapsed Time:" + SumWithinruntime)</SPAN>
<SPAN class="comment token">#&nbsp;&nbsp;&nbsp; count = arcpy.GetMessageCount()</SPAN>
<SPAN class="comment token">#&nbsp;&nbsp;&nbsp; print (arcpy.GetMessage(count-2))</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>GetMessages<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#Declare variables</SPAN>
fc <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Open_Store_Centers'</SPAN>
fields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'USER_market_id'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'USER_Store_ID'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'USER_Store_Center_Name'</SPAN><SPAN class="punctuation token">]</SPAN>
fieldname <SPAN class="operator token">=</SPAN> <SPAN class="string token">'USER_market_id'</SPAN>

<SPAN class="comment token">#Define WHERE clause statement</SPAN>
whereclause <SPAN class="operator token">=</SPAN> <SPAN class="string token">"""{} = 2000"""</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>AddFieldDelimiters<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> fieldname<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">#Cursor to create list of centers to loop through</SPAN>
cursor <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>in_table <SPAN class="operator token">=</SPAN> fc<SPAN class="punctuation token">,</SPAN> field_names <SPAN class="operator token">=</SPAN> fields<SPAN class="punctuation token">,</SPAN> where_clause<SPAN class="operator token">=</SPAN>whereclause<SPAN class="punctuation token">,</SPAN> sql_clause<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">(</SPAN>None<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ORDER BY USER_market_id, USER_Store_ID'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">#Loop to run SummarizeWithin by center</SPAN>
<SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> <SPAN class="punctuation token">(</SPAN>cursor<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#&nbsp; Set variables for SummarizeWithin</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#&nbsp; Specify type of summarization, either Blocks or ZIPS, as part of the polys argument</SPAN>
&nbsp;&nbsp;&nbsp; polys <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Market{0}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="operator token">+</SPAN><SPAN class="string token">"Blocks"</SPAN>
&nbsp;&nbsp;&nbsp; points <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Feb_NWPatientVisits{0}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="operator token">+</SPAN><SPAN class="string token">"{0}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; outFeatureClass <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Feb_NWSumWithin{0}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="operator token">+</SPAN><SPAN class="string token">"{0}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; keepAll <SPAN class="operator token">=</SPAN> <SPAN class="string token">'ONLY_INTERSECTING'</SPAN>
&nbsp;&nbsp;&nbsp; sumFields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'USER_VisitCount'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Sum'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp; addShapeSum <SPAN class="operator token">=</SPAN> <SPAN class="string token">'ADD_SHAPE_SUM'</SPAN>

&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>SummarizeWithin_analysis<SPAN class="punctuation token">(</SPAN>polys<SPAN class="punctuation token">,</SPAN> points<SPAN class="punctuation token">,</SPAN> outFeatureClass<SPAN class="punctuation token">,</SPAN> keepAll<SPAN class="punctuation token">,</SPAN> sumFields<SPAN class="punctuation token">,</SPAN> addShapeSum<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">''</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#Print Results</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">#&nbsp;&nbsp;&nbsp; print("SumWithin Elapsed Time:" + SumWithinruntime)</SPAN>
<SPAN class="comment token">#&nbsp;&nbsp;&nbsp; count = arcpy.GetMessageCount()</SPAN>
<SPAN class="comment token">#&nbsp;&nbsp;&nbsp; print (arcpy.GetMessage(count-2))</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>GetMessages<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Find more posts tagged with

Accepted answers

All comments

Business_IntelligenceSoftware

I was not sure what to set "points" is not equal (<>) to (""), and what to put after it.

Here is what I have so far

<SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> <SPAN class="punctuation token">(</SPAN>cursor<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#&nbsp; Set variables for SummarizeWithin</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#&nbsp; Specify type of summarization, either Blocks or ZIPS, as part of the polys argument</SPAN>
&nbsp;&nbsp;&nbsp; polys <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Market{0}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="operator token">+</SPAN><SPAN class="string token">"Blocks"</SPAN>
&nbsp;&nbsp;&nbsp; points <SPAN class="operator token">=</SPAN> <SPAN class="string token">"May_CTPatientVisits{0}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="operator token">+</SPAN><SPAN class="string token">"{0}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> points <SPAN class="keyword token">is</SPAN> <SPAN class="operator token">not</SPAN> None<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; outFeatureClass <SPAN class="operator token">=</SPAN> <SPAN class="string token">"May2_CTSumWithin{0}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="operator token">+</SPAN><SPAN class="string token">"{0}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; keepAll <SPAN class="operator token">=</SPAN> <SPAN class="string token">'ONLY_INTERSECTING'</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sumFields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'USER_VisitCount'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Sum'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; addShapeSum <SPAN class="operator token">=</SPAN> <SPAN class="string token">'ADD_SHAPE_SUM'</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>SummarizeWithin_analysis<SPAN class="punctuation token">(</SPAN>polys<SPAN class="punctuation token">,</SPAN> points<SPAN class="punctuation token">,</SPAN> outFeatureClass<SPAN class="punctuation token">,</SPAN> keepAll<SPAN class="punctuation token">,</SPAN> sumFields<SPAN class="punctuation token">,</SPAN> addShapeSum<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">''</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#Print Results</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">#&nbsp;&nbsp;&nbsp; print("SumWithin Elapsed Time:" + SumWithinruntime)</SPAN>
<SPAN class="comment token">#&nbsp;&nbsp;&nbsp; count = arcpy.GetMessageCount()</SPAN>
<SPAN class="comment token">#&nbsp;&nbsp;&nbsp; print (arcpy.GetMessage(count-2))</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>GetMessages<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

DanPatterson_Retired

did neither of my suggestions work? ie checking for None, or an empty string?

If they didn't, could you report the error so that we can figure out what is in the records that is causing the problem

Business_IntelligenceSoftware

This looks promising. Do you know where I would insert that function into Xander Bakker's looping example above?

DanPatterson_Retired

Why! that looks like a brilliant function! cool

JoeBorgione

In a project that I've been tasked with, I have moved from several if, elif, else blocks to try:/except: blocks . Not sure if that approach is applicable here, but may be worth a try. Here I examine a size of on a numpy array, and if it has size I work with with it; if it isn't even created (which indicates it didn't need to be) I don't sweat it...

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; name6
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> name6<SPAN class="punctuation token">.</SPAN>size <SPAN class="operator token"><></SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; hitList6 <SPAN class="operator token">=</SPAN> _flatten<SPAN class="punctuation token">(</SPAN>name6<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">del</SPAN> name6
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">pass</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">except</SPAN> NameError<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">pass</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Dan Patterson‌, notice the call to _flatten() ?

Business_IntelligenceSoftware

Yes the code is duplicated for each month. Unfortunately, "if points > 0:" gives me the following error.

TypeError<SPAN class="punctuation token">:</SPAN> unorderable types<SPAN class="punctuation token">:</SPAN> str<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">></SPAN> int<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

I then tried adding " " around the zero to change it from an integer to a string, which allowed it to run, but it did not exclude the stores with zero visits

XanderBakker

Also when you feel that you are repeating code (like you now have a big block for Jan and another for Feb) it is time to use a loop. For instance have a list of the month prefixes that you want to use like months = ['Jan', 'Feb', ..., 'Dec'] and loop through the months. Something like this (ignoring any other changes that might be required in the code):

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">import</SPAN> sys
<SPAN class="keyword token">import</SPAN> os
<SPAN class="keyword token">import</SPAN> datetime

<SPAN class="comment token">#now = datetime.datetime.now()</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>overwriteOutput <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN>

<SPAN class="comment token">#Set the workspace</SPAN>
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env
env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\arcGIS_Shared\Python\CenterHeatMaps.gdb"</SPAN>

<SPAN class="comment token">#Declare variables</SPAN>
fc <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Open_Store_Centers'</SPAN>
fields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'USER_market_id'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'USER_Store_ID'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'USER_Store_Center_Name'</SPAN><SPAN class="punctuation token">]</SPAN>
fieldname <SPAN class="operator token">=</SPAN> <SPAN class="string token">'USER_market_id'</SPAN>

<SPAN class="comment token">#Define WHERE clause statement</SPAN>
whereclause <SPAN class="operator token">=</SPAN> <SPAN class="string token">"{0} = 2000"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>AddFieldDelimiters<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> fieldname<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
sqlclause <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN>None<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ORDER BY USER_market_id, USER_Store_ID'</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># loop through months</SPAN>
months <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Jan'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Feb'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Mar'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="comment token"># add all the months</SPAN>
<SPAN class="keyword token">for</SPAN> month <SPAN class="keyword token">in</SPAN> months<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#Cursor to create list of centers to loop through</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>in_table<SPAN class="operator token">=</SPAN>fc<SPAN class="punctuation token">,</SPAN> field_names<SPAN class="operator token">=</SPAN>fields<SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where_clause<SPAN class="operator token">=</SPAN>whereclause<SPAN class="punctuation token">,</SPAN> sql_clause<SPAN class="operator token">=</SPAN>sqlclause<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#Loop to run SummarizeWithin by center</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#&nbsp; Set variables for SummarizeWithin</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#&nbsp; Specify type of summarization, either Blocks or ZIPS, as part of the polys argument</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; polys <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Market{0}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="operator token">+</SPAN><SPAN class="string token">"Blocks"</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; points <SPAN class="operator token">=</SPAN> <SPAN class="string token">"{2}_NWPatientVisits{0}{1}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> month<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; outFeatureClass <SPAN class="operator token">=</SPAN> <SPAN class="string token">"{2}_NWSumWithin{0}{1}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> month<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; keepAll <SPAN class="operator token">=</SPAN> <SPAN class="string token">'ONLY_INTERSECTING'</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sumFields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'USER_VisitCount'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Sum'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; addShapeSum <SPAN class="operator token">=</SPAN> <SPAN class="string token">'ADD_SHAPE_SUM'</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>SummarizeWithin_analysis<SPAN class="punctuation token">(</SPAN>polys<SPAN class="punctuation token">,</SPAN> points<SPAN class="punctuation token">,</SPAN> outFeatureClass<SPAN class="punctuation token">,</SPAN> keepAll<SPAN class="punctuation token">,</SPAN> sumFields<SPAN class="punctuation token">,</SPAN> addShapeSum<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">''</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#Print Results</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#&nbsp;&nbsp;&nbsp; print("SumWithin Elapsed Time:" + SumWithinruntime)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#&nbsp;&nbsp;&nbsp; count = arcpy.GetMessageCount()</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#&nbsp;&nbsp;&nbsp; print (arcpy.GetMessage(count-2))</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>GetMessages<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

DanPatterson_Retired

Use the Python option within the syntax highlighter to get line numbers.

After this line

points = "Feb_NWPatientVisits{0}".format(row[0])+"{0}".format(row[2])

<SPAN class="keyword token">if</SPAN> points <SPAN class="operator token">></SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># then indent all your other lines</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># to continue the processing</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># just guessing since there are no line numbers </SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># and portions of the code seem to be duplicated</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Business_IntelligenceSoftware

Sorry about that. I don't know why it was in that format

DanPatterson_Retired

Code formatting please it is unreadable in its current state. Try not to edit code once it is pasted in either, that seems to be what happened. Edit in the source, then paste

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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