I have a table with thousands of addresses开发者_JAVA技巧 as points. Is there a function in postgis that will allow me to get a bounding polygon around these points and return it as a polygon?
This question already has answers here: Migrate SPATIAL data from Oracle to开发者_StackOverflow社区 Postgresql
I am using PostgreSQL with the GIS exten开发者_如何学JAVAsion to store map data, together with OpenLayers, GeoServer etc. Given a polygon, e.g. of a neighborhood, I need to find all LAT/LONG points st
Last month I\'ve installed PostgresSql 8.4.1 and Postgis 1.4 via开发者_运维问答 macports on my Mac with Leopard(10.5), and everything just worked fine. I then updated to Snow Leopard(10.6) and still e
My goal is to display various shapes(polygons, points, linestring) on google maps by using data entered into a Postgis database dynamically(i mean by that we can see modifications in the map in real t
I am trying to put a SHP file into my PostGIS database, the the data is just a little off. I think this is because I am using the wrong SRID. The contents of the PRJ file are as follows: