Changes

              
    

          
          
        
        

            
f
1
{
f
1
{
            
2
  "author": null,
2
  "author": null,
            
3
  "author_email": null,
3
  "author_email": null,
            
4
  "citation": "CLSS. (2022). Columbia Lake (S1) [Data set]. Columbia 
4
  "citation": "CLSS. (2022). Columbia Lake (S1) [Data set]. Columbia 
            
5
Basin Water Hub. https://doi.org/10.48511/V4X5-NS17",
5
Basin Water Hub. https://doi.org/10.48511/V4X5-NS17",
            
6
  "creator": "Columbia Basin Water Hub",
6
  "creator": "Columbia Basin Water Hub",
            
7
  "creator_user_id": "74e49cb5-943c-4090-9199-8e29c06b29ef",
7
  "creator_user_id": "74e49cb5-943c-4090-9199-8e29c06b29ef",
            
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 themselves.",
11
whether it will be appropriate for their purpose themselves.",
            
12
  "data_type": "Lake",
12
  "data_type": "Lake",
            
13
  "end_date": "2022-05-27",
13
  "end_date": "2022-05-27",
            
14
  "funding_reference": "This projected is supported by: Columbia Basin 
14
  "funding_reference": "This projected is supported by: Columbia Basin 
            
15
Trust, Columbia Valley Local Conservation fund, Columbia Valley 
15
Trust, Columbia Valley Local Conservation fund, Columbia Valley 
            
16
Community Foundation, District of Canal Flats and supporting 
16
Community Foundation, District of Canal Flats and supporting 
            
17
communities.",
17
communities.",
            
18
  "groups": [],
18
  "groups": [],
            
19
  "id": "649af27c-27f4-4864-bd7a-ca8236ce462c",
19
  "id": "649af27c-27f4-4864-bd7a-ca8236ce462c",
            
20
  "identifier": "https://doi.org/10.48511/V4X5-NS17",
20
  "identifier": "https://doi.org/10.48511/V4X5-NS17",
            
21
  "isopen": false,
21
  "isopen": false,
            
22
  "keywords": "Lake,Lab Water Quality,Field Water 
22
  "keywords": "Lake,Lab Water Quality,Field Water 
            
23
Quality,Community-based monitoring,Community Research Grade",
23
Quality,Community-based monitoring,Community Research Grade",
            
24
  "latitude": "50.253929",
24
  "latitude": "50.253929",
            
25
  "license_id": "CC-BY-SA-4.0",
25
  "license_id": "CC-BY-SA-4.0",
            
26
  "license_title": "CC-BY-SA-4.0",
26
  "license_title": "CC-BY-SA-4.0",
            
27
  "location": "Middle of Columbia Lake, near Spirits Reach.",
27
  "location": "Middle of Columbia Lake, near Spirits Reach.",
            
28
  "longitude": "-115.86256",
28
  "longitude": "-115.86256",
            
29
  "maintainer": null,
29
  "maintainer": null,
            
30
  "maintainer_email": "cbwaterhub@livinglakescanada.ca",
30
  "maintainer_email": "cbwaterhub@livinglakescanada.ca",
            
31
  "metadata_created": "2022-10-19T18:47:01.374513",
31
  "metadata_created": "2022-10-19T18:47:01.374513",
            
n
32
  "metadata_modified": "2022-11-23T18:00:58.459977",
n
32
  "metadata_modified": "2022-11-23T18:00:58.712812",
            
33
  "name": "columbia-lake-s1",
33
  "name": "columbia-lake-s1",
            
34
  "notes": "Water quality data from the middle of the lake, near 
34
  "notes": "Water quality data from the middle of the lake, near 
            
35
Spirits Reach. Dataset collected to better understand health of 
35
Spirits Reach. Dataset collected to better understand health of 
            
36
Columbia lake and to communicate information to decision makers for 
36
Columbia lake and to communicate information to decision makers for 
            
37
strategic planning for management strategies, as well as to support 
37
strategic planning for management strategies, as well as to support 
            
38
our contributing partners for their future projects and initiatives.",
38
our contributing partners for their future projects and initiatives.",
            
39
  "num_resources": 2,
39
  "num_resources": 2,
            
40
  "num_tags": 5,
40
  "num_tags": 5,
            
41
  "organization": {
41
  "organization": {
            
42
    "approval_status": "approved",
42
    "approval_status": "approved",
            
43
    "created": "2021-09-03T14:49:38.225713",
43
    "created": "2021-09-03T14:49:38.225713",
            
44
    "description": "The Columbia Lake Stewardship Society is an 
44
    "description": "The Columbia Lake Stewardship Society is an 
            
45
environmental stewardship organization working to preserve the 
45
environmental stewardship organization working to preserve the 
            
46
ecological health and water supply of Columbia Lake for present and 
46
ecological health and water supply of Columbia Lake for present and 
            
47
future generations through scientific investigation, collaboration, 
47
future generations through scientific investigation, collaboration, 
            
48
and outreach.\r\n",
48
and outreach.\r\n",
            
49
    "id": "e6b9b424-d988-4378-b8c8-ac81f1ef3f91",
49
    "id": "e6b9b424-d988-4378-b8c8-ac81f1ef3f91",
            
50
    "image_url": "2021-09-03-214952.111892CLSS-logo.jpg",
50
    "image_url": "2021-09-03-214952.111892CLSS-logo.jpg",
            
51
    "is_organization": true,
51
    "is_organization": true,
            
52
    "name": "clss",
52
    "name": "clss",
            
53
    "state": "active",
53
    "state": "active",
            
54
    "title": "Columbia Lake Stewardship Society",
54
    "title": "Columbia Lake Stewardship Society",
            
55
    "type": "organization"
55
    "type": "organization"
            
56
  },
56
  },
            
57
  "other_sources": "",
57
  "other_sources": "",
            
58
  "owner_org": "e6b9b424-d988-4378-b8c8-ac81f1ef3f91",
58
  "owner_org": "e6b9b424-d988-4378-b8c8-ac81f1ef3f91",
            
59
  "private": false,
59
  "private": false,
            
60
  "publication_year": "2022",
60
  "publication_year": "2022",
            
61
  "relationships_as_object": [],
61
  "relationships_as_object": [],
            
62
  "relationships_as_subject": [],
62
  "relationships_as_subject": [],
            
63
  "resources": [
63
  "resources": [
            
64
    {
64
    {
            
65
      "cache_last_updated": null,
65
      "cache_last_updated": null,
            
66
      "cache_url": null,
66
      "cache_url": null,
            
67
      "created": "2022-10-19T18:49:00.582163",
67
      "created": "2022-10-19T18:49:00.582163",
            
68
      "data_collection_info": "Four sample bottles are filled with 
68
      "data_collection_info": "Four sample bottles are filled with 
            
69
lake water. Three of these bottles are unfiltered, and filled using a 
69
lake water. Three of these bottles are unfiltered, and filled using a 
            
70
measuring cup. One of the bottles is filtered using a new syringe and 
70
measuring cup. One of the bottles is filtered using a new syringe and 
            
71
filter apparatus.",
71
filter apparatus.",
            
72
      "data_processing": "Analyzed data as delivered by CARO 
72
      "data_processing": "Analyzed data as delivered by CARO 
            
73
Analytical Services.",
73
Analytical Services.",
            
74
      "datastore_active": false,
74
      "datastore_active": false,
            
75
      "datastore_contains_all_records_of_source_file": false,
75
      "datastore_contains_all_records_of_source_file": false,
            
76
      "datastore_status": "pending",
76
      "datastore_status": "pending",
            
77
      "description": "Lab results for the samples taken at the S1 
77
      "description": "Lab results for the samples taken at the S1 
            
78
sampling site on Columbia Lake since 2014. Dataset collected to better 
78
sampling site on Columbia Lake since 2014. Dataset collected to better 
            
79
understand health of Columbia lake and to communicate information to 
79
understand health of Columbia lake and to communicate information to 
            
80
decision makers for strategic planning for management strategies, as 
80
decision makers for strategic planning for management strategies, as 
            
81
well as to support our contributing partners for their future projects 
81
well as to support our contributing partners for their future projects 
            
82
and initiatives.",
82
and initiatives.",
            
83
      "format": "XLSX",
83
      "format": "XLSX",
            
84
      "hash": "3075c8ba278d39bdb04bff9aed991e3e",
84
      "hash": "3075c8ba278d39bdb04bff9aed991e3e",
            
85
      "header_row": "1",
85
      "header_row": "1",
            
86
      "id": "19a8c2b6-18b3-4f61-bb94-c84392f2b967",
86
      "id": "19a8c2b6-18b3-4f61-bb94-c84392f2b967",
            
87
      "last_modified": "2022-10-19T18:49:00.559840",
87
      "last_modified": "2022-10-19T18:49:00.559840",
            
t
88
      "load_status": "ERROR: Unable to find a usable engine; tried 
t
88
      "load_status": "Reading tabular file 
            
89
using: 'sqlalchemy'.\nA suitable version of sqlalchemy is required for 
89
clss_waterquality_s1_20140420_20210903.xlsx (xlsx)",
            
90
sql I/O support.\nTrying to import the above resulted in these 

            
91
errors:\n - Pandas requires version '1.4.16' or newer of 'sqlalchemy' 

            
92
(version '1.3.5' currently installed).",

            
93
      "metadata_modified": "2022-11-23T18:00:58.464520",
90
      "metadata_modified": "2022-11-23T18:00:58.715943",
            
94
      "mimetype": 
91
      "mimetype": 
            
95
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
92
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
            
96
      "mimetype_inner": null,
93
      "mimetype_inner": null,
            
97
      "name": "Water Quality (2014-04-20 to 2021-09-03) Columbia Lake 
94
      "name": "Water Quality (2014-04-20 to 2021-09-03) Columbia Lake 
            
98
(S1)",
95
(S1)",
            
99
      "package_id": "649af27c-27f4-4864-bd7a-ca8236ce462c",
96
      "package_id": "649af27c-27f4-4864-bd7a-ca8236ce462c",
            
100
      "position": 0,
97
      "position": 0,
            
101
      "recent_qa_date": "2022-10-01",
98
      "recent_qa_date": "2022-10-01",
            
102
      "resource_citation": "CLSS. (2022). Water Quality (2014-04-20 to 
99
      "resource_citation": "CLSS. (2022). Water Quality (2014-04-20 to 
            
103
2021-09-03) Columbia Lake (S1) [Resource]. Columbia Basin Water Hub. 
100
2021-09-03) Columbia Lake (S1) [Resource]. Columbia Basin Water Hub. 
            
104
https://doi.org/10.48511/V4X5-NS17",
101
https://doi.org/10.48511/V4X5-NS17",
            
105
      "resource_data_disclaimer": "No warranty or guarantee exists 
102
      "resource_data_disclaimer": "No warranty or guarantee exists 
            
106
that the information is accurate, complete, current, or suitable for 
103
that the information is accurate, complete, current, or suitable for 
            
107
any purpose. The individual user must confirm the accuracy of the data 
104
any purpose. The individual user must confirm the accuracy of the data 
            
108
and whether it will be appropriate for their purpose themselves.",
105
and whether it will be appropriate for their purpose themselves.",
            
109
      "resource_location": "Middle of Columbia Lake, near Spirits 
106
      "resource_location": "Middle of Columbia Lake, near Spirits 
            
110
Reach.",
107
Reach.",
            
111
      "resource_type": null,
108
      "resource_type": null,
            
112
      "size": 221903,
109
      "size": 221903,
            
113
      "state": "active",
110
      "state": "active",
            
114
      "url": 
111
      "url": 
            
115
94-c84392f2b967/download/clss_waterquality_s1_20140420_20210903.xlsx",
112
94-c84392f2b967/download/clss_waterquality_s1_20140420_20210903.xlsx",
            
116
      "url_type": "upload",
113
      "url_type": "upload",
            
117
      "waterhub_grade": "Community Research Grade"
114
      "waterhub_grade": "Community Research Grade"
            
118
    },
115
    },
            
119
    {
116
    {
            
120
      "cache_last_updated": null,
117
      "cache_last_updated": null,
            
121
      "cache_url": null,
118
      "cache_url": null,
            
122
      "created": "2022-10-19T18:52:21.583976",
119
      "created": "2022-10-19T18:52:21.583976",
            
123
      "data_collection_info": "Data collected by summer student and 
120
      "data_collection_info": "Data collected by summer student and 
            
124
program coordinator with the help of volunteers. Data collected using 
121
program coordinator with the help of volunteers. Data collected using 
            
125
turbidimeter, pH probe, dissolved oxygen probe, specific conductivity 
122
turbidimeter, pH probe, dissolved oxygen probe, specific conductivity 
            
126
probe, thermometer, secchi disk.",
123
probe, thermometer, secchi disk.",
            
127
      "data_processing": "The Water Hub has performed a preliminary 
124
      "data_processing": "The Water Hub has performed a preliminary 
            
128
QA/QC protocol on this data but the individual user must still confirm 
125
QA/QC protocol on this data but the individual user must still confirm 
            
129
the accuracy of the data and whether it will be appropriate for their 
126
the accuracy of the data and whether it will be appropriate for their 
            
130
purpose.",
127
purpose.",
            
131
      "datastore_active": false,
128
      "datastore_active": false,
            
132
      "datastore_contains_all_records_of_source_file": false,
129
      "datastore_contains_all_records_of_source_file": false,
            
133
      "datastore_status": "",
130
      "datastore_status": "",
            
134
      "description": "Water quality data from the middle of Columbia 
131
      "description": "Water quality data from the middle of Columbia 
            
135
Lake near Spirits Reach.",
132
Lake near Spirits Reach.",
            
136
      "format": "XLSX",
133
      "format": "XLSX",
            
137
      "hash": "92367db73e7e0be2cb0606ff2cd6463b",
134
      "hash": "92367db73e7e0be2cb0606ff2cd6463b",
            
138
      "header_row": "1",
135
      "header_row": "1",
            
139
      "id": "14c8becf-7e66-4909-af56-518fe04180f9",
136
      "id": "14c8becf-7e66-4909-af56-518fe04180f9",
            
140
      "last_modified": "2022-10-19T18:52:21.560240",
137
      "last_modified": "2022-10-19T18:52:21.560240",
            
141
      "load_status": "ERROR: Unable to find a usable engine; tried 
138
      "load_status": "ERROR: Unable to find a usable engine; tried 
            
142
using: 'sqlalchemy'.\nA suitable version of sqlalchemy is required for 
139
using: 'sqlalchemy'.\nA suitable version of sqlalchemy is required for 
            
143
sql I/O support.\nTrying to import the above resulted in these 
140
sql I/O support.\nTrying to import the above resulted in these 
            
144
errors:\n - Pandas requires version '1.4.16' or newer of 'sqlalchemy' 
141
errors:\n - Pandas requires version '1.4.16' or newer of 'sqlalchemy' 
            
145
(version '1.3.5' currently installed).",
142
(version '1.3.5' currently installed).",
            
146
      "metadata_modified": "2022-11-23T18:00:49.890893",
143
      "metadata_modified": "2022-11-23T18:00:49.890893",
            
147
      "mimetype": 
144
      "mimetype": 
            
148
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
145
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
            
149
      "mimetype_inner": null,
146
      "mimetype_inner": null,
            
150
      "name": "Field Water Quality (2014-04-20 to 2022-05-27) Columbia 
147
      "name": "Field Water Quality (2014-04-20 to 2022-05-27) Columbia 
            
151
Lake (S1)",
148
Lake (S1)",
            
152
      "package_id": "649af27c-27f4-4864-bd7a-ca8236ce462c",
149
      "package_id": "649af27c-27f4-4864-bd7a-ca8236ce462c",
            
153
      "position": 1,
150
      "position": 1,
            
154
      "recent_qa_date": "2022-10-01",
151
      "recent_qa_date": "2022-10-01",
            
155
      "resource_citation": "CLSS. (2022). Field Water Quality 
152
      "resource_citation": "CLSS. (2022). Field Water Quality 
            
156
(2014-04-20 to 2022-05-27) Columbia Lake (S1) [Resource]. Columbia 
153
(2014-04-20 to 2022-05-27) Columbia Lake (S1) [Resource]. Columbia 
            
157
Basin Water Hub. DOI",
154
Basin Water Hub. DOI",
            
158
      "resource_data_disclaimer": "No warranty or guarantee exists 
155
      "resource_data_disclaimer": "No warranty or guarantee exists 
            
159
that the information is accurate, complete, current, or suitable for 
156
that the information is accurate, complete, current, or suitable for 
            
160
any purpose. The individual user must confirm the accuracy of the data 
157
any purpose. The individual user must confirm the accuracy of the data 
            
161
and whether it will be appropriate for their purpose themselves.",
158
and whether it will be appropriate for their purpose themselves.",
            
162
      "resource_location": "Middle of Columbia Lake near Spirits 
159
      "resource_location": "Middle of Columbia Lake near Spirits 
            
163
Reach",
160
Reach",
            
164
      "resource_type": null,
161
      "resource_type": null,
            
165
      "size": 89338,
162
      "size": 89338,
            
166
      "state": "active",
163
      "state": "active",
            
167
      "url": 
164
      "url": 
            
168
8fe04180f9/download/clss_fieldwaterquality_s1_20140420_20220527.xlsx",
165
8fe04180f9/download/clss_fieldwaterquality_s1_20140420_20220527.xlsx",
            
169
      "url_type": "upload",
166
      "url_type": "upload",
            
170
      "waterhub_grade": "Community Research Grade"
167
      "waterhub_grade": "Community Research Grade"
            
171
    }
168
    }
            
172
  ],
169
  ],
            
