Changes
On December 6, 2023 at 5:27:15 PM UTC, michael-stockermans-1908:
-
Set format of resource Water Quality (2017 to 2021) Carpenter Creek to CSV (previously XLSX) in Carpenter Creek Water Quality Monitoring
-
Uploaded a new file to resource Water Quality (2017 to 2021) Carpenter Creek in Carpenter Creek Water Quality Monitoring
-
Added the following fields to resource Water Quality (2017 to 2021) Carpenter Creek in Carpenter Creek Water Quality Monitoring
-
datastore_contains_all_records_of_source_file with value
data_type with value
recent_qa_date with value
-
Removed field
waterhub_certified
from resource Water Quality (2017 to 2021) Carpenter Creek in Carpenter Creek Water Quality Monitoring -
Changed value of field
load_status
of resource Water Quality (2017 to 2021) Carpenter Creek toERROR: Unable to find a usable engine; tried using: 'sqlalchemy'. A suitable version of sqlalchemy is required for sql I/O support. Trying to import the above resulted in these errors: - Pandas requires version '1.4.16' or newer of 'sqlalchemy' (version '1.3.5' currently installed).
(previouslyERROR: Unable to find a usable engine; tried using: 'sqlalchemy'. A suitable version of sqlalchemy is required for sql I/O support. Trying to import the above resulted in these errors: - Pandas requires version '1.4.16' or newer of 'sqlalchemy' (version '1.3.5' currently installed).
) in Carpenter Creek Water Quality Monitoring
f | 1 | { | f | 1 | { |
2 | "author": null, | 2 | "author": null, | ||
3 | "author_email": null, | 3 | "author_email": null, | ||
4 | "citation": "Slocan Lake Stewardship Society. (2021). Carpenter | 4 | "citation": "Slocan Lake Stewardship Society. (2021). Carpenter | ||
5 | Creek Water Quality Monitoring [Data set]. Columbia Basin Water Hub. | 5 | Creek Water Quality Monitoring [Data set]. Columbia Basin Water Hub. | ||
6 | https://doi.org/10.48511/DQRQ-S461", | 6 | https://doi.org/10.48511/DQRQ-S461", | ||
7 | "creator": "Slocan Lake Stewardship Society", | 7 | "creator": "Slocan Lake Stewardship Society", | ||
8 | "creator_user_id": "f510817b-5df1-47a6-9a21-a22c9f1eaa77", | 8 | "creator_user_id": "f510817b-5df1-47a6-9a21-a22c9f1eaa77", | ||
9 | "data_disclaimer": "No warranty or guarantee exists that the | 9 | "data_disclaimer": "No warranty or guarantee exists that the | ||
10 | information is accurate, complete, current, or suitable for any | 10 | information is accurate, complete, current, or suitable for any | ||
11 | purpose. The individual user must confirm the accuracy of the data and | 11 | purpose. The individual user must confirm the accuracy of the data and | ||
12 | whether it will be appropriate for their purpose.", | 12 | whether it will be appropriate for their purpose.", | ||
13 | "data_type": "Stream", | 13 | "data_type": "Stream", | ||
14 | "end_date": "2021-12-27", | 14 | "end_date": "2021-12-27", | ||
15 | "funding_reference": "This monitoring program has operated with past | 15 | "funding_reference": "This monitoring program has operated with past | ||
16 | support of Columbia Basin Trust, currently supported and operated by | 16 | support of Columbia Basin Trust, currently supported and operated by | ||
17 | SLSS volunteers. ", | 17 | SLSS volunteers. ", | ||
18 | "groups": [ | 18 | "groups": [ | ||
19 | { | 19 | { | ||
20 | "description": "This group includes all the datasets which fall | 20 | "description": "This group includes all the datasets which fall | ||
21 | within the Mid Columbia-Kootenay Hydrologic region ", | 21 | within the Mid Columbia-Kootenay Hydrologic region ", | ||
n | 22 | "display_name": "Mid Columbia-Kootenay", | n | 22 | "display_name": "Mid-Columbia Kootenay", |
23 | "id": "f1292df6-8c73-419f-b3ce-9c7e831ca78d", | 23 | "id": "f1292df6-8c73-419f-b3ce-9c7e831ca78d", | ||
24 | "image_display_url": | 24 | "image_display_url": | ||
25 | terhub.ca/uploads/group/2021-03-03-004652.569487Mapfinalmidkoots.png", | 25 | terhub.ca/uploads/group/2021-03-03-004652.569487Mapfinalmidkoots.png", | ||
26 | "name": "mid-columbia-kootenay", | 26 | "name": "mid-columbia-kootenay", | ||
n | 27 | "title": "Mid Columbia-Kootenay" | n | 27 | "title": "Mid-Columbia Kootenay" |
28 | } | 28 | } | ||
29 | ], | 29 | ], | ||
30 | "id": "524ffafb-a402-46a9-aeb1-510e95e544be", | 30 | "id": "524ffafb-a402-46a9-aeb1-510e95e544be", | ||
31 | "identifier": "10.48511/DQRQ-S461", | 31 | "identifier": "10.48511/DQRQ-S461", | ||
32 | "isopen": false, | 32 | "isopen": false, | ||
33 | "keywords": "Community Research Grade,Water temperature,Stream,Field | 33 | "keywords": "Community Research Grade,Water temperature,Stream,Field | ||
34 | Water Quality", | 34 | Water Quality", | ||
35 | "latitude": "49.98932", | 35 | "latitude": "49.98932", | ||
36 | "license_id": "CC-BY-NC-SA-4.0", | 36 | "license_id": "CC-BY-NC-SA-4.0", | ||
37 | "license_title": "CC-BY-NC-SA-4.0", | 37 | "license_title": "CC-BY-NC-SA-4.0", | ||
38 | "location": "Carpenter Creek, New Denver BC", | 38 | "location": "Carpenter Creek, New Denver BC", | ||
39 | "longitude": "-117.37212", | 39 | "longitude": "-117.37212", | ||
40 | "maintainer": null, | 40 | "maintainer": null, | ||
41 | "maintainer_email": "cbwaterhub@livinglakescanada.ca", | 41 | "maintainer_email": "cbwaterhub@livinglakescanada.ca", | ||
42 | "metadata_created": "2021-03-19T18:32:38.256866", | 42 | "metadata_created": "2021-03-19T18:32:38.256866", | ||
n | 43 | "metadata_modified": "2022-11-23T05:00:14.102618", | n | 43 | "metadata_modified": "2023-12-06T17:27:15.028744", |
44 | "name": "carpenter-creek-water-quality-monitoring", | 44 | "name": "carpenter-creek-water-quality-monitoring", | ||
45 | "notes": "This dataset contains water quality monitoring data from | 45 | "notes": "This dataset contains water quality monitoring data from | ||
46 | Carpenter Creek. Since 2016, SLSS volunteers have been sampling from 4 | 46 | Carpenter Creek. Since 2016, SLSS volunteers have been sampling from 4 | ||
47 | streams that feed Slocan Lake for basic water quality parameters. The | 47 | streams that feed Slocan Lake for basic water quality parameters. The | ||
48 | purpose is to identify unusual changes that might indicate disruptive | 48 | purpose is to identify unusual changes that might indicate disruptive | ||
49 | human activities. ", | 49 | human activities. ", | ||
50 | "num_resources": 1, | 50 | "num_resources": 1, | ||
51 | "num_tags": 4, | 51 | "num_tags": 4, | ||
52 | "organization": { | 52 | "organization": { | ||
53 | "approval_status": "approved", | 53 | "approval_status": "approved", | ||
54 | "created": "2020-07-27T08:34:12.008932", | 54 | "created": "2020-07-27T08:34:12.008932", | ||
55 | "description": "The Slocan Lake Stewardship Society is dedicated | 55 | "description": "The Slocan Lake Stewardship Society is dedicated | ||
56 | to protecting the beauty, health and wonder of the magnificent Slocan | 56 | to protecting the beauty, health and wonder of the magnificent Slocan | ||
57 | Lake ecosystem for future generations. We do this by investing in | 57 | Lake ecosystem for future generations. We do this by investing in | ||
58 | science that helps us learn how Slocan Lake and its surrounding | 58 | science that helps us learn how Slocan Lake and its surrounding | ||
59 | ecosystems function, and what needs to be done to keep the system | 59 | ecosystems function, and what needs to be done to keep the system | ||
60 | healthy; by developing useful, credible and accessible information | 60 | healthy; by developing useful, credible and accessible information | ||
61 | that is publicly shared; and by working cooperatively with local | 61 | that is publicly shared; and by working cooperatively with local | ||
62 | communities and governments to set priorities for managing Slocan Lake | 62 | communities and governments to set priorities for managing Slocan Lake | ||
63 | and its environs in a manner that fosters collective responsibility. | 63 | and its environs in a manner that fosters collective responsibility. | ||
64 | ", | 64 | ", | ||
65 | "id": "8de81e1c-786f-4548-88e1-25129507cdf3", | 65 | "id": "8de81e1c-786f-4548-88e1-25129507cdf3", | ||
66 | "image_url": | 66 | "image_url": | ||
67 | "2021-02-25-212716.467546Slocan-Lake-Stewardship-Society.png", | 67 | "2021-02-25-212716.467546Slocan-Lake-Stewardship-Society.png", | ||
68 | "is_organization": true, | 68 | "is_organization": true, | ||
69 | "name": "slocan-lake-stewardship-society", | 69 | "name": "slocan-lake-stewardship-society", | ||
70 | "state": "active", | 70 | "state": "active", | ||
71 | "title": "Slocan Lake Stewardship Society", | 71 | "title": "Slocan Lake Stewardship Society", | ||
72 | "type": "organization" | 72 | "type": "organization" | ||
73 | }, | 73 | }, | ||
74 | "other_sources": "N/A", | 74 | "other_sources": "N/A", | ||
75 | "owner_org": "8de81e1c-786f-4548-88e1-25129507cdf3", | 75 | "owner_org": "8de81e1c-786f-4548-88e1-25129507cdf3", | ||
76 | "private": false, | 76 | "private": false, | ||
77 | "publication_year": "2021", | 77 | "publication_year": "2021", | ||
78 | "relationships_as_object": [], | 78 | "relationships_as_object": [], | ||
79 | "relationships_as_subject": [], | 79 | "relationships_as_subject": [], | ||
80 | "resources": [ | 80 | "resources": [ | ||
81 | { | 81 | { | ||
82 | "cache_last_updated": null, | 82 | "cache_last_updated": null, | ||
83 | "cache_url": null, | 83 | "cache_url": null, | ||
84 | "created": "2021-03-19T18:33:32.644863", | 84 | "created": "2021-03-19T18:33:32.644863", | ||
85 | "data_collection_info": "Temperature measurements are taken | 85 | "data_collection_info": "Temperature measurements are taken | ||
86 | in-stream. Water samples are collected, and analysed in batches on the | 86 | in-stream. Water samples are collected, and analysed in batches on the | ||
87 | dates noted as \"Analysis\" in the \"Remarks\" column. Instruments | 87 | dates noted as \"Analysis\" in the \"Remarks\" column. Instruments | ||
88 | used are calibrated as per manufacturer instructions and standards.", | 88 | used are calibrated as per manufacturer instructions and standards.", | ||
89 | "data_processing": "The Water Hub has performed a preliminary | 89 | "data_processing": "The Water Hub has performed a preliminary | ||
90 | QA/QC protocol on this data and has flagged a value that was | 90 | QA/QC protocol on this data and has flagged a value that was | ||
91 | identified as unexpected, but the individual user must still confirm | 91 | identified as unexpected, but the individual user must still confirm | ||
92 | the accuracy of the data and whether it will be appropriate for their | 92 | the accuracy of the data and whether it will be appropriate for their | ||
93 | purpose.\r\n", | 93 | purpose.\r\n", | ||
n | n | 94 | "data_type": "non-lab", | ||
94 | "datastore_active": false, | 95 | "datastore_active": false, | ||
n | n | 96 | "datastore_contains_all_records_of_source_file": false, | ||
95 | "datastore_status": "", | 97 | "datastore_status": "", | ||
96 | "description": "This resource is a record of water quality | 98 | "description": "This resource is a record of water quality | ||
97 | monitoring for Silverton Creek. It is part of the water quality | 99 | monitoring for Silverton Creek. It is part of the water quality | ||
98 | monitoring program which occurs in 4 creeks which are tributaries of | 100 | monitoring program which occurs in 4 creeks which are tributaries of | ||
99 | Slocan Lake. This program started in 2016 and is operated by | 101 | Slocan Lake. This program started in 2016 and is operated by | ||
100 | volunteers.", | 102 | volunteers.", | ||
n | 101 | "format": "XLSX", | n | 103 | "format": "CSV", |
102 | "hash": "be7c16d6978f0ec062168e3e9d7f9d87", | 104 | "hash": "be7c16d6978f0ec062168e3e9d7f9d87", | ||
103 | "header_row": "1", | 105 | "header_row": "1", | ||
104 | "id": "7efb0cd1-db02-4854-a0bc-83d9ffaca65e", | 106 | "id": "7efb0cd1-db02-4854-a0bc-83d9ffaca65e", | ||
n | 105 | "last_modified": "2022-08-23T20:59:25.834906", | n | 107 | "last_modified": "2023-12-06T17:27:15.021777", |
106 | "load_status": "ERROR: Unable to find a usable engine; tried | 108 | "load_status": "ERROR: Unable to find a usable engine; tried | ||
n | 107 | using: 'sqlalchemy'.\nA suitable version of sqlalchemy is required for | n | 109 | using: 'sqlalchemy'.\r\nA suitable version of sqlalchemy is required |
108 | sql I/O support.\nTrying to import the above resulted in these | 110 | for sql I/O support.\r\nTrying to import the above resulted in these | ||
109 | errors:\n - Pandas requires version '1.4.16' or newer of 'sqlalchemy' | 111 | errors:\r\n - Pandas requires version '1.4.16' or newer of | ||
110 | (version '1.3.5' currently installed).", | 112 | 'sqlalchemy' (version '1.3.5' currently installed).", | ||
111 | "metadata_modified": "2022-11-23T05:00:14.105568", | 113 | "metadata_modified": "2023-12-06T17:27:15.032101", | ||
112 | "mimetype": | 114 | "mimetype": "text/csv", | ||
113 | "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", | ||||
114 | "mimetype_inner": null, | 115 | "mimetype_inner": null, | ||
115 | "name": "Water Quality (2017 to 2021) Carpenter Creek", | 116 | "name": "Water Quality (2017 to 2021) Carpenter Creek", | ||
116 | "package_id": "524ffafb-a402-46a9-aeb1-510e95e544be", | 117 | "package_id": "524ffafb-a402-46a9-aeb1-510e95e544be", | ||
117 | "position": 0, | 118 | "position": 0, | ||
n | n | 119 | "recent_qa_date": "", | ||
118 | "resource_citation": "Slocan Lake Stewardship Society. (2021) | 120 | "resource_citation": "Slocan Lake Stewardship Society. (2021) | ||
119 | Carpenter Creek Water Quality Monitoring 2017-2021. Columbia Basin | 121 | Carpenter Creek Water Quality Monitoring 2017-2021. Columbia Basin | ||
120 | Water Hub. [Resource]. New Denver. (DOI)", | 122 | Water Hub. [Resource]. New Denver. (DOI)", | ||
121 | "resource_data_disclaimer": "No warranty or guarantee exists | 123 | "resource_data_disclaimer": "No warranty or guarantee exists | ||
122 | that the information is accurate, complete, current, or suitable for | 124 | that the information is accurate, complete, current, or suitable for | ||
123 | any purpose. Some metadata may be missing from this file. Instrument | 125 | any purpose. Some metadata may be missing from this file. Instrument | ||
124 | accuracy may be limited. The individual user must confirm the accuracy | 126 | accuracy may be limited. The individual user must confirm the accuracy | ||
125 | of the data and whether it will be appropriate for their purpose.", | 127 | of the data and whether it will be appropriate for their purpose.", | ||
126 | "resource_location": "Carpenter Creek, New Denver BC", | 128 | "resource_location": "Carpenter Creek, New Denver BC", | ||
127 | "resource_type": null, | 129 | "resource_type": null, | ||
n | 128 | "size": 212612, | n | 130 | "size": 27737, |
129 | "state": "active", | 131 | "state": "active", | ||
130 | "url": | 132 | "url": | ||
n | 131 | 3d9ffaca65e/download/slss_waterquality_carpentercreek_2017_2021.xlsx", | n | 133 | a65e/download/slss_waterquality_carpentercreek_20171202_20211227.csv", |
132 | "url_type": "upload", | 134 | "url_type": "upload", | ||
t | 133 | "waterhub_certified": "Certified", | t | ||
134 | "waterhub_grade": "Community Research Grade" | 135 | "waterhub_grade": "Community Research Grade" | ||
135 | } | 136 | } | ||
136 | ], | 137 | ], | ||
137 | "start_date": "2017-12-21", | 138 | "start_date": "2017-12-21", | ||
138 | "state": "active", | 139 | "state": "active", | ||
139 | "tags": [ | 140 | "tags": [ | ||
140 | { | 141 | { | ||
141 | "display_name": "Community Research Grade", | 142 | "display_name": "Community Research Grade", | ||
142 | "id": "1f0dafbc-c76f-4b7c-9200-880b759fe7f4", | 143 | "id": "1f0dafbc-c76f-4b7c-9200-880b759fe7f4", | ||
143 | "name": "Community Research Grade", | 144 | "name": "Community Research Grade", | ||
144 | "state": "active", | 145 | "state": "active", | ||
145 | "vocabulary_id": null | 146 | "vocabulary_id": null | ||
146 | }, | 147 | }, | ||
147 | { | 148 | { | ||
148 | "display_name": "Field Water Quality", | 149 | "display_name": "Field Water Quality", | ||
149 | "id": "f7ccfe9a-95ee-462f-8503-44ae52c0802e", | 150 | "id": "f7ccfe9a-95ee-462f-8503-44ae52c0802e", | ||
150 | "name": "Field Water Quality", | 151 | "name": "Field Water Quality", | ||
151 | "state": "active", | 152 | "state": "active", | ||
152 | "vocabulary_id": null | 153 | "vocabulary_id": null | ||
153 | }, | 154 | }, | ||
154 | { | 155 | { | ||
155 | "display_name": "Stream", | 156 | "display_name": "Stream", | ||
156 | "id": "208421f0-ebb5-4b32-8111-2ff156803d73", | 157 | "id": "208421f0-ebb5-4b32-8111-2ff156803d73", | ||
157 | "name": "Stream", | 158 | "name": "Stream", | ||
158 | "state": "active", | 159 | "state": "active", | ||
159 | "vocabulary_id": null | 160 | "vocabulary_id": null | ||
160 | }, | 161 | }, | ||
161 | { | 162 | { | ||
162 | "display_name": "Water temperature", | 163 | "display_name": "Water temperature", | ||
163 | "id": "0770347d-73eb-4f60-a661-50199f7049c3", | 164 | "id": "0770347d-73eb-4f60-a661-50199f7049c3", | ||
164 | "name": "Water temperature", | 165 | "name": "Water temperature", | ||
165 | "state": "active", | 166 | "state": "active", | ||
166 | "vocabulary_id": null | 167 | "vocabulary_id": null | ||
167 | } | 168 | } | ||
168 | ], | 169 | ], | ||
169 | "title": "Carpenter Creek Water Quality Monitoring", | 170 | "title": "Carpenter Creek Water Quality Monitoring", | ||
170 | "type": "dataset", | 171 | "type": "dataset", | ||
171 | "url": null, | 172 | "url": null, | ||
172 | "version": null | 173 | "version": null | ||
173 | } | 174 | } |