Skip to content
csH sql walk routes
database tables
basic aggregate functions
group
reminder
More
Share
Explore

icon picker
database tables

​
Walk and Route Database
There are two tables in this database: route and walk. The two tables are shown below.
ROUTE
1
ROUTEID
STARTPOINT
FINISHPOINT
ESTIMATEDMINS
KMS
ROUTETYPE
RATING
1
1
Shiel Bridge
Glen More
480
23
Mountain
5
2
2
Aberdour
Anstruther
600
44
Coastal
4
3
3
Rackwick
Rackwick
180
12
Coastal
2
4
4
Kelty
Loch Glow
90
5
Forest
1
5
5
Fort William
Steall Falls
210
8
Hill
4
6
6
Pitlochry
Blair Atholl
175
11
Forest
2
There are no rows in this table
6
Count
⁠

WALK
0
WALKNUMBER
WALKDAY
DEPARTURE
NUMBERWALKERS
RAINED
MINUTESTAKEN
ROUTEID
1
1893
21-Mar-2017
30-Dec-1899
9
Yes
213
3
2
2002
30-Apr-2017
30-Dec-1899
15
No
167
3
3
19
27-Nov-2014
30-Dec-1899
30
No
606
2
4
218
01-Feb-2016
30-Dec-1899
3
No
102
4
5
723
16-Oct-2015
30-Dec-1899
12
Yes
713
2
6
86
01-Jan-2015
30-Dec-1899
24
Yes
180
6
7
1992
05-Apr-2017
30-Dec-1899
2
No
512
1
8
499
19-Nov-2015
30-Dec-1899
9
No
190
5
There are no rows in this table
8
Count
⁠

Scripts


⁠
Github scripts
⁠
⁠

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.