Home | Privacy Policy | ShoreZone Page | Metadata | ShoreZone.org | Contact |
Table A-1. Data dictionary for UNIT table
The Unit Table includes information related to the entire unit, including geomorphic attributes such as overall coastal morphology type, coastal stability, sediment sources to the unit, wave exposure level, and potential oil residence. Administrative information such as the names of the mappers, editors, videotape number, and date entered are also included within the Unit table.
Field Name |
Type |
Description |
UnitRecID |
N |
Automatically-generated number field; the database primary key for unit-level relationships |
PHY_IDENT |
T |
Unique physical identifier; an alphanumeric string comprised of the Region, Area, Unit, and Subunit separated by slashes (e.g. 12/03/0552/0); this field is completed by the database manager using an update query |
REGION |
T |
2-digit coastal region number (see reference maps and GIS materials) |
AREAS |
T |
2-digit coastal area number (see reference maps and GIS materials) |
PHY_UNIT |
T |
4-digit physical along-shore unit number; segmented during physical mapping and delineated on paper maps and in GIS |
SUBUNIT |
T |
Set to 0 for line features (units) or non-zero for point features (also called variants); several subunits in a unit are numbered sequentially (1, 2, 3) according to the order occurring within the unit (based on UTC time) |
TYPE |
T |
Single-letter description of Unit type: a (L)ine (unit) or (P)oint feature (variant) |
N |
Coastal class or shore type of the unit based primarily on substrate type, across-shore width, and slope; derived from the Howes et al. (1994) system applied in coastal British Columbia (Table A-2) |
|
T |
Environmental Sensitivity Index (shore unit classification (Table A-3) |
|
N |
Oil Residence Index |
|
LENGTH_M |
N |
Along-shore length in meters; calculated after digitizing using ArcGIS and updated using database query |
GEO_MAPPER |
T |
Last name of the physical mapper |
GEO_EDITOR |
T |
Last name of the physical mapper who QA/QCs the work (10% of all units are reviewed by an editor) |
GEO_MAP_DATE |
blank; the mapping date is automatically recorded in the DATE_ENTERED field |
|
VIDEOTAPE |
T |
Title of the videotape (DVD imagery) used for mapping; naming convention for 2006 and on is SE06_GL_08, in which 06 is year, GL is team, 08 is tape |
HR |
T |
Hour at which unit starts; based on the first two digits of the 6-digit UTC time on video when start of unit is at center of screen |
MIN |
T |
Minute at which unit starts; based on third and fourth digits of 6-digit UTC time on video when start of unit is at center of screen |
SEC |
T |
Seconds at which unit starts; based on the last two digits of the 6-digit UTC time on video when start of unit is at center of screen |
EXP_OBSER |
T |
Estimate of wave exposure as observed by the physical mapper, as a function of the relative fetch (Table A-5), with a consideration of geomorphology. |
SED_SOURCE |
T |
Estimated sediment source for the unit: (A)longshore, (B)ackshore, (F)luvial, (O)ffshore, (X) not identifiable |
SED_ABUND |
T |
Code indicating the relative sediment abundance within the shore-unit, (A)bundant, (M)oderate, (S)carce |
SED_DIR |
T |
One of the eight cardinal points of the compass indicating dominant sediment transport direction (N, NE, E, SE, S, SW, W, NW). (X) Indicates transport direction could not be discerned from imagery. |
CHNG_TYPE |
T |
Code indicating the stability of the shore unit, reflecting the relative degree of measurable change during a 3-5 year time span: (A)ccretional, (E)rosional, (S)table |
SHORENAME |
T |
Name of a prominent geographic feature near the unit (from nautical chart or gazetteer) |
UNIT_COMMENTS |
T |
Text field used for miscellaneous comments and notes during physical mapping |
SHORE_PROB |
T |
Comment on nature of difference between digital shoreline and observed shoreline |
SM1_TYPE |
T |
2-letter code indicating the primary type of shore modification occurring within the unit: BR = boat ramp; CB = concrete bulkhead; LF = landfill; SP= sheet pile; RR = rip rap and WB = wooden bulkhead |
SM% |
N |
Estimated % occurrence of the primary shore modification type in tenths (i.e. 2 = 20% occurrence with the unit alongshore) |
SM2_TYPE |
T |
2-letter code indicating the secondary type of shore modification occurring within the unit |
SM2% |
N |
Estimated % occurrence of the secondary type of shore modification occurring within the unit |
SM3_TYPE |
T |
2-letter code indicating the tertiary type of shore modification occurring within the unit |
SM3% |
N |
Estimated % occurrence of the tertiary seawall type in tenths (i.e., 2 = 20% occurrence within the unit) |
SMOD_TOTAL |
N |
Total % occurrence of shore modification in the unit in tenths |
RAMPS |
N |
Number of boat ramps that occur within the unit; ramps must impact some portion of the shore-zone and generally be constructed of concrete, wood or aggregate |
PIERS_DOCK |
N |
Number of piers or wharves that occur within the unit; piers or docks must extend at least 10 m into the intertidal zone; does not include anchored floats |
REC_SLIPS |
N |
Estimated number of recreational slips at docks of the unit; based on small boat length ~50 |
DEEPSEA_SLIP |
N |
Estimated number of slips for ocean-going vessels in the unit; based on ship length ~100 |
ITZ |
N |
Sum of the across-shore width of all the intertidal components (B zones) within the unit |
EntryDate ModifiedDate |
D/T |
Date and time the unit was physically mapped (or modified) |