|

»

3dm point table def

View: New views

4 Messages — Rating Filter: Alert me

	3dm point table def by Masanao Yajima-2 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message 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 postgis-users@... http://postgis.refractions.net/mailman/listinfo/postgis-users
	Re: 3dm point table def by Jun Koike :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message 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 <yajiyajijp@...>: > 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 > postgis-users@... > http://postgis.refractions.net/mailman/listinfo/postgis-users > > -- --- Jun KOIKE jun.july.25@... _______________________________________________ postgis-users mailing list postgis-users@... http://postgis.refractions.net/mailman/listinfo/postgis-users
	Re: 3dm point table def by Paragon Corporation-2 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message 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: postgis-users-bounces@... [mailto:postgis-users-bounces@...] 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 <yajiyajijp@...>: > 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 > postgis-users@... > http://postgis.refractions.net/mailman/listinfo/postgis-users > > -- --- Jun KOIKE jun.july.25@... _______________________________________________ postgis-users mailing list postgis-users@... http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@... http://postgis.refractions.net/mailman/listinfo/postgis-users
	Re: 3dm point table def by Masanao Yajima-2 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Thank you guys! On Sun, Oct 18, 2009 at 12:40 AM, Paragon Corporation <lr@...> 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: postgis-users-bounces@... [mailto:postgis-users-bounces@...] 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 <yajiyajijp@...>: > 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 > postgis-users@... > http://postgis.refractions.net/mailman/listinfo/postgis-users > > -- --- Jun KOIKE jun.july.25@... _______________________________________________ postgis-users mailing list postgis-users@... http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@... http://postgis.refractions.net/mailman/listinfo/postgis-users -- Masanao Yajima _______________________________________________ postgis-users mailing list postgis-users@... http://postgis.refractions.net/mailman/listinfo/postgis-users