How Alteryx store spatial data in sqlite and mdb?

Question

I have spatial polygon data in Alteryx that export in sqlite as blob.

After that I tried to read this data with as well known binary in .net.

Unfortunatelly it says, that geometry type is uknown.

So question is, what is type of binary data, that Alteryx export to Sqlite?

nicolesalazar10 · Answer

Hi, I'm trying to do the same as you, but I'm curious to know the workflow you followed to get the output with the field type "geography". I'm trying to do the same but with 'geometry'.

nikolov_k · Answer

Actually, I have some progress here. I found that Alteryx support for projections/srid is quite limited. It is working only for some outputs. Also it is quite dificult to store data in SQL Server as Geography. In most cases format in SQL Server is image and starts with binary 5 0 0 0, it is the same format as the one in SQLite and access mdb.

At the end I succeded to output file to SQL Server as Geography and as second step transfer from SQL Server to SQLite as WKB.

Would be realy nice if Alteryx supports projections/srid on more Output formats.

Hollingsworth · Answer

As to the mdb file containing spatial data, that sounds like it is the ESRI personal geodatabase format.

Both of these formats (GeoPackage and personal geodatabase) seek to answer the problem of portable datasets that conform to modern data typing. By portable, I mean not tied to a server or cloud-based RDBMS.