Database Reference
In-Depth Information
Whenwecall
ST_Transform()
ontheMODISraster,weonlypassthedestination
SRID 2163
.Wecouldspecifyotherparameters,suchasthe
resampling algorithm
and
error tolerance
. The default resampling algorithm and error tolerance are set
to
NearestNeighbor
and
0.125
. Using a different algorithm and/or lowering the
errortolerancemayimprovethequalityoftheresampledrasteratthecostofmore
processing time.
Let'stransformtheMODISrasteragain,thistimespecifyingtheresamplingalgorithm
anderrortoleranceas
Cubic
and
0.05
respectively.Wealsoindicatethatthetrans-
formed raster must be aligned to a reference raster.
SELECT ST_Transform(ST_Clip(m.rast,
ST_Transform(sf.geom, 96974)), prism.rast,
'cubic', 0.05)
FROM modis m
CROSS JOIN prism
CROSS JOIN sfpoly sf
WHERE prism.rid = 1;
UnlikethepriorquerieswherewetransformtheMODISraster,let'screateanover-
view.An
overview
isalowerresolutionversionofthesourceraster.Ifyouarefamili-