Database Reference
In-Depth Information
CROSS JOIN
tempraster
) AS pcr
)
SELECT write_file(ST_AsPNG(raster), '/tmp/
test.png'::text) FROM rasterized;
-- write to file in windows -- comment previous
line and uncomment following line:
-- SELECT write_file(ST_AsPNG(raster),
'c:\temp\test.png'::text) FROM rasterized ;
Ifwechoosetoandarepatient,wemaynowrerunourcodewiththeentiredataset
and get a first level approximation of an orthophoto. A formal orthophoto is on the
left for comparison and our first level approximation from UAS imagery on the right:
As a proof of concept, this process is promising. With forthcoming functions being
addedtoPostGIS,especiallytotherasterfunctionality,weshouldbeabletorefine
these results substantially, for example, by draping the original imagery back to its
appropriate location and rendering it to a high-resolution, photogrammetrically-cor-
rect aerial photograph.
