[postgis-users] One server, several map projections

[Nicklas Avén]

Hallo

> Which is the best solution to cope with the different map projections?
> - Several databases with the same map projection each one?
No, then you will get problems when quering tables in differnt
databases.

> - One database in WGS84, and reprojecting data each time people use
> each project?
No, that will give you a poor performance to always project "on the fly"

Why not keep the data in the right projection in the same database.

You can have different projections in different columns in the same
table. You can even have different projection on different rows since
the srid is stored on geometry level. But that is not recomended since
it will give huge problems with the client.

Regards
/Nicklas
> 
> Thank you very much! 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users