Skip to content
Gallery
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
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.