Description

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

Dataset Attributes

  • OBJECTID
    Number
  • 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} ()
  • AssetID
    Text
    {"value"=>"SN4139", "count"=>3} (), {"value"=>"SN4138", "count"=>3} (), {"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} ()
  • Status
    Text
    {"value"=>"Active", "count"=>3983, "code"=>"Active"} (), {"value"=>"Removed", "count"=>84, "code"=>"Removed"} (), {"value"=>"Not Connected", "count"=>8, "code"=>"Not Connected"} (), {"value"=>"Proposed", "count"=>1, "code"=>"Proposed"} ()
  • OwnedBy
    Text
    {"value"=>"Cupertino", "count"=>4046, "code"=>"Cupertino"} (), {"value"=>"Other Public", "count"=>14, "code"=>"Other Public"} (), {"value"=>"Sunnyvale", "count"=>9, "code"=>"Sunnyvale"} (), {"value"=>"CalTrans", "count"=>4, "code"=>"CalTrans"} (), {"value"=>"Private HOA", "count"=>2, "code"=>"Private HOA"} (), {"value"=>"San Jose", "count"=>1, "code"=>"San Jose"} ()
  • MaintainedBy
    Text
    {"value"=>"Cupertino", "count"=>3687, "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 1508273111000
  • UpdateDate
    Date
    1486928131000 to 1510598726000
  • 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"=>2806} (), {"value"=>" ", "count"=>833} (), {"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"=>774, "code"=>"Taper 3 Bolt"} (), {"value"=>" ", "count"=>742, "code"=>" "} (), {"value"=>"Taper 2 Bolt", "count"=>628, "code"=>"Taper 2 Bolt"} (), {"value"=>"Flute 1 Bolt", "count"=>417, "code"=>"Flute 1 Bolt"} (), {"value"=>"Top Mount", "count"=>384, "code"=>"Top Mount"} (), {"value"=>"1B", "count"=>30, "code"=>"1B"} (), {"value"=>"Mast Arm Pole", "count"=>14, "code"=>"Mast Arm Pole"} (), {"value"=>"Type15", "count"=>6, "code"=>"Type15"} (), {"value"=>"Steel Round Pole", "count"=>1, "code"=>"Steel Round Pole"} ()
  • PoleMaterial
    Text
    {"value"=>"Galvanized", "count"=>2307, "code"=>"Galvanized"} (), {"value"=>"Steel", "count"=>673, "code"=>"Steel"} (), {"value"=>"Wood", "count"=>424, "code"=>"Wood"} (), {"value"=>" ", "count"=>240, "code"=>" "} (), {"value"=>"Concrete", "count"=>160, "code"=>"Concrete"} (), {"value"=>"Aluminium", "count"=>111, "code"=>"Aluminium"} (), {"value"=>"UNKNOWN", "count"=>31, "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"=>1364, "code"=>8} (), {"value"=>"6'", "count"=>1235, "code"=>6} (), {"value"=>"3'", "count"=>289, "code"=>3} (), {"value"=>"10'", "count"=>263, "code"=>10} (), {"value"=>"12'", "count"=>129, "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"=>3252, "code"=>"Street Light"} (), {"value"=>"Park Light", "count"=>243, "code"=>"Park Light"} (), {"value"=>" ", "count"=>228, "code"=>" "} (), {"value"=>"Safety Light", "count"=>149, "code"=>"Safety Light"} (), {"value"=>"Parking Lot Light", "count"=>92, "code"=>"Parking Lot Light"} ()
  • NumberOfLamps
    Number
    {"value"=>"1", "count"=>3631, "code"=>1} (), {"value"=>"2", "count"=>69, "code"=>2} ()
  • LampType
    Text
    {"value"=>"Inductive", "count"=>2906, "code"=>"ID"} (), {"value"=>"High Pressure Sodium", "count"=>497, "code"=>"HPS"} (), {"value"=>" ", "count"=>233, "code"=>" "} (), {"value"=>"LED", "count"=>216, "code"=>"LED"} (), {"value"=>"Metal Halide", "count"=>85, "code"=>"MH"} (), {"value"=>"Mercury Vapor", "count"=>4, "code"=>"MERC"} ()
  • Wattage
    Number
    0 to 400
  • Volts
    Number
    {"value"=>"120V", "count"=>2621, "code"=>120} (), {"value"=>"240V", "count"=>941, "code"=>240} (), {"value"=>"277V", "count"=>43, "code"=>277} (), {"value"=>"480V", "count"=>39, "code"=>480} ()
  • Base
    Text
    {"value"=>"Anchor", "count"=>3168, "code"=>"Anchor"} (), {"value"=>"Buried", "count"=>466, "code"=>"Buried"} (), {"value"=>" ", "count"=>311, "code"=>" "} ()
  • Fixture
    Text
    {"value"=>"Cobra", "count"=>3166, "code"=>"Cobra"} (), {"value"=>" ", "count"=>298, "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"=>3424, "code"=>"PEC"} (), {"value"=>" ", "count"=>309, "code"=>" "} (), {"value"=>"Time Clock", "count"=>199, "code"=>"Time Clock"} ()
  • HasBeacon
    Text
    {"value"=>"No", "count"=>3171, "code"=>"No"} (), {"value"=>" ", "count"=>619, "code"=>" "} (), {"value"=>"No", "count"=>153, "code"=>"N"} (), {"value"=>"Yes", "count"=>10, "code"=>"Y"} ()
  • IsFused
    Text
    {"value"=>" ", "count"=>3550, "code"=>" "} (), {"value"=>"Yes", "count"=>351, "code"=>"Y"} (), {"value"=>"Yes", "count"=>21, "code"=>"Yes"} (), {"value"=>"No", "count"=>12, "code"=>"N"} ()
  • IsUnderground
    Text
    {"value"=>"Yes", "count"=>2206, "code"=>"Y"} (), {"value"=>"No", "count"=>1432, "code"=>"N"} (), {"value"=>" ", "count"=>311, "code"=>" "} ()
  • IsMetered
    Text
    {"value"=>"No", "count"=>3268, "code"=>"N"} (), {"value"=>"Yes", "count"=>345, "code"=>"Y"} (), {"value"=>" ", "count"=>321, "code"=>" "} ()
  • HasStencil
    Text
    {"value"=>" ", "count"=>3104, "code"=>" "} (), {"value"=>"Yes", "count"=>819, "code"=>"Y"} (), {"value"=>"No", "count"=>9, "code"=>"N"} ()
  • HasSticker
    Text
    {"value"=>"Yes", "count"=>2700, "code"=>"Y"} (), {"value"=>" ", "count"=>1219, "code"=>" "} (), {"value"=>"No", "count"=>13, "code"=>"N"} ()
  • RateSchedule
    Text
    {"value"=>"LS2-A", "count"=>2974, "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
  • Shape
    Number
  • POINT_X
    Number
    6099440.17339455 to 6126508.41617049
  • POINT_Y
    Number
    1933078.49395674 to 1949329.62754454
  • NoVehicleHds
    Number
    0 to 5
  • NoPedHds
    Number
    {"value"=>"1", "count"=>27, "code"=>1} (), {"value"=>"2", "count"=>2, "code"=>2} ()
  • NoPedButtons
    Number
    {"value"=>"1", "count"=>21, "code"=>1} (), {"value"=>"2", "count"=>1, "code"=>2} ()
  • IsTrafficSignal
    Text
    {"value"=>"No", "count"=>3571, "code"=>"No"} (), {"value"=>"Yes", "count"=>488, "code"=>"Y"} ()
  • hasHandPoleCover
    Text
    {"value"=>"No", "count"=>2, "code"=>"N"} ()
  • isStreetlight
    Text
    {"value"=>"Yes", "count"=>3712, "code"=>"Yes"} (), {"value"=>"No", "count"=>348, "code"=>"No"} (), {"value"=>"Yes", "count"=>8, "code"=>"Y"} ()

About

  • By on April 27, 2016
  • Updated 13 days ago

Related Datasets