archiveren

Tagarchief: postgis

postgis setting to shift from the bessel ellipsoid to the wgs84 ellipsoid for the dutch national coordinate system:

update 
   spatial_ref_sys 
set proj4text =
       '+proj=sterea +lat_0=52.15616055555555 
        +lon_0=5.38763888888889 +k=0.999908 
        +x_0=155000 +y_0=463000 +ellps=bessel 
        +units=m 
        +towgs84=565.2369,50.0087, 465.658, 
        -0.406857330322398,0.350732676542563,
        -1.8703473836068,4.0812 
        +no_defs' 
where 
   srid=28992;

This fix corrects issues in Google Maps, Google Earth and other wgs84 based coordinate systems.