Skip to main content
Solved

How do i bring in Geotiff into a spl spatial database and retain values.

  • November 15, 2019
  • 1 reply
  • 97 views

Forum|alt.badge.img

I'm trying to bring a geotiff into an Azure sql spatial database and it only seems to give me a polygon. Any thoughts.

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.

View original
Did this help you find an answer to your question?

1 reply

daveatsafe
Safer
Forum|alt.badge.img+19
  • Safer
  • Best Answer
  • November 15, 2019

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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings