topic Re: Dynamic Text Table Attribute & Arcade Expression for Street Index in ArcGIS Pro Questions

Dynamic Text Table Attribute & Arcade Expression for Street Index

LindaKuhn — Wed, 10 Aug 2022 11:49:29 GMT

I have a street map with a Street Index listing street names in alphabetical order and showing which section(s) those street are listed in. I am trying to use the Dynamic Text - Table Attribute to create the Street Index from an Excel spreadsheet.

I am using an Arcade expression to count the number of characters in the street name and the section(s) to then determine how many leader dots to place in between the street name and the section. I've decided on a total character length of 30 as this should hold the longest street name and the longest section(s) and still allow a few leader dots in between the two.

This is a small sample of my Excel spreadsheet:

Column A contains the street names and Column B contains the section(s) that particular street is found in on the map.

Looking at my Text Element, from the Insert Table Attribute I am using an Arcade expression. I want the Arcade expression to add a blank row between the numeric street names and another blank row between the street names that start with A and another blank row between the street names that start with B, etc. to the end of the alphabet. I am using the Arcade expression to count the total number of characters found in the street name and section(s) to determine how many leader dots to place in between the two words.

This is what my Arcade expression looks like:

if ($feature.Section == null)

{

return TextFormatting.NewLine + $feature.StreetNames + TextFormatting.NewLine

}

var a = $feature.StreetNames + $feature.Section

var b = Count(a)

var c = 30 - b

var d = c/2

var e = c%2

if (e == 0) {d = d +1}

var dotString = ""

for (var i=0; i<d; i++)

{dotString = dotString + ". "}

return $feature.StreetNames + " " + dotString + $feature.Section + TextFormatting.NewLine

