Changes
On December 6, 2023 at 6:40:56 PM UTC, lladmin:
-
Changed value of field
load_status
of resource Water Quality (2014-04-20 to 2021-09-03) Columbia Lake (S4) toLoading 144 rows to datastore
(previouslyReading tabular file clss_waterquality_s4_20140420_20210903.csv (csv)
) in Columbia Lake (S4)
f | 1 | { | f | 1 | { |
2 | "author": null, | 2 | "author": null, | ||
3 | "author_email": null, | 3 | "author_email": null, | ||
4 | "citation": "Columbia Lake Stewardship Society. (2022). Columbia | 4 | "citation": "Columbia Lake Stewardship Society. (2022). Columbia | ||
5 | Lake (S4) [Data set]. Columbia Basin Water Hub. | 5 | Lake (S4) [Data set]. Columbia Basin Water Hub. | ||
6 | https://doi.org/10.48511/M44B-H052", | 6 | https://doi.org/10.48511/M44B-H052", | ||
7 | "creator": "Columbia Basin Water Hub", | 7 | "creator": "Columbia Basin Water Hub", | ||
8 | "creator_user_id": "74e49cb5-943c-4090-9199-8e29c06b29ef", | 8 | "creator_user_id": "74e49cb5-943c-4090-9199-8e29c06b29ef", | ||
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 themselves.", | 12 | whether it will be appropriate for their purpose themselves.", | ||
13 | "data_type": "Lake", | 13 | "data_type": "Lake", | ||
14 | "end_date": "2022-05-27", | 14 | "end_date": "2022-05-27", | ||
15 | "funding_reference": "This projected is supported by: Columbia Basin | 15 | "funding_reference": "This projected is supported by: Columbia Basin | ||
16 | Trust, Columbia Valley Local Conservation fund, Columbia Valley | 16 | Trust, Columbia Valley Local Conservation fund, Columbia Valley | ||
17 | Community Foundation, District of Canal Flats and supporting | 17 | Community Foundation, District of Canal Flats and supporting | ||
18 | communities.", | 18 | communities.", | ||
19 | "groups": [ | 19 | "groups": [ | ||
20 | { | 20 | { | ||
21 | "description": "This group includes all the datasets which fall | 21 | "description": "This group includes all the datasets which fall | ||
22 | within the Columbia-Kootenay Headwaters Hydrologic region ", | 22 | within the Columbia-Kootenay Headwaters Hydrologic region ", | ||
23 | "display_name": "Columbia-Kootenay Headwaters", | 23 | "display_name": "Columbia-Kootenay Headwaters", | ||
24 | "id": "20673d8f-8f40-4e64-9f34-4966d5123705", | 24 | "id": "20673d8f-8f40-4e64-9f34-4966d5123705", | ||
25 | "image_display_url": | 25 | "image_display_url": | ||
26 | rhub.ca/uploads/group/2021-03-02-214610.209659Mapfinalheadwayers.png", | 26 | rhub.ca/uploads/group/2021-03-02-214610.209659Mapfinalheadwayers.png", | ||
27 | "name": "columbia-kootenay-headwaters", | 27 | "name": "columbia-kootenay-headwaters", | ||
28 | "title": "Columbia-Kootenay Headwaters" | 28 | "title": "Columbia-Kootenay Headwaters" | ||
29 | } | 29 | } | ||
30 | ], | 30 | ], | ||
31 | "id": "5ace930f-f846-4117-8a82-4d294c672da4", | 31 | "id": "5ace930f-f846-4117-8a82-4d294c672da4", | ||
32 | "identifier": "https://doi.org/10.48511/M44B-H052", | 32 | "identifier": "https://doi.org/10.48511/M44B-H052", | ||
33 | "isopen": false, | 33 | "isopen": false, | ||
34 | "keywords": "Community Research Grade,Lab Water Quality,Field Water | 34 | "keywords": "Community Research Grade,Lab Water Quality,Field Water | ||
35 | Quality", | 35 | Quality", | ||
36 | "latitude": "50.17533", | 36 | "latitude": "50.17533", | ||
37 | "license_id": "CC-BY-SA-4.0", | 37 | "license_id": "CC-BY-SA-4.0", | ||
38 | "license_title": "CC-BY-SA-4.0", | 38 | "license_title": "CC-BY-SA-4.0", | ||
39 | "location": "South Columbia Lake.", | 39 | "location": "South Columbia Lake.", | ||
40 | "longitude": "-115.83442", | 40 | "longitude": "-115.83442", | ||
41 | "maintainer": null, | 41 | "maintainer": null, | ||
42 | "maintainer_email": "cbwaterhub@livinglakescanada.ca", | 42 | "maintainer_email": "cbwaterhub@livinglakescanada.ca", | ||
43 | "metadata_created": "2022-10-19T18:19:01.539921", | 43 | "metadata_created": "2022-10-19T18:19:01.539921", | ||
n | 44 | "metadata_modified": "2023-12-06T18:40:56.079689", | n | 44 | "metadata_modified": "2023-12-06T18:40:56.352768", |
45 | "name": "columbia-lake-s4", | 45 | "name": "columbia-lake-s4", | ||
46 | "notes": "Water quality measurements on Columbia Lake north of | 46 | "notes": "Water quality measurements on Columbia Lake north of | ||
47 | Tilley Memorial Park, collected as part of CLSS water monitoring | 47 | Tilley Memorial Park, collected as part of CLSS water monitoring | ||
48 | program.", | 48 | program.", | ||
49 | "num_resources": 2, | 49 | "num_resources": 2, | ||
50 | "num_tags": 3, | 50 | "num_tags": 3, | ||
51 | "organization": { | 51 | "organization": { | ||
52 | "approval_status": "approved", | 52 | "approval_status": "approved", | ||
53 | "created": "2021-09-03T14:49:38.225713", | 53 | "created": "2021-09-03T14:49:38.225713", | ||
54 | "description": "The Columbia Lake Stewardship Society is an | 54 | "description": "The Columbia Lake Stewardship Society is an | ||
55 | environmental stewardship organization working to preserve the | 55 | environmental stewardship organization working to preserve the | ||
56 | ecological health and water supply of Columbia Lake for present and | 56 | ecological health and water supply of Columbia Lake for present and | ||
57 | future generations through scientific investigation, collaboration, | 57 | future generations through scientific investigation, collaboration, | ||
58 | and outreach.\r\n", | 58 | and outreach.\r\n", | ||
59 | "id": "e6b9b424-d988-4378-b8c8-ac81f1ef3f91", | 59 | "id": "e6b9b424-d988-4378-b8c8-ac81f1ef3f91", | ||
60 | "image_url": "2021-09-03-214952.111892CLSS-logo.jpg", | 60 | "image_url": "2021-09-03-214952.111892CLSS-logo.jpg", | ||
61 | "is_organization": true, | 61 | "is_organization": true, | ||
62 | "name": "clss", | 62 | "name": "clss", | ||
63 | "state": "active", | 63 | "state": "active", | ||
64 | "title": "Columbia Lake Stewardship Society", | 64 | "title": "Columbia Lake Stewardship Society", | ||
65 | "type": "organization" | 65 | "type": "organization" | ||
66 | }, | 66 | }, | ||
67 | "other_sources": "", | 67 | "other_sources": "", | ||
68 | "owner_org": "e6b9b424-d988-4378-b8c8-ac81f1ef3f91", | 68 | "owner_org": "e6b9b424-d988-4378-b8c8-ac81f1ef3f91", | ||
69 | "private": false, | 69 | "private": false, | ||
70 | "publication_year": "2022", | 70 | "publication_year": "2022", | ||
71 | "relationships_as_object": [], | 71 | "relationships_as_object": [], | ||
72 | "relationships_as_subject": [], | 72 | "relationships_as_subject": [], | ||
73 | "resources": [ | 73 | "resources": [ | ||
74 | { | 74 | { | ||
75 | "cache_last_updated": null, | 75 | "cache_last_updated": null, | ||
76 | "cache_url": null, | 76 | "cache_url": null, | ||
77 | "created": "2022-10-19T18:22:47.958856", | 77 | "created": "2022-10-19T18:22:47.958856", | ||
78 | "data_collection_info": "Four sample bottles are filled with | 78 | "data_collection_info": "Four sample bottles are filled with | ||
79 | lake water. Three of these bottles are unfiltered, and filled using a | 79 | lake water. Three of these bottles are unfiltered, and filled using a | ||
80 | measuring cup. One of the bottles is filtered using a new syringe and | 80 | measuring cup. One of the bottles is filtered using a new syringe and | ||
81 | filter apparatus.", | 81 | filter apparatus.", | ||
82 | "data_processing": "Analyzed data as delivered by CARO | 82 | "data_processing": "Analyzed data as delivered by CARO | ||
83 | Analytical Services.", | 83 | Analytical Services.", | ||
84 | "data_type": "non-lab", | 84 | "data_type": "non-lab", | ||
85 | "datastore_active": false, | 85 | "datastore_active": false, | ||
86 | "datastore_contains_all_records_of_source_file": false, | 86 | "datastore_contains_all_records_of_source_file": false, | ||
87 | "datastore_status": "pending", | 87 | "datastore_status": "pending", | ||
88 | "description": "Lab results for the samples taken at the S4 | 88 | "description": "Lab results for the samples taken at the S4 | ||
89 | sampling site on Columbia Lake since 2014. Dataset collected to better | 89 | sampling site on Columbia Lake since 2014. Dataset collected to better | ||
90 | understand health of Columbia lake and to communicate information to | 90 | understand health of Columbia lake and to communicate information to | ||
91 | decision makers for strategic planning for management strategies, as | 91 | decision makers for strategic planning for management strategies, as | ||
92 | well as to support our contributing partners for their future projects | 92 | well as to support our contributing partners for their future projects | ||
93 | and initiatives.", | 93 | and initiatives.", | ||
94 | "format": "CSV", | 94 | "format": "CSV", | ||
95 | "hash": "578fcb6919b4b13f2f396501634fbe91", | 95 | "hash": "578fcb6919b4b13f2f396501634fbe91", | ||
96 | "header_row": "1", | 96 | "header_row": "1", | ||
97 | "id": "29686362-7c87-4777-969c-4311ecf71fb1", | 97 | "id": "29686362-7c87-4777-969c-4311ecf71fb1", | ||
98 | "last_modified": "2023-12-06T18:40:52.127544", | 98 | "last_modified": "2023-12-06T18:40:52.127544", | ||
t | 99 | "load_status": "Reading tabular file | t | 99 | "load_status": "Loading 144 rows to datastore", |
100 | clss_waterquality_s4_20140420_20210903.csv (csv)", | ||||
101 | "metadata_modified": "2023-12-06T18:40:56.082982", | 100 | "metadata_modified": "2023-12-06T18:40:56.355787", | ||
102 | "mimetype": "text/csv", | 101 | "mimetype": "text/csv", | ||
103 | "mimetype_inner": null, | 102 | "mimetype_inner": null, | ||
104 | "name": "Water Quality (2014-04-20 to 2021-09-03) Columbia Lake | 103 | "name": "Water Quality (2014-04-20 to 2021-09-03) Columbia Lake | ||
105 | (S4)", | 104 | (S4)", | ||
106 | "package_id": "5ace930f-f846-4117-8a82-4d294c672da4", | 105 | "package_id": "5ace930f-f846-4117-8a82-4d294c672da4", | ||
107 | "position": 0, | 106 | "position": 0, | ||
108 | "recent_qa_date": "2022-10-01", | 107 | "recent_qa_date": "2022-10-01", | ||
109 | "resource_citation": "CLSS. (2022). Water Quality (2014-04-20 to | 108 | "resource_citation": "CLSS. (2022). Water Quality (2014-04-20 to | ||
110 | 2021-09-03) Columbia Lake (S4) [Resource]. Columbia Basin Water Hub. | 109 | 2021-09-03) Columbia Lake (S4) [Resource]. Columbia Basin Water Hub. | ||
111 | https://doi.org/10.48511/M44B-H052", | 110 | https://doi.org/10.48511/M44B-H052", | ||
112 | "resource_data_disclaimer": "No warranty or guarantee exists | 111 | "resource_data_disclaimer": "No warranty or guarantee exists | ||
113 | that the information is accurate, complete, current, or suitable for | 112 | that the information is accurate, complete, current, or suitable for | ||
114 | any purpose. The individual user must confirm the accuracy of the data | 113 | any purpose. The individual user must confirm the accuracy of the data | ||
115 | and whether it will be appropriate for their purpose themselves.", | 114 | and whether it will be appropriate for their purpose themselves.", | ||
116 | "resource_location": "South end of the lake, just north of | 115 | "resource_location": "South end of the lake, just north of | ||
117 | Tilley Memorial Park.", | 116 | Tilley Memorial Park.", | ||
118 | "resource_type": null, | 117 | "resource_type": null, | ||
119 | "size": 23444, | 118 | "size": 23444, | ||
120 | "state": "active", | 119 | "state": "active", | ||
121 | "url": | 120 | "url": | ||
122 | 69c-4311ecf71fb1/download/clss_waterquality_s4_20140420_20210903.csv", | 121 | 69c-4311ecf71fb1/download/clss_waterquality_s4_20140420_20210903.csv", | ||
123 | "url_type": "upload", | 122 | "url_type": "upload", | ||
124 | "waterhub_grade": "Community Research Grade" | 123 | "waterhub_grade": "Community Research Grade" | ||
125 | }, | 124 | }, | ||
126 | { | 125 | { | ||
127 | "cache_last_updated": null, | 126 | "cache_last_updated": null, | ||
128 | "cache_url": null, | 127 | "cache_url": null, | ||
129 | "created": "2022-10-19T18:26:21.549082", | 128 | "created": "2022-10-19T18:26:21.549082", | ||
130 | "data_collection_info": "Data collected by summer student and | 129 | "data_collection_info": "Data collected by summer student and | ||
131 | program coordinator with help of volunteers. Test for turbidity, pH, | 130 | program coordinator with help of volunteers. Test for turbidity, pH, | ||
132 | specific conductivity, dissolved oxygen, air temperature, water | 131 | specific conductivity, dissolved oxygen, air temperature, water | ||
133 | temperature, and lake depth.", | 132 | temperature, and lake depth.", | ||
134 | "data_processing": "The Water Hub has performed a preliminary | 133 | "data_processing": "The Water Hub has performed a preliminary | ||
135 | QA/QC protocol on this data and has flagged a value that was | 134 | QA/QC protocol on this data and has flagged a value that was | ||
136 | identified as unexpected, but the individual user must still confirm | 135 | identified as unexpected, but the individual user must still confirm | ||
137 | the accuracy of the data and whether it will be appropriate for their | 136 | the accuracy of the data and whether it will be appropriate for their | ||
138 | purpose.", | 137 | purpose.", | ||
139 | "data_type": "non-lab", | 138 | "data_type": "non-lab", | ||
140 | "datastore_active": false, | 139 | "datastore_active": false, | ||
141 | "datastore_contains_all_records_of_source_file": false, | 140 | "datastore_contains_all_records_of_source_file": false, | ||
142 | "datastore_status": "", | 141 | "datastore_status": "", | ||
143 | "description": "Water quality data collected by the CLSS since | 142 | "description": "Water quality data collected by the CLSS since | ||
144 | 2014 for location S4 in the water quality monitoring program.", | 143 | 2014 for location S4 in the water quality monitoring program.", | ||
145 | "format": "XLSX", | 144 | "format": "XLSX", | ||
146 | "hash": "9dd4ad72658912c299e99bf6bd8b44ec", | 145 | "hash": "9dd4ad72658912c299e99bf6bd8b44ec", | ||
147 | "header_row": "1", | 146 | "header_row": "1", | ||
148 | "id": "8674101d-3ac8-4b5f-8936-a76709e80c45", | 147 | "id": "8674101d-3ac8-4b5f-8936-a76709e80c45", | ||
149 | "last_modified": "2022-10-19T18:26:21.528794", | 148 | "last_modified": "2022-10-19T18:26:21.528794", | ||
150 | "load_status": "ERROR: Unable to find a usable engine; tried | 149 | "load_status": "ERROR: Unable to find a usable engine; tried | ||
151 | using: 'sqlalchemy'.\r\nA suitable version of sqlalchemy is required | 150 | using: 'sqlalchemy'.\r\nA suitable version of sqlalchemy is required | ||
152 | for sql I/O support.\r\nTrying to import the above resulted in these | 151 | for sql I/O support.\r\nTrying to import the above resulted in these | ||
153 | errors:\r\n - Pandas requires version '1.4.16' or newer of | 152 | errors:\r\n - Pandas requires version '1.4.16' or newer of | ||
154 | 'sqlalchemy' (version '1.3.5' currently installed).", | 153 | 'sqlalchemy' (version '1.3.5' currently installed).", | ||
155 | "metadata_modified": "2023-12-06T18:40:52.140362", | 154 | "metadata_modified": "2023-12-06T18:40:52.140362", | ||
156 | "mimetype": | 155 | "mimetype": | ||
157 | "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", | 156 | "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", | ||
158 | "mimetype_inner": null, | 157 | "mimetype_inner": null, | ||
159 | "name": "Field Water Quality (2014-04-20 to 2022-05-27) Columbia | 158 | "name": "Field Water Quality (2014-04-20 to 2022-05-27) Columbia | ||
160 | Lake (S4)", | 159 | Lake (S4)", | ||
161 | "package_id": "5ace930f-f846-4117-8a82-4d294c672da4", | 160 | "package_id": "5ace930f-f846-4117-8a82-4d294c672da4", | ||
162 | "position": 1, | 161 | "position": 1, | ||
163 | "recent_qa_date": "2022-10-01", | 162 | "recent_qa_date": "2022-10-01", | ||
164 | "resource_citation": "CLSS. (2022). Field Water Quality | 163 | "resource_citation": "CLSS. (2022). Field Water Quality | ||
165 | (2014-04-20 to 2022-05-27) Columbia Lake (S4) [Resource]. Columbia | 164 | (2014-04-20 to 2022-05-27) Columbia Lake (S4) [Resource]. Columbia | ||
166 | Basin Water Hub. https://doi.org/10.48511/M44B-H052", | 165 | Basin Water Hub. https://doi.org/10.48511/M44B-H052", | ||
167 | "resource_data_disclaimer": "No warranty or guarantee exists | 166 | "resource_data_disclaimer": "No warranty or guarantee exists | ||
168 | that the information is accurate, complete, current, or suitable for | 167 | that the information is accurate, complete, current, or suitable for | ||
169 | any purpose. The individual user must confirm the accuracy of the data | 168 | any purpose. The individual user must confirm the accuracy of the data | ||
170 | and whether it will be appropriate for their purpose themselves.", | 169 | and whether it will be appropriate for their purpose themselves.", | ||
171 | "resource_location": "South end of Columbia Lake, just North of | 170 | "resource_location": "South end of Columbia Lake, just North of | ||
172 | Tilley Memorial Park.", | 171 | Tilley Memorial Park.", | ||
173 | "resource_type": null, | 172 | "resource_type": null, | ||
174 | "size": 90755, | 173 | "size": 90755, | ||
175 | "state": "active", | 174 | "state": "active", | ||
176 | "url": | 175 | "url": | ||
177 | 6709e80c45/download/clss_fieldwaterquality_s4_20140420_20220527.xlsx", | 176 | 6709e80c45/download/clss_fieldwaterquality_s4_20140420_20220527.xlsx", | ||
178 | "url_type": "upload", | 177 | "url_type": "upload", | ||
179 | "waterhub_grade": "Community Research Grade" | 178 | "waterhub_grade": "Community Research Grade" | ||
180 | } | 179 | } | ||
181 | ], | 180 | ], | ||
182 | "start_date": "2014-04-20", | 181 | "start_date": "2014-04-20", | ||
183 | "state": "active", | 182 | "state": "active", | ||
184 | "tags": [ | 183 | "tags": [ | ||
185 | { | 184 | { | ||
186 | "display_name": "Community Research Grade", | 185 | "display_name": "Community Research Grade", | ||
187 | "id": "1f0dafbc-c76f-4b7c-9200-880b759fe7f4", | 186 | "id": "1f0dafbc-c76f-4b7c-9200-880b759fe7f4", | ||
188 | "name": "Community Research Grade", | 187 | "name": "Community Research Grade", | ||
189 | "state": "active", | 188 | "state": "active", | ||
190 | "vocabulary_id": null | 189 | "vocabulary_id": null | ||
191 | }, | 190 | }, | ||
192 | { | 191 | { | ||
193 | "display_name": "Field Water Quality", | 192 | "display_name": "Field Water Quality", | ||
194 | "id": "f7ccfe9a-95ee-462f-8503-44ae52c0802e", | 193 | "id": "f7ccfe9a-95ee-462f-8503-44ae52c0802e", | ||
195 | "name": "Field Water Quality", | 194 | "name": "Field Water Quality", | ||
196 | "state": "active", | 195 | "state": "active", | ||
197 | "vocabulary_id": null | 196 | "vocabulary_id": null | ||
198 | }, | 197 | }, | ||
199 | { | 198 | { | ||
200 | "display_name": "Lab Water Quality", | 199 | "display_name": "Lab Water Quality", | ||
201 | "id": "5a36f422-9cf9-481b-810d-9f697259b26c", | 200 | "id": "5a36f422-9cf9-481b-810d-9f697259b26c", | ||
202 | "name": "Lab Water Quality", | 201 | "name": "Lab Water Quality", | ||
203 | "state": "active", | 202 | "state": "active", | ||
204 | "vocabulary_id": null | 203 | "vocabulary_id": null | ||
205 | } | 204 | } | ||
206 | ], | 205 | ], | ||
207 | "title": "Columbia Lake (S4)", | 206 | "title": "Columbia Lake (S4)", | ||
208 | "type": "dataset", | 207 | "type": "dataset", | ||
209 | "url": null, | 208 | "url": null, | ||
210 | "version": null | 209 | "version": null | ||
211 | } | 210 | } |