After creating a feature class, it would be convenient to go back after data input, and make changes to the field ordering (position).
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
Indeed: Does anyone remember PULLITEMS? Surely ESRI could program something that would accomplish the same.
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.
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
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=)
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
I don’t see ESRI making this happen since they have pretty much stopped development on ArcGIS Desktop
And pushing ArcCatalog on everyone.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.