AnsweredAssumed Answered

Shapefile Shape field to SQL geometry Data Type

Question asked by sotriant on Apr 23, 2019
Latest reply on Apr 25, 2019 by vangelo-esristaff

I am using Arcpy and ArcGIS 10.4.1. Is there any way to parse a shapefile's Shape field and get the value in the following format; 0xE6100000010CF091A1F8EB67354050B8D91D27644440.

 

Currently i am storing in native sql server using the following query; insert into [TABLE_NAME] (Shape) SELECT geometry::Point(21.405944385000055, 40.782443744000034 , 4326)

 

i.e

# Get data from shapefile
with arcpy.da.SearchCursor(table, ['Shape']) as cursor:
         for row in cursor:
                  Shape = row[0]

                  print Shape

>>>>(21.405944385000055, 40.782443744000034)

And i want it to be 0xE6100000010CF091A1F8EB67354050B8D91D27644440

Outcomes