[postgis-users] degree vs. metric projection performance?

[Pedro Doria Meunier]

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
>
>