Hi @morijlumos,

Do you know what format the BLOB geometry is in?

It is varbinary(max)

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.

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!