(Note: I'm not good with Arcade yet, so had to have a colleague help me with the above expression)

Because I have calculated the number of leader dots to have each line a total of 30 characters, I was expecting that my results would display as even straight columns ending at the same position on the right hand side, but that is not the results I'm getting. I have tried setting my Text symbol - Appearance - Position - Horizontal alignment as "Left", "Center", "Right" and "Justify" and none of them return even columns.

I have tried using several monospaced fonts (Lucida Sans Typewriter, Simsun, Courier New) and this doesn't help either. This is the results I am getting. The right hand side of the columns is uneven.

I used to make this map in ArcMap using 8 individual Text Boxes where I manually typed the street name, the leader dots and the section, hit the hard return after each line and used the full justify position. The result was very neat looking but hard to maintain whenever new streets were built. If the new street started with the letter "C" it would be added in the second text box in alphabetical order and then the last street from each text box to the right of it would have to be manually moved to the top of the next text box. I'm trying to transfer this map to ArcGIS Pro and take advantage of its newer functionality but can't get results to be even on both sides of each column. This is what the street index looks like in ArcMap using individual text boxes:

Any suggestions/ideas would be appreciated.

Re: Dynamic Text Table Attribute & Arcade Expression for Street Index

jcarlson — Wed, 10 Aug 2022 12:51:02 GMT

I tried accomplishing this with some sample data, and here's what worked for me:

// check for section header first if (IsEmpty(s['Section'])){ return `\n${s['StreetNames']}\n` } else { // build string var text_len = Count(s['StreetNames']) + Count(s['Section']) Console('total text length ', text_len) // get number of remaining spaces between text var spaces = 30 - text_len var dot_string = ' ' // leaving at least two characters for spaces on either end, populate the rest of the dot string for (var x=0; x < spaces-2; x++){ // add '.' for even-numbered iterations, ' ' for odd-numbered dot_string += Iif(x % 2 == 0, '.', ' ') } dot_string += ' ' // add full string to output return `${s['StreetNames']}${dot_string}${s['Section']}\n` }

A few pointers:

I like to use template literals for building strings. Instead of $feature.attribute1 + ', ' + $feature.attribute2 + TextFormatting.NewLine, you could have `${feature.attribute1}, ${feature.attribute2}\n`.

For building the dot string, I did things a bit differently with the for loop. Rather than iterate over once for every two characters in the remaining space, it would take the left over characters (30 - street name and sections) and alternate between '.' and ' ', leaving room on both ends for a space.

It seems to work well enough, though the dots don't always align vertically from row to row. You could further modify this to get those dots to align nicely, but here's what my expression produces.

Re: Dynamic Text Table Attribute & Arcade Expression for Street Index

jcarlson — Wed, 10 Aug 2022 12:52:01 GMT

PS - Since I was using sample data, I accessed the features with a made-up variable s. Just replace those with $feature to apply this to your own situation.

Re: Dynamic Text Table Attribute & Arcade Expression for Street Index

LindaKuhn — Wed, 10 Aug 2022 14:26:03 GMT

Thank you very much for responding to my post. I took your arcade expression and replaced the variable s with $feature per your P.S. My arcade expression looks like this:

// check for section header first
if (IsEmpty($feature['Section'])){
return `\n${$feature['StreetNames']}\n`
} else {
// build string
var text_len = Count(s['StreetNames']) + Count(s['Section'])
Console('total text length ', text_len)

// get number of remaining spaces between text
var spaces = 30 - text_len

var dot_string = ' '

// leaving at least two characters for spaces on either end, populate the rest of the dot string
for (var x=0; x < spaces-2; x++){
// add '.' for even-numbered iterations, ' ' for odd-numbered
dot_string += Iif(x % 2 == 0, '.', ' ')
}

dot_string += ' '

// add full string to output
return `${s['StreetNames']}${dot_string}${s['Section']}\n`
}

My result is only showing the headings and none of the street names

Did I misunderstand something?

Re: Dynamic Text Table Attribute & Arcade Expression for Street Index

jcarlson — Wed, 10 Aug 2022 14:58:47 GMT

You've still got a handful of s variables in the expression you posted.

Re: Dynamic Text Table Attribute & Arcade Expression for Street Index

LindaKuhn — Wed, 10 Aug 2022 15:17:21 GMT

Yes, I see that I missed a couple of s variables. Now that I've updated the Arcade expression again it looks like this:

// check for section header first
if (IsEmpty($feature['Section'])){
return `\n${$feature['StreetNames']}\n`
} else {
// build string
var text_len = Count($feature['StreetNames']) + Count($Feature['Section'])
Console('total text length ', text_len)

// get number of remaining spaces between text
var spaces = 30 - text_len

var dot_string = ' '

// leaving at least two characters for spaces on either end, populate the rest of the dot string
for (var x=0; x < spaces-2; x++){
// add '.' for even-numbered iterations, ' ' for odd-numbered
dot_string += Iif(x % 2 == 0, '.', ' ')
}

dot_string += ' '

// add full string to output
return `${Feature$['StreetNames']}${dot_string}${$Feature['Section']}\n`
}

but these revisions didn't change the end results. I still am only getting the headings and none of the street names:

Re: Dynamic Text Table Attribute & Arcade Expression for Street Index

LindaKuhn — Wed, 10 Aug 2022 15:32:28 GMT

I looked closer at your Arcade expression Line 3 and revised Line 23 to follow its formatting. I replaced your last line of Arcade expression with:

return `\n${$feature['StreetNames']}${dot_string}${$Feature['Section']}\n`

and it looks great. Thank you so much for your help.

My final Arcade Expression looks like this:

// check for section header first
if (IsEmpty($feature['Section'])){
return `\n${$feature['StreetNames']}\n`
} else {
// build string
var text_len = Count($feature['StreetNames']) + Count($Feature['Section'])
Console('total text length ', text_len)

// get number of remaining spaces between text
var spaces = 30 - text_len

var dot_string = ' '

// leaving at least two characters for spaces on either end, populate the rest of the dot string
for (var x=0; x < spaces-2; x++){
// add '.' for even-numbered iterations, ' ' for odd-numbered
dot_string += Iif(x % 2 == 0, '.', ' ')
}

dot_string += ' '

// add full string to output
return `\n${$feature['StreetNames']}${dot_string}${$Feature['Section']}\n`
}

Re: Dynamic Text Table Attribute & Arcade Expression for Street Index

JesseWickizer — Fri, 19 Aug 2022 18:56:54 GMT

Another approach to consider is to use a table frame for the index. There's not a specific mechanism to add dot leaders, but with some formatting of the table frame parts you could achieve a similar look without requiring the use of a monospace font.

Steps:

First, format the vertical alignment of the data text of the page number field to right justified.

Add dot leader style to table frame rows

In the table frame properties, set Background 1 and Background 2 to 1 row each.

Then click the symbol next to Background 1 to edit the background style. Here's where to add in a dotted style to the bottom of the text row.

Change the fill style to Hatched fill with 90 degree angle and about 8pt separation (adjust separation amount as you prefer).

Edit the Hatch line symbol further by clicking Format line symbol... in the symbol menu.

Click the Structure tab (wrench symbol) then add a new Marker layer.

Delete the original line layer leaving only the marker layer.

Edit the marker layer properties to create the repeating dot style.

Size: 1pt
Scale proportionally: UN-check
Marker placement: At extremities
Extremities: At begin
Offset: 3pt

Now set the same style for the Background 2 style.

Clean up extra dots

This also leaves dots in places we don't want, such as before and after the text and overlapping the text so the next step is to fix this.

Start by narrowing the space between the text and border (horizontal) in the Table frame properties. This will cover the dots hanging off the beginning and end of the text.

Next, edit the text symbol for the fields to add a background callout in the same color as the layout background - white in this case. I used 2px left and right margin to cover dots that are too close to the text but try other sizes that look best.

Moving the table frame over a gray background reveals how it's constructed - add a white background to the whole table frame element or ensure it's paced over a white or matching background in the layout.

Re: Dynamic Text Table Attribute & Arcade Expression for Street Index

BrianCoward1 — Fri, 13 Feb 2026 23:53:55 GMT

First. Thank for the arcade script. It was very helpful. I'm having trouble getting the same results you shared in your screen shot. Mainly, the right justified section/grid value. I've tried modifying line 23 with the <Align> tag but without any luck. Here's my version:

return `\n${"<ALIGN horizontal='left'>"+$feature['Full_Street']+"</ALIGN>"}${dot_string}${"<ALIGN horizontal='right'>"+$Feature['Grid']+"</ALIGN>"}\n`

Any suggestions would be much appreciated. I also have streets which have more than 20 characters. I need to figure out how to wrap the text after 15 characters to a newline until all the grid values are all shown and right justified.

I've got it setup in table frame but its taking more space with the grid lines than I have available on my street map.

Appreciate what you provided already! Thank you.