Changes
On March 19, 2022 at 6:24:17 PM UTC, lladmin:
-
Changed value of field
load_status
of resource Water Quality and Discharge (1996-06-14 to 2007-08-04) Bonanza Creek toERROR: (psycopg2.errors.InsufficientPrivilege) must be owner of table b58eb38f-f657-488b-8b00-6da0a74d041b [SQL: DROP TABLE "b58eb38f-f657-488b-8b00-6da0a74d041b"] (Background on this error at: http://sqlalche.me/e/f405)
(previouslyLoading 1338 rows to datastore
) in Bonanza Creek -
Removed the value of field
datastore_status
in resource Water Quality and Discharge (1996-06-14 to 2007-08-04) Bonanza Creek in Bonanza Creek
f | 1 | { | f | 1 | { |
2 | "author": null, | 2 | "author": null, | ||
3 | "author_email": null, | 3 | "author_email": null, | ||
4 | "citation": "Slocan Lake Stewardship Society. (2021). Bonanza Creek | 4 | "citation": "Slocan Lake Stewardship Society. (2021). Bonanza Creek | ||
5 | [Data set]. Columbia Basin Water Hub. | 5 | [Data set]. Columbia Basin Water Hub. | ||
6 | https://doi.org/10.48511/R91F-YN96", | 6 | https://doi.org/10.48511/R91F-YN96", | ||
7 | "creator": "Slocan Lake Stewardship Society", | 7 | "creator": "Slocan Lake Stewardship Society", | ||
8 | "creator_user_id": "f510817b-5df1-47a6-9a21-a22c9f1eaa77", | 8 | "creator_user_id": "f510817b-5df1-47a6-9a21-a22c9f1eaa77", | ||
9 | "data_disclaimer": "No warranty or guarantee exists that the | 9 | "data_disclaimer": "No warranty or guarantee exists that the | ||
10 | information is accurate, complete, current, or suitable for any | 10 | information is accurate, complete, current, or suitable for any | ||
11 | purpose. The individual user must confirm the accuracy of the data and | 11 | purpose. The individual user must confirm the accuracy of the data and | ||
12 | whether it will be appropriate for their purpose.", | 12 | whether it will be appropriate for their purpose.", | ||
13 | "data_type": "Stream", | 13 | "data_type": "Stream", | ||
14 | "end_date": "2007-08-04", | 14 | "end_date": "2007-08-04", | ||
15 | "funding_reference": "Forest Renewal BC Program", | 15 | "funding_reference": "Forest Renewal BC Program", | ||
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 Mid Columbia-Kootenay Hydrologic region ", | 19 | within the Mid Columbia-Kootenay Hydrologic region ", | ||
20 | "display_name": "Mid Columbia-Kootenay", | 20 | "display_name": "Mid Columbia-Kootenay", | ||
21 | "id": "f1292df6-8c73-419f-b3ce-9c7e831ca78d", | 21 | "id": "f1292df6-8c73-419f-b3ce-9c7e831ca78d", | ||
22 | "image_display_url": | 22 | "image_display_url": | ||
23 | terhub.ca/uploads/group/2021-03-03-004652.569487Mapfinalmidkoots.png", | 23 | terhub.ca/uploads/group/2021-03-03-004652.569487Mapfinalmidkoots.png", | ||
24 | "name": "mid-columbia-kootenay", | 24 | "name": "mid-columbia-kootenay", | ||
25 | "title": "Mid Columbia-Kootenay" | 25 | "title": "Mid Columbia-Kootenay" | ||
26 | } | 26 | } | ||
27 | ], | 27 | ], | ||
28 | "id": "97508619-8651-4c9f-9fe2-a8a759a364ce", | 28 | "id": "97508619-8651-4c9f-9fe2-a8a759a364ce", | ||
29 | "identifier": "10.48511/R91F-YN96", | 29 | "identifier": "10.48511/R91F-YN96", | ||
30 | "isopen": false, | 30 | "isopen": false, | ||
31 | "keywords": "Stream,Community-based monitoring,Water | 31 | "keywords": "Stream,Community-based monitoring,Water | ||
32 | temperature,Community Research Grade,Hydrometric,Water | 32 | temperature,Community Research Grade,Hydrometric,Water | ||
33 | Level,Discharge,Field Water Quality", | 33 | Level,Discharge,Field Water Quality", | ||
34 | "latitude": "50.09", | 34 | "latitude": "50.09", | ||
35 | "license_id": "CC-BY-SA-4.0", | 35 | "license_id": "CC-BY-SA-4.0", | ||
36 | "license_title": "CC-BY-SA-4.0", | 36 | "license_title": "CC-BY-SA-4.0", | ||
37 | "location": "Bonanza Creek at Gauge Site", | 37 | "location": "Bonanza Creek at Gauge Site", | ||
38 | "longitude": "-117.48", | 38 | "longitude": "-117.48", | ||
39 | "maintainer": null, | 39 | "maintainer": null, | ||
40 | "maintainer_email": "cbwaterhub@livinglakescanada.ca", | 40 | "maintainer_email": "cbwaterhub@livinglakescanada.ca", | ||
41 | "metadata_created": "2021-06-25T22:47:55.537608", | 41 | "metadata_created": "2021-06-25T22:47:55.537608", | ||
n | 42 | "metadata_modified": "2022-03-19T18:24:17.354553", | n | 42 | "metadata_modified": "2022-03-19T18:24:17.645756", |
43 | "name": "bonanza-creek", | 43 | "name": "bonanza-creek", | ||
44 | "notes": "Water monitoring at Bonanza Creek conducted by the Slocan | 44 | "notes": "Water monitoring at Bonanza Creek conducted by the Slocan | ||
45 | Lake Stewardship Society", | 45 | Lake Stewardship Society", | ||
46 | "num_resources": 1, | 46 | "num_resources": 1, | ||
47 | "num_tags": 8, | 47 | "num_tags": 8, | ||
48 | "organization": { | 48 | "organization": { | ||
49 | "approval_status": "approved", | 49 | "approval_status": "approved", | ||
50 | "created": "2020-07-27T08:34:12.008932", | 50 | "created": "2020-07-27T08:34:12.008932", | ||
51 | "description": "The Slocan Lake Stewardship Society is dedicated | 51 | "description": "The Slocan Lake Stewardship Society is dedicated | ||
52 | to protecting the beauty, health and wonder of the magnificent Slocan | 52 | to protecting the beauty, health and wonder of the magnificent Slocan | ||
53 | Lake ecosystem for future generations. We do this by investing in | 53 | Lake ecosystem for future generations. We do this by investing in | ||
54 | science that helps us learn how Slocan Lake and its surrounding | 54 | science that helps us learn how Slocan Lake and its surrounding | ||
55 | ecosystems function, and what needs to be done to keep the system | 55 | ecosystems function, and what needs to be done to keep the system | ||
56 | healthy; by developing useful, credible and accessible information | 56 | healthy; by developing useful, credible and accessible information | ||
57 | that is publicly shared; and by working cooperatively with local | 57 | that is publicly shared; and by working cooperatively with local | ||
58 | communities and governments to set priorities for managing Slocan Lake | 58 | communities and governments to set priorities for managing Slocan Lake | ||
59 | and its environs in a manner that fosters collective responsibility. | 59 | and its environs in a manner that fosters collective responsibility. | ||
60 | ", | 60 | ", | ||
61 | "id": "8de81e1c-786f-4548-88e1-25129507cdf3", | 61 | "id": "8de81e1c-786f-4548-88e1-25129507cdf3", | ||
62 | "image_url": | 62 | "image_url": | ||
63 | "2021-02-25-212716.467546Slocan-Lake-Stewardship-Society.png", | 63 | "2021-02-25-212716.467546Slocan-Lake-Stewardship-Society.png", | ||
64 | "is_organization": true, | 64 | "is_organization": true, | ||
65 | "name": "slocan-lake-stewardship-society", | 65 | "name": "slocan-lake-stewardship-society", | ||
66 | "state": "active", | 66 | "state": "active", | ||
67 | "title": "Slocan Lake Stewardship Society", | 67 | "title": "Slocan Lake Stewardship Society", | ||
68 | "type": "organization" | 68 | "type": "organization" | ||
69 | }, | 69 | }, | ||
70 | "other_sources": "N/A", | 70 | "other_sources": "N/A", | ||
71 | "owner_org": "8de81e1c-786f-4548-88e1-25129507cdf3", | 71 | "owner_org": "8de81e1c-786f-4548-88e1-25129507cdf3", | ||
72 | "private": false, | 72 | "private": false, | ||
73 | "publication_year": "2021", | 73 | "publication_year": "2021", | ||
74 | "relationships_as_object": [], | 74 | "relationships_as_object": [], | ||
75 | "relationships_as_subject": [], | 75 | "relationships_as_subject": [], | ||
76 | "resources": [ | 76 | "resources": [ | ||
77 | { | 77 | { | ||
78 | "cache_last_updated": null, | 78 | "cache_last_updated": null, | ||
79 | "cache_url": null, | 79 | "cache_url": null, | ||
80 | "created": "2021-06-25T22:49:06.711804", | 80 | "created": "2021-06-25T22:49:06.711804", | ||
81 | "data_collection_info": "N/A", | 81 | "data_collection_info": "N/A", | ||
82 | "data_processing": "The Water Hub has performed a preliminary | 82 | "data_processing": "The Water Hub has performed a preliminary | ||
83 | QA/QC protocol on this data but the individual user must still confirm | 83 | QA/QC protocol on this data but the individual user must still confirm | ||
84 | the accuracy of the data and whether it will be appropriate for their | 84 | the accuracy of the data and whether it will be appropriate for their | ||
85 | purpose.\r\n", | 85 | purpose.\r\n", | ||
86 | "datastore_active": false, | 86 | "datastore_active": false, | ||
n | 87 | "datastore_status": "pending", | n | 87 | "datastore_status": "", |
88 | "description": "Field water quality, gauge level, discharge | 88 | "description": "Field water quality, gauge level, discharge | ||
89 | measurements and weather for Bonanza Creek. Data was collected at | 89 | measurements and weather for Bonanza Creek. Data was collected at | ||
90 | intervals ranging from daily to weekly during the field season. \r\nBC | 90 | intervals ranging from daily to weekly during the field season. \r\nBC | ||
91 | EMS Site E248959", | 91 | EMS Site E248959", | ||
92 | "format": "XLSX", | 92 | "format": "XLSX", | ||
93 | "hash": "a6f6ae7335991454565ffa167904ffa0", | 93 | "hash": "a6f6ae7335991454565ffa167904ffa0", | ||
94 | "header_row": "1", | 94 | "header_row": "1", | ||
95 | "id": "b58eb38f-f657-488b-8b00-6da0a74d041b", | 95 | "id": "b58eb38f-f657-488b-8b00-6da0a74d041b", | ||
96 | "last_modified": "2022-03-19T18:24:12.702399", | 96 | "last_modified": "2022-03-19T18:24:12.702399", | ||
t | 97 | "load_status": "Loading 1338 rows to datastore", | t | 97 | "load_status": "ERROR: (psycopg2.errors.InsufficientPrivilege) |
98 | must be owner of table b58eb38f-f657-488b-8b00-6da0a74d041b\n\n[SQL: | ||||
99 | \nDROP TABLE \"b58eb38f-f657-488b-8b00-6da0a74d041b\"]\n(Background on | ||||
100 | this error at: http://sqlalche.me/e/f405)", | ||||
98 | "metadata_modified": "2022-03-19T18:24:17.357404", | 101 | "metadata_modified": "2022-03-19T18:24:17.648825", | ||
99 | "mimetype": | 102 | "mimetype": | ||
100 | "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", | 103 | "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", | ||
101 | "mimetype_inner": null, | 104 | "mimetype_inner": null, | ||
102 | "name": "Water Quality and Discharge (1996-06-14 to 2007-08-04) | 105 | "name": "Water Quality and Discharge (1996-06-14 to 2007-08-04) | ||
103 | Bonanza Creek ", | 106 | Bonanza Creek ", | ||
104 | "package_id": "97508619-8651-4c9f-9fe2-a8a759a364ce", | 107 | "package_id": "97508619-8651-4c9f-9fe2-a8a759a364ce", | ||
105 | "position": 0, | 108 | "position": 0, | ||
106 | "resource_citation": "Slocan Lake Stewardship Society. (2021). | 109 | "resource_citation": "Slocan Lake Stewardship Society. (2021). | ||
107 | Water Quality and Discharge (1996-06-14 to 2007-08-04) Bonanza Creek. | 110 | Water Quality and Discharge (1996-06-14 to 2007-08-04) Bonanza Creek. | ||
108 | Columbia Basin Water Hub [Resource]. Slocan, BC. | 111 | Columbia Basin Water Hub [Resource]. Slocan, BC. | ||
109 | https://doi.org/10.48511/R91F-YN96", | 112 | https://doi.org/10.48511/R91F-YN96", | ||
110 | "resource_data_disclaimer": "No warranty or guarantee exists | 113 | "resource_data_disclaimer": "No warranty or guarantee exists | ||
111 | that the information is accurate, complete, current, or suitable for | 114 | that the information is accurate, complete, current, or suitable for | ||
112 | any purpose. Insufficient metadata is available to assess the quality | 115 | any purpose. Insufficient metadata is available to assess the quality | ||
113 | of this data. Instrument accuracy may be limited. A calibration record | 116 | of this data. Instrument accuracy may be limited. A calibration record | ||
114 | has not been provided for the instruments used to collect this data. | 117 | has not been provided for the instruments used to collect this data. | ||
115 | The individual user must confirm the accuracy of the data and whether | 118 | The individual user must confirm the accuracy of the data and whether | ||
116 | it will be appropriate for their purpose.", | 119 | it will be appropriate for their purpose.", | ||
117 | "resource_location": "Bonanza Creek at Gauge Site", | 120 | "resource_location": "Bonanza Creek at Gauge Site", | ||
118 | "resource_type": null, | 121 | "resource_type": null, | ||
119 | "size": 545979, | 122 | "size": 545979, | ||
120 | "state": "active", | 123 | "state": "active", | ||
121 | "url": | 124 | "url": | ||
122 | a0a74d041b/download/slss_waterquality_bonanza_19960614_20070804.xlsx", | 125 | a0a74d041b/download/slss_waterquality_bonanza_19960614_20070804.xlsx", | ||
123 | "url_type": "upload", | 126 | "url_type": "upload", | ||
124 | "waterhub_certified": "Certified", | 127 | "waterhub_certified": "Certified", | ||
125 | "waterhub_grade": "Community Research Grade" | 128 | "waterhub_grade": "Community Research Grade" | ||
126 | } | 129 | } | ||
127 | ], | 130 | ], | ||
128 | "start_date": "1996-06-14", | 131 | "start_date": "1996-06-14", | ||
129 | "state": "active", | 132 | "state": "active", | ||
130 | "tags": [ | 133 | "tags": [ | ||
131 | { | 134 | { | ||
132 | "display_name": "Community Research Grade", | 135 | "display_name": "Community Research Grade", | ||
133 | "id": "1f0dafbc-c76f-4b7c-9200-880b759fe7f4", | 136 | "id": "1f0dafbc-c76f-4b7c-9200-880b759fe7f4", | ||
134 | "name": "Community Research Grade", | 137 | "name": "Community Research Grade", | ||
135 | "state": "active", | 138 | "state": "active", | ||
136 | "vocabulary_id": null | 139 | "vocabulary_id": null | ||
137 | }, | 140 | }, | ||
138 | { | 141 | { | ||
139 | "display_name": "Community-based monitoring", | 142 | "display_name": "Community-based monitoring", | ||
140 | "id": "9b75240a-5e54-43c9-9063-969983d065f6", | 143 | "id": "9b75240a-5e54-43c9-9063-969983d065f6", | ||
141 | "name": "Community-based monitoring", | 144 | "name": "Community-based monitoring", | ||
142 | "state": "active", | 145 | "state": "active", | ||
143 | "vocabulary_id": null | 146 | "vocabulary_id": null | ||
144 | }, | 147 | }, | ||
145 | { | 148 | { | ||
146 | "display_name": "Discharge", | 149 | "display_name": "Discharge", | ||
147 | "id": "cc9b1548-2fa3-4feb-9048-758b564187f9", | 150 | "id": "cc9b1548-2fa3-4feb-9048-758b564187f9", | ||
148 | "name": "Discharge", | 151 | "name": "Discharge", | ||
149 | "state": "active", | 152 | "state": "active", | ||
150 | "vocabulary_id": null | 153 | "vocabulary_id": null | ||
151 | }, | 154 | }, | ||
152 | { | 155 | { | ||
153 | "display_name": "Field Water Quality", | 156 | "display_name": "Field Water Quality", | ||
154 | "id": "f7ccfe9a-95ee-462f-8503-44ae52c0802e", | 157 | "id": "f7ccfe9a-95ee-462f-8503-44ae52c0802e", | ||
155 | "name": "Field Water Quality", | 158 | "name": "Field Water Quality", | ||
156 | "state": "active", | 159 | "state": "active", | ||
157 | "vocabulary_id": null | 160 | "vocabulary_id": null | ||
158 | }, | 161 | }, | ||
159 | { | 162 | { | ||
160 | "display_name": "Hydrometric", | 163 | "display_name": "Hydrometric", | ||
161 | "id": "ae588e2d-8628-4e7f-ad0a-2cbd38adfd76", | 164 | "id": "ae588e2d-8628-4e7f-ad0a-2cbd38adfd76", | ||
162 | "name": "Hydrometric", | 165 | "name": "Hydrometric", | ||
163 | "state": "active", | 166 | "state": "active", | ||
164 | "vocabulary_id": null | 167 | "vocabulary_id": null | ||
165 | }, | 168 | }, | ||
166 | { | 169 | { | ||
167 | "display_name": "Stream", | 170 | "display_name": "Stream", | ||
168 | "id": "208421f0-ebb5-4b32-8111-2ff156803d73", | 171 | "id": "208421f0-ebb5-4b32-8111-2ff156803d73", | ||
169 | "name": "Stream", | 172 | "name": "Stream", | ||
170 | "state": "active", | 173 | "state": "active", | ||
171 | "vocabulary_id": null | 174 | "vocabulary_id": null | ||
172 | }, | 175 | }, | ||
173 | { | 176 | { | ||
174 | "display_name": "Water Level", | 177 | "display_name": "Water Level", | ||
175 | "id": "3100ac20-0d39-473c-bd6c-5be66ff76041", | 178 | "id": "3100ac20-0d39-473c-bd6c-5be66ff76041", | ||
176 | "name": "Water Level", | 179 | "name": "Water Level", | ||
177 | "state": "active", | 180 | "state": "active", | ||
178 | "vocabulary_id": null | 181 | "vocabulary_id": null | ||
179 | }, | 182 | }, | ||
180 | { | 183 | { | ||
181 | "display_name": "Water temperature", | 184 | "display_name": "Water temperature", | ||
182 | "id": "0770347d-73eb-4f60-a661-50199f7049c3", | 185 | "id": "0770347d-73eb-4f60-a661-50199f7049c3", | ||
183 | "name": "Water temperature", | 186 | "name": "Water temperature", | ||
184 | "state": "active", | 187 | "state": "active", | ||
185 | "vocabulary_id": null | 188 | "vocabulary_id": null | ||
186 | } | 189 | } | ||
187 | ], | 190 | ], | ||
188 | "title": "Bonanza Creek", | 191 | "title": "Bonanza Creek", | ||
189 | "type": "dataset", | 192 | "type": "dataset", | ||
190 | "url": null, | 193 | "url": null, | ||
191 | "version": null | 194 | "version": null | ||
192 | } | 195 | } |