考虑到SQL Server的“geography”数据类型...
我可以将纬度和经度的数组(顺序应该是经度在前,纬度在后还是反之?)输入到字段中,如下所示:
INSERT INTO SpatialZonePolygons (Coordinates)
VALUES (geography::STGeomFromText('POLYGON((-122.358 47.653 , -122.348 47.649, -122.348 47.658, -122.358 47.658, -122.358 47.653))', 4326));
GO
这将显示为:0xE6100000010405000000DD24068195D34740F4FDD478E9965EC0508D976E12D3474083C0CAA145965EC04E62105839D4474083C0CAA145965EC04E62105839D44740F4FDD478E9965EC0DD24068195D34740F4FDD478E9965EC001000000020000000001000000FFFFFFFF0000000003
我该如何将它们重新转换为纬度和经度格式?
STAsText
? - Damien_The_Unbeliever