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; } } }

ポップアップ用の式エディターで、YES または NO の値を含むフィールドのリストから新しいフィーチャを作成する

Anonymous User

皆さん、こんにちは。

ArcGIS Online に Web マップを作成しています。このマップは REST サービスからデータを取得しています。この REST サービスには、私の州で営業しているファーマーズマーケットが表示されており、各市場の営業月が非常に扱いにくい形式で一覧表示されています。添付のスクリーンショットのように、ポップアップ内では1つの市場に対して、YES または NO の値が12回表示されます。これらの YES と NO の値をまとめて、市場の営業月を簡潔に示す新しいフィーチャを作成したいです。

これはダッシュボードで表示した、この市場のポップアップです。このマップは最終的にこのダッシュボードで使用する予定です。

各市場をクリックしたとき、ポップアップに「営業月：6月、7月、8月、9月」のように表示させたいだけです。

なお、所属組織の都合で、REST サービス上の項目を変更する権限はありません。そのため、回避策が必要です。

問題の解決策として「フィーチャ」という言葉の使い方が間違っているかもしれませんので、その点も遠慮なくご指摘ください。回避策として考えていたのは、式エディターの feature または featureset 関数を使って、約360の市場すべてについて、既存の12か月分のデータ列を参照する新しいフィーチャを作成することです。ここ数日、この処理を行う Arcade 式の書き方を学ぼうとしているのですが、関数がいろいろありすぎて頭が混乱しています。それに、これまでどの言語でもコードを書いたことがないので、構文の仕組みを理解するところでまだつまずいています。はは！

@XanderBakker タグ付けしてしまいましたが、よろしいでしょうか！こちらの投稿で、似たような問題に対する解決策を提示されているのを拝見しました。もしかすると、相談するのに最適な方ではないかと思い、ご連絡しました！

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

Content Management

Data and services

Arcade

Accepted answers

XanderBakker

Hi @Anonymous User ,

I think you could use something like this:

// create a disctionary with field names and month names (change the field names!)
var dct = {"OpenJan": "January", "OpenFeb": "February",
           "OpenMar": "March", "OpenApr": "April", 
		   "OpenMay": "May", "OpenJun": "June",
		   "OpenJul": "July", "OpenAug": "August",
		   "OpenSep": "September", "OpenOct": "October",
		   "OpenNov": "November", "OpenDec": "December"};

// start with an empty result string
var result = "";

// loop through field names in dct
for (var fldname in dct) {
	// read the value of the field
	var fldval = $feature[fldname];
	// validate if the value is YES
	if (fldval == "YES") {
		// add the month to the result
		if (result == "") {
			// first month
			result = "Open in: " + dct[fldname];
		} else {
			// any next month
			result += ", " + dct[fldname];	
		}
	}
}

return result;	‍
‍

XanderBakker

Hi @Anonymous User ,

A simple fix could be this:

// create a disctionary with field names and month names (change the field names!)
var dct = {"OpenJan": "January", "OpenFeb": "February",
           "OpenMar": "March", "OpenApr": "April", 
		   "OpenMay": "May", "OpenJun": "June",
		   "OpenJul": "July", "OpenAug": "August",
		   "OpenSep": "September", "OpenOct": "October",
		   "OpenNov": "November", "OpenDec": "December"};

// simple fix, use a list of field names with the right order
var lst = ["OpenJan", "OpenFeb", "OpenMar", "OpenApr", 
		   "OpenMay", "OpenJun", "OpenJul", "OpenAug",
		   "OpenSep", "OpenOct", "OpenNov", "OpenDec"];

// start with an empty result string
var result = "OK";

// start with an empty result string
var result = "";

// loop through the list of field names
for (var i in lst) {
    var fldname = lst[i];
	// read the value of the field
	var fldval = $feature[fldname];
	// validate if the value is YES
	if (fldval == "YES") {
		// add the month to the result
		if (result == "") {
			// first month
			result = dct[fldname];
		} else {
			// any next month
			result += ", " + dct[fldname];	
		}
	}
}

