Derelict Bicycles

[rayrshah]

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
    (
      descriptor LIKE '%Derelict Bicycle%' OR
      descriptor LIKE 'Chained Bike' OR
      descriptor LIKE 'Bicycle Chained%'
    ) AND
    unique_key IS NOT NULL
  WHERE
}

=================== Broken Wheel License information: ===================

https://thenounproject.com/search/?q=bicycle+wheel&i=44321 You just got a license to Bicycle Wheel

by Laurent Canivet You can use this icon for unlimited use on any project, forever. Your purchase directly supports the creator.

[dirkkelly]

INSERT INTO publishers (
  title, description, endpoint, tags, icon, visible, active
)
VALUES (
  'Derelict Bikes',
  'NYC 311 Derelict Bike Notifications',
  'https://citygram-services-nyc.herokuapp.com/nyc-311-derelict-bikes',
  '{"new-york"}',
  'nyc/broken-wheel.png',
  true,
  true
);