利用经纬度坐标怎么求两个公司间的地理距离

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

1. * Example generated by -dataex-. To install: ssc install dataex
   
2. clear
   
3. input long stkcd int year str21(Jingwei1 Jingwei2)
   
4. 2 2007 "114.068746,22.573589" "113.979272,22.562049"
   
5. 2 2008 "114.068746,22.573589" "113.979272,22.562049"
   
6. 2 2009 "114.068746,22.573589" "113.979272,22.562049"
   
7. 2 2010 "114.068746,22.573589" "113.979272,22.562049"
   
8. 2 2011 "114.068746,22.573589" "113.979272,22.562049"
   
9. 2 2012 "114.068746,22.573589" "113.979272,22.562049"
   
10. 2 2013 "114.068746,22.573589" "113.979272,22.562049"
    
11. 2 2014 "114.068746,22.573589" "113.979272,22.562049"
    
12. 2 2015 "114.068746,22.573589" "113.979272,22.562049"
    
13. 2 2016 "114.068746,22.573589" "113.979272,22.562049"
    
14. 2 2017 "114.068746,22.573589" "114.070184,22.552655"
    
15. 2 2018 "114.068746,22.573589" "114.070184,22.552655"
    
16. 2 2019 "114.068746,22.573589" "114.070184,22.552655"
    
17. 2 2020 "114.068746,22.573589" "114.070184,22.552655"
    
18. 4 2007 "114.054117,22.556835" "114.057334,22.54277"
    
19. 4 2008 "114.054117,22.556835" "114.057334,22.54277"
    
20. 4 2009 "114.054117,22.556835" "114.057334,22.54277"
    
21. 4 2010 "114.054117,22.556835" "114.057334,22.54277"
    
22. 4 2011 "114.054117,22.556835" "114.057334,22.54277"
    
23. 4 2012 "114.054117,22.556835" "114.057334,22.54277"
    
24. end

复制代码

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏4 回帖

关键词：经纬度 generated generate install example

求大神指导解答！

感谢 Andrew Musau 之建议，：请先 ssc install geodist 并试试

1. // ssc install geodist
   
2. split Jingwei1, p(,) g(coord1) destring
   
3. split Jingwei2, p(,) g(coord2) destring
   
4. rename (coord11-coord22) (lon1 lat1 lon2 lat2)
   
5. geodist lat1 lon1 lat2 lon2, g(wanted)

复制代码

谢谢老师！

请问这是stata吗，请问导入数据的excel表格长啥样呀，输出来的结果又是什么样的格式呢