AnsweredAssumed Answered

Using SQL to access RASTERBLOB?

Question asked by FSteiner on Jul 29, 2020

The old ST_Raster (until 10.5) had the possibility to access the raster data directly using SQL-Queries (https://desktop.arcgis.com/en/arcmap/10.5/manage-data/using-sql-with-gdbs/a-quick-tour-of-sql-functions-used-with-st-raster.htm). Is there a similar way when working with the new RASTERBLOB data type?

My reason for asking: We would like to automate raster-analysis (exraction of single pixel values and calculation of zonal statistics) using SQL Triggers.

 

Using Enterprise Geodatabase on MS SQL Server.

Outcomes