[postgis-users] Get ST_Value results from a tiled raster

[Bborie Park]

Pierre's response is probably the correct one.  You need the WHERE
clause as the ST_Value is being run upon every tile in that table.

-bborie

On 06/29/2012 02:38 PM, Robin Wilson wrote:
> Hi bborie,
> 
> Thanks for the idea. I've set up the logging and checked and only one query is being sent by the client. I've also checked the code used by the client, which simply runs one query and gets the results.
> 
> Does anyone have any idea why this may be happening?
> 
> Cheers,
> 
> Robin
> 
> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> 
> Robin,
> 
> I can't say for certain but it looks like your client (not psql) is
> sending off multiple queries.  The nulls would return if the point being
> sampled isn't in any of the tiles.
> 
> You could enable statement logging (log_statement) in PostgreSQL to see
> what statements are being run from your connector.
> 
> http://www.postgresql.org/docs/9.0/interactive/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT
> 
> -bborie
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 

-- 
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkpark at ucdavis.edu