Database Reference
In-Depth Information
Thus returning:
LINESTRING Z (2 0 0,2 1 0)
LINESTRING Z (1 2 0,0 2 0)
LINESTRING Z (2 1 0,1 1 0)
LINESTRING Z (0 0 0,2 0 0)
LINESTRING Z (1 1 0,1 2 0)
LINESTRING Z (0 2 0,0 0 0)
Thenextstepistoconstructalinerepresentingtheboundaryoftheextruded
wall
,
as follows:
threeDline AS
(
SELECT ST_MakeLine(
ARRAY[
ST_StartPoint(the_geom),
ST_EndPoint(the_geom),
ST_Translate(ST_EndPoint(the_geom), 0, 0,
$2),
ST_Translate(ST_StartPoint(the_geom), 0, 0,
$2),
ST_StartPoint(the_geom)
]
)
AS the_geom FROM splodedLine
),
Now, we need to convert each linestring to a polygon.
threeDwall AS
(
SELECT ST_MakePolygon(the_geom) as the_geom
FROM threeDline
),
