Yes the ST_AsText() only gives the 2D representation even for 3D geometries. Its based on an older OGC standard before 3D was introduced into OGC/MM specs.
Leo -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jun Koike Sent: Sunday, October 18, 2009 12:08 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] 3dm point table def Hi, I've tried your example and got 3-dimension geometry by this query... SELECT ST_AsEWKT(roads_geom) FROM road; (Windows+PostgreSQL8.3+PostGIS(I forgot my version...sorry)) I think geometry itself is inserted well but somehow ST_AsText() gives only 2-dimension geometry...as your result, is this because of WKT specification on PostGIS??? Regards, 2009/10/18 Masanao Yajima <[email protected]>: > Hi list > > I have question regarding making 3DM point column in PostGIS. > > When I try to insert POINTM(x,y,m), > if the dimension of the column is 3 it drops the M dimension, and when > I make the dimension 4 it asks for the z dimension. > > How should I make the geometry column to have only x,y,m so I can > insert POINTM? > > Here is example of the query > > CREATE TABLE road( > road_id INTEGER, > road_name VARCHAR > ); > SELECT AddGeometryColumn( 'road', 'roads_geom', -1, 'GEOMETRY',3 ); > > insert into temptest (road_id, road_name, roads_geom) values > (21,'test', > ST_GeomFromEWKT('POINTM(191232 243118 1111)')) > > select st_astext(roads_geom) from temptest > > I appreciate your help! > -- > Masanao Yajima > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > -- --- Jun KOIKE [email protected] _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
