ESdat Forums
»
Forums
»
ESdat
»
Linking ArcGIS directly to ESdat database
Rank: Member
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
|
|
|
|
Rank: Administration
Groups: Registered, Administrators Posts: 498 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
|
|
|
|
Rank: Member
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
|
|
|
|
Rank: Administration
Groups: Registered, Administrators Posts: 498 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
|
|
|
|
ESdat Forums
»
Forums
»
ESdat
»
Linking ArcGIS directly to ESdat database
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.