Database Reference
In-Depth Information
04 | 18.5
05 | 22.9
06 | 27
07 | 30
08 | 29.8
09 | 26.4
10 | 21.7
11 | 16.6
12 | 12.9
(12 rows)
6. Adifferentapproachistostoreeachmonthvalueinadifferentrasterband.
The
raster2pgsql
commanddoesn'tletyouloadtodifferentbandsinan
existing table. But, you can use GDAL by combining the
gdalbuildvrt
andthe
gdal_translate
commands.First,use
gdalbuildvrt
tocreate
a new virtual raster composed of 12 bands, one for each month:
$ gdalbuildvrt -separate tmax_2012.vrt
worldclim/tmax*.bil
7. Analyze the
tmax_2012.vrt xml
file with a text editor. It should have a
virtual band (
VRTRasterBand
) for each physical raster pointing to it:
<VRTDataset rasterXSize="2160"
rasterYSize="900">
<SRS>GEOGCS...</SRS>
<GeoTransform>
-1.8000000000000006e+02,
1.6666666666666699e-01,
...</GeoTransform>
<VRTRasterBand dataType="Int16"
band="1">
<NoDataValue>-9.99900000000000E+03</NoDataValue>
<ComplexSource>
<SourceFilename
relativeToVRT="1">worldclim/
tmax01.bil</SourceFilename>
