Centre 40° 1°
rayon = 0.75
point2 POINT(40.5 1.2)
point4 POINT(40.15 1.2)
point4 POINT(40.15 1.2) | Distance = 0.25
point2 POINT(40.5 1.2) | Distance = 0.53851648071345
SELECT name, AsText(location), SQRT(POW( ABS( X(location) - X(@center)), 2) + POW( ABS(Y(location) - Y(@center)), 2 )) AS distance FROM Points WHERE Intersects( location, GeomFromText(@bbox) ) AND SQRT(POW( ABS( X(location) - X(@center)), 2) + POW( ABS(Y(location) - Y(@center)), 2 )) < @radius ORDER BY distance;
point1 => POINT(41.5 2.2)
point2 => POINT(40.5 1.2)
point3 => POINT(39.5 0.2)
point4 => POINT(40.15 1.2)
POINT_5 => POINT(43 1.8)
POINT_6 => POINT(43.6 2.4)
POINT_7 => POINT(43.7 2.5)
POINT_8 => POINT(43.8 2.6)
POINT_9 => POINT(43.9 2.7)
POINT_10 => POINT(44 2.8)
POINT_11 => POINT(44.1 2.9)
POINT_12 => POINT(44.2 3)
POINT_13 => POINT(44.3 3.1)
POINT_14 => POINT(44.4 3.2)
POINT_15 => POINT(44.5 3.3)
POINT_16 => POINT(44.6 3.4)
POINT_17 => POINT(43.822523809524 2.3483870967742)
POINT_18 => POINT(43.870142857143 2.3806451612903)
POINT_19 => POINT(43.917761904762 2.4129032258065)
POINT_20 => POINT(43.965380952381 2.4451612903226)
POINT_21 => POINT(44.013 2.4774193548387)
POINT_22 => POINT(44.060619047619 2.5096774193548)
POINT_23 => POINT(44.108238095238 2.541935483871)
POINT_24 => POINT(44.155857142857 2.5741935483871)
POINT_25 => POINT(44.203476190476 2.6064516129032)
POINT_26 => POINT(44.251095238095 2.6387096774194)