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

ArcGIS should allow the ability to permanently reorder fields in a table

NewingtonConnecticut

After creating a feature class, it would be convenient to go back after data input, and make changes to the field ordering (position).

Encontre mais publicações marcadas com

Geodatabase

Under Consideration

Status: Under Consideration

Comentários

EricPaitz

If your Feature Class is an SDE Feature Class then this can only be done if the underlying RDBMS can support changing the field as you described. If the RDBMS does not support altering an existing field then there is nothing ESRI can do other then actually creating a new field with a new name, calculating the new values and then dropping the old field. What if you are converting from string to number and the conversion fails? The RDBMS usually will roll back the whole update query. It might be done using small groups of records or record by record but this would be very slow for large tables. If you wanted to keep the same field name then the existing field name would have to be changed so the new field (with the new type) can be added. If the RDBMS does not allow an existing field to be renamed you could not keep the same field name without creating the field twice. If this field was a foreign-key to a field in another table I don’t think the field can be dropped without removing the foreign key constraint. This could be very problematic to implement. This might only be possible if the Feature Class is stored in a File GDB because ESRI has full control of its implementation. It’s really only possible if the RDBMS can do it and then there is the question of keeping the user experience the same across all GeoDatabase implementations.

JulieLuetzelschwab

It would be nice to be able to easily rearrange fields too, without having to create a new output feature class.

naokomeyer1

Both of them are really good ideas.

JasonVerachtert

I have been looking for this to happen for years. If it is in SDE (on SQL Server) or a Personal GDB then it can be done in MS SQL or MS Access respectivly, but for Shapefiles or the File GDB you are out of luck. I refuse to use the new File GDB for this reason (and the field reordering, but that is a different issue).

CarlPalmer

For file geodatabases, this would be a very handy feature during prototyping when I frequently find myself correcting oversights and other initial design errors.

SimonShin1

Promoted this to 3000 Points. I think this is a feasible idea.

CyrilMrva1

For shapefiles can be used free Czech software Janitor (http://janitor.cenia.cz/www/j2_dwnfile.php/dwn/app/janitor2.5.1.exe?f=82). The program JanDat can change the name, field type and some properties dbf tables and dbf tables belonging to shp. I also was looking for a Python module, which could change the structure dbf table, but I found only a useful module for dBASE III. (SHP uses dBASE IV

CarlosIsaac_Cabrera

Although I like the idea of this, I think takes just as much time to create a new field and copy the data over. There are also further complications when changing data type. If this was added I see it as a time cost that would take longer than just creating the new field and populating with the calculator.

BarbaraKent

The ability to rename/update an existing field or reposition the placement of a field within a table are commands that were extremely useful in Arc/Info Workstation. It would be so nice to have this functionality in ArcGIS Desktop.

Likewise, the ability to add a new item to a table and designate it's placement in that table (the old Arc/Info ADDITEM command) is greatly missed. Please add these to Desktop.

HeinrichMalina

Changes to field name, field type and field position is also very much wanted for Shapefiles.
Using a Czech software for such a common task is just a work around.

JudithCauldwell

I normally have to cheat (sorry workaround) and take the dbf into Access (normally renaming it so it's less than eight characters long so Access recognises it), it's a pain, surely such a simple database task should be available in ArcGIS. Especially useful would be the ability to change field names, lengths and order.

Shapefiles, gdb, sde who cares what the data is held as or in - needs change overtime.

DanielGrillo

Yep... the reason I user ET Geowizards was because I want to reorder fields and it would be really nice if Esri put this ability back in... I am a workstation left over

BillTedford

GDBs require this field order manipulation functionality, simple request on user's side, long overdue.

John_S

I agree that renaming fields has challenges based on your RDBMS, but, reordering the fields should be really simple. I'm still using 9.3.1, but I've heard now in 10, you can reorder fields within an ArcMap session. Why not take this functionality and put it on the server side instead of limiting it to the MXD side of things.
All you would have to do is add a short, simple, table that lists the fields and their position and expose a table, tab, or other way to easily edit the "Position Number" of each field.
The table could look something like:
[Feature Dataset], [Feature Class], [Field Name], [Field Position]

Example:

Dataset 1, Polygon_Test_fc, "GLOBAL_ID", 3
Dataset 1, Polygon_Test_fc, "ROAD_NAME", 1
Dataset 1, Polygon_Test_fc, "ALIAS_NAME1", 2

So, when accessing the "Polygon_Test_fc" feature class, the attribute table would show up with the Road name, followed by the Alias name, followed by the GID by default.

The [Field Position] could be a short integer, the others would be whatever unique identifier, string, or whatever is convenient to integrate with existing indentifiers for this information.

Then, all you would have to do is tell the desktop software, ArcGIS Server, etc... that, when they access this data, first review this table, and then apply that order to the fields in displaying them client side.

Maybe I'm way off the mark on this one, not sure, but, that's what comes to my mind as a really quick and strait-forward solution to providing at least one of these very highly demanded features.

JurajKrumpolec

When this will be possible (field rename), ArcMap should also ensure automatic update of every query, label or symbology linked to renamed field either in currently opened MXDs or when map document with modified layer is opened.

GrantCrosswell

Yes also agree. Field order is a function we would like to have other GIS staff use in a personal geodatabase to prepare layers for submission to central gis database.
Currently we export XML schema, shuffle the field array order, load the schema and load the data.

DanielGrillo

Get on with it ESRI... we are not asking for much...

AhmedSaad

Some RDMS may have limitations hindering the creation of such tool. However, different RDMS can be inspected by the tool to indentify if it is possible or not ... So the tool can be created but will not run on all systems and that is acceptable.

Anonymous User

Hi everyone,

Thank you for all of your input. We are currently considering adding the ability to rename fields and change some of the field properties to a future release.

Regards,

Despina M.

MikeGeorge

Having the ability to reorder the fields at the database level would be extremely helpful. I have been using the reorder fields tool from the ArcScripts gallery, has been working with ArcGIS 10 until SP2. Being able to reorder the fields into a more useable workflow (without having to recreate the entire feature class) also helps with custom form development in both ArcPad and ArcGIS Mobile.

NatalieCassar-Pieper

Hi despina, didn't you tell us at UC2011, that in 10.1 it would be possible to rename and change a field? I just installed ArcGIS Desktop 10.1 beta, but I did not find out how to redefine an existing field.

RichardBaker

This would be powerful. Not only changing character limits when you are short three characters for your description but being able to change strings to numeric or back again. I don't know how many times I've had to create a field then copy data to achieve the same result. Here's another idea along the lines of interactive to make it more user friendly, to customize maps using the database data power.

MichaelHickey

I can rename, resequence, and change data type of feature classes and tables - IF the data is a 'personal geodatabase' ... just close ArcGIS and open the personal geodatabase in Access.

Since ESRI and Microsoft seem to be intent to phase out .mdb files, it sure would be nice if this ability were developed by ESRI to work with file geodatabases ... in ArcCatalog

SarahGreenlaw

YES!!!!!!!!!!!!!!!

JoshBrashears

It was nice in the old ArcINFO to be able to add an item while specifying its exact location relative to the other items. It was also nice to be able to alter (rename) items. I wish such capabilities were included in ArcGIS before ESRI deprecates the old ArcINFO!

nathanielgouk

i concur with sgreenl...... yes!!!!!

DebbieBull

It is a strange restriction on inherent database behavior (in SQL Server anyway) not to be able to rename a field/column in a supported way even on unversioned data.

TrinaNair

Like the old ArcInfo7 -> ALTER command.

MikeSweetman

Change a field from optional to mandatory

I know sdetable -o alter_column -x disallow_nulls exists, but I've had troubles using it - the database gets updated but not the SDE column registry.

I'm posting this as well as putting it here. In what I think is the most complex situation - a feature class in a dataset with versioning and archiving in play, and part of a topology rule, you need to work in the following order to avoid difficulties:

1) disable archiving on dataset
2) remove versioning on feature classes referenced by topology
3) delete topology
4) run a python script to create a new version of the feature class, retaining the data and recreating relationship classes lost when the olve version was dropped
5) create topology
6) apply versioning to feature classes referenced by topology
7) run Register as versioned ... at the dataset level
😎 enable archiving on dataset

