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