Database Reference
In-Depth Information
3734, which is a State Plane Coordinate system that measures projections in feet.
To run SQL queries, follow the ensuing steps:
1. Click on the
SQL window
buttonin the DB Manager:
2. Copy the following query into the SQL window and then click on
Execute
:
SELECT AddGeometryColumn('Chp11',
'lines','geom_sp',3734,
'MULTILINESTRING', 2);
UPDATE "Chp11".lines SET geom_sp =
ST_Transform(geom,3734);
The query creates a new geometry column named
geom_sp
, and then up-
datesthegeometryinformationbytransformingtheoriginalgeometry(
geom
)
from EPSG 4269 to 3734:
3. Refresh the
Chp11
schema and you'll notice that the table in the database
now has two geometry columns that are treated independently in the
Tree
window: