[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] 3dm point table def
From: Masanao Yajima <yajiyajijp () yahoo ! co ! jp>
Date: 2009-10-18 23:35:28
Message-ID: 3a86f2c00910181635u20a331d1p7e6534b0c25873b1 () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Thank you guys!
On Sun, Oct 18, 2009 at 12:40 AM, Paragon Corporation <lr@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@postgis.refractions.net
> [mailto:postgis-users-bounces@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@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@postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
>
> --
> ---
> Jun KOIKE
> jun.july.25@gmail.com
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
--
Masanao Yajima
[Attachment #5 (text/html)]
Thank you guys!<br><br><div class="gmail_quote">On Sun, Oct 18, 2009 at 12:40 AM, \
Paragon Corporation <span dir="ltr"><<a \
href="mailto:lr@pcorp.us">lr@pcorp.us</a>></span> wrote:<br><blockquote \
class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt \
0pt 0.8ex; padding-left: 1ex;"> Yes the ST_AsText() only gives the 2D representation \
even for 3D geometries.<br> Its based on an older OGC standard before 3D was \
introduced into OGC/MM<br> specs.<br>
<br>
Leo<br>
<div><div></div><div class="h5"><br>
-----Original Message-----<br>
From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a><br>
[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a>] \
On Behalf Of Jun<br> Koike<br>
Sent: Sunday, October 18, 2009 12:08 AM<br>
To: PostGIS Users Discussion<br>
Subject: Re: [postgis-users] 3dm point table def<br>
<br>
Hi,<br>
<br>
I've tried your example and got 3-dimension geometry by this query...<br>
SELECT ST_AsEWKT(roads_geom) FROM road;<br>
(Windows+PostgreSQL8.3+PostGIS(I forgot my version...sorry))<br>
<br>
I think geometry itself is inserted well but somehow ST_AsText() gives only<br>
2-dimension geometry...as your result, is this because of WKT specification<br>
on PostGIS???<br>
<br>
Regards,<br>
<br>
2009/10/18 Masanao Yajima <<a \
href="mailto:yajiyajijp@yahoo.co.jp">yajiyajijp@yahoo.co.jp</a>>:<br> > Hi \
list<br> ><br>
> I have question regarding making 3DM point column in PostGIS.<br>
><br>
> When I try to insert POINTM(x,y,m),<br>
> if the dimension of the column is 3 it drops the M dimension, and when<br>
> I make the dimension 4 it asks for the z dimension.<br>
><br>
> How should I make the geometry column to have only x,y,m so I can<br>
> insert POINTM?<br>
><br>
> Here is example of the query<br>
><br>
> CREATE TABLE road(<br>
> road_id INTEGER,<br>
> road_name VARCHAR<br>
> );<br>
> SELECT AddGeometryColumn( 'road', 'roads_geom', -1, \
'GEOMETRY',3 );<br> ><br>
> insert into temptest (road_id, road_name, roads_geom) values<br>
> (21,'test',<br>
> ST_GeomFromEWKT('POINTM(191232 243118 1111)'))<br>
><br>
> select st_astext(roads_geom) from temptest<br>
><br>
> I appreciate your help!<br>
> --<br>
> Masanao Yajima<br>
><br>
> _______________________________________________<br>
> postgis-users mailing list<br>
> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" \
target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br> \
><br> ><br>
<br>
--<br>
---<br>
Jun KOIKE<br>
<a href="mailto:jun.july.25@gmail.com">jun.july.25@gmail.com</a><br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" \
target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br> \
<br> <br>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" \
target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br> \
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Masanao Yajima<br>
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic