Update a Feature Layer from the same Feature Layer

[JeffSilberberg]

So I have an Excel worksheet with 200 rows, each of the rows has descriptive data and a Lat/Lon value.  I can upload that and create a Feature Layer.

Now what I would like to do, I think, is run an analytic that walks through this feature layer, adds a geoPoint, and uses the data in one of the columns to calculate a radius around the point to create a ring, resulting in the same Feature layer just with additional columns.

Can I do an Analytic that reads the Feature Layer as the Input and does an update output, maybe as the geoEvent equivalent of a Big Data Analytic? 

[JakeSkinner]

Hi @JeffSilberberg, I'm not sure I'm understanding your workflow.  Are you trying to iterate through the feature service, and create a buffer using a distance value from a field in the feature service?

[JeffSilberberg]

YES, that is exactly what I want to do.

[JakeSkinner]

You won't be able to update the point feature service, but you can output the buffers to a new polygon feature service using the Buffer Creator processor.  Below is an example of how this is setup.  It's getting the buffer distance from a field called distance:

For the Coordinate System, make sure you specify a Projected Coordinate System.

[JeffSilberberg]

Thank you, 

    I was afraid that was the answer.  But now I have two Feature Layers, the one built from the source Excel Worksheet and the output of a monthly update run to add the coverage radius circle. 

   Maybe I ned to make the Worksheet a Feed somehow.. 

[JakeSkinner]

If you can get the spreadsheet in a CSV format, you can use the Watch a Folder for New CSV Files input.

[JeffSilberberg]

@JakeSkinner 

    CSV into a watched folder is the path I started down late yesterday.  But did not get as far as I wanted yet.   

THANK YOU! 

[JeffSilberberg]

@JakeSkinner 

  So I have my Registered Folder Selected for the Input Directory Data Store, and I added a subDirectory CSV Files.  Do I want to specify "\CSV Files" or just "CSV Files" in the IInput Directory field?  

  Update: I just can not get the Feed to read the CSV file.   Must be missing something but not sure what - 

I used the "\CSV Files", but it does not seem to be pulling in the CSV I just pasted there. 

[JakeSkinner]

Just "CSV Files".

[JeffSilberberg]

No joy --  An the Log is no help at all.   

Should I open a Support ticket?