SQL Server geography type imports as standalone table to ArcGIS Pro

374
2
04-21-2022 01:23 PM
Labels (1)
LisaL
by
New Contributor

I am using ArcPro 2.8.2.  I connected to my SQL Server database.  In ArcMap, I used to drag and drop a SQL table full of line geography types and lines would appear in the map.  In ArcPro, when I add the geography table to the map, all I get is a stand-alone table -- which is pointless.  I have a primary key on the table.  Do I need to do something special for ArcPro to recognize it?

ie.  geography field value:  

0xE610000001146666666666E6494071AB20063A4D60C03333333333E34940F69672BE584E60C0

0 Kudos
2 Replies
KimGarbade
Occasional Contributor III

I have similar data in a SQL Server EGDB and when I drag the table onto my map in Pro 2.8.5 I do see the lines. 

KimGarbade_0-1650631793736.png

KimGarbade_2-1650631916737.png

I know that's not helpful, but it points to an implication that it can work and we can find a solution.

If you open the table in SQL Server, what data type is your geometry being stored in?

KimGarbade_3-1650632077677.png

When you right click the table in your Catalog pane and click properties what does it show for Geometry Type and Storage:

KimGarbade_1-1650637198234.png

 

 

Mike_I
by Esri Contributor
Esri Contributor

Hello @LisaL,

Are you working with a table or feature class? How was the table originally created?

Have you checked if the table is registered with the geodatabase? See this documentation: Register with Geodatabase (Data Management)

You could also consider using the Migrate Storage geoprocessing tool to change the current geometry type to one more recognizable by ArcGIS Pro such as ST_Geometry. See this documentation: Migrate Storage (Data Management)

If the Migrate Storage option is used, it would be recommended to make a database backup beforehand.

Cheers,

Mike

Data Management Specialist, Esri Support Services
0 Kudos