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

Crear una nueva entidad a partir de una lista de campos con valores SÍ o NO mediante el editor de expresiones para ventanas emergentes

Anonymous User

Hola a todos:

Tengo un mapa web en ArcGIS Online que obtiene los datos de un servicio REST. El servicio REST muestra los mercados agrícolas activos de mi estado y enumera los meses en que está abierto cada mercado de una forma extremadamente engorrosa. La captura de pantalla adjunta muestra que, en la ventana emergente de cada mercado, aparece 12 veces un valor de SÍ o NO. Quiero consolidar todos estos valores de SÍ y NO en una nueva entidad que simplemente indique los meses en que está abierto el mercado.

Esta es la ventana emergente de este mercado tal como se muestra en un cuadro de mando, que será la aplicación final de este mapa.

Solo quiero que la ventana emergente indique algo como «Abierto en: jun., julio, agosto y septiembre» para cada mercado que seleccione.

Cabe señalar que mi organización no me permite modificar el servicio REST (ni los servicios REST) correspondiente. De ahí que necesite una solución alternativa.

Puede que esté usando mal la palabra «entidad» para referirme a una solución a mi problema, así que no dudes en corregirme también al respecto. Mi idea para una solución alternativa era usar las funciones feature o featureset en el editor de expresiones para crear una nueva entidad que haga referencia a las 12 columnas de datos mensuales existentes para los aproximadamente 360 mercados. Durante los últimos días he estado intentando aprender a escribir una expresión de Arcade que haga esto, pero todas las funciones distintas me están dando vueltas la cabeza y nunca había intentado programar en ningún lenguaje antes. ¡Todavía estoy atascado en la etapa de entender cómo funciona la sintaxis, jaja!

@XanderBakker ¡Espero que no te importe que te haya mencionado! Vi que ofreciste una solución aparentemente similar al problema planteado aquí. ¡Esperaba que quizá fueras la persona indicada para pedir ayuda!

Encuentra más publicaciones etiquetadas con

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;

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

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