sqlserver 空間資料類型

標籤：

--3.建立有空間資料的表create table x(    v int not null identity(1,1) primary key,    geog geography not null,    geogWKT as geog.STAsText())--4.增加空間資料insert into x(geog)values(geography::Parse(‘POLYGON(                                  (-93.123 36.943,                                   -93.126 36.953,                                   -94.129 36.986,                                   -93.123 36.943)                                 )‘                       )         ),   --多邊形，開始座標和結束座標必須相同,注意polygon中必須包含2層括弧，否則報錯              (geography::Parse(‘POINT(-93.123 36.943)‘)),    --點座標              (geography::Parse(‘LINESTRING(-93.123 36.943,                                     -93.126 36.953)‘)                         )  --兩座標之間的線--5.地理資料的計算  select v,       geogWKT,       geog.STDistance(‘POINT (-93.123 36.985)‘),          --距離       geog.STIntersects(‘POINT (-93.123 36.943)‘),        --是否有交集       geog.STLength(),                                    --長度       geog.STArea(),                                      --多邊形面積       geog.STAsText()                                     --WKT格式的座標      from x/*v    geogWKT    (無列名)    (無列名)    (無列名)    (無列名)    (無列名)1    POLYGON ((-93.123 36.943, -93.126 36.953, -94.129 36.986, -93.123 36.943))    3561.29978820883    1    180244.411606998    48996227.1008911    POLYGON ((-93.123 36.943, -93.126 36.953, -94.129 36.986, -93.123 36.943))2    POINT (-93.123 36.943)    4661.03285004629    1    0    0    POINT (-93.123 36.943)3    LINESTRING (-93.123 36.943, -93.126 36.953)    3561.29978820883    1    1141.48450709835    0    LINESTRING (-93.123 36.943, -93.126 36.953)*/select * from x

 

sqlserver 空間資料類型