I have a table in a SQL database that has been spatially enabled with a geography column.
In ArcGIS it is a line feature and can be viewed in ArcMap with no issues and even published as a map service with ArcGIS for Server.
However, neither the feature when it is in ArcMap or as a map service in a web app is able to be selected through the map. It can be selected through the attribute table.
I have adjusted and tested all selection settings in ArcMap. I have exported the data out as a shapefile an it works correctly. I have another table in the same SQL database that is a point feature and it works correctly.
Has anyone experienced this before or know of any esri bug related to this?
I have rebuilt the table using geometry instead of geography - no change.
There is one feature that can be selected, it is the only feature west of the prime meridian.
UPDATE 2 (in response to comments):
1- Not sure about spatial indexes with SQL Spatial tables, please advise what i should be looking for?
2- I added the table to ArcMap from the database connection made in ArcCatalog, it calculated the extent on import, and maintained the correct spatial reference information as below:
The data also draws in the correct locations.
3- The table does have an objectID field. The table is not in a geodatabase, it is in SQL Server.
Have found the below known issue. Not exactly what I am experiencing but similar. I adjusted the data to only be inside one hemisphere and it is still not working.
Have tested the same data in Blue Marble Global Mapper, and it works correctly. Looking like an esri bug.