[postgis-users] st_value/st_world2rastercoordx error
Mathieu Bossaert (CEN L-R)
sig at cenlr.org
Tue Jul 31 02:09:44 PDT 2012
Good morning,
first of all I want to thank the PostGIS community for the great job she does.
I am a french user of postgis since 2006 and it helps us a lot in our mission to preserve landscapes and biodiversity.
Since a few month we use rasters function in order to characterize species distribution.
I have a problem with 1 of 5 raster table containing a dem.
When I try to populate an elevation attribute of a point layer from this raster I get an error. To workaround this problem I use pg-script to run this update line after line.
Is there a way to run this command, skipping the error.
Here is the query :
UPDATE export.tous_point_espece_selon_format_esri SET pente_mnt = ST_VALUE(rast, geometrie, true)
FROM raster.pente_mnt30
WHERE code_insee LIKE '30%'
And here is the error (sorry it's in french)
ERREUR: syntaxe en entrée invalide pour l'entier : « NaN »
CONTEXTE : PL/pgSQL function "st_world2rastercoordx" lors de la conversion de la valeur de retour au type de retour de la fonction PL/pgSQL function "st_value" line 13 at RETURN
Thanks again,
Mathieu Bossaert
--
Mathieu BOSSAERT
Responsable du système d'information du CEN L-R
04 67 29 90 65 - sig at cenlr.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120731/323199be/attachment.html>
More information about the postgis-users
mailing list