GPS Coordinate Neighbor Finder

Premise to Pole Match Up Tool

This page takes two sets of gps coordinate data as input (in the form: id, gps x, gps y - examples filled in below). The first should be coordinates for premises. The second for poles. For each premise, the results report back the id of the closest pole. Note that data are not limited to what is visible in each field.

Premise ID, gpsx, gpsy	Pole ID, gpsx, gpsy	Dist (ft), Premise ID, Pole ID	Dist (ft), Pole 1 ID, Pole 2 ID
F_390145_2979505,-72.484972979999995,42.419446209999997 F_390562_2979206,-72.483784270000001,42.418830929999999 F_389985_2979403,-72.48553038,42.419148700000001 F_389991_2979115,-72.485719450000005,42.41850882 F_390428_2979077,-72.484449440000006,42.418518130000002 F_390530_2978880,-72.483779130000002,42.418002690000002 F_390038_2978837,-72.485559100000003,42.417806519999999 F_390463_2978373,-72.483903929999997,42.416630439999999 F_390184_2977954,-72.484863529999998,42.415772160000003 F_390515_2978105,-72.483546219999994,42.415852020000003	8268,-72.484241,42.41679 8411,-72.484575,42.419081 8535,-72.48467,42.415978 8563,-72.484674,42.418395 8642,-72.484606,42.416394 8645,-72.485687,42.418222 8804,-72.484157,42.418832 7419,-72.485035,42.417931 7505,-72.484553,42.415951 7510,-72.484884,42.417383 7667,-72.48383,42.418635 7670,-72.483459,42.419539 7815,-72.484445,42.417995 7820,-72.485104,42.418989 7821,-72.483537,42.41991 7890,-72.484766,42.416899 8047,-72.483994,42.41932 8091,-72.483834,42.415998 8107,-72.484806,42.419393 8185,-72.483946,42.418142 8191,-72.485158,42.418466	Results will appear here	Results will appear here

			Distance cutoff: feet

Why might this be useful?

Premise to Pole Mapping: If you map to all poles, this tells you which houses are far from any pole (service pole or road pole). These houses might have either direct bury or conduit to the home (of course, one is expensive to replicate, the other maybe not - you'll need further investigation). If you restrict pole data to only those along roads, then this analysis will give you the distances from each premise to the nearest road pole, to estimate overall drop distance (but note that one might net a somewhat shorter distance by using a "mid-span" connection).

Note that you can just do the "pole neighbor" calculation, by leaving the "Premise" box empty.

Pole to Pole Mapping: This tells you which poles are adjacent to which poles. This could eventually be useful in connecting poles, but that is a harder exercise. If a pole has only one neighbor, then it might be an "end of run" pole, but it might also indicate a pole missed in the mapping. If a pole has no neighbors, then perhaps the both are true. In any case, it flags poles for further investigation. Note that this has a user-defineable cutoff distance, initially set to 250 ft. Setting this too high will yield "too many" neighbors; setting it too low may yield false positive orphans.