Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
This may not be possible however, is it possible if I have a list of roads and postal codes(Zip codes) linked with global coordinates to setup a page whereby you can search for coordinates and it would return all roads within a set mile radius e.g. 1 mile?
I could have just a postal code search however I've found that either side of a road could have a different postal code.
I don't want to have a road name search e.g. high street would bring back 1000s of results. You would need a multitude of filters
With the coordinates you could input latitude and longitude and then a range of roads would appear
Could you try creating a table with dimension = if(distancebetween(RoadCoordinates, InputCoordinates) < 1, RoadName) and then unchecking Include null values?
The distancebetween function would need to be some variation of
atan2(sqrt(sqr(cos(RoadLat*pi()/180)*sin(RoadLong*pi()/180-DestLongitude*pi()/180))
+sqr(cos(InputLat *pi()/180)*sin(RoadLat*pi()/180)-sin(InputLat *pi()/180)*cos(RoadLat*pi()/180)
*cos(RoadLong*pi()/180 -InputLong*pi()/180))),sin(InputLat *pi()/180)*sin(RoadLat*pi()/180)
+cos(InputLat *pi()/180)*cos(RoadLat*pi()/180)*cos(RoadLong*pi()/180 -InputLong*pi()/180))*6371
since this outputs kilometers.
Also, InputLat and InputLong would likely need to be variables that could be changed by the user in input objects.
Could you share a sample of the data?
I've put together some sample data to protect clients and hopefully this helps.
Building Number | Street | Town | Postcode |
1 | HILL LANE | LONDON | S1 3AB |
2 | HILL LANE | LONDON | S1 3AB |
3 | HILL LANE | LONDON | S1 3AB |
4 | HILL LANE | LONDON | S1 3AB |
5 | HILL LANE | LONDON | S1 3AB |
1 | WHEEL LANE | LONDON | S1 3AC |
2 | WHEEL LANE | LONDON | S1 3AC |
3 | WHEEL LANE | LONDON | S1 3AC |
4 | WHEEL LANE | LONDON | S1 3AC |
5 | WHEEL LANE | LONDON | S1 3AC |
1 | PLUMBER CLOSE | LONDON | S1 3AF |
2 | PLUMBER CLOSE | LONDON | S1 3AF |
3 | PLUMBER CLOSE | LONDON | S1 3AF |
4 | PLUMBER CLOSE | LONDON | S1 3AF |
5 | PLUMBER CLOSE | LONDON | S1 3AF |
1 | MANS ROAD | LONDON | S1 3BC |
2 | MANS ROAD | LONDON | S1 3BC |
3 | MANS ROAD | LONDON | S1 3BC |
4 | MANS ROAD | LONDON | S1 3BC |
5 | MANS ROAD | LONDON | S1 3BC |
Those are an example of addresses, if my coordinates put me at latitude 52.579171, longitude 3.4699609, all of the addresses fall within a range of that.
I was hoping to input those coordinates and it'll return those addresses because they are all within a 1/2 mile range.
I will try the formula you sent and see, I wasn't sure if it was possible in the first place as Lat and Long will be inputted variables and then the radius search would be an inputted variable