Coordinates conversion

I am working over a small component for a web portal that show polygons over a map, using OpenLayers, Google Maps, and another proprietary source .

The user has the points in PSAD56 (UTM) datum and I need to change it to WGS84 in order to use with Google Maps. I have at hand both Oracle 9i without spatial extensions and postgis. Can Oracle locator or Postgis make this transformation? Or is there an open source that can do th开发者_如何学JAVAat?

You could load the user data into Postgis. How you do that depends on which data format they use. shp2pgsql script if the points are available as shapefile.

To transform your geometries into WGS84, you then run

ST_Transform(the_geom,4326)

Bolivia could be either in

• PSAD56 / UTM zone 19S ... EPSG:24879 or
• PSAD56 / UTM zone 20S ... EPSG:24880

You'll have to ask your user.

OpenLayers can also transform between coordinate systems and projections using the Proj4JS library. Note this is probably only viable if you have relatively small amounts of data to transform.