<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: arial,helvetica,sans-serif; font-size: 10pt; color: #000000'><style>p { margin: 0; }</style><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt; color: #000000">Good morning,<br><br>first of all I want to thank the PostGIS community for the great job she does.<br><br>I am a french user of postgis since 2006 and it helps us a lot in our mission to preserve landscapes and biodiversity.<br>Since a few month we use rasters function in order to characterize species distribution.<br><br>I have a problem with 1 of 5 raster table containing a dem.<br>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. <br><br>Is there a way to run this command, skipping the error.<br><br>Here is the query : <br><br>UPDATE export.tous_point_espece_selon_format_esri SET pente_mnt = ST_VALUE(rast, geometrie, true)<br>
FROM raster.pente_mnt30 <br>
WHERE code_insee LIKE '30%'<br><br>And here is the error (sorry it's in french)<br><br>ERREUR: syntaxe en entrée invalide pour l'entier : « NaN » <br>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 <br><br>Thanks again,<br><br>Mathieu Bossaert<br><br><div><span></span>--<br><font style="color: rgb(102, 102, 102);" size="1"><em>Mathieu BOSSAERT</em><br style="font-style: italic;"><em>Responsable du </em><a style="font-style: italic;" href="http://si.cenlr.org/" target="_blank">système d'information</a></font><font style="font-weight: bold; font-style: italic; color: rgb(102, 102, 102);" size="1"> du CEN L-R</font><br><font style="font-style: italic; color: rgb(102, 102, 102);" size="1">04 67 29 90 65 - sig@cenlr.org</font><br><img src="http://sig.cenlr.org/_media/signature-courriel_mathieu.jpg" dfsrc="http://sig.cenlr.org/_media/signature-courriel_mathieu.jpg"><br><span></span><br></div></div></div></body></html>