173
  "start_date": "2014-04-20",
170
  "start_date": "2014-04-20",
            
174
  "state": "active",
171
  "state": "active",
            
175
  "tags": [
172
  "tags": [
            
176
    {
173
    {
            
177
      "display_name": "Community Research Grade",
174
      "display_name": "Community Research Grade",
            
178
      "id": "1f0dafbc-c76f-4b7c-9200-880b759fe7f4",
175
      "id": "1f0dafbc-c76f-4b7c-9200-880b759fe7f4",
            
179
      "name": "Community Research Grade",
176
      "name": "Community Research Grade",
            
180
      "state": "active",
177
      "state": "active",
            
181
      "vocabulary_id": null
178
      "vocabulary_id": null
            
182
    },
179
    },
            
183
    {
180
    {
            
184
      "display_name": "Community-based monitoring",
181
      "display_name": "Community-based monitoring",
            
185
      "id": "9b75240a-5e54-43c9-9063-969983d065f6",
182
      "id": "9b75240a-5e54-43c9-9063-969983d065f6",
            
186
      "name": "Community-based monitoring",
183
      "name": "Community-based monitoring",
            
187
      "state": "active",
184
      "state": "active",
            
188
      "vocabulary_id": null
185
      "vocabulary_id": null
            
189
    },
186
    },
            
190
    {
187
    {
            
191
      "display_name": "Field Water Quality",
188
      "display_name": "Field Water Quality",
            
192
      "id": "f7ccfe9a-95ee-462f-8503-44ae52c0802e",
189
      "id": "f7ccfe9a-95ee-462f-8503-44ae52c0802e",
            
193
      "name": "Field Water Quality",
190
      "name": "Field Water Quality",
            
194
      "state": "active",
191
      "state": "active",
            
195
      "vocabulary_id": null
192
      "vocabulary_id": null
            
196
    },
193
    },
            
197
    {
194
    {
            
198
      "display_name": "Lab Water Quality",
195
      "display_name": "Lab Water Quality",
            
199
      "id": "5a36f422-9cf9-481b-810d-9f697259b26c",
196
      "id": "5a36f422-9cf9-481b-810d-9f697259b26c",
            
200
      "name": "Lab Water Quality",
197
      "name": "Lab Water Quality",
            
201
      "state": "active",
198
      "state": "active",
            
202
      "vocabulary_id": null
199
      "vocabulary_id": null
            
203
    },
200
    },
            
204
    {
201
    {
            
205
      "display_name": "Lake",
202
      "display_name": "Lake",
            
206
      "id": "66dc1292-41ac-45cf-a267-f0d5c8a31826",
203
      "id": "66dc1292-41ac-45cf-a267-f0d5c8a31826",
            
207
      "name": "Lake",
204
      "name": "Lake",
            
208
      "state": "active",
205
      "state": "active",
            
209
      "vocabulary_id": null
206
      "vocabulary_id": null
            
210
    }
207
    }
            
211
  ],
208
  ],
            
212
  "title": "Columbia Lake (S1)",
209
  "title": "Columbia Lake (S1)",
            
213
  "type": "dataset",
210
  "type": "dataset",
            
214
  "url": null,
211
  "url": null,
            
215
  "version": null
212
  "version": null
            
216
}
213
}