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

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

Connectors

Spatial Analysis

Accepted answers

All comments

DIFM

Really? Nothing on this?

Hollingsworth

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.

Hollingsworth

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

ngavish

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:

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

@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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703