Question

地图绘制世界新一米,I m试图将SQ服务器地理线一栏改成纬度点,以利用地图。

The line is being set like this

Set @GeoPoly = geography::STGeomFromText( LINESTRING( +@Polyline+ ) ,4326)

任何人都知道如何这样做? 预收

Answer 1

我有幸这样做:

DECLARE @g geography;
SET @g = geography::STLineFromText(
    LINESTRING(-122.360 47.656, -122.343 47.656 ) 
    , 4326
); 
SELECT @g.STPointN(1).ToString(), @g.STPointN(2).ToString();

Answer 2

您界线只包括一个连接两点的直线部分? 如果是的话,你可以检索这些要点的纬度和长度:

SELECT
  @GeoPoly.STStartPoint.Lat AS Start_Lat,
  @GeoPoly.STStartPoint.Long AS Start_Long,
  @GeoPoly.STEndPoint.Lat AS End_Lat,
  @GeoPoly.STEndPoint.Long AS End_Long;

如果你的分界线由多个直线部分组成,连接一系列的点,那么,你就可以利用“TtoString()”方法检索好Known文本代表,然后通过把 resulting子分开,将由此造成的扼制成协调奶制品:

SELECT @GeoPoly.ToString()

其结果将采用以下格式: Lat1, Lon2, Lat2, ......, Lonn, Latn

Answer 3

您可以通过将STasText(STasText)(SPLIT)、CROSS AppLY(CROSS)和UBING_AGG(AG)合并来做到这一点。这方面的一个例子是:

WITH Links AS (
    SELECT Id, REPLACE(REPLACE(PosList.STAsText(),  LINESTRING ( ,   ),  ) ,   ) as points_string
    FROM LinkSequenceProjections
    WHERE ImportFileId = 1
    AND Id < 5
)
, Points AS (
    SELECT Id, ltrim(value) as point_string, row_number() OVER (PARTITION BY Id ORDER By Id) as Nr
    FROM Links
    CROSS APPLY STRING_SPLIT(points_string,  , )
)
, Coords AS (
    SELECT Id, Nr, CAST(value AS [varchar](max)) AS coord
    FROM Points
    CROSS APPLY STRING_SPLIT(point_string,    )
)
, GroupedByNr AS (
    SELECT Id, Nr, MIN(coord) AS Lon, MAX(coord) AS Lat
    FROM Coords
    GROUP BY Id, Nr
)
, GroupedById AS (
    SELECT Id,  LINSESTRING (  + STRING_AGG(Lon +     + Lat,  ,  ) WITHIN GROUP (ORDER BY Nr) +  )  as wkt2
    FROM GroupedByNr
    GROUP BY Id
)
SELECT Id, geography::STGeomFromText(wkt2, 4326) AS PosList2
FROM GroupedById

友情链接