User Story:
As a traveller/visitor, I'd like to know where the closest available Public Toilet I can easily access.
Identify Data:
Complaint Type
Descriptor
Public Toilet
Dirty/Graffiti
Public Toilet
Damaged Toilet/Sink
Public Toilet
Lighting/Electrical
Public Toilet
Damaged Other
Public Toilet
Flooded
Public Toilet
Damaged/Missing Ad Box
Public Toilet
Damaged Door
Public Toilet
New Automatic Public Toilet Request
Public Toilet
Damaged/Leaking Roof
Ruby / SQL
query = {
'$limit' => 1000,
'$order' => 'created_date DESC',
'$where' => <<-WHERE.oneline
created_date >= '#{SpyGlass::Utils.last_week_floating_timestamp}' AND
longitude IS NOT NULL AND
latitude IS NOT NULL AND
complaint_type LIKE 'Public Toilet%' AND
unique_key IS NOT NULL
WHERE
}
**Issue Icon:
User Story: As a traveller/visitor, I'd like to know where the closest available Public Toilet I can easily access.
Identify Data:
Ruby / SQL query = { '$limit' => 1000, '$order' => 'created_date DESC', '$where' => <<-WHERE.oneline created_date >= '#{SpyGlass::Utils.last_week_floating_timestamp}' AND longitude IS NOT NULL AND latitude IS NOT NULL AND complaint_type LIKE 'Public Toilet%' AND unique_key IS NOT NULL WHERE } **Issue Icon:![toilet](https://cloud.githubusercontent.com/assets/13894221/10711916/5052f850-7a58-11e5-9271-2284963d6c2d.png)