sql server arcgis计算点是否在范围内

最新推荐文章于 2021-02-28 11:08:51 发布

七大爷爷

最新推荐文章于 2021-02-28 11:08:51 发布

阅读量644

点赞数

分类专栏： arcgis

本文链接：https://blog.csdn.net/a363096s/article/details/51180040

版权

arcgis 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

範例

sql server函数写法

USE [GtsManage]
GO
/****** Object: UserDefinedFunction [dbo].[GetPolygons] Script Date: 2016/4/18 星期一 15:11:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER FUNCTION [dbo].[GetPolygons] (@Polygon varchar(2000), @PotionX varchar(100), @PotionY varchar(100))
RETURNS FLOAT
AS
BEGIN

DECLARE @g GEOMETRY
SET @g=geometry::STGeomFromText(@Polygon,0); --转换

SET @g=@g.MakeValid();

DECLARE @p varchar(100)
SET @p = 'POINT('+ @PotionX+' '+@PotionY+')'

DECLARE @duge FLOAT

set @duge=
@g.STContains(@p)

RETURN @duge
END

@Polygon 参数为：

POLYGON ((120.21321937561035 30.376910095214842, 120.2130477142334 30.377296333312987, 120.21218940734863 30.3779829788208, 120.21184608459472 30.378369216918944, 120.21167442321777 30.378798370361327, 120.2115885925293 30.37927043914795, 120.21167442321777 30.379656677246092, 120.21201774597168 30.37995708465576, 120.21236106872558 30.380128746032714, 120.21274730682373 30.380128746032714, 120.21433517456054 30.38, 120.2150647354126 30.379914169311522, 120.21570846557617 30.37969959259033, 120.21592304229736 30.379356269836425, 120.21618053436279 30.378798370361327, 120.21626636505127 30.37845504760742, 120.21592304229736 30.378154640197753, 120.21536514282226 30.378025894165038, 120.21480724334716 30.377854232788085, 120.21446392059326 30.377811317443846, 120.21412059783935 30.37772548675537, 120.21377727508545 30.377596740722655, 120.2136056137085 30.37725341796875, 120.21326229095459 30.37699592590332, 120.2130477142334 30.376867179870604, 120.21321937561035 30.376910095214842)

arcgis sql server实例网址：

https://technet.microsoft.com/zh-tw/library/bb933792.aspx