Hi David,

Edgar Soldin wrote a very useful plugin that can help you with that:
http://soldin.de/about/2004-jump_plugins/

CTS extension.

You just have to put the correct values into $OJHOME/lib/ext/cs.conf
You can get those out of spatial_ref_sys table from your postgis-enabled database (srtext column)

With this you can work in metric-based projection and after your done re-project it back to wgs84 and save it in whatever format you use.

HTH,
Pedro Doria Meunier.

Davi Pires wrote:
Hi all,

I am developing an application that uses google maps as a front-end
and postgis in the backend. Currently, we are using google mercator
projection (SRID = 4326) for all geometries in the database. But,
since we perform lots of geometric operations with these objects
within the database, I am concerned about performance issues.

Wouldn't it be better if instead of a mercator projection, we stored
all information in metric-based values?
If so, is there any metric-based projection that works in any part of the world?

Thanks for any help.

Davi Pires

_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to