ArcGIS 10 attribute table sort issue

ArcGIS 10 attribute table sort issue

what is the solution for this funky sorting Esri does in attribute tables with decimal places values… screen shot:">attribute table funky sort

It looks like MP is a character field, thus the weird sort. That sort looks normal for a character field. Try creating a new field, e.g. "MP_Num", as a numeric field, then calculate the values of MP_Num based on String-to-Number conversion of MP.

edit: I just noticed the ET_STATION field looks to be the numeric equivalent of MP, so you may not need to make a new field. Try sorting on ET_STATION.

What type is your field? If it's a text type, it will alphabetise it and therefore put everything starting with 1 first. Make a new field of a numerical type and it will sort properly.

edit: Also I just tested this on a table of my own with decimal places of type DOUBLE and it does not sort like this. But it does do it for the text label field I have.

Your field is a text field and if you want to sort it properly, then it needs to be padded with zeros. There are various ways of doing this, an example is shown here which can be implemented within the field calculator if using ArcMap and I am sure other programs that support Python or Python-like syntax


Then you can always use zfill to pad your rows if you are using the field calculator and the Python parser, you just .

>>> "17.98".zfill(8) '00017.98'

eg, convert to a string then pad

>>> a = 17.98 >>> b = str(a).zfill(8) >>> b '00017.98' >>>

ArcGIS 10 attribute table sort issue - Geographic Information Systems

All articles published by MDPI are made immediately available worldwide under an open access license. No special permission is required to reuse all or part of the article published by MDPI, including figures and tables. For articles published under an open access Creative Common CC BY license, any part of the article may be reused without permission provided that the original article is clearly cited.

Feature Papers represent the most advanced research with significant potential for high impact in the field. Feature Papers are submitted upon individual invitation or recommendation by the scientific editors and undergo peer review prior to publication.

The Feature Paper can be either an original research article, a substantial novel research study that often involves several techniques or approaches, or a comprehensive review paper with concise and precise updates on the latest progress in the field that systematically reviews the most exciting advances in scientific literature. This type of paper provides an outlook on future directions of research or possible applications.

Editor’s Choice articles are based on recommendations by the scientific editors of MDPI journals from around the world. Editors select a small number of articles recently published in the journal that they believe will be particularly interesting to authors, or important in this field. The aim is to provide a snapshot of some of the most exciting work published in the various research areas of the journal.

Graphical abstract


►The Madrid region of Spain has experienced remarkably dynamic land use change over the past 20 years. ►These changes can be documented to a high level of detail using the CORINE land cover dataset, which forms an effective baseline dataset for regional land planning. ►Urbanization has occurred away from the capital city in an unmanaged and unsustainable way, aided by liberal land use policies and abandonment of agrarian land areas. ►Top-down political solutions are not forthcoming integrative methodologies based on rapid sustainable development appraisals, communication and cooperation between municipalities and local groups, and participatory approaches using land use scenario modeling, offer a way forward.

Watch the video: Sorting Tables in ArcGIS Pro