topic Re: Populate Street Name Index using Arcade in ArcGIS Pro Questions

Populate Street Name Index using Arcade

SarahHartholt — Fri, 05 Mar 2021 20:09:31 GMT

I am trying to create a street name index as described in this post from 2007 Creating street name indexes (esri.com). I would like to know if it is possible to create an arcade script to create the final table rather than manually manipulating the data in excel. For example, I would like my final GridIndex field attribute to populate on one line as Army Reserve Road-D4, D5

Re: Populate Street Name Index using Arcade

DavidPike — Fri, 05 Mar 2021 21:10:19 GMT

I think you would be best concatenating the D4, D5 in the spatial join initially, then doing any field calculations/arcade labelling.

Where the road intersects each grid in the spatial join, you can set the field mapping to 'Join' and set a delimiter (such as a comma).

A good overview of the process (albeit in ArcMap) Spatial Join’s hidden trick or how to transfer attribute values in a One to Many relationship | Esri Australia Technical Blog (wordpress.com)

Spatial Join (Analysis)—ArcGIS Pro | Documentation - look at the filed_mapping parameter.

Re: Populate Street Name Index using Arcade

SarahHartholt — Mon, 08 Mar 2021 18:57:16 GMT

do you know if there is a way to chose the order of the attribute with the join? I would like the Cell_ID to populate in order (D1, D2, D3, D4, D5). some of my cells are populating with the larger number first (D5,D4), as seen below.

I may have to perform some manual manipulation anyways. I will be left with 4 Army Reserve Roads since there are 4 road segments for this road:

Cell_ID: D5

Cell_ID: D5,D4

Cell_ID: D4

Using the dissolve tool as suggested in the 2007 post will only remove 1 instance of Army Reserve Rd-D4. I suspect that I will be left with 3 features: Army Reserve Rd-D5, Army Reserve Rd-D5,D4, & Army Reserve Rd-D4

Re: Populate Street Name Index using Arcade

DavidPike — Mon, 08 Mar 2021 18:59:20 GMT

I'm not sure about sorting in the join. You might be best just doing a field calculation:

def my_function(value): value_list = value.split(",") sorted_list = sorted(value_list) string = '' for value in sorted_list: if string != '': string += "," + value else: string += value return string

I thought you had repeated roads because of a one-to-many operation. With the join type being concatenated, you would just need a One-to-one join? or am I missing something about your roads data (I can only read between the lines so far)?

Re: Populate Street Name Index using Arcade

SarahHartholt — Mon, 08 Mar 2021 19:16:06 GMT

I guess it's a bit complicated. My original road layer contains multiple segments for a single road (4 for Army Reserve Rd). 1 in D4, 1 that crosses D4 & D5, and 2 in D5.

The process in the 2007 article states that the duplicated roads/cellID's be removed using the dissolve tool AFtER the spatial join has been performed. in this case I would have 4 features: Army Reserve:D4, Army Reserve:D4, Army Reserve D5, Army Reserve D5. The dissolve would then remove the duplicates and leave me with Army Reserve:D4 & Army Reserve:D5

Your original suggestion was to concatenate the CellID's during the spatial join process which, in the 2007 article, is performed BEFORE the duplicated roads are removed. I would again then be left with 4 Army Reserve Rd's:

Army Reserve:D4

Army Reserve:D5

Army Reserve:D5,D4

Re: Populate Street Name Index using Arcade

DavidPike — Mon, 08 Mar 2021 19:17:41 GMT

Just dissolve on the field ABBR_NAME first, then run the spatial join after that surely?

Re: Populate Street Name Index using Arcade

SarahHartholt — Mon, 08 Mar 2021 21:21:52 GMT

I used the following Arcade expression to reorder my Cell_ID values:

var arrName = split($feature.Cell_ID, ","); return Concatenate(sort(arrName),",")