Skip to main content
  • EN

Hello Group,

 

I'm wanting to see if I can can create lines from what may be well known binary (WKB) strings (e.g.: 0xE61000000114297C137101D7B2BFE65D8A76C0BF494030842DCBFFD3B2BF70EC7899C0BF4940). To be honest I'm not 100% certain that they are WKB.

 

I have a csv containing these potential WKB values. The workspace is...

 

Creator>

FeatureReader (reads in the csv setting the field called 'sp_geography', which contains the WKB value to varchar>

GeometryReplacer (with encoding as OGC Well Known Binary and the geometry source set to 'sp_geography').

 

When I run it all 171 records goi to the Rejected port. There's a curious blue message in the log:

 

"Invalid WKB encountered.

... Last line repeated 170 times ..."

 

This is odd as the WKD values in the csv are, as far as I can see, all unique.

To be honest, it looks like your data isn't WKB at all. The start of that string doesn't match what the first characters of a WKB string would contain.

The "Last line repeated 170 times" refers to the message of "Invalid WKB encounted", not the data. So its saying there were 171 instances of an invalid WKB

Reply


Community Stats

30,409
Posts
115,533
Replies
38,216
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.