Changes
On November 25, 2022 at 9:20:41 PM UTC, lladmin:
-
Changed value of field
load_status
of resource Water Quality (2017-07-07 to 2022-09-15) Kinbasket Reservoir at Bush Harbour 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).
(previouslyLoading 31 rows to datastore
) in Kinbasket Reservoir at Bush Harbour -
Removed the value of field
datastore_status
in resource Water Quality (2017-07-07 to 2022-09-15) Kinbasket Reservoir at Bush Harbour in Kinbasket Reservoir at Bush Harbour
f | 1 | { | f | 1 | { |
2 | "author": null, | 2 | "author": null, | ||
3 | "author_email": null, | 3 | "author_email": null, | ||
4 | "citation": "Columbia Shuswap Invasive Species Society. (2021). | 4 | "citation": "Columbia Shuswap Invasive Species Society. (2021). | ||
5 | Kinbasket Reservoir at Bush Harbour [Data set]. Columbia Basin Water | 5 | Kinbasket Reservoir at Bush Harbour [Data set]. Columbia Basin Water | ||
6 | Hub. https://doi.org/10.48511/0GRT-RF74", | 6 | Hub. https://doi.org/10.48511/0GRT-RF74", | ||
7 | "creator": "Columbia Shuswap Invasive Species Society", | 7 | "creator": "Columbia Shuswap Invasive Species 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": "Lake", | 13 | "data_type": "Lake", | ||
14 | "end_date": "2022-09-15", | 14 | "end_date": "2022-09-15", | ||
15 | "funding_reference": "The Ministry of Environment supports this work | 15 | "funding_reference": "The Ministry of Environment supports this work | ||
16 | through the Habitat Conservation Trust Foundation.", | 16 | through the Habitat Conservation Trust Foundation.", | ||
17 | "groups": [ | 17 | "groups": [ | ||
18 | { | 18 | { | ||
19 | "description": "This group includes all the datasets which fall | 19 | "description": "This group includes all the datasets which fall | ||
20 | within the Upper Columbia Hydrologic region", | 20 | within the Upper Columbia Hydrologic region", | ||
21 | "display_name": "Upper Columbia", | 21 | "display_name": "Upper Columbia", | ||
22 | "id": "649ea430-fefc-42ea-a3b2-f6e40d88cc5f", | 22 | "id": "649ea430-fefc-42ea-a3b2-f6e40d88cc5f", | ||
23 | "image_display_url": | 23 | "image_display_url": | ||
24 | b.ca/uploads/group/2021-03-03-021114.668619Mapfinaluppercolumbia.png", | 24 | b.ca/uploads/group/2021-03-03-021114.668619Mapfinaluppercolumbia.png", | ||
25 | "name": "upper-columbia", | 25 | "name": "upper-columbia", | ||
26 | "title": "Upper Columbia" | 26 | "title": "Upper Columbia" | ||
27 | } | 27 | } | ||
28 | ], | 28 | ], | ||
29 | "id": "027ef280-a68f-43b1-97bd-62f90e3e3a74", | 29 | "id": "027ef280-a68f-43b1-97bd-62f90e3e3a74", | ||
30 | "identifier": "10.48511/0GRT-RF74", | 30 | "identifier": "10.48511/0GRT-RF74", | ||
31 | "isopen": false, | 31 | "isopen": false, | ||
32 | "keywords": "Lake,Water temperature,Community Research Grade,Field | 32 | "keywords": "Lake,Water temperature,Community Research Grade,Field | ||
33 | Water Quality", | 33 | Water Quality", | ||
34 | "latitude": "51.756443", | 34 | "latitude": "51.756443", | ||
35 | "license_id": "CC-BY-SA-4.0", | 35 | "license_id": "CC-BY-SA-4.0", | ||
36 | "license_title": "CC-BY-SA-4.0", | 36 | "license_title": "CC-BY-SA-4.0", | ||
37 | "location": "Kinbasket Reservoir at Bush Harbour", | 37 | "location": "Kinbasket Reservoir at Bush Harbour", | ||
38 | "longitude": "-117.574689", | 38 | "longitude": "-117.574689", | ||
39 | "maintainer": null, | 39 | "maintainer": null, | ||
40 | "maintainer_email": "cbwaterhub@livinglakescanada.ca", | 40 | "maintainer_email": "cbwaterhub@livinglakescanada.ca", | ||
41 | "metadata_created": "2021-09-13T21:38:55.613515", | 41 | "metadata_created": "2021-09-13T21:38:55.613515", | ||
n | 42 | "metadata_modified": "2022-11-25T21:20:41.341428", | n | 42 | "metadata_modified": "2022-11-25T21:20:41.577739", |
43 | "name": "kinbasket-reservoir-at-bush-harbour", | 43 | "name": "kinbasket-reservoir-at-bush-harbour", | ||
44 | "notes": "The Columbia Shuswap Invasive Species Society (CSISS) | 44 | "notes": "The Columbia Shuswap Invasive Species Society (CSISS) | ||
45 | collects plankton samples for several waterbodies in the Northern | 45 | collects plankton samples for several waterbodies in the Northern | ||
46 | Columbia Basin which are tested for the presence of larval stages of | 46 | Columbia Basin which are tested for the presence of larval stages of | ||
47 | invasive mussels and clams. Along with the plankton samples, ancillary | 47 | invasive mussels and clams. Along with the plankton samples, ancillary | ||
48 | data including surface pH, surface temperature and Secchi depth are | 48 | data including surface pH, surface temperature and Secchi depth are | ||
49 | measured. Data is collected from July to September, either every 2 | 49 | measured. Data is collected from July to September, either every 2 | ||
50 | weeks or every month (depending on the waterbody\u2019s risk of | 50 | weeks or every month (depending on the waterbody\u2019s risk of | ||
51 | infestation).", | 51 | infestation).", | ||
52 | "num_resources": 1, | 52 | "num_resources": 1, | ||
53 | "num_tags": 4, | 53 | "num_tags": 4, | ||
54 | "organization": { | 54 | "organization": { | ||
55 | "approval_status": "approved", | 55 | "approval_status": "approved", | ||
56 | "created": "2021-08-31T13:32:00.093305", | 56 | "created": "2021-08-31T13:32:00.093305", | ||
57 | "description": "The Columbia Shuswap Invasive Species Society is a | 57 | "description": "The Columbia Shuswap Invasive Species Society is a | ||
58 | network of partners who facilitate the prevention, reduction, and | 58 | network of partners who facilitate the prevention, reduction, and | ||
59 | management of invasive species through collaboration, engagement, and | 59 | management of invasive species through collaboration, engagement, and | ||
60 | education.", | 60 | education.", | ||
61 | "id": "63da0067-390a-4cad-9dd7-3c7e4b1ded42", | 61 | "id": "63da0067-390a-4cad-9dd7-3c7e4b1ded42", | ||
62 | "image_url": "2021-08-31-203215.393825CSISS.jpg", | 62 | "image_url": "2021-08-31-203215.393825CSISS.jpg", | ||
63 | "is_organization": true, | 63 | "is_organization": true, | ||
64 | "name": "csiss", | 64 | "name": "csiss", | ||
65 | "state": "active", | 65 | "state": "active", | ||
66 | "title": "Columbia Shuswap Invasive Species Society", | 66 | "title": "Columbia Shuswap Invasive Species Society", | ||
67 | "type": "organization" | 67 | "type": "organization" | ||
68 | }, | 68 | }, | ||
69 | "other_sources": "N/A", | 69 | "other_sources": "N/A", | ||
70 | "owner_org": "63da0067-390a-4cad-9dd7-3c7e4b1ded42", | 70 | "owner_org": "63da0067-390a-4cad-9dd7-3c7e4b1ded42", | ||
71 | "private": false, | 71 | "private": false, | ||
72 | "publication_year": "2021", | 72 | "publication_year": "2021", | ||
73 | "relationships_as_object": [], | 73 | "relationships_as_object": [], | ||
74 | "relationships_as_subject": [], | 74 | "relationships_as_subject": [], | ||
75 | "resources": [ | 75 | "resources": [ | ||
76 | { | 76 | { | ||
77 | "cache_last_updated": null, | 77 | "cache_last_updated": null, | ||
78 | "cache_url": null, | 78 | "cache_url": null, | ||
79 | "created": "2021-09-13T21:39:48.578447", | 79 | "created": "2021-09-13T21:39:48.578447", | ||
80 | "data_collection_info": "Temperature and pH are measured using a | 80 | "data_collection_info": "Temperature and pH are measured using a | ||
81 | Hanna Industries pen meter (HI98129) within 2-4\u201d of the surface. | 81 | Hanna Industries pen meter (HI98129) within 2-4\u201d of the surface. | ||
82 | Secchi depths are collected where there is sufficient depth to measure | 82 | Secchi depths are collected where there is sufficient depth to measure | ||
83 | from the sampling location. Data collection is consistent with the | 83 | from the sampling location. Data collection is consistent with the | ||
84 | Invasive Mussel Field Protocol prepared by the Ecosystems Branch, BC | 84 | Invasive Mussel Field Protocol prepared by the Ecosystems Branch, BC | ||
85 | Ministry of Environment and Climate Change Strategy.", | 85 | Ministry of Environment and Climate Change Strategy.", | ||
86 | "data_processing": "The Water Hub has performed a preliminary | 86 | "data_processing": "The Water Hub has performed a preliminary | ||
87 | QA/QC protocol on this data but the individual user must still confirm | 87 | QA/QC protocol on this data but the individual user must still confirm | ||
88 | the accuracy of the data and whether it will be appropriate for their | 88 | the accuracy of the data and whether it will be appropriate for their | ||
89 | purpose.\r\n", | 89 | purpose.\r\n", | ||
90 | "datastore_active": false, | 90 | "datastore_active": false, | ||
91 | "datastore_contains_all_records_of_source_file": false, | 91 | "datastore_contains_all_records_of_source_file": false, | ||
n | 92 | "datastore_status": "pending", | n | 92 | "datastore_status": "", |
93 | "description": "Water temperature, pH and Secchi depth are | 93 | "description": "Water temperature, pH and Secchi depth are | ||
94 | measured as ancillary data for the CSISS aquatic invasive species | 94 | measured as ancillary data for the CSISS aquatic invasive species | ||
95 | monitoring program. ", | 95 | monitoring program. ", | ||
96 | "format": "XLSX", | 96 | "format": "XLSX", | ||
97 | "hash": "6a690995a53677dd5a6e05ad558ba95e", | 97 | "hash": "6a690995a53677dd5a6e05ad558ba95e", | ||
98 | "header_row": "1", | 98 | "header_row": "1", | ||
99 | "id": "98d0256e-c8a4-4b1b-ace7-e017cac2686e", | 99 | "id": "98d0256e-c8a4-4b1b-ace7-e017cac2686e", | ||
100 | "last_modified": "2022-11-25T21:20:37.104554", | 100 | "last_modified": "2022-11-25T21:20:37.104554", | ||
t | 101 | "load_status": "Loading 31 rows to datastore", | t | 101 | "load_status": "ERROR: Unable to find a usable engine; tried |
102 | using: 'sqlalchemy'.\nA suitable version of sqlalchemy is required for | ||||
103 | sql I/O support.\nTrying to import the above resulted in these | ||||
104 | errors:\n - Pandas requires version '1.4.16' or newer of 'sqlalchemy' | ||||
105 | (version '1.3.5' currently installed).", | ||||
102 | "metadata_modified": "2022-11-25T21:20:41.344560", | 106 | "metadata_modified": "2022-11-25T21:20:41.580682", | ||
103 | "mimetype": | 107 | "mimetype": | ||
104 | "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", | 108 | "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", | ||
105 | "mimetype_inner": null, | 109 | "mimetype_inner": null, | ||
106 | "name": "Water Quality (2017-07-07 to 2022-09-15) Kinbasket | 110 | "name": "Water Quality (2017-07-07 to 2022-09-15) Kinbasket | ||
107 | Reservoir at Bush Harbour", | 111 | Reservoir at Bush Harbour", | ||
108 | "package_id": "027ef280-a68f-43b1-97bd-62f90e3e3a74", | 112 | "package_id": "027ef280-a68f-43b1-97bd-62f90e3e3a74", | ||
109 | "position": 0, | 113 | "position": 0, | ||
110 | "recent_qa_date": "2022-11-25", | 114 | "recent_qa_date": "2022-11-25", | ||
111 | "resource_citation": "Columbia Shuswap Invasive Species Society. | 115 | "resource_citation": "Columbia Shuswap Invasive Species Society. | ||
112 | (2021). Water Quality (2017-07-07 to 2022-09-15) Kinbasket Reservoir | 116 | (2021). Water Quality (2017-07-07 to 2022-09-15) Kinbasket Reservoir | ||
113 | at Bush Harbour [Resource]. Columbia Basin Water Hub | 117 | at Bush Harbour [Resource]. Columbia Basin Water Hub | ||
114 | https://doi.org/10.48511/0GRT-RF74", | 118 | https://doi.org/10.48511/0GRT-RF74", | ||
115 | "resource_data_disclaimer": "No warranty or guarantee exists | 119 | "resource_data_disclaimer": "No warranty or guarantee exists | ||
116 | that the information is accurate, complete, current, or suitable for | 120 | that the information is accurate, complete, current, or suitable for | ||
117 | any purpose. Instrument accuracy may be limited. The individual user | 121 | any purpose. Instrument accuracy may be limited. The individual user | ||
118 | must confirm the accuracy of the data and whether it will be | 122 | must confirm the accuracy of the data and whether it will be | ||
119 | appropriate for their purpose.", | 123 | appropriate for their purpose.", | ||
120 | "resource_location": "Kinbasket Reservoir at Bush Harbour, Deep | 124 | "resource_location": "Kinbasket Reservoir at Bush Harbour, Deep | ||
121 | dock, harbour is partly enclosed and open to main lake on one side. | 125 | dock, harbour is partly enclosed and open to main lake on one side. | ||
122 | ", | 126 | ", | ||
123 | "resource_type": null, | 127 | "resource_type": null, | ||
124 | "size": 191927, | 128 | "size": 191927, | ||
125 | "state": "active", | 129 | "state": "active", | ||
126 | "url": | 130 | "url": | ||
127 | ss_waterquality_kinbasketreservoirbushharbour_20170707_20220915.xlsx", | 131 | ss_waterquality_kinbasketreservoirbushharbour_20170707_20220915.xlsx", | ||
128 | "url_type": "upload", | 132 | "url_type": "upload", | ||
129 | "waterhub_grade": "Community Research Grade" | 133 | "waterhub_grade": "Community Research Grade" | ||
130 | } | 134 | } | ||
131 | ], | 135 | ], | ||
132 | "start_date": "2017-07-07", | 136 | "start_date": "2017-07-07", | ||
133 | "state": "active", | 137 | "state": "active", | ||
134 | "tags": [ | 138 | "tags": [ | ||
135 | { | 139 | { | ||
136 | "display_name": "Community Research Grade", | 140 | "display_name": "Community Research Grade", | ||
137 | "id": "1f0dafbc-c76f-4b7c-9200-880b759fe7f4", | 141 | "id": "1f0dafbc-c76f-4b7c-9200-880b759fe7f4", | ||
138 | "name": "Community Research Grade", | 142 | "name": "Community Research Grade", | ||
139 | "state": "active", | 143 | "state": "active", | ||
140 | "vocabulary_id": null | 144 | "vocabulary_id": null | ||
141 | }, | 145 | }, | ||
142 | { | 146 | { | ||
143 | "display_name": "Field Water Quality", | 147 | "display_name": "Field Water Quality", | ||
144 | "id": "f7ccfe9a-95ee-462f-8503-44ae52c0802e", | 148 | "id": "f7ccfe9a-95ee-462f-8503-44ae52c0802e", | ||
145 | "name": "Field Water Quality", | 149 | "name": "Field Water Quality", | ||
146 | "state": "active", | 150 | "state": "active", | ||
147 | "vocabulary_id": null | 151 | "vocabulary_id": null | ||
148 | }, | 152 | }, | ||
149 | { | 153 | { | ||
150 | "display_name": "Lake", | 154 | "display_name": "Lake", | ||
151 | "id": "66dc1292-41ac-45cf-a267-f0d5c8a31826", | 155 | "id": "66dc1292-41ac-45cf-a267-f0d5c8a31826", | ||
152 | "name": "Lake", | 156 | "name": "Lake", | ||
153 | "state": "active", | 157 | "state": "active", | ||
154 | "vocabulary_id": null | 158 | "vocabulary_id": null | ||
155 | }, | 159 | }, | ||
156 | { | 160 | { | ||
157 | "display_name": "Water temperature", | 161 | "display_name": "Water temperature", | ||
158 | "id": "0770347d-73eb-4f60-a661-50199f7049c3", | 162 | "id": "0770347d-73eb-4f60-a661-50199f7049c3", | ||
159 | "name": "Water temperature", | 163 | "name": "Water temperature", | ||
160 | "state": "active", | 164 | "state": "active", | ||
161 | "vocabulary_id": null | 165 | "vocabulary_id": null | ||
162 | } | 166 | } | ||
163 | ], | 167 | ], | ||
164 | "title": "Kinbasket Reservoir at Bush Harbour", | 168 | "title": "Kinbasket Reservoir at Bush Harbour", | ||
165 | "type": "dataset", | 169 | "type": "dataset", | ||
166 | "url": null, | 170 | "url": null, | ||
167 | "version": null | 171 | "version": null | ||
168 | } | 172 | } |