[Task]: Manually Sync Watershed/Site/Parameters from Develop to Stable
Closed this issue · 5 comments
Transfer over the "subscribed" USGS sites for certain watersheds.
Data acquisition has been occurring in develop based on scripted "subscriptions" for a while. This needs to be transferred to stable, but it's complicated to replay those actions.
Suggestion emptying the following tables in Stable and manually exporting/importing data from Develop:
- usgs_site
- usgs_site_parameters
- watershed_usgs_sites
This will allow airflow to start acquisition and enable the extract endpoints for Stable.
❓ Should I also copy over usgs_measurements or just start from now with airflow?
Unable to export/import from pgadmin
related: https://www.pgadmin.org/docs/pgadmin4/6.9/import_export_servers.html
Transfer over the "subscribed" USGS sites for certain watersheds.
Data acquisition has been occurring in develop based on scripted "subscriptions" for a while. This needs to be transferred to stable, but it's complicated to replay those actions.
Suggestion emptying the following tables in Stable and manually exporting/importing data from Develop:
- usgs_site
- usgs_site_parameters
- watershed_usgs_sites
This will allow airflow to start acquisition and enable the
extractendpoints for Stable.❓ Should I also copy over usgs_measurements or just start from now with airflow?
Recommend we forego copying over the measurements and start collecting from present forward.
Unable to export/import from pgadmin
Any idea what's causing this?
This task no longer applies as we no longer connect site parameters to watersheds. Recommend we close this issue.
This task no longer applies as we no longer connect site parameters to watersheds. Recommend we close this issue.
Confirmed