Description

more
The spatial location of poles within the cCity of Prince George. Standard poles for traffic signals, sign poles, fence poles, etc. Related feature tables such as TLamp, TSIgn, TPedestrian Signal, etc. have the objects mounted or related to each specific pole.

Dataset Attributes

  • OBJECTID
    Number
  • AssetID
    Text
    {"value"=>"1899", "count"=>1} (), {"value"=>"1898", "count"=>1} (), {"value"=>"1897", "count"=>1} (), {"value"=>"1896", "count"=>1} (), {"value"=>"1895", "count"=>1} (), {"value"=>"1894", "count"=>1} (), {"value"=>"1893", "count"=>1} (), {"value"=>"1892", "count"=>1} (), {"value"=>"1891", "count"=>1} (), {"value"=>"1890", "count"=>1} ()
  • FacilityID
    Number
    1 to 7693
  • LegacyID
    Text
  • LifeCycleStatus
    Text
    {"value"=>"Active", "count"=>7576, "code"=>"ACT"} (), {"value"=>"Removed", "count"=>57, "code"=>"RMV"} ()
  • SubType
    Number
    1 to 5
  • AssetOwner
    Number
    {"value"=>"CPG", "count"=>4542, "code"=>1} (), {"value"=>"BCH", "count"=>2560, "code"=>-3} (), {"value"=>"MOH", "count"=>554, "code"=>-4} ()
  • AssetManager
    Number
    {"value"=>"Transportation", "count"=>4432, "code"=>20} (), {"value"=>-3, "count"=>2547, "code"=>-3} (), {"value"=>-4, "count"=>554, "code"=>-4} (), {"value"=>"Utilities", "count"=>110, "code"=>21} (), {"value"=>"Private", "count"=>2, "code"=>-2} ()
  • AdministrativeArea
    Text
  • Location
    Text
    {"value"=>"Ospika Blvd & 15th Ave ", "count"=>11} (), {"value"=>"2501 Tyner Blvd", "count"=>6} (), {"value"=>"Domano Blvd & St Lawrence Ave ", "count"=>5} (), {"value"=>"Queensway & 17th Ave ", "count"=>5} (), {"value"=>"Queensway & 20th Ave ", "count"=>5} (), {"value"=>"Ferry Ave & Lansdowne Rd ", "count"=>4} (), {"value"=>"Victoria St & 15th Ave ", "count"=>4} (), {"value"=>"15th Ave & Tabor Blvd ", "count"=>4} (), {"value"=>"Tabor Blvd & Hill Ave", "count"=>4} (), {"value"=>"Hart Hwy & Northwood Pulpmill Rd ", "count"=>3} ()
  • InstallDate
    Date
    1198108800000 to 7564924800000
  • InstallContractor
    Text
    {"value"=>"L&M Engineering Ltd", "count"=>77} (), {"value"=>"L&M Engineering", "count"=>35} (), {"value"=>"L&M", "count"=>31} (), {"value"=>"BC Hydro", "count"=>10} (), {"value"=>"H.Y. Engineering Ltd", "count"=>8} (), {"value"=>"NRS Engineering", "count"=>8} (), {"value"=>"Radloff", "count"=>7} (), {"value"=>"L&M Engineering Limited", "count"=>4} (), {"value"=>"NRS Engineering Ltd", "count"=>4} (), {"value"=>"MRS Engineering LTD", "count"=>4} ()
  • OperationalArea
    Text
  • StreetName
    Text
    {"value"=>"Boundary Rd", "count"=>108} (), {"value"=>"River Rd", "count"=>56} (), {"value"=>"George St", "count"=>33} (), {"value"=>"Gunn Rd", "count"=>20} (), {"value"=>"Chancellor Blvd", "count"=>11} (), {"value"=>"PG Pulpmill Rd", "count"=>10} (), {"value"=>"Tyner Blvd", "count"=>9} (), {"value"=>"Redfield Pl", "count"=>8} (), {"value"=>"Peter Rd", "count"=>6} (), {"value"=>"Rowe St", "count"=>6} ()
  • PrimaryImage
    Text
    {"value"=>"424.05", "count"=>29} (), {"value"=>"1147.85", "count"=>18} (), {"value"=>"734", "count"=>14} (), {"value"=>"575.11", "count"=>11} (), {"value"=>"194.02", "count"=>10} (), {"value"=>"170.07", "count"=>10} (), {"value"=>"696.19", "count"=>10} (), {"value"=>"996.06", "count"=>9} (), {"value"=>"662", "count"=>9} (), {"value"=>"170.04", "count"=>9} ()
  • BoltPattern
    Text
  • Class
    Text
  • FootingDiameter
    Number
  • UpperAccess
    Number
  • CommJBox
    Number
  • Manufacturer
    Text
    {"value"=>"Code1", "count"=>1, "code"=>"1"} ()
  • FinishColor
    Text
  • Style
    Text
    {"value"=>"Standard", "count"=>193, "code"=>"STA"} (), {"value"=>"Decorative", "count"=>33, "code"=>"DEC"} ()
  • MountType
    Text
  • RecordedLength
    Number
  • Diameter
    Number
  • Material
    Text
    {"value"=>"Galvanized Steel", "count"=>462, "code"=>"STL"} (), {"value"=>"Wood", "count"=>2, "code"=>"WD"} ()
  • MeterYoke
    Number
  • mylegacy
    Number
  • ConditionDate
    Date
    1533643424000 to 1534334400000
  • AcquisitionCost
    Number
  • DeprecationMethod
    Text
  • ExpectedLife
    Number
  • ResidualValue
    Number
  • slightID_old
    Number
    1 to 7909
  • bstopID_old
    Number
  • signID_old
    Number
  • created_user
    Text
    {"value"=>"SATHERTON", "count"=>261} (), {"value"=>"MLEMORVAN", "count"=>248} (), {"value"=>"LMCKERSIE", "count"=>100} (), {"value"=>"GMULLIGAN", "count"=>1} ()
  • created_date
    Date
    1394570604000 to 1542412840000
  • last_edited_user
    Text
    {"value"=>"GISADMIN", "count"=>5213} (), {"value"=>"TLATKOWSKI", "count"=>1635} (), {"value"=>" ", "count"=>482} (), {"value"=>"SATHERTON", "count"=>227} (), {"value"=>"LMCKERSIE", "count"=>126} (), {"value"=>"MLEMORVAN", "count"=>9} ()
  • last_edited_date
    Date
    1407896522000 to 1542846080000
  • BusStop
    Number
  • SubType
    Text
    {"value"=>"TLightPole", "count"=>400} (), {"value"=>"TSignalPole", "count"=>126} (), {"value"=>"TSignPole", "count"=>38} (), {"value"=>"TPowerPole", "count"=>11} ()
  • Condition
    Number
    0 to 0
  • CoFScore
    Number
  • CoFDate
    Date
  • RiskScore
    Number
  • Link
    Text
  • DF
    Text

About

  • By on February 9, 2016
  • Updated 2 days ago

Related Datasets