Database Reference
In-Depth Information
postgis_cookbook=# SELECT
(ST_VALUE(rast, 1,
ST_SetSRID(ST_Point(12.49, 41.88), 4326))/
10) AS jan,
(ST_VALUE(rast, 2,
ST_SetSRID(ST_Point(12.49, 41.88), 4326))/
10) AS feb,
(ST_VALUE(rast, 3,
ST_SetSRID(ST_Point(12.49, 41.88), 4326))/
10) AS mar,
(ST_VALUE(rast, 4,
ST_SetSRID(ST_Point(12.49, 41.88), 4326))/
10) AS apr,
(ST_VALUE(rast, 5,
ST_SetSRID(ST_Point(12.49, 41.88), 4326))/
10) AS may,
(ST_VALUE(rast, 6,
ST_SetSRID(ST_Point(12.49, 41.88), 4326))/
10) AS jun,
(ST_VALUE(rast, 7,
ST_SetSRID(ST_Point(12.49, 41.88), 4326))/
10) AS jul,
(ST_VALUE(rast, 8,
ST_SetSRID(ST_Point(12.49, 41.88), 4326))/
10) AS aug,
(ST_VALUE(rast, 9,
ST_SetSRID(ST_Point(12.49, 41.88), 4326))/
10) AS sep,
(ST_VALUE(rast, 10,
ST_SetSRID(ST_Point(12.49, 41.88), 4326))/
10) AS oct,
(ST_VALUE(rast, 11,
ST_SetSRID(ST_Point(12.49, 41.88), 4326))/
10) AS nov,
(ST_VALUE(rast, 12,
ST_SetSRID(ST_Point(12.49, 41.88), 4326))/
10) AS dec
FROM chp01.tmax_2012_multi WHERE rid IN
Search WWH ::




Custom Search