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

Use Select by Attributes to select greatest n records (FGDB)

Bud

ArcGIS Pro 3.2.1; file geodatabase

As far as I know, there isn’t a way to use Select By Attributes to select the top n records of a FGDB FC, such as select the 4 cities with the largest POPULATION (no ties).

See:

Select the records with the highest values in a particular field
https://community.esri.com/t5/arcgis-pro-questions/arcgis-3-0-2-what-tool-can-select-the-records-with/m-p/1370898#M77491
Select the 3 features that have the largest attribute value

Najít více příspěvků označených jako

Geodatabase

Status: Otevřít

Komentáře

Bud

I suppose this idea might be a duplicate of my other idea: SQL LIMIT clause in FGDB SQL

And this idea is related too: ROW_NUMBER function in FGDB SQL

In those ideas, I wanted to make it clear that I want those specific functions/clauses in FGDB SQL. They would help with the current idea above, as well as many other use cases.

JamalNUMAN

Yes, we need it

Bud

To me, it's not really acceptable that Esri's main/proprietary datatype doesn't support this (without creating a copy of the data). It's a basic GIS task: select the 4 biggest cities.

Bud

Idea: Make Query Table — Sort data (and then generate dynamic OBJECTID)

Bud

FGDB SQL is too limited to be useful to us.

Připojte se k diskusi

Přihlaste se pro psaní příspěvků, sledování obsahu a další. Jste tu noví? Zaregistrujte se zdarma.