Level	wd_id	name	osm_id	type	mouth	lat	lon	continent	country	admin
1	35654	Firth of Clyde		firth	-1	-5,0	55,666666666		145 22	
.2	19721	River Clyde	2794973	river	35654	-3,652222222	55,406388888	46	145 	22
..3	2559923	River Leven		river	19721	-4,62	56,054		145 	22
...4	208926	Loch Lomond		lake	-1	-4,566666666	56,083333333		145 22	208121
..3	7337212	River Cart		river	19721	-4,40488889	55,89169444		145 	211091
...4	2662466	Black Cart Water		river	7337212	-4,40658333	55,88305556		145 	22
....5	1049507	Castle Semple Loch		lake	-1	-4,6	55,783333333		145 22	211091
.2	7337441	River Garnock		river	35654	-4,690026	55,608189		145 	
..3	6699841	Lugton Water		river	7337441	-4,68333	55,63333		145 	22
...4	6664943	Loch Libo		lake	-1	-4,49608	55,769		145 22	
.2	7337351	River Doon		river	35654	-4,65	55,439444444		145 	
..3	1547670	Loch Doon	49398	lake	-1	-4,371944444	55,25		145 22	209135
1	202083	Firth of Forth		firth	-1	-2,75	56,166666666		145 22	22
.2	1821741	River Leven		river	202083	-3,107761111	56,194761111		145 	22
..3	2266807	Loch Leven		lake	-1	-3,375	56,194444444		145 22	22
1	715269	World Ocean		ocean	83169					
.2	97	Atlantic Ocean		ocean	715269	-30,0	0,0			
..3	1693	North Sea		sea	97	3,0	56,0		35 183 142 145 20 55 31	
...4	19720	Spey	2795138	river	1693	-3,0955	57,6746		145 	22
....5	8313107	River Avon	2795129	river	19720	-3,37537	57,41468		145 	22
.....6	7375126	Loch A'an		lake	-1	-3,62713	57,1034		145 22	
....5	6665014	Loch Spey		lake	-1	-4,60417	57,0078		145 22	
...4	3433823	River Shin		river	1693	-4,413333333	57,935666666		145 	
....5	430478	Loch Shin		reservoir	-1	-4,533333333	58,1		145 22	
...4	387736	River Don		river	1693	-2,078305555	57,175555555	46	145 22 	189912
...4	503262	River Tweed	3308236	river	1693	-1,990222222	55,76525	46	145 	211113 23079
....5	994956	Ettrick Water		river	503262	-3,307	55,344		145 	22
.....6	8049573	Yarrow Water		river	994956	-2,913	55,5531		145 	22
......7	338446	St Mary's Loch		lake	-1	-3,186111111	55,494444444		145 22	211113
...4	964949	River Dee	2887920	river	1693	-2,067888888	57,142111111	46	145 	189912
....5	6664930	Loch Kinord		lake	-1	-2,92	57,0815		145 22	189912
..3	3433664	River Carron		river	97	-5,433769444	57,425919444		145 	22
...4	3257710	Loch Scaven		lake	-1	-5,165	57,523055555		145 22	
1	1765455	Firth of Tay		firth	-1	-3,0	56,433333333		145	22
.2	19719	River Tay	2794974	river	1765455	-2,874805555	56,457416666	46	145 	22
..3	1259288	River Tummel		river	19719	-3,666666666	56,633333333		145 	22
...4	1265271	Dunalastair Water		lake	-1	-4,129166666	56,698611111		145 22	207679
1	5762423	Inner Seas off the West Coast of Scotland		sea	-1	-7,0	56,0		145	
.2	1947182	River Morar		river	5762423	-5,83333	56,9833		145 	22
..3	1444264	Loch Morar		lake	-1	-5,672222222	56,95		145 22	208279
1	7346603	Loch Ken		lake	-1	-4,056	55,009		145 22	
1	7337110	River Awe		river	1908082	-5,23333	56,45		145 	22
.2	1368230	Loch Awe		lake	-1	-5,235	56,297777777		145 22	202174
1	909073	Caledonian Canal		canal	-1	-4,738541	57,112478		145 	
.2	49650	Loch Ness	4023212	lake	909073	-4,45	57,3		145 22	208279
1	1326564	Lunan Burn		river	-1	-3,31667	56,55		145 	22
.2	1867305	Loch of the Lowes		lake	-1	-3,55	56,577777777		145 22	207679
1	4955638	Braid Burn		river	-1	-3,13128	55,9405		145 	
.2	1263637	Duddingston Loch		lake	-1	-3,14666667	55,94166667		145 22	23436
1	5470610	Forss Water		river	-1	-3,66832	58,6008		145 	22
.2	19900759	Loch Shurrery		lake	-1	-3,63333	58,48333		145 22	864668
1	19309271	Q19309271		river	-1	-3,05838889	55,91083333		145 	206934
.2	5566250	Gladhouse Reservoir		reservoir	-1	-3,11665	55,7702		145 22