Changes
On December 27, 2023 at 6:03:47 PM UTC, lladmin:
-
Changed value of field
load_status
of resource Water Quality Lab Results Goat River 2022- 2023 toLoading 1999 rows to datastore
(previouslyReading tabular file wcvb_labwaterquality_goatriver_goa01_20220905_20231002.xlsx (xlsx)
) in Goat River Water Quality
f | 1 | { | f | 1 | { |
2 | "author": null, | 2 | "author": null, | ||
3 | "author_email": null, | 3 | "author_email": null, | ||
4 | "citation": "Wildsight Creston Valley. (2022-2023). Goat River Water | 4 | "citation": "Wildsight Creston Valley. (2022-2023). Goat River Water | ||
5 | Quality [Data set]. Columbia Basin Water Hub. DOI", | 5 | Quality [Data set]. Columbia Basin Water Hub. DOI", | ||
6 | "creator": "Wildsight Creston Valley", | 6 | "creator": "Wildsight Creston Valley", | ||
7 | "creator_user_id": "95e1d40d-1c5a-452b-8dc0-6e0640d9f1da", | 7 | "creator_user_id": "95e1d40d-1c5a-452b-8dc0-6e0640d9f1da", | ||
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.", | 11 | whether it will be appropriate for their purpose.", | ||
12 | "data_type": "Stream", | 12 | "data_type": "Stream", | ||
13 | "end_date": "2023-10-25", | 13 | "end_date": "2023-10-25", | ||
14 | "funding_reference": "", | 14 | "funding_reference": "", | ||
15 | "groups": [], | 15 | "groups": [], | ||
16 | "id": "d0580db6-308e-4f0c-802b-16b8303fa4e5", | 16 | "id": "d0580db6-308e-4f0c-802b-16b8303fa4e5", | ||
17 | "identifier": "", | 17 | "identifier": "", | ||
18 | "isopen": false, | 18 | "isopen": false, | ||
19 | "keywords": "Community-based monitoring,Community Research | 19 | "keywords": "Community-based monitoring,Community Research | ||
20 | Grade,Field Water Quality,Water temperature,Stream", | 20 | Grade,Field Water Quality,Water temperature,Stream", | ||
21 | "latitude": "49.0807", | 21 | "latitude": "49.0807", | ||
22 | "license_id": "CC-BY-SA-4.0", | 22 | "license_id": "CC-BY-SA-4.0", | ||
23 | "license_title": "CC-BY-SA-4.0", | 23 | "license_title": "CC-BY-SA-4.0", | ||
24 | "location": "GOA01- about 200m Upstream of Highway 21 | 24 | "location": "GOA01- about 200m Upstream of Highway 21 | ||
25 | bridge.\r\n10th Ave S- Goat River at the end of 10th Ave S. \r\n3.5km | 25 | bridge.\r\n10th Ave S- Goat River at the end of 10th Ave S. \r\n3.5km | ||
26 | Leadville FSR- Grassy area that rvs/campers use in the summer", | 26 | Leadville FSR- Grassy area that rvs/campers use in the summer", | ||
27 | "longitude": "-116.51907", | 27 | "longitude": "-116.51907", | ||
28 | "maintainer": null, | 28 | "maintainer": null, | ||
29 | "maintainer_email": "cbwaterhub@livinglakescanada.ca", | 29 | "maintainer_email": "cbwaterhub@livinglakescanada.ca", | ||
30 | "metadata_created": "2023-07-11T22:03:42.183814", | 30 | "metadata_created": "2023-07-11T22:03:42.183814", | ||
n | 31 | "metadata_modified": "2023-12-27T18:03:45.925944", | n | 31 | "metadata_modified": "2023-12-27T18:03:46.990763", |
32 | "name": "goat-river-cabin-water-quality", | 32 | "name": "goat-river-cabin-water-quality", | ||
33 | "notes": "This dataset contains water quality measurements for Goat | 33 | "notes": "This dataset contains water quality measurements for Goat | ||
34 | River. This is part of a program that collects water quality data | 34 | River. This is part of a program that collects water quality data | ||
35 | using portable meters from spring to fall on the Goat River at two | 35 | using portable meters from spring to fall on the Goat River at two | ||
36 | locations (one near hwy 21 and one near Kitchener). It also includes | 36 | locations (one near hwy 21 and one near Kitchener). It also includes | ||
37 | lab results taken during the fall during CABIN sampling. ", | 37 | lab results taken during the fall during CABIN sampling. ", | ||
38 | "num_resources": 2, | 38 | "num_resources": 2, | ||
39 | "num_tags": 5, | 39 | "num_tags": 5, | ||
40 | "organization": { | 40 | "organization": { | ||
41 | "approval_status": "approved", | 41 | "approval_status": "approved", | ||
42 | "created": "2020-07-27T08:49:08.292867", | 42 | "created": "2020-07-27T08:49:08.292867", | ||
43 | "description": "Wildsight Creston Valley engages and inspires the | 43 | "description": "Wildsight Creston Valley engages and inspires the | ||
44 | local community. We host passionate speakers throughout the year on a | 44 | local community. We host passionate speakers throughout the year on a | ||
45 | wide range of topics including wildlife and the region\u2019s | 45 | wide range of topics including wildlife and the region\u2019s | ||
46 | landscape.", | 46 | landscape.", | ||
47 | "id": "820ee378-1b32-4684-8e42-1653e3979ff9", | 47 | "id": "820ee378-1b32-4684-8e42-1653e3979ff9", | ||
48 | "image_url": "2021-03-09-192900.290061wildsight.png", | 48 | "image_url": "2021-03-09-192900.290061wildsight.png", | ||
49 | "is_organization": true, | 49 | "is_organization": true, | ||
50 | "name": "wildsight-creston-valley", | 50 | "name": "wildsight-creston-valley", | ||
51 | "state": "active", | 51 | "state": "active", | ||
52 | "title": "Wildsight Creston Valley", | 52 | "title": "Wildsight Creston Valley", | ||
53 | "type": "organization" | 53 | "type": "organization" | ||
54 | }, | 54 | }, | ||
55 | "other_sources": "CABIN specific data available at | 55 | "other_sources": "CABIN specific data available at | ||
56 | change/services/canadian-aquatic-biomonitoring-network/database.html", | 56 | change/services/canadian-aquatic-biomonitoring-network/database.html", | ||
57 | "owner_org": "820ee378-1b32-4684-8e42-1653e3979ff9", | 57 | "owner_org": "820ee378-1b32-4684-8e42-1653e3979ff9", | ||
58 | "private": false, | 58 | "private": false, | ||
59 | "publication_year": "2023", | 59 | "publication_year": "2023", | ||
60 | "relationships_as_object": [], | 60 | "relationships_as_object": [], | ||
61 | "relationships_as_subject": [], | 61 | "relationships_as_subject": [], | ||
62 | "resources": [ | 62 | "resources": [ | ||
63 | { | 63 | { | ||
64 | "cache_last_updated": null, | 64 | "cache_last_updated": null, | ||
65 | "cache_url": null, | 65 | "cache_url": null, | ||
66 | "created": "2023-07-11T22:11:46.081202", | 66 | "created": "2023-07-11T22:11:46.081202", | ||
67 | "data_collection_info": "N/A", | 67 | "data_collection_info": "N/A", | ||
68 | "data_processing": "The Water Hub has completed a preliminary | 68 | "data_processing": "The Water Hub has completed a preliminary | ||
69 | QA/QC protocol on this file, however the individual user must confirm | 69 | QA/QC protocol on this file, however the individual user must confirm | ||
70 | the accuracy of the data and whether it will be appropriate for their | 70 | the accuracy of the data and whether it will be appropriate for their | ||
71 | purpose.", | 71 | purpose.", | ||
72 | "data_type": "non-lab", | 72 | "data_type": "non-lab", | ||
73 | "datastore_active": true, | 73 | "datastore_active": true, | ||
74 | "datastore_contains_all_records_of_source_file": false, | 74 | "datastore_contains_all_records_of_source_file": false, | ||
75 | "datastore_status": "pending", | 75 | "datastore_status": "pending", | ||
76 | "description": "Data was collected using portable meters on the | 76 | "description": "Data was collected using portable meters on the | ||
77 | Goat River. Samples are taken monthly from May to October at 10th Ave | 77 | Goat River. Samples are taken monthly from May to October at 10th Ave | ||
78 | S and Leadville 3.5km. Samples are taken once a year at the CABIN | 78 | S and Leadville 3.5km. Samples are taken once a year at the CABIN | ||
79 | site GOA01.", | 79 | site GOA01.", | ||
80 | "format": "CSV", | 80 | "format": "CSV", | ||
81 | "hash": "1d35e4ab42b06d02fdb6ae91452fac41", | 81 | "hash": "1d35e4ab42b06d02fdb6ae91452fac41", | ||
82 | "header_row": "1", | 82 | "header_row": "1", | ||
83 | "id": "e9ba1221-7495-40f4-9050-13214b63d04b", | 83 | "id": "e9ba1221-7495-40f4-9050-13214b63d04b", | ||
84 | "last_modified": "2023-12-06T19:30:23.507622", | 84 | "last_modified": "2023-12-06T19:30:23.507622", | ||
85 | "load_status": "Table was successfully loaded: 13 rows", | 85 | "load_status": "Table was successfully loaded: 13 rows", | ||
86 | "metadata_modified": "2023-12-06T19:30:27.141878", | 86 | "metadata_modified": "2023-12-06T19:30:27.141878", | ||
87 | "mimetype": "text/csv", | 87 | "mimetype": "text/csv", | ||
88 | "mimetype_inner": null, | 88 | "mimetype_inner": null, | ||
89 | "name": "Field Water Quality (2022-05-01 to 2022-10-29) Goat | 89 | "name": "Field Water Quality (2022-05-01 to 2022-10-29) Goat | ||
90 | River", | 90 | River", | ||
91 | "package_id": "d0580db6-308e-4f0c-802b-16b8303fa4e5", | 91 | "package_id": "d0580db6-308e-4f0c-802b-16b8303fa4e5", | ||
92 | "position": 0, | 92 | "position": 0, | ||
93 | "recent_qa_date": "2023-07-31", | 93 | "recent_qa_date": "2023-07-31", | ||
94 | "resource_citation": "Wildsight Creston Valley. (2023). Field | 94 | "resource_citation": "Wildsight Creston Valley. (2023). Field | ||
95 | Water Quality (2022-05-01 to 2022-10-29) Goat River [Data set]. | 95 | Water Quality (2022-05-01 to 2022-10-29) Goat River [Data set]. | ||
96 | Columbia Basin Water Hub.", | 96 | Columbia Basin Water Hub.", | ||
97 | "resource_data_disclaimer": "No warranty or guarantee exists | 97 | "resource_data_disclaimer": "No warranty or guarantee exists | ||
98 | that the information is accurate, complete, current, or suitable for | 98 | that the information is accurate, complete, current, or suitable for | ||
99 | any purpose. The individual user must confirm the accuracy of the data | 99 | any purpose. The individual user must confirm the accuracy of the data | ||
100 | and whether it will be appropriate for their purpose.", | 100 | and whether it will be appropriate for their purpose.", | ||
101 | "resource_id": "e9ba1221-7495-40f4-9050-13214b63d04b", | 101 | "resource_id": "e9ba1221-7495-40f4-9050-13214b63d04b", | ||
102 | "resource_location": "GOA01- Upstream of hwy 21 bridge\r\n10th | 102 | "resource_location": "GOA01- Upstream of hwy 21 bridge\r\n10th | ||
103 | Ave S\r\n3.5km up Leadville FSR", | 103 | Ave S\r\n3.5km up Leadville FSR", | ||
104 | "resource_type": null, | 104 | "resource_type": null, | ||
105 | "size": 3831, | 105 | "size": 3831, | ||
106 | "state": "active", | 106 | "state": "active", | ||
107 | "url": | 107 | "url": | ||
108 | 63d04b/download/wc_fieldwaterquality_goatriver_20220501_20221029.csv", | 108 | 63d04b/download/wc_fieldwaterquality_goatriver_20220501_20221029.csv", | ||
109 | "url_type": "upload", | 109 | "url_type": "upload", | ||
110 | "waterhub_grade": "Community Research Grade" | 110 | "waterhub_grade": "Community Research Grade" | ||
111 | }, | 111 | }, | ||
112 | { | 112 | { | ||
113 | "cache_last_updated": null, | 113 | "cache_last_updated": null, | ||
114 | "cache_url": null, | 114 | "cache_url": null, | ||
115 | "created": "2023-12-27T18:03:41.939771", | 115 | "created": "2023-12-27T18:03:41.939771", | ||
116 | "data_collection_info": "Samples were collected and processed | 116 | "data_collection_info": "Samples were collected and processed | ||
117 | according to CARO analytical procedure.", | 117 | according to CARO analytical procedure.", | ||
118 | "data_processing": "", | 118 | "data_processing": "", | ||
119 | "data_type": "lab", | 119 | "data_type": "lab", | ||
120 | "datastore_active": false, | 120 | "datastore_active": false, | ||
121 | "datastore_contains_all_records_of_source_file": false, | 121 | "datastore_contains_all_records_of_source_file": false, | ||
122 | "datastore_status": "pending", | 122 | "datastore_status": "pending", | ||
123 | "description": "Samples collected during the fall and processed | 123 | "description": "Samples collected during the fall and processed | ||
124 | by CARO Analytical.", | 124 | by CARO Analytical.", | ||
125 | "format": "XLSX", | 125 | "format": "XLSX", | ||
126 | "hash": "42d5788058edf8db45587fc889040083", | 126 | "hash": "42d5788058edf8db45587fc889040083", | ||
127 | "header_row": "1", | 127 | "header_row": "1", | ||
128 | "id": "fd09ca81-a7aa-4deb-a334-11fdeeb34b94", | 128 | "id": "fd09ca81-a7aa-4deb-a334-11fdeeb34b94", | ||
129 | "last_modified": "2023-12-27T18:03:41.906808", | 129 | "last_modified": "2023-12-27T18:03:41.906808", | ||
t | 130 | "load_status": "Reading tabular file | t | 130 | "load_status": "Loading 1999 rows to datastore", |
131 | wcvb_labwaterquality_goatriver_goa01_20220905_20231002.xlsx (xlsx)", | ||||
132 | "metadata_modified": "2023-12-27T18:03:45.929422", | 131 | "metadata_modified": "2023-12-27T18:03:46.993587", | ||
133 | "mimetype": | 132 | "mimetype": | ||
134 | "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", | 133 | "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", | ||
135 | "mimetype_inner": null, | 134 | "mimetype_inner": null, | ||
136 | "name": "Water Quality Lab Results Goat River 2022- 2023", | 135 | "name": "Water Quality Lab Results Goat River 2022- 2023", | ||
137 | "package_id": "d0580db6-308e-4f0c-802b-16b8303fa4e5", | 136 | "package_id": "d0580db6-308e-4f0c-802b-16b8303fa4e5", | ||
138 | "position": 1, | 137 | "position": 1, | ||
139 | "recent_qa_date": "", | 138 | "recent_qa_date": "", | ||
140 | "resource_citation": "Wildsight Creston Valley. (2023). Lab | 139 | "resource_citation": "Wildsight Creston Valley. (2023). Lab | ||
141 | Water Quality Goat River 2022-2023.(Resource) Columbia Basin Water | 140 | Water Quality Goat River 2022-2023.(Resource) Columbia Basin Water | ||
142 | Hub. Dataset DOI", | 141 | Hub. Dataset DOI", | ||
143 | "resource_data_disclaimer": "", | 142 | "resource_data_disclaimer": "", | ||
144 | "resource_location": "GOA01- 200m upstream of hwy 21 | 143 | "resource_location": "GOA01- 200m upstream of hwy 21 | ||
145 | bridge\r\nGOA02- 3.5km on the Leadville FSR", | 144 | bridge\r\nGOA02- 3.5km on the Leadville FSR", | ||
146 | "resource_type": null, | 145 | "resource_type": null, | ||
147 | "site": [ | 146 | "site": [ | ||
148 | { | 147 | { | ||
149 | "datum": "WGS84", | 148 | "datum": "WGS84", | ||
150 | "elevation": 545, | 149 | "elevation": 545, | ||
151 | "latitude": 49.0807, | 150 | "latitude": 49.0807, | ||
152 | "longitude": -116.51907, | 151 | "longitude": -116.51907, | ||
153 | "site_id": "GOA01", | 152 | "site_id": "GOA01", | ||
154 | "site_name": "200m upstream of highway 21 bridge.", | 153 | "site_name": "200m upstream of highway 21 bridge.", | ||
155 | "waterbody": "Goat River", | 154 | "waterbody": "Goat River", | ||
156 | "waterbody_type": "stream/river" | 155 | "waterbody_type": "stream/river" | ||
157 | }, | 156 | }, | ||
158 | { | 157 | { | ||
159 | "datum": "WGS84", | 158 | "datum": "WGS84", | ||
160 | "latitude": 49.1917843, | 159 | "latitude": 49.1917843, | ||
161 | "longitude": -116.3443565, | 160 | "longitude": -116.3443565, | ||
162 | "site_id": "GOA02", | 161 | "site_id": "GOA02", | ||
163 | "site_name": "3.5km up Leadville FSR from Kitchener. Grassy | 162 | "site_name": "3.5km up Leadville FSR from Kitchener. Grassy | ||
164 | area that rvs/campers use in the summer", | 163 | area that rvs/campers use in the summer", | ||
165 | "waterbody": "Goat River", | 164 | "waterbody": "Goat River", | ||
166 | "waterbody_type": "stream/river" | 165 | "waterbody_type": "stream/river" | ||
167 | } | 166 | } | ||
168 | ], | 167 | ], | ||
169 | "size": 404053, | 168 | "size": 404053, | ||
170 | "state": "active", | 169 | "state": "active", | ||
171 | "url": | 170 | "url": | ||
172 | download/wcvb_labwaterquality_goatriver_goa01_20220905_20231002.xlsx", | 171 | download/wcvb_labwaterquality_goatriver_goa01_20220905_20231002.xlsx", | ||
173 | "url_type": "upload", | 172 | "url_type": "upload", | ||
174 | "waterhub_grade": "Not Reviewed" | 173 | "waterhub_grade": "Not Reviewed" | ||
175 | } | 174 | } | ||
176 | ], | 175 | ], | ||
177 | "start_date": "2022-05-01", | 176 | "start_date": "2022-05-01", | ||
178 | "state": "active", | 177 | "state": "active", | ||
179 | "station_url": "", | 178 | "station_url": "", | ||
180 | "tags": [ | 179 | "tags": [ | ||
181 | { | 180 | { | ||
182 | "display_name": "Community Research Grade", | 181 | "display_name": "Community Research Grade", | ||
183 | "id": "1f0dafbc-c76f-4b7c-9200-880b759fe7f4", | 182 | "id": "1f0dafbc-c76f-4b7c-9200-880b759fe7f4", | ||
184 | "name": "Community Research Grade", | 183 | "name": "Community Research Grade", | ||
185 | "state": "active", | 184 | "state": "active", | ||
186 | "vocabulary_id": null | 185 | "vocabulary_id": null | ||
187 | }, | 186 | }, | ||
188 | { | 187 | { | ||
189 | "display_name": "Community-based monitoring", | 188 | "display_name": "Community-based monitoring", | ||
190 | "id": "9b75240a-5e54-43c9-9063-969983d065f6", | 189 | "id": "9b75240a-5e54-43c9-9063-969983d065f6", | ||
191 | "name": "Community-based monitoring", | 190 | "name": "Community-based monitoring", | ||
192 | "state": "active", | 191 | "state": "active", | ||
193 | "vocabulary_id": null | 192 | "vocabulary_id": null | ||
194 | }, | 193 | }, | ||
195 | { | 194 | { | ||
196 | "display_name": "Field Water Quality", | 195 | "display_name": "Field Water Quality", | ||
197 | "id": "f7ccfe9a-95ee-462f-8503-44ae52c0802e", | 196 | "id": "f7ccfe9a-95ee-462f-8503-44ae52c0802e", | ||
198 | "name": "Field Water Quality", | 197 | "name": "Field Water Quality", | ||
199 | "state": "active", | 198 | "state": "active", | ||
200 | "vocabulary_id": null | 199 | "vocabulary_id": null | ||
201 | }, | 200 | }, | ||
202 | { | 201 | { | ||
203 | "display_name": "Stream", | 202 | "display_name": "Stream", | ||
204 | "id": "208421f0-ebb5-4b32-8111-2ff156803d73", | 203 | "id": "208421f0-ebb5-4b32-8111-2ff156803d73", | ||
205 | "name": "Stream", | 204 | "name": "Stream", | ||
206 | "state": "active", | 205 | "state": "active", | ||
207 | "vocabulary_id": null | 206 | "vocabulary_id": null | ||
208 | }, | 207 | }, | ||
209 | { | 208 | { | ||
210 | "display_name": "Water temperature", | 209 | "display_name": "Water temperature", | ||
211 | "id": "0770347d-73eb-4f60-a661-50199f7049c3", | 210 | "id": "0770347d-73eb-4f60-a661-50199f7049c3", | ||
212 | "name": "Water temperature", | 211 | "name": "Water temperature", | ||
213 | "state": "active", | 212 | "state": "active", | ||
214 | "vocabulary_id": null | 213 | "vocabulary_id": null | ||
215 | } | 214 | } | ||
216 | ], | 215 | ], | ||
217 | "title": "Goat River Water Quality", | 216 | "title": "Goat River Water Quality", | ||
218 | "type": "dataset", | 217 | "type": "dataset", | ||
219 | "url": null, | 218 | "url": null, | ||
220 | "version": null | 219 | "version": null | ||
221 | } | 220 | } |