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).

[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:

• https://community.esri.com/thread/3944#comment-118525
• https://community.esri.com/ideas/1362?commentID=66221#comment-31823
• https://community.esri.com/ideas/1362?commentID=66221#comment-45373

and probably many more places 😞

[PeterSchoenfield]

2018 and counting.

[TimMinter]

Hmm.  I note that there is a "Refactor Fields" tool in an available GIS toolset that might be employed in a Rube Goldberg-inspired workflow to change field orders in geospatial data tables.  Might be worth a look.

[BrianQuinn]

I stopped trying to do this. Now, I write a single spatial SQL query to PostGIS and visualise in QGIS. I get the attributes that I want in one step. I can export to share back to ArcGIS Pro users

Brian B. Quinn

brian.quinn@sfgov.org

[MichaelHickey]

If the data is in a Personal geodatabase (pGdB)(aka MS_Access), open the

attribute table in Access, go to "Designer View" and rename fields,

change attributes, reorder fields and SAVE ... all will be OK in ESRI IF

you do NOT add/delete records.

This is true for SQL_Express database (xGdB) using SQL Management

Studio ... probably also true for data in MS_SQL enterprise geodatabases

(eGdB) ... My paranoia has not let me do that ... I copy from the eGdB

to xGdB, make my changes and then copy the data back...

If the schema changes are SO EASY with MS_Access &

MS_SQL_Management_Studio, why can't ESRI do it (connect to Microsoft

code) to do this in Microsoft format databases?

Mike Hickey

Tulare County IT/GIS

mhickey@co.tulare.ca.us

>>> Brian Quinn <geonet@esri.com> 11/9/2018 11:34 AM >>>

GeoNet

(

https://urldefense.proofpoint.com/v2/url?u=https-3A__community.esri.com_-3Fet-3Dwatches.email.idea-5Fcomment&d=DwMCaQ&c=LlH32oy6OBtmot7tcUOx1EUIJYTUxwihlBYC0z2BYZI&r=nsfEMcjBFLgy5lOkWNlnx4hbv1QDMkIeeTQyHknewM4&m=ghbpuIPEc4n_xujbW3HRLWYZgSt-dB-CXNNr-CmomBI&s=iFrd8TcCToeUfkQQs547x3EKZWu0mBwiEhA6Q6odfPU&e=)

ArcGIS should allow the ability to permanently reorder fields in a

table new comment by Brian Quinn

(

https://urldefense.proofpoint.com/v2/url?u=https-3A__community.esri.com_people_bbq&d=DwMCaQ&c=LlH32oy6OBtmot7tcUOx1EUIJYTUxwihlBYC0z2BYZI&r=nsfEMcjBFLgy5lOkWNlnx4hbv1QDMkIeeTQyHknewM4&m=ghbpuIPEc4n_xujbW3HRLWYZgSt-dB-CXNNr-CmomBI&s=XGkkBR03t4LKi0EpBIdzjAObFKXbeWtvOMTtQrbdl9o&e=)

View all comments on this idea

(

https://urldefense.proofpoint.com/v2/url?u=https-3A__community.esri.com_ideas_1362-3FcommentID-3D67368-23comment-2D67368&d=DwMCaQ&c=LlH32oy6OBtmot7tcUOx1EUIJYTUxwihlBYC0z2BYZI&r=nsfEMcjBFLgy5lOkWNlnx4hbv1QDMkIeeTQyHknewM4&m=ghbpuIPEc4n_xujbW3HRLWYZgSt-dB-CXNNr-CmomBI&s=6IpyGmCN7XvizLqhLodmiBTOiijT_PD2bqC6QHw3Jwk&e=)

I stopped trying to do this. Now, I write a single spatial SQL query

to PostGIS and visualise in QGIS. I get the attributes that I want in

one step. I can export to share back to ArcGIS Pro users

Brian B. Quinn

brian.quinn@sfgov.org

Reply to this email to respond to Brian Quinn's comment.

Following ArcGIS should allow the ability to permanently reorder fields

in a table

(

https://urldefense.proofpoint.com/v2/url?u=https-3A__community.esri.com_ideas_1362-3FcommentID-3D67368-26et-3Dwatches.email.idea-5Fcomment-23comment-2D67368&d=DwMCaQ&c=LlH32oy6OBtmot7tcUOx1EUIJYTUxwihlBYC0z2BYZI&r=nsfEMcjBFLgy5lOkWNlnx4hbv1QDMkIeeTQyHknewM4&m=ghbpuIPEc4n_xujbW3HRLWYZgSt-dB-CXNNr-CmomBI&s=XVTqSKkl8h5TG2Zx7Sh5GQWTkT9i0oaV9rTclcw88mA&e=)

in these streams: Inbox

This email was sent by GeoNet because you are a registered user.

You may unsubscribe

(

https://urldefense.proofpoint.com/v2/url?u=https-3A__community.esri.com_unsubscribe.jspa-3Femail-3Dmhickey-2540co.tulare.ca.us-26token-3Da093a907f4dfc58a9d87b5f592a8de49e7463eeef829ea2f5220ff061641b572&d=DwMCaQ&c=LlH32oy6OBtmot7tcUOx1EUIJYTUxwihlBYC0z2BYZI&r=nsfEMcjBFLgy5lOkWNlnx4hbv1QDMkIeeTQyHknewM4&m=ghbpuIPEc4n_xujbW3HRLWYZgSt-dB-CXNNr-CmomBI&s=0MzqsUOCNcHgvP-N-sDK8Z3rRtdLvIG0-hyJ0yjVvIc&e=)

instantly from GeoNet, or adjust email frequency in your email

preferences

(

https://urldefense.proofpoint.com/v2/url?u=https-3A__community.esri.com_user-2Dpreferences-21input.jspa&d=DwMCaQ&c=LlH32oy6OBtmot7tcUOx1EUIJYTUxwihlBYC0z2BYZI&r=nsfEMcjBFLgy5lOkWNlnx4hbv1QDMkIeeTQyHknewM4&m=ghbpuIPEc4n_xujbW3HRLWYZgSt-dB-CXNNr-CmomBI&s=sscQJ0vl6e43pL41cUIvXQhLFzoe35teXH_PU32BPnQ&e=)

[HelenJohnson]

I think it would be incredibly helpful to be able to permanently reorder fields in a table.  Right now, I use the X-Ray add-in for ArcCatalog to reorder fields.  It has problems, such as dropping subtypes, but is currently the easiest method I have come across.  The add-in includes a reororder fields tool.  See links below:

Item page: https://www.arcgis.com/home/item.html?id=9ea218ff575f4a5195e01a2cae03a0ae 

Intro Video:  Introduction to X-Ray for ArcCatalog Video | Esri 

xraytools‌ #xray

[CattyannCampbell]

I don’t see ESRI making this happen since they have pretty much stopped development on ArcGIS Desktop

And pushing ArcCatalog on everyone.

[RDHarles]

We've been discussing/arguing about not having this feature at least since Esri adopted python in 2005.  It's been almost 15 years!  If it hasn't happened by now, pretty sure it's not going to happen!!  I think it's funny(?) that this thread is tagged "Under Consideration".  This thread is 9 years old!