Description

more
Public Works roadway, paving plan, status, work order information and asset history, street lights, by owner and type, and other infrastructure information. Version 2.0

Dataset Attributes

  • OBJECT ID 1
    Number
  • SUBTYPE CD
    Number
    1 to 4
  • GRID ADDRESS
    Text
    {"value"=>"N1216NK0200", "count"=>4} (), {"value"=>"N1111BO2500", "count"=>4} (), {"value"=>"N0914GI8900", "count"=>4} (), {"value"=>"N1216NK5200", "count"=>4} (), {"value"=>"N0914GI4800", "count"=>4} (), {"value"=>"N1018PH2500", "count"=>4} (), {"value"=>"N1018PG3800", "count"=>4} (), {"value"=>"N0914GJ6100", "count"=>4} (), {"value"=>"N1018OG7700", "count"=>4} (), {"value"=>"N0816YI3800", "count"=>4} ()
  • WATTS
    Number
    70 to 1000
  • FIXTURE ST
    Text
    {"value"=>"ENCL", "count"=>26268} (), {"value"=>"ENFL", "count"=>12541} (), {"value"=>"COLN", "count"=>5222} (), {"value"=>"CTMP", "count"=>958} (), {"value"=>"ULTR", "count"=>850} (), {"value"=>"RECT", "count"=>814} (), {"value"=>"TRAD", "count"=>761} (), {"value"=>"OPEN", "count"=>689} (), {"value"=>"DIR", "count"=>370} (), {"value"=>"ULFL", "count"=>336} ()
  • DECAL COLOR
    Text
    {"value"=>"YLO", "count"=>42287} (), {"value"=>"LTBL", "count"=>6976} (), {"value"=>"WHT", "count"=>22} ()
  • DECAL NUMBER
    Text
    {"value"=>"7", "count"=>21405} (), {"value"=>"10", "count"=>12829} (), {"value"=>"25", "count"=>8037} (), {"value"=>"15", "count"=>4808} (), {"value"=>"40", "count"=>1731} (), {"value"=>"17", "count"=>447} (), {"value"=>"X1", "count"=>22} (), {"value"=>"70", "count"=>6} ()
  • LAMP CODE
    Text
    {"value"=>"HPS", "count"=>42342} (), {"value"=>"MV", "count"=>6943} ()
  • USE CODE
    Text
    {"value"=>"STL", "count"=>49285} ()
  • MOUNT HEIGHT
    Number
    0 to 36
  • OWNER
    Text
    {"value"=>"PW", "count"=>45381} (), {"value"=>"SCH", "count"=>2257} (), {"value"=>"GS", "count"=>1600} (), {"value"=>"FM", "count"=>42} (), {"value"=>"PU", "count"=>5} ()
  • BRACKET CD
    Text
    {"value"=>" ", "count"=>48960} (), {"value"=>"TA", "count"=>203} (), {"value"=>"UNK", "count"=>61} (), {"value"=>"US", "count"=>25} (), {"value"=>"GU", "count"=>14} (), {"value"=>"TR", "count"=>13} (), {"value"=>"AF", "count"=>6} (), {"value"=>"DI", "count"=>3} ()
  • BRACKET LN
    Text
    {"value"=>" ", "count"=>47794} (), {"value"=>"0", "count"=>414} (), {"value"=>"12", "count"=>397} (), {"value"=>"6", "count"=>376} (), {"value"=>"10", "count"=>181} (), {"value"=>"8", "count"=>115} (), {"value"=>"14", "count"=>6} (), {"value"=>"30", "count"=>1} (), {"value"=>"16", "count"=>1} ()
  • INSTALL DATE
    Date
    1035158400000 to 1511222400000
  • RELATED POL
    Number
    474878 to 147304699
  • FIRST ON POLE
    Text
    {"value"=>"YES", "count"=>47665} (), {"value"=>"NO", "count"=>1620} ()
  • BRIDGE INS
    Text
    {"value"=>"NO", "count"=>49219} (), {"value"=>"YES", "count"=>65} (), {"value"=>" ", "count"=>1} ()
  • MATERIAL C
    Text
    {"value"=>"C", "count"=>18012} (), {"value"=>"W", "count"=>15780} (), {"value"=>"F", "count"=>13778} (), {"value"=>"A", "count"=>1199} (), {"value"=>"S", "count"=>516} ()
  • STYLE
    Text
    {"value"=>"STD", "count"=>48836} (), {"value"=>"FLU", "count"=>411} (), {"value"=>"SPL", "count"=>38} ()
  • WORK EFFECT
    Date
    1026086400000 to 1500768000000
  • WORK REQUEST
    Number
    0 to 999999999
  • MODIFY USE
    Text
    {"value"=>" ", "count"=>25082} (), {"value"=>"mich534", "count"=>5783} (), {"value"=>"dotty01", "count"=>4696} (), {"value"=>"linda48", "count"=>3754} (), {"value"=>"krist48", "count"=>1064} (), {"value"=>"Rebecc3", "count"=>1055} (), {"value"=>"jeffr73", "count"=>971} (), {"value"=>"lewis26", "count"=>856} (), {"value"=>"jam0570", "count"=>604} (), {"value"=>"jeffe49", "count"=>599} ()
  • MODIFY DATE
    Date
    -2208988800000 to 1489276800000
  • CREATION USE
    Text
    {"value"=>"VABsub6", "count"=>7140} (), {"value"=>"VABsub05", "count"=>5008} (), {"value"=>"VABsub3", "count"=>4972} (), {"value"=>"VABsub7", "count"=>3217} (), {"value"=>"VABsub11", "count"=>3023} (), {"value"=>"VABsub2", "count"=>2871} (), {"value"=>"VABsub9", "count"=>2665} (), {"value"=>"VABsub8", "count"=>2508} (), {"value"=>"VABsub15", "count"=>1520} (), {"value"=>"VABsub10", "count"=>1278} ()
  • CREATION DATE
    Date
  • LUMENS
    Number
    3300 to 127000
  • CONTRACT
    Number
    375520 to 375570
  • NOM VOLT
    Number
    0 to 120
  • SYMBOL ROTA
    Number
    0 to 360
  • SUBMISSION
    Text
    {"value"=>" ", "count"=>11829} (), {"value"=>"VB6", "count"=>7147} (), {"value"=>"VB4", "count"=>5971} (), {"value"=>"VB5", "count"=>5011} (), {"value"=>"VB7", "count"=>3214} (), {"value"=>"VB11", "count"=>3019} (), {"value"=>"VABsub2", "count"=>2825} (), {"value"=>"VB9", "count"=>2665} (), {"value"=>"VB8", "count"=>2511} (), {"value"=>"VB15", "count"=>1520} ()
  • WORK REQUES
    Text
    {"value"=>" ", "count"=>40095} (), {"value"=>"YL DECAL", "count"=>213} (), {"value"=>"SV to SVFLT", "count"=>117} (), {"value"=>"MBX M CAMPBELL", "count"=>115} (), {"value"=>"7777777", "count"=>103} (), {"value"=>"MBX CAMPBELL", "count"=>101} (), {"value"=>"7063538", "count"=>97} (), {"value"=>"6443253", "count"=>96} (), {"value"=>"MBX LONG", "count"=>92} (), {"value"=>"6361492", "count"=>61} ()
  • DESIGN ID
    Text
    {"value"=>" ", "count"=>44365} (), {"value"=>"113742", "count"=>108} (), {"value"=>"333782", "count"=>98} (), {"value"=>"118755", "count"=>98} (), {"value"=>"91075", "count"=>78} (), {"value"=>"455461", "count"=>59} (), {"value"=>"143811", "count"=>58} (), {"value"=>"540632", "count"=>49} (), {"value"=>"261444", "count"=>49} (), {"value"=>"574337", "count"=>47} ()
  • WORK LOCATION
    Text
    {"value"=>" ", "count"=>44322} (), {"value"=>"1", "count"=>530} (), {"value"=>"2", "count"=>437} (), {"value"=>"3", "count"=>370} (), {"value"=>"4", "count"=>327} (), {"value"=>"5", "count"=>279} (), {"value"=>"6", "count"=>252} (), {"value"=>"7", "count"=>217} (), {"value"=>"8", "count"=>189} (), {"value"=>"9", "count"=>179} ()
  • WORK FLOWST
    Number
    0 to 0
  • WORK FUNCTION
    Number
    0 to 1
  • DELETED INA
    Number
    0 to 0
  • ENABLED
    Number
    0 to 1
  • SP X
    Number
    12147912.7655 to 12238839.4678
  • SP Y
    Number
    3369316.62323 to 3503408.00053
  • LATITUDE
    Number
    36.55074552 to 36.92089982
  • LONGITUDE
    Number
    -76.22762395 to -75.92171356
  • Shape
    Number

Related Datasets