Hi everyone, I am trying to create a script to run every night to calculate the total insects counted each day by summing two insect count fields in a feature layer. I can't use Arcade because the layer has "track changes" and "sync" enabled for the field crew (grrrr...). Below is my simple script to calculate the "TotalArmyworms" field based on summing the Western Yellow Armyworm field with the Bertha Armyworm field. I have tried many different ways to identify the layer from AGOL, and each time the error states that 'Item' object has no attribute 'calculate'. Any thoughts? import arcgis import arcpy from arcgis . gis import GIS from arcgis import features from arcgis . features import FeatureLayer gis = GIS ( 'https://arcgis.com' , 'xyz' , 'xyz' ) arcpy . env . overwriteOutput = True trap_count = gis . content . get ( "b6b9c68fa42b408a88c68aa9e18593d5" ) trap_count trap_count . calculate ( where = "fid > 0" , calc_expression = [ { "field" : "TotalArmyworms" , "sqlExpression" : "Nu_W_YellowStripedArmyworm + Nu_BerthArmyworm" } ] ) - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - KeyError Traceback ( most recent call last ) C : \Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro - py3\lib\site - packages\arcgis\gis\__init__ . py in __getattr__ ( self , name ) 6998 try : - > 6999 return dict . __getitem__ ( self , name ) 7000 except : KeyError : 'calculate' During handling of the above exception , another exception occurred : AttributeError Traceback ( most recent call last ) ipython - input -50 - 2608a815f7ee > in module > - - - - > 1 trap_count . calculate ( where = "fid > 0" , calc_expression = [ { "field" : "TotalArmyworms" , "sqlExpression" : "Nu_W_YellowStripedArmyworm + Nu_BerthArmyworm" } ] ) 2 C : \Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro - py3\lib\site - packages\arcgis\gis\__init__ . py in __getattr__ ( self , name ) 6999 return dict . __getitem__ ( self , name ) 7000 except : - > 7001 raise AttributeError ( "'%s' object has no attribute '%s'" % ( type ( self ) . __name__ , name ) ) 7002 7003 def __getitem__ ( self , k ) : # support item attributes as dictionary keys on this object AttributeError : 'Item' object has no attribute 'calculate' 1

Hi Natalie, I think you need to run calculate() on a feature layer, not the feature service. Try the code below: . calculate ( where = "fid > 0" , calc_expression = [ { "field" : "TotalArmyworms" , "sqlExpression" : "Nu_W_YellowStripedArmyworm + Nu_BerthArmyworm" } ] ) import arcgis import arcpy from arcgis . gis import GIS from arcgis import features from arcgis . features import FeatureLayer gis = GIS ( ' https://arcgis.com ' , 'xyz' , 'xyz' ) arcpy . env . overwriteOutput = True trap_count = gis . content . get ( "b6b9c68fa42b408a88c68aa9e18593d5" ) trap_count trap_count_lyr = trap_count.layers[0] # replace the 0 with the actual layer index trap_count_lyr -Josh

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; } } }

calculate function in python jupyter notebook

DryCreekEng

Hi everyone,

I am trying to create a script to run every night to calculate the total insects counted each day by summing two insect count fields in a feature layer. I can't use Arcade because the layer has "track changes" and "sync" enabled for the field crew (grrrr...). Below is my simple script to calculate the "TotalArmyworms" field based on summing the Western Yellow Armyworm field with the Bertha Armyworm field. I have tried many different ways to identify the layer from AGOL, and each time the error states that 'Item' object has no attribute 'calculate'. Any thoughts?

<SPAN class="keyword token">import</SPAN> arcgis
<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">from</SPAN> arcgis<SPAN class="punctuation token">.</SPAN>gis <SPAN class="keyword token">import</SPAN> GIS
<SPAN class="keyword token">from</SPAN> arcgis <SPAN class="keyword token">import</SPAN> features
<SPAN class="keyword token">from</SPAN> arcgis<SPAN class="punctuation token">.</SPAN>features <SPAN class="keyword token">import</SPAN> FeatureLayer

gis <SPAN class="operator token">=</SPAN> GIS<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'https://arcgis.com'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'xyz'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'xyz'</SPAN><SPAN class="punctuation token">)</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>

