Changes
On December 27, 2022 at 8:58:03 PM UTC, lladmin:
-
Changed value of field
datastore_active
toTrue
in resource Temperature (2019-03-27 to 2022-10-18) Milkranch Creek in Milkranch Creek Temperature -
Changed value of field
load_status
of resource Temperature (2019-03-27 to 2022-10-18) Milkranch Creek toReading tabular file rs_temp_milkranchcreek_20190327_20221018.xlsx (xlsx)
(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 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-10-18", | 14 | "end_date": "2022-10-18", | ||
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 10 m | 36 | "location": "Milkranch Creek, Rossland\r\nlocation moved 10 m | ||
37 | downstream July 2022", | 37 | downstream July 2022", | ||
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-12-27T20:58:02.795160", | n | 42 | "metadata_modified": "2022-12-27T20:58:03.211629", |
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": "2022", | 68 | "publication_year": "2022", | ||
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", | ||
n | 86 | "datastore_active": false, | n | 86 | "datastore_active": true, |
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": "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": "9e95ef64ed6b7446187d8c13f639c96a", | 95 | "hash": "9e95ef64ed6b7446187d8c13f639c96a", | ||
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-12-27T20:57:59.200965", | 98 | "last_modified": "2022-12-27T20:57:59.200965", | ||
t | 99 | "load_status": "ERROR: Unable to find a usable engine; tried | t | 99 | "load_status": "Reading tabular file |
100 | using: 'sqlalchemy'.\r\nA suitable version of sqlalchemy is required | 100 | rs_temp_milkranchcreek_20190327_20221018.xlsx (xlsx)", | ||
101 | for sql I/O support.\r\nTrying to import the above resulted in these | ||||
102 | errors:\r\n - Pandas requires version '1.4.16' or newer of | ||||
103 | 'sqlalchemy' (version '1.3.5' currently installed).", | ||||
104 | "metadata_modified": "2022-12-27T20:58:02.800380", | 101 | "metadata_modified": "2022-12-27T20:58:03.214935", | ||
105 | "mimetype": | 102 | "mimetype": | ||
106 | "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", | 103 | "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", | ||
107 | "mimetype_inner": null, | 104 | "mimetype_inner": null, | ||
108 | "name": "Temperature (2019-03-27 to 2022-10-18) Milkranch Creek | 105 | "name": "Temperature (2019-03-27 to 2022-10-18) Milkranch Creek | ||
109 | ", | 106 | ", | ||
110 | "package_id": "fa599e62-b6b3-40a3-8cf3-2084eef4eeea", | 107 | "package_id": "fa599e62-b6b3-40a3-8cf3-2084eef4eeea", | ||
111 | "position": 0, | 108 | "position": 0, | ||
112 | "recent_qa_date": "2022-11-25", | 109 | "recent_qa_date": "2022-11-25", | ||
113 | "resource_citation": "Rossland Streamkeepers. (2021) Temperature | 110 | "resource_citation": "Rossland Streamkeepers. (2021) Temperature | ||
114 | (2019-03-27 to 2022-10-18) Milkranch Creek. Columbia Basin Water Hub | 111 | (2019-03-27 to 2022-10-18) Milkranch Creek. Columbia Basin Water Hub | ||
115 | [Resource]. Rossland. https://doi.org/10.48511/BG4Y-J876", | 112 | [Resource]. Rossland. https://doi.org/10.48511/BG4Y-J876", | ||
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.", | 116 | and whether it will be appropriate for their purpose.", | ||
120 | "resource_id": "c8c2707e-010f-4992-8af9-f632724b7c5b", | 117 | "resource_id": "c8c2707e-010f-4992-8af9-f632724b7c5b", | ||
121 | "resource_location": "Milkranch Creek, Rossland\r\nmoved 10 m | 118 | "resource_location": "Milkranch Creek, Rossland\r\nmoved 10 m | ||
122 | downstream in July 2022\r\ndatalogger found chewed by animal in dry | 119 | downstream in July 2022\r\ndatalogger found chewed by animal in dry | ||
123 | creek bed in Oct 2022 - still working", | 120 | creek bed in Oct 2022 - still working", | ||
124 | "resource_type": null, | 121 | "resource_type": null, | ||
125 | "size": 591308, | 122 | "size": 591308, | ||
126 | "state": "active", | 123 | "state": "active", | ||
127 | "url": | 124 | "url": | ||
128 | -f632724b7c5b/download/rs_temp_milkranchcreek_20190327_20221018.xlsx", | 125 | -f632724b7c5b/download/rs_temp_milkranchcreek_20190327_20221018.xlsx", | ||
129 | "url_type": "upload", | 126 | "url_type": "upload", | ||
130 | "waterhub_grade": "Community Research Grade" | 127 | "waterhub_grade": "Community Research Grade" | ||
131 | } | 128 | } | ||
132 | ], | 129 | ], | ||
133 | "start_date": "2019-03-27", | 130 | "start_date": "2019-03-27", | ||
134 | "state": "active", | 131 | "state": "active", | ||
135 | "tags": [ | 132 | "tags": [ | ||
136 | { | 133 | { | ||
137 | "display_name": "Community Research Grade", | 134 | "display_name": "Community Research Grade", | ||
138 | "id": "1f0dafbc-c76f-4b7c-9200-880b759fe7f4", | 135 | "id": "1f0dafbc-c76f-4b7c-9200-880b759fe7f4", | ||
139 | "name": "Community Research Grade", | 136 | "name": "Community Research Grade", | ||
140 | "state": "active", | 137 | "state": "active", | ||
141 | "vocabulary_id": null | 138 | "vocabulary_id": null | ||
142 | }, | 139 | }, | ||
143 | { | 140 | { | ||
144 | "display_name": "Community-based monitoring", | 141 | "display_name": "Community-based monitoring", | ||
145 | "id": "9b75240a-5e54-43c9-9063-969983d065f6", | 142 | "id": "9b75240a-5e54-43c9-9063-969983d065f6", | ||
146 | "name": "Community-based monitoring", | 143 | "name": "Community-based monitoring", | ||
147 | "state": "active", | 144 | "state": "active", | ||
148 | "vocabulary_id": null | 145 | "vocabulary_id": null | ||
149 | }, | 146 | }, | ||
150 | { | 147 | { | ||
151 | "display_name": "Stream", | 148 | "display_name": "Stream", | ||
152 | "id": "208421f0-ebb5-4b32-8111-2ff156803d73", | 149 | "id": "208421f0-ebb5-4b32-8111-2ff156803d73", | ||
153 | "name": "Stream", | 150 | "name": "Stream", | ||
154 | "state": "active", | 151 | "state": "active", | ||
155 | "vocabulary_id": null | 152 | "vocabulary_id": null | ||
156 | }, | 153 | }, | ||
157 | { | 154 | { | ||
158 | "display_name": "Water temperature", | 155 | "display_name": "Water temperature", | ||
159 | "id": "0770347d-73eb-4f60-a661-50199f7049c3", | 156 | "id": "0770347d-73eb-4f60-a661-50199f7049c3", | ||
160 | "name": "Water temperature", | 157 | "name": "Water temperature", | ||
161 | "state": "active", | 158 | "state": "active", | ||
162 | "vocabulary_id": null | 159 | "vocabulary_id": null | ||
163 | } | 160 | } | ||
164 | ], | 161 | ], | ||
165 | "title": "Milkranch Creek Temperature", | 162 | "title": "Milkranch Creek Temperature", | ||
166 | "type": "dataset", | 163 | "type": "dataset", | ||
167 | "url": null, | 164 | "url": null, | ||
168 | "version": null | 165 | "version": null | ||
169 | } | 166 | } |