Design Data Pipeline for Joining Layers and Add/Update Fields

Question

Hello all,

I am seeking assistance with developing a ArcGIS Online pipeline. I am attempting to 'populate' data from a point feature layer into a polygon feature layer.

I have 2 feature layers: 1) A polygon feature layer that came from a deployed ESRI solution (CPC Projects in feature layer screenshot  below). 2) A point feature layer that is tethered to an API which auto-updates with new information daily (Projects feature layer in screenshot below).

We are attempting to connect the ESRI solution polygon layer with the point feature layer in a way that does not create a new feature layer. We would like to develop a Pipeline that populates the point feature layer data into specific matched fields of the polygon feature layer based on a spatial join.

I am unfamiliar with the best order-of-operations for this in a Pipeline. I have been testing out the 'Map fields', 'Update fieds', and 'Join' tool in a test pipeline, but cannot determine the best flow for running the tools? Additionally, because I do not want a new feature layer output, the 'Add and Update' function on the output feature layer tool would need to be used, but because fields need to be matched from the target-polygon layer and the joining-point layer, I'm also uncertain when the 'Map fields' tool would need to be performed?

Below is a screen shot of my preliminary explorations. Hoping someone has an idea on the best order of operations for executing this.

image_pipeline.png

JonathanMcD · Answer

@SarahReny1

So, assuming you're capturing the points in a field app or such, you can avoid using a pipeline by simply adding an expression into (say) Field Maps where is inherits information from the polygon beneath it, when the point is created.

However, let's say you're wishing to add postcode or area information to the point from the polygon - the very simplest of spatial joins will do.

I think, as I've not tried this yet as a test, you'll need to create a view of the polygon dataset to fit the data you need to transpose over as it will just join all fields.