return result;

All comments

XanderBakker

Hi @Anonymous User ,

I think you could use something like this:

// create a disctionary with field names and month names (change the field names!)
var dct = {"OpenJan": "January", "OpenFeb": "February",
           "OpenMar": "March", "OpenApr": "April", 
		   "OpenMay": "May", "OpenJun": "June",
		   "OpenJul": "July", "OpenAug": "August",
		   "OpenSep": "September", "OpenOct": "October",
		   "OpenNov": "November", "OpenDec": "December"};

// start with an empty result string
var result = "";

// loop through field names in dct
for (var fldname in dct) {
	// read the value of the field
	var fldval = $feature[fldname];
	// validate if the value is YES
	if (fldval == "YES") {
		// add the month to the result
		if (result == "") {
			// first month
			result = "Open in: " + dct[fldname];
		} else {
			// any next month
			result += ", " + dct[fldname];	
		}
	}
}

return result;	‍
‍

Anonymous User

You're a wizard! It worked perfectly besides listing a couple months in the wrong order, but I can manage fixing that myself I think.

One more piece of help please! It lists the months in alphabetical order instead of by the order of months in a year. I try and type some solutions to this into your code but I can't seem to do anything other than break it. What to do? @XanderBakker

XanderBakker

Hi @Anonymous User ,

Glad to hear that it helped. If you run into problems with making the required changes just let me know.

About your questions:

For example, why use this method instead of creating an entire new feature?
- I wonder how you would create a new feature if you are not the owner of the data. You could with a notebook access the data, transform it the way you need it, and write a local feature layer and use that. This is more complex to implement.
What was the purpose of starting the logic part of the expression with "an empty results string?"
- Any variable you want to assign a value needs to be initialized. This is done using "var NameOfVariable = InitialValue". Perhaps this could be omitted and line 21 could start with "var ". However, sometimes this could create an error when compiling the code, so I prefer to initialize the variable before the loop.
Finally, what exactly do the "{" and "}" symbols do in this expression?
- The "{" and "}" are used to contain logic that needs to be executed. It also helps the readability of the code. To learn more about Arcade you could follow the learn path: https://learn.arcgis.com/en/paths/try-arcade/

Anonymous User

Thanks for your explanations. I will be sure to explore the resources you linked to asap.

One more piece of help please! It lists the months in alphabetical order instead of by the order of months in a year. What to do? @XanderBakker

XanderBakker

Hi @Anonymous User ,

Can you share the expression you have now?

XanderBakker

Hi @Anonymous User ,

A simple fix could be this:

// create a disctionary with field names and month names (change the field names!)
var dct = {"OpenJan": "January", "OpenFeb": "February",
           "OpenMar": "March", "OpenApr": "April", 
		   "OpenMay": "May", "OpenJun": "June",
		   "OpenJul": "July", "OpenAug": "August",
		   "OpenSep": "September", "OpenOct": "October",
		   "OpenNov": "November", "OpenDec": "December"};

// simple fix, use a list of field names with the right order
var lst = ["OpenJan", "OpenFeb", "OpenMar", "OpenApr", 
		   "OpenMay", "OpenJun", "OpenJul", "OpenAug",
		   "OpenSep", "OpenOct", "OpenNov", "OpenDec"];

// start with an empty result string
var result = "OK";

// start with an empty result string
var result = "";

// loop through the list of field names
for (var i in lst) {
    var fldname = lst[i];
	// read the value of the field
	var fldval = $feature[fldname];
	// validate if the value is YES
	if (fldval == "YES") {
		// add the month to the result
		if (result == "") {
			// first month
			result = dct[fldname];
		} else {
			// any next month
			result += ", " + dct[fldname];	
		}
	}
}

return result;

会話に参加する

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

クイックリンク

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