Changes
On November 25, 2022 at 7:26:47 PM UTC, lladmin:
-
Changed value of field
load_status
of resource Temperature (2019-04-03 to 2022-04-06) Centennial Wetland 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 2358 rows to datastore
) in Centennial Wetland Temperature -
Removed the value of field
datastore_status
in resource Temperature (2019-04-03 to 2022-04-06) Centennial Wetland in Centennial Wetland Temperature
f | 1 | { | f | 1 | { |
2 | "author": null, | 2 | "author": null, | ||
3 | "author_email": null, | 3 | "author_email": null, | ||
4 | "citation": "Rossland Streamkeepers. (2021). Centennial Wetland | 4 | "citation": "Rossland Streamkeepers. (2021). Centennial Wetland | ||
5 | Temperature [Data set]. Columbia Basin Water Hub. | 5 | Temperature [Data set]. Columbia Basin Water Hub. | ||
6 | https://doi.org/10.48511/PGPX-1W35", | 6 | https://doi.org/10.48511/PGPX-1W35", | ||
7 | "creator": "Rossland Streamkeepers", | 7 | "creator": "Rossland Streamkeepers", | ||
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": "2022-04-06", | 14 | "end_date": "2022-04-06", | ||
15 | "funding_reference": "N/A", | 15 | "funding_reference": "N/A", | ||
16 | "groups": [ | 16 | "groups": [ | ||
17 | { | 17 | { | ||
18 | "description": "This group includes all the datasets which fall | 18 | "description": "This group includes all the datasets which fall | ||
19 | within the Lower Columbia-Kootenay Hydrologic region", | 19 | within the Lower Columbia-Kootenay Hydrologic region", | ||
20 | "display_name": "Lower Columbia Kootenay", | 20 | "display_name": "Lower Columbia Kootenay", | ||
21 | "id": "7b51570f-3a68-4db0-b6f7-6089037c7cbd", | 21 | "id": "7b51570f-3a68-4db0-b6f7-6089037c7cbd", | ||
22 | "image_display_url": | 22 | "image_display_url": | ||
23 | erhub.ca/uploads/group/2021-03-02-225850.777385Mapfinallowerkoot.png", | 23 | erhub.ca/uploads/group/2021-03-02-225850.777385Mapfinallowerkoot.png", | ||
24 | "name": "lower-columbia-kootenay", | 24 | "name": "lower-columbia-kootenay", | ||
25 | "title": "Lower Columbia Kootenay" | 25 | "title": "Lower Columbia Kootenay" | ||
26 | } | 26 | } | ||
27 | ], | 27 | ], | ||
28 | "id": "f4531a92-6ed4-4b4f-b190-ad57c6afcf87", | 28 | "id": "f4531a92-6ed4-4b4f-b190-ad57c6afcf87", | ||
29 | "identifier": "10.48511/PGPX-1W35", | 29 | "identifier": "10.48511/PGPX-1W35", | ||
30 | "isopen": false, | 30 | "isopen": false, | ||
31 | "keywords": "Community Research Grade,Water | 31 | "keywords": "Community Research Grade,Water | ||
32 | temperature,Community-based monitoring,Stream", | 32 | temperature,Community-based monitoring,Stream", | ||
33 | "latitude": "49.075833", | 33 | "latitude": "49.075833", | ||
34 | "license_id": "CC-BY-NC-SA-4.0", | 34 | "license_id": "CC-BY-NC-SA-4.0", | ||
35 | "license_title": "CC-BY-NC-SA-4.0", | 35 | "license_title": "CC-BY-NC-SA-4.0", | ||
36 | "location": "Stream in Centennial Wetland, Rossland", | 36 | "location": "Stream in Centennial Wetland, Rossland", | ||
37 | "longitude": "-117.815833", | 37 | "longitude": "-117.815833", | ||
38 | "maintainer": null, | 38 | "maintainer": null, | ||
39 | "maintainer_email": "cbwaterhub@livinglakescanada.ca", | 39 | "maintainer_email": "cbwaterhub@livinglakescanada.ca", | ||
40 | "metadata_created": "2021-03-23T14:30:53.039490", | 40 | "metadata_created": "2021-03-23T14:30:53.039490", | ||
n | 41 | "metadata_modified": "2022-11-25T19:26:47.058987", | n | 41 | "metadata_modified": "2022-11-25T19:26:47.300601", |
42 | "name": "centennial-wetland-temperature", | 42 | "name": "centennial-wetland-temperature", | ||
43 | "notes": "Water quality and temperature measurements for a stream in | 43 | "notes": "Water quality and temperature measurements for a stream in | ||
44 | Centennial Wetland. This is part of a program that monitors the | 44 | Centennial Wetland. This is part of a program that monitors the | ||
45 | temperature of nine creeks in the Trail Creek Watershed, and one | 45 | temperature of nine creeks in the Trail Creek Watershed, and one | ||
46 | location in the Topping Creek Watershed. ", | 46 | location in the Topping Creek Watershed. ", | ||
47 | "num_resources": 1, | 47 | "num_resources": 1, | ||
48 | "num_tags": 4, | 48 | "num_tags": 4, | ||
49 | "organization": { | 49 | "organization": { | ||
50 | "approval_status": "approved", | 50 | "approval_status": "approved", | ||
51 | "created": "2020-07-27T08:24:30.188760", | 51 | "created": "2020-07-27T08:24:30.188760", | ||
52 | "description": "A citizen organization passionate about aquatic | 52 | "description": "A citizen organization passionate about aquatic | ||
53 | monitoring, protection and enhancement of our local mountain fed | 53 | monitoring, protection and enhancement of our local mountain fed | ||
54 | creeks, wetlands and groundwater. We provide education in local | 54 | creeks, wetlands and groundwater. We provide education in local | ||
55 | watersheds to schools and produce public outreach materials and | 55 | watersheds to schools and produce public outreach materials and | ||
56 | events. See website rosslandstreamkeepers.ca for more information.", | 56 | events. See website rosslandstreamkeepers.ca for more information.", | ||
57 | "id": "5d537bb0-2ede-430a-a9f8-82b01d28e83c", | 57 | "id": "5d537bb0-2ede-430a-a9f8-82b01d28e83c", | ||
58 | "image_url": "2020-12-04-181320.951101IMG2707.jpg", | 58 | "image_url": "2020-12-04-181320.951101IMG2707.jpg", | ||
59 | "is_organization": true, | 59 | "is_organization": true, | ||
60 | "name": "rossland-streamkeepers", | 60 | "name": "rossland-streamkeepers", | ||
61 | "state": "active", | 61 | "state": "active", | ||
62 | "title": "Rossland Streamkeepers", | 62 | "title": "Rossland Streamkeepers", | ||
63 | "type": "organization" | 63 | "type": "organization" | ||
64 | }, | 64 | }, | ||
65 | "other_sources": "N/A", | 65 | "other_sources": "N/A", | ||
66 | "owner_org": "5d537bb0-2ede-430a-a9f8-82b01d28e83c", | 66 | "owner_org": "5d537bb0-2ede-430a-a9f8-82b01d28e83c", | ||
67 | "private": false, | 67 | "private": false, | ||
68 | "publication_year": "2021", | 68 | "publication_year": "2021", | ||
69 | "relationships_as_object": [], | 69 | "relationships_as_object": [], | ||
70 | "relationships_as_subject": [], | 70 | "relationships_as_subject": [], | ||
71 | "resources": [ | 71 | "resources": [ | ||
72 | { | 72 | { | ||
73 | "cache_last_updated": null, | 73 | "cache_last_updated": null, | ||
74 | "cache_url": null, | 74 | "cache_url": null, | ||
75 | "created": "2021-03-23T14:34:35.631069", | 75 | "created": "2021-03-23T14:34:35.631069", | ||
76 | "data_collection_info": "Tidbit fastened to 10 lb plastic coated | 76 | "data_collection_info": "Tidbit fastened to 10 lb plastic coated | ||
77 | round dumbbell with cinch ties and tethered by cord to nearest tree. | 77 | round dumbbell with cinch ties and tethered by cord to nearest tree. | ||
78 | Device deployed in deepest area of creek.", | 78 | Device deployed in deepest area of creek.", | ||
79 | "data_processing": "The Water Hub has performed a preliminary | 79 | "data_processing": "The Water Hub has performed a preliminary | ||
80 | QA/QC protocol on this data but the individual user must still confirm | 80 | QA/QC protocol on this data but the individual user must still confirm | ||
81 | the accuracy of the data and whether it will be appropriate for their | 81 | the accuracy of the data and whether it will be appropriate for their | ||
82 | purpose.\r\n", | 82 | purpose.\r\n", | ||
83 | "datastore_active": false, | 83 | "datastore_active": false, | ||
84 | "datastore_contains_all_records_of_source_file": false, | 84 | "datastore_contains_all_records_of_source_file": false, | ||
n | 85 | "datastore_status": "pending", | n | 85 | "datastore_status": "", |
86 | "description": "This resource is part of the Trail Creek | 86 | "description": "This resource is part of the Trail Creek | ||
87 | Watershed monitoring program and contains temperature measurements for | 87 | Watershed monitoring program and contains temperature measurements for | ||
88 | a stream in Centennial Wetland, a tributary of Trail Creek. This is | 88 | a stream in Centennial Wetland, a tributary of Trail Creek. This is | ||
89 | part of a program that monitors the temperature of nine creeks in the | 89 | part of a program that monitors the temperature of nine creeks in the | ||
90 | Trail Creek Watershed, and one location in the Topping Creek | 90 | Trail Creek Watershed, and one location in the Topping Creek | ||
91 | Watershed. ", | 91 | Watershed. ", | ||
92 | "format": "XLSX", | 92 | "format": "XLSX", | ||
93 | "hash": "5df3cf5708e9cb924c78cfaa5fc881bc", | 93 | "hash": "5df3cf5708e9cb924c78cfaa5fc881bc", | ||
94 | "header_row": "1", | 94 | "header_row": "1", | ||
95 | "id": "cc57e1ce-6fef-4631-986f-27d34aae8a38", | 95 | "id": "cc57e1ce-6fef-4631-986f-27d34aae8a38", | ||
96 | "last_modified": "2022-11-25T19:26:42.242866", | 96 | "last_modified": "2022-11-25T19:26:42.242866", | ||
t | 97 | "load_status": "Loading 2358 rows to datastore", | t | 97 | "load_status": "ERROR: Unable to find a usable engine; tried |
98 | using: 'sqlalchemy'.\nA suitable version of sqlalchemy is required for | ||||
99 | sql I/O support.\nTrying to import the above resulted in these | ||||
100 | errors:\n - Pandas requires version '1.4.16' or newer of 'sqlalchemy' | ||||
101 | (version '1.3.5' currently installed).", | ||||
98 | "metadata_modified": "2022-11-25T19:26:47.062075", | 102 | "metadata_modified": "2022-11-25T19:26:47.303819", | ||
99 | "mimetype": | 103 | "mimetype": | ||
100 | "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", | 104 | "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", | ||
101 | "mimetype_inner": null, | 105 | "mimetype_inner": null, | ||
102 | "name": "Temperature (2019-04-03 to 2022-04-06) Centennial | 106 | "name": "Temperature (2019-04-03 to 2022-04-06) Centennial | ||
103 | Wetland ", | 107 | Wetland ", | ||
104 | "package_id": "f4531a92-6ed4-4b4f-b190-ad57c6afcf87", | 108 | "package_id": "f4531a92-6ed4-4b4f-b190-ad57c6afcf87", | ||
105 | "position": 0, | 109 | "position": 0, | ||
106 | "recent_qa_date": "2022-11-25", | 110 | "recent_qa_date": "2022-11-25", | ||
107 | "resource_citation": "Rossland Streamkeepers. (2021). | 111 | "resource_citation": "Rossland Streamkeepers. (2021). | ||
108 | Temperature (2020-04-03 to 2022-04-06) Centennial Wetland. Columbia | 112 | Temperature (2020-04-03 to 2022-04-06) Centennial Wetland. Columbia | ||
109 | Basin Water Hub [Resource]. Rossland. | 113 | Basin Water Hub [Resource]. Rossland. | ||
110 | https://doi.org/10.48511/pgpx-1w35", | 114 | https://doi.org/10.48511/pgpx-1w35", | ||
111 | "resource_data_disclaimer": "No warranty or guarantee exists | 115 | "resource_data_disclaimer": "No warranty or guarantee exists | ||
112 | that the information is accurate, complete, current, or suitable for | 116 | that the information is accurate, complete, current, or suitable for | ||
113 | any purpose. The individual user must confirm the accuracy of the data | 117 | any purpose. The individual user must confirm the accuracy of the data | ||
114 | and whether it will be appropriate for their purpose.", | 118 | and whether it will be appropriate for their purpose.", | ||
115 | "resource_location": "Stream in Centennial Wetland, Rossland", | 119 | "resource_location": "Stream in Centennial Wetland, Rossland", | ||
116 | "resource_type": null, | 120 | "resource_type": null, | ||
117 | "size": 611480, | 121 | "size": 611480, | ||
118 | "state": "active", | 122 | "state": "active", | ||
119 | "url": | 123 | "url": | ||
120 | d34aae8a38/download/rs_temp_centennialwetland_20190403_20220406.xlsx", | 124 | d34aae8a38/download/rs_temp_centennialwetland_20190403_20220406.xlsx", | ||
121 | "url_type": "upload", | 125 | "url_type": "upload", | ||
122 | "waterhub_grade": "Community Research Grade" | 126 | "waterhub_grade": "Community Research Grade" | ||
123 | } | 127 | } | ||
124 | ], | 128 | ], | ||
125 | "start_date": "2019-04-03", | 129 | "start_date": "2019-04-03", | ||
126 | "state": "active", | 130 | "state": "active", | ||
127 | "tags": [ | 131 | "tags": [ | ||
128 | { | 132 | { | ||
129 | "display_name": "Community Research Grade", | 133 | "display_name": "Community Research Grade", | ||
130 | "id": "1f0dafbc-c76f-4b7c-9200-880b759fe7f4", | 134 | "id": "1f0dafbc-c76f-4b7c-9200-880b759fe7f4", | ||
131 | "name": "Community Research Grade", | 135 | "name": "Community Research Grade", | ||
132 | "state": "active", | 136 | "state": "active", | ||
133 | "vocabulary_id": null | 137 | "vocabulary_id": null | ||
134 | }, | 138 | }, | ||
135 | { | 139 | { | ||
136 | "display_name": "Community-based monitoring", | 140 | "display_name": "Community-based monitoring", | ||
137 | "id": "9b75240a-5e54-43c9-9063-969983d065f6", | 141 | "id": "9b75240a-5e54-43c9-9063-969983d065f6", | ||
138 | "name": "Community-based monitoring", | 142 | "name": "Community-based monitoring", | ||
139 | "state": "active", | 143 | "state": "active", | ||
140 | "vocabulary_id": null | 144 | "vocabulary_id": null | ||
141 | }, | 145 | }, | ||
142 | { | 146 | { | ||
143 | "display_name": "Stream", | 147 | "display_name": "Stream", | ||
144 | "id": "208421f0-ebb5-4b32-8111-2ff156803d73", | 148 | "id": "208421f0-ebb5-4b32-8111-2ff156803d73", | ||
145 | "name": "Stream", | 149 | "name": "Stream", | ||
146 | "state": "active", | 150 | "state": "active", | ||
147 | "vocabulary_id": null | 151 | "vocabulary_id": null | ||
148 | }, | 152 | }, | ||
149 | { | 153 | { | ||
150 | "display_name": "Water temperature", | 154 | "display_name": "Water temperature", | ||
151 | "id": "0770347d-73eb-4f60-a661-50199f7049c3", | 155 | "id": "0770347d-73eb-4f60-a661-50199f7049c3", | ||
152 | "name": "Water temperature", | 156 | "name": "Water temperature", | ||
153 | "state": "active", | 157 | "state": "active", | ||
154 | "vocabulary_id": null | 158 | "vocabulary_id": null | ||
155 | } | 159 | } | ||
156 | ], | 160 | ], | ||
157 | "title": "Centennial Wetland Temperature", | 161 | "title": "Centennial Wetland Temperature", | ||
158 | "type": "dataset", | 162 | "type": "dataset", | ||
159 | "url": null, | 163 | "url": null, | ||
160 | "version": null | 164 | "version": null | ||
161 | } | 165 | } |