admin 管理员组

文章数量: 1086019

i need to help with, data conversion

My wkb data in varbinary column db º Ça µ³A7ɹè UA! Eo µ³A / } UA é Y µ³A UAT¶hD µ³A UA é#M µ³Aküì¿ UAº Ça µ³A % UAT¶8\ µ³AÓbSJ UAº Ça µ³A7ɹè UA ÿÿÿÿ

after transformation i have

POLYGON ((330634849.77778208 5527063.6363394773, 330634863.27153212 5527073.9550894788, 330634841.04653209 5527100.1488394774, 330634820.40903211 5527088.2425894784, 330634829.14028209 5527042.998839478, 330634849.77778208 5527044.5863394774, 330634844.22153211 5527073.1613394795, 330634849.77778208 5527063.6363394773))

i used follow query - 0 i dont know originall SRID

SELECT geometry::STGeomFromWKB(mo.GEO_DATA, 0).STAsText() AS WKTGeometry FROM MAPA_OBJEKTY mo WHERE mo.FK_BASE_RECORD = 541109;

final polygon is correct but different place,

original place is somewhere in cz - but my is ocean or chinese

Thank you

本文标签: epsgWKBWKTEPGS map transformationStack Overflow