In this example I am trying to find the distance between the locations in a table and a given point. When I found the distance I will return thee result filtered by a allegible distance.<\/p>\n
-- =============================================
-- Author:\t\tAsghar Panahy
-- Create date: 28-Feb-2013
-- Description:\tZoekt objecten binnen bereik van gegeven punt
-- =============================================
<\/span>ALTER PROCEDURE [dbo].[BereikbareObjecten]
\t-- Add the parameters for the stored procedure here<\/span>
\t@orig_lat REAL ,
\t@orig_lng REAL,
\t@binnenMeter integer
AS
BEGIN
\t-- SET NOCOUNT ON added to prevent extra result sets from
\t-- interfering with SELECT statements.<\/span>
\tSET NOCOUNT ON;
\t---------------------------------------------------------
\t-- Select your SRID wisely. Don't follow me.
\t-- select * from sys.spatial_reference_systems
<\/span>\t-- <\/span>where spatial_reference_id in (4937, 4258, 4326, 4269)<\/span>
\tDECLARE @SRID as int = 4326;
\t---------------------------------------------------------<\/span>
\tDECLARE @orig geography;
\tSET @orig = geography::Point<\/span>(@orig_lat, @orig_lng, @SRID);
\t<\/b>
\tSELECT *,CONVERT(INT, @orig.STDistance<\/span><\/b>( geography::Point([object].[Latitude], [object].[Longitude], @SRID))) As [Distance]
\t INTO #MyTempTable
\t FROM [Object]
\t
\tSELECT * FROM #MyTempTable
WHERE [Distance] <= @binnenMeter
ORDER BY [Distance]
\t
END
<\/pre>\n","protected":false},"excerpt":{"rendered":"In this example I am trying to find the distance between the locations in a table and a given point. When I found the distance I will return thee result filtered by a allegible distance. — =============================================– Author: Asghar Panahy– Create date: 28-Feb-2013– Description: Zoekt objecten binnen bereik van gegeven punt– =============================================ALTER PROCEDURE [dbo].[BereikbareObjecten] — … Continue reading “Finds Close Points by Distance”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[25,26,24],"tags":[],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false,"post-thumbnail":false},"uagb_author_info":{"display_name":"Pouya Panahy","author_link":"http:\/\/panahy.nl\/index.php\/author\/pouya\/"},"uagb_comment_info":0,"uagb_excerpt":"In this example I am trying to find the distance between the locations in a table and a given point. When I found the distance I will return thee result filtered by a allegible distance. -- =============================================-- Author: Asghar Panahy-- Create date: 28-Feb-2013-- Description: Zoekt objecten binnen bereik van gegeven punt-- =============================================ALTER PROCEDURE [dbo].[BereikbareObjecten] --…","_links":{"self":[{"href":"http:\/\/panahy.nl\/index.php\/wp-json\/wp\/v2\/posts\/30"}],"collection":[{"href":"http:\/\/panahy.nl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/panahy.nl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/panahy.nl\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/panahy.nl\/index.php\/wp-json\/wp\/v2\/comments?post=30"}],"version-history":[{"count":0,"href":"http:\/\/panahy.nl\/index.php\/wp-json\/wp\/v2\/posts\/30\/revisions"}],"wp:attachment":[{"href":"http:\/\/panahy.nl\/index.php\/wp-json\/wp\/v2\/media?parent=30"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/panahy.nl\/index.php\/wp-json\/wp\/v2\/categories?post=30"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/panahy.nl\/index.php\/wp-json\/wp\/v2\/tags?post=30"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}