Item talk:Q61433
From geokb
{
"USGS Publications Warehouse": {
"schema": {
"@context": "https://schema.org",
"@type": "CreativeWork",
"additionalType": "USGS Numbered Series",
"name": "Development of a database-driven system for simulating water temperature in the lower Yakima River main stem, Washington, for various climate scenarios",
"identifier": [
{
"@type": "PropertyValue",
"propertyID": "USGS Publications Warehouse IndexID",
"value": "ofr20131010",
"url": "https://pubs.usgs.gov/publication/ofr20131010"
},
{
"@type": "PropertyValue",
"propertyID": "USGS Publications Warehouse Internal ID",
"value": 70042825
},
{
"@type": "PropertyValue",
"propertyID": "DOI",
"value": "10.3133/ofr20131010",
"url": "https://doi.org/10.3133/ofr20131010"
}
],
"inLanguage": "en",
"isPartOf": [
{
"@type": "CreativeWorkSeries",
"name": "Open-File Report"
}
],
"datePublished": "2013",
"dateModified": "2013-01-24",
"abstract": "A model for simulating daily maximum and mean water temperatures was developed by linking two existing models: one developed by the U.S. Geological Survey and one developed by the Bureau of Reclamation. The study area included the lower Yakima River main stem between the Roza Dam and West Richland, Washington. To automate execution of the labor-intensive models, a database-driven model automation program was developed to decrease operation costs, to reduce user error, and to provide the capability to perform simulations quickly for multiple management and climate change scenarios. Microsoft\u00a9 SQL Server 2008 R2 Integration Services packages were developed to (1) integrate climate, flow, and stream geometry data from diverse sources (such as weather stations, a hydrologic model, and field measurements) into a single relational database; (2) programmatically generate heavily formatted model input files; (3) iteratively run water temperature simulations; (4) process simulation results for export to other models; and (5) create a database-driven infrastructure that facilitated experimentation with a variety of scenarios, node permutations, weather data, and hydrologic conditions while minimizing costs of running the model with various model configurations. As a proof-of-concept exercise, water temperatures were simulated for a \"Current Conditions\" scenario, where local weather data from 1980 through 2005 were used as input, and for \"Plus 1\" and \"Plus 2\" climate warming scenarios, where the average annual air temperatures used in the Current Conditions scenario were increased by 1degree Celsius (\u00b0C) and by 2\u00b0C, respectively. Average monthly mean daily water temperatures simulated for the Current Conditions scenario were compared to measured values at the Bureau of Reclamation Hydromet gage at Kiona, Washington, for 2002-05. Differences ranged between 1.9\u00b0 and 1.1\u00b0C for February, March, May, and June, and were less than 0.8\u00b0C for the remaining months of the year. The difference between current conditions and measured monthly values for the two warmest months (July and August) were 0.5\u00b0C and 0.2\u00b0C, respectively. The model predicted that water temperature generally becomes less sensitive to air temperature increases as the distance from the mouth of the river decreases. As a consequence, the difference between climate warming scenarios also decreased. The pattern of decreasing sensitivity is most pronounced from August to October. Interactive graphing tools were developed to explore the relative sensitivity of average monthly and mean daily water temperature to increases in air temperature for model output locations along the lower Yakima River main stem.",
"description": "iv, 20 p.",
"publisher": {
"@type": "Organization",
"name": "U.S. Geological Survey"
},
"author": [
{
"@type": "Person",
"name": "Maule, Alec",
"givenName": "Alec",
"familyName": "Maule"
},
{
"@type": "Person",
"name": "Voss, Frank",
"givenName": "Frank",
"familyName": "Voss"
}
],
"funder": [
{
"@type": "Organization",
"name": "Washington Water Science Center",
"url": "https://www.usgs.gov/centers/washington-water-science-center"
}
],
"spatialCoverage": [
{
"@type": "Place",
"additionalType": "country",
"name": "United States",
"url": "https://geonames.org/4074035"
},
{
"@type": "Place",
"additionalType": "state",
"name": "Washington"
},
{
"@type": "Place",
"additionalType": "unknown",
"name": "Yakima River",
"url": "https://geonames.org/5816604"
},
{
"@type": "Place",
"geo": [
{
"@type": "GeoShape",
"additionalProperty": {
"@type": "PropertyValue",
"name": "GeoJSON",
"value": {
"type": "FeatureCollection",
"features": [
{
"type": "Feature",
"properties": {},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-120.67,
46.0
],
[
-120.67,
47.0
],
[
-119.0,
47.0
],
[
-119.0,
46.0
],
[
-120.67,
46.0
]
]
]
}
}
]
}
}
},
{
"@type": "GeoCoordinates",
"latitude": 46.49999999999999,
"longitude": -119.83500000000001
}
]
}
]
}
},
"OpenAlex": {
"abstract_inverted_index": {
"A": [
0
],
"model": [
1,
59,
130,
175,
178,
313,
383
],
"for": [
2,
81,
143,
188,
206,
244,
264,
272,
283,
299,
382
],
"simulating": [
3
],
"daily": [
4,
240,
374
],
"maximum": [
5
],
"and": [
6,
24,
46,
72,
84,
103,
117,
148,
166,
205,
209,
233,
270,
276,
278,
295,
305,
309,
372
],
"mean": [
7,
239,
373
],
"water": [
8,
136,
184,
241,
316,
375
],
"temperatures": [
9,
185,
220,
242
],
"was": [
10,
62
],
"developed": [
11,
18,
26,
63,
97,
363
],
"by": [
12,
19,
27,
229,
234
],
"linking": [
13
],
"two": [
14,
301
],
"existing": [
15
],
"models:": [
16
],
"one": [
17,
25
],
"the": [
20,
28,
36,
43,
54,
75,
174,
216,
223,
245,
255,
284,
288,
300,
327,
330,
333,
339,
366,
387
],
"U.S.": [
21
],
"Geological": [
22
],
"Survey": [
23
],
"Bureau": [
29,
256
],
"of": [
30,
53,
160,
172,
257,
287,
332,
349,
369
],
"Reclamation.": [
31
],
"The": [
32,
290,
312,
347
],
"study": [
33
],
"area": [
34
],
"included": [
35
],
"lower": [
37,
388
],
"Yakima": [
38,
389
],
"River": [
39,
390
],
"main": [
40,
391
],
"stem": [
41
],
"between": [
42,
268,
292,
341
],
"Roza": [
44
],
"Dam": [
45
],
"West": [
47
],
"Richland,": [
48
],
"Washington.": [
49
],
"To": [
50
],
"automate": [
51
],
"execution": [
52
],
"labor-intensive": [
55
],
"models,": [
56
],
"a": [
57,
114,
121,
151,
158,
181,
189,
337
],
"database-driven": [
58,
152
],
"automation": [
60
],
"program": [
61
],
"to": [
64,
68,
73,
77,
98,
145,
251,
322,
357,
364,
377
],
"decrease": [
65
],
"operation": [
66
],
"costs,": [
67
],
"reduce": [
69
],
"user": [
70
],
"error,": [
71
],
"provide": [
74
],
"capability": [
76
],
"perform": [
78
],
"simulations": [
79
],
"quickly": [
80
],
"multiple": [
82
],
"management": [
83
],
"climate": [
85,
212,
342
],
"change": [
86
],
"scenarios.": [
87
],
"Microsoft\u00a9": [
88
],
"SQL": [
89
],
"Server": [
90
],
"2008": [
91
],
"R2": [
92
],
"Integration": [
93
],
"Services": [
94
],
"packages": [
95
],
"were": [
96,
186,
201,
227,
249,
279,
307,
362
],
"(1)": [
99
],
"integrate": [
100
],
"climate,": [
101
],
"flow,": [
102
],
"stream": [
104
],
"geometry": [
105
],
"data": [
106,
196
],
"from": [
107,
197,
329,
355
],
"diverse": [
108
],
"sources": [
109
],
"(such": [
110
],
"as": [
111,
203,
326
],
"weather": [
112,
164,
195
],
"stations,": [
113
],
"hydrologic": [
115,
167
],
"model,": [
116
],
"field": [
118
],
"measurements)": [
119
],
"into": [
120
],
"single": [
122
],
"relational": [
123
],
"database;": [
124
],
"(2)": [
125
],
"programmatically": [
126
],
"generate": [
127
],
"heavily": [
128
],
"formatted": [
129
],
"input": [
131
],
"files;": [
132
],
"(3)": [
133
],
"iteratively": [
134
],
"run": [
135
],
"temperature": [
137,
317,
324,
376,
381
],
"simulations;": [
138
],
"(4)": [
139
],
"process": [
140
],
"simulation": [
141
],
"results": [
142
],
"export": [
144
],
"other": [
146
],
"models;": [
147
],
"(5)": [
149
],
"create": [
150
],
"infrastructure": [
153
],
"that": [
154,
315
],
"facilitated": [
155
],
"experimentation": [
156
],
"with": [
157,
176
],
"variety": [
159
],
"scenarios,": [
161,
214
],
"node": [
162
],
"permutations,": [
163
],
"data,": [
165
],
"conditions": [
168,
294
],
"while": [
169
],
"minimizing": [
170
],
"costs": [
171
],
"running": [
173
],
"various": [
177
],
"configurations.": [
179
],
"As": [
180,
336
],
"proof-of-concept": [
182
],
"exercise,": [
183
],
"simulated": [
187,
243
],
"\"Current": [
190
],
"Conditions\"": [
191
],
"scenario,": [
192
],
"where": [
193,
215
],
"local": [
194
],
"1980": [
198
],
"through": [
199
],
"2005": [
200
],
"used": [
202,
221
],
"input,": [
204
],
"\"Plus": [
207,
210
],
"1\"": [
208
],
"2\"": [
211
],
"warming": [
213,
343
],
"average": [
217,
370
],
"annual": [
218
],
"air": [
219,
323,
380
],
"in": [
222,
379
],
"Current": [
224,
246
],
"Conditions": [
225,
247
],
"scenario": [
226,
248
],
"increased": [
228
],
"1degree": [
230
],
"Celsius": [
231
],
"(\u00b0C)": [
232
],
"2\u00b0C,": [
235
],
"respectively.": [
236,
311
],
"Average": [
237
],
"monthly": [
238,
297,
371
],
"compared": [
250
],
"measured": [
252,
296
],
"values": [
253,
298
],
"at": [
254,
261
],
"Reclamation": [
258
],
"Hydromet": [
259
],
"gage": [
260
],
"Kiona,": [
262
],
"Washington,": [
263
],
"2002-05.": [
265
],
"Differences": [
266
],
"ranged": [
267
],
"1.9\u00b0": [
269
],
"1.1\u00b0C": [
271
],
"February,": [
273
],
"March,": [
274
],
"May,": [
275
],
"June,": [
277
],
"less": [
280,
320
],
"than": [
281
],
"0.8\u00b0C": [
282
],
"remaining": [
285
],
"months": [
286,
303
],
"year.": [
289
],
"difference": [
291,
340
],
"current": [
293
],
"warmest": [
302
],
"(July": [
304
],
"August)": [
306
],
"0.5\u00b0C": [
308
],
"0.2\u00b0C,": [
310
],
"predicted": [
314
],
"generally": [
318
],
"becomes": [
319
],
"sensitive": [
321
],
"increases": [
325,
378
],
"distance": [
328
],
"mouth": [
331
],
"river": [
334
],
"decreases.": [
335
],
"consequence,": [
338
],
"scenarios": [
344
],
"also": [
345
],
"decreased.": [
346
],
"pattern": [
348
],
"decreasing": [
350
],
"sensitivity": [
351,
368
],
"is": [
352
],
"most": [
353
],
"pronounced": [
354
],
"August": [
356
],
"October.": [
358
],
"Interactive": [
359
],
"graphing": [
360
],
"tools": [
361
],
"explore": [
365
],
"relative": [
367
],
"output": [
384
],
"locations": [
385
],
"along": [
386
],
"stem.": [
392
]
},
"apc_list": null,
"apc_paid": null,
"authorships": [
{
"author_position": "first",
"author": {
"id": "https://openalex.org/A5074768458",
"display_name": "Frank D. Voss",
"orcid": null
},
"institutions": [
{
"id": "https://openalex.org/I1286329397",
"display_name": "United States Geological Survey",
"ror": "https://ror.org/035a68863",
"country_code": "US",
"type": "government",
"lineage": [
"https://openalex.org/I1286329397",
"https://openalex.org/I1335927249"
]
}
],
"countries": [
"US"
],
"is_corresponding": false,
"raw_author_name": "Frank Voss",
"raw_affiliation_strings": [
"U.S. Geological Survey, Reston, Virginia",
"Washington Water Science Center U.S. Geological Survey 934 Broadway, Suite 300 Tacoma, Washington 98402"
],
"affiliations": [
{
"raw_affiliation_string": "Washington Water Science Center U.S. Geological Survey 934 Broadway, Suite 300 Tacoma, Washington 98402",
"institution_ids": []
},
{
"raw_affiliation_string": "U.S. Geological Survey, Reston, Virginia",
"institution_ids": [
"https://openalex.org/I1286329397"
]
}
]
},
{
"author_position": "last",
"author": {
"id": "https://openalex.org/A5075263924",
"display_name": "Alec G. Maule",
"orcid": null
},
"institutions": [
{
"id": "https://openalex.org/I1286329397",
"display_name": "United States Geological Survey",
"ror": "https://ror.org/035a68863",
"country_code": "US",
"type": "government",
"lineage": [
"https://openalex.org/I1286329397",
"https://openalex.org/I1335927249"
]
}
],
"countries": [
"US"
],
"is_corresponding": false,
"raw_author_name": "Alec Maule",
"raw_affiliation_strings": [
"U.S. Geological Survey, Reston, Virginia",
"Washington Water Science Center U.S. Geological Survey 934 Broadway, Suite 300 Tacoma, Washington 98402"
],
"affiliations": [
{
"raw_affiliation_string": "Washington Water Science Center U.S. Geological Survey 934 Broadway, Suite 300 Tacoma, Washington 98402",
"institution_ids": []
},
{
"raw_affiliation_string": "U.S. Geological Survey, Reston, Virginia",
"institution_ids": [
"https://openalex.org/I1286329397"
]
}
]
}
],
"best_oa_location": {
"is_oa": true,
"landing_page_url": "https://doi.org/10.3133/ofr20131010",
"pdf_url": "https://pubs.usgs.gov/of/2013/1010/pdf/ofr20131010.pdf",
"source": {
"id": "https://openalex.org/S4210194219",
"display_name": "Antarctica A Keystone in a Changing World",
"issn_l": "0196-1497",
"issn": [
"0196-1497",
"2331-1258",
"2332-4899"
],
"is_oa": true,
"is_in_doaj": false,
"is_core": true,
"host_organization": "https://openalex.org/P4310316088",
"host_organization_name": "United States Department of the Interior",
"host_organization_lineage": [
"https://openalex.org/P4310316088"
],
"host_organization_lineage_names": [
"United States Department of the Interior"
],
"type": "journal"
},
"license": null,
"license_id": null,
"version": "publishedVersion",
"is_accepted": true,
"is_published": true
},
"biblio": {
"volume": null,
"issue": null,
"first_page": null,
"last_page": null
},
"citation_normalized_percentile": {
"value": 0.577373,
"is_in_top_1_percent": false,
"is_in_top_10_percent": false
},
"cited_by_api_url": "https://api.openalex.org/works?filter=cites:W1483477784",
"cited_by_count": 2,
"cited_by_percentile_year": {
"min": 74,
"max": 78
},
"concepts": [
{
"id": "https://openalex.org/c77088390",
"wikidata": "https://www.wikidata.org/wiki/Q8513",
"display_name": "Database",
"level": 1,
"score": 0.6736767,
"qid": "Q165904"
},
{
"id": "https://openalex.org/c39432304",
"wikidata": "https://www.wikidata.org/wiki/Q188847",
"display_name": "Environmental science",
"level": 0,
"score": 0.6270167,
"qid": "Q166085"
},
{
"id": "https://openalex.org/c41008148",
"wikidata": "https://www.wikidata.org/wiki/Q21198",
"display_name": "Computer science",
"level": 0,
"score": 0.5099093,
"qid": "Q158969"
},
{
"id": "https://openalex.org/c132651083",
"wikidata": "https://www.wikidata.org/wiki/Q7942",
"display_name": "Climate change",
"level": 2,
"score": 0.48032466,
"qid": "Q169118"
},
{
"id": "https://openalex.org/c76886044",
"wikidata": "https://www.wikidata.org/wiki/Q2883300",
"display_name": "Hydrology (agriculture)",
"level": 2,
"score": 0.41039163,
"qid": "Q161210"
},
{
"id": "https://openalex.org/c153294291",
"wikidata": "https://www.wikidata.org/wiki/Q25261",
"display_name": "Meteorology",
"level": 1,
"score": 0.39534345,
"qid": "Q159006"
},
{
"id": "https://openalex.org/c127413603",
"wikidata": "https://www.wikidata.org/wiki/Q11023",
"display_name": "Engineering",
"level": 0,
"score": 0.12897435,
"qid": "Q158977"
},
{
"id": "https://openalex.org/c205649164",
"wikidata": "https://www.wikidata.org/wiki/Q1071",
"display_name": "Geography",
"level": 0,
"score": 0.09981564,
"qid": "Q158983"
},
{
"id": "https://openalex.org/c187320778",
"wikidata": "https://www.wikidata.org/wiki/Q1349130",
"display_name": "Geotechnical engineering",
"level": 1,
"score": 0.0,
"qid": "Q226247"
},
{
"id": "https://openalex.org/c86803240",
"wikidata": "https://www.wikidata.org/wiki/Q420",
"display_name": "Biology",
"level": 0,
"score": 0.0,
"qid": "Q158998"
},
{
"id": "https://openalex.org/c18903297",
"wikidata": "https://www.wikidata.org/wiki/Q7150",
"display_name": "Ecology",
"level": 1,
"score": 0.0,
"qid": "Q158972"
}
],
"corresponding_author_ids": [],
"corresponding_institution_ids": [],
"countries_distinct_count": 1,
"counts_by_year": [
{
"year": 2013,
"cited_by_count": 1
},
{
"year": 2012,
"cited_by_count": 1
}
],
"created_date": "2016-06-24",
"datasets": [],
"display_name": "Development of a database-driven system for simulating water temperature in the lower Yakima River main stem, Washington, for various climate scenarios",
"doi": "https://doi.org/10.3133/ofr20131010",
"fulltext_origin": "pdf",
"fwci": 0.346,
"grants": [],
"has_fulltext": true,
"id": "https://openalex.org/W1483477784",
"ids": {
"openalex": "https://openalex.org/W1483477784",
"doi": "https://doi.org/10.3133/ofr20131010",
"mag": "1483477784"
},
"indexed_in": [
"crossref"
],
"institutions_distinct_count": 1,
"is_paratext": false,
"is_retracted": false,
"keywords": [
{
"id": "https://openalex.org/keywords/watershed-simulation",
"display_name": "Watershed Simulation",
"score": 0.601727
},
{
"id": "https://openalex.org/keywords/groundwater-level-forecasting",
"display_name": "Groundwater Level Forecasting",
"score": 0.543543
},
{
"id": "https://openalex.org/keywords/rainfall-runoff-modeling",
"display_name": "Rainfall-Runoff Modeling",
"score": 0.541488
},
{
"id": "https://openalex.org/keywords/hydrological-modeling",
"display_name": "Hydrological Modeling",
"score": 0.509525
}
],
"language": "en",
"locations": [
{
"is_oa": true,
"landing_page_url": "https://doi.org/10.3133/ofr20131010",
"pdf_url": "https://pubs.usgs.gov/of/2013/1010/pdf/ofr20131010.pdf",
"source": {
"id": "https://openalex.org/S4210194219",
"display_name": "Antarctica A Keystone in a Changing World",
"issn_l": "0196-1497",
"issn": [
"0196-1497",
"2331-1258",
"2332-4899"
],
"is_oa": true,
"is_in_doaj": false,
"is_core": true,
"host_organization": "https://openalex.org/P4310316088",
"host_organization_name": "United States Department of the Interior",
"host_organization_lineage": [
"https://openalex.org/P4310316088"
],
"host_organization_lineage_names": [
"United States Department of the Interior"
],
"type": "journal"
},
"license": null,
"license_id": null,
"version": "publishedVersion",
"is_accepted": true,
"is_published": true
}
],
"locations_count": 1,
"mesh": [],
"ngrams_url": "https://api.openalex.org/works/W1483477784/ngrams",
"open_access": {
"is_oa": true,
"oa_status": "bronze",
"oa_url": "https://pubs.usgs.gov/of/2013/1010/pdf/ofr20131010.pdf",
"any_repository_has_fulltext": false
},
"primary_location": {
"is_oa": true,
"landing_page_url": "https://doi.org/10.3133/ofr20131010",
"pdf_url": "https://pubs.usgs.gov/of/2013/1010/pdf/ofr20131010.pdf",
"source": {
"id": "https://openalex.org/S4210194219",
"display_name": "Antarctica A Keystone in a Changing World",
"issn_l": "0196-1497",
"issn": [
"0196-1497",
"2331-1258",
"2332-4899"
],
"is_oa": true,
"is_in_doaj": false,
"is_core": true,
"host_organization": "https://openalex.org/P4310316088",
"host_organization_name": "United States Department of the Interior",
"host_organization_lineage": [
"https://openalex.org/P4310316088"
],
"host_organization_lineage_names": [
"United States Department of the Interior"
],
"type": "journal"
},
"license": null,
"license_id": null,
"version": "publishedVersion",
"is_accepted": true,
"is_published": true
},
"primary_topic": {
"id": "https://openalex.org/T10330",
"display_name": "Hydrological Modeling and Water Resource Management",
"score": 0.9995,
"subfield": {
"id": "https://openalex.org/subfields/2312",
"display_name": "Water Science and Technology"
},
"field": {
"id": "https://openalex.org/fields/23",
"display_name": "Environmental Science"
},
"domain": {
"id": "https://openalex.org/domains/3",
"display_name": "Physical Sciences"
}
},
"publication_date": "2013-01-01",
"publication_year": 2013,
"referenced_works": [
"https://openalex.org/W1552029949",
"https://openalex.org/W172456775",
"https://openalex.org/W90872982"
],
"referenced_works_count": 3,
"related_works": [
"https://openalex.org/W868043274",
"https://openalex.org/W4376872516",
"https://openalex.org/W3190643595",
"https://openalex.org/W3096121261",
"https://openalex.org/W2748952813",
"https://openalex.org/W2284877871",
"https://openalex.org/W2138102289",
"https://openalex.org/W2003932708",
"https://openalex.org/W1968810339",
"https://openalex.org/W1967424056"
],
"sustainable_development_goals": [],
"title": "Development of a database-driven system for simulating water temperature in the lower Yakima River main stem, Washington, for various climate scenarios",
"topics": [
{
"id": "https://openalex.org/T10330",
"display_name": "Hydrological Modeling and Water Resource Management",
"score": 0.9995,
"subfield": {
"id": "https://openalex.org/subfields/2312",
"display_name": "Water Science and Technology"
},
"field": {
"id": "https://openalex.org/fields/23",
"display_name": "Environmental Science"
},
"domain": {
"id": "https://openalex.org/domains/3",
"display_name": "Physical Sciences"
}
},
{
"id": "https://openalex.org/T11311",
"display_name": "Biogeochemical Cycling of Nutrients in Aquatic Ecosystems",
"score": 0.9931,
"subfield": {
"id": "https://openalex.org/subfields/2304",
"display_name": "Environmental Chemistry"
},
"field": {
"id": "https://openalex.org/fields/23",
"display_name": "Environmental Science"
},
"domain": {
"id": "https://openalex.org/domains/3",
"display_name": "Physical Sciences"
}
},
{
"id": "https://openalex.org/T11490",
"display_name": "Hydrological Modeling using Machine Learning Methods",
"score": 0.9781,
"subfield": {
"id": "https://openalex.org/subfields/2305",
"display_name": "Environmental Engineering"
},
"field": {
"id": "https://openalex.org/fields/23",
"display_name": "Environmental Science"
},
"domain": {
"id": "https://openalex.org/domains/3",
"display_name": "Physical Sciences"
}
}
],
"type": "article",
"type_crossref": "journal-article",
"updated_date": "2024-08-09T02:23:49.526370",
"versions": [],
"qid": "Q61433"
}
}
