Database Reference
In-Depth Information
SELECT gid,
ST_BUFFER("Chp11".lines.geom_sp, 75) AS
the_geom, fullname FROM "Chp11".lines
WHERE fullname <> ''
AND hydroflg = 'Y'
The preceding query is shown in the following screenshot:
The preceding query selects the lines on the map that represent hydrology
unitssuchas
"hydroflg" = 'Y'
andstreams.Theselectedstreamlines
(whichusetheStatePlanegeometry)arebufferedby75feet,whichshould
yield a result like that shown in the following screenshot:
