You may want to check out http://postgis.refractions.net/docs/ST_Force_2D.html.
For example, you could add a new column containing the 2D representation.
SELECT ST_AddGeometryColumn('myschema','mytable', '2d_geom',4326,'POLYGON',2);
UPDATE you table SET 2d_geom = ST_Force_2D(the_geom);
Regards
Edward
Date: Mon, 29 Oct 2012 14:57:18 -0200
From: [email protected]
To: [email protected]
Subject: [Geoserver-users] Problem when publish postgis data from geoserver
I'm tried create services reading my postgis database using geoserver 2.2When i
try execute layer preview shows this error log
http://pastebin.com/dgezB4fV
This error "WGS 84 (geocentric)" has 3 dimensions, while 2 was expected." shows
because my database has 3d features, if yes how can i transform this 3D
features in 2D features, thanks
Thanks..
Jairo de Almeida
email: [email protected]
skype: jairodealmeida
------------------------------------------------------------------------------
The Windows 8 Center - In partnership with Sourceforge
Your idea - your app - 30 days.
Get started!
http://windows8center.sourceforge.net/
what-html-developers-need-to-know-about-coding-windows-8-metro-style-apps/
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
------------------------------------------------------------------------------
The Windows 8 Center - In partnership with Sourceforge
Your idea - your app - 30 days.
Get started!
http://windows8center.sourceforge.net/
what-html-developers-need-to-know-about-coding-windows-8-metro-style-apps/
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
