I've got a MSSQL database that stores JPEG images in a varbinary(max) field. I can of course bring this data into FME desktop with either the SQL Creator or the MSSQL_ADO reader. I also know I can get at the EXIF information using the JPEG reader and exposing those attributes. Where I get stuck is how to get from the fme-binary data into the JPEG reader to expose that meta data. Ultimately I'm trying to extract the GPS coordinates from the JPEG but nothing I've tried has worked. Since this is an ARCmap Feature Attachment table I can't be the first person who wants to extract the timestamp and GPS to verify or update the feature data to which the attachment is associated, but I can't figure it out.
- Contributor
redgeographics wrote:
Are you sure the EXIF is actually stored in the database?
+15- Contributor
ask this question on stack overflow. There are many answers and scripts to read the jpegs from mssql.
(no hits on this forum..yet)
- Contributor
gio wrote:
ask this question on stack overflow. There are many answers and scripts to read the jpegs from mssql.
(no hits on this forum..yet)
Some googling indicates that MSSQL has no native understanding of the jpeg format or the EXIF extension, which means that you'll have to use some specialized software to get at the EXIF data.
This typically means reading the entire jpeg into something like FME or other software that knows what to look for.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.