Shapefile to Binary SQL Geography field type

paulwini

Hi Everyone,

I have a shapefile, which I would like to publish to SQL. However, I would like the SpatialObj field to be converted to a binary SQL geography field in the output data. The binary SQL geography field for polygons normally start with "0x" and then a long list of characters. Is this possible in Alteryx? I attached a sample workflow in this post.

Thanks!

Paul

Shapefile_Alteryx.yxmd

rkapoor

@paulwini if you can convert the Shapefile into a blob or set of blobs, then you can push a binary file into a SQL Server table for example. This previous post may help you:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Binary-File-to-SQL-Table-using-Alteryx/td-p/503207