Hello, I have a BLOB field, it is supposedly multiple points that form a polyline, but I cannot export the blob into a usable geometry. I have tried GeometryReplacer and GeometryExtractor but I have not been able to get usable results. I attached an excel file with the BLOBs
Solved
Blob field in SQL Server to usable Geometry
Best answer by david_r
The only way I was able to get the GeometryReplacer to return anything else than an error was by first removing the "0x" prefix and treat it like a QlikMaps Encoded Polyline. However the result doesn't make much sense (to me):
I think the key here is to know how the geometry is encoded in the blob, or at the very least know which software is used to manipulate it.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
Hi @morijlumos,
Do you know what format the BLOB geometry is in?
I am fairly certain it is supposed to be points
+19- Safer
- 1637 replies
I am fairly certain it is supposed to be points
From that info, it appears to be a set of points in each record, but the key thing to know is how is it binary encoded. The GeometryReplacer in FME supports several kinds of binary geometries: FME Binary (likely not the case), OGC WKB and SQL Server Binary. I have tried all those, and none of them seem to be the encoding used.
- 8394 replies
- Best Answer
The only way I was able to get the GeometryReplacer to return anything else than an error was by first removing the "0x" prefix and treat it like a QlikMaps Encoded Polyline. However the result doesn't make much sense (to me):
I think the key here is to know how the geometry is encoded in the blob, or at the very least know which software is used to manipulate it.
Thanks! It looks like after all that there doesn't seem to be much useable data in there at all, or its something that ESRI doesn't want to show us!