It would be very handy if you can choose the spatial column when you add data to ArcMap if there are more as one.
Copy and paste data between databases in ArcGIS—Help | ArcGIS for Desktop
I'm stuck: I can't envision a scenario where you would end up with two spatial columns in one table that makes any sense. I'm shocked that ESRI even allows there to be more than one shape column in a table.
Example. One row with original geometry, a second with generalized geometry. You show now scale dependent the best geometry. You prevent data redundancy or the fact to define materialized views. There are solutions but it could be easier.
Your generalized geometry is only appropriate in a narrow range of scales, so you have an entire redundant column just for those scales. At every other scale, you are going to use the original geometry, so why the extra storage?
Plus, you've opened up the issue of users using the wrong column, and then they think the data is of poor quality and not reliable. I have this issue all the time with older datasets where someone added an area field and manually calculated the areas for the features. Now that it is in a geodatabase (with an area field), I still have users who want to use the old area field even though no one has maintained it (and before anyone asks why I don't remove it, I'm not the data owner, so I'm not allowed).
On top of that, you've now opened up the issue that every geoprocessing tool, Select by Location, etc., will have to ask which column should it use for the geometry it need to run for every single input that accept a feature.
I understand that you do not agree. I did my thought on our situation. There are ways to prevent this situation. We now and use them. Sorry to touch a sore spot. That's my last contribution to this idea.
A few other scenarios where we might have multiple geometry columns in a database table or view (not necessarily registered with a geodatabase):
I'm shocked that ESRI even allows there to be more than one shape column in a table.
I have a related idea here: ArcGIS should ignore non-FC columns
I'm thinking that one may want to make one spatial query layer for each geometry column in the table.
As a result, one would have the same number of layers representing that table as the number of geometry columns.
Just in case, here is how we can query for the spatial columns in a table that's not registered with the geodatabase:https://desktop.arcgis.com/en/arcmap/latest/manage-data/using-sql-with-gdbs/geometry-columns.htm
Relevant forum in qgis:https://gis.stackexchange.com/questions/109599/how-to-display-a-table-with-more-than-one-geometry-co...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.