Changes
On June 19, 2022 at 6:44:34 PM UTC, lladmin:
-
Changed value of field
load_status
of resource Groundwater (2019-07-19 to 2021-03-29) LLC VOW 13 toLoading 14862 rows to datastore
(previouslyReading tabular file llc_waterlevel_watertemp_aquifer1039_vow13_20190719_20210329.xlsx (xlsx)
) in LLC VOW 13 (WTN 101596)
f | 1 | { | f | 1 | { |
2 | "author": null, | 2 | "author": null, | ||
3 | "author_email": null, | 3 | "author_email": null, | ||
4 | "citation": "Living Lakes Canada Groundwater Monitoring Program. | 4 | "citation": "Living Lakes Canada Groundwater Monitoring Program. | ||
5 | (2021). LLC VOW 13 (WTN 101596) [Data set]. Columbia Basin Water Hub. | 5 | (2021). LLC VOW 13 (WTN 101596) [Data set]. Columbia Basin Water Hub. | ||
6 | https://doi.org/10.48511/B1RK-P520", | 6 | https://doi.org/10.48511/B1RK-P520", | ||
7 | "creator": "Living Lakes Canada Groundwater Monitoring Program", | 7 | "creator": "Living Lakes Canada Groundwater Monitoring Program", | ||
8 | "creator_user_id": "4281b3ba-1b47-464e-8c98-0ba1837e4351", | 8 | "creator_user_id": "4281b3ba-1b47-464e-8c98-0ba1837e4351", | ||
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 themselves.\r\n", | 12 | whether it will be appropriate for their purpose themselves.\r\n", | ||
13 | "data_type": "Groundwater", | 13 | "data_type": "Groundwater", | ||
14 | "end_date": "2021-03-29", | 14 | "end_date": "2021-03-29", | ||
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 Columbia-Kootenay Headwaters Hydrologic region ", | 19 | within the Columbia-Kootenay Headwaters Hydrologic region ", | ||
20 | "display_name": "Columbia-Kootenay Headwaters", | 20 | "display_name": "Columbia-Kootenay Headwaters", | ||
21 | "id": "20673d8f-8f40-4e64-9f34-4966d5123705", | 21 | "id": "20673d8f-8f40-4e64-9f34-4966d5123705", | ||
22 | "image_display_url": | 22 | "image_display_url": | ||
23 | rhub.ca/uploads/group/2021-03-02-214610.209659Mapfinalheadwayers.png", | 23 | rhub.ca/uploads/group/2021-03-02-214610.209659Mapfinalheadwayers.png", | ||
24 | "name": "columbia-kootenay-headwaters", | 24 | "name": "columbia-kootenay-headwaters", | ||
25 | "title": "Columbia-Kootenay Headwaters" | 25 | "title": "Columbia-Kootenay Headwaters" | ||
26 | } | 26 | } | ||
27 | ], | 27 | ], | ||
28 | "id": "70993fb4-37e7-4dd8-be57-edb24d918e7b", | 28 | "id": "70993fb4-37e7-4dd8-be57-edb24d918e7b", | ||
29 | "identifier": "10.48511/B1RK-P520", | 29 | "identifier": "10.48511/B1RK-P520", | ||
30 | "isopen": false, | 30 | "isopen": false, | ||
31 | "keywords": "Groundwater,Water Level,Technical Research Grade,People | 31 | "keywords": "Groundwater,Water Level,Technical Research Grade,People | ||
32 | and Perspectives,Water temperature,Hydrometric", | 32 | and Perspectives,Water temperature,Hydrometric", | ||
33 | "latitude": "50.82434", | 33 | "latitude": "50.82434", | ||
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": "Brisco, Sylvania Road. East side of Columbia | 36 | "location": "Brisco, Sylvania Road. East side of Columbia | ||
37 | Wetlands\r\n", | 37 | Wetlands\r\n", | ||
38 | "longitude": "-116.24762", | 38 | "longitude": "-116.24762", | ||
39 | "maintainer": null, | 39 | "maintainer": null, | ||
40 | "maintainer_email": "groundwater@livinglakescanada.ca", | 40 | "maintainer_email": "groundwater@livinglakescanada.ca", | ||
41 | "metadata_created": "2021-03-08T23:38:32.645433", | 41 | "metadata_created": "2021-03-08T23:38:32.645433", | ||
n | 42 | "metadata_modified": "2022-06-19T18:44:31.116790", | n | 42 | "metadata_modified": "2022-06-19T18:44:34.580623", |
43 | "name": "llc_vow_13_wtn_101596", | 43 | "name": "llc_vow_13_wtn_101596", | ||
44 | "notes": "This dataset is part of the Living Lakes Canada Upper | 44 | "notes": "This dataset is part of the Living Lakes Canada Upper | ||
45 | Columbia Basin Groundwater Monitoring Program, and contains a | 45 | Columbia Basin Groundwater Monitoring Program, and contains a | ||
46 | groundwater level monitoring record for VOW 13. Additional | 46 | groundwater level monitoring record for VOW 13. Additional | ||
47 | information can be found in accompanying reports.\r\n", | 47 | information can be found in accompanying reports.\r\n", | ||
48 | "num_resources": 1, | 48 | "num_resources": 1, | ||
49 | "num_tags": 6, | 49 | "num_tags": 6, | ||
50 | "organization": { | 50 | "organization": { | ||
51 | "approval_status": "approved", | 51 | "approval_status": "approved", | ||
52 | "created": "2021-03-08T15:34:26.521768", | 52 | "created": "2021-03-08T15:34:26.521768", | ||
53 | "description": "The Living Lakes Canada Groundwater Monitoring | 53 | "description": "The Living Lakes Canada Groundwater Monitoring | ||
54 | Program is collecting continuous (hourly) groundwater level data from | 54 | Program is collecting continuous (hourly) groundwater level data from | ||
55 | Volunteer Observation Wells throughout the Upper Columbia Basin. ", | 55 | Volunteer Observation Wells throughout the Upper Columbia Basin. ", | ||
56 | "id": "c4e124a2-fcc0-4323-9d28-dfb9001ab555", | 56 | "id": "c4e124a2-fcc0-4323-9d28-dfb9001ab555", | ||
57 | "image_url": "2021-03-09-211316.698293well-monitoring.png", | 57 | "image_url": "2021-03-09-211316.698293well-monitoring.png", | ||
58 | "is_organization": true, | 58 | "is_organization": true, | ||
59 | "name": "living-lakes-groundwater-monitoring-program", | 59 | "name": "living-lakes-groundwater-monitoring-program", | ||
60 | "state": "active", | 60 | "state": "active", | ||
61 | "title": "Living Lakes Groundwater Monitoring Program", | 61 | "title": "Living Lakes Groundwater Monitoring Program", | ||
62 | "type": "organization" | 62 | "type": "organization" | ||
63 | }, | 63 | }, | ||
64 | "other_sources": "N/A\r\n", | 64 | "other_sources": "N/A\r\n", | ||
65 | "owner_org": "c4e124a2-fcc0-4323-9d28-dfb9001ab555", | 65 | "owner_org": "c4e124a2-fcc0-4323-9d28-dfb9001ab555", | ||
66 | "private": false, | 66 | "private": false, | ||
67 | "publication_year": "2021", | 67 | "publication_year": "2021", | ||
68 | "relationships_as_object": [], | 68 | "relationships_as_object": [], | ||
69 | "relationships_as_subject": [], | 69 | "relationships_as_subject": [], | ||
70 | "resources": [ | 70 | "resources": [ | ||
71 | { | 71 | { | ||
72 | "cache_last_updated": null, | 72 | "cache_last_updated": null, | ||
73 | "cache_url": null, | 73 | "cache_url": null, | ||
74 | "created": "2021-03-08T23:40:22.646310", | 74 | "created": "2021-03-08T23:40:22.646310", | ||
75 | "data_collection_info": "Continuous (hourly) water level data | 75 | "data_collection_info": "Continuous (hourly) water level data | ||
76 | were collected with a HOBO MX 2001 Bluetooth (9 meter range) water | 76 | were collected with a HOBO MX 2001 Bluetooth (9 meter range) water | ||
77 | level logger. The data logger determines water levels by continuously | 77 | level logger. The data logger determines water levels by continuously | ||
78 | collecting the absolute pressure of the water column above a sensor, | 78 | collecting the absolute pressure of the water column above a sensor, | ||
79 | compensating it for atmospheric pressure, and calibrating it with | 79 | compensating it for atmospheric pressure, and calibrating it with | ||
80 | reference water levels that are collected manually. The atmospheric | 80 | reference water levels that are collected manually. The atmospheric | ||
81 | pressure is measured by a barometric sensor in the MX2001 top end unit | 81 | pressure is measured by a barometric sensor in the MX2001 top end unit | ||
82 | that is installed in the airspace at the top of the wellhead. Manual | 82 | that is installed in the airspace at the top of the wellhead. Manual | ||
83 | water level level measurements were collected using either a Heron or | 83 | water level level measurements were collected using either a Heron or | ||
84 | Solinst water level tape (sounding tape). \r\n", | 84 | Solinst water level tape (sounding tape). \r\n", | ||
85 | "data_processing": "Data compensation and water level | 85 | "data_processing": "Data compensation and water level | ||
86 | referencing are completed with the HOBOmobile App. For the conversion | 86 | referencing are completed with the HOBOmobile App. For the conversion | ||
87 | of pressure to water level, the water density of freshwater is | 87 | of pressure to water level, the water density of freshwater is | ||
88 | adjusted for water temperature. Pressures are converted to water level | 88 | adjusted for water temperature. Pressures are converted to water level | ||
89 | based on manual water manual readings using a water level tape. The | 89 | based on manual water manual readings using a water level tape. The | ||
90 | pressure data were reviewed to ensure they are within the factory | 90 | pressure data were reviewed to ensure they are within the factory | ||
91 | calibrated range of the sensor. Manual and logger data were compared | 91 | calibrated range of the sensor. Manual and logger data were compared | ||
92 | to identify potential instrument drift. The differences between the | 92 | to identify potential instrument drift. The differences between the | ||
93 | manual measurements (6) and the data logger were all less than 1.9 cm. | 93 | manual measurements (6) and the data logger were all less than 1.9 cm. | ||
94 | ", | 94 | ", | ||
95 | "datastore_active": false, | 95 | "datastore_active": false, | ||
96 | "datastore_status": "pending", | 96 | "datastore_status": "pending", | ||
97 | "description": "This resource is part of the Living Lakes Canada | 97 | "description": "This resource is part of the Living Lakes Canada | ||
98 | Upper Columbia Basin Groundwater Monitoring Program, and contains a | 98 | Upper Columbia Basin Groundwater Monitoring Program, and contains a | ||
99 | groundwater monitoring record for VOW 13 from 2019-07-19 to | 99 | groundwater monitoring record for VOW 13 from 2019-07-19 to | ||
100 | 2020-10-29. Water levels are reported in meters below ground surface. | 100 | 2020-10-29. Water levels are reported in meters below ground surface. | ||
101 | This resource will be updated periodically to add new data.\r\n", | 101 | This resource will be updated periodically to add new data.\r\n", | ||
102 | "format": "XLSX", | 102 | "format": "XLSX", | ||
103 | "hash": "41988aeb341523334ac6f59f67fd3a44", | 103 | "hash": "41988aeb341523334ac6f59f67fd3a44", | ||
104 | "header_row": "1", | 104 | "header_row": "1", | ||
105 | "id": "bdae8d07-d54c-4cf1-9e7c-452c6892dfe9", | 105 | "id": "bdae8d07-d54c-4cf1-9e7c-452c6892dfe9", | ||
106 | "last_modified": "2022-06-19T18:44:27.290662", | 106 | "last_modified": "2022-06-19T18:44:27.290662", | ||
t | 107 | "load_status": "Reading tabular file | t | 107 | "load_status": "Loading 14862 rows to datastore", |
108 | llc_waterlevel_watertemp_aquifer1039_vow13_20190719_20210329.xlsx | ||||
109 | (xlsx)", | ||||
110 | "metadata_modified": "2022-06-19T18:44:31.120324", | 108 | "metadata_modified": "2022-06-19T18:44:34.583672", | ||
111 | "mimetype": | 109 | "mimetype": | ||
112 | "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", | 110 | "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", | ||
113 | "mimetype_inner": null, | 111 | "mimetype_inner": null, | ||
114 | "name": "Groundwater (2019-07-19 to 2021-03-29) LLC VOW 13", | 112 | "name": "Groundwater (2019-07-19 to 2021-03-29) LLC VOW 13", | ||
115 | "package_id": "70993fb4-37e7-4dd8-be57-edb24d918e7b", | 113 | "package_id": "70993fb4-37e7-4dd8-be57-edb24d918e7b", | ||
116 | "position": 0, | 114 | "position": 0, | ||
117 | "resource_citation": "Living Lakes Canada Upper Columbia Basin | 115 | "resource_citation": "Living Lakes Canada Upper Columbia Basin | ||
118 | Groundwater Monitoring Program (2021). Groundwater (2019-07-19 to | 116 | Groundwater Monitoring Program (2021). Groundwater (2019-07-19 to | ||
119 | 2021-03-29) LLC VOW 13. Columbia Basin Water Hub. (Resource) Brisco. | 117 | 2021-03-29) LLC VOW 13. Columbia Basin Water Hub. (Resource) Brisco. | ||
120 | (DOI). \r\n", | 118 | (DOI). \r\n", | ||
121 | "resource_data_disclaimer": "No warranty or guarantee exists | 119 | "resource_data_disclaimer": "No warranty or guarantee exists | ||
122 | that the information is accurate, complete, current, or suitable for | 120 | that the information is accurate, complete, current, or suitable for | ||
123 | any purpose. The individual user must confirm the accuracy of the data | 121 | any purpose. The individual user must confirm the accuracy of the data | ||
124 | and whether it will be appropriate for their purpose themselves.\r\n", | 122 | and whether it will be appropriate for their purpose themselves.\r\n", | ||
125 | "resource_location": "Brisco, Sylvania Road. East side of | 123 | "resource_location": "Brisco, Sylvania Road. East side of | ||
126 | Columbia Wetlands\r\n", | 124 | Columbia Wetlands\r\n", | ||
127 | "resource_type": null, | 125 | "resource_type": null, | ||
128 | "size": 2537880, | 126 | "size": 2537880, | ||
129 | "state": "active", | 127 | "state": "active", | ||
130 | "url": | 128 | "url": | ||
131 | ad/llc_waterlevel_watertemp_aquifer1039_vow13_20190719_20210329.xlsx", | 129 | ad/llc_waterlevel_watertemp_aquifer1039_vow13_20190719_20210329.xlsx", | ||
132 | "url_type": "upload", | 130 | "url_type": "upload", | ||
133 | "waterhub_certified": "Certified", | 131 | "waterhub_certified": "Certified", | ||
134 | "waterhub_grade": "Technical Research Grade" | 132 | "waterhub_grade": "Technical Research Grade" | ||
135 | } | 133 | } | ||
136 | ], | 134 | ], | ||
137 | "start_date": "2019-07-19", | 135 | "start_date": "2019-07-19", | ||
138 | "state": "active", | 136 | "state": "active", | ||
139 | "tags": [ | 137 | "tags": [ | ||
140 | { | 138 | { | ||
141 | "display_name": "Groundwater", | 139 | "display_name": "Groundwater", | ||
142 | "id": "243a7c8f-4e25-4fd0-93d2-e23d7977a712", | 140 | "id": "243a7c8f-4e25-4fd0-93d2-e23d7977a712", | ||
143 | "name": "Groundwater", | 141 | "name": "Groundwater", | ||
144 | "state": "active", | 142 | "state": "active", | ||
145 | "vocabulary_id": null | 143 | "vocabulary_id": null | ||
146 | }, | 144 | }, | ||
147 | { | 145 | { | ||
148 | "display_name": "Hydrometric", | 146 | "display_name": "Hydrometric", | ||
149 | "id": "ae588e2d-8628-4e7f-ad0a-2cbd38adfd76", | 147 | "id": "ae588e2d-8628-4e7f-ad0a-2cbd38adfd76", | ||
150 | "name": "Hydrometric", | 148 | "name": "Hydrometric", | ||
151 | "state": "active", | 149 | "state": "active", | ||
152 | "vocabulary_id": null | 150 | "vocabulary_id": null | ||
153 | }, | 151 | }, | ||
154 | { | 152 | { | ||
155 | "display_name": "People and Perspectives", | 153 | "display_name": "People and Perspectives", | ||
156 | "id": "bce02f6f-d09f-4305-8e4e-bfeabaeb3a2c", | 154 | "id": "bce02f6f-d09f-4305-8e4e-bfeabaeb3a2c", | ||
157 | "name": "People and Perspectives", | 155 | "name": "People and Perspectives", | ||
158 | "state": "active", | 156 | "state": "active", | ||
159 | "vocabulary_id": null | 157 | "vocabulary_id": null | ||
160 | }, | 158 | }, | ||
161 | { | 159 | { | ||
162 | "display_name": "Technical Research Grade", | 160 | "display_name": "Technical Research Grade", | ||
163 | "id": "97d8e587-1cbd-450e-96a0-e8cfad092b83", | 161 | "id": "97d8e587-1cbd-450e-96a0-e8cfad092b83", | ||
164 | "name": "Technical Research Grade", | 162 | "name": "Technical Research Grade", | ||
165 | "state": "active", | 163 | "state": "active", | ||
166 | "vocabulary_id": null | 164 | "vocabulary_id": null | ||
167 | }, | 165 | }, | ||
168 | { | 166 | { | ||
169 | "display_name": "Water Level", | 167 | "display_name": "Water Level", | ||
170 | "id": "3100ac20-0d39-473c-bd6c-5be66ff76041", | 168 | "id": "3100ac20-0d39-473c-bd6c-5be66ff76041", | ||
171 | "name": "Water Level", | 169 | "name": "Water Level", | ||
172 | "state": "active", | 170 | "state": "active", | ||
173 | "vocabulary_id": null | 171 | "vocabulary_id": null | ||
174 | }, | 172 | }, | ||
175 | { | 173 | { | ||
176 | "display_name": "Water temperature", | 174 | "display_name": "Water temperature", | ||
177 | "id": "0770347d-73eb-4f60-a661-50199f7049c3", | 175 | "id": "0770347d-73eb-4f60-a661-50199f7049c3", | ||
178 | "name": "Water temperature", | 176 | "name": "Water temperature", | ||
179 | "state": "active", | 177 | "state": "active", | ||
180 | "vocabulary_id": null | 178 | "vocabulary_id": null | ||
181 | } | 179 | } | ||
182 | ], | 180 | ], | ||
183 | "title": "LLC VOW 13 (WTN 101596)", | 181 | "title": "LLC VOW 13 (WTN 101596)", | ||
184 | "type": "dataset", | 182 | "type": "dataset", | ||
185 | "url": null, | 183 | "url": null, | ||
186 | "version": null | 184 | "version": null | ||
187 | } | 185 | } |