Database Reference
In-Depth Information
The preceding screenshot shows the created geometry. The following
screenshot shows the original geometry.
4. Forournextquery,letustakeasubsetofthe
lines
table.Similartowhat
wedidintheprecedingsection,wewillonlylookatthedataabouttheroads.
However, this time, we can limit the columns that we want to load with the
layer,aswellasperformmorecomplicatedspatialqueries.We'llapplyabuf-
fer of 10 feet using the new geometry column (
geom_sp
), by executing the
following command:
SELECT gid, ST_Buffer(geom_sp, 10) AS
geom, fullname, roadflg FROM
"Chp11".lines WHERE roadflg = 'Y'
Checkthe
Load as new layer
checkbox,andthenselect
gid
astheunique
idand
geom
asthegeometry.Createanameforthelayerandthenclickon
Load Now!
: