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

Update Field Values

kapalczynski

I have a question...I am trying to update a specific field with the code below. I want to query all the data and change a field named "FLAGFIELD" to YES

I can get at the Portal ID for the Service and point to the correct table and set the proper JSON payload...

But I am missing where I am querying or selecting with a where clause of 1=1

Can anyone help with this part? How do I "Change ALL records to YES in the field FLAGFIELD"

Thanks

    gis = GIS("https://xyz", "xyz", "xyz")
    #currenttoken = gis._con.token
    portal_item = gis.content.get('b373b127exxxxxxxxxx0dfb14a1')
    ports_layer = portal_item.tables[0]

    # We need to reconstruct json features to be updated
    FLAGFIELDvalue = 'YES'

    # construct json
    add_data = {
          "attributes" : {
            "FLAGFIELD" : FLAGFIELDvalue, 
          }
        }
    # Push updates
    add_updates = ports_layer.edit_features(updates = [add_data])

Find more posts tagged with

Accepted answers

jskinner

Hi @kapalczynski ,

An easier approach may be to use arcpy. Ex:

# Variables
portalURL = 'https://gis.esri.com/portal'
username = 'portaladmin'
password = 'p0rt@l@dmin1'
featureServiceURL = 'https://gis.esri.com/server/rest/services/pipes/FeatureServer/0'

# Sign into Portal
arcpy.SignInToPortal(portalURL, username, password)

# Calculate Field
arcpy.management.CalculateField(
    in_table=featureServiceURL,
    field="FLAGFIELD",
    expression="'YES'",
    expression_type="PYTHON3",
    code_block="",
    field_type="TEXT",
    enforce_domains="NO_ENFORCE_DOMAINS"
)

All comments

kapalczynski

@JakeSkinner

So create a layer from the inputFeatureLayer where the field "Imported = No" and dump the results into an InMemory Layer

From there I need to query the InMemory layer (r"memory\importedRecords") and append that to the main Feature...

Something like this

    inputFeatureLayer = r'https://gggg.gov/hosting/rest/services/Hosted/Public_DEV_View/FeatureServer/0'
    outputFeatureLayer = r'https://gggg.gov/hosting/rest/services/Hosted/Public_/FeatureServer/0'
    whereClause = "Imported = 'No'"
    arcpy.MakeFeatureLayer_management(inputFeatureLayer, r"memory\importedRecords", whereClause )
    arcpy.management.Append(r"memory\importedRecords"], outputFeatureLayer, "TEST_AND_SKIP")

jskinner

I tend to stick to arcpy when the functionality is available in both arcpy and ArcGIS API for Python. It minimizes the code you will have to write.

For the WHERE clause, you can first create a Feature Layer using the Make Feature Layer tool.

kapalczynski

@JakeSkinner How could I add a WHERE clause to that ... so update the field value only when xyz

kapalczynski

@JakeSkinner thanks... that is way easier... not sure when to use one or the other... still a bit confused there

jskinner

Hi @kapalczynski ,

An easier approach may be to use arcpy. Ex:

# Variables
portalURL = 'https://gis.esri.com/portal'
username = 'portaladmin'
password = 'p0rt@l@dmin1'
featureServiceURL = 'https://gis.esri.com/server/rest/services/pipes/FeatureServer/0'

# Sign into Portal
arcpy.SignInToPortal(portalURL, username, password)

# Calculate Field
arcpy.management.CalculateField(
    in_table=featureServiceURL,
    field="FLAGFIELD",
    expression="'YES'",
    expression_type="PYTHON3",
    code_block="",
    field_type="TEXT",
    enforce_domains="NO_ENFORCE_DOMAINS"
)

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.