學 MS SQL GIS

Buffer/ 交集

DECLARE @g geometry;

SET @g = geometry::STGeomFromText('POINT(121.53496799999993 25.041786)', 0);

select housecase ,lat,lon, postulation_dry, postulation_dryimg, postulation_wet, postulation_wetimg

from housecase where @g.STBuffer(0.009).STIntersects(the_gemo)=1

MSSQL 2008 GIS

加入欄位
INSERT into geo (metry,graphy) VALUES (geometry::Parse('POINT(306251.3722 2770828.7255)'),geography::STGeomFromText('POINT(121.56569 25.0426818)',4326))

select * from sys.spatial_reference_systems where spatial_reference_id= 4326
4326:WGS84 (沒台灣的基準 3828 3826 )