Hi, 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 that?
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.
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
You'll have to ask your user.