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! :
Search WWH ::




Custom Search