NoelPeterson

It's absolutely embarassing that this hasn't yet been implemented. Come on, Esri!

DanielGrillo

ESRI should allow the change where it is possible - come on! it is the end of 2016 and a solution is still not here!

TinaMorgan1

If you are using an enterprise geodatabase you can create a database view. You use SQL in the definition to define what fields show up in the view and the order can be defined as well.

For example, if my cities feature class has fields: OBJECTID, NAME, STATE, SHAPE, and all I want to show is STATE then NAME, then I would create a new view with the SQL "select STATE, NAME from cities", and my output view will only have those two fields in that order.

Unfortunately, this is not an option for .mdb (personal) or .gdb (file) geodatabases.

AngelaPollett01

Thanks for the tip Gina. Unfortunately I use file GDB.

Nice to know there are so many helpful people out there though ☺

Cheers, Angela

Angela Pollett

Senior GIS Analyst (Part-time Monday to Thursday)

Spatial Information

Department of Natural Resources & Mines

P: 07 5451 2402 F: 07 5451 2260

E: angela.pollett@dnrm.qld.gov.au<mailto:angela.pollett@dnrm.qld.gov.au>

W: www.dnrm.qld.gov.au<http://www.dnrm.qld.gov.au/>

RichEmerson

I think what most people need is a simple geoprocessing tool that will calculate an "order" field, not necessarily change the underlying RDBMS.

EmilianoTondi

I think a different function directly into table view is needed. Drag and drop field will be perfect to reorder fileds permanently.

Emiliano

Il giorno 3 ott 2018, alle ore 23:34, Rich Emerson <geonet@esri.com> ha scritto:
GeoNet
ArcGIS should allow the ability to permanently reorder fields in a table
new comment by Rich Emerson View all comments on this idea
I think what most people need is a simple geoprocessing tool that will calculate an "order" field, not necessarily change the underlying RDBMS.
Reply to this email to respond to Rich Emerson's comment.
Following ArcGIS should allow the ability to permanently reorder fields in a table in these streams: Inbox
This email was sent by GeoNet because you are a registered user.
You may unsubscribe instantly from GeoNet, or adjust email frequency in your email preferences

WayneRichter

Indeed: Does anyone remember PULLITEMS? Surely ESRI could program something that would accomplish the same.

GraemeBrowning

Yes - see:

and probably many more places 😞

Participe da Conversa

Faça login para publicar, seguir conteúdo e mais. Novo aqui? Registre-se gratuitamente.