基本信息
源码名称：空间查询
源码大小：0.82KB
文件格式：.txt
开发语言：SQL
更新时间：2014-02-22
友情提示：（无需注册或充值，赞助后即可获取资源下载链接）
嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：813200300
本次赞助数额为： 10 元×
微信扫码支付：10 元
×
请留下您的邮箱，我们将在2小时内将文件发到您的邮箱
源码介绍
USE [NSA]
GO
/****** Object: StoredProcedure [dbo].[BufferSelect] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[BufferSelect]
@WKT varchar(2000),
@startPt varchar(30),
@Buffer int,
@OrderbyX int
AS
begin
declare @stPt geometry;
set @stPt=geometry::STGeomFromText(@startPt,4326);
declare @urplace GEOGRAPHY;
set @urplace= GEOGRAPHY::STGeomFromText(@WKT,4326);
declare @bufArea GEOGRAPHY
set @bufArea = @urplace.STBuffer(3);
declare @bufArea2 geometry
set @bufArea2=geometry::STGeomFromWKB(@bufArea.STAsBinary(),4326)
select p.*,l.LineID as LineName,l.Path as LinePath from SVPoint p left join SVLine l on p.LineID=l.LineID inner join (
select ptID as PointID, PtGeo from SVPointGeo where PtGeo.Filter(@bufArea2)=1
) g on p.PointID= g.PointID order by g.PtGeo.STDistance(@stPt)
USE [NSA]
GO
/****** Object: StoredProcedure [dbo].[BufferSelect] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[BufferSelect]
@WKT varchar(2000),
@startPt varchar(30),
@Buffer int,
@OrderbyX int
AS
begin
declare @stPt geometry;
set @stPt=geometry::STGeomFromText(@startPt,4326);
declare @urplace GEOGRAPHY;
set @urplace= GEOGRAPHY::STGeomFromText(@WKT,4326);
declare @bufArea GEOGRAPHY
set @bufArea = @urplace.STBuffer(3);
declare @bufArea2 geometry
set @bufArea2=geometry::STGeomFromWKB(@bufArea.STAsBinary(),4326)
select p.*,l.LineID as LineName,l.Path as LinePath from SVPoint p left join SVLine l on p.LineID=l.LineID inner join (
select ptID as PointID, PtGeo from SVPointGeo where PtGeo.Filter(@bufArea2)=1
) g on p.PointID= g.PointID order by g.PtGeo.STDistance(@stPt)