Thank you guys! On Sun, Oct 18, 2009 at 12:40 AM, Paragon Corporation <[email protected]> wrote:
> 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 > -- Masanao Yajima
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
