| 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: DATABASE TABLES
Table and Field Definitions
The section details the table and field definitions of the tables in the Asset Database.
The tables are detailed in alphabetical order.
Please note that the 'Field Name' is the column name in the table, the 'Data Type' is the type of data that the field holds, for example text or a number and the 'Description field is a description of the information that the field holds.
Table D- 2: Bridge Table
Field Name | Data Type | Description |
Deck Level | Number | The level of the deck of the bridge (metres AOD) |
Scheme ID | Number | Reference to the scheme that the defence belongs to. |
Width | Number | The width of the bridge (m) |
Bridge ID | Text | Unique reference identifying the Bridge. |
Soffit Level | Number | The level of the soffit of the bridge (metres AOD) |
Piers | Number | The number of piers in the bridge. |
Parapet Height | Number | The level of the parapet of the bridge (metres AOD) |
Length | Number | The length of the bridge (m) |
Comments | Text | Comments on the structure. |
Level Survey | Date/Time | The date that the bridge was surveyed. |
Material ID | Number | The material that the bridge was constructed of (Look-up table: Material) |
Condition ID | Number | The condition of the bridge (Look-up table: Condition) |
Constructed | Number | Whether the bridge was constructed (Look-up table: Construction) |
Location Description | Text | A description of the location of the bridge. |
Table D- 3: Channel Improvement Table
Field Name | Data Type | Description |
Scheme ID | Text | Reference to the scheme that the defence belongs to. |
Channel Improvement ID | Text | Unique reference identifying the channel improvement. |
Length | Number | Length of the channel improvements (m) |
Comments | Text | Comments on the structure. |
Level Survey | Number | The date that the channel improvement was surveyed. |
Bank ID | Number | The bank that the channel improvements are on. (Look-up table: Bank) |
Condition ID | Text | The condition of the channel improvements (Look-up table: Condition) |
Channel Improvement Type ID | Number | Type of channel improvement (Look-up table: ChannelImprovementsType) |
FPO | Number | Whether the channel improvements are part of the original flood prevention order. (Look-up table: FPO) |
Constructed | Number | Whether the channel improvements were constructed. (Look-up table: Construction) |
Location Description | Text | A description of the location of the culvert. |
Table D- 4: Culvert Table
Field Name | Data Type | Description |
Scheme ID | Text | Link to the scheme that the defence belongs to. |
Culvert ID | Text | Unique reference identifying defence. |
Upstream Easting | Number | Queried directly from the GIS |
Upstream Northing | Number | Queried directly from the GIS |
Downstream Easting | Number | Queried directly from the GIS |
Downstream Northing | Number | Queried directly from the GIS |
Diameter | Number | Diameter of culvert (m) |
Height | Number | Height of culvert (m) |
Number of Pipes | Number | The number of pipes in the culvert. |
Length | Number | The length of the culvert (m) |
Comments | Text | Comments on the structure. |
Level Survey | Date/Time | The date that the culvert was surveyed. |
Material | Text | The material of the culvert (Look-up table: Material) |
Shape | Text | The shape of the culvert (Look-up table: Shape) |
Bank ID | Number | The bank that the culvert is on. (Look-up table: Bank) |
Condition ID | Text | The condition of the culvert (Look-up table: Condition) |
FPO | Number | Whether the culvert is part of the original flood prevention order. (Look-up table: FPO) |
Constructed | Number | Whether the culvert was constructed. (Look-up table: Construction) |
Location Description | Text | A description of the location of the culvert. |
Table D- 5: Culvert Headwall Table
Field Name | Data Type | Description |
Culvert Headwall ID | Text | Unique reference identifying the culvert headwall |
Slope | Number | Slope of the culvert headwall (degrees) |
Length | Number | Length of the culvert headwall (m) |
Comments | Text | Comments on the culvert headwall |
Level Survey | Date/Time | The date that the culvert headwall was surveyed. |
Material | Text | The material of the culvert headwall(Look-up table: Material) |
Condition ID | Text | The condition of the culvert headwall (Look-up table: Condition) |
FPO | Number | Whether the culvert headwall is part of the original flood prevention order. (Look-up table: FPO) |
Constructed | Number | Whether the culvert headwall is constructed. (Look-up table: Construction) |
Location Description | Text | A description of the location of the culvert headwall. |
Table D- 6: Culvert Screen Table
Field Name | Data Type | Description |
Culvert Screen ID | AutoNumber | Unique reference identifying the culvert screen |
Height | Number | Height of the culvert screen (m) |
Width | Number | Width of the culvert screen (m) |
Bar Thickness | Number | Bar Thickness (mm) |
Bar Spacing | Number | Bar Spacing (mm) |
Comments | Text | Comments on the culvert screen |
Level Survey | Date/Time | The date that the culvert screen was surveyed. |
Condition ID | Text | The condition of the culvert screen (Look-up table: Condition) |
Material | Text | The material of the culvert screen (Look-up table: Material) |
FPO | Number | Whether the culvert screen is part of the original flood prevention order. (Look-up table: FPO) |
Constructed | Number | Whether the culvert screen is constructed. (Look-up table: Construction) |
Location Description | Text | A description of the location of the culvert screen. |
Table D- 7: Embankment Table
Field Name | Data Type | Description |
Scheme ID | Text | Link to the scheme the defence belongs to. |
Embankment ID | Text | Unique reference identifying defence. |
Upstream Easting | Number | Directly queried from the GIS. |
Upstream Northing | Number | Directly queried from the GIS. |
Downstream Easting | Number | Directly queried from the GIS. |
Downstream Northing | Number | Directly queried from the GIS. |
Height | Number | Height of embankment (m) |
Crest Level Upstream | Number | Crest level of embankment upstream (metres AOD) |
Crest Level Downstream | Number | Crest level of embankment downstream (metres AOD) |
Side slope | Number | Side slope of embankment. |
Freeboard | Number | Freeboard included in embankment (mm) |
Length | Number | Freeboard included in embankment (m) |
Comments | Text | Comments on the structure. |
Material | Text | The material of the embankment (Look-up table: Material) |
Level Survey | Date/Time | The date that the embankment was surveyed. |
Material | Text | The material of the embankment (Look-up table: Material) |
Bank ID | Number | The bank that the embankment is on. (Look-up table: Bank) |
Condition ID | Text | The condition of the embankment (Look-up table: Condition) |
FPO | Number | Whether the embankment is part of the original flood prevention order. (Look-up table: FPO) |
Constructed | Number | Whether the embankment was constructed. (Look-up table: Construction) |
Location Description | Text | A description of the location of the embankment. |
Table D- 8: Faults Table
Field Name | Data Type | Description |
Scheme ID | Text | Link to the scheme the defence belongs to. |
Scheme Fault ID | Text | Unique reference identifying defence. |
Eastings | Number | Queried directly from the GIS |
Northings | Number | Queried directly from the GIS |
Details | Text | Details of the location of the fault |
Comments | Text | Comments on the fault. |
Date | Date/Time | Date that fault was found |
Defence Type ID | Number | Type of defence (Look-up table: Defence Type) |
Defence ID | Text | Link to the defence of which the fault belongs |
SubDefence ID | Text | Link to the sub defence of which the fault belongs |
Table D- 9: Floodgate Cabinet Table
Field Name | Data Type | Description |
Scheme ID | Number | Link to the scheme the defence belongs to. |
Floodgate Cabinet ID | AutoNumber | Unique reference identifying defence. |
Comments | Text | Comments on the structure. |
Condition ID | Text | The condition of the floodgate cabinet (Look-up table: Condition) |
Cabinet Type ID | Number | Type of floodgate cabinet (Look-up table: FloodgateCabinetType) |
FPO | Number | Whether the floodgate cabinet is part of the original flood prevention order. (Look-up table: FPO) |
Constructed | Number | Whether the floodgate cabinet was constructed. (Look-up table: Construction) |
Location Description | Text | A description of the location of the floodgate cabinet. |
Table D- 10: Flood Prevention Scheme Table
Field Name | Data Type | Description |
Local Auth ID | Text | Reference to the local authority that manages the scheme. |
Scheme ID | Text | Unique reference identifying defence. |
Scheme Name | Text | Name of the scheme. |
SE File Ref | Number | Scottish Executive File Reference. |
Category | Text | Category of the scheme |
Central Easting | Number | Directly queried from the GIS. |
Central Northing | Number | Directly queried from the GIS. |
Town/City | Text | Town/City Scheme is in. |
Watercourse | Text | Name of the watercourse scheme is on. |
Length | Number | Length of the scheme (m) |
Predominant Land Use | Number | Land use of the area (Look-up table: PredominantLandUse) |
Date of FPO | Text | Date of the flood prevention order. |
Date Construction | Text | Date that the scheme was constructed. |
Climate Change Area | Number | Climate Change area that the scheme belongs in (Look-up table: ClimateChangeArea) |
Inspection Frequency | Number | How frequently the scheme is inspected |
Maintenance Regime | Text | Text describing the maintenance of the scheme. |
Construction Cost | Number | Cost of construction |
Construction Cost at 2004 | Number | Cost of construction at today's prices. |
Cost Benefit Ratio | Number | Cost benefit ratio for the scheme. |
Drawings | Text | List of drawings relating to the scheme |
List of Pertinent documents | Text | List of documents that are relevant to the scheme. |
FPAID | Number | Flood prevention act ID (Look-up table: FloodPreventionAct) |
TOFID | Number | Type of Flooding ID (Look-up table: TypeofFlooding) |
CC | Number | Climate change. Whether climate change was accounted for at the time of scheme design. |
Design Flood Map | Number | Whether a historic flood map was located for the scheme. |
Design Model | Number | Whether a design model was located for the scheme. |
Design As Builts | Number | Whether design 'as-builts' were located for the scheme. |
Design Catchment Area | Number | The design catchment area for the scheme. |
Volume of Design | Number | Volume of design of the scheme. |
Design 100 Yr Flow | Number | The 100 year flow calculated at the time of scheme design. |
Design Flow | Number | The design flow. |
Design SOP | Text | The design standard of protection. |
Current SOP | Number | The current standard of protection. |
SoP AsBuilt | Number | The standard of protection as the scheme was built. |
SoP WithFaults | Number | The standard of protection with faults. |
CC Added To Flow | Number | The percentage of flow added to the design to account for climate change. |
Auto FEH Q100 | Number | The auto feh Q100 value. |
Auto FEH Comments | Text | Any comments about the auto feh value. |
Defended Area | Number | The area defended by the scheme in kilometers. |
Average Annual Damage Defended | Text | Average annual damages incurred with the scheme in place. |
Average Annual Damage Undefended | Number | Average annual damages incurred without the scheme in place. |
Number of Properties Risk at 100yr | Number | Number of properties at risk from the 100 year flood. |
Number of Properties Risk at 200yr | Number | Number of properties at risk from the 200 year flood. |
Number Defended Properties Comm | Number | Number of commercial properties defended. |
Number Defended Properties Resi | Number | Number of residential properties defended. |
List of Operations | Text | |
Inspection Report | Text | |
PresentValueDamageDefended | Number | |
PresentValueDamageUndefended | Number | |
Present Value Damages Avoided | Number | |
Onset RP | Number | |
SE 1961 Scheme List | Number | |
Number of properties defended | Number | |
Table D- 11: Hydrology (Flood Estimation) Table
Field Name | Data Type | Description |
Hydrology ID | Text | |
Scheme ID | Text | |
X | Number | X co-ordinates |
Y | Number | Y co-ordinates |
FEH Catchment Area | Number | Catchment area from FEH |
Adjusted Catchment Area | Number | Adjusted catchment area using OS Mapping |
URBEXT 1990 | Number | URBEXT factor from FEH |
URBEXT 2004 | Number | URBEXT factor from OS Mapping |
URBEXT Adjustment Method | Number | |
SAAR | Number | |
Method | Number | Statistical, Rainfall Run-off, ADAS or IOH124 |
Variation From Chosen Method | Text | |
Index | Number | |
QMED | Number | |
5 | Number | |
10 | Number | |
25 | Number | |
30 | Number | |
50 | Number | |
75 | Number | |
100 | Number | |
200 | Number | |
1000 | Number | |
CC Region | Number | |
CC Adjustment | Number | |
100 CC | Number | |
Donor Analogue | Text | |
AFQMED | Number | |
AF 100 | Number | |
AF 200 | Number | |
AF 1000 | Number | |
SAF 100 | Number | |
SAF 200 | Number | |
SAF 1000 | Number | |
Table D- 12: Local Authority Table
Field Name | Data Type | Description |
Auth ID | Text | Unique reference identifying the local authority. |
Auth Name | Text | Name of the local authority |
Auth Contact | Text | Contact at the local authority. |
Auth Department | Text | Department in the local authority responsible for flood prevention schemes |
Area | Number | Area of the local authority |
Table D- 13: Manhole Table
Field Name | Data Type | Description |
Scheme ID | Text | Reference to the Scheme that the photo is of. |
Manhole ID | Text | Unique ID identifying the Manhole |
Diameter | Number | Diameter of the manhole (m) |
Number of Pipes | Number | Number of pipes in the manhole |
Comments | Text | Comments about the manhole |
Level Survey | Date/Time | Date that the manhole was surveyed. |
Material ID | Number | Material that the manhole is constructed of. (Look-up table: Material) |
Shape ID | Number | Shape of the manhole (Look-up table: Shape) |
Bank ID | Number | Bank of the watercourse that the manhole is on. (Look-up table: Bank) |
Condition ID | Number | Condition of the manhole (Look-up table: Condition) |
FPO | Number | Whether the Manhole was constructed as part of the FPO (Look-up table: FPO) |
Constructed | Number | Whether the manhole was constructed (Look-up table: Construction) |
Location Description | Text | Description of the location of the manhole. |
Table D- 14: Orifice Table
Field Name | Data Type | Description |
Scheme ID | Text | ID of the scheme that the orifice is part of |
Orifice ID | Text | Unique ID identifying the orifice |
Height | Text | Height of the orifice (m) |
Width | Text | Width of the orifice (m) |
Throat Level | Number | Throat level of the orifice (metres AOD) |
Coefficient of Discharge | Number | Coefficient of discharge of the orifice |
Level Survey | Date/Time | Date that the orifice was surveyed |
Condition ID | Number | Condition of the orifice (Look-up table: Condition) |
Comments | Text | Comments about the orifice |
FPO | Text | Whether the orifice was constructed as part of the FPO (Look-up table: FPO) |
Material ID | Number | Material that the orifice is constructed of (Look-up table: Material) |
Location Description | Text | Description of the location of the orifice |
Table D- 15: Orifice Screen Table
Field Name | Data Type | Description |
Orifice ID | Text | ID of the orifice that the screen belongs to |
Orifice Screen ID | Text | Unique ID identifying the orifice screen. |
Height | Text | Height of the orifice screen (m) |
Width | Text | Width of the orifice screen (m) |
Bar Thickness | Number | Bar thickness of the bars in the screen (mm) |
Bar Spacing | Number | Bar spacing of the bars in the screen (mm) |
Comments | Date/Time | Comments about the screen |
Level Survey | Date/Time | Date of the survey of the screen |
Condition ID | Number | Condition of the screen (Look-up table: Condition) |
Material ID | Number | Material that the screen is constructed of (Look-up table: Material) |
FPO | Number | Whether the screen was constructed as part of the FPO (Look-up table: FPO) |
Constructed | Number | Whether the screen was constructed |
Location Description | Text | A description of the location of the screen. |
Table D- 16: Outfall Table
Field Name | Data Type | Description |
Outfall ID | Text | Unique ID identifying the Outfall |
Scheme ID | Text | ID of the scheme that the outfall belongs to |
Culvert ID | Text | ID of the culvert if the outfall is part of one |
Outfall Type ID | Number | Type of outfall structure (Look-up table: Outfall) |
Diameter | Number | Diameter of the outfall (m) |
Bank ID | Number | Bank that the outfall is on (Look-up table: Bank) |
Material ID | Number | Material of the outfall ((Look-up table: Material) |
Level Survey | Date/Time | Date that the outfall was surveyed on |
Condition ID | Number | Condition of the outfall (Look-up table: Condition) |
FPO | Number | Whether the outfall was constructed as part of the FPO (Look-up table: FPO) |
Comments | Text | Comments about the outfall structure |
Constructed | Number | Whether the outfall was constructed (Look-up table: Construction) |
Location Description | Text | A description of the location of the outfall. |
Height | Number | Height of the Outfall (m) |
Width | Number | Width of the Outfall (m) |
Table D- 17: Photos Table
Field Name | Data Type | Description |
Scheme ID | Text | Reference to the Scheme that the photo is of. |
Photo ID | Text | Unique reference identifying the Scheme photo. |
Date | Date/Time | Date of Photograph |
Photograph Number | Text | Number of the photograph - input from GISmo. |
Photograph Description | Text | Description of the photograph. |
Photograph Direction | Number | Direction the photograph was taken (Look-up table: Photograph Direction) |
Comments | Text | Comments about the photograph |
Defence ID | Text | Link to the defence of which the fault belongs |
Defence Type | Number | Type of defence (Look-up table: DefenceType) |
SubDefence ID | Text | Link to the sub defence of which the fault belongs |
Table D- 18: Pump Table
Field Name | Data Type | Description |
Scheme ID | Text | Unique ID identifying the Pump |
Pump ID | Text | ID of the scheme that the pump belongs to |
Pump Number | Text | The number of the pump |
Total Capacity | Number | Total capacity of the pump |
Head | Number | The head of the pump |
Last Inspection | Number | Date the pump was last inspected |
Comments | Number | Comments about the pump |
Level Survey | Date/Time | Date that the pump was surveyed on |
Bank ID | Number | Bank that the outfall is on (Look-up table: Bank) |
Function ID | Number | The function of the pump (Look-up table: Function) |
Activation Switch ID | Text | Pump activation switch type (Look-up table: ActivationSwitch) |
FPO | Number | Whether the pump was constructed as part of the FPO (Look-up table: FPO) |
Constructed | Text | Whether the pump was constructed (Look-up table: Construction) |
Location Description | Number | A description of the location of the pump |
Condition ID | Number | Condition of the pump (Look-up table: Condition) |
Table D- 19: Flood Storage Area Table
Field Name | Data Type | Description |
Scheme ID | Text | Link to the scheme the defence belongs to. |
Storage ID | Text | Unique reference identifying defence. |
Volume | Number | Volume of the storage area (m ) |
Perimeter | Number | Perimeter of the storage area (m) |
Maximum Volume | Number | Maximum volume (m ) |
Maximum Area | Number | Maximum area (km ) |
Construction Cost | Text | Cost of construction of the storage in today's prices. (£) |
Top Water Level | Number | Designed top water level (metres above sea level) |
Under Reservoirs Act | Yes/No | Flood storage area falls within the scope of the Reservoirs Act 1975 |
Bottom Storage Area | Number | Designed bottom water area (km ) |
Crest Level Area | Number | Crest level area (km ) |
Crest Level Volume | Number | Crest level volume (m ) |
PMF Area | Number | |
PMF Volume | Number | |
Freeboard | Number | Freeboard of storage area (mm) |
Annual Maintenance Regime | Text | |
Biennial Maintenance Regime | Text | |
Annual Inspection | Text | |
Comments | Text | Comments on the structure. |
StorageType ID | Number | Type of storage area (look-up table: StorageType) |
Condition ID | Number | Condition of storage (look-up table: Condition) |
FPO | Number | Whether the storage area was constructed as part of the FPO (Look-up table: FPO) |
Constructed | Number | Whether the storage area was constructed (Look-up table: Construction) |
Location Description | Text | A description of the location of the storage area |
Table D- 20: Surface Grating Table
Field Name | Data Type | Description |
Scheme ID | Text | ID of the scheme that the surface grating belongs to |
Surface Grating ID | Text | Unique ID identifying the surface grating |
Culvert ID | Text | ID of the culvert if the surface grating is part of one |
Length | Number | Length of the grating (m) |
Width | Number | Width of the grating (m) |
Bar Thickness | Number | Bar thickness of the grating (mm) |
Bar Spacing | Number | Bar spacing of the grating (mm) |
Bar Width | Number | Bar width of the grating (mm) |
Comments | Text | Comments about the grating |
Level Survey | Date/Time | Date that the grating was surveyed |
Condition ID | Number | Condition of the surface grating (Look-up table: Condition) |
Material ID | Number | Material of the surface grating (Look-up table: Material) |
FPO | Number | Whether the grating was constructed as part of the flood prevention order (Look-up table: FPO) |
Constructed | Number | Whether the grating was constructed (Look-up table: Construction) |
Location Description | Text | A description of the location of the surface grating. |
Table D- 21: Wall Table
Field Name | Data Type | Description |
Scheme ID | Text | Link to the scheme the defence belongs to. |
Wall ID | Text | Unique reference identifying defence. |
Upstream Easting | Number | Queried directly from the GIS. |
Upstream Northing | Number | Queried directly from the GIS. |
Downstream Easting | Number | Queried directly from the GIS. |
Downstream Northing | Number | Queried directly from the GIS. |
Height | Number | Ground to crest level (m) |
Level Upstream | Number | Upstream level of the wall (metres above sea level) |
Level Downstream | Number | Downstream level of the wall (metres above sea level) |
Thickness | Number | Thickness of the wall (mm) |
| | |
Facing Outer | Number | Material of outer facing (Look-up table: Material) |
Facing Inner | Number | Material of inner facing (Look-up table: Material) |
| | |
Freeboard | Number | Freeboard of the wall (mm) |
Length | Number | Length of the wall (m) |
Comments | Text | Comments on the structure. |
Level Survey | Date/Time | Date that the wall was surveyed |
Bank ID | Number | Bank that the outfall is on (Look-up table: Bank) |
Condition ID | Number | Condition of the wall (Look-up table: Condition) |
Material ID | Number | Material of the wall (Look-up table: Material) |
Type ID | Number | Type of wall (Look-up table: Type) |
FPO | Number | Whether the wall was constructed as part of the FPO (Look-up table: FPO) |
Constructed | Number | Whether the wall has been constructed (Look-up table: Construction) |
Location Description | Text | Description of the location of the wall. |
Table D- 22: Wall Floodgate Table
Field Name | Data Type | Description |
Wall Floodgate ID | Text | Unique ID identifying the wall floodgate |
Condition ID | Number | Condition of the wall floodgate (Look-up table: Condition) |
Cabinet Type ID | Number | The cabinet type if there is one attached to the floodgate (Look-up table: FloodgateCabinetType) |
Floodgate Description | Text | A description of the floodgate |
Comments | Text | Comments about the floodgate |
Material ID | Number | The material that the floodgate is constructed of (Look-up table: Material) |
FPO | Number | Whether the flood was constructed as part of the FPO (Look-up table: FPO) |
Constructed | Number | Whether the wall has been constructed (Look-up table: Construction) |
Location Description | Text | Description of the location of the wall floodgate. |
Wall ID | Text | The ID of the wall that the floodgate is attached to |
Table D- 23: Weir Table
Field Name | Data Type | Description |
Scheme ID | Text | ID of the scheme that the weir belongs to |
Weir ID | Text | Unique ID identifying the weir structure |
Length | Number | Length of the weir (m) |
WeirProfile ID | Number | ID describing the profile of the weir structure |
Coefficient Of Discharge | Number | Coefficient of discharge of the weir |
Crest Level | Number | Crest level of the weir (metres above sea level) |
Level Survey | Date/Time | Date that the weir was surveyed. |
Condition ID | Number | Condition of the weir (Look-up table: Condition) |
Comments | Text | Comments about the weir |
FPO | Number | Whether the weir was constructed as part of the Flood Prevention Order (Look-up table: FPO) |
Material ID | Number | Material that the weir is constructed of (Look-up table: Material) |
Constructed | Number | Whether the weir was constructed (Look-up table: Construction) |
Location Description | Text | Description of the location of the weir. |
Table D- 24: Weir Screen Table
Field Name | Data Type | Description |
Weir ID | Text | ID of the weir that the screen is linked to |
Weir Screen ID | Text | Unique ID identifying the Weir Screen |
Height | Number | Height of the screen (m) |
Width | Number | Width of the screen (m) |
Bar Thickness | Number | Bar thickness of the bars (mm) |
Bar Spacing | Number | Bar spacing of the bars (mm) |
Comments | Text | Comments about the screen |
Level Survey | Date/Time | Date that the screen was surveyed |
Condition ID | Number | Condition of the screen (Look-up table: Condition) |
Material ID | Number | Whether the screen was constructed as part of the Flood Prevention Order (Look-up table: FPO) |
FPO | Number | Material that the screen is constructed of (Look-up table: FPO) |
Constructed | Number | Whether the screen was constructed (Look-up table: Construction) |
Location Description | Text | Description of the location of the weir screen |
Table D- 25: Weir Sluice gate Table
Field Name | Data Type | Description |
Weir ID | Text | ID of the weir that the sluice gate is part of |
Weir Sluicegate ID | Text | Unique ID identifying the Weir Sluice gate |
Condition ID | Number | Condition of the sluice gate (Look-up table: Condition) |
Cabinet Type ID | Number | Type of floodgate cabinet if one is attached to the sluice gate (Look-up table: FloodgateCabinetType) |
Floodgate Description | Text | A description of the floodgate |
Comments | Text | Comments about the floodgate |
FPO | Number | Whether the sluice gate was constructed as part of the FPO (Look-up table: FPO) |
Constructed | Number | Whether the sluice gate was constructed (Look-up table: Construction) |
Location Description | Text | A description of the location of the weir sluice gate. |
Table D- 26: Weir Wingwall Table
Field Name | Data Type | Description |
Weir Wingwall ID | Text | Unique ID identifying the weir wingwall |
Height | Text | Height of the weir wingwall (m) |
Level Upstream | Number | Level upstream (metres above sea level) |
Level Downstream | Number | Level downstream (metres above sea level) |
Thickness | Number | Thickness of the wall. (mm) |
Facing Outer | Number | Material of outer facing (Look-up table: Material) |
Facing Inner | Number | Material of inner facing (Look-up table: Material) |
Freeboard | Number | Freeboard associated with the weir wingwall (mm) |
Length | Number | Length (m) |
Comments | Text | Comments about the weir wingwall |
Level Survey | Date/Time | Date that the weir wingwall was surveyed |
Bank ID | Number | Bank that the wingwall is on (Look-up table: Bank) |
Condition ID | Number | Condition of the wingwall (Look-up table: Condition) |
Type ID | Number | Type of wingwall (Look-up table: Type) |
Material ID | Number | Material of the wingwall (Look-up table: Material) |
FPO | Number | Whether the wingwall was constructed as part of the FPO (Look-up table: FPO) |
Constructed | Number | Whether the wingwall has been constructed (Look-up table: Construction) |
Location Description | Text | Description of the location of the wingwall. |
Weir ID | Text | The ID of the weir that the wall is part of |
Contents |