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
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.