Potholes - Highway

[dirkkelly]

User Story: As a highway driver, I would like to get highway pothole notifications as well general Pothole information

Identify Data:

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

Ruby / SQL:

query = {
  '$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
    descriptor LIKE 'Pothole%' AND
    unique_key IS NOT NULL
  WHERE
}

Issue Icon: