Portal for ArcGIS – dashboard - priority

lisete_vieira

Portal for ArcGIS – dashboard: I have a feature class called quarries, which contains a field for the quarry number (n_cadastro) that is repeated in some situations. For example, there may be a record for a quarry that is already licensed and also a record with a request for that same quarry for expansion.

However, I want to obtain a chart by quarry status (With guarantee, Provisional Authorization, Request, and Without Guarantee), ensuring that the quarry number is not duplicated and following this priority:

1 – With guarantee
2 – Provisional Authorization
3 – Request
4 – Without Guarantee

In other words, if there is a quarry with a guarantee and also a request for that same quarry, I only want the record with With guarantee to appear, ignoring the request. If there is a request for a quarry and also a record Without guarantee, only the Request record should appear.

How should I proceed to achieve what I want?

Thank you for your help.
Best regards.

IsabelMiguel

Hello Lisete

Try, but be attencion for field name:

var portal = Portal("https://portalgeo.dgeg.gov.pt/arcgis");

 

var fs = FeatureSetByPortalItem(
    portal,
    "2d47540cff784dfcae59deaa07543226",
    0,
    ["n_cadastro", "situacao"],
    false
);

 

// ======================================================
// 1) Criar tabela temporária com prioridade
// ======================================================

 

var tmp = {
    fields: [
        { name: "n_cadastro", type: "esriFieldTypeString" },
        { name: "prio", type: "esriFieldTypeInteger" }
    ],
    geometryType: "",
    features: []
};

 

var i = 0;

 

for (var f in fs) {

 

    var idv = Trim(Text(f["n_cadastro"]));

 

    if (IsEmpty(idv)) {
        continue;
    }

 

    // normalizar texto
    var s = Upper(Trim(Text(f["situacao"])));

 

    // prioridade
    var p = Decode(
        s,
        "COMCAUCAO", 4,
        "AUTORIZACAOPROVISORIA", 3,
        "PEDIDO", 2,
        "SEMCAUCAO", 1,
        0
    );

 

    tmp.features[i++] = {
        attributes: {
            n_cadastro: idv,
            prio: p
        }
    };
}

 

var fsPrio = FeatureSet(tmp);

 

// ======================================================
// 2) Remover duplicados mantendo prioridade máxima
// ======================================================

 

var dedup = GroupBy(
    fsPrio,
    ["n_cadastro"],
    [{
        name: "prio_max",
        expression: "prio",
        statistic: "MAX"
    }]
);

 

// ======================================================
// 3) Contar quantos existem por prioridade
// ======================================================

 

var counts = GroupBy(
    dedup,
    ["prio_max"],
    [{
        name: "total",
        expression: "prio_max",
        statistic: "COUNT"
    }]
);

 

// ======================================================
// 4) Função auxiliar
// ======================================================

 

function getCount(p) {

 

    var hit = First(Filter(counts, "prio_max = @p"));

 

    return IIF(IsEmpty(hit), 0, hit["total"]);
}

 

// ======================================================
// 5) Devolver FeatureSet final para Dashboard
// ======================================================

 

return FeatureSet({
    fields: [
        { name: "estado", type: "esriFieldTypeString" },
        { name: "total", type: "esriFieldTypeInteger" }
    ],
    geometryType: "",
    features: [

 

        {
            attributes: {
                estado: "Com Caução",
                total: getCount(4)
            }
        },

 

        {
            attributes: {
                estado: "Autorização Provisória",
                total: getCount(3)
            }
        },

 

        {
            attributes: {
                estado: "Pedido",
                total: getCount(2)
            }
        },

 

        {
            attributes: {
                estado: "Sem Caução",
                total: getCount(1)
            }
        }

 

    ]
});