[postgis-users] 3dm point table def

[Paragon Corporation]

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