Timeline for PostGIS raster geoTiff simple Lat/Lon query example
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 8, 2016 at 10:48 | vote | accept | Jason | ||
| Mar 7, 2016 at 15:14 | answer | added | Pierre Racine | timeline score: 2 | |
| Mar 7, 2016 at 11:09 | comment | added | Jason | Thanks, but "exclude_nodata_value" does not seem make any difference either it is set to TRUE of FALSE, unless I am doing it the wrong way: 'SELECT ST_Value( rast, ST_SetSRID(ST_MakePoint(0,51.5),4326), TRUE ) AS rast_val FROM my_raster' or 'SELECT ST_Value( rast, ST_SetSRID(ST_MakePoint(0,51.5),4326), FALSE ) AS rast_val FROM my_raster' | |
| Mar 4, 2016 at 15:13 | comment | added | John Powell | It looks correct. You don't really need the WHERE clause, though I imagine the query parser will convert the query into something that doesn't actually call ST_Value twice. You could probably handle that more elegantly using exclude_nodata_value true/false that is built into the function. | |
| Mar 4, 2016 at 10:03 | history | asked | Jason | CC BY-SA 3.0 |