| Description | Scottish Flood Defence Asset Database Final Report |
|---|
| ISBN | (Web Only) |
|---|
| Official Print Publication Date | |
|---|
| Website Publication Date | August 20, 2007 |
|---|
Contents |
Listen
APPENDIX D: LOOKUP TABLES
The ID value from the appropriate look-up table linked to the asset database is used to determine the textual information that is placed on the Web GIS Application. These look-up tables are listed below.
Table D- 27: ActivationSwitc h
Activation Switch ID | Description |
1 | HiHi |
2 | Hi |
3 | Lo |
4 | LoLo |
5 | Unknown |
Table D- 28: Bank Position
Bank ID | Description |
1 | Left |
2 | Right |
3 | Centre |
4 | Both |
6 | Unknown |
7 | Coast |
Table D- 29: Channel Improvement Type
Channel Improvement Type ID | Description |
1 | Unrevetted Channel Sides |
2 | Rock and Stone Revetment |
3 | Grouted Stone Revetment |
4 | Gabion and Reno Mattress |
5 | Precast Concrete Units and Concrete Blockwork Revetment |
6 | Concrete Channel Walls |
7 | Brick or Masonry |
8 | Steel Piling |
9 | Diversion of Channel |
10 | Haphazard Protection |
11 | Open Channel |
12 | Raising of Bridge |
13 | Reconstruction of Bridge |
14 | Regrading and Cleaning of Channel |
15 | Regrading and Widening of Channel |
16 | Removal of Culvert |
17 | Regrading of Channel |
18 | Unknown |
19 | New Channel |
20 | Cleaning of Channel |
21 | Wood Boards |
22 | Rock erosion control |
23 | Flood Berm |
24 | Realignment of Channel |
25 | Rip-Rap |
26 | Concrete lain on the channel |
27 | Concrete block mattress |
28 | Erosion protection |
29 | Strengthening of Bridge |
30 | Strengthening of Floor |
Table D- 30: Climate Change Area
Area ID | Description |
0 | Unknown |
1 | Eastern Scotland |
2 | North & North-West Scotland |
3 | South-West Scotland |
Table D- 31: Coastal Hydraulics
CoastalHydraulics ID | Description |
1 | Proudman Oceanographic Laboratory |
2 | Observed data |
3 | Other |
Table D- 32: Asset Condition
Condition ID | Condition | Description |
1 | Very Good | In good condition, fully serviceable, no remedial work required. Maintenance to continue as present. No significant defect. |
2 | Good | Minor defects, non-urgent. Minor routine maintenance work required. In reasonable condition, some increase in maintenance needed, probably not more than 5% affected with slight defect. |
3 | Fair | Some cause for concern, requires careful monitoring. Significant maintenance works required. Average condition, some minor repairs needed & moderate 5% - 20% affected. |
4 | Poor | Structurally unsound now or in the near future. Major remedial works required or replacement (1-5 years) Extensive repair required in the short term. Extensive defect 20%-50% affected. |
5 | Very Poor | Completely failed or derelict requires complete reconstruction. Major urgent repairs or replacement needed without delay to avoid failure probably beyond repair. Extensive defect > 50% |
7 | Unknown | Unknown |
Table D- 33: Culvert Construction
Construction ID | Description |
8 | Single Arched |
9 | Double Arched |
10 | Multiple Arched |
11 | Single Beam |
Table D- 34: DefenceType
DefenceType ID | Description |
1 | Bridge |
2 | Channel Improvement |
3 | Culvert |
4 | Culvert Screen |
5 | Embankment |
6 | Floodgate Cabinet |
7 | Manhole |
8 | Orifice |
9 | Pump |
10 | Scheme |
11 | Storage |
12 | Surface Grating |
13 | Wall |
14 | Wall Floodgate |
15 | Weir |
16 | Weir Screen |
17 | Weir Sluicegate |
18 | Outfall |
19 | Culvert Headwall |
20 | Weir Wingwall |
Table D- 35: Design Consultant
Design Consultant ID | Name |
1 | Arup |
2 | Babtie |
3 | Bullen |
4 | Central Regional Council |
5 | Chalmers Construction |
7 | Crouch Hogg Waterman (now Halcrow) |
8 | Fife Regional Council Engineering Department - Water / Drainage Division |
10 | Frederick Snow & Partners |
11 | Grampian Regional Council |
12 | Halcrow |
13 | Harper and Tait |
15 | J R Gladstone & Sons |
16 | Mott McDonald |
18 | Ove Arup & Partners |
19 | Royal Haskoning/Posford Duvivier |
20 | W A Fairhurst and partners |
21 | W R Costley & Company |
22 | Warren & Partners |
23 | WS Atkins |
24 | JBA Consulting |
25 | Crouch & Hogg (now Halcrow) |
26 | Rendel Palmer and Triton |
27 | Hyder |
28 | North of Scotland Water Authority ( NoSWA) |
29 | W & J Barr and sons |
30 | Findlay Construction Ltd |
31 | Gabion Construction Co ltd (not design consultants) |
32 | Unknown |
Table D- 36: Scheme Drawing Type
Drawing Type ID | Description |
1 | 'As-built' |
2 | Flood Prevention Order |
3 | Survey |
Table D- 37: FloodgateCabinetType
Cabinet Type ID | Description |
1 | Gate |
2 | Stop logs |
6 | Unknown |
Table D- 38: Flood Prevention Scheme
FPSID | Part of FPS? |
1 | Yes |
2 | No |
3 | Unknown |
Table D- 39: Pump Function
Function ID | Description |
1 | Duty |
2 | Duty/Standby |
3 | Duty/Assist |
4 | Unknown |
Table D- 40: Asset Inspection Frequency
Inspection ID | Description |
0 | Unknown |
1 | Daily |
2 | Weekly |
3 | Monthly |
4 | Biannually |
5 | Annually |
Table D- 41: Level of Information Detail
Code | Description |
A | Detailed information |
B | Some information |
C | Little or no information |
D | Detailed information (d) |
Table D- 42: Construction Material
Material ID | Description |
1 | Concrete |
2 | Corrugated Steel |
3 | Plastic |
4 | Plastic Smooth |
5 | Random Rubble |
6 | Steel |
7 | Stone |
8 | Unknown |
9 | Shale |
10 | Earth |
11 | Rock |
12 | Rock and Stone |
13 | Grouted Stone |
14 | Gabion and Reno Mattress |
15 | Mixed Earth and Gabion and Reno Mattress |
17 | Brick |
18 | Block |
19 | Other |
20 | Piles |
21 | Masonry |
22 | Earth and Gabion Mixed |
23 | Breeze block on top of masonry. |
24 | Cast Iron |
25 | Reinforced Grass |
26 | Breeze Block |
27 | Wood Board |
28 | None |
29 | Sand Bags |
30 | Steel sheet piling |
31 | Wood |
32 | Clay |
33 | Geotextile |
34 | Exposed Aggregate |
Table D- 43: Outfall Type
Outfall Type ID | Description |
1 | Pipe |
2 | Flap Valve |
3 | Penstock |
4 | Sluice Gate |
5 | Screens |
6 | Unknown |
7 | Tide Flex |
Table D- 44: Photograph Direction
Photograph Direction ID | Description |
19 | Upstream |
20 | Downstream |
21 | Towards Left Bank |
22 | Towards Right Bank |
23 | Away From Left Bank |
24 | Away from Right Bank |
25 | North |
26 | North East |
27 | East |
28 | South East |
29 | South |
30 | South West |
31 | West |
32 | North West |
33 | Unknown |
Table D- 45: Predominant Land Use
Land ID | Description |
0 | Unknown |
1.1 | Broad-leaved, mixed and yew woodland |
2.1 | Coniferous woodland |
4.1 | Arable & horticulture. Cereals |
4.2 | Arable & horticulture. Horticulture/non-cereal. |
5.1 | Improved grassland. |
6.1 | Neutral grassland |
7.1 | Calcarous grassland |
8.1 | Acid grassland |
13.1 | Standing water/canals |
17.1 | Built-up areas, gardens. Suburban/rural developed |
17.2 | Built-up areas, gardens. Continuous Urban. |
21.1 | Littoral sediment |
Table D- 46: Produced By
Produced ID | Description |
1 | JBA Consulting |
2 | Scottish Borders Council |
3 | Crouch Hogg Waterman |
4 | Fife Regional Council |
5 | Highland Regional Council |
6 | Babtie |
7 | Central Regional Council |
8 | Borders Regional Council |
9 | Fairhurst |
10 | Dumfries & Galloway Council |
Table D- 47: Culvert Shape
Shape ID | Description |
1 | Armc o |
2 | Elliptical |
3 | Arched |
4 | Box |
5 | Circular |
6 | Unknown |
7 | Triangular |
Table D- 48: Flood Storage Type
Storage Type ID | Description |
1 | Dry Pond |
2 | Wet Pond |
3 | Washland |
5 | Unknown |
Table D- 49: Flood Defence Type
Type ID | Description |
1 | Flood bank |
2 | Brick wall |
3 | Coastal defence |
4 | Concrete wall |
5 | Concrete wall to base of channel |
6 | Flood wall |
7 | Raised bridge / Parapet wall |
8 | Sheet pile wall to base of channel |
9 | Sideways pile wall |
10 | Wall to base of channel |
11 | Unknown |
12 | Retaining |
13 | Freestanding |
14 | Gabion Wall |
15 | Garden |
16 | Precast Concrete Kerb |
Table D- 50: Type of Flooding
Type of Flooding ID | Description |
1 | Tidal |
2 | Pluvial |
3 | Fluvial |
4 | Tidal/Fluvial |
5 | Unknown |
Table D- 51: Weir Profile
Weir Profile ID | Description |
1 | Rectangular Broad crested |
2 | Gabion |
3 | Ogee |
4 | Sharp Crested |
5 | Flume |
6 | Overflow |
7 | Embankment |
8 | V-Shape |
9 | Unknown |
Table D- 52: Yes, No or N/A
Code | Description |
0 | No |
1 | Yes |
2 | N/A |
Table D- 53: Base Flow Index
Method ID | Description |
1 | BFI |
2 | BFIHOST |
Table D- 54: Flood Estimation Method
Method ID | Description |
1 | FEH Statistical Method |
2 | FEH Rainfall-Runoff Method |
3 | ADAS 345 |
4 | IOH 124 Small Catchments |
5 | Rational Method |
6 | Hybrid |
Table D- 55: URBEXT Adjustment Method
Method ID | Description |
8 | FEH methodology using 1:10,000 scale OS map. |
9 | LandCover 2000 |
Contents |