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.
Question
How do I read EXIF information from a database?
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.
- Contributor
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
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.