User Story:
Whether I walk or drive, I'd like to know where construction takes place so that I can avoid and reach my destination quickly through the most accessible route.
Identify Data:
Complaint Type
Descriptor
CONSTRUCTION
ROOF
CONSTRUCTION
VACANT APARTMENT
CONSTRUCTION
PAVEMENT
CONSTRUCTION
ELEVATOR
CONSTRUCTION
RAIN LEADER
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 'CONSTRUCTION%' AND
unique_key IS NOT NULL
WHERE
}
**Issue Icon:
User Story: Whether I walk or drive, I'd like to know where construction takes place so that I can avoid and reach my destination quickly through the most accessible route.
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 'CONSTRUCTION%' AND unique_key IS NOT NULL WHERE } **Issue Icon: