Hi,
the EPSG database misses the towgs84 parameters for the Dutch national grid
which are necessary for this to work properly.
I've used the following definition successfully (read here how to change
parameters in the EPSG database
http://docs.codehaus.org/display/GEOSDOC/Hacking+the+EPSG+hsql+database+directly):
(Btw, it's still a shame you can't overrule an existing entry of the EPSG
database through the property file 
)
28992=PROJCS["Amersfoort / RD New", GEOGCS["Amersfoort", DATUM["Amersfoort",
SPHEROID["Bessel 1841", 6377397.155, 299.1528128, AUTHORITY["EPSG","7004"]],
TOWGS84[565.237, 50.0087, 465.658, -0.406857, 0.350733, -1.87035, 4.0812],
AUTHORITY["EPSG","6289"]], PRIMEM["Greenwich", 0.0,
AUTHORITY["EPSG","8901"]], UNIT["degree", 0.017453292519943295],
AXIS["Geodetic longitude", EAST], AXIS["Geodetic latitude", NORTH],
AUTHORITY["EPSG","4289"]], PROJECTION["Oblique Stereographic",
AUTHORITY["EPSG","9809"]], PARAMETER["central_meridian", 5.387638888888891],
PARAMETER["latitude_of_origin", 52.15616055555556],
PARAMETER["scale_factor", 0.9999079], PARAMETER["false_easting", 155000.0],
PARAMETER["false_northing", 463000.0], UNIT["m", 1.0], AXIS["Easting",
EAST], AXIS["Northing", NORTH], AUTHORITY["EPSG","28992"]]
Best regards,
Bart
--
Bart van den Eijnden
OSGIS, Open Source GIS
http://www.osgis.nl
--------- Oorspronkelijk bericht --------
Van: Andrea Aime <aaime@anonymised.com>
Naar: Pieter Minnaar <pieter.minnaar@anonymised.com>
Cc: geoserver-users@lists.sourceforge.net
Onderwerp: Re: [Geoserver-users] Oracle Spatial, GoogleMaps, GeoServer and
the Netherlands projection
Datum: 03/03/08 07:11
Pieter Minnaar ha scritto:
> Hi,
>
> I am trying to do an overlay of Oracle Spatial data in the
Netherlands
> projection system - 28992.
>
> This issue was discussed on this forum in February 2007 (not
> specifically related to Oracle Spatial) and it was then suggested to
> upgrade to 1.5 and this solved the problem.
>
> I am however using GeoServer 1.6 and I still get the error reported
> then: "(about 80 meters north and twenty east)".Hum, GeoServer is now using the official EPSG database for SRS
lookup, so it should be picking the most accurate set of parameters.
What SRS handling have you chosen for your feature type? Force or
reproject? Try playing with that setting.> I think I might need to change the projection in Oracle - I am using
90112.
Which is an Oracle custom projection, not a standard one.
Would you be able to dump your data into a shapefile and send it to me
by private mail? This way I can have a look.
Also, what are you using as a term of comparison for the offsets?
Google Earth?Cheers
Andrea-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users