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.
daveatsafe wrote:
Hi @morijlumos,
Do you know what format the BLOB geometry is in?
It is varbinary(max)
daveatsafe wrote:
Hi @morijlumos,
Do you know what format the BLOB geometry is in?
I am fairly certain it is supposed to be points
+19- Safer
morijlumos wrote:
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.
- 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!
Reply
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.