獲得多邊形地域?qū)嵗闹行狞c
——jcstone 20130103
SQL 空間數(shù)據(jù)庫中并不提供多邊形地域?qū)嵗闹行狞c計算,因此借用幾何實例方法解決
DECLARE @geog geography;
SET @geog = geography::STGeomFromText('POLYGON((-122.358 47.653, -122.348 47.649, -122.348 47.658, -122.358 47.658, -122.358 47.653))', 4326); DECLARE @geom geometry; SET @geom = geometry::STGeomFromText(@geog.STAsText(), 0); DECLARE @g geography; |
|
來自: Jcstone > 《SQLSpatial》