topic Re: Listing polygon names that another polygon intersects in ArcGIS Online Questions

Listing polygon names that another polygon intersects

Leahr — Thu, 15 Sep 2022 20:34:19 GMT

Hello! I am currently writing an expression to list all of the cities (or just a single city) that a park area is in. I was able to get a loop to find and list all of the cities/city returned, just formatting it is my last issue.

Currently what is returned is:

which depends on how many cities the park is in. (here is the expression)

Ideally, I would want the list to look more like

"This park is in: City1, City2, and City3"

or "This park is in: City1 and City2"

or "This park is in: City1"

(obviously, it would depend on the number of cities the park is in)

Does anyone have a solution to adding commas between city names, while not having a comma after the last city, but having an and before the last one (if possible)?

Thanks!

Re: Listing polygon names that another polygon intersects

KenBuja — Thu, 15 Sep 2022 21:42:38 GMT

Here's one way to do that

Re: Listing polygon names that another polygon intersects

JohannesLindner — Fri, 16 Sep 2022 08:11:32 GMT

Here's another way:

var cityList = [] for(var c in inCity) { Push(cityList, c.CTU_NAME) } if(Count(cityList) > 1) { cityList[-1] = "and " + cityList[-1] } var cityString = Concatenate(cityList, ", ") cityString = Replace(cityString, ", and", " and") return "This park is in: " + cityString

Re: Listing polygon names that another polygon intersects

Leahr — Mon, 19 Sep 2022 21:01:49 GMT

Hi Johannes!

It worked, thanks so much😊