Data · dataset · 2019
To Estimate and Optimize the Source of Drinking Water for Metro Vancouver until 2040
Listed in Borealis and Agri-environmental Research Data Dataverse — shown once because both records carry DOI 10.5683/sp2/6ku4i7
The population of Metro Vancouver (20110729Regional Growth Strategy Projections Population, Housing and Employment 2006 – 2041 File) will have increased greatly by 2040, and finding a new source of reservoirs for drinking water (2015_ Water Consumption_ Statistics File) will be essential.
Description
This issue of drinking water needs to be optimized and estimated (Data Mining file) with the aim of developing the region. Three current sources of water reservoirs for Metro Vancouver are Capilano, Seymour, and Coquitlam, in which the treated water is being supplied to the customer.
The linear optimization (LP) model (Optimization, Sensitivity Report File) illustrates the amount of drinking water for each reservoir and region. In fact, the B.C. government has a specific strategy for the growing population till 2040, which leads them toward their goal. In addition, another factor is the new water source for drinking water that needs to be estimated and monitored to anticipate the feasible water source (wells) until 2040.
Read the rest (3 more)
As such, the government will have to make a decision on how much groundwater is used. The goal of the project is two steps: (1) an optimization model for three water reservoirs, and (2) estimating the new source of water to 2040. The process of data analysis for the project includes: the data is analyzed with six software—Trifacta Wrangler, AMPL, Excel Solver, Arc GIS, and SQL—and is visualized in Tableau. 1.
Trifacta Wrangler Software clean data (Data Mining file). 2. AMPL and Solver Excel Software optimize drinking water consumption for Metro Vancouver (data in the Optimization and Sensitivity Report file). 3. ArcMap collaborates the raw data and result of the optimization water reservoir and estimating population till 2040 with the ArcGIS software (GIS Map for Tableau file). 4.
Visualizing, estimating, and optimizing the source of drinking water for Metro Vancouver until 2040 with SQL software in Tableau (export tableau data file).
Links
Where it is published
- Dataverse dataset page borealisdata.ca/dataset.xhtml?persistentId=doi%3A10.5683%2FSP2%2F6KU4I7 ↗
landing page · from borealisdata ca
- DOI doi.org/10.5683/sp2/6ku4i7 ↗
DOI / persistent id · from borealisdata ca
Catalogue records · 1
- Dataverse API borealisdata.ca/api/datasets/:persistentId/?persistentId=doi%3A10.5683%2FSP2%2… ↗
metadata API · from borealisdata ca
Topics
- Stated by source
- Engineering · Engineering
Provenance · 2 source records, 21 field assertions
| Source | Key | Last seen | Raw |
|---|---|---|---|
| Borealis | doi:10.5683/SP2/6KU4I7 | 10 d ago | JSON v1 |
| Agri-environmental Research Data Dataverse | doi:10.5683/SP2/6KU4I7 | 9 d ago | JSON v1 |
| Field | Assertion | Extractor | Evidence |
|---|---|---|---|
| concepts[field].dataverse_subject:engineering | source · borealisdata ca | connector:borealisdata_ca@1.0.0 | /subjects |
| concepts[field].dataverse_subject:engineering | source · borealisdata ca dataverse | connector:borealisdata_ca_dataverse@1.0.0 | /subjects |
| concepts[field].local:field:chemistry | mapping · borealisdata ca dataverse | connector:borealisdata_ca_dataverse@1.0.0 | /subjects |
| concepts[field].local:field:computer-science-ai | mapping · borealisdata ca dataverse | connector:borealisdata_ca_dataverse@1.0.0 | /subjects |
| concepts[field].local:field:earth-environmental | mapping · borealisdata ca dataverse | connector:borealisdata_ca_dataverse@1.0.0 | /subjects |
| concepts[field].local:field:earth-environmental | mapping · borealisdata ca | connector:borealisdata_ca@1.0.0 | /subjects |
| concepts[field].local:field:economics-finance | mapping · borealisdata ca dataverse | connector:borealisdata_ca_dataverse@1.0.0 | /subjects |
| concepts[field].local:field:engineering | mapping · borealisdata ca dataverse | connector:borealisdata_ca_dataverse@1.0.0 | /subjects |
| concepts[field].local:field:engineering | mapping · borealisdata ca | connector:borealisdata_ca@1.0.0 | /subjects |
| concepts[field].local:field:humanities | mapping · borealisdata ca dataverse | connector:borealisdata_ca_dataverse@1.0.0 | /subjects |
| concepts[field].local:field:life-sciences | mapping · borealisdata ca dataverse | connector:borealisdata_ca_dataverse@1.0.0 | /subjects |
| concepts[field].local:field:mathematics-statistics | mapping · borealisdata ca dataverse | connector:borealisdata_ca_dataverse@1.0.0 | /subjects |
| concepts[field].local:field:medicine-health | mapping · borealisdata ca dataverse | connector:borealisdata_ca_dataverse@1.0.0 | /subjects |
| concepts[field].local:field:ocean-atmospheric | mapping · borealisdata ca dataverse | connector:borealisdata_ca_dataverse@1.0.0 | /subjects |
| concepts[field].local:field:social-science | mapping · borealisdata ca dataverse | connector:borealisdata_ca_dataverse@1.0.0 | /subjects |
| created_date | source · borealisdata ca | connector:borealisdata_ca@1.0.0 | |
| description | source · borealisdata ca | connector:borealisdata_ca@1.0.0 | /description |
| publication_date | source · borealisdata ca | connector:borealisdata_ca@1.0.0 | |
| title | source · borealisdata ca | connector:borealisdata_ca@1.0.0 | /name |
| updated_date | source · borealisdata ca | connector:borealisdata_ca@1.0.0 | |
| version_label | source · borealisdata ca | connector:borealisdata_ca@1.0.0 |