trap_count <SPAN class="operator token">=</SPAN> gis<SPAN class="punctuation token">.</SPAN>content<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"b6b9c68fa42b408a88c68aa9e18593d5"</SPAN><SPAN class="punctuation token">)</SPAN>
trap_count

trap_count<SPAN class="punctuation token">.</SPAN>calculate<SPAN class="punctuation token">(</SPAN>where<SPAN class="operator token">=</SPAN><SPAN class="string token">"fid > 0"</SPAN><SPAN class="punctuation token">,</SPAN> calc_expression<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">{</SPAN><SPAN class="string token">"field"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"TotalArmyworms"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"sqlExpression"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"Nu_W_YellowStripedArmyworm + Nu_BerthArmyworm"</SPAN> <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
   

<SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN>
KeyError                                  Traceback <SPAN class="punctuation token">(</SPAN>most recent call last<SPAN class="punctuation token">)</SPAN>
C<SPAN class="punctuation token">:</SPAN>\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro<SPAN class="operator token">-</SPAN>py3\lib\site<SPAN class="operator token">-</SPAN>packages\arcgis\gis\__init__<SPAN class="punctuation token">.</SPAN>py <SPAN class="keyword token">in</SPAN> __getattr__<SPAN class="punctuation token">(</SPAN>self<SPAN class="punctuation token">,</SPAN> name<SPAN class="punctuation token">)</SPAN>
   <SPAN class="number token">6998</SPAN>         <SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
<SPAN class="operator token">-</SPAN><SPAN class="operator token">></SPAN> <SPAN class="number token">6999</SPAN>             <SPAN class="keyword token">return</SPAN> dict<SPAN class="punctuation token">.</SPAN>__getitem__<SPAN class="punctuation token">(</SPAN>self<SPAN class="punctuation token">,</SPAN> name<SPAN class="punctuation token">)</SPAN>
   <SPAN class="number token">7000</SPAN>         <SPAN class="keyword token">except</SPAN><SPAN class="punctuation token">:</SPAN>

KeyError<SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'calculate'</SPAN>

During handling of the above exception<SPAN class="punctuation token">,</SPAN> another exception occurred<SPAN class="punctuation token">:</SPAN>

AttributeError                            Traceback <SPAN class="punctuation token">(</SPAN>most recent call last<SPAN class="punctuation token">)</SPAN>
<SPAN class="operator token"><</SPAN>ipython<SPAN class="operator token">-</SPAN>input<SPAN class="number token">-50</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">2608a815f7ee</SPAN><SPAN class="operator token">></SPAN> <SPAN class="keyword token">in</SPAN> <SPAN class="operator token"><</SPAN>module<SPAN class="operator token">></SPAN>
<SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">></SPAN> <SPAN class="number token">1</SPAN> trap_count<SPAN class="punctuation token">.</SPAN>calculate<SPAN class="punctuation token">(</SPAN>where<SPAN class="operator token">=</SPAN><SPAN class="string token">"fid > 0"</SPAN><SPAN class="punctuation token">,</SPAN> calc_expression<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">{</SPAN><SPAN class="string token">"field"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"TotalArmyworms"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"sqlExpression"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"Nu_W_YellowStripedArmyworm + Nu_BerthArmyworm"</SPAN> <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
      <SPAN class="number token">2</SPAN> 

C<SPAN class="punctuation token">:</SPAN>\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro<SPAN class="operator token">-</SPAN>py3\lib\site<SPAN class="operator token">-</SPAN>packages\arcgis\gis\__init__<SPAN class="punctuation token">.</SPAN>py <SPAN class="keyword token">in</SPAN> __getattr__<SPAN class="punctuation token">(</SPAN>self<SPAN class="punctuation token">,</SPAN> name<SPAN class="punctuation token">)</SPAN>
   <SPAN class="number token">6999</SPAN>             <SPAN class="keyword token">return</SPAN> dict<SPAN class="punctuation token">.</SPAN>__getitem__<SPAN class="punctuation token">(</SPAN>self<SPAN class="punctuation token">,</SPAN> name<SPAN class="punctuation token">)</SPAN>
   <SPAN class="number token">7000</SPAN>         <SPAN class="keyword token">except</SPAN><SPAN class="punctuation token">:</SPAN>
<SPAN class="operator token">-</SPAN><SPAN class="operator token">></SPAN> <SPAN class="number token">7001</SPAN>             <SPAN class="keyword token">raise</SPAN> AttributeError<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"'%s' object has no attribute '%s'"</SPAN> <SPAN class="operator token">%</SPAN> <SPAN class="punctuation token">(</SPAN>type<SPAN class="punctuation token">(</SPAN>self<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>__name__<SPAN class="punctuation token">,</SPAN> name<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
   <SPAN class="number token">7002</SPAN> 
   <SPAN class="number token">7003</SPAN>     <SPAN class="keyword token">def</SPAN> <SPAN class="token function">__getitem__</SPAN><SPAN class="punctuation token">(</SPAN>self<SPAN class="punctuation token">,</SPAN> k<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="comment token"># support item attributes as dictionary keys on this object</SPAN>

AttributeError<SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'Item'</SPAN> object has no attribute <SPAN class="string token">'calculate'</SPAN>

<SPAN class="number token">1</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>

Find more posts tagged with

Accepted answers

GeoJosh

Hi Natalie,

I think you need to run calculate() on a feature layer, not the feature service. Try the code below:

trap_count_lyr<SPAN class="">.</SPAN>calculate<SPAN class="">(</SPAN>where<SPAN class="">=</SPAN><SPAN class="">"fid > 0"</SPAN><SPAN class="">,</SPAN> calc_expression<SPAN class="">=</SPAN><SPAN class="">[</SPAN><SPAN class="">{</SPAN><SPAN class="">"field"</SPAN><SPAN class="">:</SPAN> <SPAN class="">"TotalArmyworms"</SPAN><SPAN class="">,</SPAN> <SPAN class="">"sqlExpression"</SPAN> <SPAN class="">:</SPAN> <SPAN class="">"Nu_W_YellowStripedArmyworm + Nu_BerthArmyworm"</SPAN> <SPAN class="">}</SPAN><SPAN class="">]</SPAN><SPAN class="">)</SPAN><CODE><SPAN class="">import</SPAN> arcgis
<SPAN class="">import</SPAN> arcpy
<SPAN class="">from</SPAN> arcgis<SPAN class="">.</SPAN>gis <SPAN class="">import</SPAN> GIS
<SPAN class="">from</SPAN> arcgis <SPAN class="">import</SPAN> features
<SPAN class="">from</SPAN> arcgis<SPAN class="">.</SPAN>features <SPAN class="">import</SPAN> FeatureLayer

gis <SPAN class="">=</SPAN> GIS<SPAN class="">(</SPAN><SPAN class=""><SPAN>'</SPAN><A href="https://community.esri.com/external-link.jspa?url=https%3A%2F%2Farcgis.com" target="_blank">https://arcgis.com</A><SPAN>'</SPAN></SPAN><SPAN class="">,</SPAN> <SPAN class="">'xyz'</SPAN><SPAN class="">,</SPAN> <SPAN class="">'xyz'</SPAN><SPAN class="">)</SPAN>
arcpy<SPAN class="">.</SPAN>env<SPAN class="">.</SPAN>overwriteOutput <SPAN class="">=</SPAN> <SPAN class="">True</SPAN>

trap_count <SPAN class="">=</SPAN> gis<SPAN class="">.</SPAN>content<SPAN class="">.</SPAN>get<SPAN class="">(</SPAN><SPAN class="">"b6b9c68fa42b408a88c68aa9e18593d5"</SPAN><SPAN class="">)</SPAN>
trap_count

trap_count_lyr = trap_count.layers[0] # replace the 0 with the actual layer index

-Josh

All comments

ahansford_LINZ

Hi @GeoJosh

I need to calculate a field (date) based on other fields (dates) using notebook to automate this.

I am currently doing this manually once a month using

Case  
When TA_is_Live is not null then TA_is_Live  
When Data_Live_and_Onboarding is not null then Data_Live_and_Onboarding  
When Signed_DSA_Returned is not null then Signed_DSA_Returned  
When Discussions_Demos_Underway is not null then Discussions_Demos_Underway 
When TA_Contacted is not null then TA_Contacted  
Else TA_Not_Interested 
End

Ideally I want the notebook to do this for me. Any assistance would be great.

Many thanks

Andrew (NZ)

erica_poisson

Hi Natalie & William,

I was able to accomplish my goal using the following:

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">import</SPAN> pandas <SPAN class="keyword token">as</SPAN> pd
<SPAN class="keyword token">from</SPAN> arcgis <SPAN class="keyword token">import</SPAN> features
<SPAN class="keyword token">from</SPAN> arcgis<SPAN class="punctuation token">.</SPAN>features <SPAN class="keyword token">import</SPAN> FeatureLayerCollection
<SPAN class="keyword token">from</SPAN> arcgis<SPAN class="punctuation token">.</SPAN>features <SPAN class="keyword token">import</SPAN> FeatureLayer
<SPAN class="keyword token">from</SPAN> arcgis<SPAN class="punctuation token">.</SPAN>gis <SPAN class="keyword token">import</SPAN> GIS

<SPAN class="comment token"># #### Run to process data:</SPAN>

gis <SPAN class="operator token">=</SPAN> GIS<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'https://arcgis.com/'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'xyz'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'xyz'</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># connect to feature layer and select proper table</SPAN>
item<SPAN class="operator token">=</SPAN>gis<SPAN class="punctuation token">.</SPAN>content<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'a550ded747db465eb2ff62153b559095'</SPAN><SPAN class="punctuation token">)</SPAN>
l<SPAN class="operator token">=</SPAN>item<SPAN class="punctuation token">.</SPAN>tables<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token"># need to deal with null Unknown_Number because Total_Gull_Count does not properly calculate if left null.</SPAN>
unknown<SPAN class="operator token">=</SPAN>l<SPAN class="punctuation token">.</SPAN>query<SPAN class="punctuation token">(</SPAN>where<SPAN class="operator token">=</SPAN><SPAN class="string token">"Unknown_Number IS NULL"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>sdf

<SPAN class="comment token"># calculate null Unknown_Numbers to be equal to 0.</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>l<SPAN class="punctuation token">.</SPAN>calculate<SPAN class="punctuation token">(</SPAN>where<SPAN class="operator token">=</SPAN><SPAN class="string token">"Unknown_Number IS NULL"</SPAN><SPAN class="punctuation token">,</SPAN>
                 calc_expression<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">{</SPAN><SPAN class="string token">"field"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"Unknown_Number"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"sqlExpression"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">'0'</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># calculate field Total Gull Count</SPAN>
<SPAN class="comment token"># select records where Total_Gull_Count is null, and then calculate value</SPAN>
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>l<SPAN class="punctuation token">.</SPAN>calculate<SPAN class="punctuation token">(</SPAN>where<SPAN class="operator token">=</SPAN><SPAN class="string token">"Total_Gull_Count IS NULL"</SPAN><SPAN class="punctuation token">,</SPAN>
                 calc_expression<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">{</SPAN><SPAN class="string token">"field"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"Total_Gull_Count"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"sqlExpression"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"RB_numb + HG_numb + BB_numb + Unknown_Number"</SPAN> <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>

DryCreekEng

Erica - would it be easier to create a new feature layer that just represents gull counts? That would ensure that when you call :

<SPAN style="color: #000000;">Site_Inspections_lyr </SPAN><SPAN class="" style="color: #a67f59; background: rgba(255, 255, 255, 0.5); border: 0px; font-weight: inherit;">=</SPAN><SPAN style="color: #000000;"> Site_Inspections</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">.</SPAN><SPAN style="color: #000000;">layers</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">[</SPAN><SPAN style="border: 0px; color: #990000; font-weight: inherit; ">0</SPAN><SPAN class="" style="color: #999999; border: 0px; font-weight: inherit;">]</SPAN>

it would pull from the correct table.

wwnde

For what you want to use the information I see no reason why this should not work. Output total can be input into the reports and even dashboard source files.

I cant quite resolve you error unless I see it. Are you able to print it?

erica_poisson

Hi William,

I am very new to this, so I need to look into the SEDF. My goal is to just calculate the "Total Gull Count" daily. The field already exists in the Feature Layer. The layer is edited daily in Collector and I need to tally the counts of different gull species into one total value. The "Total Gull Count" field will be used in maps and Dashboard charts/indicators. I don't want to have to re-publish the data each time; I'd like to leave it alone where it is in ArcGIS Online.

For the code sample you provided above, this still does not work when I change the layer index to 1 (this is where the "Total Gull Count" field lives - all of the values being added together also live here). I get the error "index is out of range". Does this not work with a hosted feature layer's related tables?

Thank you,

Erica

wwnde

Why cant you leverage the spatial enabled data frame? What do you want to do with the data. Visualize or republish?

<SPAN class="keyword token">import</SPAN> pandas <SPAN class="keyword token">as</SPAN> pd
<SPAN class="keyword token">from</SPAN> arcgis<SPAN class="punctuation token">.</SPAN>gis <SPAN class="keyword token">import</SPAN> GIS
<SPAN class="keyword token">from</SPAN> arcgis <SPAN class="keyword token">import</SPAN> features
<SPAN class="keyword token">from</SPAN> arcgis<SPAN class="punctuation token">.</SPAN>features <SPAN class="keyword token">import</SPAN> FeatureLayer

gis <SPAN class="operator token">=</SPAN> GIS<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'https://arcgis.com'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'xyz'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'xyz'</SPAN><SPAN class="punctuation token">)</SPAN>

item<SPAN class="operator token">=</SPAN>gis<SPAN class="punctuation token">.</SPAN>content<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'511646881336491988ab0b87817343ad'</SPAN><SPAN class="punctuation token">)</SPAN>
l<SPAN class="operator token">=</SPAN>item<SPAN class="punctuation token">.</SPAN>layers<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> 
df<SPAN class="operator token">=</SPAN>l<SPAN class="punctuation token">.</SPAN>query<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>sdf
<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>df<SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token">#df will be output as a table</SPAN>

<SPAN class="comment token">#Say you need;Total_Gull_Count</SPAN>
df<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Total_Gull_Count'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="operator token">=</SPAN> df<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'RB_numb'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="operator token">+</SPAN>df<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'HG_numb'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="operator token">+</SPAN> df<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'BB_numb'</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> df<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Unknown_Number'</SPAN><SPAN class="punctuation token">]</SPAN>
‍‍‍‍‍‍‍‍‍‍
That will add new column<SPAN class="punctuation token">.</SPAN> Can both be visualized <SPAN class="operator token">or</SPAN> republished on portal<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>

erica_poisson

Hi Josh,

I am hoping you might be able to help me out...I am trying to re-purpose the code above to calculate a field in a feature layer that has sync enabled. I am trying to do this in a Notebook in ArcGIS Online. Here is what my code looks like..

<SPAN class="keyword token">from</SPAN> arcgis<SPAN class="punctuation token">.</SPAN>gis <SPAN class="keyword token">import</SPAN> GIS
<SPAN class="keyword token">from</SPAN> arcgis <SPAN class="keyword token">import</SPAN> features
<SPAN class="keyword token">from</SPAN> arcgis<SPAN class="punctuation token">.</SPAN>features <SPAN class="keyword token">import</SPAN> FeatureLayer
gis <SPAN class="operator token">=</SPAN> GIS<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"home"</SPAN><SPAN class="punctuation token">)</SPAN>

gis <SPAN class="operator token">=</SPAN> GIS<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'https://arcgis.com'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'xyz'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'xyz'</SPAN><SPAN class="punctuation token">)</SPAN>

Site_Inspections <SPAN class="operator token">=</SPAN> gis<SPAN class="punctuation token">.</SPAN>content<SPAN class="punctuation token">.</SPAN>get<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"511646881336491988ab0b87817343ad"</SPAN><SPAN class="punctuation token">)</SPAN>
Site_Inspections

