Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Geopackages: Can Alteryx Open GeoPackage Files (.gpkg)?

DIFM-CIG
5 - Atom

Dear Community,  

 

This has been a very useful forum for gaining knowledge, and this is my first contribution.  

We're a university research group evaluating Alteryx and we have quite a few gpkg files that need ETL to a database.  I did not see anything online about this topic and it doesn't appear that Alteryx can open these files.   Is there a workaround or a tool? 

 

Please advise, 

 

Thanks!

 

Keith  

  

 

9 REPLIES 9
DIFM-CIG
5 - Atom

Really?   Nothing on this?

Hollingsworth
11 - Bolide
11 - Bolide

GeoPackage files can be read by Alteryx by forcing the input file type to be SQLite. That is the foundational data format.

However, the geometry data is stored as a Geometry Binary Format. I've yet to determine how to decode that data.

So you can import and see the attribute data, but at present, I don't have a solution to convert the geometry data to a format Alteryx can read.

However, this is certainly a worthwhile avenue for pursuit.

John Hollingsworth
Clear Channel Outdoor
Hollingsworth
11 - Bolide
11 - Bolide

Adding this link to the spec for WKBGeometry byte streams for reference.

 

https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.spatial.doc/ids_spat_285.htm

John Hollingsworth
Clear Channel Outdoor
AdamR
Alteryx
Alteryx

By a strange co-incidence I also find myself wanting to open a gpkg file today. I am currently trying to use the ogr2ogr tool from gdal to convert my file to a shapefile. I will report back if I am successful.

Adam Riley
Principal Software Engineer
Tech Lead Core Engines, Alteryx
Hollingsworth
11 - Bolide
11 - Bolide

Any update on your progress @AdamR ? Enquiring minds want to know. 🙂

John Hollingsworth
Clear Channel Outdoor
AdamR
Alteryx
Alteryx

Yes. Sorry I forgot to report back. I got ogr2ogr to work converting my file to a shapefile using the below command.

 

ogr2ogr -f "ESRI Shapefile" output_folder osopenusrn_202103.gpkg

Adam Riley
Principal Software Engineer
Tech Lead Core Engines, Alteryx
ngavish
5 - Atom

This feature would be very helpful, much official data comes only in Geopackage format nowadays. Currently the geometry is not readable by Alteryx and shows up as gibberish:

 

 

Capture.PNG

 

Converting to shapefile is hardly an alternative, geopackage is specifically meant to be able to handle bigger data (that shapefile cannot) as well as store multiple tables and geometries. 

Hollingsworth
11 - Bolide
11 - Bolide

@ngavish, I dug a little and found that there are other output format options.

 

https://gdal.org/programs/ogr2ogr.html?highlight=format_name

 

And I wholeheartedly agree that this needs to be added. I'll create an idea post.

John Hollingsworth
Clear Channel Outdoor
Hollingsworth
11 - Bolide
11 - Bolide

I have added this as an idea. https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Add-GeoPackage-geospatial-data-format-to-the...

 

Please like.

Also shouting out to my SpACEals, @CharlieS , @Deanna , @Samanthaj_hughes for some love for this idea.

John Hollingsworth
Clear Channel Outdoor
Labels