Hi,

I'm trying to understand the status of 3D geometries in PostgreSQL/PostGIS. I'm 
examining the 3D tests in the  in the jdbc-postgis module.

I see two problems with the testing framework; the first it assumes only 2D 
geometries. Perhaps some hint for the required dimension (2D or 3D) in the 
FeatureType or passed to the schema constructor is needed. See JDBC3DTest. 
checkCreateSchemaAndInsert(), JDBCDataStore.createSchema(), 
BasicSQLDialect.postCreateTable() and PostGISDialect.postCreateTable() for 
points of interest.

The second problem is that JTS Geometry.toText() (and toString()) only creates 
a string representation containing 2D points despite the data having 3D. I have 
no obvious suggestion here apart from creating a utility method to examine the 
geometry and create our own string representation. There might be something 
that does this already or a start in the right direction.

Are these points correct in regards to 3D geometries in PostgreSQL/PostGIS? I 
would like to get 3D geometries in PostGIS working in GeoTools. Are there other 
areas of immediate concern?

Brett

Brett Walker <brett.wal...@geometryit.com<mailto:brett.wal...@geometryit.com>>
Software Developer / Analyst
Geometry Pty Ltd

Telephone               03 6223 1999
Mobile                     0458 498 386
Fax                          03 6223 1988
Web                        www.geometryit.com<http://www.geometryit.com/>
Address                   31 Salamanca Square, Battery Point, TAS 7004, 
Australia

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel

Reply via email to