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

Verify that database install documentation is clear and that dev and prod database are easy to setup. #98

Closed
dblodgett-usgs opened this issue Apr 11, 2023 · 3 comments
Assignees

Comments

@dblodgett-usgs
Copy link
Member

dblodgett-usgs commented Apr 11, 2023

We need easy to install "sample/development" and "complete/prod" database installs. The project already more or less has these options and documentation of how to install each locally needs to be clear.

This issue can be closed once both options have been installed, the process documented carefully, and followup issues have been opened.

@dblodgett-usgs dblodgett-usgs self-assigned this Apr 11, 2023
@dblodgett-usgs
Copy link
Member Author

Opened #100 to take care of some of this.

@dblodgett-usgs
Copy link
Member Author

I've been working through a simplified full scale database install. I did some work on the (currently internal) database load project and opened #100 to move parts of that load into this repository.

I've successfully gotten both the demo database and the prod database installed locally and will open a PR with some updates.

@gzt5142
Copy link
Collaborator

gzt5142 commented Apr 19, 2023

For a localized testing/demo/development database, the critical thing that I would want to see is the full NHD table(s), so that ingested features and be spatially joined to their comid counterparts from NHD.

The feature table itself should be present, along with the feature_* tables from which it inherits... but those source-specific feature tables don't necessarily need to be fully populated. Perhaps only one of the source tables can be fully populated, but the others only present with a handful of sample features present.

The crawler_source table is so small that it can be included -- or can be loaded from its TSV in the repo at the time the test database is built locally.

dblodgett-usgs added a commit that referenced this issue Apr 20, 2023
documentation and make sure things run fixes #98
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants