How to Link Obs Well and Aquifer Numbers

Not all groundwater observation wells and aquifer numbers are available to link to so we must keep inclusion lists in the system so that we know when to provide a link to external systems. Here are the steps to obtain lists of wells and aquifers GWELLS can link to.

Obs Well

1. Go to the Obs Well Interactive Map
2. Zoom out to view all of B.C.
3. Click on the 'Select' tool
4. Using the select tool, highlight all active and inactive observation wells in B.C.
5. Use the select tool options to export the data
6. Export the data for both active and inactive wells as CSV
7. For each of the generated CSVs extract the obswellcode field.
8. With each of these columns generate a new CSV with the data including the header.
9. Name these files featuresActiveReduced.csv and featuresInactiveReduced.csv
10. Include these files in the database/external data folder of the gwells clone
11. Clean up the data by hand ... do left padding of zeros and remove empty rows.
12. Run database/cron/post-deploy.sh

Aquifers

1. Go to the Aquifer Classification Database
2. Add checkmarks to the aquifer number and aquifer description boxes
3. Add % to the aquifer number field
4. Click submit to see the full list
5. Copy the list into a spreadsheet.
6. Filter out row for which there is no report
7. Copy the filtered row to a new sheet.
8. Rename the Aq. No column to aquifer_id in the new sheet.
9. Export the new sheet as a CSV
10. Save the generated CSV to database/external-data in the gwells clone as AquiferWithDescription.csv
11. Run database/cron/post-deploy.sh

All aquifers with a blank aquifer description field do not have a downloadable report.