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 5
  • 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"=>25462} (), {"value"=>"ENFL", "count"=>13434} (), {"value"=>"COLN", "count"=>5240} (), {"value"=>"CTMP", "count"=>949} (), {"value"=>"ULTR", "count"=>818} (), {"value"=>"RECT", "count"=>818} (), {"value"=>"TRAD", "count"=>761} (), {"value"=>"OPEN", "count"=>669} (), {"value"=>"DIR", "count"=>367} (), {"value"=>"ULFL", "count"=>334} ()
  • DECAL COLOR
    Text
    {"value"=>"YLO", "count"=>42681} (), {"value"=>"LTBL", "count"=>6623} (), {"value"=>"WHT", "count"=>23} (), {"value"=>"GRE", "count"=>15} ()
  • DECAL NUMBER
    Text
    {"value"=>"7", "count"=>21739} (), {"value"=>"10", "count"=>12565} (), {"value"=>"25", "count"=>8037} (), {"value"=>"15", "count"=>4811} (), {"value"=>"40", "count"=>1731} (), {"value"=>"17", "count"=>418} (), {"value"=>"X1", "count"=>20} (), {"value"=>"4", "count"=>15} (), {"value"=>"70", "count"=>6} ()
  • LAMP CODE
    Text
    {"value"=>"HPS", "count"=>42736} (), {"value"=>"MV", "count"=>6591} (), {"value"=>"LED", "count"=>15} ()
  • USE CODE
    Text
    {"value"=>"STL", "count"=>49342} ()
  • MOUNT HEIGHT
    Number
    0 to 36
  • OWNER
    Text
    {"value"=>"PW", "count"=>45423} (), {"value"=>"SCH", "count"=>2245} (), {"value"=>"GS", "count"=>1597} (), {"value"=>"FM", "count"=>42} (), {"value"=>"PU", "count"=>35} ()
  • BRACKET CD
    Text
    {"value"=>" ", "count"=>48881} (), {"value"=>"TA", "count"=>220} (), {"value"=>"UNK", "count"=>133} (), {"value"=>"US", "count"=>42} (), {"value"=>"GU", "count"=>42} (), {"value"=>"TR", "count"=>15} (), {"value"=>"AF", "count"=>6} (), {"value"=>"DI", "count"=>3} ()
  • BRACKET LN
    Text
    {"value"=>" ", "count"=>47779} (), {"value"=>"12", "count"=>417} (), {"value"=>"0", "count"=>414} (), {"value"=>"6", "count"=>397} (), {"value"=>"10", "count"=>201} (), {"value"=>"8", "count"=>126} (), {"value"=>"14", "count"=>6} (), {"value"=>"30", "count"=>1} (), {"value"=>"16", "count"=>1} ()
  • INSTALL DATE
    Date
    1035158400000 to 1516406400000
  • RELATED POL
    Number
    474878 to 157960799
  • FIRST ON POLE
    Text
    {"value"=>"YES", "count"=>47725} (), {"value"=>"NO", "count"=>1617} ()
  • BRIDGE INS
    Text
    {"value"=>"NO", "count"=>49276} (), {"value"=>"YES", "count"=>65} (), {"value"=>" ", "count"=>1} ()
  • MATERIAL C
    Text
    {"value"=>"C", "count"=>17943} (), {"value"=>"W", "count"=>15790} (), {"value"=>"F", "count"=>13918} (), {"value"=>"A", "count"=>1179} (), {"value"=>"S", "count"=>512} ()
  • STYLE
    Text
    {"value"=>"STD", "count"=>48899} (), {"value"=>"FLU", "count"=>406} (), {"value"=>"SPL", "count"=>37} ()
  • WORK EFFECT
    Date
    1026086400000 to 1516752000000
  • WORK REQUEST
    Number
    0 to 999999999
  • MODIFY USE
    Text
    {"value"=>" ", "count"=>23967} (), {"value"=>"mich534", "count"=>6933} (), {"value"=>"dotty01", "count"=>4536} (), {"value"=>"linda48", "count"=>3568} (), {"value"=>"jeffr73", "count"=>1120} (), {"value"=>"krist48", "count"=>1035} (), {"value"=>"Rebecc3", "count"=>1015} (), {"value"=>"lewis26", "count"=>907} (), {"value"=>"jam0570", "count"=>764} (), {"value"=>"jeffe49", "count"=>636} ()
  • MODIFY DATE
    Date
    -2208988800000 to 1516752000000
  • CREATION USE
    Text
    {"value"=>"VABsub6", "count"=>7133} (), {"value"=>"VABsub05", "count"=>5000} (), {"value"=>"VABsub3", "count"=>4965} (), {"value"=>"VABsub7", "count"=>3216} (), {"value"=>"VABsub11", "count"=>3006} (), {"value"=>"VABsub2", "count"=>2869} (), {"value"=>"VABsub9", "count"=>2661} (), {"value"=>"VABsub8", "count"=>2498} (), {"value"=>"VABsub15", "count"=>1519} (), {"value"=>"VABsub10", "count"=>1277} ()
  • CREATION DATE
    Date
  • LUMENS
    Number
    4 to 127000
  • CONTRACT
    Number
    375520 to 375570
  • NOM VOLT
    Number
    0 to 120
  • SYMBOL ROTA
    Number
    0 to 360
  • SUBMISSION
    Text
    {"value"=>" ", "count"=>11950} (), {"value"=>"VB6", "count"=>7142} (), {"value"=>"VB4", "count"=>5964} (), {"value"=>"VB5", "count"=>5003} (), {"value"=>"VB7", "count"=>3213} (), {"value"=>"VB11", "count"=>3002} (), {"value"=>"VABsub2", "count"=>2823} (), {"value"=>"VB9", "count"=>2661} (), {"value"=>"VB8", "count"=>2501} (), {"value"=>"VB15", "count"=>1519} ()
  • WORK REQUES
    Text
    {"value"=>" ", "count"=>39535} (), {"value"=>"YL DECAL", "count"=>208} (), {"value"=>"MBX LONG", "count"=>166} (), {"value"=>"SV to SVFLT", "count"=>114} (), {"value"=>"MBX M CAMPBELL", "count"=>113} (), {"value"=>"MBX CAMPBELL", "count"=>107} (), {"value"=>"7777777", "count"=>104} (), {"value"=>"7063538", "count"=>96} (), {"value"=>"6443253", "count"=>95} (), {"value"=>"6361492", "count"=>61} ()
  • DESIGN ID
    Text
    {"value"=>" ", "count"=>44127} (), {"value"=>"113742", "count"=>108} (), {"value"=>"333782", "count"=>98} (), {"value"=>"118755", "count"=>98} (), {"value"=>"91075", "count"=>79} (), {"value"=>"455461", "count"=>59} (), {"value"=>"143811", "count"=>58} (), {"value"=>"682439", "count"=>52} (), {"value"=>"540632", "count"=>49} (), {"value"=>"261444", "count"=>49} ()
  • WORK LOCATION
    Text
    {"value"=>" ", "count"=>44085} (), {"value"=>"1", "count"=>598} (), {"value"=>"2", "count"=>464} (), {"value"=>"3", "count"=>390} (), {"value"=>"4", "count"=>343} (), {"value"=>"5", "count"=>296} (), {"value"=>"6", "count"=>267} (), {"value"=>"7", "count"=>230} (), {"value"=>"8", "count"=>198} (), {"value"=>"9", "count"=>187} ()
  • 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