Site_Inspections_lyr <SPAN class="operator token">=</SPAN> Site_Inspections<SPAN class="punctuation token">.</SPAN>layers<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>

Site_Inspections_lyr<SPAN class="punctuation token">.</SPAN>calculate<SPAN class="punctuation token">(</SPAN>where<SPAN class="operator token">=</SPAN><SPAN class="string token">"OBJECTID > 0"</SPAN><SPAN class="punctuation token">,</SPAN> calc_expression<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">{</SPAN><SPAN class="string token">"field"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"Total_Gull_Count"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"sqlExpression"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"RB_numb + HG_numb + BB_numb + Unknown_Number"</SPAN> <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>

I keep getting the following error:

<SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN>
IndexError                                Traceback <SPAN class="punctuation token">(</SPAN>most recent call last<SPAN class="punctuation token">)</SPAN>
<SPAN class="operator token"><</SPAN>ipython<SPAN class="operator token">-</SPAN>input<SPAN class="number token">-12</SPAN><SPAN class="operator token">-</SPAN>b67e0c1245fc<SPAN class="operator token">></SPAN> <SPAN class="keyword token">in</SPAN> <SPAN class="operator token"><</SPAN>module<SPAN class="operator token">></SPAN>
<SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">-</SPAN><SPAN class="operator token">></SPAN> <SPAN class="number token">1</SPAN> Total_Gull_Count_lyr <SPAN class="operator token">=</SPAN> Total_Gull_Count<SPAN class="punctuation token">.</SPAN>layers<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
      <SPAN class="number token">2</SPAN> 
      <SPAN class="number token">3</SPAN> Total_Gull_Count_lyr<SPAN class="punctuation token">.</SPAN>calculate<SPAN class="punctuation token">(</SPAN>where<SPAN class="operator token">=</SPAN><SPAN class="string token">"OBJECTID > 0"</SPAN><SPAN class="punctuation token">,</SPAN> calc_expression<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">{</SPAN><SPAN class="string token">"field"</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"Total_Gull_Count"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"sqlExpression"</SPAN> <SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"RB_numb + HG_numb + BB_numb + Unknown_Number"</SPAN> <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

IndexError<SPAN class="punctuation token">:</SPAN> list index out of range

‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<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>

I've triple checked my feature service, and the layer I am attempting to do this calculate on is index 1. Does it matter that this is a table?

Do you have any suggestions that could help out here? My goal is to schedule this to run daily to update the "Total_Gull_Count" field within my table.

Thank you,

Erica

DryCreekEng

Thanks Josh for the answer. I tried something similar with specifying the layer (trap_count.layers[0]) from using a search to find the service layer (gis.content.search) and it didnt work. Im glad it was an easy fix!

GeoJosh

Hi Natalie,

I think you need to run calculate() on a feature layer, not the feature service. Try the code below:

trap_count_lyr<SPAN class="">.</SPAN>calculate<SPAN class="">(</SPAN>where<SPAN class="">=</SPAN><SPAN class="">"fid > 0"</SPAN><SPAN class="">,</SPAN> calc_expression<SPAN class="">=</SPAN><SPAN class="">[</SPAN><SPAN class="">{</SPAN><SPAN class="">"field"</SPAN><SPAN class="">:</SPAN> <SPAN class="">"TotalArmyworms"</SPAN><SPAN class="">,</SPAN> <SPAN class="">"sqlExpression"</SPAN> <SPAN class="">:</SPAN> <SPAN class="">"Nu_W_YellowStripedArmyworm + Nu_BerthArmyworm"</SPAN> <SPAN class="">}</SPAN><SPAN class="">]</SPAN><SPAN class="">)</SPAN><CODE><SPAN class="">import</SPAN> arcgis
<SPAN class="">import</SPAN> arcpy
<SPAN class="">from</SPAN> arcgis<SPAN class="">.</SPAN>gis <SPAN class="">import</SPAN> GIS
<SPAN class="">from</SPAN> arcgis <SPAN class="">import</SPAN> features
<SPAN class="">from</SPAN> arcgis<SPAN class="">.</SPAN>features <SPAN class="">import</SPAN> FeatureLayer

gis <SPAN class="">=</SPAN> GIS<SPAN class="">(</SPAN><SPAN class=""><SPAN>'</SPAN><A href="https://community.esri.com/external-link.jspa?url=https%3A%2F%2Farcgis.com" target="_blank">https://arcgis.com</A><SPAN>'</SPAN></SPAN><SPAN class="">,</SPAN> <SPAN class="">'xyz'</SPAN><SPAN class="">,</SPAN> <SPAN class="">'xyz'</SPAN><SPAN class="">)</SPAN>
arcpy<SPAN class="">.</SPAN>env<SPAN class="">.</SPAN>overwriteOutput <SPAN class="">=</SPAN> <SPAN class="">True</SPAN>

trap_count <SPAN class="">=</SPAN> gis<SPAN class="">.</SPAN>content<SPAN class="">.</SPAN>get<SPAN class="">(</SPAN><SPAN class="">"b6b9c68fa42b408a88c68aa9e18593d5"</SPAN><SPAN class="">)</SPAN>
trap_count

trap_count_lyr = trap_count.layers[0] # replace the 0 with the actual layer index

-Josh

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.