[Benchmarking] WKT for 900913

[Frank Warmerdam]

Martin,

I have filed:

  http://trac.osgeo.org/gdal/ticket/4178

on this issue, and will incorporate a fix upstream this morning.   Others
will need to (possibly manually) fixup the PostGIS instance in question.

Best regards,

On Thu, Jul 28, 2011 at 3:37 AM, Martin Daly <Martin.Daly at cadcorp.com> wrote:
> The WKT for 900913 in spatial_ref_sys was:
>
> PROJCS["Popular Visualisation CRS / Mercator (deprecated)",GEOGCS["Popular Visualisation CRS",DATUM["Popular_Visualisation_Datum",SPHEROID["Popular Visualisation Sphere",6378137,0,AUTHORITY["EPSG","7059"]],TOWGS84[0,0,0,0,0,0,0],AUTHORITY["EPSG","6055"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4055"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],PROJECTION["Mercator_1SP"],PARAMETER["central_meridian",0],PARAMETER["scale_factor",1],PARAMETER["false_easting",0],PARAMETER["false_northing",0],AUTHORITY["EPSG","3785"],AXIS["X",EAST],AXIS["Y",NORTH]]
>
> Can you spot the mistake? The EBNF element order is wrong (EBNF sequences having strict order according to ISO/IEC 14977).
>
> The correct WKT is:
>
> PROJCS["Popular Visualisation CRS / Mercator (deprecated)",GEOGCS["Popular Visualisation CRS",DATUM["Popular_Visualisation_Datum",SPHEROID["Popular Visualisation Sphere",6378137,0,AUTHORITY["EPSG","7059"]],TOWGS84[0,0,0,0,0,0,0],AUTHORITY["EPSG","6055"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4055"]],PROJECTION["Mercator_1SP"],PARAMETER["central_meridian",0],PARAMETER["scale_factor",1],PARAMETER["false_easting",0],PARAMETER["false_northing",0],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["X",EAST],AXIS["Y",NORTH],AUTHORITY["EPSG","3785"]]
>
> See? Much better. The first two parts - PROJCS and GEOGCS - are correct, but then the order *must* be: PROJECTION; (optional) PARAMETER(s); UNIT; (optional) AXIS(es?); (optional) AUTHORITY.
>
> I have updated the database with that WKT.
>
> IMHO the PostGIS spatial_ref_sys.sql will also need to be fixed, as will whatever produced this WKT: I'm guessing OGR. Just MHO though.
>
> Regards,
> Martin
>
> ****************************************************************************
> This email is confidential and may be privileged and should not be used, read
> or copied by anyone who is not the  original intended recipient. If you have
> received this email in error  please inform the sender and delete it from
> your mailbox or any other storage mechanism. Unless specifically stated,
> nothing in this email constitutes an offer by Cadcorp and Cadcorp does not
> warrant that any information contained in this email is accurate.
> Cadcorp cannot accept liability for any statements made which are clearly the
> sender's own and not expressly made on behalf of Cadcorp or one of its agents.
> Please rely on your own virus check. No responsibility is taken by Cadcorp
> for any damage arising out of any bug or virus infection.
> ****************************************************************************
>
> _______________________________________________
> Benchmarking mailing list
> Benchmarking at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/benchmarking
>



-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Software Developer