topic Using SQL to access RASTERBLOB? in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/using-sql-to-access-rasterblob/m-p/801826#M2661 <HTML><HEAD></HEAD><BODY><P>The old ST_Raster (until 10.5) had the possibility to access the raster data directly using SQL-Queries (<A href="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"><SPAN style="color: #0066cc; text-decoration: underline; ">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</SPAN></A>). Is there a similar way when working with the new RASTERBLOB data type?</P><P>My reason for asking: We would like to automate raster-analysis (exraction of single pixel values and calculation of zonal statistics) using SQL Triggers.</P><P></P><P>Using Enterprise Geodatabase on MS SQL Server.</P></BODY></HTML> Wed, 29 Jul 2020 16:09:04 GMT FlorianSteiner 2020-07-29T16:09:04Z Using SQL to access RASTERBLOB? https://community.esri.com/t5/geodatabase-questions/using-sql-to-access-rasterblob/m-p/801826#M2661 <HTML><HEAD></HEAD><BODY><P>The old ST_Raster (until 10.5) had the possibility to access the raster data directly using SQL-Queries (<A href="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"><SPAN style="color: #0066cc; text-decoration: underline; ">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</SPAN></A>). Is there a similar way when working with the new RASTERBLOB data type?</P><P>My reason for asking: We would like to automate raster-analysis (exraction of single pixel values and calculation of zonal statistics) using SQL Triggers.</P><P></P><P>Using Enterprise Geodatabase on MS SQL Server.</P></BODY></HTML> Wed, 29 Jul 2020 16:09:04 GMT https://community.esri.com/t5/geodatabase-questions/using-sql-to-access-rasterblob/m-p/801826#M2661 FlorianSteiner 2020-07-29T16:09:04Z