[postgis-users] LinestringZ not valid

[Sandro Santilli]

On Mon, Oct 22, 2012 at 09:40:46AM -0700, ps.tiara wrote:
> Hello,
> 
> I've tried to make a linestring with z value as below
> 
> select st_isvalid(a.p), st_isvalid(b.q)
> from (select st_geomfromtext ('LINESTRING Z(0 0 0, 1 0 0)') as p) as a,
> (select st_geomfromtext('LINESTRING Z(0 0 0, 0 0 1)') as q) as b
> 
> the result shows that linestring from table b is not valid,,it's caused too
> few points..
> is it impossible to make linestring (0 0 0, 0 0 1) ? how to make it valid?

No, not possible. Vertical lines are not supported by the 2.5d model.

--Strk;

 http://www.cartodb.com - Map, analyze and build applications with your data

                                       ~~ http://strk.keybit.net