topic SQL Server geography type imports as standalone table to ArcGIS Pro in Data Management Questions

SQL Server geography type imports as standalone table to ArcGIS Pro

LisaL — Thu, 21 Apr 2022 20:23:28 GMT

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

Re: SQL Server geography type imports as standalone table to ArcGIS Pro

KimberlyGarbade — Fri, 22 Apr 2022 14:21:42 GMT

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.

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?

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

Re: SQL Server geography type imports as standalone table to ArcGIS Pro

Anonymous User — Wed, 04 May 2022 18:50:02 GMT

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