StuckwithGeo
New Member
- Joined
- Aug 23, 2016
- Messages
- 1
Hello!
I am hoping someone can help
I have tons of data similar to the sample data below. I am trying to figure out how many other lat, longs within the whole list are within 5km of each lat and long. For example, for the lat/long in B2, C2, how many other lat/longs in the whole list are within 5km. I then want to do the same with B3, C3 and B4, C4 etc.
etc.
The formula for the distance between lat/long is: =ACOS(COS(RADIANS(90-Lat1)) *COS(RADIANS(90-Lat2)) +SIN(RADIANS(90-Lat1)) *SIN(RADIANS(90-Lat2)) *COS(RADIANS(Long1-Long2))) *6371
<tbody>
</tbody>
Thank you!
I am hoping someone can help
I have tons of data similar to the sample data below. I am trying to figure out how many other lat, longs within the whole list are within 5km of each lat and long. For example, for the lat/long in B2, C2, how many other lat/longs in the whole list are within 5km. I then want to do the same with B3, C3 and B4, C4 etc.
etc.
The formula for the distance between lat/long is: =ACOS(COS(RADIANS(90-Lat1)) *COS(RADIANS(90-Lat2)) +SIN(RADIANS(90-Lat1)) *SIN(RADIANS(90-Lat2)) *COS(RADIANS(Long1-Long2))) *6371
A | B | C | D | ||
1 | Long | Lat | How many other Long, Lats within 5km? | ||
2 |
<colgroup><col width="65" style="width:65pt"> </colgroup><tbody> <!--StartFragment--> <!--EndFragment--> </tbody> |
<colgroup><col width="65" style="width:65pt"> </colgroup><tbody> <!--StartFragment--> <!--EndFragment--> </tbody> | ? | ||
3 |
<colgroup><col width="65" style="width:65pt"> </colgroup><tbody> <!--StartFragment--> <!--EndFragment--> </tbody> |
<colgroup><col width="65" style="width:65pt"> </colgroup><tbody> <!--StartFragment--> <!--EndFragment--> </tbody> | |||
4 |
<colgroup><col width="65" style="width:65pt"> </colgroup><tbody> <!--StartFragment--> <!--EndFragment--> </tbody> |
<colgroup><col width="65" style="width:65pt"> </colgroup><tbody> <!--StartFragment--> <!--EndFragment--> </tbody> | |||
5 |
<colgroup><col width="65" style="width:65pt"> </colgroup><tbody> <!--StartFragment--> <!--EndFragment--> </tbody> |
<colgroup><col width="65" style="width:65pt"> </colgroup><tbody> <!--StartFragment--> <!--EndFragment--> </tbody> |
<tbody>
</tbody>
Thank you!