topic Calculate 1:1 relationship and distance on two point data sets in Spatial Statistics Questions https://community.esri.com/t5/spatial-statistics-questions/calculate-1-1-relationship-and-distance-on-two/m-p/663154#M2146 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I've got two point data sets for the location of schools (with postcodes). However, as one data set is geocoded and the other data set is more accurate (primary) data, they have different Eastings and Northings coordinates (British National Grid).</SPAN><BR /><BR /><SPAN>There's two things I'd like to achieve:</SPAN><BR /><BR /><SPAN>1. Join/relate the two data sets, based on the points in each layer having the same postcode</SPAN><BR /><SPAN>2. Measure the distance between the points that have been 'joined'</SPAN><BR /><BR /><SPAN>I'd like to do something similar to the existing Near function but rather than create a 1:n (one-to-many) relationship, I need a 1:1 relationship.</SPAN><BR /><BR /><SPAN>Any ideas on how this could be done?</SPAN><BR /><BR /><SPAN>Many thanks,</SPAN><BR /><BR /><SPAN>Miles</SPAN></BODY></HTML> Mon, 09 Jun 2014 13:51:17 GMT MilesMacCalman 2014-06-09T13:51:17Z Calculate 1:1 relationship and distance on two point data sets https://community.esri.com/t5/spatial-statistics-questions/calculate-1-1-relationship-and-distance-on-two/m-p/663154#M2146 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I've got two point data sets for the location of schools (with postcodes). However, as one data set is geocoded and the other data set is more accurate (primary) data, they have different Eastings and Northings coordinates (British National Grid).</SPAN><BR /><BR /><SPAN>There's two things I'd like to achieve:</SPAN><BR /><BR /><SPAN>1. Join/relate the two data sets, based on the points in each layer having the same postcode</SPAN><BR /><SPAN>2. Measure the distance between the points that have been 'joined'</SPAN><BR /><BR /><SPAN>I'd like to do something similar to the existing Near function but rather than create a 1:n (one-to-many) relationship, I need a 1:1 relationship.</SPAN><BR /><BR /><SPAN>Any ideas on how this could be done?</SPAN><BR /><BR /><SPAN>Many thanks,</SPAN><BR /><BR /><SPAN>Miles</SPAN></BODY></HTML> Mon, 09 Jun 2014 13:51:17 GMT https://community.esri.com/t5/spatial-statistics-questions/calculate-1-1-relationship-and-distance-on-two/m-p/663154#M2146 MilesMacCalman 2014-06-09T13:51:17Z