Re: [Geotools-gt2-users] Writing to a postgis database with 4 dimensional coordinates

Diego Jesus Wed, 19 Oct 2011 03:06:52 -0700

Hello and thanks for the replies,

I have found an alternative solution: Instead of using geotools to create 4D coordinates, I used postgis to force whatever geometry I want to write to be in 4D. Here's some code:

Geometry mGeometry = factory.createPoint(new Coordinate(100, 101, 102));
st = con.prepareStatement("INSERT INTO \""+TABLE_NAME+"\" " +
                                            "("+THE_GEOM+") " +
                                            "VALUES (ST_Force_4D(ST_GeomFromText(?, 20791)))", PreparedStatement.RETURN_GENERATED_KEYS);

st.setString(1, g.mGeometry.toText());

I convert the geometry to Well Known Text and in the SQL statement I convert it back to a geometry and force it to use 4D. It may be a work around but I believe it is working.

Diego

Mark Payne
October 19, 2011 10:27 AM

Hi Diego,

I had to do a bit of work with 4D coordinates and what I found out was
that all the JTS classes used for building geometries (Coordinate, and
those supplied to implement the interfaces CoordinateSequence and
CoordinateSequenceFactory) are inherently 3D only.

If you want to use 4D you have to provide some kind of 4D coordinate
class, and implementations of CoordinateSequence and
CoordinateSequenceFactory that know how to populate it. Fortunately in
the full source download of JTS there is a package called
com.vividsolutions.jtsexample.geom that has examples of how to do this.

Note that in the version of JTS I downloaded (1.11) there was a bug in
ExtendedCoordinateSequence.java; the switch statements in
setOrdinate(int, int, double) is missing break statements after each case.

Mark

------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2d-oct
_______________________________________________
Geotools-gt2-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users

------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2d-oct

_______________________________________________
Geotools-gt2-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users

Re: [Geotools-gt2-users] Writing to a postgis database with 4 dimensional coordinates

Reply via email to