postgis « postgresql « Java Database Q&A





1. PreparedStatement is not reading all my parameters for PostGIS Geography    stackoverflow.com

I have the following JDBC code. Note that I am attempting to use PostGIS geography:

PreparedStatement stmt = db.prepareStatement("INSERT INTO " +
          ...

2. Reading points from a Geography Polygon in a PostGIS database    stackoverflow.com

My goal: To read the points from a Geography Polygon stored in my PostGIS database. The PostGIS manual has a great example of how to extract a Polygon from ...

3. Every sets of values in a record should be unique?    stackoverflow.com

I have a database storing a pair of x,y coordinates on each records. I have already generated 1000 points. However, how can I make sure there's no duplicate points ...