Editing Features

The ArcGIS API for Python makes programmatic editing of features a breeze. The edit_features() method on FeatureLayer object can be used for the same. In the example below, we see how to add, update and delete features from a point feature layer

#connect to GIS
from arcgis.gis import GIS
from IPython.display import display
gis = GIS("portal url", 'username', 'password')
#search for the feature layer named Ports along west coast
portal_item = gis.content.get('6a8766e14d3d41cfb8fc8d4d8974f16d')
portal_item
Ports in the Western US
Subset of ports data based on US Department of Transportation.Feature Layer Collection by api_data_owner
Last Modified: August 20, 2018
0 comments, 26 views
#access the item's feature layers
ports_layer = portal_item.layers[0]
ports_layer
<FeatureLayer url:"https://pythonapi.playground.esri.com/server/rest/services/Hosted/Ports_in_the_Western_US/FeatureServer/0">

Query the features

Let us query the features on this layer

#query all the features and display it on a map
ports_fset = ports_layer.query() #an empty query string will return all 
                                        #the features or the first 1000 which ever is smaller

The sdf property of FeatureSet class is a powerful way to visualize all the features as a pandas dataframe table.

ports_fset.sdf
objectidcountryglobalidharborsizelabel_positionlatitudelongitudeport_nameshort_formgeometry_xgeometry_yglobalid_1SHAPE
01US{14FB62C9-1CEA-4F12-ACA4-14BB72F042BF}LSW37.816667-122.416667SAN FRANCISCOSFFO-136273604553559{9D3F40A8-C4C5-4C59-A82C-3C3B19373671}{"x": -13627361.035, "y": 4553559.283399999, "...
12US{6EE30C76-399D-42F5-B6ED-403C94DFFCD4}SSW37.783333-122.266667ALAMEDANGZ-136106604548863{6FD08053-6335-474A-B976-6D42A9D1D528}{"x": -13610663.1114, "y": 4548863.0858, "spat...
23US{A6A21CC3-DE52-4B8A-A5B2-1CAA726E7F02}LSW37.816667-122.333333OAKLANDOAK-1361808045535590{E44E1348-822A-413B-9FFE-7C49CF527027}{"x": -13618084.3366, "y": 4553559.283399999, ...
34US{265AD7A6-4F59-4181-88DE-194F23F64E92}SSW37.916667-122.366667POINT RICHMONDRIC-136218004567660{030877E0-580F-46D2-A2A7-66ECDD6B9093}{"x": -13621795.0605, "y": 4567660.334200002, ...
45US{B15D545F-83DD-4D3E-9051-6D9F290A8E9E}SSW38.100000-122.266667MARE ISLANDNone-136106604593562{20B9B1A1-E243-4C82-8158-CA11A93B38C8}{"x": -13610663.1114, "y": 4593562.1065, "spat...
56US{A97E8B59-1E25-416E-9206-4B59A869E2F4}SSW38.083333-122.250000SOUTH VALLEJONone-136088104591205{A18751ED-E493-44C3-A684-602488346594}{"x": -13608807.749499999, "y": 4591204.668700...
67US{8EB57C5B-100B-4C50-B6B1-4D6B9B1C7545}SSW37.950000-121.300000STOCKTONSCK-135030504572365{A2688CB5-CDFB-4A8A-B76F-F0AB0D1FCAAC}{"x": -13503054.233199999, "y": 4572364.8957, ...
78US{3B7B126E-0B60-49AF-89AA-4AC05402CFEA}SSW38.583333-121.500000SACRAMENTOSMF-135253204662162{A86D6850-70B8-43B6-BB66-73B5E4D46C48}{"x": -13525318.1314, "y": 4662162.127899997, ...
89US{20378B4B-3E9E-47D2-AF42-4F0A31D5CA66}SSW40.800000-124.183333EUREKAACV-138240304982886{A01048CF-CE39-44FE-AF40-B3F792D2DE9E}{"x": -13824025.3946, "y": 4982886.316600002, ...
910US{782C11E0-B02D-45AB-8BAD-97C1B5817812}MSW43.400000-124.283333EMPIRENone-138351605373055{7B19D43F-DD50-48C6-BBD3-01930B3605A4}{"x": -13835157.3437, "y": 5373055.471900001, ...
1011US{888593DC-D385-4A7C-A1F0-C9D46AB91353}SSW43.366667-124.216667COOS BAYNone-138277405367950{B63F5915-F764-46A1-BA81-1209BDEA3438}{"x": -13827736.1185, "y": 5367949.881800003, ...
1112US{A04935D7-314D-43D3-AA39-99E91FE93BD5}MSW32.716667-117.183333SAN DIEGOSAN-130447903857756{A325CED6-0C85-46D3-9524-B0E253ECFBFA}{"x": -13044788.958999999, "y": 3857756.351199...
1213US{45CCFAFA-CE13-4EEE-907A-5C53A486C434}MSW33.766667-118.183333LONG BEACHLGH-131561103997514{A904E129-30BE-41C5-B0F6-ABB5C8521FE7}{"x": -13156108.4498, "y": 3997513.9714, "spat...
1314US{ECA58B5E-ADBB-4392-A6F2-1F5476E69375}SSW36.616667-121.883333MONTEREYMRY-135679904385809{63CEB887-33E7-46AF-8710-9DDD4E2F3C19}{"x": -13567990.5657, "y": 4385808.953900002, ...
1415US{9B472045-E648-4371-906A-FCC35A7CB0B1}LSW45.516667-122.666667PORTLANDNone-136551905703230{9A803AB5-5EB9-4BA2-AA17-CB708E3CD92C}{"x": -13655190.9077, "y": 5703230.203000002, ...
1516US{B8AC37F8-5AA6-4D27-A401-7B35A8E4B9D3}SSW21.950000-159.350000NAWILIWILI BAYNone-177387602505523{0C4B2263-59C7-463B-AF9C-284C07B8DFB0}{"x": -17738760.8579, "y": 2505523.1952, "spat...
1617US{6D718925-1CF2-4A45-9E3D-B4FBE215BA71}SSW21.900000-159.583333PORT ALLENNone-177647402499523{59634BC9-1CDE-4F56-84F1-0C29C6787169}{"x": -17764735.3687, "y": 2499523.2661000006,...
1718US{50ECBCE3-137E-45BF-A42E-F0D423434067}MSW21.300000-157.866667HONOLULUHNL-175736402427687{A9E9A7A1-4D5E-42C7-9F53-D09C3E04D441}{"x": -17573636.9837, "y": 2427686.5436000004,...
1819US{9168C51F-28FF-4885-AFD5-18A1607E3808}SSW20.033333-155.833333KAWAIHAENone-173472902276980{7E86F7D7-4E2E-43BC-893A-09D0F1E78092}{"x": -17347287.2782, "y": 2276980.0967999995,...
1920US{A2A35C01-C1D4-4FD0-B74E-424E1A9DE20F}MSW19.733333-155.066667HILOITO-172619402241467{1F6FCB1A-7F2D-4DC9-9571-05E685D2A66A}{"x": -17261942.4095, "y": 2241467.1730999984,...
2021US{BC904585-28E5-4995-9F6F-BCBDEE4D00C2}MSW45.633333-122.683333VANCOUVERNone-136570505721784{57CDFEA4-FA11-41C4-8A69-943C5114CDC0}{"x": -13657046.1584, "y": 5721784.0173999965,...
2122US{8AFA0145-A107-4031-B05B-1D09550E9D88}SSW34.055600-117.182000REDLANDSNone-130446404036270{0CD089EE-1465-4055-BD3B-6566759D2F1F}{"x": -13044640.5701, "y": 4036270.1933000013,...

Check if the layer can be edited

To enable a feature layer to be edited, the edit capability needs to be turned on for the item. This can be verified by accessing the capabilities property on the FeatureLayer object:

ports_layer.properties.capabilities
'Query,Sync,Extract'

Editing features

Updating features

From the dataframe above, we notice the short_form field of San Francisco port has a typo. We can update this by calling the edit_features() method on the ports_flayer FeatureLayer object. The edit_features() method accepts a Feature object with correct parameters set.

ports_features = ports_fset.features

# select San Francisco feature
sfo_feature = [f for f in ports_features if f.attributes['port_name']=='SAN FRANCISCO'][0]
sfo_feature.attributes
{'objectid': 1,
 'country': 'US',
 'globalid': '{14FB62C9-1CEA-4F12-ACA4-14BB72F042BF}',
 'harborsize': 'L',
 'label_position': 'SW',
 'latitude': 37.816667,
 'longitude': -122.416667,
 'port_name': 'SAN FRANCISCO',
 'short_form': 'SFFO',
 'geometry_x': -13627360,
 'geometry_y': 4553559,
 'globalid_1': '{9D3F40A8-C4C5-4C59-A82C-3C3B19373671}',
 'SHAPE': {'x': -13627361.035,
  'y': 4553559.283399999,
  'spatialReference': {'wkid': 102100, 'latestWkid': 3857}}}

As we can see above, the short_form attribute should be changed to SFO. Let us edit that and store it as a new Feature object

sfo_edit = sfo_feature
sfo_edit.attributes['short_form'] = 'SFO'
display(sfo_edit)
{"geometry": {"x": -13627361.035, "y": 4553559.283399999, "spatialReference": {"wkid": 102100, "latestWkid": 3857}}, "attributes": {"objectid": 1, "country": "US", "globalid": "{14FB62C9-1CEA-4F12-ACA4-14BB72F042BF}", "harborsize": "L", "label_position": "SW", "latitude": 37.816667, "longitude": -122.416667, "port_name": "SAN FRANCISCO", "short_form": "SFO", "geometry_x": -13627360, "geometry_y": 4553559, "globalid_1": "{9D3F40A8-C4C5-4C59-A82C-3C3B19373671}", "SHAPE": {"x": -13627361.035, "y": 4553559.283399999, "spatialReference": {"wkid": 102100, "latestWkid": 3857}}}}

Now let us send this feature object to the edit_features() method and edit the original feature layer

update_result = ports_flayer.edit_features(updates=[sfo_edit])
update_result
{'addResults': [],
 'updateResults': [{'objectId': 1,
   'globalId': '{9D3F40A8-C4C5-4C59-A82C-3C3B19373671}',
   'success': True}],
 'deleteResults': [],
 'attachments': {'addResults': [], 'updateResults': [], 'deleteResults': []}}

Adding features

From the data frame, we also notice that 'Los Angeles', an important port is missing. We can add this to the original layer by calling the edit_features() method and passing a dictionary representation of the feature

# construct a Feature object for Los Angeles.
la_dict = {"attributes": 
           {"latitude": 33.75,
            "longitude": -118.25,
            "country": "US",
            "harborsize": "L",
            "label_position": "SW",
            "port_name": "LOS ANGELES",
            "short_form": "LAX"}, 
           "geometry": 
           {"x": -13044788.958999995, "y": 3857756.351200014}}
add_result = ports_flayer.edit_features(adds = [la_dict])
add_result
{'addResults': [{'objectId': 23,
   'globalId': '{F5FCFF4C-ED2F-4C72-80EF-B414EF4C8C5B}',
   'success': True}],
 'updateResults': [],
 'deleteResults': [],
 'attachments': {'addResults': [], 'updateResults': [], 'deleteResults': []}}

Deleting features

From the data frame, we notice 'Redlands', a land locked city is wrongly added as a port. We can remove it by calling the edit_features() method and passing the object id of the feature we want to be remove to the deletes parameter.

# find object id for Redlands
Redlands_feature = [f for f in ports_features if f.attributes['port_name'] == 'REDLANDS'][0]
Redlands_objid = Redlands_feature.get_value('objectid')
Redlands_objid
22
type(Redlands_objid)
int
# pass the object id as a string to the delete parameter
delete_result = ports_flayer.edit_features(deletes=str(Redlands_objid))
delete_result
{'addResults': [],
 'updateResults': [],
 'deleteResults': [{'objectId': 22, 'globalId': None, 'success': True}],
 'attachments': {'addResults': [], 'updateResults': [], 'deleteResults': []}}

Check results of edit operations

We have successfully added, removed and edited features. Let us query the layer once again and display the resutls as a dataframe and verify them.

ports_fset_edited = ports_flayer.query()
ports_fset_edited.sdf
objectidcountryglobalidharborsizelabel_positionlatitudelongitudeport_nameshort_formgeometry_xgeometry_yglobalid_1SHAPE
01US{14FB62C9-1CEA-4F12-ACA4-14BB72F042BF}LSW37.816667-122.416667SAN FRANCISCOSFO-13627360.04553559.0{9D3F40A8-C4C5-4C59-A82C-3C3B19373671}{"x": -13627361.035, "y": 4553559.283399999, "...
12US{6EE30C76-399D-42F5-B6ED-403C94DFFCD4}SSW37.783333-122.266667ALAMEDANGZ-13610660.04548863.0{6FD08053-6335-474A-B976-6D42A9D1D528}{"x": -13610663.1114, "y": 4548863.0858, "spat...
23US{A6A21CC3-DE52-4B8A-A5B2-1CAA726E7F02}LSW37.816667-122.333333OAKLANDOAK-13618080.045535590.0{E44E1348-822A-413B-9FFE-7C49CF527027}{"x": -13618084.3366, "y": 4553559.283399999, ...
34US{265AD7A6-4F59-4181-88DE-194F23F64E92}SSW37.916667-122.366667POINT RICHMONDRIC-13621800.04567660.0{030877E0-580F-46D2-A2A7-66ECDD6B9093}{"x": -13621795.0605, "y": 4567660.334200002, ...
45US{B15D545F-83DD-4D3E-9051-6D9F290A8E9E}SSW38.100000-122.266667MARE ISLANDNone-13610660.04593562.0{20B9B1A1-E243-4C82-8158-CA11A93B38C8}{"x": -13610663.1114, "y": 4593562.1065, "spat...
56US{A97E8B59-1E25-416E-9206-4B59A869E2F4}SSW38.083333-122.250000SOUTH VALLEJONone-13608810.04591205.0{A18751ED-E493-44C3-A684-602488346594}{"x": -13608807.749499999, "y": 4591204.668700...
67US{8EB57C5B-100B-4C50-B6B1-4D6B9B1C7545}SSW37.950000-121.300000STOCKTONSCK-13503050.04572365.0{A2688CB5-CDFB-4A8A-B76F-F0AB0D1FCAAC}{"x": -13503054.233199999, "y": 4572364.8957, ...
78US{3B7B126E-0B60-49AF-89AA-4AC05402CFEA}SSW38.583333-121.500000SACRAMENTOSMF-13525320.04662162.0{A86D6850-70B8-43B6-BB66-73B5E4D46C48}{"x": -13525318.1314, "y": 4662162.127899997, ...
89US{20378B4B-3E9E-47D2-AF42-4F0A31D5CA66}SSW40.800000-124.183333EUREKAACV-13824030.04982886.0{A01048CF-CE39-44FE-AF40-B3F792D2DE9E}{"x": -13824025.3946, "y": 4982886.316600002, ...
910US{782C11E0-B02D-45AB-8BAD-97C1B5817812}MSW43.400000-124.283333EMPIRENone-13835160.05373055.0{7B19D43F-DD50-48C6-BBD3-01930B3605A4}{"x": -13835157.3437, "y": 5373055.471900001, ...
1011US{888593DC-D385-4A7C-A1F0-C9D46AB91353}SSW43.366667-124.216667COOS BAYNone-13827740.05367950.0{B63F5915-F764-46A1-BA81-1209BDEA3438}{"x": -13827736.1185, "y": 5367949.881800003, ...
1112US{A04935D7-314D-43D3-AA39-99E91FE93BD5}MSW32.716667-117.183333SAN DIEGOSAN-13044790.03857756.0{A325CED6-0C85-46D3-9524-B0E253ECFBFA}{"x": -13044788.958999999, "y": 3857756.351199...
1213US{45CCFAFA-CE13-4EEE-907A-5C53A486C434}MSW33.766667-118.183333LONG BEACHLGH-13156110.03997514.0{A904E129-30BE-41C5-B0F6-ABB5C8521FE7}{"x": -13156108.4498, "y": 3997513.9714, "spat...
1314US{ECA58B5E-ADBB-4392-A6F2-1F5476E69375}SSW36.616667-121.883333MONTEREYMRY-13567990.04385809.0{63CEB887-33E7-46AF-8710-9DDD4E2F3C19}{"x": -13567990.5657, "y": 4385808.953900002, ...
1415US{9B472045-E648-4371-906A-FCC35A7CB0B1}LSW45.516667-122.666667PORTLANDNone-13655190.05703230.0{9A803AB5-5EB9-4BA2-AA17-CB708E3CD92C}{"x": -13655190.9077, "y": 5703230.203000002, ...
1516US{B8AC37F8-5AA6-4D27-A401-7B35A8E4B9D3}SSW21.950000-159.350000NAWILIWILI BAYNone-17738760.02505523.0{0C4B2263-59C7-463B-AF9C-284C07B8DFB0}{"x": -17738760.8579, "y": 2505523.1952, "spat...
1617US{6D718925-1CF2-4A45-9E3D-B4FBE215BA71}SSW21.900000-159.583333PORT ALLENNone-17764740.02499523.0{59634BC9-1CDE-4F56-84F1-0C29C6787169}{"x": -17764735.3687, "y": 2499523.2661000006,...
1718US{50ECBCE3-137E-45BF-A42E-F0D423434067}MSW21.300000-157.866667HONOLULUHNL-17573640.02427687.0{A9E9A7A1-4D5E-42C7-9F53-D09C3E04D441}{"x": -17573636.9837, "y": 2427686.5436000004,...
1819US{9168C51F-28FF-4885-AFD5-18A1607E3808}SSW20.033333-155.833333KAWAIHAENone-17347290.02276980.0{7E86F7D7-4E2E-43BC-893A-09D0F1E78092}{"x": -17347287.2782, "y": 2276980.0967999995,...
1920US{A2A35C01-C1D4-4FD0-B74E-424E1A9DE20F}MSW19.733333-155.066667HILOITO-17261940.02241467.0{1F6FCB1A-7F2D-4DC9-9571-05E685D2A66A}{"x": -17261942.4095, "y": 2241467.1730999984,...
2021US{BC904585-28E5-4995-9F6F-BCBDEE4D00C2}MSW45.633333-122.683333VANCOUVERNone-13657050.05721784.0{57CDFEA4-FA11-41C4-8A69-943C5114CDC0}{"x": -13657046.1584, "y": 5721784.0173999965,...
2123USNoneLSW33.750000-118.250000LOS ANGELESLAXNaNNaN{F5FCFF4C-ED2F-4C72-80EF-B414EF4C8C5B}{"x": -13044788.958999999, "y": 3857756.351199...

Thus, we no longer see 'Redlands' which we deleted. We see a new objectid of 23 corresponding to Los Angeles that we added. Also the short_form of San Francisco is corrected to 'SFO'.

The edits we performed on the features are persisted in the feature layer and will reflect in all clients accessing it.

Your browser is no longer supported. Please upgrade your browser for the best experience. See our browser deprecation post for more details.