Changes
On November 25, 2022 at 7:03:58 PM UTC, lladmin:
-
Changed value of field
load_status
of resource Temperature (2019-03-27 to 2022-07-02) Milkranch Creek 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 2272 rows to datastore
) in Milkranch Creek Temperature -
Removed the value of field
datastore_status
in resource Temperature (2019-03-27 to 2022-07-02) Milkranch Creek in Milkranch Creek Temperature
f | 1 | { | f | 1 | { |
2 | "author": null, | 2 | "author": null, | ||
3 | "author_email": null, | 3 | "author_email": null, | ||
4 | "citation": "Rossland Streamkeepers. (2021). Milkranch Creek | 4 | "citation": "Rossland Streamkeepers. (2021). Milkranch Creek | ||
5 | Temperature [Data set]. Columbia Basin Water Hub. | 5 | Temperature [Data set]. Columbia Basin Water Hub. | ||
6 | https://doi.org/10.48511/BG4Y-J876", | 6 | https://doi.org/10.48511/BG4Y-J876", | ||
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-07-02", | 14 | "end_date": "2022-07-02", | ||
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": "fa599e62-b6b3-40a3-8cf3-2084eef4eeea", | 28 | "id": "fa599e62-b6b3-40a3-8cf3-2084eef4eeea", | ||
29 | "identifier": "10.48511/BG4Y-J876", | 29 | "identifier": "10.48511/BG4Y-J876", | ||
30 | "isopen": false, | 30 | "isopen": false, | ||
31 | "keywords": "Community Research Grade,Water | 31 | "keywords": "Community Research Grade,Water | ||
32 | temperature,Stream,Community-based monitoring", | 32 | temperature,Stream,Community-based monitoring", | ||
33 | "latitude": "49.083333", | 33 | "latitude": "49.083333", | ||
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": "Milkranch Creek, Rossland\r\nlocation moved to near | 36 | "location": "Milkranch Creek, Rossland\r\nlocation moved to near | ||
37 | wagon road trail above golf course", | 37 | wagon road trail above golf course", | ||
38 | "longitude": "-117.7625", | 38 | "longitude": "-117.7625", | ||
39 | "maintainer": null, | 39 | "maintainer": null, | ||
40 | "maintainer_email": "cbwaterhub@livinglakescanada.ca", | 40 | "maintainer_email": "cbwaterhub@livinglakescanada.ca", | ||
41 | "metadata_created": "2021-03-22T20:57:24.616147", | 41 | "metadata_created": "2021-03-22T20:57:24.616147", | ||
n | 42 | "metadata_modified": "2022-11-25T19:03:58.619020", | n | 42 | "metadata_modified": "2022-11-25T19:03:58.864415", |
43 | "name": "milkranch-creek-water-quality", | 43 | "name": "milkranch-creek-water-quality", | ||
44 | "notes": "Temperature measurements for Milkranch Creek. This is part | 44 | "notes": "Temperature measurements for Milkranch Creek. This is part | ||
45 | of a program that monitors the temperature of nine creeks in the Trail | 45 | of a program that monitors the temperature of nine creeks in the Trail | ||
46 | Creek Watershed, and one location in the Topping Creek Watershed. ", | 46 | Creek Watershed, and one 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": "2022-03-21T23:45:13.709812", | 75 | "created": "2022-03-21T23:45:13.709812", | ||
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. There is a gap in | 78 | Device deployed in deepest area of creek. There is a gap in | ||
79 | measurement between 2019-06-24 and 2019-10-04 when a new logger was | 79 | measurement between 2019-06-24 and 2019-10-04 when a new logger was | ||
80 | deployed. Between mid July and mid August 2020 the logger was | 80 | deployed. Between mid July and mid August 2020 the logger was | ||
81 | removed.", | 81 | removed.", | ||
82 | "data_processing": "The Water Hub has performed a preliminary | 82 | "data_processing": "The Water Hub has performed a preliminary | ||
83 | QA/QC protocol on this data but the individual user must still confirm | 83 | QA/QC protocol on this data but the individual user must still confirm | ||
84 | the accuracy of the data and whether it will be appropriate for their | 84 | the accuracy of the data and whether it will be appropriate for their | ||
85 | purpose.\r\n", | 85 | purpose.\r\n", | ||
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, | ||
n | 88 | "datastore_status": "pending", | n | 88 | "datastore_status": "", |
89 | "description": "This resource is part of the Trail Creek | 89 | "description": "This resource is part of the Trail Creek | ||
90 | Watershed monitoring program and contains temperature measurements for | 90 | Watershed monitoring program and contains temperature measurements for | ||
91 | Milkranch Creek, a tributary of Trail Creek. This is part of a program | 91 | Milkranch Creek, a tributary of Trail Creek. This is part of a program | ||
92 | that monitors the temperature of nine creeks in the Trail Creek | 92 | that monitors the temperature of nine creeks in the Trail Creek | ||
93 | Watershed, and one location in the Topping Creek Watershed. ", | 93 | Watershed, and one location in the Topping Creek Watershed. ", | ||
94 | "format": "XLSX", | 94 | "format": "XLSX", | ||
95 | "hash": "e50c36f16a4260062705a5fb2fee361a", | 95 | "hash": "e50c36f16a4260062705a5fb2fee361a", | ||
96 | "header_row": "1", | 96 | "header_row": "1", | ||
97 | "id": "c8c2707e-010f-4992-8af9-f632724b7c5b", | 97 | "id": "c8c2707e-010f-4992-8af9-f632724b7c5b", | ||
98 | "last_modified": "2022-11-25T19:03:54.146866", | 98 | "last_modified": "2022-11-25T19:03:54.146866", | ||
t | 99 | "load_status": "Loading 2272 rows to datastore", | t | 99 | "load_status": "ERROR: Unable to find a usable engine; tried |
100 | using: 'sqlalchemy'.\nA suitable version of sqlalchemy is required for | ||||
101 | sql I/O support.\nTrying to import the above resulted in these | ||||
102 | errors:\n - Pandas requires version '1.4.16' or newer of 'sqlalchemy' | ||||
103 | (version '1.3.5' currently installed).", | ||||
100 | "metadata_modified": "2022-11-25T19:03:58.622171", | 104 | "metadata_modified": "2022-11-25T19:03:58.867658", | ||
101 | "mimetype": | 105 | "mimetype": | ||
102 | "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", | 106 | "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", | ||
103 | "mimetype_inner": null, | 107 | "mimetype_inner": null, | ||
104 | "name": "Temperature (2019-03-27 to 2022-07-02) Milkranch Creek | 108 | "name": "Temperature (2019-03-27 to 2022-07-02) Milkranch Creek | ||
105 | ", | 109 | ", | ||
106 | "package_id": "fa599e62-b6b3-40a3-8cf3-2084eef4eeea", | 110 | "package_id": "fa599e62-b6b3-40a3-8cf3-2084eef4eeea", | ||
107 | "position": 0, | 111 | "position": 0, | ||
108 | "recent_qa_date": "2022-11-25", | 112 | "recent_qa_date": "2022-11-25", | ||
109 | "resource_citation": "Rossland Streamkeepers. (2021) Temperature | 113 | "resource_citation": "Rossland Streamkeepers. (2021) Temperature | ||
110 | (2019-03-27 to 2022-07-02) Milkranch Creek. Columbia Basin Water Hub | 114 | (2019-03-27 to 2022-07-02) Milkranch Creek. Columbia Basin Water Hub | ||
111 | [Resource]. Rossland. https://doi.org/10.48511/BG4Y-J876", | 115 | [Resource]. Rossland. https://doi.org/10.48511/BG4Y-J876", | ||
112 | "resource_data_disclaimer": "No warranty or guarantee exists | 116 | "resource_data_disclaimer": "No warranty or guarantee exists | ||
113 | that the information is accurate, complete, current, or suitable for | 117 | that the information is accurate, complete, current, or suitable for | ||
114 | any purpose. The individual user must confirm the accuracy of the data | 118 | any purpose. The individual user must confirm the accuracy of the data | ||
115 | and whether it will be appropriate for their purpose.", | 119 | and whether it will be appropriate for their purpose.", | ||
116 | "resource_location": "Milkranch Creek, Rossland\r\nre-located to | 120 | "resource_location": "Milkranch Creek, Rossland\r\nre-located to | ||
117 | above wagon road above golf course", | 121 | above wagon road above golf course", | ||
118 | "resource_type": null, | 122 | "resource_type": null, | ||
119 | "size": 558499, | 123 | "size": 558499, | ||
120 | "state": "active", | 124 | "state": "active", | ||
121 | "url": | 125 | "url": | ||
122 | -f632724b7c5b/download/rs_temp_milkranchcreek_20190327_20220702.xlsx", | 126 | -f632724b7c5b/download/rs_temp_milkranchcreek_20190327_20220702.xlsx", | ||
123 | "url_type": "upload", | 127 | "url_type": "upload", | ||
124 | "waterhub_grade": "Community Research Grade" | 128 | "waterhub_grade": "Community Research Grade" | ||
125 | } | 129 | } | ||
126 | ], | 130 | ], | ||
127 | "start_date": "2019-03-27", | 131 | "start_date": "2019-03-27", | ||
128 | "state": "active", | 132 | "state": "active", | ||
129 | "tags": [ | 133 | "tags": [ | ||
130 | { | 134 | { | ||
131 | "display_name": "Community Research Grade", | 135 | "display_name": "Community Research Grade", | ||
132 | "id": "1f0dafbc-c76f-4b7c-9200-880b759fe7f4", | 136 | "id": "1f0dafbc-c76f-4b7c-9200-880b759fe7f4", | ||
133 | "name": "Community Research Grade", | 137 | "name": "Community Research Grade", | ||
134 | "state": "active", | 138 | "state": "active", | ||
135 | "vocabulary_id": null | 139 | "vocabulary_id": null | ||
136 | }, | 140 | }, | ||
137 | { | 141 | { | ||
138 | "display_name": "Community-based monitoring", | 142 | "display_name": "Community-based monitoring", | ||
139 | "id": "9b75240a-5e54-43c9-9063-969983d065f6", | 143 | "id": "9b75240a-5e54-43c9-9063-969983d065f6", | ||
140 | "name": "Community-based monitoring", | 144 | "name": "Community-based monitoring", | ||
141 | "state": "active", | 145 | "state": "active", | ||
142 | "vocabulary_id": null | 146 | "vocabulary_id": null | ||
143 | }, | 147 | }, | ||
144 | { | 148 | { | ||
145 | "display_name": "Stream", | 149 | "display_name": "Stream", | ||
146 | "id": "208421f0-ebb5-4b32-8111-2ff156803d73", | 150 | "id": "208421f0-ebb5-4b32-8111-2ff156803d73", | ||
147 | "name": "Stream", | 151 | "name": "Stream", | ||
148 | "state": "active", | 152 | "state": "active", | ||
149 | "vocabulary_id": null | 153 | "vocabulary_id": null | ||
150 | }, | 154 | }, | ||
151 | { | 155 | { | ||
152 | "display_name": "Water temperature", | 156 | "display_name": "Water temperature", | ||
153 | "id": "0770347d-73eb-4f60-a661-50199f7049c3", | 157 | "id": "0770347d-73eb-4f60-a661-50199f7049c3", | ||
154 | "name": "Water temperature", | 158 | "name": "Water temperature", | ||
155 | "state": "active", | 159 | "state": "active", | ||
156 | "vocabulary_id": null | 160 | "vocabulary_id": null | ||
157 | } | 161 | } | ||
158 | ], | 162 | ], | ||
159 | "title": "Milkranch Creek Temperature", | 163 | "title": "Milkranch Creek Temperature", | ||
160 | "type": "dataset", | 164 | "type": "dataset", | ||
161 | "url": null, | 165 | "url": null, | ||
162 | "version": null | 166 | "version": null | ||
163 | } | 167 | } |