Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Design and implement a SMALL database of attractions for testing and development #15

Open
dongskyler opened this issue May 2, 2020 · 1 comment
Labels
status: on hold Issues that are on hold
Milestone

Comments

@dongskyler
Copy link
Member

dongskyler commented May 2, 2020

If you're interested in working on this issue, please contact me. I have designed the data schema and some data in CSV files.

Is your feature request related to a problem? Please describe.

Design a small database for testing and development. For example, a limited number of National Parks or state parks in a given state.

Create a small database of 10-20 attractions, so that we can use it to develop core algorithms that can recommend road trip routes.

The area around Las Vegas is an ideal choice. There are many natural attractions within ~4 hours of driving, including Grand Canyon National Park, Death Valley National Park, Zion National Park, Bryce Canyon National Park, Horseshoe Bend, and Antelope Canyon.

Describe the solution you'd like

The database can be implemented in SQL (such as PostgreSQL or MySQL) or noSQL (such as MongoDB).

The database will be implemented with MongoDB.

Because it is difficult to pre-define the schema, given that:

  • Attractions of different types may have very different attributes.
  • When we scale this database up, we don't know what attributes will be included.

Therefore, a noSQL database (such as MongoDB) is an ideal choice.

The database will include at least the following info:

  • Name
  • Coordinates
  • Type of attraction (e.g. National Park, National Monument, National Historical Park, etc)
  • Hours
  • Entrance fee, annual pass
  • Campsite info
  • In-park lodging
  • Major attractions inside each park/attraction
  • Popularity, measured by, e.g., number of visitors (of last available year)
@dongskyler dongskyler added this to the Version 1.1 milestone May 2, 2020
@dongskyler dongskyler changed the title Design and implement a small database of attractions for testing and development Design and implement a SMALL database of attractions for testing and development May 2, 2020
@dongskyler dongskyler self-assigned this May 3, 2020
@dongskyler dongskyler removed their assignment May 13, 2020
@dongskyler dongskyler changed the title Design and implement a SMALL database of attractions for testing and development Design and implement a SMALL distance matrix of attractions for testing and development Jul 19, 2020
@dongskyler dongskyler changed the title Design and implement a SMALL distance matrix of attractions for testing and development Design and implement a SMALL database of attractions for testing and development Jul 19, 2020
@dongskyler dongskyler added the status: on hold Issues that are on hold label Jul 19, 2020
@dongskyler
Copy link
Member Author

This issue is too big. It needs to be broken down into smaller tasks.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
status: on hold Issues that are on hold
Projects
None yet
Development

No branches or pull requests

1 participant