search

BetaNYC / citygram-services-nyc

Web content transformation proxies for open data API's
https://citygram-services-nyc.herokuapp.com/
4 stars 6 forks source link

Radioactive Material #41

Closed gfleetwood closed 3 years ago

gfleetwood commented 8 years ago

User Story:

Unsafe radioactive material is a severe health hazard. As such, information on such instances is vital.

Identify Data:

Complaint Type Descriptor
Radioactive Material User Unlicensed
Radioactive Material Material Stored Improperly
Radioactive Material Contamination Risk

Ruby / SQL

query = {
  '$limit' => 1000,
  '$order' => 'created_date DESC',
  '$where' => <<-WHERE.oneline
    created_date >= '#{28.days.ago.iso8601}' AND
    longitude IS NOT NULL AND
    latitude IS NOT NULL AND
    descriptor LIKE 'User Unlicensed' OR LIKE 'Material Stored Improperly' OR LIKE 'Contamination Risk' AND
    unique_key IS NOT NULL
}

Issue Icon:

noun_47216_cc