As a user I want to see amenities displayed in the application so that I have a reason to use it.

[ajslezak]

User Story

As a system administrator, I want automated scripts to import each NYC Open Data source into the database so that the data can be regularly updated without manual intervention.

Note: Wifi will be more complex due to multiple datasets with potentially duplicate information, and is therefore in a separate Story.

Acceptance Criteria

• Scenario: Data Population for Water Fountains

  • Given the Water Fountains data source URL: https://data.cityofnewyork.us/Recreation/NYC-Parks-Drinking-Fountains-Map/622h-mkfu
  • When the data population script for Water Fountains is executed
  • Then all relevant Water Fountain data should be successfully imported into the unified Amenity model
  • And each imported record should have its amenity_type correctly set to "Water Fountain".

• Scenario: Data Population for Restrooms

  • Given the Restrooms data source URL: https://data.cityofnewyork.us/City-Government/Public-Restrooms/i7jb-7jku
  • When the data population script for Restrooms is executed
  • Then all relevant Restroom data should be successfully imported into the unified Amenity model
  • And each imported record should have its amenity_type correctly set to "Restroom".

• Scenario: Data Population for Bicycle Parking

  • Given the Bicycle Parking data source URL: https://data.cityofnewyork.us/Transportation/Bicycle-Parking/592z-n7dk
  • When the data population script for Bicycle Parking is executed
  • Then all relevant Bicycle Parking data should be successfully imported into the unified Amenity model
  • And each imported record should have its amenity_type correctly set to "Bicycle Parking".

• Scenario: Data Population for Cooling Stations

  • Given the Cooling Stations data source URL: https://data.cityofnewyork.us/dataset/Cool-It-NYC-2020-Cooling-Sites/h2bn-gu9k
  • When the data population script for Cooling Stations is executed
  • Then all relevant Cooling Station data should be successfully imported into the unified Amenity model
  • And each imported record should have its amenity_type correctly set to "Cooling Station".