Group GPS coordinates by proximity

Imebatilisha Ilichapishwa Miaka 5 iliyopita Kulipwa wakati wa kujifungua
Imebatilisha Kulipwa wakati wa kujifungua

I have a list of geo-positioned elements with decimal coordinates of latitude and longitude, it is necessary to be able to group nearby elements by a distance.

The original data is in a Microsoft SQL Server, if it is with SQL statements, better.

A program in C # is also accepted.

Input data:

-List of id of the elements and their coordinates

-The radius in meters to group

Output data:

-coordinates and id list of the elements that are in that radius

Kuprogramu ukitumia C# Mtandao wa Microsoft SQL SQL

Kitambulisho cha Mradi: #17331312

Kuhusu mradi

3 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

3 wafanyakazi huru wanazabuni wastani wa $159 kwa kazi hii

codevikas

Hello, My Understanding - the program will be provided by latitude and longitude values and the radius to group the elements. The program should group these elements based on radius and output the result. Is this corr Zaidi

$166 USD kwa siku 3
(Maoni 24)
4.7
jab2012gm

I can program it in several ways. It depends on the range of values of the radius (Harvesine formula) Can do it in sql 2008+, c# or Nodejs.

$155 USD kwa siku 4
(Maoni 0)
0.0