Description

more
Point layer representing the city of Cupertino's traffic poles.

Dataset Attributes

  • OBJECTID
    Number
  • AssetID
    Text
    {"value"=>"TP9914", "count"=>1} (), {"value"=>"TP9913", "count"=>1} (), {"value"=>"TP9887", "count"=>1} (), {"value"=>"TP944", "count"=>1} (), {"value"=>"TP8805", "count"=>1} (), {"value"=>"TP8310", "count"=>1} (), {"value"=>"TP8309", "count"=>1} (), {"value"=>"TP8308", "count"=>1} (), {"value"=>"TP8307", "count"=>1} (), {"value"=>"TP8131", "count"=>1} ()
  • Location
    Text
    {"value"=>" ", "count"=>215} (), {"value"=>"CITY HALL/LIBRARY", "count"=>55} (), {"value"=>"MARY AVE. BRIDGE", "count"=>36} (), {"value"=>"MEMORIAL PARK", "count"=>33} (), {"value"=>"CREEKSIDE PARK", "count"=>30} (), {"value"=>"JOLLYMAN PARK", "count"=>28} (), {"value"=>"QUINLAN CENTER", "count"=>24} (), {"value"=>"LINDA VISTA PARK", "count"=>17} (), {"value"=>"WILSON PARK", "count"=>15} (), {"value"=>"QUINLAN", "count"=>15} ()
  • Status
    Text
    {"value"=>"Active", "count"=>3971, "code"=>"Active"} (), {"value"=>"Removed", "count"=>85, "code"=>"Removed"} (), {"value"=>"Not Connected", "count"=>9, "code"=>"Not Connected"} (), {"value"=>"Proposed", "count"=>2, "code"=>"Proposed"} ()
  • OwnedBy
    Text
    {"value"=>"Cupertino", "count"=>4041, "code"=>"Cupertino"} (), {"value"=>"Other Public", "count"=>14, "code"=>"Other Public"} (), {"value"=>"Sunnyvale", "count"=>9, "code"=>"Sunnyvale"} (), {"value"=>"Private HOA", "count"=>2, "code"=>"Private HOA"} (), {"value"=>"San Jose", "count"=>1, "code"=>"San Jose"} ()
  • MaintainedBy
    Text
    {"value"=>"Cupertino", "count"=>3678, "code"=>"Cupertino"} (), {"value"=>"PGE", "count"=>365, "code"=>"PGE"} (), {"value"=>"Other Public", "count"=>14, "code"=>"Other Public"} (), {"value"=>"Sunnyvale", "count"=>9, "code"=>"Sunnyvale"} (), {"value"=>"San Jose", "count"=>1, "code"=>"San Jose"} ()
  • CreateDate
    Date
    1245283200000 to 1488208593000
  • UpdateDate
    Date
    1486928131000 to 1488578608000
  • Rotation
    Number
    0 to 0
  • BadgeNumber
    Text
    {"value"=>" ", "count"=>271} (), {"value"=>"2", "count"=>14} (), {"value"=>"1", "count"=>14} (), {"value"=>"5", "count"=>13} (), {"value"=>"4", "count"=>13} (), {"value"=>"3", "count"=>13} (), {"value"=>"6", "count"=>11} (), {"value"=>"9", "count"=>10} (), {"value"=>"8", "count"=>10} (), {"value"=>"7", "count"=>10} ()
  • ServiceID
    Text
    {"value"=>"4993063026", "count"=>2807} (), {"value"=>" ", "count"=>834} (), {"value"=>"4993063022", "count"=>133} (), {"value"=>"4993063002", "count"=>67} (), {"value"=>"4993063014", "count"=>46} (), {"value"=>"4993063008", "count"=>26} (), {"value"=>"4993063886", "count"=>7} (), {"value"=>"4993063046", "count"=>3} (), {"value"=>"4993063016", "count"=>3} (), {"value"=>"4993063819", "count"=>2} ()
  • PoleType
    Text
    {"value"=>"Taper 1 Bolt", "count"=>984, "code"=>"Taper 1 Bolt"} (), {"value"=>"Taper 3 Bolt", "count"=>765, "code"=>"Taper 3 Bolt"} (), {"value"=>" ", "count"=>743, "code"=>" "} (), {"value"=>"Taper 2 Bolt", "count"=>629, "code"=>"Taper 2 Bolt"} (), {"value"=>"Flute 1 Bolt", "count"=>426, "code"=>"Flute 1 Bolt"} (), {"value"=>"Top Mount", "count"=>384, "code"=>"Top Mount"} (), {"value"=>"1B", "count"=>29, "code"=>"1B"} (), {"value"=>"Mast Arm Pole", "count"=>11, "code"=>"Mast Arm Pole"} (), {"value"=>"Type15", "count"=>5, "code"=>"Type15"} (), {"value"=>"Steel Round Pole", "count"=>1, "code"=>"Steel Round Pole"} ()
  • PoleMaterial
    Text
    {"value"=>"Galvanized", "count"=>2293, "code"=>"Galvanized"} (), {"value"=>"Steel", "count"=>684, "code"=>"Steel"} (), {"value"=>"Wood", "count"=>424, "code"=>"Wood"} (), {"value"=>" ", "count"=>240, "code"=>" "} (), {"value"=>"Concrete", "count"=>159, "code"=>"Concrete"} (), {"value"=>"Aluminium", "count"=>111, "code"=>"Aluminium"} (), {"value"=>"UNKNOWN", "count"=>32, "code"=>"UNKNOWN"} (), {"value"=>"STANDARD WOOD", "count"=>7, "code"=>"STANDARD WOOD"} (), {"value"=>"ALUMINUM", "count"=>4, "code"=>"ALUMINUM"} (), {"value"=>"OTHER", "count"=>1, "code"=>"OTHER"} ()
  • PoleHeight
    Number
    0 to 435
  • ArmLength
    Number
    {"value"=>"8'", "count"=>1362, "code"=>8} (), {"value"=>"6'", "count"=>1238, "code"=>6} (), {"value"=>"3'", "count"=>289, "code"=>3} (), {"value"=>"10'", "count"=>263, "code"=>10} (), {"value"=>"12'", "count"=>130, "code"=>12} (), {"value"=>"15'", "count"=>10, "code"=>15} (), {"value"=>"60'", "count"=>1, "code"=>60} (), {"value"=>"55'", "count"=>1, "code"=>55} (), {"value"=>"30'", "count"=>1, "code"=>30} ()
  • LightFunction
    Text
    {"value"=>"Street Light", "count"=>3253, "code"=>"Street Light"} (), {"value"=>"Park Light", "count"=>243, "code"=>"Park Light"} (), {"value"=>" ", "count"=>228, "code"=>" "} (), {"value"=>"Safety Light", "count"=>150, "code"=>"Safety Light"} (), {"value"=>"Parking Lot Light", "count"=>92, "code"=>"Parking Lot Light"} ()
  • NumberOfLamps
    Number
    {"value"=>"1", "count"=>3633, "code"=>1} (), {"value"=>"2", "count"=>69, "code"=>2} ()
  • LampType
    Text
    {"value"=>"Inductive", "count"=>2907, "code"=>"ID"} (), {"value"=>"High Pressure Sodium", "count"=>511, "code"=>"HPS"} (), {"value"=>" ", "count"=>233, "code"=>" "} (), {"value"=>"LED", "count"=>201, "code"=>"LED"} (), {"value"=>"Metal Halide", "count"=>87, "code"=>"MH"} (), {"value"=>"Mercury Vapor", "count"=>4, "code"=>"MERC"} ()
  • Wattage
    Number
    0 to 400
  • Volts
    Number
    {"value"=>"120V", "count"=>2622, "code"=>120} (), {"value"=>"240V", "count"=>942, "code"=>240} (), {"value"=>"277V", "count"=>43, "code"=>277} (), {"value"=>"480V", "count"=>39, "code"=>480} ()
  • Base
    Text
    {"value"=>"Anchor", "count"=>3169, "code"=>"Anchor"} (), {"value"=>"Buried", "count"=>466, "code"=>"Buried"} (), {"value"=>" ", "count"=>312, "code"=>" "} ()
  • Fixture
    Text
    {"value"=>"Cobra", "count"=>3167, "code"=>"Cobra"} (), {"value"=>" ", "count"=>299, "code"=>" "} (), {"value"=>"Ornamental", "count"=>249, "code"=>"Ornamental"} (), {"value"=>"Shoe Box", "count"=>117, "code"=>"Shoe Box"} (), {"value"=>"Park Dome", "count"=>102, "code"=>"Park Dome"} ()
  • ControlType
    Text
    {"value"=>"Photo Electronic Control", "count"=>3425, "code"=>"PEC"} (), {"value"=>" ", "count"=>310, "code"=>" "} (), {"value"=>"Time Clock", "count"=>199, "code"=>"Time Clock"} ()
  • HasBeacon
    Text
    {"value"=>"No", "count"=>3173, "code"=>"No"} (), {"value"=>" ", "count"=>619, "code"=>" "} (), {"value"=>"No", "count"=>153, "code"=>"N"} (), {"value"=>"Yes", "count"=>10, "code"=>"Y"} ()
  • IsFused
    Text
    {"value"=>" ", "count"=>3571, "code"=>" "} (), {"value"=>"Yes", "count"=>332, "code"=>"Y"} (), {"value"=>"Yes", "count"=>21, "code"=>"Yes"} (), {"value"=>"No", "count"=>12, "code"=>"N"} ()
  • IsUnderground
    Text
    {"value"=>"Yes", "count"=>2207, "code"=>"Y"} (), {"value"=>"No", "count"=>1432, "code"=>"N"} (), {"value"=>" ", "count"=>312, "code"=>" "} ()
  • IsMetered
    Text
    {"value"=>"No", "count"=>3269, "code"=>"N"} (), {"value"=>"Yes", "count"=>345, "code"=>"Y"} (), {"value"=>" ", "count"=>322, "code"=>" "} ()
  • HasStencil
    Text
    {"value"=>" ", "count"=>3106, "code"=>" "} (), {"value"=>"Yes", "count"=>819, "code"=>"Y"} (), {"value"=>"No", "count"=>9, "code"=>"N"} ()
  • HasSticker
    Text
    {"value"=>"Yes", "count"=>2701, "code"=>"Y"} (), {"value"=>" ", "count"=>1220, "code"=>" "} (), {"value"=>"No", "count"=>13, "code"=>"N"} ()
  • RateSchedule
    Text
    {"value"=>"LS2-A", "count"=>2976, "code"=>"LS2-A"} (), {"value"=>" ", "count"=>672, "code"=>" "} (), {"value"=>"LS1-F", "count"=>136, "code"=>"LS1-F"} (), {"value"=>"LS1-A", "count"=>68, "code"=>"LS1-A"} (), {"value"=>"LS1-E", "count"=>53, "code"=>"LS1-E"} (), {"value"=>"LS1-C", "count"=>27, "code"=>"LS1-C"} (), {"value"=>"LS1-B", "count"=>2, "code"=>"LS1-B"} ()
  • GlobalID
    Number
  • POINT_X
    Number
    6099440.17339455 to 6126508.41617049
  • POINT_Y
    Number
  • NoVehicleHds
    Number
  • NoPedHds
    Number
  • NoPedButtons
    Number
  • IsTrafficSignal
    Text
  • hasHandPoleCover
    Text
  • Shape
    Number
  • isStreetlight
    Text

About

  • By on April 27, 2016
  • Updated 5 months ago

Related Datasets