[postgis-users] z,m,zm geometries

[Duarte Carreira]

Hi there.

I'm trying to convert from esri's st_ geometry type to postgis' one.

I can't convert to wkt using esri's functions and build a geometry in
postgis using geomfromtext.

Problems start when there are z, m, or zm coordinates. Mind that I'm on
postgis 1.4 since that's the latest supported by esri.

Now, when I convert from esri using their function I get a text like:

LINESTRING Z ...

When I pass it to geomfromtext, or even st_geomfromewkt, postgis does not
like this...

I posted on esri's forum and got a slap in the hand saying postgis is not
following the ogc standard...

I've done some reading and all I could find are references to POINTZ,
POLYGONZ, etc. (suffixes withouth spaces) in v.1.2.0 of the standard. But
this does not seem to be the spec for encoding wkt, just the geometry type
to be put into geometry_columns. Either way, I could not get postgis 1.4 to
accept pointz or any other geometryz type. I found references to postgis
2.0 doing this... but that is beyong my grasp for now.

So my 2 questions are:

 - is there anyway i can get this to work in postgis 1.4 (main question)?
 - and as long as we're in the subject, how is this related to the ogc sfs
spec? are "they" right?

Thanks for your time!

Regards,
Duarte
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120515/8003c006/attachment.html>