search

CIROH-UA / NGIAB_data_preprocess

Tools to subset hydrofabrics, generate forcings, create default realizations for NGIAB
5 stars 2 forks source link

sqlite3.OperationalError: no such table: main.divides #11

Closed arpita0911patel closed 1 month ago

arpita0911patel commented 4 months ago

While running run.sh using VScode on my local machine seeing below error:

File "/Users/apatel54/Documents/Arpita/git/NGIAB_data_preprocess/data_processing/gpkg_utils.py", line 34, in verify_indices con.execute(index) sqlite3.OperationalError: no such table: main.divides

image

jameshalgren commented 3 months ago

The application is looking for a table in the conus.gpkg file. @chp2001, we might need to update the instructions. Step 5, as the steps are currently laid out, should be in front of step 3, like this:

1) Clone this repo 2) Download hydrofabric geopackage files

cd data_sources
wget https://lynker-spatial.s3.amazonaws.com/v20.1/conus.gpkg
wget https://lynker-spatial.s3.amazonaws.com/v20.1/model_attributes.parquet
cd ..
# to run
./run.sh
# the first run may seem slow to start as it needs to generate a river network

3) Open the repository folder in vscode
4) Click through the popups in the bottom right of the vscode window. Depending on what you've already got installed, it may install wsl, docker, and the vscode devcontainer extension
5) Wait for it to finish building, view the log to watch it build

JoshCu commented 1 month ago

22 Added code to automatically download these two files on first launch of the app which should mitigate this issue.