BC PSCIS Submission schema for use in the Electronic Submission Framework. Copyright (c) 2006 BC Gov, All Rights Reserved. Mandatory: metadata and content of an PSCIS submission. Top level specification of PSCIS submission via ESF Mandatory: indicates the name of the original source excel file provided by the contractor Mandatory: indicates the name of the attachment file provided by the contractor Specifies the data for a PSCIS Required: the name given to identify a project. Mandatory: set to "I" (Input) for first-time submission; set to "U" if updating PSCIS. Optional: Defines the source of funding for the associated project. Eg. FIA Optional: the identifier for the project and is usually related to the funding source Optional: the forest client number of the provided licensee. Required: the name of the responsible parties contact. Required: the phone number of the responsible parties contact. Required: the email of the responsible parties contact. Optional: the forest client number of the provided consultant. Required: the name of the consultant. Required: the phone number of the consultant. Required: the email of the consultant. Optional: the projected total budget alloted for the project. Conditional: 1 or more Remediation Design Proposals Conditional: 1 or more Crossing Assessments Conditional: 1 or more Remediation Results Specification of a Remediation Design Proposal Specification of a Remediation Design Proposal Removes generic gml:featureMember property. The choice between an existing Stream Crossing Id and an External Crossing Reference is determined by whether this is a stream crossing for a re-assessment or a net new assessment Required: is the unique identifier for the STREAM CROSSING LOCATION POINT. Required: identifies the submitters name used to reference a stream crossing. Optional: the mapped stream name. If no name is given for the watercourse, then the parent tributary name is used (i.e. Tributary to Bear Creek). Optional: the name of the road at the crossing, usually a forest road. Optional: the road kilometre position of the crossing to the nearest 0.1 km, matching the kilometre markers, if present. Optional: the corresponding Forest File Id for the service road. Encloses a Point geometry. Removes generic gml:featureMember property. Required: is the unique identifier for the STREAM CROSSING LOCATION POINT. Required: identifies the submitters name used to reference a stream crossing. Removes generic gml:featureMember property. Optional: the measured structure diameter in metres, to the nearest 0.01m if it is a culvert. If it is an open bottomed structure, record a span value in metres to the nearest 0.01m. Optional: the length of the structure in metres, to the nearest 0.01m if it is a culvert. If it is a closed bottom structure enter a width value in metres, to the nearest 0.01m. Required: code value defining the type of crossing present at the location of the stream crossing. Acceptable types are: OBS = Open Bottom Structure CBS = Closed Bottom Structure OTHER = Crossing structure does not fit into the above categories. Eg: ford, wier Required: defines the value provided with a CROSSING TYPE CODE. Valid subtypes depend on CROSSING TYPE CODE. Acceptable values are BRIDGE, PIPE ARCH, WOOD BOX CULVERT, ROUND CULVERT, OVAL CULVERT. Association to an Proposal Feature. Specification of a Remediation Design Proposal Specifies Remediation Design Proposal Type Optional: the estimated cost to complete the proposed remediation. Required: the date in which the remediation proposal was recieved. Optional: the date when the REMEDIATION PROPOSAL will expire. Optional: verified habitat length in linear meters (to the nearest meter). Optional: brief description of the basic quality of the local habitat. Used for determining the importance or necessity of the remediation proposal. Optional: code value describing the evaluated habitat at a crossing site. Particular emphasis is on habitat upstream of the CBS as this is the habitat that will be gained when fish passage is restored. Acceptable values are HIGH, MEDIUM and LOW. Optional: the approximate diameter or span (bridge) of proposed replacement structure, in metres to the nearest 0.01m. Optional: defines the allowable culvert fix options. Acceptable values are: RM - Removal OBS - Open Bottom Structure SS - Stream bed Simulation EM - Additional substrate material and/or downstream weirs BW - Backwater Optional: code value defining the type of crossing present at the location of the stream crossing. Acceptable types are: OBS = Open Bottom Structure CBS = Closed Bottom Structure OTHER = Crossing structure does not fit into the above categories. Eg: ford, wier Optional: defines the value provided with a CROSSING TYPE CODE. Valid subtypes depend on CROSSING TYPE CODE. Acceptable values are BRIDGE, PIPE ARCH, WOOD BOX CULVERT, ROUND CULVERT, OVAL CULVERT. Required: Identifies the stream crossing Association to an Assessment Feature. Specification of a Assessment Specifies Assessment Type Required: Should be set to true when this is a re-assessment. Required: the date when the assessment was completed. Required: initials of the crew members taking measurements. Optional: the date when the assessment was completed. Optional: identifies the approximate average depth of the substrate within the culvert (Metres, to the nearest 0.01m). Optional: indicator value identifying if the bed of the culvert resembles the native stream bed. Acceptable values are 'Y' and 'N'. Optional: indicator value identifying if the culvert is backwatered. Acceptable values are 'Y' and 'N'. Backwatering refers to the damming of water as a result of a downstream control (weir or debris jam). Optional: the percentage of total culvert length that the outlet pool fills back into the culvert. Optional: the avereage depth of fill over culvert in metres (to the nearest 0.01m). Optional: a sum of two measures (metres , to nearest 0.01m) 1.) The distance between the culvert invert and the top of the residual pool 2.) The height of the outlet control (The height of the top of the residual pool to the bottom of the outlet control) Optional: describes the residual pool depth in metres (To the nearest 0.01m). Subtrat water depth at the outlet control from the water depth of the pool downstream of the crossing. Optional: indicator value identifying if there is a drop between the Stream bed elevation and the invert of the culvert at the inlet. Acceptable values are 'Y' and 'N'. Optional: the slope of the culvert. Looking upstream in the culvert, culvert slope is estimated by using a clinometer. If the initial culvert slope is 4% or greater, the estimated slope is recorded (as a percentage value). If the initial reading is less than 4%, the slop is measured using a more precise instrument such as a level. Optional: describes the channel width in meters (to the nearest 0.01m). Channel width is the horizontal distance between the opposite stream banks, measured at right angles to the general orientation of the banks. Optional: describes the slope of a section of stream either upstream or downstream of the culvert, measured using a clinometer. If the stream is at the confluence of the lake, wetland, or larger river, the slope of a section of an upstream section beyond the influence of the road right-of-way is measured. Optional: indicates evidence of beaver activity. This is a maintenance issue and may influence restoration options. Allowable values are 'Y' and 'N'. Optional: identifies if fish have been observed at the crossing. Allowable values are 'Y' and 'N'. Optional: the approximate length (stream bed simulation) or span (bridge) of the proposed replacement structure. Optional: additional note or details. Optional: defines the allowable culvert fix options. Acceptable values are: RM - Removal OBS - Open Bottom Structure SS - Stream bed Simulation EM - Additional substrate material and/or downstream weirs BW - Backwater Optional: code value indicating the depth of the fill on stream. Acceptable values are: DF - Deep Fill - No or little bedrock showing on stream. SF- Shallow Fill - Bedrock occasionally shows on stream. BR - Bedrock - A large area of the bedrock is evident on stream. Optional: code value describing the evaluated habitat at a crossing site. Particular emphasis is on habitat upstream of the CBS as this is the habitat that will be gained when fish passage is restored. Acceptable values are HIGH, MEDIUM and LOW. Required: Identifies the structure Required: Identifies the stream crossing Required: Identifies the stream crossing Association to an Proposal Feature. Specification of a Remediation Result Specifies Remediation Result Type Required: the date in which the remediation was completed. Required: the final total cost compiled for the remediation proposal. Optional: defines the allowable culvert fix options. Acceptable values are: RM - Removal OBS - Open Bottom Structure SS - Stream bed Simulation EM - Additional substrate material and/or downstream weirs BW - Backwater Required: Identifies the structure Required: Identifies the stream crossing Describes submission as (I)nsert, (U)pdate or (V)alidate