by
2 Solutions
Hi @LisaT,
I don't know how comfortable you are with coding but it is quite simple to achieve with the ArcGIS Api for Python and it is all free.
This is how you do it
Upload your CSV the first time to create the service
in the new service get the url displayed at the bottom of the page
add /0 if there is only one layer in the service
Here is the code that you need if you run this in ArcGIS Pro not setup is required
from arcgis.gis import GIS
from arcgis.features import Feature
from arcgis.geometry import Point
from arcgis.features import FeatureLayer
"""
# Read the CSV and build the rows to append
"""
rows_to_append = []
# Read the csv and build the rows to append
with open('upload_data.csv', 'r') as read_file: # path should be full if the csv is not in the same folder c:/mypath/upload_data.csv
lines = read_file.readlines()
heading = True
for line in lines:
line = line.strip('\n')
if heading is True:
print(line) #heading
heading = False
continue
print(line) # Records
record = line.split(';') # splits the rows into parts
# build record to append
row_to_append = {"name": record[0], "surname": record[1]} # Create Attributes
geometry_point = Point({"x": record[2], "y": record[3], "spatialReference" : {"wkid" : 4326}}) # Create Geometry
rows_to_append.append(Feature(attributes=row_to_append, geometry=geometry_point))
"""
# log into AGOL and append new rows
"""
con = GIS('https://arcgis.com', 'username', 'password') # log in to AGOL
# connect to the layer to append
layer_to_append = FeatureLayer('https://services.arcgis.com/nZAAAAAAn0yqFPN/arcgis/rest/services/upload_data/FeatureServer/0', con)
# view Current Rows
view_rows = layer_to_append.query(where='1=1')
for row in view_rows:
print(row)
# append new rows
result = layer_to_append.edit_features(adds=rows_to_append)
print(result)
# view all rows
view_rows = layer_to_append.query(where='1=1')
for row in view_rows:
print(row)
Hope it helps
Henry
by
by
by
