No similar question seems to relate to my issue but I desperately need help with calculating distances. I have a CSV with the residential postcode of 200 000 patients. For each patient, I also have the postcode of their respective doctor. I need to find out how far, on average, patients are travelling to see their doctor.

So I've created centroids for all my postcodes thinking that a point layer would be easier to work with, but now I have no idea what to do. Old threads speak of plugins like Points2one that no longer exist (to my knowledge). I'm assuming I need to produce a line between all individual sets of points, then calculate the length of the lines and get the average. Help!

  • Perhaps Join by lines (hub lines) tool will be useful. To prepare hub/spoke point layers, joining your csv to the centroids layer is not a problem for you? – Kazuhito Nov 16 '19 at 2:26
  • Kazuhito that sounds promising- do you know any good tutorials for how to use that function? – Dee_ell_ess Nov 16 '19 at 23:56
  • Dee_ell_ess, I do not know any tutorial, but a good example posted by MrXsquared would be helpful. – Kazuhito Nov 17 '19 at 0:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.