One important part of creating a fiber design is maintaining linkages between existing and new assets. While FOND isn't a dedicated Database Of Records (DBOR), it does provide some functionality allowing you to maintain connections in your data.
In this article, we're going to go over how this can be done for Poles, but first, some terminology.
When uploading Poles and Addresses in FOND, you may include a column or field named 'ID'. This is the only field that FOND will look for unique IDs, so you may need to make sure your own data has been prepared for this. For example, if your poles have an ID called 'MyPoleID', you'll need to create a new column called 'ID', and copy the values from 'MyPoleID' into the 'ID' column.
FondID, OccPole and OccPit fields
These fields are used by FOND to manage relationships between Network Design Elements (Cabinets, Closures, Cables) and Physical Design Elements (Poles, Spans, Conduit, Civil, Pits).
All Closures and Cabinets have both an OccPit and OccPole field. These fields correspond to the FondID of the Pits or Poles that support the Closure or Cabinet. For example, in the GIF below, the Pole has a FondID of POLE1052. This corresponds to the value for OccPole of the Closure that sits on top of the Pole (POLE1052).
A real example
Suppose we want to find the Poles that are supporting Closures in your FOND design, where you are not interested in knowing the FondID of the supporting poles, but the value for MyPoleID (an example field we made up earlier). Doing this will still require you to write some queries in your own GIS system, but we've outlined the logic for doing this below:
- For your pole data, read the value of MyPoleID
- If you prepared your input data as we suggested earlier in the article, these should equal the value for the ID field
- The ID field gets carried to the Pole layer in Network Design. Since every Pole in the Network design has a FondID (and assuming the values in MyPoleID were all unique), you now have a one to one relationship between the FondID's for Poles and the MyPoleID
- Now, for any Closure or Cabinet, you can read the OccPole value to see which Pole it occupies. You can use the relationship found in step 3 to determine which of your poles supports the closure in terms of the MyPoleID
So in the GIF above where the Closure has an OccPole of POLE1052, we can tell from the Pole layer that the Pole with FondID of POLE1052 has an ID of 942, which means that it's on the Pole with MyPoleID of 942.