Street light condition

[tomca32]

As a community board member, I want to identify problems with street lighting in my community.

|Complaint Type| Descriptor Highway Condition Pothole - Highway Street Condition Pothole

Complaint Type	Descriptor
Street Light Condition	Street Light Lamp Dim
Street Light Condition	Lamppost Base Door/Cover Open
Street Light Condition	Control Panel Damaged
Street Light Condition	Glassware Hanging
Street Light Condition	Fixture/Luminaire Damaged
Street Light Condition	Street Light Lamp Missing
Street Light Condition	Flood Light Lamp Cycling
Street Light Condition	Lamppost Damaged
Street Light Condition	Traffic Signal Light
Street Light Condition	Wood Pole Leaning
Street Light Condition	Fixture/Luminaire Door Open
Street Light Condition	Photocell (PEC) Missing
Street Light Condition	Bracket Arm Bent
Street Light Condition	Bracket Arm Missing
Street Light Condition	Glassware Missing
Street Light Condition	Fire Alarm Lamp Cycling
Street Light Condition	Flood Light Lamp Missing
Street Light Condition	Bracket Arm Broken
Street Light Condition	Wood Pole Damaged
Street Light Condition	Fixture/Luminaire Missing
Street Light Condition	Lamppost Wire Exposed
Street Light Condition	Foreign Attachment On Lamppost
Street Light Condition	Lamppost Base Door/Cover Damaged
Street Light Condition	Lamppost Missing
Street Light Condition	Flood Light Lamp Dim
Street Light Condition	Wood Pole Missing
Street Light Condition	Glassware Broken
Street Light Condition	Lamppost Knocked Down
Street Light Condition	Highway Sign Lighting Repair
Street Light Condition	Foreign Attachment On Wood Pole
Street Light Condition	Time Clock Maladjusted
Street Light Condition	Street Light Out
Street Light Condition	Street Light Cycling
Street Light Condition	Multiple St Lts Dayburning
Street Light Condition	Wood Pole Knocked Down
Street Light Condition	Lamppost Base Door/Cover Missing
Street Light Condition	Street Light Dayburning
Street Light Condition	Fire Globe Missing
Street Light Condition	Fixture/Luminaire Hanging
Street Light Condition	Multiple Street Lights Out
Street Light Condition	Flood Light Lamp Dayburning
Street Light Condition	In-Line Fuse Missing
Street Light Condition	Lamppost Leaning
Street Light Condition	Bracket Arm Loose
Street Light Condition
Street Light Condition	Wood Pole Wires Exposed
Street Light Condition	Fixture/Luminaire Out Of Position

{
  '$limit' => 1000,
  '$order' => 'created_date DESC',
  '$where' => <<-WHERE.oneline
    created_date >= '#{7.days.ago.iso8601}' AND
    longitude IS NOT NULL AND
    latitude IS NOT NULL AND
    complaint_type = 'Street Light Condition'
    descriptor != '%Fire Alarm Lamp%' AND
    descriptor != '%Flood Light%'
    unique_key IS NOT NULL
  WHERE
}