Changes
On December 6, 2023 at 6:36:33 PM UTC, lladmin:
-
Changed value of field
load_status
of resource Water Quality (2014-04-20 to 2021-09-03) Columbia Lake (S1) toReading tabular file clss_waterquality_s1_20140420_20210903.csv (csv)
(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 Columbia Lake (S1)
f | 1 | { | f | 1 | { |
2 | "author": null, | 2 | "author": null, | ||
3 | "author_email": null, | 3 | "author_email": null, | ||
4 | "citation": "CLSS. (2022). Columbia Lake (S1) [Data set]. Columbia | 4 | "citation": "CLSS. (2022). Columbia Lake (S1) [Data set]. Columbia | ||
5 | Basin Water Hub. https://doi.org/10.48511/V4X5-NS17", | 5 | Basin Water Hub. https://doi.org/10.48511/V4X5-NS17", | ||
6 | "creator": "Columbia Basin Water Hub", | 6 | "creator": "Columbia Basin Water Hub", | ||
7 | "creator_user_id": "74e49cb5-943c-4090-9199-8e29c06b29ef", | 7 | "creator_user_id": "74e49cb5-943c-4090-9199-8e29c06b29ef", | ||
8 | "data_disclaimer": "No warranty or guarantee exists that the | 8 | "data_disclaimer": "No warranty or guarantee exists that the | ||
9 | information is accurate, complete, current, or suitable for any | 9 | information is accurate, complete, current, or suitable for any | ||
10 | purpose. The individual user must confirm the accuracy of the data and | 10 | purpose. The individual user must confirm the accuracy of the data and | ||
11 | whether it will be appropriate for their purpose themselves.", | 11 | whether it will be appropriate for their purpose themselves.", | ||
12 | "data_type": "Lake", | 12 | "data_type": "Lake", | ||
13 | "end_date": "2022-05-27", | 13 | "end_date": "2022-05-27", | ||
14 | "funding_reference": "This projected is supported by: Columbia Basin | 14 | "funding_reference": "This projected is supported by: Columbia Basin | ||
15 | Trust, Columbia Valley Local Conservation fund, Columbia Valley | 15 | Trust, Columbia Valley Local Conservation fund, Columbia Valley | ||
16 | Community Foundation, District of Canal Flats and supporting | 16 | Community Foundation, District of Canal Flats and supporting | ||
17 | communities.", | 17 | communities.", | ||
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 Columbia-Kootenay Headwaters Hydrologic region ", | 21 | within the Columbia-Kootenay Headwaters Hydrologic region ", | ||
22 | "display_name": "Columbia-Kootenay Headwaters", | 22 | "display_name": "Columbia-Kootenay Headwaters", | ||
23 | "id": "20673d8f-8f40-4e64-9f34-4966d5123705", | 23 | "id": "20673d8f-8f40-4e64-9f34-4966d5123705", | ||
24 | "image_display_url": | 24 | "image_display_url": | ||
25 | rhub.ca/uploads/group/2021-03-02-214610.209659Mapfinalheadwayers.png", | 25 | rhub.ca/uploads/group/2021-03-02-214610.209659Mapfinalheadwayers.png", | ||
26 | "name": "columbia-kootenay-headwaters", | 26 | "name": "columbia-kootenay-headwaters", | ||
27 | "title": "Columbia-Kootenay Headwaters" | 27 | "title": "Columbia-Kootenay Headwaters" | ||
28 | } | 28 | } | ||
29 | ], | 29 | ], | ||
30 | "id": "649af27c-27f4-4864-bd7a-ca8236ce462c", | 30 | "id": "649af27c-27f4-4864-bd7a-ca8236ce462c", | ||
31 | "identifier": "https://doi.org/10.48511/V4X5-NS17", | 31 | "identifier": "https://doi.org/10.48511/V4X5-NS17", | ||
32 | "isopen": false, | 32 | "isopen": false, | ||
33 | "keywords": "Lake,Lab Water Quality,Field Water | 33 | "keywords": "Lake,Lab Water Quality,Field Water | ||
34 | Quality,Community-based monitoring,Community Research Grade", | 34 | Quality,Community-based monitoring,Community Research Grade", | ||
35 | "latitude": "50.253929", | 35 | "latitude": "50.253929", | ||
36 | "license_id": "CC-BY-SA-4.0", | 36 | "license_id": "CC-BY-SA-4.0", | ||
37 | "license_title": "CC-BY-SA-4.0", | 37 | "license_title": "CC-BY-SA-4.0", | ||
38 | "location": "Middle of Columbia Lake, near Spirits Reach.", | 38 | "location": "Middle of Columbia Lake, near Spirits Reach.", | ||
39 | "longitude": "-115.86256", | 39 | "longitude": "-115.86256", | ||
40 | "maintainer": null, | 40 | "maintainer": null, | ||
41 | "maintainer_email": "cbwaterhub@livinglakescanada.ca", | 41 | "maintainer_email": "cbwaterhub@livinglakescanada.ca", | ||
42 | "metadata_created": "2022-10-19T18:47:01.374513", | 42 | "metadata_created": "2022-10-19T18:47:01.374513", | ||
n | 43 | "metadata_modified": "2023-12-06T18:36:33.607588", | n | 43 | "metadata_modified": "2023-12-06T18:36:33.893558", |
44 | "name": "columbia-lake-s1", | 44 | "name": "columbia-lake-s1", | ||
45 | "notes": "Water quality data from the middle of the lake, near | 45 | "notes": "Water quality data from the middle of the lake, near | ||
46 | Spirits Reach. Dataset collected to better understand health of | 46 | Spirits Reach. Dataset collected to better understand health of | ||
47 | Columbia lake and to communicate information to decision makers for | 47 | Columbia lake and to communicate information to decision makers for | ||
48 | strategic planning for management strategies, as well as to support | 48 | strategic planning for management strategies, as well as to support | ||
49 | our contributing partners for their future projects and initiatives.", | 49 | our contributing partners for their future projects and initiatives.", | ||
50 | "num_resources": 2, | 50 | "num_resources": 2, | ||
51 | "num_tags": 5, | 51 | "num_tags": 5, | ||
52 | "organization": { | 52 | "organization": { | ||
53 | "approval_status": "approved", | 53 | "approval_status": "approved", | ||
54 | "created": "2021-09-03T14:49:38.225713", | 54 | "created": "2021-09-03T14:49:38.225713", | ||
55 | "description": "The Columbia Lake Stewardship Society is an | 55 | "description": "The Columbia Lake Stewardship Society is an | ||
56 | environmental stewardship organization working to preserve the | 56 | environmental stewardship organization working to preserve the | ||
57 | ecological health and water supply of Columbia Lake for present and | 57 | ecological health and water supply of Columbia Lake for present and | ||
58 | future generations through scientific investigation, collaboration, | 58 | future generations through scientific investigation, collaboration, | ||
59 | and outreach.\r\n", | 59 | and outreach.\r\n", | ||
60 | "id": "e6b9b424-d988-4378-b8c8-ac81f1ef3f91", | 60 | "id": "e6b9b424-d988-4378-b8c8-ac81f1ef3f91", | ||
61 | "image_url": "2021-09-03-214952.111892CLSS-logo.jpg", | 61 | "image_url": "2021-09-03-214952.111892CLSS-logo.jpg", | ||
62 | "is_organization": true, | 62 | "is_organization": true, | ||
63 | "name": "clss", | 63 | "name": "clss", | ||
64 | "state": "active", | 64 | "state": "active", | ||
65 | "title": "Columbia Lake Stewardship Society", | 65 | "title": "Columbia Lake Stewardship Society", | ||
66 | "type": "organization" | 66 | "type": "organization" | ||
67 | }, | 67 | }, | ||
68 | "other_sources": "", | 68 | "other_sources": "", | ||
69 | "owner_org": "e6b9b424-d988-4378-b8c8-ac81f1ef3f91", | 69 | "owner_org": "e6b9b424-d988-4378-b8c8-ac81f1ef3f91", | ||
70 | "private": false, | 70 | "private": false, | ||
71 | "publication_year": "2022", | 71 | "publication_year": "2022", | ||
72 | "relationships_as_object": [], | 72 | "relationships_as_object": [], | ||
73 | "relationships_as_subject": [], | 73 | "relationships_as_subject": [], | ||
74 | "resources": [ | 74 | "resources": [ | ||
75 | { | 75 | { | ||
76 | "cache_last_updated": null, | 76 | "cache_last_updated": null, | ||
77 | "cache_url": null, | 77 | "cache_url": null, | ||
78 | "created": "2022-10-19T18:49:00.582163", | 78 | "created": "2022-10-19T18:49:00.582163", | ||
79 | "data_collection_info": "Four sample bottles are filled with | 79 | "data_collection_info": "Four sample bottles are filled with | ||
80 | lake water. Three of these bottles are unfiltered, and filled using a | 80 | lake water. Three of these bottles are unfiltered, and filled using a | ||
81 | measuring cup. One of the bottles is filtered using a new syringe and | 81 | measuring cup. One of the bottles is filtered using a new syringe and | ||
82 | filter apparatus.", | 82 | filter apparatus.", | ||
83 | "data_processing": "Analyzed data as delivered by CARO | 83 | "data_processing": "Analyzed data as delivered by CARO | ||
84 | Analytical Services.", | 84 | Analytical Services.", | ||
85 | "data_type": "non-lab", | 85 | "data_type": "non-lab", | ||
86 | "datastore_active": false, | 86 | "datastore_active": false, | ||
87 | "datastore_contains_all_records_of_source_file": false, | 87 | "datastore_contains_all_records_of_source_file": false, | ||
88 | "datastore_status": "pending", | 88 | "datastore_status": "pending", | ||
89 | "description": "Lab results for the samples taken at the S1 | 89 | "description": "Lab results for the samples taken at the S1 | ||
90 | sampling site on Columbia Lake since 2014. Dataset collected to better | 90 | sampling site on Columbia Lake since 2014. Dataset collected to better | ||
91 | understand health of Columbia lake and to communicate information to | 91 | understand health of Columbia lake and to communicate information to | ||
92 | decision makers for strategic planning for management strategies, as | 92 | decision makers for strategic planning for management strategies, as | ||
93 | well as to support our contributing partners for their future projects | 93 | well as to support our contributing partners for their future projects | ||
94 | and initiatives.", | 94 | and initiatives.", | ||
95 | "format": "CSV", | 95 | "format": "CSV", | ||
96 | "hash": "73d60d175c3bd393e1b20dfc5ce45323", | 96 | "hash": "73d60d175c3bd393e1b20dfc5ce45323", | ||
97 | "header_row": "1", | 97 | "header_row": "1", | ||
98 | "id": "19a8c2b6-18b3-4f61-bb94-c84392f2b967", | 98 | "id": "19a8c2b6-18b3-4f61-bb94-c84392f2b967", | ||
99 | "last_modified": "2023-12-06T18:36:29.985205", | 99 | "last_modified": "2023-12-06T18:36:29.985205", | ||
t | 100 | "load_status": "ERROR: Unable to find a usable engine; tried | t | 100 | "load_status": "Reading tabular file |
101 | using: 'sqlalchemy'.\r\nA suitable version of sqlalchemy is required | 101 | clss_waterquality_s1_20140420_20210903.csv (csv)", | ||
102 | for sql I/O support.\r\nTrying to import the above resulted in these | ||||
103 | errors:\r\n - Pandas requires version '1.4.16' or newer of | ||||
104 | 'sqlalchemy' (version '1.3.5' currently installed).", | ||||
105 | "metadata_modified": "2023-12-06T18:36:33.612293", | 102 | "metadata_modified": "2023-12-06T18:36:33.896693", | ||
106 | "mimetype": "text/csv", | 103 | "mimetype": "text/csv", | ||
107 | "mimetype_inner": null, | 104 | "mimetype_inner": null, | ||
108 | "name": "Water Quality (2014-04-20 to 2021-09-03) Columbia Lake | 105 | "name": "Water Quality (2014-04-20 to 2021-09-03) Columbia Lake | ||
109 | (S1)", | 106 | (S1)", | ||
110 | "package_id": "649af27c-27f4-4864-bd7a-ca8236ce462c", | 107 | "package_id": "649af27c-27f4-4864-bd7a-ca8236ce462c", | ||
111 | "position": 0, | 108 | "position": 0, | ||
112 | "recent_qa_date": "2022-10-01", | 109 | "recent_qa_date": "2022-10-01", | ||
113 | "resource_citation": "CLSS. (2022). Water Quality (2014-04-20 to | 110 | "resource_citation": "CLSS. (2022). Water Quality (2014-04-20 to | ||
114 | 2021-09-03) Columbia Lake (S1) [Resource]. Columbia Basin Water Hub. | 111 | 2021-09-03) Columbia Lake (S1) [Resource]. Columbia Basin Water Hub. | ||
115 | https://doi.org/10.48511/V4X5-NS17", | 112 | https://doi.org/10.48511/V4X5-NS17", | ||
116 | "resource_data_disclaimer": "No warranty or guarantee exists | 113 | "resource_data_disclaimer": "No warranty or guarantee exists | ||
117 | that the information is accurate, complete, current, or suitable for | 114 | that the information is accurate, complete, current, or suitable for | ||
118 | any purpose. The individual user must confirm the accuracy of the data | 115 | any purpose. The individual user must confirm the accuracy of the data | ||
119 | and whether it will be appropriate for their purpose themselves.", | 116 | and whether it will be appropriate for their purpose themselves.", | ||
120 | "resource_location": "Middle of Columbia Lake, near Spirits | 117 | "resource_location": "Middle of Columbia Lake, near Spirits | ||
121 | Reach.", | 118 | Reach.", | ||
122 | "resource_type": null, | 119 | "resource_type": null, | ||
123 | "size": 24894, | 120 | "size": 24894, | ||
124 | "state": "active", | 121 | "state": "active", | ||
125 | "url": | 122 | "url": | ||
126 | b94-c84392f2b967/download/clss_waterquality_s1_20140420_20210903.csv", | 123 | b94-c84392f2b967/download/clss_waterquality_s1_20140420_20210903.csv", | ||
127 | "url_type": "upload", | 124 | "url_type": "upload", | ||
128 | "waterhub_grade": "Community Research Grade" | 125 | "waterhub_grade": "Community Research Grade" | ||
129 | }, | 126 | }, | ||
130 | { | 127 | { | ||
131 | "cache_last_updated": null, | 128 | "cache_last_updated": null, | ||
132 | "cache_url": null, | 129 | "cache_url": null, | ||
133 | "created": "2022-10-19T18:52:21.583976", | 130 | "created": "2022-10-19T18:52:21.583976", | ||
134 | "data_collection_info": "Data collected by summer student and | 131 | "data_collection_info": "Data collected by summer student and | ||
135 | program coordinator with the help of volunteers. Data collected using | 132 | program coordinator with the help of volunteers. Data collected using | ||
136 | turbidimeter, pH probe, dissolved oxygen probe, specific conductivity | 133 | turbidimeter, pH probe, dissolved oxygen probe, specific conductivity | ||
137 | probe, thermometer, secchi disk.", | 134 | probe, thermometer, secchi disk.", | ||
138 | "data_processing": "The Water Hub has performed a preliminary | 135 | "data_processing": "The Water Hub has performed a preliminary | ||
139 | QA/QC protocol on this data but the individual user must still confirm | 136 | QA/QC protocol on this data but the individual user must still confirm | ||
140 | the accuracy of the data and whether it will be appropriate for their | 137 | the accuracy of the data and whether it will be appropriate for their | ||
141 | purpose.", | 138 | purpose.", | ||
142 | "data_type": "non-lab", | 139 | "data_type": "non-lab", | ||
143 | "datastore_active": false, | 140 | "datastore_active": false, | ||
144 | "datastore_contains_all_records_of_source_file": false, | 141 | "datastore_contains_all_records_of_source_file": false, | ||
145 | "datastore_status": "", | 142 | "datastore_status": "", | ||
146 | "description": "Water quality data from the middle of Columbia | 143 | "description": "Water quality data from the middle of Columbia | ||
147 | Lake near Spirits Reach.", | 144 | Lake near Spirits Reach.", | ||
148 | "format": "XLSX", | 145 | "format": "XLSX", | ||
149 | "hash": "92367db73e7e0be2cb0606ff2cd6463b", | 146 | "hash": "92367db73e7e0be2cb0606ff2cd6463b", | ||
150 | "header_row": "1", | 147 | "header_row": "1", | ||
151 | "id": "14c8becf-7e66-4909-af56-518fe04180f9", | 148 | "id": "14c8becf-7e66-4909-af56-518fe04180f9", | ||
152 | "last_modified": "2022-10-19T18:52:21.560240", | 149 | "last_modified": "2022-10-19T18:52:21.560240", | ||
153 | "load_status": "ERROR: Unable to find a usable engine; tried | 150 | "load_status": "ERROR: Unable to find a usable engine; tried | ||
154 | using: 'sqlalchemy'.\r\nA suitable version of sqlalchemy is required | 151 | using: 'sqlalchemy'.\r\nA suitable version of sqlalchemy is required | ||
155 | for sql I/O support.\r\nTrying to import the above resulted in these | 152 | for sql I/O support.\r\nTrying to import the above resulted in these | ||
156 | errors:\r\n - Pandas requires version '1.4.16' or newer of | 153 | errors:\r\n - Pandas requires version '1.4.16' or newer of | ||
157 | 'sqlalchemy' (version '1.3.5' currently installed).", | 154 | 'sqlalchemy' (version '1.3.5' currently installed).", | ||
158 | "metadata_modified": "2023-12-06T18:36:29.997756", | 155 | "metadata_modified": "2023-12-06T18:36:29.997756", | ||
159 | "mimetype": | 156 | "mimetype": | ||
160 | "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", | 157 | "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", | ||
161 | "mimetype_inner": null, | 158 | "mimetype_inner": null, | ||
162 | "name": "Field Water Quality (2014-04-20 to 2022-05-27) Columbia | 159 | "name": "Field Water Quality (2014-04-20 to 2022-05-27) Columbia | ||
163 | Lake (S1)", | 160 | Lake (S1)", | ||
164 | "package_id": "649af27c-27f4-4864-bd7a-ca8236ce462c", | 161 | "package_id": "649af27c-27f4-4864-bd7a-ca8236ce462c", | ||
165 | "position": 1, | 162 | "position": 1, | ||
166 | "recent_qa_date": "2022-10-01", | 163 | "recent_qa_date": "2022-10-01", | ||
167 | "resource_citation": "CLSS. (2022). Field Water Quality | 164 | "resource_citation": "CLSS. (2022). Field Water Quality | ||
168 | (2014-04-20 to 2022-05-27) Columbia Lake (S1) [Resource]. Columbia | 165 | (2014-04-20 to 2022-05-27) Columbia Lake (S1) [Resource]. Columbia | ||
169 | Basin Water Hub. https://doi.org/10.48511/V4X5-NS17", | 166 | Basin Water Hub. https://doi.org/10.48511/V4X5-NS17", | ||
170 | "resource_data_disclaimer": "No warranty or guarantee exists | 167 | "resource_data_disclaimer": "No warranty or guarantee exists | ||
171 | that the information is accurate, complete, current, or suitable for | 168 | that the information is accurate, complete, current, or suitable for | ||
172 | any purpose. The individual user must confirm the accuracy of the data | 169 | any purpose. The individual user must confirm the accuracy of the data | ||
173 | and whether it will be appropriate for their purpose themselves.", | 170 | and whether it will be appropriate for their purpose themselves.", | ||
174 | "resource_location": "Middle of Columbia Lake near Spirits | 171 | "resource_location": "Middle of Columbia Lake near Spirits | ||
175 | Reach", | 172 | Reach", | ||
176 | "resource_type": null, | 173 | "resource_type": null, | ||
177 | "size": 89338, | 174 | "size": 89338, | ||
178 | "state": "active", | 175 | "state": "active", | ||
179 | "url": | 176 | "url": | ||
180 | 8fe04180f9/download/clss_fieldwaterquality_s1_20140420_20220527.xlsx", | 177 | 8fe04180f9/download/clss_fieldwaterquality_s1_20140420_20220527.xlsx", | ||
181 | "url_type": "upload", | 178 | "url_type": "upload", | ||
182 | "waterhub_grade": "Community Research Grade" | 179 | "waterhub_grade": "Community Research Grade" | ||
183 | } | 180 | } | ||
184 | ], | 181 | ], | ||
185 | "start_date": "2014-04-20", | 182 | "start_date": "2014-04-20", | ||
186 | "state": "active", | 183 | "state": "active", | ||
187 | "tags": [ | 184 | "tags": [ | ||
188 | { | 185 | { | ||
189 | "display_name": "Community Research Grade", | 186 | "display_name": "Community Research Grade", | ||
190 | "id": "1f0dafbc-c76f-4b7c-9200-880b759fe7f4", | 187 | "id": "1f0dafbc-c76f-4b7c-9200-880b759fe7f4", | ||
191 | "name": "Community Research Grade", | 188 | "name": "Community Research Grade", | ||
192 | "state": "active", | 189 | "state": "active", | ||
193 | "vocabulary_id": null | 190 | "vocabulary_id": null | ||
194 | }, | 191 | }, | ||
195 | { | 192 | { | ||
196 | "display_name": "Community-based monitoring", | 193 | "display_name": "Community-based monitoring", | ||
197 | "id": "9b75240a-5e54-43c9-9063-969983d065f6", | 194 | "id": "9b75240a-5e54-43c9-9063-969983d065f6", | ||
198 | "name": "Community-based monitoring", | 195 | "name": "Community-based monitoring", | ||
199 | "state": "active", | 196 | "state": "active", | ||
200 | "vocabulary_id": null | 197 | "vocabulary_id": null | ||
201 | }, | 198 | }, | ||
202 | { | 199 | { | ||
203 | "display_name": "Field Water Quality", | 200 | "display_name": "Field Water Quality", | ||
204 | "id": "f7ccfe9a-95ee-462f-8503-44ae52c0802e", | 201 | "id": "f7ccfe9a-95ee-462f-8503-44ae52c0802e", | ||
205 | "name": "Field Water Quality", | 202 | "name": "Field Water Quality", | ||
206 | "state": "active", | 203 | "state": "active", | ||
207 | "vocabulary_id": null | 204 | "vocabulary_id": null | ||
208 | }, | 205 | }, | ||
209 | { | 206 | { | ||
210 | "display_name": "Lab Water Quality", | 207 | "display_name": "Lab Water Quality", | ||
211 | "id": "5a36f422-9cf9-481b-810d-9f697259b26c", | 208 | "id": "5a36f422-9cf9-481b-810d-9f697259b26c", | ||
212 | "name": "Lab Water Quality", | 209 | "name": "Lab Water Quality", | ||
213 | "state": "active", | 210 | "state": "active", | ||
214 | "vocabulary_id": null | 211 | "vocabulary_id": null | ||
215 | }, | 212 | }, | ||
216 | { | 213 | { | ||
217 | "display_name": "Lake", | 214 | "display_name": "Lake", | ||
218 | "id": "66dc1292-41ac-45cf-a267-f0d5c8a31826", | 215 | "id": "66dc1292-41ac-45cf-a267-f0d5c8a31826", | ||
219 | "name": "Lake", | 216 | "name": "Lake", | ||
220 | "state": "active", | 217 | "state": "active", | ||
221 | "vocabulary_id": null | 218 | "vocabulary_id": null | ||
222 | } | 219 | } | ||
223 | ], | 220 | ], | ||
224 | "title": "Columbia Lake (S1)", | 221 | "title": "Columbia Lake (S1)", | ||
225 | "type": "dataset", | 222 | "type": "dataset", | ||
226 | "url": null, | 223 | "url": null, | ||
227 | "version": null | 224 | "version": null | ||
228 | } | 225 | } |