Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
dyu  
#1 Posted : Friday, September 4, 2020 12:03:10 AM(UTC)
dyu
Rank: Member

Reputation:

Groups: Registered
Posts: 11

Hi,

We are testing to use ArcGIS Pro (2.6.0) to read directly table (Locations). We found that we can not see the point and attributes. We are wondering the column CoordGeography (type is geography) is the standard SQL Server Geography type or is the ESdat proprietary type?

Thanks,

Daniel

Edited by moderator Thursday, November 5, 2020 3:21:18 PM(UTC)  | Reason: Not specified

Warwick Wood  
#2 Posted : Friday, September 4, 2020 4:36:10 PM(UTC)
Warwick Wood
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 498
Man
Location: Byron Bay

Was thanked: 19 time(s) in 19 post(s)

Hi Daniel,

It's a standard SQL Server geography column type.  However if it has a value then you can also read it from the Latitude and Longitude columns, which would be more straightforward.

If your Latitude / Longitude values are Null check you have entered x and y coord values for the Location and have specified a Coordinate System for the Site.

Warwick

dyu  
#3 Posted : Friday, October 23, 2020 1:18:59 AM(UTC)
dyu
Rank: Member

Reputation:

Groups: Registered
Posts: 11

Hi Warwick,

As today we are using ArcGIS Pro (2.6.2) to connect to Location table and it displays point properly but when we click attribute table, it showed below error message. Even there is no point data in the table we still got below message. I work with ESRI few sessoins and export this table to another brand new DB and it worked. So we are wondering is there any ESdat built-in function to prevent showing attribute table from external application like ArcGIS Pro. Any information will be appreciated.

A .NET Framework error occurred during execution of user-defined routine or aggregate "geography": Microsoft.SqlServer.Types.GLArgumentException: 24205: The specified input does not represent a valid geography instance because it exceeds a single hemisphere. Each geography instance must fit inside a single hemisphere. A common reason for this error is that a polygon has the wrong ring orientation.

Thanks,

Daniel

Warwick Wood  
#4 Posted : Friday, October 23, 2020 6:33:17 AM(UTC)
Warwick Wood
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 498
Man
Location: Byron Bay

Was thanked: 19 time(s) in 19 post(s)

Hi Daniel,

If you're using ArcGIS to read directly from the ESdat database, you can select which Table/Views you want to read, but I'm not aware that you can restrict the Fields/Columns in those tables that should be shown in ArcGIS, ie they all get included.

Another option would be to create a new View in the database and only include the Fields you want. You can then link ArcGIS to that View.  

Regards,

Warwick

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.