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

Can I use cursors in a geoprocessing service?

WilsonIonara

Can I use cursors (search, insert and update cursors) in a geoprocessing service that is going to be used in a web app? Thanks

Vind meer berichten getagd met

Accepted answers

WilsonIonara

A note on the last note: If use arcpy.GeParameterAsText() it works in arcmap but not when running the gp, because apparently a parameter cannot have a feature class as an input (go figure!), so if you use arcpy.GetParameterAsText() and then have that parameter as a featureset (which I needed for my gp) it won't work in the gp. What I did was to create a variable for that parameter and when I run it inside ArcMap I grab the layer for that feature class (in my case the layer is referencing a feature class in a sde geodatabase). Then I publish the gp, then when I run the geoprocessing service I can grab the file directly from the connection instead of the layer. I hope it will help somebody because it took me a while to figure this out.

 Input_Polygons = "Stewardship"    with arcpy.da.UpdateCursor(Input_Polygons, ("DateStart", "PlanID", "FFY")) as rows:      for row in rows:          if not (row[1] or "").strip(): #covers blank, one blank space, or Null             Datestarstr1 = row[0]             Datestarstr2 = str(Datestarstr1)                      yearonly = Datestarstr2[0:4]                               row[2] = yearonly              rows.updateRow(row)

All comments

DanielSmith

Can I use cursors (search, insert and update cursors) in a geoprocessing service that is going to be used in a web app? Thanks

Any answer to this? Currently working with an update cursor in a python script. Script runs fine stand alone and as a geoprocessing tool. Service says it finishes w/o errors but the table is not updated.

many thanks

BrittanyBurson_1-1625781852737.png

Capture.PNG

WilsonIonara

Yes, we can use all the cursors, the problem is usually with the data input. Here is something that works for me. For the inputs (the inputpolygons) make sure you create a python toolbox parameter as a feature set. To make the update occur in the geoprocessing service, make sure when you run the tool in ArcMap that you select the inputs from their actual files (their databases), not the layers in your map. It took a while for me to figure out this. Of course, make sure the arcgisserver can access the data before through the data store. Good luck!

# Import arcpy module
import os, sys, arcpy, traceback, arcgisscripting

Input_Polygons = "Stewardship"

with arcpy.da.UpdateCursor(Input_Polygons, ("DateStart", "PlanID", "FFY")) as rows:


    for row in rows:

        if not (row[1] or "").strip(): #covers blank, one blank space, or Null
           Datestarstr1 = row[0]

           Datestarstr2 = str(Datestarstr1)


           yearonly = Datestarstr2[0:4]


           row[2] = yearonly

           rows.updateRow(row)

DanielSmith

thank you very much. i will test this now. The data will be local to the user so we'll see how this shakes out soon.

WilsonIonara

No problem. Make sure you check the logs in the manager also. It can give you a clue about the problem.

WilsonIonara

Just a note:

When I started adding more feature class, things stopped working, so I changed this

Input_Polygons = "Stewardship"
Counties = "Counties"

to

Input_Polygons = arcpy.GetParameterAsText(0)
Counties = arcpy.GetParameterAsText(1)

And Everything is working again!

WilsonIonara

 Input_Polygons = "Stewardship"    with arcpy.da.UpdateCursor(Input_Polygons, ("DateStart", "PlanID", "FFY")) as rows:      for row in rows:          if not (row[1] or "").strip(): #covers blank, one blank space, or Null             Datestarstr1 = row[0]             Datestarstr2 = str(Datestarstr1)                      yearonly = Datestarstr2[0:4]                               row[2] = yearonly              rows.updateRow(row)

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

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