What's the format of the Shape column blob in a mobile geodatabase?

2587
11
12-21-2020 02:10 PM
KirkKuykendall1
Occasional Contributor III

Hi -

With 2.7, I created a mobile geodatabase with a simple webmercator polygon featureclass in it.

Using Microsoft.Data.Sqlite, I'm able to read the byte array, but both GeometryEngine.ImportFromEsriShape and ImportFromWKB throw an exception.

Anyone know what the format of the byte array is?

Thanks, Kirk

Tags (1)
0 Kudos
11 Replies
KirkKuykendall1
Occasional Contributor III

It turns out the dlls from MyEsri are actually Sqlite extensions, even though Esri doesn't call them that.

Dlls for Windows and linux can be downloaded from MyEsri under Database Support.  

myesri1.PNG

I'm able to call SqliteConnection.LoadExtension, passing the path to the dll, and then query the featureclass with ST_AsText.  Except for the dll, there are no other Esri dependencies.

 

SELECT ST_AsText(shape) from MyPolygons

 

I'm assuming that all the ST_Geometry functions described here will work with only the dll, but have not verified.

What are Esri's restrictions for re-distributing this dll?

 

PatrickMcColl
New Contributor

Hi Kirk,

I have the same problem with Shape column blob in a mobile geodatabase, looked everywhere and can't find any info.

Did you find the binary format used in the blob?

 

Thank you,

Patrick McColl

 

 

0 Kudos