[postgis-users] 3dm point table def

Masanao Yajima yajiyajijp at yahoo.co.jp
Sun Oct 18 16:35:28 PDT 2009


Thank you guys!

On Sun, Oct 18, 2009 at 12:40 AM, Paragon Corporation <lr at pcorp.us> 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 at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] 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 at yahoo.co.jp>:
> > 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 at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
>
> --
> ---
> Jun KOIKE
> jun.july.25 at gmail.com
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-- 
Masanao Yajima
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20091018/3dced592/attachment.html>


More information about the postgis-users mailing list