nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

arcade expression for label the numbers of permits by neighborhood

DianaWilson1

Hi All,

I am working an arcade expression for label the numbers of permits open by neighborhood. Each permit is assign to each parcel within the Neighborhood. The parcel Identification number is a "text" data type and a duplicate parcel identification in the attribute table means that there are more than one permit open on the property. I wrote this expression, but it does not work how it is expected. Using the counts function, I got number “1”for each permit in each parcel, but I cannot sum the counts. I want to display the total number of permit per neighborhood.

Could you please review it and let me know how will be the right expression. Any advice? thank you!

SUM(count([$feature.PARID]))

Capture4.PNG

A6629B8A-9E53-46D6-8500-B796DF58CB68.jpeg

タグ付きの投稿をもっと見る

Analysis

Accepted answers

XanderBakker

Hi @DianaWilson1 ,

Related to the first part of your response, I guess this should also be possible to achieve using the condo complex. Let me know if you want to explore that option.

To learn Arcade I think the book should be a very good resource, although I haven't seen the content in detail. Arcade in for instance a web map is something that is not very advanced. However, using arcade in attribute rules is a topic that can be advanced depending on what you want to achieve. There is a community in GeoNet focussed on attribute rules: https://community.esri.com/t5/attribute-rules/ct-p/attribute-rules

Also, the examples in the help documentation are very helpful: https://pro.arcgis.com/en/pro-app/help/data/geodatabases/overview/attribute-rule-script-expression.htm

I would also recommend the various blogs published by Esri: https://www.esri.com/arcgis-blog/?s=#arcade
There are also learn lessons for Arcade: https://learn.arcgis.com/en/gallery/#?q=arcade

And last but not least all the blogs and documents published here at GeoNet that can provide insight in how to do something: https://community.esri.com/t5/forums/searchpage/tab/message?filter=includeBlogs,includeTkbs&q=arcade&include_tkbs=true&collapse_discussion=true&include_blogs=true

All comments

XanderBakker

Hi @DianaWilson1 ,

The reason that you obtain the value 1 is this: $feature.PARID is a single value and when you "count" a single value you get 1 and when you do a sum of 1 you also get 1.

What you want to do to either read out the neighborhood id or obtain it using Intersects and filter the data using the id to get all the permits in the neighborhood. Is the permits information spatial or just a table. If it is spatial and represented using the parcels you can use a spatial operation to get all the permits if you both have the permit locations and the neighborhood polygons. If not, you would probably have to use some attribute to know how to filter the data and get the amount of permits in the area. Can you explain a little more what your situation is?

DianaWilson1

The permits information is spatial and it is represented with the parcels polygons. They can be more than one permit per parcel.

You suggestion is to use the label funtion:

var geom2 = Polygon({...})
Count( Intersects($feature.NBHD, geom2) );

Using this one, I got an error "Invalid key". I am getting familiar with all the label funtions, but I haven't use this one. Any advice? Thank you!

XanderBakker

Hi @DianaWilson1 ,

If your goal is to label features (sorry I had not noticed that when I replied previously), you will need to create a field and store the result of an análisis in that field (you could use Arcade with a field calculation). The label profile is very limited and does not allow you to access other features and do these types of aggregations. You can include it in the pop-up using Arcade without creating the field.

So if you can indicate if you really need labels and are able to add another field, or are open to showing the information dynamically in the pop-up then we can have a look at t he options.

DianaWilson1

Hi Alex,

Thank you! I won't be able to add another field. The data is storage using is a URL that programmer created and I will share this map though portal.
It is a great idea to include the permit count by NBHD using the pop-up window! Please looking this option, what will be your advice? Thank you!

XanderBakker

Hi @DianaWilson1 ,

In the pop-up you can create an Arcade expression on the neighborhood layer and find all the permits that spatially intersect the neighborhood and do a count on that and return the number of permits.

It can be something as simple as this:

// access the layer that contains the permits
var fs = FeatureSetByName($map, 'Name of the permits layer in the TOC');

// intersect with the neighborhood feature and count the number of permits
var permits = Count(Intersects(fs, $feature));

// return the number of permits
return permits;

However, the solution depends on how your permits are stored.

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.