Hallo liebes Forum,
ich habe folgendes Problem:
Ich habe ein Tabelle mit Polygonen (EPSG: 4326). Die Eingangsdaten liegen in unterschiedlichen Koordinatensystemen vor.
D.h. wenn ich Polygone aus EPSG-Code 31468 ins 4326 transformiere und dann in meine Tabelle importiere, erwarte ich, dass
ich bei der Rücktransformation der Daten aus meiner Tabelle in EPSG-Code 31468 die Polygone ohne Verschiebung zurückbekomme.
Aber:
Bei Daten, die im EPSG-Code 31468 vorliegen bekomme ich eine Abweichung bei der Rücktransformation.
Bei EPSG-Code 3397 nicht. Woran könnte das liegen?
SELECT ST_AsText (ST_Transform(ST_Transform(the_geom,4326),31468)) FROM test_polygon_31468;
SELECT ST_AsText (ST_Transform(ST_Transform(the_geom,4326),3397)) FROM test_polygon_3397;
[TABLE=“width: 512”]
[TR]
[TD]EPSG: 31468
[/TD]
[TD]nach ST_Transform über 4326
[/TD]
[TD]Deviation
[/TD]
[/TR]
[TR]
[TD=“align: right”]4492539,64197082
[/TD]
[TD=“align: right”]4492539,64193947
[/TD]
[TD=“align: right”]0,00003135
[/TD]
[/TR]
[TR]
[TD=“align: right”]5621068,30964302
[/TD]
[TD=“align: right”]5621068,30960137
[/TD]
[TD=“align: right”]0,00004165
[/TD]
[/TR]
[TR]
[TD=“align: right”]4492539,48593203
[/TD]
[TD=“align: right”]4492539,48590068
[/TD]
[TD=“align: right”]0,00003135
[/TD]
[/TR]
[TR]
[TD=“align: right”]5621079,07631938
[/TD]
[TD=“align: right”]5621079,07627772
[/TD]
[TD=“align: right”]0,00004166
[/TD]
[/TR]
[TR]
[TD=“align: right”]4492555,16783021
[/TD]
[TD=“align: right”]4492555,16779884
[/TD]
[TD=“align: right”]0,00003137
[/TD]
[/TR]
[TR]
[TD=“align: right”]5621080,94878483
[/TD]
[TD=“align: right”]5621080,94874317
[/TD]
[TD=“align: right”]0,00004166
[/TD]
[/TR]
[TR]
[TD=“align: right”]4492539,64197082
[/TD]
[TD=“align: right”]4492539,64193947
[/TD]
[TD=“align: right”]0,00003135
[/TD]
[/TR]
[TR]
[TD=“align: right”]5621068,30964302
[/TD]
[TD=“align: right”]5621068,30960137
[/TD]
[TD=“align: right”]0,00004165
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]EPSG: 3397
[/TD]
[TD]nach ST_Transform über 4326
[/TD]
[TD]Deviation
[/TD]
[/TR]
[TR]
[TD=“align: right”]4492539,64197082
[/TD]
[TD=“align: right”]4492539,64197082
[/TD]
[TD=“align: right”]0,00000000
[/TD]
[/TR]
[TR]
[TD=“align: right”]5621068,30964302
[/TD]
[TD=“align: right”]5621068,30964302
[/TD]
[TD=“align: right”]0,00000000
[/TD]
[/TR]
[TR]
[TD=“align: right”]4492539,48593203
[/TD]
[TD=“align: right”]4492539,48593203
[/TD]
[TD=“align: right”]0,00000000
[/TD]
[/TR]
[TR]
[TD=“align: right”]5621079,07631938
[/TD]
[TD=“align: right”]5621079,07631938
[/TD]
[TD=“align: right”]0,00000000
[/TD]
[/TR]
[TR]
[TD=“align: right”]4492555,16783021
[/TD]
[TD=“align: right”]4492555,16783021
[/TD]
[TD=“align: right”]0,00000000
[/TD]
[/TR]
[TR]
[TD=“align: right”]5621080,94878483
[/TD]
[TD=“align: right”]5621080,94878483
[/TD]
[TD=“align: right”]0,00000000
[/TD]
[/TR]
[TR]
[TD=“align: right”]4492539,64197082
[/TD]
[TD=“align: right”]4492539,64197082
[/TD]
[TD=“align: right”]0,00000000
[/TD]
[/TR]
[TR]
[TD=“align: right”]5621068,30964302
[/TD]
[TD=“align: right”]5621068,30964302
[/TD]
[TD=“align: right”]0,00000000
[/TD]
[/TR]
[/TABLE]