Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Input and Output Spatial Objects from/to .SQLITE files

I have a big need to input files created in a .sqlite format and also write out to files as .sqlite that contain spatial object fields.  Currently they are not recognized as spatial objects.  BlobConvert is not able to convert the spatial fields from the input correctly (it gets close) so the result is that we are unable to utilize any spatial fields from or to these files.

2 Comments
sphwillis
7 - Meteor
you can convert them in QGIS to SHP format which can be read by Alteryx. commandline tool like OGR may work too. 
http://docs.qgis.org/

Simon
NickPa
Alteryx Alumni (Retired)

Hi,

 

Typically users are storing spatial data in SQLite for mobile use cases.  Can you please elaborate the data (stored as sqlite) that you're intending to bring into Alteryx, what you will do with that data, and then downstream use of that exported SQLite data?  We need more context before we can research this further.


Thanks