Question

Creating lines from (possible) WKD strings

  • 24 February 2023
  • 2 replies
  • 0 views
scarter
Rank
Badge +7

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.

2 replies

redgeographics
Rank
Userlevel 5
Badge +25

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.

hkingsbury
Rank
Userlevel 5
Badge +29

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

Check out the Abley FME Firesides on Youtube: https://www.youtube.com/@ableyltd

Reply


Community Stats

28,709
Posts
109,481
Replies
36,554
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.