Another Popular file format is "comma separated value" files with field data. The process is very similar to importing KML files, starting by pressing the Import Button in the Coordinates Editor Window. It can import pole location, pole attributes, connected guys and anchors, plus hardware.

 

Start by finding the CSV file you would like to Import:

 

The following fields exist for these types of files:

 

  1. The first row in the file must be a row header, identifying the field names for values in the following row.
  2. Field Names:
    1. "Name" - an Integer number identifying the specific item. (optional)
    2. "North" - Northing coordinate
    3. "East" - Easting Coordinate
    4. "Elevation" - Elevation
    5. "Latitude"
    6. "Longitude". If populated, a question wil popup to confirm if this value is based on WGS84 or the project's Datum/Zone.
    7. "Code" - for type of item. Quick Pole will ask you to match on import, each description in the data to one of the following:
      • Pole 
      • Building
      • Anchor
      • Pole Front Edge
      • Pole Back Edge
      • Pole Brace
    1. "Pole_" - pole number
    2. "Pole_typ" - pole type. Wood and Concrete. If not entered, or entry is "wood", then wood is assumed. Otherwise concrete is assumed.
    3. "WOOD_SPECI" or "SPECIES" species of wooden pole
    4. "MANUFACTUR" - for concrete poles, this identifies the manufacturer.
    5. "Year" - Year of pole manufacture. Format example=1987
    6. "Height" - Pole height in feet
    7. "Class" - Pole Class
    8. "Height_1" or "Height" - pole length
    9. "SURVEY_ID" or "ANCHOR_ID" - Survey name/number
    10. "BAR_CODE" - alternate pole number
    11. "POLE_HAZAR" Pole hazard notes
    12. "POLE_CONDI" Pole condition notes
    13. "NOTES" - notes.
    14. "GENERAL_NO" - general notes
    15. "POLE_INSPE" - Pole inspection year
    16. "LASER_HEIG" - Lowest Attachment Height by Laser (m)
    17. "BOLT_HOLE" - Communications bolt holes
    18. "BOLT_HO_1" - Secondary area bolt holes
    19. "BOLT_HOL_2" - Primary area bolt holes
    20. "TOP_OF_POL" - Height of pole above ground
    21. "CIRCUMFERE" - pole groundline circumference for wooden poles
    22. "PICTURE_NO" - picture #1 location
    23. "SPAN_TO" - picture #2 location
    24. "SPAN_PICTU" - picture #3 location
    25. "P/S_BOX" - Communications Power Supply height
    26. "COM1_RISER","COM2_RISER","COM3_RISER","COM4_RISER" - separate fields for communication riser heights
    27. "PM_COMM_DEVICE" - Small Communications Enclosure or Terminal height
    28. "S/L" - Street Light height
    29. "CELLULAR_G" - Cellular Device height
    30. "SCADA_BOX" - SCADA Device height
    31. "HYDRO_BOX" - HYDRO EQUIP BOX height
    32. "T/L" - Traffic light height
    33. "PED_LIGHT" - Pedestrian Light height
    34. "CSP" - Fiber Cross Connect Box, a.k.a Central Splitting Point (optical)
    35. "SEC_RISER" - secondary riser height
    36. "PRIM_RISER" - primary riser height
    37. "SEC_DRIP_L" or "MONITOR_DR" - Secondary Voltage Point (0-750V) height
    38. "FUSE" or "FUSE_2" - Fused Cutout (15-27KV) height
    39. "BUSH" - Primary Bushing (0.75 -> 22KV) height
    40. "TX_NO" - Transformer ID
    41. "BOTTOM" - Bottom TX Height
    42. "TOP" - multiple transformer heights separated by ;
    43. "ANTENNA" - Antenna height
    44. "SWITCH" - 3 Phase Fused Cutout Switch 46KV height (main unit up near primaries)
    45. "STAND_OFF" - Insulator - Side Mount 15KV height
    46. "SWITCH_ARM" switch arm height
    47. "OWNER" - owner
    48. "EYES" number of guy eyes on anchor rod
    49. "ROD_SIZE" anchor rod size
    50. "GUY_1","GUY_2","GUY_3","GUY_4" - guy heights attached to anchor
    51. "DISTANCE_T" Anchor lead
    52. "ROD_HEADTYPE" - anchor rod head type (forged, screwed on, etc)
    53. "TEDG_1/4" - communications 1/4 inch guy wire
    54. "TEDG_5/16"- communications 5/16 inch guy wire
    55. "TEDG_3/8"- communications 3/8 inch guy wire
    56. "TEDG_7/16"- communications 7/16 inch guy wire
    57. "TEDG_1/2"- communications 1/2 inch guy wire
    58. "HYDG_1/4" or "HYDG_1/4_" Power 1/4 inch guy wire
    59. "HYDG_5/16" or "HYDG_5/16_" Power 5/16 inch guy wire
    60. "HYDG_3/8" or "HYDG_3/8_" Power 3/8 inch guy wire
    61. "HYDG_7/16" or "HYDG_7/16_" Power 7/16 inch guy wire
    62. "HYDG_1/2" or "HYDG_1/2_" Power 1/2 inch guy wire

 

The next step in the process reviews the file and determines how many records are present.

 

The next two steps are similar to importing KML files.

 


If something is not immediately recognizable, Quick Pole will popup questions that will ask you to match what was detected with an item that it has in one of its datasets.

 

At the final step we get confirmation of what has been imported from the file:

 

All entries should be visible once you press "Finish".