[gdal-dev] Export image binary data from GDB dataset

[Even Rouault]

Andrea,

looking with an hexadecimal editor, one sees the strings "Fotografia di 
Photo Editor", "MSPhotoEd.3", so it seems to be Microsoft Photo Editor 
format. According to 
https://stackoverflow.com/questions/43902205/microsoft-photo-editor-conversion-file-signatures 
, it might be a OLE based format containing JPEG files. So you might try 
tools that extract the content from OLE, and/or look for content between 
the FF D8 marker for the start of JPEG content and FF D9 for end of JPEG 
file

Even

Le 15/11/2023 à 12:49, andy via gdal-dev a écrit :
> Hi,
> I have a Binary field in a GDB data source.
>
> I have no other metadata about it. I know only that the field name is 
> "image", then it should contain images.
> But I do not know the original file format.
>
> I have extract one row (and then one field) as string it, using
>
> ogr2ogr -f CSV /vsistdout/ -fieldTypeToString Binary data.gdb 
> SITI_ARCHEO -where "OBJECTID=277" >out.csv
>
> And I have a long string as the one below.
> I have tried to use "xxd -r -p" to convert to binary and then use 
> "file" to interpret its file format, but I don't get anything useful.
>
> How could I do some reverse extraction of these images in their 
> original format?
>
> Thank you
>
> 151C3B00020000001B000C0014002F00FFFFFFFF466F746F6772616669612064692050686F746F20456469746F72004D5350686F746F45642E330001050000020000000C0000004D5350686F746F45642E33000000000000000000000E0900D0CF11E0A1B11AE1000000000000000000000000000000003E000300FEFF09000600000000000000000000000A0000000100000000000000001000000200000001000000FEFFFFFF0000000000000000040000000500000006000000070000004502000046020000470200004802000049020000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 
> ...
>
> -- 
> ___________________
>
> Andrea Borruso
> website: https://medium.com/tantotanto
> 38° 7' 48" N, 13° 21' 9" E, EPSG:4326
> ___________________
>
> "cercare e saper riconoscere chi e cosa,
>  in mezzo all’inferno, non è inferno,
> e farlo durare, e dargli spazio"
>
> Italo Calvino
>
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/gdal-dev

-- 
http://www.spatialys.com
My software is free, but my time generally not.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20231115/06b510f1/attachment.htm>