I'm trying to bring a geotiff into an Azure sql spatial database and it only seems to give me a polygon. Any thoughts.
Solved
How do i bring in Geotiff into a spl spatial database and retain values.
Best answer by daveatsafe
Hi @brianapeters,
FME's SQL Server writers do not support raster data, so the geometry is being converted to the bounding box of the image.
If you would like to store the image in a BLOB field, you can do so using the RasterExtractor to extract the raster geometry into a blob attribute, in any of the popular image formats, then write that attribute to a BLOB field in the output table.
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.
+20- Safer
- Best Answer
Hi @brianapeters,
FME's SQL Server writers do not support raster data, so the geometry is being converted to the bounding box of the image.
If you would like to store the image in a BLOB field, you can do so using the RasterExtractor to extract the raster geometry into a blob attribute, in any of the popular image formats, then write that attribute to a BLOB field in the output table.