[Geoserver-devel] Google projection... 900913, 3875, 3785, oh my...

Hi,
I'm looking into adding working support for the official
EPSG code for the Google projection but I'm having some issues...
maybe it's just too hot and I cannot think straight... but
as far as I can see the latest and greatest version of EPSG database,
version 7.1, does not contain code 3875, which is touted to be the
new official code in some mail messages in this ml as well as
some blog posts like this one:
http://ollie.blogs.splintdev.geog.ucl.ac.uk/2009/06/spherical-mercator-maps-in-openlayers-28/

The Postgres sql script does not contain any 3875 code, but
it contains the 3785 instead, which some places report to be
the "old and superceded" version of 3875... hmmm... do we
have people living in the future around here?

Here is what I have instead:

INSERT INTO epsg_coordinatereferencesystem VALUES ( 3785,
'Popular Visualisation CRS / Mercator',
3544,
'projected',
4499,
Null,
4055,
19847,
Null,
'Certain Web mapping and visualisation applications.',
'Uses spherical development. Relative to an ellipsoidal development errors of up to 800 metres in position and 0.7% in scale may arise. Some applications call this WGS 84. It is not a recognised geodetic system: see WGS 84 / World Mercator (CRS code 3395)',
'Microsoft.',
'OGP',
'2008-03-14',
'2008.114',
1,
1 );

To support this I'll have to create a new project class, as
EPSG decided to make a custom projection for it that we don't
have, whilst for 900913 Martin decided to add an extra parameter
to an existing one... oh well...

Cheers
Andrea

--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.

Andrea Aime ha scritto:

Hi,
I'm looking into adding working support for the official
EPSG code for the Google projection but I'm having some issues...
maybe it's just too hot and I cannot think straight... but
as far as I can see the latest and greatest version of EPSG database,
version 7.1, does not contain code 3875, which is touted to be the
new official code in some mail messages in this ml as well as
some blog posts like this one:
http://ollie.blogs.splintdev.geog.ucl.ac.uk/2009/06/spherical-mercator-maps-in-openlayers-28/

The Postgres sql script does not contain any 3875 code, but

Never mind, found it... it's 3857, not 3875

Cheers
Andrea

--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.