am used The below mention Query for find source and target from Routes table, but its not get accurate result
SELECT TOP 1 a.target FROM Routes a WHERE (ROUND((geometry:
oint(73.0135494838,19.2625249655, 4326).STDistance(geometry:oint(a.x2, a.y2, 4326)))*111.325,1) < 2.00) ORDER BY ROUND((geometry:oint(73.0135494838,19.2625249655, 4326).STDistance(geometry:oint(a.x2, a.y2,4326)))*111.325,2);How to find the source and target of vector with in a buffer range of given point using (STBuffer,STIntersects,STPointFromText)
أكثر...
SELECT TOP 1 a.target FROM Routes a WHERE (ROUND((geometry:
oint(73.0135494838,19.2625249655, 4326).STDistance(geometry:oint(a.x2, a.y2, 4326)))*111.325,1) < 2.00) ORDER BY ROUND((geometry:oint(73.0135494838,19.2625249655, 4326).STDistance(geometry:oint(a.x2, a.y2,4326)))*111.325,2);How to find the source and target of vector with in a buffer range of given point using (STBuffer,STIntersects,STPointFromText)أكثر...