Updating a hosted feature layer data table

897
1
08-06-2020 02:36 AM
Dunn_Jeremy
New Contributor III

Good Morning

I have a hosted feature layer that has several points and associated lat/lons. One of the points is in the wrong location. So I went into the "Data" table and updated the lat/lons manually. However when I "visualise" the layer with the new lat/lon it is still in the same place. 

Why has the layer not inherited the lat/lon update ? And put the point in the correct position. 

Regards. 

Jeremy. 

1 Reply
Stephanie_F
Esri Contributor

Hi Jeremy, 

When a hosted feature layer is created, the geometry and attribute values are separate as ArcGIS Online assigns XY values to points. So when you updated the attribute table, the geometry was not also updated. A possible workflow that can be used to update geometry with a specified Lat/Long is below.

  1. Export and download the data as a CSV
  2. Open the downloaded CSV-- your Lat/Long columns should be correct because you edited the attribute table, look for X and Y columns which reflect the geometry 
  3. Update Y to match Latitude and X to match Longitude and save the CSV
  4. Navigate to your hosted feature layer in ArcGIS Online>>Overview tab
  5. Update Data>>Append data to layer
  6. Select your CSV
  7. Match the identifying field
  8. Make sure 'Update existing features' and 'Update geometry for existing features' are checked and apply the update

Hope this helps!

-Stephanie