Changes
On April 16, 2024 at 10:56:59 PM UTC, michael-stockermans-1908:
-
Renamed resource Conductivity (2004-05-23 to 2006-??-??) Haley Creek to Conductivity (2023-04-05 to 2024-03-30) Haley Creek in Haley Creek
-
Updated description of resource Conductivity (2023-04-05 to 2024-03-30) Haley Creek in Haley Creek from
A Onset HOBO U24 Conductivity Data Logger programmed to measure conductivity every 6 hours in Haley Creek at the temperature monitoring location. Deployed 4 May 2022.
toA Onset HOBO U24 Conductivity Data Logger programmed to measure conductivity every 6 hours in Haley Creek at the temperature monitoring location. Data collection started on 2023-04-05 through until 2024-03-30.
-
Uploaded a new file to resource Conductivity (2023-04-05 to 2024-03-30) Haley Creek in Haley Creek
-
Added the following fields to resource Conductivity (2023-04-05 to 2024-03-30) Haley Creek in Haley Creek
-
site with value
parameter with value
-
Changed value of field
resource_citation
of resource Conductivity (2023-04-05 to 2024-03-30) Haley Creek toBill Coedy, Rossland Streamkeepers. (2023). Conductivity (2023-04-05 to 2024-03-30) Haley Creek [Resource]. Columbia Basin Water Hub. DOI
(previouslyBill Coedy, Rossland Streamkeepers. (2023). Conductivity (2004-05-23 to 2006-??-??) Haley Creek [Resource]. Columbia Basin Water Hub. DOI
) in Haley Creek -
Changed value of field
recent_qa_date
to2024-04-16
in resource Conductivity (2023-04-05 to 2024-03-30) Haley Creek in Haley Creek -
Changed value of field
resource_data_disclaimer
toNo warranty or guarantee exists that the information is accurate, complete, current, or suitable for any purpose. The individual user must confirm the accuracy of the data and whether it will be appropriate for their purpose.
in resource Conductivity (2023-04-05 to 2024-03-30) Haley Creek in Haley Creek -
Changed value of field
data_processing
of resource Conductivity (2023-04-05 to 2024-03-30) Haley Creek toProcessed with scripting to convert formats into XLSX then CSV. This was re-assembled from raw data formats into a compatible CSV using scripting tools and date re-structuring.
(previouslyProcessed with scripting to convert formats into XLSX then CSV.
) in Haley Creek -
Changed value of field
waterhub_grade
toCommunity Research Grade
in resource Conductivity (2023-04-05 to 2024-03-30) Haley Creek in Haley Creek
f | 1 | { | f | 1 | { |
2 | "author": null, | 2 | "author": null, | ||
3 | "author_email": null, | 3 | "author_email": null, | ||
4 | "citation": "Rossland Streamkeepers. (2022). Haley Creek [Data | 4 | "citation": "Rossland Streamkeepers. (2022). Haley Creek [Data | ||
5 | set]. Columbia Basin Water Hub. https://doi.org/10.48511/0RZV-YQ31", | 5 | set]. Columbia Basin Water Hub. https://doi.org/10.48511/0RZV-YQ31", | ||
6 | "creator": "Rossland Streamkeepers", | 6 | "creator": "Rossland Streamkeepers", | ||
7 | "creator_user_id": "f510817b-5df1-47a6-9a21-a22c9f1eaa77", | 7 | "creator_user_id": "f510817b-5df1-47a6-9a21-a22c9f1eaa77", | ||
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": "2022-10-04", | 13 | "end_date": "2022-10-04", | ||
14 | "funding_reference": "N/A", | 14 | "funding_reference": "N/A", | ||
15 | "groups": [ | 15 | "groups": [ | ||
16 | { | 16 | { | ||
17 | "description": "This group includes all the datasets which fall | 17 | "description": "This group includes all the datasets which fall | ||
18 | within the Lower Columbia-Kootenay Hydrologic region", | 18 | within the Lower Columbia-Kootenay Hydrologic region", | ||
19 | "display_name": "Lower Columbia-Kootenay", | 19 | "display_name": "Lower Columbia-Kootenay", | ||
20 | "id": "7b51570f-3a68-4db0-b6f7-6089037c7cbd", | 20 | "id": "7b51570f-3a68-4db0-b6f7-6089037c7cbd", | ||
21 | "image_display_url": | 21 | "image_display_url": | ||
22 | erhub.ca/uploads/group/2021-03-02-225850.777385Mapfinallowerkoot.png", | 22 | erhub.ca/uploads/group/2021-03-02-225850.777385Mapfinallowerkoot.png", | ||
23 | "name": "lower-columbia-kootenay", | 23 | "name": "lower-columbia-kootenay", | ||
24 | "title": "Lower Columbia-Kootenay" | 24 | "title": "Lower Columbia-Kootenay" | ||
25 | } | 25 | } | ||
26 | ], | 26 | ], | ||
27 | "id": "e06a8dda-cd38-4f23-bcca-d988d9aded29", | 27 | "id": "e06a8dda-cd38-4f23-bcca-d988d9aded29", | ||
28 | "identifier": "10.48511/0RZV-YQ31", | 28 | "identifier": "10.48511/0RZV-YQ31", | ||
29 | "isopen": false, | 29 | "isopen": false, | ||
30 | "keywords": "Technical Research Grade,Water | 30 | "keywords": "Technical Research Grade,Water | ||
31 | temperature,Stream,Metals,Lab Water Quality,People and Perspectives", | 31 | temperature,Stream,Metals,Lab Water Quality,People and Perspectives", | ||
32 | "latitude": "49.0975", | 32 | "latitude": "49.0975", | ||
33 | "license_id": "CC-BY-NC-SA-4.0", | 33 | "license_id": "CC-BY-NC-SA-4.0", | ||
34 | "license_title": "CC-BY-NC-SA-4.0", | 34 | "license_title": "CC-BY-NC-SA-4.0", | ||
35 | "location": "Haley Creek, Warfield BC\r\ndownstream from the treated | 35 | "location": "Haley Creek, Warfield BC\r\ndownstream from the treated | ||
36 | Teck landfill station ", | 36 | Teck landfill station ", | ||
37 | "longitude": "-117.7375", | 37 | "longitude": "-117.7375", | ||
38 | "maintainer": null, | 38 | "maintainer": null, | ||
39 | "maintainer_email": "cbwaterhub@livinglakescanada.ca", | 39 | "maintainer_email": "cbwaterhub@livinglakescanada.ca", | ||
40 | "metadata_created": "2021-03-22T22:36:55.179626", | 40 | "metadata_created": "2021-03-22T22:36:55.179626", | ||
n | 41 | "metadata_modified": "2024-04-15T13:02:54.220716", | n | 41 | "metadata_modified": "2024-04-16T22:56:59.701968", |
42 | "name": "haley-creek", | 42 | "name": "haley-creek", | ||
43 | "notes": "Temperature measurements from a Tidbit datalogger for | 43 | "notes": "Temperature measurements from a Tidbit datalogger for | ||
44 | Haley Creek. This is part of a program that monitors the temperature | 44 | Haley Creek. This is part of a program that monitors the temperature | ||
45 | of nine creeks in the Trail Creek Watershed, and one location in the | 45 | of nine creeks in the Trail Creek Watershed, and one location in the | ||
46 | Topping Creek Watershed.\r\nConductivity by datalogger began in | 46 | Topping Creek Watershed.\r\nConductivity by datalogger began in | ||
47 | 2022.\r\nWater quality analysis snapshot collected after Teck | 47 | 2022.\r\nWater quality analysis snapshot collected after Teck | ||
48 | remediation methods.", | 48 | remediation methods.", | ||
49 | "num_resources": 5, | 49 | "num_resources": 5, | ||
50 | "num_tags": 6, | 50 | "num_tags": 6, | ||
51 | "organization": { | 51 | "organization": { | ||
52 | "approval_status": "approved", | 52 | "approval_status": "approved", | ||
53 | "created": "2020-07-27T08:24:30.188760", | 53 | "created": "2020-07-27T08:24:30.188760", | ||
54 | "description": "A citizen organization passionate about aquatic | 54 | "description": "A citizen organization passionate about aquatic | ||
55 | monitoring, protection and enhancement of our local mountain fed | 55 | monitoring, protection and enhancement of our local mountain fed | ||
56 | creeks, wetlands and groundwater. We provide education in local | 56 | creeks, wetlands and groundwater. We provide education in local | ||
57 | watersheds to schools and produce public outreach materials and | 57 | watersheds to schools and produce public outreach materials and | ||
58 | events. See website rosslandstreamkeepers.ca for more information.", | 58 | events. See website rosslandstreamkeepers.ca for more information.", | ||
59 | "id": "5d537bb0-2ede-430a-a9f8-82b01d28e83c", | 59 | "id": "5d537bb0-2ede-430a-a9f8-82b01d28e83c", | ||
60 | "image_url": "2020-12-04-181320.951101IMG2707.jpg", | 60 | "image_url": "2020-12-04-181320.951101IMG2707.jpg", | ||
61 | "is_organization": true, | 61 | "is_organization": true, | ||
62 | "name": "rossland-streamkeepers", | 62 | "name": "rossland-streamkeepers", | ||
63 | "state": "active", | 63 | "state": "active", | ||
64 | "title": "Rossland Streamkeepers", | 64 | "title": "Rossland Streamkeepers", | ||
65 | "type": "organization" | 65 | "type": "organization" | ||
66 | }, | 66 | }, | ||
67 | "other_sources": "N/A", | 67 | "other_sources": "N/A", | ||
68 | "owner_org": "5d537bb0-2ede-430a-a9f8-82b01d28e83c", | 68 | "owner_org": "5d537bb0-2ede-430a-a9f8-82b01d28e83c", | ||
69 | "private": false, | 69 | "private": false, | ||
70 | "publication_year": "2022", | 70 | "publication_year": "2022", | ||
71 | "relationships_as_object": [], | 71 | "relationships_as_object": [], | ||
72 | "relationships_as_subject": [], | 72 | "relationships_as_subject": [], | ||
73 | "resources": [ | 73 | "resources": [ | ||
74 | { | 74 | { | ||
75 | "cache_last_updated": null, | 75 | "cache_last_updated": null, | ||
76 | "cache_url": null, | 76 | "cache_url": null, | ||
77 | "created": "2023-09-09T00:11:36.994163", | 77 | "created": "2023-09-09T00:11:36.994163", | ||
78 | "data_collection_info": "As per lab protocol, used ALS Lab | 78 | "data_collection_info": "As per lab protocol, used ALS Lab | ||
79 | sample bottles; rinsed 3x, grab sample collected, samples shipped | 79 | sample bottles; rinsed 3x, grab sample collected, samples shipped | ||
80 | immediately to lab for analysis. Samples analyzed by ALS | 80 | immediately to lab for analysis. Samples analyzed by ALS | ||
81 | Laboratories.", | 81 | Laboratories.", | ||
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. We are not conducting QA/QC on the values themselves.", | 85 | purpose. We are not conducting QA/QC on the values themselves.", | ||
86 | "data_type": "lab", | 86 | "data_type": "lab", | ||
87 | "datastore_active": true, | 87 | "datastore_active": true, | ||
88 | "datastore_contains_all_records_of_source_file": false, | 88 | "datastore_contains_all_records_of_source_file": false, | ||
89 | "datastore_status": "ready", | 89 | "datastore_status": "ready", | ||
90 | "description": "This resource contains laboratory analysis of a | 90 | "description": "This resource contains laboratory analysis of a | ||
91 | single grab water sample collected from Haley Creek on 2023-06-22 with | 91 | single grab water sample collected from Haley Creek on 2023-06-22 with | ||
92 | issuing on 2023-08-30.", | 92 | issuing on 2023-08-30.", | ||
93 | "format": "CSV", | 93 | "format": "CSV", | ||
94 | "hash": "4cdb4f037391070550c6e36eb1521308", | 94 | "hash": "4cdb4f037391070550c6e36eb1521308", | ||
95 | "header_row": "1", | 95 | "header_row": "1", | ||
96 | "id": "4d254729-f301-471e-93ef-717b93f3b691", | 96 | "id": "4d254729-f301-471e-93ef-717b93f3b691", | ||
97 | "last_modified": "2023-12-06T19:37:21.292333", | 97 | "last_modified": "2023-12-06T19:37:21.292333", | ||
98 | "load_status": "Table was successfully loaded: 56 rows", | 98 | "load_status": "Table was successfully loaded: 56 rows", | ||
99 | "metadata_modified": "2024-04-15T13:02:30.065468", | 99 | "metadata_modified": "2024-04-15T13:02:30.065468", | ||
100 | "mimetype": "text/csv", | 100 | "mimetype": "text/csv", | ||
101 | "mimetype_inner": null, | 101 | "mimetype_inner": null, | ||
102 | "name": "Water Quality (2023-06-22) Haley Creek", | 102 | "name": "Water Quality (2023-06-22) Haley Creek", | ||
103 | "package_id": "e06a8dda-cd38-4f23-bcca-d988d9aded29", | 103 | "package_id": "e06a8dda-cd38-4f23-bcca-d988d9aded29", | ||
104 | "parameter": [ | 104 | "parameter": [ | ||
105 | { | 105 | { | ||
106 | "lab_name": "ALS Labs", | 106 | "lab_name": "ALS Labs", | ||
107 | "sample_date_time": "2023-06-20", | 107 | "sample_date_time": "2023-06-20", | ||
108 | "sample_details": "Lab Provided Bottles", | 108 | "sample_details": "Lab Provided Bottles", | ||
109 | "sample_id": " VA23B4184-001", | 109 | "sample_id": " VA23B4184-001", | ||
110 | "sample_site_id": "Haley Creek", | 110 | "sample_site_id": "Haley Creek", | ||
111 | "time_zone": "PT" | 111 | "time_zone": "PT" | ||
112 | } | 112 | } | ||
113 | ], | 113 | ], | ||
114 | "position": 0, | 114 | "position": 0, | ||
115 | "recent_qa_date": "2023-09-08", | 115 | "recent_qa_date": "2023-09-08", | ||
116 | "resource_citation": "Rossland Streamkeepers. (2021). Water | 116 | "resource_citation": "Rossland Streamkeepers. (2021). Water | ||
117 | Quality (2023-06-22) Haley Creek. Columbia Basin Water Hub | 117 | Quality (2023-06-22) Haley Creek. Columbia Basin Water Hub | ||
118 | [Resource]. Warfield. https://doi.org/10.48511/0RZV-YQ31", | 118 | [Resource]. Warfield. https://doi.org/10.48511/0RZV-YQ31", | ||
119 | "resource_data_disclaimer": "No warranty or guarantee exists | 119 | "resource_data_disclaimer": "No warranty or guarantee exists | ||
120 | that the information is accurate, complete, current, or suitable for | 120 | that the information is accurate, complete, current, or suitable for | ||
121 | 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 | ||
122 | and whether it will be appropriate for their purpose.", | 122 | and whether it will be appropriate for their purpose.", | ||
123 | "resource_location": "Haley Creek, Warfield", | 123 | "resource_location": "Haley Creek, Warfield", | ||
124 | "resource_type": null, | 124 | "resource_type": null, | ||
125 | "site": [ | 125 | "site": [ | ||
126 | { | 126 | { | ||
127 | "datum": "WGS84", | 127 | "datum": "WGS84", | ||
128 | "elevation": 537, | 128 | "elevation": 537, | ||
129 | "latitude": 49.0975, | 129 | "latitude": 49.0975, | ||
130 | "longitude": -117.7375, | 130 | "longitude": -117.7375, | ||
131 | "site_id": "Haley Creek", | 131 | "site_id": "Haley Creek", | ||
132 | "site_name": "Haley Creek", | 132 | "site_name": "Haley Creek", | ||
133 | "waterbody": "Haley Creek", | 133 | "waterbody": "Haley Creek", | ||
134 | "waterbody_type": "stream/river" | 134 | "waterbody_type": "stream/river" | ||
135 | } | 135 | } | ||
136 | ], | 136 | ], | ||
137 | "size": 11271, | 137 | "size": 11271, | ||
138 | "state": "active", | 138 | "state": "active", | ||
139 | "url": | 139 | "url": | ||
140 | 7b93f3b691/download/rs_waterquality_haleycreek_20230622_20230830.csv", | 140 | 7b93f3b691/download/rs_waterquality_haleycreek_20230622_20230830.csv", | ||
141 | "url_type": "upload", | 141 | "url_type": "upload", | ||
142 | "waterhub_grade": "Technical Research Grade" | 142 | "waterhub_grade": "Technical Research Grade" | ||
143 | }, | 143 | }, | ||
144 | { | 144 | { | ||
145 | "cache_last_updated": null, | 145 | "cache_last_updated": null, | ||
146 | "cache_url": null, | 146 | "cache_url": null, | ||
147 | "created": "2021-03-22T22:38:10.580256", | 147 | "created": "2021-03-22T22:38:10.580256", | ||
148 | "data_collection_info": "Tidbit fastened to 10 lb plastic coated | 148 | "data_collection_info": "Tidbit fastened to 10 lb plastic coated | ||
149 | round dumbbell with cinch ties and tethered by cord to nearest tree. | 149 | round dumbbell with cinch ties and tethered by cord to nearest tree. | ||
150 | Device deployed at waterfall from culvert at Trail Creek.\r\nAn Onset | 150 | Device deployed at waterfall from culvert at Trail Creek.\r\nAn Onset | ||
151 | Hobo Conductivity Logger U24 (new battery Aug 2022) was placed in the | 151 | Hobo Conductivity Logger U24 (new battery Aug 2022) was placed in the | ||
152 | stream to record conductivity every 6 hours.", | 152 | stream to record conductivity every 6 hours.", | ||
153 | "data_processing": "The Water Hub has performed a preliminary | 153 | "data_processing": "The Water Hub has performed a preliminary | ||
154 | QA/QC protocol on this data but the individual user must still confirm | 154 | QA/QC protocol on this data but the individual user must still confirm | ||
155 | the accuracy of the data and whether it will be appropriate for their | 155 | the accuracy of the data and whether it will be appropriate for their | ||
156 | purpose.", | 156 | purpose.", | ||
157 | "data_type": "non-lab", | 157 | "data_type": "non-lab", | ||
158 | "datastore_active": true, | 158 | "datastore_active": true, | ||
159 | "datastore_contains_all_records_of_source_file": false, | 159 | "datastore_contains_all_records_of_source_file": false, | ||
160 | "datastore_status": "ready", | 160 | "datastore_status": "ready", | ||
161 | "description": "This resource is part of the Trail Creek | 161 | "description": "This resource is part of the Trail Creek | ||
162 | Watershed monitoring program and contains temperature measurements for | 162 | Watershed monitoring program and contains temperature measurements for | ||
163 | Haley Creek, a tributary of Trail Creek.", | 163 | Haley Creek, a tributary of Trail Creek.", | ||
164 | "format": "CSV", | 164 | "format": "CSV", | ||
165 | "hash": "8a1541b7347791c28d82c5be6eba9e34", | 165 | "hash": "8a1541b7347791c28d82c5be6eba9e34", | ||
166 | "header_row": "1", | 166 | "header_row": "1", | ||
167 | "id": "6a42c79f-9577-4098-81c9-4d255b9ba329", | 167 | "id": "6a42c79f-9577-4098-81c9-4d255b9ba329", | ||
168 | "last_modified": "2023-12-06T19:35:26.525111", | 168 | "last_modified": "2023-12-06T19:35:26.525111", | ||
169 | "load_status": "Table was successfully loaded: 3183 rows", | 169 | "load_status": "Table was successfully loaded: 3183 rows", | ||
170 | "metadata_modified": "2024-04-12T16:07:14.568208", | 170 | "metadata_modified": "2024-04-12T16:07:14.568208", | ||
171 | "mimetype": "text/csv", | 171 | "mimetype": "text/csv", | ||
172 | "mimetype_inner": null, | 172 | "mimetype_inner": null, | ||
173 | "name": "Temperature (2019-04-03 to 2023-06-20) Haley Creek ", | 173 | "name": "Temperature (2019-04-03 to 2023-06-20) Haley Creek ", | ||
174 | "package_id": "e06a8dda-cd38-4f23-bcca-d988d9aded29", | 174 | "package_id": "e06a8dda-cd38-4f23-bcca-d988d9aded29", | ||
175 | "parameter": [ | 175 | "parameter": [ | ||
176 | { | 176 | { | ||
177 | "accuracy": "\u00b10.2\u00b0C", | 177 | "accuracy": "\u00b10.2\u00b0C", | ||
178 | "calibration": "Factory calibrated", | 178 | "calibration": "Factory calibrated", | ||
179 | "instrument_manufacturer": "HOBO", | 179 | "instrument_manufacturer": "HOBO", | ||
180 | "instrument_model": "MX2203", | 180 | "instrument_model": "MX2203", | ||
181 | "instrument_type": "Data Logger", | 181 | "instrument_type": "Data Logger", | ||
182 | "notes_method": "Tidbit fastened to 10 lb plastic coated | 182 | "notes_method": "Tidbit fastened to 10 lb plastic coated | ||
183 | round dumbbell with cinch ties and tethered by cord to nearest tree.", | 183 | round dumbbell with cinch ties and tethered by cord to nearest tree.", | ||
184 | "parameter": "Water Temperature", | 184 | "parameter": "Water Temperature", | ||
185 | "parameter_unit": "degrees celsius", | 185 | "parameter_unit": "degrees celsius", | ||
186 | "range": "-20\u00b0 to 50\u00b0C (-4\u00b0 to 122\u00b0F) in | 186 | "range": "-20\u00b0 to 50\u00b0C (-4\u00b0 to 122\u00b0F) in | ||
187 | water", | 187 | water", | ||
188 | "resolution": "n/a", | 188 | "resolution": "n/a", | ||
189 | "serial_number": 20533209, | 189 | "serial_number": 20533209, | ||
190 | "time_zone": "GMT-7" | 190 | "time_zone": "GMT-7" | ||
191 | } | 191 | } | ||
192 | ], | 192 | ], | ||
193 | "position": 1, | 193 | "position": 1, | ||
194 | "recent_qa_date": "2022-11-25", | 194 | "recent_qa_date": "2022-11-25", | ||
195 | "resource_citation": "Rossland Streamkeepers. (2021). | 195 | "resource_citation": "Rossland Streamkeepers. (2021). | ||
196 | Temperature (2019-04-03 to 2023-06-20) Haley Creek. Columbia Basin | 196 | Temperature (2019-04-03 to 2023-06-20) Haley Creek. Columbia Basin | ||
197 | Water Hub [Resource]. Warfield. https://doi.org/10.48511/0rzv-yq31", | 197 | Water Hub [Resource]. Warfield. https://doi.org/10.48511/0rzv-yq31", | ||
198 | "resource_data_disclaimer": "No warranty or guarantee exists | 198 | "resource_data_disclaimer": "No warranty or guarantee exists | ||
199 | that the information is accurate, complete, current, or suitable for | 199 | that the information is accurate, complete, current, or suitable for | ||
200 | any purpose. The individual user must confirm the accuracy of the data | 200 | any purpose. The individual user must confirm the accuracy of the data | ||
201 | and whether it will be appropriate for their purpose.", | 201 | and whether it will be appropriate for their purpose.", | ||
202 | "resource_location": "Haley Creek, Warfield. Haley Creek flows | 202 | "resource_location": "Haley Creek, Warfield. Haley Creek flows | ||
203 | from the Teck landfill and Village of Warfield water treatment | 203 | from the Teck landfill and Village of Warfield water treatment | ||
204 | plant.", | 204 | plant.", | ||
205 | "resource_type": null, | 205 | "resource_type": null, | ||
206 | "site": [ | 206 | "site": [ | ||
207 | { | 207 | { | ||
208 | "datum": "WGS84", | 208 | "datum": "WGS84", | ||
209 | "elevation": 537, | 209 | "elevation": 537, | ||
210 | "latitude": 49.0975, | 210 | "latitude": 49.0975, | ||
211 | "longitude": -117.7375, | 211 | "longitude": -117.7375, | ||
212 | "site_id": "Haley_Creek", | 212 | "site_id": "Haley_Creek", | ||
213 | "site_name": "Haley_Creek", | 213 | "site_name": "Haley_Creek", | ||
214 | "waterbody": "Haley_Creek", | 214 | "waterbody": "Haley_Creek", | ||
215 | "waterbody_type": "stream/river" | 215 | "waterbody_type": "stream/river" | ||
216 | } | 216 | } | ||
217 | ], | 217 | ], | ||
218 | "size": 318151, | 218 | "size": 318151, | ||
219 | "state": "active", | 219 | "state": "active", | ||
220 | "url": | 220 | "url": | ||
221 | -81c9-4d255b9ba329/download/rs_temp_haleycreek_20190403_20230620.csv", | 221 | -81c9-4d255b9ba329/download/rs_temp_haleycreek_20190403_20230620.csv", | ||
222 | "url_type": "upload", | 222 | "url_type": "upload", | ||
223 | "waterhub_grade": "Technical Research Grade" | 223 | "waterhub_grade": "Technical Research Grade" | ||
224 | }, | 224 | }, | ||
225 | { | 225 | { | ||
226 | "cache_last_updated": null, | 226 | "cache_last_updated": null, | ||
227 | "cache_url": null, | 227 | "cache_url": null, | ||
228 | "created": "2021-03-23T16:41:06.927129", | 228 | "created": "2021-03-23T16:41:06.927129", | ||
229 | "data_collection_info": "As per lab protocol, used ALS Lab | 229 | "data_collection_info": "As per lab protocol, used ALS Lab | ||
230 | sample bottles; rinsed 3x, grab sample collected, samples shipped | 230 | sample bottles; rinsed 3x, grab sample collected, samples shipped | ||
231 | immediately to lab for analysis. Samples analysed by ALS Laboratories. | 231 | immediately to lab for analysis. Samples analysed by ALS Laboratories. | ||
232 | ", | 232 | ", | ||
233 | "data_processing": "The Water Hub has performed a preliminary | 233 | "data_processing": "The Water Hub has performed a preliminary | ||
234 | QA/QC protocol on this data but the individual user must still confirm | 234 | QA/QC protocol on this data but the individual user must still confirm | ||
235 | the accuracy of the data and whether it will be appropriate for their | 235 | the accuracy of the data and whether it will be appropriate for their | ||
236 | purpose. We are not conducting QA/QC on the values themselves.\r\n", | 236 | purpose. We are not conducting QA/QC on the values themselves.\r\n", | ||
237 | "data_type": "lab", | 237 | "data_type": "lab", | ||
238 | "datastore_active": true, | 238 | "datastore_active": true, | ||
239 | "datastore_contains_all_records_of_source_file": false, | 239 | "datastore_contains_all_records_of_source_file": false, | ||
240 | "datastore_status": "ready", | 240 | "datastore_status": "ready", | ||
241 | "description": "This resource contains laboratory analysis of a | 241 | "description": "This resource contains laboratory analysis of a | ||
242 | water sample collected from Haley Creek in May 2020. Water quality | 242 | water sample collected from Haley Creek in May 2020. Water quality | ||
243 | data is also available for Falaise, Trail and Warfield Creeks.", | 243 | data is also available for Falaise, Trail and Warfield Creeks.", | ||
244 | "format": "CSV", | 244 | "format": "CSV", | ||
245 | "hash": "6a80e3f2a52866cc0ede29b735176533", | 245 | "hash": "6a80e3f2a52866cc0ede29b735176533", | ||
246 | "header_row": "1", | 246 | "header_row": "1", | ||
247 | "id": "54d312ec-6627-4337-a47b-aae5deb976ca", | 247 | "id": "54d312ec-6627-4337-a47b-aae5deb976ca", | ||
248 | "last_modified": "2023-12-06T19:36:29.257053", | 248 | "last_modified": "2023-12-06T19:36:29.257053", | ||
249 | "load_status": "ERROR: (psycopg2.errors.InsufficientPrivilege) | 249 | "load_status": "ERROR: (psycopg2.errors.InsufficientPrivilege) | ||
250 | must be owner of table | 250 | must be owner of table | ||
251 | 54d312ec-6627-4337-a47b-aae5deb976ca\r\n\r\n[SQL: \r\nDROP TABLE | 251 | 54d312ec-6627-4337-a47b-aae5deb976ca\r\n\r\n[SQL: \r\nDROP TABLE | ||
252 | \"54d312ec-6627-4337-a47b-aae5deb976ca\"]\r\n(Background on this error | 252 | \"54d312ec-6627-4337-a47b-aae5deb976ca\"]\r\n(Background on this error | ||
253 | at: http://sqlalche.me/e/f405)", | 253 | at: http://sqlalche.me/e/f405)", | ||
254 | "metadata_modified": "2024-02-08T20:46:02.279595", | 254 | "metadata_modified": "2024-02-08T20:46:02.279595", | ||
255 | "mimetype": "text/csv", | 255 | "mimetype": "text/csv", | ||
256 | "mimetype_inner": null, | 256 | "mimetype_inner": null, | ||
257 | "name": "Water Quality (May 2020) Haley Creek ", | 257 | "name": "Water Quality (May 2020) Haley Creek ", | ||
258 | "package_id": "e06a8dda-cd38-4f23-bcca-d988d9aded29", | 258 | "package_id": "e06a8dda-cd38-4f23-bcca-d988d9aded29", | ||
259 | "parameter": [ | 259 | "parameter": [ | ||
260 | { | 260 | { | ||
261 | "lab_name": "ALS Labs", | 261 | "lab_name": "ALS Labs", | ||
262 | "sample_date_time": "2020-05-29 10:42:00", | 262 | "sample_date_time": "2020-05-29 10:42:00", | ||
263 | "sample_details": "Lab Provided Bottles", | 263 | "sample_details": "Lab Provided Bottles", | ||
264 | "sample_id": "VA20A6347-003", | 264 | "sample_id": "VA20A6347-003", | ||
265 | "sample_site_id": "Haley Creek", | 265 | "sample_site_id": "Haley Creek", | ||
266 | "time_zone": "PT" | 266 | "time_zone": "PT" | ||
267 | } | 267 | } | ||
268 | ], | 268 | ], | ||
269 | "position": 2, | 269 | "position": 2, | ||
270 | "recent_qa_date": "", | 270 | "recent_qa_date": "", | ||
271 | "resource_citation": "Rossland Streamkeepers. (2021). Water | 271 | "resource_citation": "Rossland Streamkeepers. (2021). Water | ||
272 | Quality (May 2020) Haley Creek. Columbia Basin Water Hub [Resource]. | 272 | Quality (May 2020) Haley Creek. Columbia Basin Water Hub [Resource]. | ||
273 | Warfield. https://doi.org/10.48511/0RZV-YQ31", | 273 | Warfield. https://doi.org/10.48511/0RZV-YQ31", | ||
274 | "resource_data_disclaimer": "No warranty or guarantee exists | 274 | "resource_data_disclaimer": "No warranty or guarantee exists | ||
275 | that the information is accurate, complete, current, or suitable for | 275 | that the information is accurate, complete, current, or suitable for | ||
276 | any purpose. The individual user must confirm the accuracy of the data | 276 | any purpose. The individual user must confirm the accuracy of the data | ||
277 | and whether it will be appropriate for their purpose. ", | 277 | and whether it will be appropriate for their purpose. ", | ||
278 | "resource_location": "Haley Creek, Warfield\r\n", | 278 | "resource_location": "Haley Creek, Warfield\r\n", | ||
279 | "resource_type": null, | 279 | "resource_type": null, | ||
280 | "site": [ | 280 | "site": [ | ||
281 | { | 281 | { | ||
282 | "datum": "WGS84", | 282 | "datum": "WGS84", | ||
283 | "elevation": 537, | 283 | "elevation": 537, | ||
284 | "latitude": 49.0975, | 284 | "latitude": 49.0975, | ||
285 | "longitude": -117.7375, | 285 | "longitude": -117.7375, | ||
286 | "site_id": "Haley Creek", | 286 | "site_id": "Haley Creek", | ||
287 | "site_name": "Haley Creek", | 287 | "site_name": "Haley Creek", | ||
288 | "waterbody": "Haley Creek", | 288 | "waterbody": "Haley Creek", | ||
289 | "waterbody_type": "stream/river" | 289 | "waterbody_type": "stream/river" | ||
290 | } | 290 | } | ||
291 | ], | 291 | ], | ||
292 | "size": 9969, | 292 | "size": 9969, | ||
293 | "state": "active", | 293 | "state": "active", | ||
294 | "url": | 294 | "url": | ||
295 | 7-a47b-aae5deb976ca/download/rs_waterquality_haleycreek_20200511.csv", | 295 | 7-a47b-aae5deb976ca/download/rs_waterquality_haleycreek_20200511.csv", | ||
296 | "url_type": "upload", | 296 | "url_type": "upload", | ||
297 | "waterhub_grade": "Technical Research Grade" | 297 | "waterhub_grade": "Technical Research Grade" | ||
298 | }, | 298 | }, | ||
299 | { | 299 | { | ||
300 | "cache_last_updated": null, | 300 | "cache_last_updated": null, | ||
301 | "cache_url": null, | 301 | "cache_url": null, | ||
302 | "created": "2021-03-23T20:02:27.985271", | 302 | "created": "2021-03-23T20:02:27.985271", | ||
303 | "data_collection_info": "As per lab protocol, used ALS Lab | 303 | "data_collection_info": "As per lab protocol, used ALS Lab | ||
304 | sample bottles; rinsed 3x, grab sample collected, samples shipped | 304 | sample bottles; rinsed 3x, grab sample collected, samples shipped | ||
305 | immediately to lab for analysis.", | 305 | immediately to lab for analysis.", | ||
306 | "data_processing": "Samples analysed by ALS Laboratories.", | 306 | "data_processing": "Samples analysed by ALS Laboratories.", | ||
307 | "data_type": "non-lab", | 307 | "data_type": "non-lab", | ||
308 | "datastore_active": false, | 308 | "datastore_active": false, | ||
309 | "datastore_contains_all_records_of_source_file": false, | 309 | "datastore_contains_all_records_of_source_file": false, | ||
310 | "datastore_status": "", | 310 | "datastore_status": "", | ||
311 | "description": "Photo of water sampling at Haley Creek in May | 311 | "description": "Photo of water sampling at Haley Creek in May | ||
312 | 2020.", | 312 | 2020.", | ||
313 | "format": "JPEG", | 313 | "format": "JPEG", | ||
314 | "hash": "1573d114f579c28c58d2ed0612e6a642", | 314 | "hash": "1573d114f579c28c58d2ed0612e6a642", | ||
315 | "header_row": "", | 315 | "header_row": "", | ||
316 | "id": "cfced888-0836-486e-b2c0-530433ef32a3", | 316 | "id": "cfced888-0836-486e-b2c0-530433ef32a3", | ||
317 | "last_modified": "2021-03-23T20:02:27.959046", | 317 | "last_modified": "2021-03-23T20:02:27.959046", | ||
318 | "load_status": "Invalid header row: ", | 318 | "load_status": "Invalid header row: ", | ||
319 | "metadata_modified": "2022-11-25T19:57:33.538438", | 319 | "metadata_modified": "2022-11-25T19:57:33.538438", | ||
320 | "mimetype": "image/jpeg", | 320 | "mimetype": "image/jpeg", | ||
321 | "mimetype_inner": null, | 321 | "mimetype_inner": null, | ||
322 | "name": "Haley Creek Water Quality Photo (May 2020)", | 322 | "name": "Haley Creek Water Quality Photo (May 2020)", | ||
323 | "package_id": "e06a8dda-cd38-4f23-bcca-d988d9aded29", | 323 | "package_id": "e06a8dda-cd38-4f23-bcca-d988d9aded29", | ||
324 | "position": 3, | 324 | "position": 3, | ||
325 | "resource_citation": "Rossland Streamkeepers. (2021) Haley Creek | 325 | "resource_citation": "Rossland Streamkeepers. (2021) Haley Creek | ||
326 | Water Quality Photo (May 2020). Columbia Basin Water Hub. [Resource] | 326 | Water Quality Photo (May 2020). Columbia Basin Water Hub. [Resource] | ||
327 | Warfield. https://doi.org/10.48511/0RZV-YQ31", | 327 | Warfield. https://doi.org/10.48511/0RZV-YQ31", | ||
328 | "resource_data_disclaimer": "No warranty or guarantee exists | 328 | "resource_data_disclaimer": "No warranty or guarantee exists | ||
329 | that the information is accurate, complete, current, or suitable for | 329 | that the information is accurate, complete, current, or suitable for | ||
330 | any purpose. The individual user must confirm the accuracy of the data | 330 | any purpose. The individual user must confirm the accuracy of the data | ||
331 | and whether it will be appropriate for their purpose.", | 331 | and whether it will be appropriate for their purpose.", | ||
332 | "resource_location": "Haley Creek, Warfield", | 332 | "resource_location": "Haley Creek, Warfield", | ||
333 | "resource_type": null, | 333 | "resource_type": null, | ||
334 | "size": 1999746, | 334 | "size": 1999746, | ||
335 | "state": "active", | 335 | "state": "active", | ||
336 | "url": | 336 | "url": | ||
337 | -0836-486e-b2c0-530433ef32a3/download/rossland_photos_haley_2020.jpg", | 337 | -0836-486e-b2c0-530433ef32a3/download/rossland_photos_haley_2020.jpg", | ||
338 | "url_type": "upload", | 338 | "url_type": "upload", | ||
339 | "waterhub_certified": "Certified", | 339 | "waterhub_certified": "Certified", | ||
340 | "waterhub_grade": "People and Perspectives" | 340 | "waterhub_grade": "People and Perspectives" | ||
341 | }, | 341 | }, | ||
342 | { | 342 | { | ||
343 | "cache_last_updated": null, | 343 | "cache_last_updated": null, | ||
344 | "cache_url": null, | 344 | "cache_url": null, | ||
345 | "created": "2023-10-01T17:34:27.341248", | 345 | "created": "2023-10-01T17:34:27.341248", | ||
346 | "data_collection_info": "by Onset HOBO Conductivity U24 data | 346 | "data_collection_info": "by Onset HOBO Conductivity U24 data | ||
347 | logger set at intervals of 6 hrs", | 347 | logger set at intervals of 6 hrs", | ||
348 | "data_processing": "Processed with scripting to convert formats | 348 | "data_processing": "Processed with scripting to convert formats | ||
n | 349 | into XLSX then CSV.", | n | 349 | into XLSX then CSV. This was re-assembled from raw data formats into a |
350 | compatible CSV using scripting tools and date re-structuring.", | ||||
350 | "data_type": "non-lab", | 351 | "data_type": "non-lab", | ||
351 | "datastore_active": true, | 352 | "datastore_active": true, | ||
352 | "datastore_contains_all_records_of_source_file": false, | 353 | "datastore_contains_all_records_of_source_file": false, | ||
353 | "datastore_status": "ready", | 354 | "datastore_status": "ready", | ||
354 | "description": "A Onset HOBO U24 Conductivity Data Logger | 355 | "description": "A Onset HOBO U24 Conductivity Data Logger | ||
355 | programmed to measure conductivity every 6 hours in Haley Creek at the | 356 | programmed to measure conductivity every 6 hours in Haley Creek at the | ||
n | 356 | temperature monitoring location. Deployed 4 May 2022.", | n | 357 | temperature monitoring location. Data collection started on 2023-04-05 |
358 | through until 2024-03-30.", | ||||
357 | "format": "CSV", | 359 | "format": "CSV", | ||
358 | "hash": "75fe9d9035771b6398b36e2877ea0904", | 360 | "hash": "75fe9d9035771b6398b36e2877ea0904", | ||
359 | "header_row": "1", | 361 | "header_row": "1", | ||
360 | "id": "20382e75-e25b-4d1b-b923-f4fca241c7fb", | 362 | "id": "20382e75-e25b-4d1b-b923-f4fca241c7fb", | ||
361 | "last_modified": "2023-12-11T18:14:34.296933", | 363 | "last_modified": "2023-12-11T18:14:34.296933", | ||
362 | "load_status": "Table was successfully loaded: 911 rows", | 364 | "load_status": "Table was successfully loaded: 911 rows", | ||
n | 363 | "metadata_modified": "2024-04-15T13:00:42.222689", | n | 365 | "metadata_modified": "2024-04-16T22:56:59.709631", |
364 | "mimetype": "text/csv", | 366 | "mimetype": "text/csv", | ||
365 | "mimetype_inner": null, | 367 | "mimetype_inner": null, | ||
n | 366 | "name": "Conductivity (2004-05-23 to 2006-??-??) Haley Creek ", | n | 368 | "name": "Conductivity (2023-04-05 to 2024-03-30) Haley Creek ", |
367 | "package_id": "e06a8dda-cd38-4f23-bcca-d988d9aded29", | 369 | "package_id": "e06a8dda-cd38-4f23-bcca-d988d9aded29", | ||
n | n | 370 | "parameter": [ | ||
371 | { | ||||
372 | "accuracy": "6 hour interval", | ||||
373 | "calibration": "", | ||||
374 | "instrument_manufacturer": "Onset HOBO", | ||||
375 | "instrument_model": "Conductivity U24 data logger", | ||||
376 | "instrument_type": "Data Logger", | ||||
377 | "notes_method": "", | ||||
378 | "parameter": "conductivity", | ||||
379 | "parameter_unit": "microsiemens per centimetre", | ||||
380 | "range": "", | ||||
381 | "time_zone": "MT" | ||||
382 | }, | ||||
383 | { | ||||
384 | "accuracy": "6 hour interval", | ||||
385 | "calibration": "", | ||||
386 | "instrument_manufacturer": "Onset HOBO", | ||||
387 | "instrument_model": "Conductivity U24 data logger", | ||||
388 | "instrument_type": "Data Logger", | ||||
389 | "notes_method": "", | ||||
390 | "parameter": "Water Temperature", | ||||
391 | "parameter_unit": "degrees celsius", | ||||
392 | "range": "", | ||||
393 | "time_zone": "MT" | ||||
394 | } | ||||
395 | ], | ||||
368 | "position": 4, | 396 | "position": 4, | ||
n | 369 | "recent_qa_date": "", | n | 397 | "recent_qa_date": "2024-04-16", |
370 | "resource_citation": "Bill Coedy, Rossland Streamkeepers. | 398 | "resource_citation": "Bill Coedy, Rossland Streamkeepers. | ||
n | 371 | (2023). Conductivity (2004-05-23 to 2006-??-??) Haley Creek | n | 399 | (2023). Conductivity (2023-04-05 to 2024-03-30) Haley Creek |
372 | [Resource]. Columbia Basin Water Hub. DOI", | 400 | [Resource]. Columbia Basin Water Hub. DOI", | ||
n | 373 | "resource_data_disclaimer": "", | n | 401 | "resource_data_disclaimer": "No warranty or guarantee exists |
402 | that the information is accurate, complete, current, or suitable for | ||||
403 | any purpose. The individual user must confirm the accuracy of the data | ||||
404 | and whether it will be appropriate for their purpose.", | ||||
374 | "resource_location": "Haley Creek, Warfield, BC. 49.09775 N, | 405 | "resource_location": "Haley Creek, Warfield, BC. 49.09775 N, | ||
375 | -117.73771 W", | 406 | -117.73771 W", | ||
376 | "resource_type": null, | 407 | "resource_type": null, | ||
n | n | 408 | "site": [ | ||
409 | { | ||||
410 | "datum": "WGS84", | ||||
411 | "elevation": 1, | ||||
412 | "latitude": 49.0975, | ||||
413 | "longitude": -116.92399, | ||||
414 | "site_id": "Haley Creek", | ||||
415 | "site_name": "Haley Creek", | ||||
416 | "waterbody": "Haley Creek", | ||||
417 | "waterbody_type": "stream/river" | ||||
418 | } | ||||
419 | ], | ||||
377 | "size": 124055, | 420 | "size": 124055, | ||
378 | "state": "active", | 421 | "state": "active", | ||
379 | "url": | 422 | "url": | ||
n | 380 | fca241c7fb/download/rs_conductivity_haleycreek_20040523_20062023.csv", | n | 423 | fca241c7fb/download/rs_conductivity_haleycreek_20230405_20240330.csv", |
381 | "url_type": "upload", | 424 | "url_type": "upload", | ||
t | 382 | "waterhub_grade": "" | t | 425 | "waterhub_grade": "Community Research Grade" |
383 | } | 426 | } | ||
384 | ], | 427 | ], | ||
385 | "start_date": "2019-04-03", | 428 | "start_date": "2019-04-03", | ||
386 | "state": "active", | 429 | "state": "active", | ||
387 | "station_url": "", | 430 | "station_url": "", | ||
388 | "tags": [ | 431 | "tags": [ | ||
389 | { | 432 | { | ||
390 | "display_name": "Lab Water Quality", | 433 | "display_name": "Lab Water Quality", | ||
391 | "id": "5a36f422-9cf9-481b-810d-9f697259b26c", | 434 | "id": "5a36f422-9cf9-481b-810d-9f697259b26c", | ||
392 | "name": "Lab Water Quality", | 435 | "name": "Lab Water Quality", | ||
393 | "state": "active", | 436 | "state": "active", | ||
394 | "vocabulary_id": null | 437 | "vocabulary_id": null | ||
395 | }, | 438 | }, | ||
396 | { | 439 | { | ||
397 | "display_name": "Metals", | 440 | "display_name": "Metals", | ||
398 | "id": "10271145-f032-4164-9c59-74d8a78e5c34", | 441 | "id": "10271145-f032-4164-9c59-74d8a78e5c34", | ||
399 | "name": "Metals", | 442 | "name": "Metals", | ||
400 | "state": "active", | 443 | "state": "active", | ||
401 | "vocabulary_id": null | 444 | "vocabulary_id": null | ||
402 | }, | 445 | }, | ||
403 | { | 446 | { | ||
404 | "display_name": "People and Perspectives", | 447 | "display_name": "People and Perspectives", | ||
405 | "id": "bce02f6f-d09f-4305-8e4e-bfeabaeb3a2c", | 448 | "id": "bce02f6f-d09f-4305-8e4e-bfeabaeb3a2c", | ||
406 | "name": "People and Perspectives", | 449 | "name": "People and Perspectives", | ||
407 | "state": "active", | 450 | "state": "active", | ||
408 | "vocabulary_id": null | 451 | "vocabulary_id": null | ||
409 | }, | 452 | }, | ||
410 | { | 453 | { | ||
411 | "display_name": "Stream", | 454 | "display_name": "Stream", | ||
412 | "id": "208421f0-ebb5-4b32-8111-2ff156803d73", | 455 | "id": "208421f0-ebb5-4b32-8111-2ff156803d73", | ||
413 | "name": "Stream", | 456 | "name": "Stream", | ||
414 | "state": "active", | 457 | "state": "active", | ||
415 | "vocabulary_id": null | 458 | "vocabulary_id": null | ||
416 | }, | 459 | }, | ||
417 | { | 460 | { | ||
418 | "display_name": "Technical Research Grade", | 461 | "display_name": "Technical Research Grade", | ||
419 | "id": "97d8e587-1cbd-450e-96a0-e8cfad092b83", | 462 | "id": "97d8e587-1cbd-450e-96a0-e8cfad092b83", | ||
420 | "name": "Technical Research Grade", | 463 | "name": "Technical Research Grade", | ||
421 | "state": "active", | 464 | "state": "active", | ||
422 | "vocabulary_id": null | 465 | "vocabulary_id": null | ||
423 | }, | 466 | }, | ||
424 | { | 467 | { | ||
425 | "display_name": "Water temperature", | 468 | "display_name": "Water temperature", | ||
426 | "id": "0770347d-73eb-4f60-a661-50199f7049c3", | 469 | "id": "0770347d-73eb-4f60-a661-50199f7049c3", | ||
427 | "name": "Water temperature", | 470 | "name": "Water temperature", | ||
428 | "state": "active", | 471 | "state": "active", | ||
429 | "vocabulary_id": null | 472 | "vocabulary_id": null | ||
430 | } | 473 | } | ||
431 | ], | 474 | ], | ||
432 | "title": "Haley Creek", | 475 | "title": "Haley Creek", | ||
433 | "type": "dataset", | 476 | "type": "dataset", | ||
434 | "url": null, | 477 | "url": null, | ||
435 | "version": null | 478 | "version": null | ||
436 | } | 479 | } |