Passing values to Reporting - multiple parcels and a spatial intersect to find multiple zonings per parcel
I'm not sure if this belongs in Workflow or Reporting. I have a workflow that takes feature input of selected parcels from a VSW application. It then runs a spatial query to identify the (possible multiple values) zoning for the parcel. I've figured out how to make a report that lists the parcel information and the zoning information by passing the zoning feature ids as a parameter in addition to the parcel feature ids.
This works great for a single parcel with either one or multiple zoning intersects, but I can't wrap my head around how to make it work for multiple parcels with zoning listed for each one. Since it's a spatial relationship, I can't do a relate to get at the data. It almost seems like I would need to pass some kind of dictionary object but I don't know if that's possible or how to make Reporting interpret it.
Any ideas? Am I even thinking about this the right way?
-
Hi. I haven't done it but possibly you could use the Get Form Element Items From Collection activity to create an array of layers and loop through that with the forEach activity. I am not really sure though. Out of curiosity, what value did you put in the circled area below to get the spatial query working? I am still working through that.
0 -
My spatial query is simply a buffer, so it gets the geometry of the selected features and uses the buffer activity, then performs a regular query on the intersecting layer.
It's been suggested I could use a json data source for the report, but I have no idea how to stick an array (parcel1:zoning1, zoning2; parcel2:zoning1) into json or how to have the report interpret it. I may call this not worth it and stick with reporting on one parcel at a time. I wish I could make VSW not put a top level option (above multiple results) to run the report. So that it's only an option with a single feature.
0 -
Sorry I couldn't be of more assistance. I haven't worked on multiple feature intersects yet, but will try to share whatever I find when I do. Putting one intersect result above all the others also occurs in ArcGIS Arcade unless a for loop is included. Sounds more challenging to implement the loop here though. Thanks for the info.
0 -
By the way, I found a solution on the forums to the “hide feature action when multiple features are selected” problem. This involves a little arcade script in the workflow custom command section, as detailed in the post.
1
Please sign in to leave a comment.
Comments
4 comments