<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic PostGre ST_RASTER Error getValue in Geodatabase Questions</title>
    <link>https://community.esri.com/t5/geodatabase-questions/postgre-st-raster-error-getvalue/m-p/806176#M2893</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi&lt;/P&gt;&lt;P&gt;when i execute&amp;nbsp;&lt;/P&gt;&lt;P&gt;SELECT getValue(raster,1,0,se_coord(-75,4)) r, &lt;BR /&gt;FROM &lt;STRONG&gt;&lt;SPAN style="color: #ff0000;"&gt;[Scheme].[RasterDataSet]&lt;/SPAN&gt; &lt;/STRONG&gt;WHERE raster_id(raster) = 1;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;the GDB say:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;NOTICE: ESRI: ST_Coord start&lt;BR /&gt;NOTICE: ESRI: ST_Coord end&lt;BR /&gt;NOTICE: ESRI: ST_Raster_getValue start&lt;BR /&gt;NOTICE: ESRI: prepare SELECT count(*) FROM INFORMATION_SCHEMA.tables WHERE lower(TABLE_CATALOG) = current_database() AND lower(TABLE_SCHEMA) = current_schema() AND lower(TABLE_NAME) = lower($1) &lt;BR /&gt;NOTICE: ESRI: prepare returned success&lt;BR /&gt;NOTICE: ESRI: prepare select srid from sde.sde_raster_columns where rastercolumn_id = $1&lt;BR /&gt;NOTICE: ESRI: prepare returned success&lt;BR /&gt;NOTICE: ESRI: prepare &lt;STRONG&gt;select row_nbr, col_nbr, block_data from &lt;SPAN style="color: #ff0000;"&gt;sde_blk_22&lt;/SPAN&gt;&lt;/STRONG&gt; where rasterband_id = $1 and rrd_factor = $2 and row_nbr &amp;gt;= $3 and row_nbr &amp;lt;= $4 and col_nbr &amp;gt;= $5 and col_nbr &amp;lt;= $6&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;the last select dont have [Scheme] and does not run well&lt;/P&gt;&lt;P&gt;the correct sentence id&amp;nbsp;&lt;STRONG&gt;select row_nbr, col_nbr, block_data from &lt;SPAN style="color: #ff0000;"&gt;[Scheme].sde_blk_22&amp;nbsp;&lt;/SPAN&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000;"&gt;&lt;STRONG&gt;but the sentence is controlled by ST_Raster Lib&lt;/STRONG&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Thu, 24 Aug 2017 17:22:06 GMT</pubDate>
    <dc:creator>FabianHeredia</dc:creator>
    <dc:date>2017-08-24T17:22:06Z</dc:date>
    <item>
      <title>PostGre ST_RASTER Error getValue</title>
      <link>https://community.esri.com/t5/geodatabase-questions/postgre-st-raster-error-getvalue/m-p/806176#M2893</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi&lt;/P&gt;&lt;P&gt;when i execute&amp;nbsp;&lt;/P&gt;&lt;P&gt;SELECT getValue(raster,1,0,se_coord(-75,4)) r, &lt;BR /&gt;FROM &lt;STRONG&gt;&lt;SPAN style="color: #ff0000;"&gt;[Scheme].[RasterDataSet]&lt;/SPAN&gt; &lt;/STRONG&gt;WHERE raster_id(raster) = 1;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;the GDB say:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;NOTICE: ESRI: ST_Coord start&lt;BR /&gt;NOTICE: ESRI: ST_Coord end&lt;BR /&gt;NOTICE: ESRI: ST_Raster_getValue start&lt;BR /&gt;NOTICE: ESRI: prepare SELECT count(*) FROM INFORMATION_SCHEMA.tables WHERE lower(TABLE_CATALOG) = current_database() AND lower(TABLE_SCHEMA) = current_schema() AND lower(TABLE_NAME) = lower($1) &lt;BR /&gt;NOTICE: ESRI: prepare returned success&lt;BR /&gt;NOTICE: ESRI: prepare select srid from sde.sde_raster_columns where rastercolumn_id = $1&lt;BR /&gt;NOTICE: ESRI: prepare returned success&lt;BR /&gt;NOTICE: ESRI: prepare &lt;STRONG&gt;select row_nbr, col_nbr, block_data from &lt;SPAN style="color: #ff0000;"&gt;sde_blk_22&lt;/SPAN&gt;&lt;/STRONG&gt; where rasterband_id = $1 and rrd_factor = $2 and row_nbr &amp;gt;= $3 and row_nbr &amp;lt;= $4 and col_nbr &amp;gt;= $5 and col_nbr &amp;lt;= $6&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;the last select dont have [Scheme] and does not run well&lt;/P&gt;&lt;P&gt;the correct sentence id&amp;nbsp;&lt;STRONG&gt;select row_nbr, col_nbr, block_data from &lt;SPAN style="color: #ff0000;"&gt;[Scheme].sde_blk_22&amp;nbsp;&lt;/SPAN&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000;"&gt;&lt;STRONG&gt;but the sentence is controlled by ST_Raster Lib&lt;/STRONG&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 24 Aug 2017 17:22:06 GMT</pubDate>
      <guid>https://community.esri.com/t5/geodatabase-questions/postgre-st-raster-error-getvalue/m-p/806176#M2893</guid>
      <dc:creator>FabianHeredia</dc:creator>
      <dc:date>2017-08-24T17:22:06Z</dc:date>
    </item>
  </channel>
</rss>

