Database Reference
In-Depth Information
To filter our PRISM rasters, we use
ST_Intersects()
to keep only those raster
tilesthatspatiallyintersectSanFrancisco'sboundaries.Wealsoremoveallrasters
whoserelevantmonthisnotJune,July,orAugust.Wethenuse
ST_AddBand()
to
createanewrasterwitheachsummermonth'snewrasterband.Finally,wepassthe
combined raster to
ST_AsTIFF()
to generate a GeoTIFF.
Ifyououtputthereturnedvaluefrom
ST_AsTIFF()
toafile,run
gdalinfo
onthat
file.The
gdalinfo
outputshowsthattheGeoTIFFfilehasthreebandsandtheco-
ordinate system of SRID 4322.
Driver: GTiff/GeoTIFF
Files: surface.tif
Size is 20, 7
Coordinate System is:
GEOGCS["WGS 72",
DATUM["WGS_1972",
SPHEROID["WGS
72",6378135,298.2600000000045,
AUTHORITY["EPSG","7043"]],
TOWGS84[0,0,4.5,0,0,0.554,0.2263],
AUTHORITY["EPSG","6322"]],
PRIMEM["Greenwich",0],
UNIT["degree",0.0174532925199433],
AUTHORITY["EPSG","4322"]]
Origin =
(-123.145833333333314,37.937500000000114)
Pixel Size =
(0.041666666666667,-0.041666666666667)
Metadata:
AREA_OR_POINT=Area
Image Structure Metadata:
INTERLEAVE=PIXEL
Corner Coordinates:
Upper Left (-123.1458333, 37.9375000) (123d
8'45.00"W, 3
7d56'15.00"N)
