gwis data dictionary v1.6 20140411

Southwest Florida Water Management District

Geographic Watershed Information System (GWIS) Database Design Document

Version 1.6

GWIS Version: 1.6

Database Design Document Date: April 2014

GWIS Data Dictionary SWFWMD, 2014 of 68

Revision History Date Version Description Author

Oct.

2006

1.0 Initial Release DB, JDJ

Nov.

2006

1.1 Added domain: dINLETDESC DB, JDJ

Mar.

2007

1.2 Added Fields:

WATERSHED_NAME (CATCHMENT)

LAKETYPE_DESC (GWIS_WATERBODY)

INCLUDE_CONNECT_DESC (HYDROEDGE, HYDROJUNCTION)

SYSTEM_SCALE_DESC (HYDROEDGE, HYDROJUNCTION)

SUBELEMENT_INDEX_CNT (BRIDGE_DECK, BRIDGE_OPENING, BRIDGE_PIER,

BRIDGE_SPURDIKE, BRIDGESECTION_TYPE, CROSSSECTION, GWIS_GATE, CHANNEL, WEIR, ORIFICE, PIPE_BARREL)

LOW_CHORD_MS (BRIDGE_OPENING)

WEIR_ORIENTATION_DESC (WEIR)

Added Domains:

dLAKETYPE, dINCLUDECONNECT, dSYSSCALE, dWEIRORIENTATION, dCSHAPE

Added relationship class: BridgeDeckHasBridgeSectionTypes

Domain dCMATERIAL – changed name to dPMATERIAL

Domain dPMATERIAL – added codes CMP, RCP, ABS, PVC, & STEEL

Domain dWEIRSHP – changed code from RECTANGLE to RECTANGULAR

DB, JDJ

July

2007

1.3 Feature Class COASTALSHORELINE – changed geometry from polygon to polyline JDJ

Jan.

2008

1.4

Feature Class OBSCUREDVEG – changed name to LOWCONFIDENCEAREAS

Feature Class HYDROEDGE – changed to polyline M

Domain dVERT_UN – changed name to dVERTUNITS

Domain dVERT_DAT – changed name to dVERTDATUM

Attribute INCLUDE_CONNECT_DESC – changed to INCLUDECONNECT_DESC

Domain dPSHAPE – removed codes for BOX, TRAPEZOIDAL, and PARABOLIC

Domain dHYDRAULICTYPE – removed code for CROSS SECTION

Domain dHYDRAULICTYPE – changed code from INLET to INLET/OUTLET

Attribute NUMBER_ELEMENTS_CNT – removed from PIPE_BARREL table

Table METADATA – changed name to GWIS_METADATA

Attribute HYDROEDGE_ID – changed to HYDROEDGEID (all locations in GWIS)

Relationship Class HydroJunctionHasBoundEdgeDischarges – changed name to HydroEdgeHasBoundEdgeDischarges

Added Feature Classes:

HIGHWATERMARKS, IRREGULAR_WEIR, PROFILE_LINE, TERRAIN_BOUNDARY, IRREGULAR_CROSSSECTION, LIDARPROJECTGRID

Added Tables:

WEIR_STATIONS, CROSSSECTION_STATIONS, PROFILE_STATIONS, DROP_STRUCTURE

JDJ

GWIS Version: 1.6



1.4 (cont.)

Added Relationship Classes:

ProfileLineHasProfileStations, IrregularWeirHasWeirStations, IrregularCrossSectionHasCrossSectionStations, WeirHasIrregularWeir, ChannelHasUpstreamCrossSection, ChannelHasDownStreamCrossSection, ChannelHasAuxiliaryUpstreamCrossSection1, ChannelHasAuxiliaryUpstreamCrossSection2, ChannelHasAuxiliaryDownstreamCrossSection1, ChannelHasAuxiliaryDownstreamCrossSection2, HydroJunctionHasDropStructure, DropStructureHasWeirs, DropStructureHasPipeBarrels

Added Fields:

CORRESPONDING_DEPTH_MS (CHANNEL),

DROPSTRUCTURE_ID (WEIR, PIPE_BARREL)

Aug.

2008

1.5 Added Geometric Network: HEP_GeometricNetwork

Added Feature Class: HEP_LINE

Added Subtypes to HYDRAULIC_ELEMENT_POINT feature class: (BARREL, PIPE, WEIR,

BRIDGE DECK, BRIDGE OPENING, BRIDGE PIER, and GENERAL POINTS)

Removed Domain:

dPOINTTYPE

Added Domains:

dPOINTTYPE_BRIDGEDECK, dPOINTTYPE_BRIDGEOPENING, dPOINTTYPE_BRIDGEPIER, dPOINTTYPE_PIPEBARREL, dPOINTTYPE_WEIR, dPOINTTYPE_GENERALPOINTS, dHEP_SUBELEMENTTYPE


HydroJunctionHasBridgeOpenings, HydroJunctionHasBridgePiers, HydroJunctionHasBridgeSpurDikes, HydroJunctionHasBridgeSectionTypes, BridgeSectionTypeHasCrossSection, BridgeOpeningHasCrossSection, BridgeSpurDikeHasCrossSection, PipeBarrelHasHEPLine

Removed Relationship Clases:

BridgeDeckHasBridgeOpenings, BridgeDeckHasBridgePiers, BridgeDeckHasBridgeSpurDikes, BridgeDeckHasBridgeSectionTypes

Added Fields:

JUNCTIONID (BRIDGE_OPENING, BRIDGE_PIER, BRIDGE_SPURDIKE,

BRIDGESECTION_TYPE)

CROSSSECTION_ID (BRIDGESECTION_TYPE)

Removed Fields:

BRIDGEDECK_ID (BRIDGE_OPENING, BRIDGE_PIER, BRIDGESECTION_TYPE)

BRIDGEOPENING_ID (BRIDGE_SPURDIKE)

Modified codes within domain dTSDATATYPE

JDJ

Jan.

2009

1.6

Added Feature Dataset: Model

Added Geometric Network: ICPR_ModelNetwork

Added Feature Classes:

ICPR_BASIN, ICPR_LINK, ICPR_NODE, ICPR_SLURP, ICPR_XSECT

Added Object Classes (Tables):

JDJ

GWIS Version: 1.6



1.6 (cont.)

ICPR_BREACH, ICPR_COMMENT, ICPR_EXFILTRATIONTRENCH,

ICPR_FILTER, ICPR_LINK_TIMEDISCHARGE, ICPR_MANHOLETYPE,

ICPR_NODE_STAGEDISCHARGE, ICPR_NODE_STORAGE,

ICPR_NODE_TIMEDISCHARGE, ICPR_NODE_TIMESTAGE,

ICPR_OVFLOWPLANE, ICPR_PARAMETERS, ICPR_PERCOLATION,

ICPR_RATINGCURVE, ICPR_RATINGCURVE_OPTABLE,

ICPR_BOTTOMCLIP_OPTABLE, ICPR_TOPCLIP_OPTABLE,

ICPR_WEIRCOEF_OPTABLE, ICPR_ORIFICECOEF_OPTABLE,

ICPR_XSECT_STATIONS, BRIDGE_RATINGCURVE,

ICPR_LINK_HYDROGRAPH, ICPR_LINK_RESULT,

ICPR_NODE_HYDROGRAPH, ICPR_NODE_RESULT

Added Domains:

dCMATERIAL, dICPR_FLOWDIRECTION, dICPR _BASINTYPE,

dICPR_LINKTYPE, dICPR_NODETYPE, dICPR_BASINSTATUS,

dTOPBOTTOMCLIP_FUNCTION, dMANHOLE_TYPE,

dRATINGCURVE_FUNCTION, dORIFICECOEF_FUNCTION,

dWEIRCOEF_FUNCTION, dFRICTION_EQUATION, dSOLUTION_ALGORITHM,

dOUTLET_CONTROL, dINLET_CONTROL, dRUN_WSPRO,

dPERCSURFAREAOPTION, dPERCVERTFLOWTERMINATION,

dEXFILTRATIONEDNTREATMENT, dBREACHEQUATION, dFILTERSLOPE,

dXSECT_ENCROACHMENT


ICPRBasinHasSLURP, BridgeOpeningHasICPRXsect,

BridgeSectionTypeHasICPRXsect, BridgeSpurDikeHasICPRXsect,

ChannelHasDownstreamAuxICPRXsect1,

ChannelHasDownstreamAuxICPRXsect2,

ChannelHasDownstreamMainICPRXsect,

ChannelHasUpstreamAuxICPRXsect1, ChannelHasUpstreamAuxICPRXsect2,

ChannelHasUpstreamMainICPRXsect, ICPRBasinHasComment,

ICPRBasinHasOverlandFlowPlane, ICPRBottomClipOpTabelHasComment,

ICPRLinkHasBreach, ICPRLinkHasBridgeDeck, ICPRLinkHasBridgeOpening,

ICPRLinkHasBridgePiers, ICPRLinkHasBridgeRatingCurve,

ICPRLinkHasBridgeSectionTypes, ICPRLinkHasBridgeSpurDike,

ICPRLinkHasChannel, ICPRLinkHasComment, ICPRLinkHasDropStructure,

ICPRLinkHasExfiltrationTrench, ICPRLinkHasFilter,

ICPRLinkHasICPRLinkHydrographs, ICPRLinkHasICPRLinkResults,

ICPRLinkHasICPRParameters, ICPRLinkHasPercolation, ICPRLinkHasPipe,

ICPRLinkHasRatingCurve, ICPRLinkHasTimeDischarge, ICPRLinkHasWeir,

ICPRNodeHasBoundDischarges, ICPRNodeHasComment,

ICPRNodeHasICPRNodeHydrographs, ICPRNodeHasICPRNodeResults,

ICPRNodeHasICPRNodeStorage, ICPRNodeHasManholeType,

ICPRNodeHasStageDischarge, ICPRNodeHasTimeStage,

ICPROrificeCoefOpTableHasComment,

ICPRRatingCurveHasOperatingTable1, CPRRatingCurveHasOperatingTable2,

ICPRRatingCurveHasOperatingTable3, CPRRatingCurveHasOperatingTable4,

ICPRRatingCurveOpTableHasComment, ICPRTopClipOpTableHasComment,

ICPRWeirCoefOpTableHasComment, ICPRXsectHasComment,

ICPRXsectHasXsectStations, WeirHasBottomClipOpTable,

WeirHasOrificeCoefOpTable, WeirHasTopClipOpTable,

WeirHasWeirCoefOpTable, WeirHasICPRXsect

GWIS Version: 1.6



1.6 (cont.)

Added Fields:

ICPR_LINK_NAME (BRIDGE_DECK, BRIDGE_OPENING, BRIDGE_PIER,

BRIDGE_SPURDIKE, BRIDGESECTION_TYPE, CHANNEL, DROP_STRUCTURE,

PIPE_BARREL, WEIR, ICPR_LINK_RESULT, ICPR_LINK_HYDROGRAPH)

ICPR_NODE_NAME (ICPR_NODE_RESULT, ICPR_NODE_HYDROGRAPH)

MUKEY (GWIS_SOIL)

Removed Object Classes (Tables):

GREENAMP_RAINEXCESS, HORTON_EXCESS, NRCS_EXCESS, ORIFICE,

GWIS_GATE, WEIR_VARIABLE, GATE_VARIABLE, ELEVATION_RATE,

BOUND_EDGE_DISCHARGE, JUNCTION_BOUNDDISCHARGE,

JUNCTION_BOUNDELEVATION, JUNCTION_STORAGE, EDGE_RESULT,

EDGE_HYDROGRAPH, JUNCTION_RESULT, JUNCTION_HYDROGRAPH,

Removed Relationship Classes:

CatchmentHasGreenampExcess, CatchmentHasHortonExcess,

CatchmentHasNRCSExcess, OrificeHasHydraulicElementPoints,

HydroJunctionHasWeirVariables, HydroJunctionHasElevationRates,

HydroJunctionHasGWISFlood, HydroJunctionHasJunctionBoundDischarges,

HydroJunctionHasJunctionStorage, GateHasHydraulicElementPoints,

HydroJunctionHasJunctionBoundElevations, HydroJunctionHasGates,

HydroJunctionHasJunctionHydrographs, HydroJunctionHasGateVariables,

HydroJunctionHasJunctionResults, HydroEdgeHasEdgeHydrographs,

HydroEdgeHasEdgeResults, HydroEdgeHasBoundEdgeDischarges

Removed Domains:

dRXCESS, dOrificeOrientation, dOrificeShape,

Removed Fields:

JUNTIONID (GWIS_FLOOD)

FLOW_DIRECTION_DESC (BRIDGE_DECK, CHANNEL, WEIR, PIPE_BARREL)

INITIAL_WATERSURFACE_MS, INITIAL_FLOW_MS, BASE_FLOW_TXT,

EVAPORATION_TXT, FLOOD_ELEVATION_VAL (HYDROJUNCTION)

Attribute TSTYPE_CD – Changed to TSTYPEID (TIMESERIES, TSTYPE)

Attribute TSDATETIME_DT – Changed to TSDATETIME (TIMESERIES)

Attribute TSTVALUE_MS – Changed to TSVALUE (TIMESERIES)

Attribute WEIR_TOPLENGTH_MS – Changed to WEIR_TOP_WIDTH_MS (WEIR)

Domain dWEIRORIENTATION – Modified codes to match ICPR options

Domain dINLETDESC – Modified codes to match ICPR options

Domain dROADSURFACE – Modified codes to match ICPR options

Domain dINCLUDECONNECT – Changed from string to integer

GWIS Version: 1.6



Dec.

2012

Jan.

2013

Mar.

2013

Oct.

2013

Apr.

2014

1.6 (cont.)

1.6 (cont.)

1.6 (cont.)

1.6 (cont.)

1.6 (cont.)

Minor spelling corrections within Data Dictionary

Field name GROUP changed to ICPR_GROUP for all ICPR features – “Group” is a reserved

word for SDE and cannot be used

Attribute WEIR_BOTTOM_WIDTH_MS – Changed units from inches to feet (WEIR)

Attribute STRUCTURE_OPENING_MS – Changed from Long integer to Double (WEIR)

Domain dPOINTTYPE_GENERALPOINTS – Expanded list of codes

Domain dEDGEHYDRAULICTYPE – added Shallow Concentrated (SC) code

Domain dICPR_NODETYPE – added codes for Channel, Weir, Pipe, and Drop Structure for

use with Arc Hydro GeoICPR tools

Domain dPIPEMATERIAL – added codes for clay and HDPE

Added Fields: FEMA_ZONE, FTYPE, SOURCE, BFE, DESCRIPTION (GWIS_FLOOD)

Added Domains: dFEMA_ZONE, dFTYPE (GWIS_FLOOD)

Added Tables: VariableDefinition, TimeSeries – to match Arc Hydro Time Series schema

Feature Class HIGHWATERMARK – changed name to HISTORICAL_WATER_LEVELS

Tables ICPR_NODE_HYDROGRAPH and ICPR_LINK_HYDROGRAPH – modified to match time series format

--------------------------------------------------------------------------------------------------

Attribute FTYPE (GWIS_FLOOD) – Increased length to 50

Added Field: LEV4 (GWIS_LANDUSE)

Removed Field: FLUCSDESC2 (GWIS_LANDUSE)

--------------------------------------------------------------------------------------------------

Tables ICPR_NODE_HYDROGRAPH and ICPR_LINK_HYDROGRAPH – changed

TIME_VAL field format from Date to Double

--------------------------------------------------------------------------------------------------

Removed Field:

CORRESPONDING_DEPTH_MS (CHANNEL)

Added Fields:

US_CORRESPONDING_DEPTH_MS (CHANNEL)

DS_CORRESPONDING_DEPTH_MS (CHANNEL)

--------------------------------------------------------------------------------------------------

Domain dFTYPE – changed Description from TRANSITION ZONES to TRANSITION ZONE

JDJ

JDJ

JDJ

JDJ

JDJ

GWIS Version: 1.6



GWIS Version: 1.6



Table of Contents

1. Introduction 10

1.1 Purpose 10

2. Database Design 10

2.1 Basin 10

2.1.1 Feature Class(es): 11

2.1.2 Domain(s): 11

2.1.3 Relationship Classes: 11

2.1.4 Business Tables (Object Classes): 12

2.2 Watershed 12


2.2.2 Domain(s): 15



2.3 Topographic Information (TopographicInformation) 15


2.3.2 Domain(s): 20



2.4 Hydrographic Network (HydroNetwork) 20


2.4.2 Domain(s): 22



2.5 Time Series 25


2.5.2 Domain(s): 26



2.6 SubElements: 27


2.6.2 Domain(s): 28



GWIS Version: 1.6



2.7 Hydraulic Element Points: 40


2.7.2 Domain(s): 44



2.8 Model: 46


2.8.2 Domain(s): 49



2.9 Metadata 66


2.9.2 Domain(s): 66



2.10 Arc Hydro Generated Information 67


2.10.2 Domain(s): 67



GWIS Version: 1.6



Database Design Document

1. Introduction

Since the establishment of the Southwest Florida Water Management District (District) in the 1960s,

the District has been involved in evolving efforts to understand how a watershed responds to the

hydrologic cycle. These efforts include data analysis and modeling, which are just some of the

components in the Watershed Management Program (WMP) as administered by the Resource

Management Engineering Section. As a result of these efforts, a centralized, standardized

database supporting business and spatial data has been identified as necessary for the storage,

sharing, maintenance, and history requirements of the WMP.

The database design presented here originated from the Arc Hydro surface water resources data

model as developed by the Center for Water Resources Consortium and Environmental Systems

Research Institute (ESRI). The core Arc Hydro data model was evaluated for District surface water

requirements and expanded on to meet the user requirements and business processes of the

WMP. Initial database design efforts were completed by ESRI staff, however, elaboration of

requirements necessitated enhancements and modifications completed by District staff. The

database design will be further refined in the future to meet groundwater and water quality modeling

requirements at the District, and as such, has been branded the Geographic Watershed Information

System (GWIS) to encompass the integrated watershed information.

1.1 Purpose

This document provides a comprehensive overview of the GWIS surface water database design. It is intended to capture and convey the business and spatial datasets to support the WMP. While expanded from the default Arc Hydro data model, the GWIS database design has maintained the key features to ensure the ESRI tools, developed to support Arc Hydro activities, still work with this design. These features include: field names/types, relationship classes and ESRI domains. As many of these features are inherent to the ESRI environment, it has been determined all business tables will be maintained within ArcSDE. This deviates from other efforts to keep the ArcSDE data layers thin and business data outside of ArcSDE.

2. Database Design

The following sections identify the specific GWIS database design. The design is presented by:

Feature Dataset, Feature Class, ESRI Domains, ESRI Relationship Class and Business Table

(Object Class). The following sections are presented as the Five (5) ESRI Feature Datasets in the

database design including: Basin, Watershed, Topographic Information, Hydrographic Network,

and Model. The Feature Datasets are followed by the additional datasets implemented to support

Time Series, Hydraulic Features, Model Results, Metadata and Hyperlinks.

2.1 Basin

The Basin Feature Dataset includes the general information associated with the catchment

delineations. The catchments are spatial features captured either by digitizing from contour maps

or from automated delineation using the underlying topographic information and Arc Hydro tools in

ArcGIS. Ridgelines, hydraulic control structures, storage areas and local collection networks are

some of the features used for determining the criteria for catchment delineation.

GWIS Version: 1.6



2.1.1 Feature Class(es):

Simple feature classCATCHMENT Contains Z values

Contains M valuesGeometry Polygon

NoNo

Data typeField namePrec-ision Scale LengthDomainDefault value

Allow nulls

OBJECTID Object ID

Shape Geometry Yes

HYDROID Long integer Yes 0

HYDROCODE_DESC String Yes 30

CATCHMENT_ACRES_MS Double Yes 0 0

METADATA_ID Long integer Yes 0

JUNCTIONID Long integer Yes 0

WATERSHED_NAME String Yes 55

SUBWATERSHED_NAME String Yes 55

Shape_Length Double Yes 0 0

Shape_Area Double Yes 0 0

OBJECTID ESRI Internal Feature Number

Shape ESRI Internally Defined Geometric Shape

HYDROID Identifier Unique Across the Entire Database (Assigned and Managed by ArcHydro Tools)

HYDROCODE_DESC User Assigned Identifier to Connect the Feature to External Systems

CATCHMENT_ACRES_MS Area of the Feature (acres)

METADATA_ID Foreign Key Identifier Associating the Feature to the Metadata Table

JUNCTIONID HYDROID of the HydroJunction Associated with the Basin Feature

WATERSHED_NAME Name of the Watershed (Note: use the dissolve tool and this field to create a watershed

boundary)

SUBWATERSHED_NAME Name of Sub Watershed (Major Tributary)

Shape_Length ESRI Internally Calculated Length (Perimeter) of the Feature in Internal Units

Shape_Area ESRI Internally Calculated Area of the Feature in Internal Units Squared

2.1.2 Domain(s):

None identified.

2.1.3 Relationship Classes:

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label

No relationship rules defined.

CatchmentHasMetadata

Origin feature class Destination table

Simple

One to many

None

METADATA

CATCHMENT

CATCHMENT

METADATA_ID

METADATA_ID

GWIS_METADATAName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


CatchmentHasRainfallDistribution


Simple

One to many

None

RAINFALL_DISTRIBUTION

CATCHMENT

CATCHMENT

HYDROID

FEATUREID

RAINFALL_DISTRIBUTIONName

GWIS Version: 1.6



2.1.4 Business Tables (Object Classes):

TableRAINFALL_DISTRIBUTION


Allow nulls

OBJECTID Object ID

FEATUREID Long integer Yes 0


RAINFALL_SITE_ID Short integer Yes 0

SITE_NAME String Yes 30

RAINFALL_DISTRIBUTION_1DAY_MS String Yes 30




RAINFALL_CALIBRATION_MS String Yes 30


FEATUREID HYDROID of the Catchment Associated with the Rainfall Distribution


RAINFALL_SITE_ID District’s Site ID

SITE_NAME Name of Rainfall Gauge

RAINFALL_DISTRIBUTION_1DAY_MS 1-Day Rainfall




RAINFALL_CALIBRATION_MS Calibration Rainfall

2.2 Watershed

The Watershed Feature Dataset includes information about the environment and current

conditions within the watershed project boundary. This information is commonly intersected with

each other to calculate values required as part of the WMP analysis such as projecting runoff and

overland flows. Enterprise Geographic Information Systems (GIS) data at the District will be

extracted and used as the initial input data for some of these efforts. As the Enterprise GIS data

reflects the conditions at a given period of time, these data layers will be updated to reflect the

conditions during the WMP effort and will be maintained within the GWIS. The GWIS Flood

boundaries are non-Enterprise GIS data layers and are delineated based on the results of the

WMP efforts. These flood boundaries are submitted to the Federal Emergency Management

Agency (FEMA) for adoption as the official flood boundary.


Simple feature classGWIS_FLOOD Contains Z values


NoNo


Allow nulls

OBJECTID Object ID

Shape Geometry Yes


FEMA_ZONE String Yes dFEMA_ZONE 20

FTYPE String Yes dFTYPE 50

SOURCE String Yes 50

BFE Double Yes 0 0

DESCRIPTION String Yes 255

NAME String Yes 15



GWIS Version: 1.6





HYDROID Identifier unique across the entire database (assigned and managed by Arc Hydro tools)

FEMA_ZONE FEMA Flood Zone Designation (see Domain: dFEMA_ZONE)

FTYPE Flood Type Designation (see Domain: dFTYPE)

SOURCE Storm Duration and Frequency

BFE Base Flood Elevation

DESCRIPTION Description

NAME Name of Corresponding Model Node



Simple feature classGWIS_LANDUSE Contains Z values


NoNo


Allow nulls

OBJECTID Object ID

Shape Geometry Yes

LANDUSE_ACRES_MS Double Yes 0 0

FLUCCSCODE Short integer Yes 0

FLUCSDESC String Yes 55

DATESTAMP Date Yes 0 0 8

LEV1 Short integer Yes 0








LANDUSE_ACRES_MS Area of the Feature (acres)

FLUCCSCODE Character Description of the Land Use/Cover Classification Code as Defined in the Florida Department of

Transportation (FDOT) Florida Land Use and Cover Classification System (FLUCCS). This is also

considered Level 4.

FLUCSDESC Character Description of the FLUCCSCODE

DATESTAMP The Date the Feature was Last Edited or Entered into the Map Libraries, Maintained by User

LEV1 Very General Classification of Land Use/Cover as Defined in the FDOT's FLUCCS Classification System

LEV2 More Detailed than Lev 1 as Defined in the FDOT's FLUCCS Classification System

LEV3 Detailed Classification as Defined in the FDOT's FLUCCS Classification System

LEV4 Detailed Classification as Defined in the FDOT's FLUCCS Classification System



GWIS Version: 1.6



Simple feature classGWIS_SOIL Contains Z values


NoNo


Allow nulls

OBJECTID Object ID

Shape Geometry Yes


MUID String Yes 6

MUKEY String Yes 30

HYDGRP String Yes 3

MUNAME String Yes 80

DATESTAMP Date Yes 0 0 8

COUNTY String Yes 3

SID String Yes 3

SOIL_ACRES_MS Double Yes 0 0





HYDROID Identifier unique across the entire database (assigned and managed by Arc Hydro tools)

MUID Mapping Unit Identifier Defined by the County Identifier and the Soil Identifier, and found in the NRCS county soil

surveys to identify soil types and characteristics

MUKEY Mapping Unit Key

HYDGRP Hydrologic classification group. Used to estimate runoff from precipitation. The four hydrologic groups are A

(high infiltration rate, low runoff), B (moderate infiltration rate), C (slow infiltration rate), D (very slow infiltration

rate, high runoff potential). In some cases, soils will have a dual hydrologic group such as B/D. A B/D listing

means that under natural conditions the soils belongs to hydrologic group D, but by artificial methods the water

table can be lowered sufficiently so that the soil fits in hydrologic group B.

MUNAME Mapping unit name (i.e. Canaveral Fine Sand). Please refer to the soil survey of the county of interest.

DATESTAMP The date the feature was last edited or entered into the map libraries, maintained by user

COUNTY Federal Information Processing Standard (FIPS) code (values 001 - 133, odd numbers only) assigned to

counties in alphabetical order (Alachua to Washington)

SID Soil identifier found in the NRCS soil surveys to identify soil types and characteristics

SOIL_ACRES_MS Area (acres)



Simple feature classGWIS_WATERBODY Contains Z values


NoNo


Allow nulls

OBJECTID Object ID

Shape Geometry Yes



WATERBODY_ACRES_MS Double Yes 0 0


WATERBODY_NAME String Yes 55

WATERBODY_ELEVATION_MS Double Yes 0 0

LAKETYPE_DESC String Yes dLAKETYPE 255








WATERBODY_ACRES_MS Area of Water Body (acres)

GWIS Version: 1.6




WATERBODY_NAME Name of Water Body

WATERBODY_ELEVATION_MS Elevation of Water Body (ft)

LAKETYPE_DESC Lake type description (see Domain: dLAKETYPE)

JUNCTIONID HYDROID of the HydroJunction Associated with the Water Body Feature



2.2.2 Domain(s):

Coded value domain

dFEMA_ZONEDescription

Field type

Split policy

Merge policy

String

Default value

Default value

DescriptionCode

A A

AE AE

AH AH

AO AO

D D

V V

VE VE

X X

X (Shaded) X (Shaded)

Coded value domain

dLAKETYPEDescription

Field type

Split policy

Merge policy

String

Default value

Default value

DescriptionCode

LAKE LAKE

POND POND

WET WETLAND

SMSA SMSA

RES RESERVOIR

Coded value domain

dFTYPEDescription

Field type

Split policy

Merge policy

String

Default value

Default value

Desc riptionCode

FLOODPLAIN FLOODPLAIN

TRANSITION ZONE TRANSITION ZONE

NEW DEVELOPMENT AREAS NEW DEVELOPMENT AREAS


Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


GWISWaterbodyHasHydroJunctions

Origin feature class Destination feature class

Simple

One to many

None

HYDROJUNCTION

GWIS_WATERBODY

HYDROJUNCTION

HYDROID

JUNCTIONID

GWIS_WATERBODYName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


GWISWaterbodyHasMetadata


Simple

One to many

None

METADATA

GWIS_WATERBODY

GWIS_WATERBODY

METADATA_ID

METADATA_ID

GWIS_METADATAName


None identified.

2.3 Topographic Information (TopographicInformation)

Topographic information is the base from which much of the GWIS information is generated.

Topographic information defines the elevations of the surface including bathymetric data. The

District has mapped elevation for the majority of its jurisdictional area, however, this information is

GWIS Version: 1.6



outdated and mostly in hardcopy format. The WMP allows for the generation of digital topographic

information by digitizing the hardcopies into ESRI compatible formats or, more commonly, the

acquisition of new topographic information utilizing Light Detection and Ranging (LiDAR)

technology. The presented database design will accommodate for either approach.

In ESRI’s 9.2 and 9.3 releases, terrain datasets manage large datasets produced by LiDAR

deliverables. The database design for topographic information in the GWIS is based from the

District’s terrain geodatabase design, developed for management of the large LiDAR datasets and

compatible with ESRI’s terrain implementation. As can be identified from the database design, the

datasets are predominantly Z-enabled, allowing for the coordinates to be integrated into the shape

of the feature. As a result of Z-enabling, the database design only requires the Datestamp field for

data management purposes. This design allows for the input of: LiDAR masspoints, breaklines

and contours. Breaklines may include: coastal shorelines, hydrographic features, islands within

waterbodies, overpasses/bridges, roads and soft features. In addition to these features, the GWIS

has included exclusion areas, which will be used when calculating volume information for the

catchment.


Simple feature classCOASTALSHORELINE Contains Z values

Contains M valuesGeometry Polyline

NoYes


Allow nulls

OBJECTID Object ID

Shape Geometry Yes

DATESTAMP_DT Date Yes 0 0 8




DATESTAMP_DT Date Feature was added to Geodatabase


Simple feature classCONTOUR Contains Z values


NoNo


Allow nulls

OBJECTID Object ID

Shape Geometry Yes

CONTOUR_ELEVATION_MS Double Yes 0 0

CARRYING_CONTOUR_ELEVATION_MS Double Yes 0 0

CONTOUR_TYPE_DESC String Yes dCONTOURTYPE 2





CONTOUR_ELEVATION_MS Elevation of the Feature (ft)

CARRYING_CONTOUR_ELEVATION_MS Carrying Elevation of Contour (ft)

CONTOUR_TYPE_DESC Type of Contour (see Domain: dCONTOURTYPE)



GWIS Version: 1.6



Simple feature classHYDROGRAPHICFEATURE Contains Z values


NoYes


Allow nulls

OBJECTID Object ID

Shape Geometry Yes







Simple feature classISLAND Contains Z values


NoYes


Allow nulls

OBJECTID Object ID

Shape Geometry Yes









Simple feature classMASSPOINT Contains Z values

Contains M valuesGeometry Multipoint

NoYes


Allow nulls

OBJECTID Object ID

Shape Geometry Yes





Simple feature classLOWCONFIDENCEAREAS Contains Z values


NoNo


Allow nulls

OBJECTID Object ID

Shape Geometry Yes









GWIS Version: 1.6



Simple feature classOVERPASS Contains Z values


NoYes


Allow nulls

OBJECTID Object ID

Shape Geometry Yes







Simple feature classROADBREAKLINE Contains Z values


NoYes


Allow nulls

OBJECTID Object ID

Shape Geometry Yes







Simple feature classSOFTFEATURE Contains Z values


NoYes


Allow nulls

OBJECTID Object ID

Shape Geometry Yes







Simple feature classSTORAGE_EXCLUSION Contains Z values


NoNo


Allow nulls

OBJECTID Object ID

Shape Geometry Yes









GWIS Version: 1.6



Simple feature classWATERBODY Contains Z values


NoYes


Allow nulls

OBJECTID Object ID

Shape Geometry Yes

WATERBODY_ELEVATION_MS Double Yes 0 0






WATERBODY_ELEVATION_MS Elevation of Water Body (ft)




Simple feature classTOPOGRAPHIC_BOUNDARY Contains Z values


NoNo


Allow nulls

OBJECTID Object ID

Shape Geometry Yes


WATERSHED_NAME String Yes 55






WATERSHED_NAME Name of the Watershed



Simple feature classLIDARPROJECTGRID Contains Z values


NoNo


Allow nulls

OBJECTID Object ID

Shape Geometry Yes

SQMILES Double Yes 0 0

FY06_CELLNUM Long integer Yes 0

FY05_CELLNUM Long integer Yes 0






SQMILES The area in square miles for each grid cell

FY06_CELLNUM Unique identifier for each cell used for FY_2006 projects

FY05_CELLNUM Unique identifier for each cell used for FY_2005 projects




* Note: the LIDARPROJECTGRID is a 5000’ by 5000’ State Plane Feet tiling scheme used to define the spatial extent of Terrain datasets, rasters, etc.

GWIS Version: 1.6



2.3.2 Domain(s):

Coded value domain

dCONTOURTYPEDescription

Field type

Split policy

Merge policy

String

Default value

Default value

DescriptionCode

1 NORMAL

2 CARRYING

3 SUPPLEMENTARY

4 DEPRESSION


None identified.


None identified.

2.4 Hydrographic Network (HydroNetwork)

The datasets implemented in the Hydrographic Network Feature Dataset are used to support the

generation of the hydrologic geometric network, which provides the connectivity between features

to identify which direction water flows. This includes the HydroEdges and HydroJunction feature

classes along with related business tables that present some of the parameters and results

developed throughout the WMP activities.

These feature classes, along with the associated datasets implemented to support Hydraulic

Features in the next session, form the hierarchical representation of watershed characteristics

within the database. The top level of the hierarchy includes the HydroEdges and HydroJunction

feature classes. The HydroEdge dataset may represent the natural flow of water (such as a stream)

or a man-made flow feature such as a channel. The HydroJunction dataset may represent the low

point of a catchment, junction at the outflow of a water body or the location of a hydraulic structure.

Typically, hydraulic structures are comprised of more than one sub-element (second level of the

hierarchy and presented as business tables in the next section) such as multiple weirs associated

with a pipe_barrel. The final level of the hierarchy includes the hydraulic element points, which

details the location and information of each of the sub-elements. The use of the Arc Hydro key

field, HydroID, is integral in the maintenance of the relationship of each of the features that

participate in this hierarchy.

HydroEdge/HydroJunction

Hydraulic Element Points

SubElements

General Location

Structure Information Tables

Specific Elevation (Z)

and Location (X,Y)

GWIS Version: 1.6




Simple edge feature classHYDROEDGE Contains Z values


YesNo


Allow nulls

OBJECTID Object ID

Shape Geometry Yes

Enabled Short integer Yes 1 EnabledDomain 0



HYPERLINK_ID Long integer Yes 0

FROMNODE_ID Long integer Yes 0

TONODE_ID Long integer Yes 0


LENGTH_DOWN_MS Double Yes 0 0

FLOW_DIRECTION_DESC String Yes dHYDROFLOWDIRECTIONS 3

HYDROEDGE_TYPE_DESC String Yes dEDGETYPE 8

HYDROEDGE_PLACEMENT_TXT String Yes dPLACEMENTMETHOD 5

HYDROEDGE_HYDRAULIC_TYPE_DESC String Yes dEDGEHYDRAULICTYPE 5

SURFACE_FEATURE_FLG String Yes dAHBOOLEAN 2

INCLUDECONNECT_DESC Long integer Yes dINCLUDECONNECT 255

SYSTEM_SCALE_DESC String Yes dSYSSCALE 255




Enabled Domain Value for whether Feature is Enabled



HYPERLINK_ID Foreign Key Identifier Associating the Feature to the Hyperlink Table

FROMNODE_ID HYDROID of the HydroJunction Associated with the Start of the Hydroedge Feature

TONODE_ID HYDROID of the HydroJunction Associated with the End of the Hydroedge Feature


LENGTH_DOWN_MS Length Downstream to the Next HydroJunction (ft)

FLOW_DIRECTION_DESC Direction of Flow (see Domain: dHYDROFLOWDIRECTIONS)

HYDROEDGE_TYPE_DESC Type of Edge (see Domain: dEDGETYPE)

HYDROEDGE_PLACEMENT_TXT Method of Placement for the Feature (see Domain: dPLACEMENTMETHOD)

HYDROEDGE_HYDRAULIC_TYPE_DESC Type of Hydraulic Feature (see Domain: dEDGEHYDRAULICTYPE)

SURFACE_FEATURE_FLG True/False Flag to Identify if the Feature is on the Surface (True) or Below Ground (False)

INCLUDECONNECT_DESC Used by the Arc Hydro below surface connectivity tool (see Domain: dINCLUDECONNECT)

SYSTEM_SCALE_DESC System Scale of the Feature (see Domain: dSYSSCALE)

Shape_Length ESRI Internally Calculated Length (Perimeter) of Feature in Internal Units

GWIS Version: 1.6



Simple junction feature classHYDROJUNCTION Contains Z values

Contains M valuesGeometry Point

NoNo


Allow nulls

OBJECTID Object ID

Shape Geometry Yes

AncillaryRole Short integer Yes 0





JUNCTION_TYPE_DESC String Yes dJUNCTIONTYPE 10

JUNCTION_PLACEMENT_DESC String Yes dPLACEMENTMETHOD 5

HYDRAULIC_TYPE_DESC String Yes dHYDRAULICTYPE 6

BOTTOM_ELEVATION_MS Double Yes 0 0


NEXTDOWNID Long integer Yes 0

LENGTH_DOWN_MS Double Yes 0 0

INCLUDECONNECT_DESC Long integer Yes dINCLUDECONNECT 255




AncillaryRole Additional Role the HydroJunction may Participate in

Enabled Domain Value for whether Feature is Enabled



HYPERLINK_ID Foreign Key Identifier Associating the Feature to the Hyperlink Table

JUNCTION_TYPE_DESC Type of HydroJunction (see Domain: dJUNCTIONTYPE)

JUNCTION_PLACEMENT_DESC Placement Method Used for HydroJunction (see Domain: dPLACEMENTMETHOD)

HYDRAULIC_TYPE_DESC Type of Hydraulic Structure Represented by HydroJunction (see Domain: dHYDRAULICTYPE)

BOTTOM_ELEVATION_MS Bottom Elevation of HydroJunction (ft)


NEXTDOWNID HYDROID of the next HydroJunction Downstream

LENGTH_DOWN_MS Length Downstream to the Next HydroJunction (ft)

INCLUDECONNECT_DESC Used by the Arc Hydro below surface connectivity tool (see Domain: dINCLUDECONNECT)


2.4.2 Domain(s):

Coded value domain

dHYDROFLOWDIRECTIONSDescription

Field type

Split policy

Merge policy

String

Default value

Default value

DescriptionCode

1 WITHDIGITIZED

2 AGAINSTDIGITIZED

3 INDETERMINATE

0 UNINITIALIZED

Coded value domain

dEDGETYPEDescription

Field type

Split policy

Merge policy

String

Default value

Default value

DescriptionCode

FLOW FLOWLINE

SHORE SHORELINE

HYD HYDRAULIC ELEMENT

Coded value domain

dPLACEMENTMETHODDescription

Field type

Split policy

Merge policy

String

Default value

Default value

DescriptionCode

AH ARCHYDRO

MAN MANUAL

Coded value domain

dEDGEHYDRAULICTYPEDescription

Field type

Split policy

Merge policy

String

Default value

Default value

DescriptionCode

CHAN CHANNEL

CON CONDUIT

SC SHALLOW CONCENTRATED

GWIS Version: 1.6



Coded value domain

dAHBOOLEANDescription

Field type

Split policy

Merge policy

String

Default value

Default value

DescriptionCode

1 TRUE

0 FALSE

Coded value domain

EnabledDomainDescription

Field type

Split policy

Merge policy

Short integer

Default value

Default value

DescriptionCode

0 False

1 True

Coded value domain

dSYSSCALEDescription

Field type

Split policy

Merge policy

String

Default value

Default value

DescriptionCode

LOCAL LOCAL

INTERMEDIATE INTERMEDIATE

REGIONAL REGIONAL

Long integer

Default value

Default value

String

Default value

Default value

Coded value domain

dINCLUDECONNECTDescription

Field type

Split policy

Merge policy

DescriptionCode

1 TRUE

0 FALSE

Long integer

Default value

Default value

Coded value domain

dHYDRAULICTYPEDescription

Field type

Split policy

Merge policy

String

Default value

Default value

DescriptionCode

NONE NONE

BRID BRIDGE

CULV CULVERT

CS CONTROL STRUCTURE

NO NATURAL OVERFLOW

DAM DAM

LEV LEVEE

INLET INLET/OUTLET

MAN MANHOLE

STOR STORAGE

Coded value domain

dJUNCTIONTYPEDescription

Field type

Split policy

Merge policy

String

Default value

Default value

DescriptionCode

LPOBASIN LOW POINT OF BASIN

LPOBOUND LOW POINT OF BOUNDARY

CON CONFLUENCE

HE HYDRAULIC ELEMENT


Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


HydroEdgeHasChannels


Simple

One to many

None

CHANNEL

HYDROEDGE

HYDROEDGE

HYDROID

HYDROEDGEID

CHANNELName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


HydroEdgeHasHyperLinks


Simple

One to many

None

HYPERLINK

HYDROEDGE

HYDROEDGE

HYPERLINK_ID

HYPERLINK_ID

HYPERLINKName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


HydroEdgeHasMetadata


Simple

One to many

None

METADATA

HYDROEDGE

HYDROEDGE

METADATA_ID

METADATA_ID

GWIS_METADATAName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


HydroEdgeHasPipeBarrels


Simple

One to many

None

PIPE_BARREL

HYDROEDGE

HYDROEDGE

HYDROID

HYDROEDGEID

PIPE_BARRELName

GWIS Version: 1.6



Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


HydroEdgeHasHydraulicElementPoints


Simple

One to many

None

HYDRAULIC_ELEMENT_POINT

HYDROEDGE

HYDROEDGE

HYDROID

HYDROEDGEID

HYDRAULIC_ELEMENT_POINTName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


HydroJunctionHasBridgeDecks


Simple

One to many

None

BRIDGE_DECK

HYDROJUNCTION

HYDROJUNCTION

HYDROID

JUNCTIONID

BRIDGE_DECKName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


HydroJunctionHasDropStructure


Simple

One to one

None

DROP_STRUCTURE

HYDROJUNCTION

HYDROJUNCTION

HYDROID

JUNCTIONID

DROP_STRUCTUREName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


HydroJunctionHasCatchments


Simple

One to one

None

HYDROJUNCTION

CATCHMENT

HYDROJUNCTION

HYDROID

JUNCTIONID

CATCHMENTName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


HydroJunctionHasHyperLinks


Simple

One to many

None

HYPERLINK

HYDROJUNCTION

HYDROJUNCTION

HYPERLINK_ID

HYPERLINK_ID

HYPERLINKName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


HydroJunctionHasHydraulicElementPoints


Simple

One to many

None


HYDROJUNCTION

HYDROJUNCTION

HYDROID

JUNCTIONID


Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


HydroJunctionHasWeirs


Simple

One to many

None

WEIR

HYDROJUNCTION

HYDROJUNCTION

HYDROID

JUNCTIONID

WEIRName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


HydroJunctionHasMetadata


Simple

One to many

None

METADATA

HYDROJUNCTION

HYDROJUNCTION

METADATA_ID

METADATA_ID

GWIS_METADATAName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


HydroJunctionHasPipeBarrels


Simple

One to many

None

PIPE_BARREL

HYDROJUNCTION

HYDROJUNCTION

HYDROID

JUNCTIONID

PIPE_BARRELName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


HydroJunctionHasBridgeOpenings


Simple

One to many

None

BRIDGE_OPENING

HYDROJUNCTION

HYDROJUNCTION

HYDROID

JUNCTIONID

BRIDGE_OPENINGName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


HydroJunctionHasBridgePiers


Simple

One to many

None

BRIDGE_PIER

HYDROJUNCTION

HYDROJUNCTION

HYDROID

JUNCTIONID

BRIDGE_PIERName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


HydroJunctionHasBridgeSpurDikes


Simple

One to many

None

BRIDGE_SPURDIKE

HYDROJUNCTION

HYDROJUNCTION

HYDROID

JUNCTIONID

BRIDGE_SPURDIKEName

GWIS Version: 1.6



Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


HydroJunctionHasBridgeSectionTypes


Simple

One to many

None

BRIDGESECTION_TYPE

HYDROJUNCTION

HYDROJUNCTION

HYDROID

JUNCTIONID

BRIDGESECTION_TYPEName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


HydroJunctionHasGWISFlood


Simple

One to one

None

GWIS_FLOOD

HYDROJUNCTION

HYDROJUNCTION

HYDROID

JUNCTIONID

GWIS_FLOODName


None Identified.

2.5 Time Series

The Time Series dataset is taken from the existing Arc Hydro Time Series database design.

District DBA staff is in the process of making changes and the GWIS database design will be

updated to reflect these changes, if possible, as tools implemented within the Arc Hydro toolbar

are dependent upon the following database design.


Simple feature classSWFWMDONERAIN Contains Z values


NoNo


Allow nulls

OBJECTID Object ID

Shape Geometry Yes








FEATUREID OneRain unique cell number for each 2 km x 2 km cell


Shape.Area ESRI Internally Calculated Area of the Feature in Internal Units Squared

GWIS Version: 1.6



2.5.2 Domain(s):

Coded value domain

dTSDataTypeDescription

Field type

Split policy

Merge policy

String

Default value

Default value

DescriptionCode

Instantaneous Instantaneous

Cumulative Cumulative

Incremental Incremental

Average Average

Maximum Maximum

Minimum Minimum

Coded value domain

dTSTimeUnitsDescription

Field type

Split policy

Merge policy

String

Default value

Default value

DescriptionCode

Second Second

Minute Minute

Hour Hour

Day Day

Week Week

Month Month

Year Year

Other Other


Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


OneRainHasTimeSeries


Simple

One to many

None

TIMESERIES

SWFWMDONERAIN

SWFWMDONERAIN

FEATUREID

FeatureID

TimeSeriesName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


VariableHasTimeSeriesValues

Origin table Destination table

Simple

One to many

None

VariableDefinition

TimeSeries

VariableDefinition

HydroID

VarID

TimeSeriesName


TableTimeSeries


Allow nulls

OBJECTID Object ID

VarID Long integer Yes 0

FeatureID Long integer Yes 0

TSTime Date Yes 0 0 8

UTCOffset Double Yes 0 0

TSValue Double Yes 0 0

TSTime_dbl Double Yes 0 0


VarID Variable ID from the Variable Table (HydroID of the related record in Variable Definition table)

FeatureID HydroID of the Related Feature

TSTime Time Stamp Value (date format)

UTCOffset Coordinated Universal Time (UTC) Offset in Hours

TSValue Time Series Value

TSTime_dbl Time Stamp Value (double format)

GWIS Version: 1.6



TableVariableDefinition


Allow nulls

OBJECTID Object ID

HydroID Long integer Yes 0

VarKey String Yes 50

VarName String Yes 255

VarDesc String Yes 255

VarUnits String Yes 50

Medium String Yes 50

VarCode String Yes 50

Vocabulary String Yes 50

TimeUnits String Yes dTSTimeUnits 50

TimeStep Double Yes 0 0

DataType String Yes dTSDataType 50

NoDataVal Double Yes 0 0

IsRegular Long integer Yes dAHBOOLEAN 0


HydroID Identifier Unique Across the Entire Database (Assigned and Managed by ArcHydro Tools)

VarKey Key or Field Name of the Variables in the Time Series Described

VarName Variable Name

VarDesc Variable Description

VarUnits Variable Units

Medium

VarCode Variable Code According to a Defined Naming Convention

Vocabulary Name of Vocabulary used to link Variable Names and Codes

TimeUnits Time Units Data (see Domain: dTSTimeUnits)

TimeStep Time Step

DataType Type of Time Series Data (see Domain: dTSDataType)

NoDataVal No Data Value

IsRegular Whether the Data are Regularly (True) or Irregularly (False) Measured by Time (see Domain: dAHBOOLEAN)

2.6 SubElements:

The SubElement tables are the middle level of the hierarchy as presented in section 2.4. These

tables provide the details of the subelements, which make up the hydraulic structures. They are

related to the HydroEdge and HydroJunction through the HydroID/JunctionID/HydroEdgeID

relationships.


Simple edge feature classHEP_LINE Contains Z values


YesNo


Allow nulls

OBJECTID Object ID

Shape Geometry Yes


SUBELEMENTID Long integer Yes 0



GWIS Version: 1.6





Enabled Enabled Domain

SUBELEMENTID HYDROID of the Related Sub Element


Shape_Length ESRI Internally Defined Geometric Shape

2.6.2 Domain(s):

Coded value domain

dBRIDGEOPENINGTYPEDescription

Field type

Split policy

Merge policy

Long integer

Default value

Default value

DescriptionCode

0 Vertical embankments and abutments, optional wingwalls

1 Sloping embankments, vertical abutments, no wingwalls

2 Sloping embankments, sloping spillthrough abutments

3 Sloping embankments, vertical abutments, with wingwalls

Coded value domain

dBRIDGESECTIONTYPEDescription

Field type

Split policy

Merge policy

String

Default value

Default value

DescriptionCode

EXIT EXIT

FV FULL VALLEY

APPR APPROACH

ROAD ROADWAY

Coded value domain

dCSHAPEDescription

Field type

Split policy

Merge policy

String

Default value

Default value

DescriptionCode

IRR IRREGULAR

TRAP TRAPEZOIDAL

PARA PARABOLIC

Coded value domain

dCROSSECTIONTYPEDescription

Field type

Split policy

Merge policy

String

Default value

Default value

DescriptionCode

UPGR UPSTREAMGROUND

DNGR DOWNSTREAMGROUND

UPTR UPSTREAMTOPROAD

DNTR DOWNSTREAMTOPROAD

Coded value domain

dPMATERIALDescription

Field type

Split policy

Merge policy

String

Default value

Default value

DescriptionCode

CMP CORRUGATED METAL

RCP CONCRETE

ABS ABS

PVC PVC

STEEL STEEL

HDPE HDPE

CLAY CLAY

Coded value domain

dPSHAPEDescription

Field type

Split policy

Merge policy

Long integer

Default value

Default value

DescriptionCode

0 CIRCULAR

1 HORIZONTAL ELLIPSE

2 VERTICAL ELLIPSE

3 ARCH

4 RECTANGULAR

Coded value domain

dSPURDIKETYPEDescription

Field type

Split policy

Merge policy

Long integer

Default value

Default value

DescriptionCode

0 ELLIPTICAL

1 STRAIGHT

Coded value domain

dROADSURFACEDescription

Field type

Split policy

Merge policy

Long integer

Default value

Default value

DescriptionCode

0 GRAVEL

1 PAVED

GWIS Version: 1.6



Coded value domain

dINLETDESCDescription

Field type

Split policy

Merge policy

Long integer

Default value

Default value

DescriptionCode

0 1 1 Circular Concrete: Square edge w/ headwall

1 1 2 Circular Concrete: Groove end w/ headwall

2 1 3 Circular Concrete: Groove end projecting

3 2 1 Circular CMP: Headwall

4 2 2 Circular CMP: Mitered to slope

5 2 3 Circular CMP: Projecting

6 3 A Circular: Beveled ring, 45 degree bevels

7 3 B Circular: Beveled ring, 33.7 degree bevels

8 8 1 Rectangular Box: 30 degree to 75 degree wingwall flares

9 8 2 Rectangular Box: 90 degree and 15 degree wingwall flares

10 8 3 Rectangular Box: 0 degree wingwall flares

11 9 1 Rectangular Box: 45 degree wingwall flare; d = 0.043D

12 9 2 Rectangular Box: 18 degree to 33.7 degree wingwall flare; d = 0.083D

13 10 1 Rectangular Box: 90 degree headwall w/ 3/4" chamfers

14 10 2 Rectangular Box: 90 degree headwall w/ 45 degree bevels

15 10 3 Rectangular Box: 90 degree headwall w/ 33.7 degree bevels

16 11 1 Rectangular Box: 3/4" chamfers; 45 degree skewed headwall



19 11 4 Rectangular Box: 45 degree bevels; 10 to 45 degree skewed headwall

20 12 1 Rectangular Box: 45 degree non-offset wingwall flares

21 12 2 Rectangular Box: 18.4 degree non-offset wingwall flares

22 12 3 Rectangular Box: 18.4 degree wingwalls w/ 30 degree skewed barrel

23 13 1 Rectangular Box: 45 degree wingwall flares - offset

24 13 2 Top Bevels: 33.7 degree wingwall flares - offset

25 13 3 Rectangular Box: 18.4 degree wingwall flares - offset

26 16-19 1 C M Box: 90 degree headwall

27 16-19 2 C M Box: Thick wall projecting

28 16-19 3 C M Box: Thin wall projecting

29 29 1 Horizontal Ellipse Concrete: Square edge w/ headwall

30 29 2 Horizontal Ellipse Concrete: Groove end w/ headwall

31 29 3 Horizontal Ellipse Concrete: Groove end projecting

32 30 1 Vertical Ellipse Concrete: Square edge w/ headwall

33 30 2 Vertical Ellipse Concrete: Groove end w/ headwall

34 30 3 Vertical Ellipse Concrete: Groove end projecting

35 34 1 Pipe Arch 18" Corner Radius CM: 90 degree headwall

36 34 2 Pipe Arch 18" Corner Radius CM: Mitered to slope

37 34 3 Pipe Arch 18" Corner Radius CM: Projecting


39 35 2 Pipe Arch 18" Corner Radius CM: No bevels

40 35 3 Pipe Arch 18" Corner Radius CM: 33.7 degree bevels


42 36 1 Pipe Arch 31" Corner Radius CM: No bevels

43 36 1 Pipe Arch 31" Corner Radius CM: 33.7 degree bevels

44 40-42 1 Arch CM: 90 degree headwall

45 40-42 2 Arch CM: Mitered to slope

46 40-42 3 Arch CM: Thin wall projecting

47 54 1 Circular: Smooth tapered inlet throat

48 54 2 Circular: Rough tapered inlet throat

49 55 1 Elliptical Inlet Face: Tapered inlet-beveled edges

50 55 2 Elliptical Inlet Face: Tapered inlet-square edges

51 55 3 Elliptical Inlet Face: Tapered inlet-thin edge projecting

52 56 1 Rectangular: Tapered inlet throat

53 57 1 Rectangular Concrete: Side tapered-less favorable edges

54 57 2 Rectangular Concrete: Side tapered-more favorable edges

55 58 1 Rectangular Concrete: Slope tapered-less favorable edges

56 58 1 Rectangular Concrete: Slope tapered-more favorable edges

Coded value domain

dWEIRSHPDescription

Field type

Split policy

Merge policy

String

Default value

Default value

DescriptionCode

RECTANGLE RECTANGULAR

V_NOTCHED V_NOTCHED

HORELLIP HORIZONTAL ELLIPSE

VERTELLIP VERTICAL ELLIPSE

CIRCULAR CIRCULAR

ARCH ARCH

TRAP TRAPEZOIDAL

PARA PARABOLIC

IRREG IRREGULAR

Coded value domain

dWEIRTYPEDescription

Field type

Split policy

Merge policy

String

Default value

Default value

DescriptionCode

BROAD BROAD

SHARP SHARP

Coded value domain

dWEIRMATERIALDescription

Field type

Split policy

Merge policy

String

Default value

Default value

DescriptionCode

CONCRETE CONCRETE

NATURAL NATURAL

PAVED PAVED

Coded value domain

dCMATERIALDescription

Field type

Split policy

Merge policy

String

Default value

Default value

DescriptionCode

CONCRETE CONCRETE

NATURAL NATURAL

Coded value domain

dWEIRORIENTATIONDescription

Field type

Split policy

Merge policy

Long integer

Default value

Default value

DescriptionCode

0 Horizontal

1 Vertical: Mavis Equation

2 Vertical: Fread Equation

3 Vertical: Paved Road

4 Vertical: Gravel Road

GWIS Version: 1.6




Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


BridgeDeckHasHydraulicElementPoints

Origin table Destination feature class

Simple

One to many

None


BRIDGE_DECK

BRIDGE_DECK

HYDROID

SUBELEMENTID


Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


BridgeOpeningHasHydraulicElementPoints


Simple

One to many

None


BRIDGE_OPENING

BRIDGE_OPENING

HYDROID

SUBELEMENTID


Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


BridgePierHasHydraulicElementPoints


Simple

One to one

None


BRIDGE_PIER

BRIDGE_PIER

HYDROID

SUBELEMENTID


Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


WeirHasHydraulicElementPoints


Simple

One to many

None


WEIR

WEIR

HYDROID

SUBELEMENTID


Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


PipeBarrelHasHydraulicElementPoints


Simple

One to many

None


PIPE_BARREL

PIPE_BARREL

HYDROID

SUBELEMENTID


Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


DropStructureHasWeirs


Simple

One to many

None

WEIR

DROP_STRUCTURE

DROP_STRUCTURE

HYDROID

DROPSTRUCTURE_ID

WEIRName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


BridgeSpurDikeHasCrossSection


Simple

One to one

None

IRREGULAR_CROSSSECTION

BRIDGE_SPURDIKE

BRIDGE_SPURDIKE

CROSSSECTION_ID

HYDROID

IRREGULAR_CROSSSECTIONName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


BridgeOpeningHasCrossSection


Simple

One to one

None


BRIDGE_OPENING

BRIDGE_OPENING

UPSTREAM_CROSSSECTION_ID

HYDROID


Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


BridgeSectionTypeHasCrossSection


Simple

One to one

None


BRIDGESECTION_TYPE

BRIDGESECTION_TYPE

CROSSSECTION_ID

HYDROID


Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


DropStructureHasPipeBarrels


Simple

One to many

None

PIPE_BARREL

DROP_STRUCTURE

DROP_STRUCTURE

HYDROID

DROPSTRUCTURE_ID

PIPE_BARRELName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


BridgeOpeningHasBridgePiers


Simple

One to many

None

BRIDGE_PIER

BRIDGE_OPENING

BRIDGE_OPENING

SECTION_NAME

BRIDGE_OPENING_SECTION

BRIDGE_PIERName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


BridgeOpeningHasSpurDike


Simple

One to one

None

BRIDGE_SPURDIKE

BRIDGE_OPENING

BRIDGE_OPENING

SECTION_NAME

BRIDGE_OPENING_SECTION

BRIDGE_SPURDIKEName

GWIS Version: 1.6



Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


WeirHasIrregularWeir


Simple

One to one

None

IRREGULAR_WEIR

WEIR

WEIR

CROSSSECTION_ID

HYDROID

IRREGULAR_WEIRName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


IrregularWeirHasWeirStations


Simple

One to many

None

WEIR_STATIONS

IRREGULAR_WEIR

IRREGULAR_WEIR

HYDROID

FEATUREID

WEIR_STATIONSName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ProfileLineHasProfileStations


Simple

One to many

None

PROFILE_STATIONS

PROFILE_LINE

PROFILE_LINE

HYDROID

FEATUREID

PROFILE_STATIONSName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


IrregularCrossSectionHasCrossSectionStations


Simple

One to many

None

CROSSSECTION_STATIONS



HYDROID

FEATUREID

CROSSSECTION_STATIONSName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


PipeBarrelHasHEPLine


Simple

One to one

None

HEP_LINE

PIPE_BARREL

PIPE_BARREL

HYDROID

SUBELEMENTID

HEP_LINEName


TableBRIDGE_DECK


Allow nulls

OBJECTID Object ID




ROAD_SURFACE_MATERIAL_DESC Long integer Yes dROADSURFACE 0

ROAD_EMBANK_TOPWIDTH_MS Double Yes 0 0

ROAD_UNSUB_WEIRQCOEF_VAL Double Yes 0 0

SUBELEMENT_INDEX_CNT Long integer Yes 0

ICPR_LINK_NAME String Yes 15




JUNCTIONID HYDROID of the Related HydroJunction Associated with the Feature

ROAD_SURFACE_MATERIAL_DESC Description of road material (see Domain: dROADSURFACE)

ROAD_EMBANK_TOPWIDTH_MS Top Width for Road Embankment (ft)

ROAD_UNSUB_WEIRQCOEFF_VAL Road Unsubmerged Weir Q Coefficient

SUBELEMENT_INDEX_CNT Sub-Element Index Count (Used When Multiple Structures Exist at a Single Location)

ICPR_LINK_NAME Name of Associated ICPR Link

GWIS Version: 1.6



TableBRIDGE_OPENING


Allow nulls

OBJECTID Object ID




OPENING_TYPE_DESC Long integer Yes dBRIDGEOPENINGTYPE 0

UPSTREAM_CROSSSECTION_ID Long integer Yes 0

SECTION_NAME String Yes 15

OPENING_INVERT_MS Double Yes 0 0

OPENING_STATION_NBR Double Yes 0 0

OPENING_SKEW_ANGLE_MS Double Yes 0 0

OPENING_EXPANSION_COEF_VAL Double Yes 0 0

OPENING_CONTRACTION_COEF_VAL Double Yes 0 0

OPENING_TOTAL_WIDTH_MS Double Yes 0 0

ORIFICE_DISCHARGE_COEF_VAL Double Yes 0 0

EMBANK_SIDESLOPE_MS Double Yes 0 0

EMBANK_ELEVATION_MS Double Yes 0 0

WINGWALL_ANGLE_MS Double Yes 0 0

WINGWALL_WIDTH_MS Double Yes 0 0

ROUNDING_RADIUS_MS Double Yes 0 0

LTOE_ELEV_MS Double Yes 0 0

RTOE_ELEV_MS Double Yes 0 0

LOW_CHORD_MS Double Yes 0 0






JUNCTIONID HYDROID of the Related HydroJunction

OPENING_TYPE_DESC Bridge Opening Type (see Domain: dBRIDGEOPENINGTYPE)

UPSTREAM_CROSSSECTION_ID HYDROID of the Corresponding Upstream Cross-Section

SECTION_NAME Name of Related ICPR Cross Section

OPENING_INVERT_MS Bridge Opening Invert Elevation (ft) to which Cross-Section is Vertically Adjusted

OPENING_STATION_NBR Bridge Opening Cumulative Distance Increasing from Downstream to Upstream (ft)

OPENING_SKEW_ANGLE_MS Bridge Opening Skew Angle (degrees)

OPENING_EXPANSION_COEF_VAL Bridge Opening Expansion Coefficient

OPENING_CONTRACTION_COEF_VAL Bridge Opening Contraction Coefficient

OPENING_TOTAL_WIDTH_MS Bridge Opening Total Width (ft)

ORIFICE_DISCHARGE_COEF_VAL Bridge Opening Orifice Discharge Coefficient

EMBANK_SIDESLOPE_MS Bridge Opening Embankment Side Slope (horizontal/vertical)

EMBANK_ELEVATION_MS Bridge Opening Embankment Elevation (ft)

WINGWALL_ANGLE_MS Bridge Opening Wing Wall Angle (degrees)

WINGWALL_WIDTH_MS Bridge Opening Wing Wall Width (ft)

ROUNDING_RADIUS_MS Bridge Opening Rounding Radius (ft)

LTOE_ELEV_MS Bridge Opening Left Toe Elevation (ft)

RTOE_ELEV_MS Bridge Opening Right Toe Elevation (ft)

LOW_CHORD_MS Low Chord of the Bridge (ft)



GWIS Version: 1.6



TableBRIDGE_PIER


Allow nulls

OBJECTID Object ID




BRIDGEPIER_ELEVATION_MS Double Yes 0 0

BRIDGEPIER_WIDTH_MS Double Yes 0 0

BRIDGEPIER_DEPTH_MS Double Yes 0 0


BRIDGE_OPENING_SECTION String Yes 15






BRIDGEPIER_ELEVATION_MS Pier Elevation (ft)

BRIDGEPIER_WIDTH_MS Pier Width (ft)

BRIDGEPIER_DEPTH_MS Pier Depth (ft)


BRIDGE_OPENING_SECTION Name of Associated Bridge Opening Cross Section


TableBRIDGE_SPURDIKE


Allow nulls

OBJECTID Object ID



SPURDIKE_TYPE_DESC Long integer Yes dSPURDIKETYPE 0

CROSSSECTION_ID Long integer Yes 0


SPURDIKE_INVERT_MS Double Yes 0 0

SPURDIKE_STATION_NBR Double Yes 0 0

SPURDIKE_SKEW_ANGLE_MS Double Yes 0 0

SPURDIKE_EXPANSION_COEF_VAL Double Yes 0 0

SPURDIKE_CONTRACTION_COEF_VAL Double Yes 0 0


BRIDGE_OPENING_SECTION String Yes 15





SPURDIKE_TYPE_DESC Spur Dike Type (see Domain: dSPURDIKETYPE)

CROSSSECTION_ID HYDROID of the Corresponding Cross-Section


SPURDIKE_INVERT_MS Bridge Spur Invert Elevation (ft) to which Cross-Section is Vertically Adjusted

SPURDIKE_STATION_NBR Spur Dike Station (ft)

SPURDIKE_SKEW_ANGLE_MS Spur Dike Skew Angle (degrees)

SPURDIKE_EXPANSION_COEF_NBR Spur Dike Expansion Coefficient

SPURDIKE_CONTRACTION_COEF_NBR Spur Dike Contraction Coefficient


BRIDGE_OPENING_SECTION Name of Associated Bridge Opening Cross Section


GWIS Version: 1.6



TableBRIDGESECTION_TYPE


Allow nulls

OBJECTID Object ID



SECTION_TYPE_DESC String Yes dBRIDGESECTIONTYPE 5



SECTION_INVERT_ELEVATION_MS Double Yes 0 0

SECTION_STATION_NBR Double Yes 0 0

SECTION_SKEW_ANGLE_VAL Double Yes 0 0

SECTION_EXPANSION_COEF_VAL Double Yes 0 0

SECTION_CONTRACTION_COEF_VAL Double Yes 0 0






SECTION _TYPE_DESC Section Type (see Domain: dBRIDGESECTIONTYPE)


CROSSSECTION_ID HYDROID of the Corresponding Cross-Section

SECTION_INVERT_ELEVATION_MS Cross-Section Invert Elevation (ft)

SECTION _STATION_NBR Cross-Section Station (ft)

SECTION _SKEW_ANGLE_VAL Cross-Section Skew Angle (degrees)

SECTION _EXPANSION_COEF_VAL Cross-Section Expansion Coefficient

SECTION_CONTRACTION_COEF_VAL Cross-Section Contraction Coefficient



TableDROP_STRUCTURE


Allow nulls

OBJECTID Object ID










GWIS Version: 1.6



TableCHANNEL


Allow nulls

OBJECTID Object ID



HYDROEDGEID Long integer Yes 0

CHANNEL_LENGTH_MS Double Yes 0 0

UPSTREAM_SHAPE_DESC String Yes dCSHAPE 10

DOWNSTREAM_SHAPE_DESC String Yes dCSHAPE 10

UPSTREAM_INVERT_ELEVATION_MS Double Yes 0 0

DOWNSTREAM_INVERT_ELEVATION_MS Double Yes 0 0

UPSTREAM_TOPCLIP_REFELEV_MS Double Yes 0 0

DOWNSTREAM_TOPCLIP_REFELEV_MS Double Yes 0 0

UPSTREAM_MANNINGSN_VAL Double Yes 0 0

DOWNSTREAM_MANNINGSN_VAL Double Yes 0 0

UPSTREAM_TOPCLIP_MS Double Yes 0 0

DOWNSTREAM_TOPCLIP_MS Double Yes 0 0

UPSTREAM_BOTTOMCLIP_MS Double Yes 0 0

DOWNSTREAM_BOTTOMCLIP_MS Double Yes 0 0

UPSTREAM_TOPWIDTH_MS Double Yes 0 0

UPSTREAM_LEFTSIDE_SLOPE_MS Double Yes 0 0

UPSTREAM_RIGHTSIDE_SLOPE_MS Double Yes 0 0

UPSTREAM_BOTTOM_WIDTH_MS Double Yes 0 0

DOWNSTREAM_TOP_WIDTH_MS Double Yes 0 0

DOWNSTREAM_LEFTSIDE_SLOPE_MS Double Yes 0 0

DOWNSTREAM_RIGHTSIDE_SLOPE_MS Double Yes 0 0

DOWNSTREAM_BOTTOM_WIDTH_MS Double Yes 0 0

OVERBANK_DEPTH_MS Double Yes 0 0

VELOCITY_COEF_VAL Double Yes 0 0

ENTRANCE_LOSS_VAL Double Yes 0 0

EXIT_LOSS_VAL Double Yes 0 0

MATERIAL_TYPE_DESC String Yes dCMATERIAL 8

US_CORRESPONDING_DEPTH_MS Double Yes 0 0

DS_CORRESPONDING_DEPTH_MS Double Yes 0 0

CONTRACTION_COEF_VAL Double Yes 0 0

EXPANSION_COEF_VAL Double Yes 0 0

US_MAIN_XS_NAME String Yes 15

DS_MAIN_XS_NAME String Yes 15

US_AUX1_ELEV Double Yes 0 0

US_AUX1_XS_NAME String Yes 15

DS_AUX1_ELEV Double Yes 0 0

DS_AUX1_XS_NAME String Yes 15

US_AUX2_ELEV Double Yes 0 0

US_AUX2_XS_NAME String Yes 15

DS_AUX2_ELEV Double Yes 0 0

DS_AUX2_XS_NAME String Yes 15


= attribute corresponding to all channels, regardless of shape

= attribute specific to Parabolic channels

= attribute specific to Irregular channels

= attribute specific to Trapezoidal channels


HYDROID Identifier Unique Across the Entire Database (Assigned by ArcHydro Tools)


HYDROEDGEID HYDROID of the HydroEdge Associated with the Channel

CHANNEL_LENGTH_MS Length of Channel (ft)

UPSTREAM_SHAPE_DESC Upstream Geometry of Cross-Section (see Domain: dCSHAPE)

DOWNSTREAM_SHAPE_DESC Downstream Geometry of Cross-Section (see Domain: dCSHAPE)

UPSTREAM_INVERT_ELEVATION_MS Upstream Invert Elevation (ft)

DOWNSTREAM_INVERT_ELEVATION_MS Downstream Invert Elevation (ft)

UPSTREAM_TOPCLIP_REFELEV_MS Upstream Top Clip Reference Elevation (ft)

GWIS Version: 1.6



DOWNSTREAM_ TOPCLIP_REFELEV_MS Downstream Top Clip Reference Elevation (ft)

UPSTREAM_MANNINGSN_VAL Upstream Manning's N

DOWNSTREAM_MANNINGSN_VAL Downstream Manning's N

UPSTREAM_TOPCLIP_MS Upstream Top Clip Dimension (ft)

DOWNSTREAM_TOPCLIP_MS Downstream Top Clip Dimension (ft)

UPSTREAM_BOTTOMCLIP_MS Upstream Bottom Clip Dimension (ft)

DOWNSTREAM_BOTTOMCLIP_MS Downstream Bottom Clip Dimension (ft)

UPSTREAM_TOPWIDTH_MS Upstream Top Width (ft)

UPSTREAM_LEFTSIDE_SLOPE_MS Upstream Left Side Slope (horizontal/vertical)

UPSTREAM_RIGHTSIDE_SLOPE_MS Upstream Right Side Slope (horizontal/vertical)

UPSTREAM_BOTTOM_WIDTH_MS Upstream Bottom Width (ft)

DOWNSTREAM_ TOPWIDTH_MS Downstream Top Width (ft)

DOWNSTREAM_LEFTSIDE_SLOPE_MS Downstream Left Side Slope (horizontal/vertical)

DOWNSTREAM_RIGHTSIDE_SLOPE_MS Downstream Right Side Slope (horizontal/vertical)

DOWNSTREAM_BOTTOM_WIDTH_MS Downstream Bottom Width (ft)

OVERBANK_DEPTH_MS Over Bank Depth (ft)

VELOCITY_COEF_VAL Velocity Coefficient

ENTRANCE_LOSS_VAL Entrance Loss Coefficient

EXIT_LOSS_VAL Exit Loss Coefficient

MATERIAL_TYPE_DESC Material (see Domain: dCMATERIAL)

US_CORRESPONDING_DEPTH_MS Upstream Corresponding Depth (ft)

DS_CORRESPONDING_DEPTH_MS Downstream Corresponding Depth (ft)

CONTRACTION_COEF_VAL Eddy Loss Contraction Coefficient

EXPANSION_COEF_VAL Eddy Loss Expansion Coefficient

US_MAIN_XS_NAME Name of ICPR Main Upstream Cross Section

DS_MAIN_XS_NAME Name of ICPR Main Downstream Cross Section

US_AUX1_ELEV Elevation of ICPR Auxiliary Upstream Cross Section #1 (ft)

US_AUX1_XS_NAME Name of ICPR Auxiliary Upstream Cross Section #1

DS_AUX1_ELEV Elevation of ICPR Auxiliary Downstream Cross Section #1 (ft)

DS_AUX1_XS_NAME Name of ICPR Auxiliary Downstream Cross Section #1

US_AUX2_ELEV Elevation of ICPR Auxiliary Upstream Cross Section #2 (ft)

US_AUX2_XS_NAME Name of ICPR Auxiliary Upstream Cross Section #2

DS_AUX2_ELEV Elevation of ICPR Auxiliary Downstream Cross Section #2 (ft)

DS_AUX2_XS_NAME Name of ICPR Auxiliary Downstream Cross Section #2


GWIS Version: 1.6



TableWEIR


Allow nulls

OBJECTID Object ID




WEIR_SHAPE_DESC String Yes dWEIRSHP 10

WEIR_TYPE_DESC String Yes dWEIRTYPE 5

WEIR_SPAN_MS Double Yes 0 0

WEIR_RISE_MS Double Yes 0 0

WEIR_INVERT_ELEVATION_MS Double Yes 0 0

CONTROL_ELEVATION_MS Double Yes 0 0

WEIR_BOTTOMCLIP_MS Double Yes 0 0

BOTTOMCLIP_OPTABLE String Yes 15

WEIR_TOPCLIP_MS Double Yes 0 0

TOPCLIP_OPTABLE String Yes 15

WEIR_DISCHARGE_COEF_VAL Double Yes 0 0

WEIRCOEF_OPTABLE String Yes 15

ORIFICE_DISCHARGE_COEF_VAL Double Yes 0 0

ORIFICECOEF_OPTABLE String Yes 15

TIME_VARIABLE_FLG String Yes 2

MATERIAL_TYPE_DESC String Yes dWEIRMATERIAL 8

WEIR_TOP_WIDTH_MS Double Yes 0 0

CORRESPONDING_DEPTH_MS Double Yes 0 0

STRUCTURE_OPENING_MS Double Yes 0

DROPSTRUCTURE_ID Long integer Yes 0



LEFTSIDE_SLOPE_VAL Double Yes 0 0

RIGHTSIDE_SLOPE_VAL Double Yes 0 0

WEIR_BOTTOM_WIDTH_MS Double Yes 0 0

WEIR_ORIENTATION_DESC Long integer Yes dWEIRORIENTATION 0



= attribute corresponding to all weirs, regardless of shape

= attribute specific to Rectangular, Circular, Horizontal Ellipse, Vertical Ellipse, or Arch weirs

= attribute specific to Parabolic weirs

= attribute specific to Irregular weirs

= attribute specific to Trapezoidal weirs




JUNCTIONID HYDROID of the HydroJunction Associated with the Weir

WEIR_SHAPE_DESC Weir Shape (see Domain: dWEIRSHP)

WEIR_TYPE_DESC Weir Type (see Domain: dWEIRTYPE)

WEIR_SPAN_MS Weir Span (in)

WEIR_RISE_MS Weir Rise (in)

WEIR_INVERT_ELEVATION_MS Weir Invert (ft)

CONTROL_ELEVATION_MS Control Elevation (ft)

WEIR_BOTTOMCLIP_MS Weir Bottom Clip (in)

BOTTOMCLIP_OPTABLE Name of Associated ICPR Weir Bottom Clip Operating Table

WEIR_TOPCLIP_MS Weir Top Clip (in)

TOPCLIP_OPTABLE Name of Associated ICPR Weir Top Clip Operating Table

WEIR_DISCHARGE_COEF_VAL Weir Discharge Coefficient

WEIRCOEF_OPTABLE Name of Associated ICPR Weir Coefficient Operating Table

ORIFICE_DISCHARGE_COEF_VAL Orifice Discharge Coefficient

ORIFICECOEF_OPTABLE Name of Associated ICPR Orifice Coefficient Operating Table

TIME_VARIABLE_FLG Time Variable Weir Crest (Yes or No)

GWIS Version: 1.6



MATERIAL_TYPE_DESC Material Type (see Domain: dCMATERIAL)

WEIR_TOP_WIDTH_MS Top Width of Weir (ft)

CORRESPONDING_DEPTH_MS Corresponding Depth (ft)

STRUCTURE_OPENING_MS Distance (ft) Between the Invert of the Structure and the Top (if it has one, else use 9999)

DROPSTRUCTURE_ID HYDROID of the Related Drop Structure

CROSSSECTION_ID HYDROID of the Related Cross-Section


LEFTSIDE_SLOPE_VAL Left Side Slope (horizontal/vertical)

RIGHTSIDE_SLOPE_VAL Right Side Slope (horizontal/vertical)

WEIR_BOTTOM_WIDTH_MS Bottom Width (ft)

WEIR_ORIENTATION_DESC Orientation of the Weir Opening (see Domain: dWEIRORIENTATION)



TablePIPE_BARREL


Allow nulls

OBJECTID Object ID





UPSTREAM_SHAPE_DESC Long integer Yes dPSHAPE 0

UPSTREAM_INVERT_ELEVATION_MS Double Yes 0 0

DOWNSTREAM_SHAPE_DESC Long integer Yes dPSHAPE 0

DOWNSTREAM_INVERT_ELEVATION_MS Double Yes 0 0

UPSTREAM_RISE_MS Double Yes 0 0

DOWNSTREAM_RISE_MS Double Yes 0 0

UPSTREAM_SPAN_MS Double Yes 0 0

DOWNSTREAM_SPAN_MS Double Yes 0 0

UPSTREAM_MANNINGSN_VAL Double Yes 0 0

DOWNSTREAM_MANNINGSN_VAL Double Yes 0 0

UPSTREAM_TOPCLIP_MS Double Yes 0 0

DOWNSTREAM_TOPCLIP_MS Double Yes 0 0

UPSTREAM_BOTTOMCLIP_MS Double Yes 0 0

DOWNSTREAM_BOTTOMCLIP_MS Double Yes 0 0

PIPE_BARREL_LENGTH_MS Double Yes 0 0

DROPSTRUCTURE_ID Long integer Yes 0

ENTRANCE_LOSS_VAL Double Yes 0 0

EXIT_LOSS_VAL Double Yes 0 0

BEND_LOSS_VAL Double Yes 0 0

VELOCITY_HEAD_VAL Double Yes 0 0

LOW_POINT_MS Double Yes 0 0

MATERIAL_TYPE_DESC String Yes dPMATERIAL 5

UPSTREAM_INLET_DESC Long integer Yes dINLETDESC 0

DOWNSTREAM_INLET_DESC Long integer Yes dINLETDESC 0



DROP_PIPE_CNT Long integer Yes 0




JUNCTIONID HYDROID of the HydroJunction Associated with the Pipe/Barrel

HYDROEDGEID HYDROID of the HydroEdge Associated with the Pipe/Barrel

UPSTREAM_SHAPE_DESC Upstream Shape (see Domain: dPSHAPE)

UPSTREAM_INVERT_ELEVATION_MS Upstream Invert (ft)

DOWNSTREAM_SHAPE_DESC Downstream Shape (see Domain: dPSHAPE)

DOWNSTREAM_INVERT_ELEVATION_MS Downstream Invert (ft)

GWIS Version: 1.6



UPSTREAM_RISE_MS Upstream Rise (in)

DOWNSTREAM_RISE_MS Downstream Rise (in)

UPSTREAM_SPAN_MS Upstream Span (in)

DOWNSTREAM_SPAN_MS Downstream Span (in)

UPSTREAM_MANNINGSN_VAL Upstream Manning’s N

DOWNSTREAM_MANNINGSN_VAL Downstream Manning’s N

UPSTREAM_TOPCLIP_MS Upstream Top Clip (in)

DOWNSTREAM_TOPCLIP_MS Downstream Top Clip (in)

UPSTREAM_BOTTOMCLIP_MS Upstream Bottom Clip (in)

DOWNSTREAM_BOTTOMCLIP_MS Downstream Bottom Clip (in)

PIPE_BARREL_LENGTH_MS Length of Pipe/Barrel (ft)

DROPSTRUCTURE_ID HYDROID of the Related Drop Structure

ENTRANCE_LOSS_VAL Entrance Loss Coefficient

EXIT_LOSS_VAL Exit Loss Coefficient

BEND_LOSS_VAL Bend Loss Coefficient

VELOCITY_HEAD_VAL Velocity Head

LOW_POINT_MS Low Point of Road (ft)

MATERIAL_TYPE_DESC Material Type (see Domain: dPMATERIAL)

UPSTREAM_INLET_DESC Upstream Inlet (see Domain: dINLETDESC)

DOWNSTEAM_INLET_DESC Downstream Inlet (see Domain: dINLETDESC)



DROP_PIPE_CNT Number of identical pipe barrels (for use with drop structures only)

TablePROFILE_STATIONS


Allow nulls

OBJECTID Object ID


STATION Double Yes 0 0

ELEV Double Yes 0 0

ISSTATION Long integer Yes 0

TOLERANCE Double Yes 0 0


FEATUREID HYDROID of the Related Profile Line

STATION Station (ft) along Profile Line

ELEV Elevation (ft) along Profile Line

ISSTATION Identifies if Record Participates in the Thinned Set of Points (1 = yes, 0 = no)

TOLERANCE Tolerance used when Thinning the Number of Points Along the Profile Line

TableWEIR_STATIONS


Allow nulls

OBJECTID Object ID



ELEV Double Yes 0 0




GWIS Version: 1.6



FEATUREID HYDROID of the Related Irregular Weir

STATION Station (ft) along Irregular Weir

ELEV Elevation (ft) along Irregular Weir


TOLERANCE Tolerance used by the Tool to Thin the Number of Points Along the Irregular Weir

TableCROSSSECTION_STATIONS


Allow nulls

OBJECTID Object ID



ELEV Double Yes 0 0

MANNINGSN Double Yes 0 0




FEATUREID HYDROID of the Related Irregular CrossSection

STATION Station (ft) along Irregular CrossSection

ELEV Elevation (ft) along Irregular CrossSection


TOLERANCE Tolerance used to Thin the Number of Points Along the Irregular CrossSection

2.7 Hydraulic Element Points:

The last level of the Hydraulic Elements hierarchy is the Hydraulic Element Point. These point

features define the sub elements. They relate back to the HydroEdge and HydroJunction feature

classes and sub element tables. The Hydraulic Element Points are divided into sub types. The

table below shows the sub types with their corresponding point types and associated sub element

tables.

SUB TYPE POINT TYPE SUBELEMENT TABLE

BARREL UIC, DIC PIPE_BARREL

PIPE UIC, DIC PIPE_BARREL

WEIR WC WEIR

BRIDGE DECK TR, ERM, RAIL, USSTRUCT, DSSTRUCT BRIDGE_DECK

BRIDGE OPENING LC, DSINV, BEGIN, END, TOE BRIDGE_OPENING

BRIDGE PIER PIER BRIDGE_PIER

GENERAL POINTS GR, ERM, TR, DG, CL, TB, BS, TS, BR, BRS, BRT, OTHER

none

GWIS Version: 1.6




Simple junction feature classHYDRAULIC_ELEMENT_POINT Contains Z values


NoNo


Allow nulls

OBJECTID Object ID

Shape Geometry Yes




SUBELEMENTID Long integer Yes 0

SUBELEMENT_TYPE Long integer Yes 4 0





HYDRAULIC_ELEMENT_METADATA_ID Long integer Yes 0

POINT_TYPE_DESC String Yes 10

ELEMENTX Double Yes 0 0

ELEMENTY Double Yes 0 0

ELEMENTZ Double Yes 0 0


GENERAL_COMMENT String Yes 255

Default value

List of defined default values and domains for subtypes in this class

DomainField nameSubtype

CodeSubtype

Description

Default subtype

Subtype field

Subtypes of HYDRAULIC_ELEMENT_POINT

SUBELEMENT_TYPE

1

1 BARREL

Enabled 1 EnabledDomain

SUBELEMENT_TYPE 1 dHEP_SUBELEMENTTYPE

POINT_TYPE_DESC UIC dPOINTTYPE_PIPEBARREL

2 PIPE



POINT_TYPE_DESC UIC dPOINTTYPE_PIPEBARREL

3 WEIR



POINT_TYPE_DESC WC dPOINTTYPE_WEIR

4 BRIDGE DECK



POINT_TYPE_DESC TR dPOINTTYPE_BRIDGEDECK

5 BRIDGE OPENING



POINT_TYPE_DESC LC dPOINTTYPE_BRIDGEOPENING

6 BRIDGE PIER



POINT_TYPE_DESC PIER dPOINTTYPE_BRIDGEPIER

7 GENERAL POINTS



POINT_TYPE_DESC GR dPOINTTYPE_BRIDGEOPENING



Enabled Enabled Domain


SUBELEMENTID HYDROID of the Sub-Element Associated with the Hydraulic Element Point

SUBELEMENT_TYPE Sub-Element Type Associated with the Feature

METADATA_ID Foreign Key Identifier to Metadata Table

HYPERLINK_ID Foreign Key Identifier to Hyperlink Table

JUNCTIONID HYDROID of the HydroJunction Associated with the Feature

HYDROEDGEID HYDROID of the HydroEdge Associated with the Feature

HYDRAULIC_ELEMENT_METADATA_ID Foreign Key Identifier to Hydraulic Element Metadata Table

POINT_TYPE_DESC Type of Shot Represented by Point (see Domain: dPOINTTYPE)

ELEMENTX X-Coordinate of the Feature

ELEMENTY Y-Coordinate of the Feature

ELEMENTZ Z-Coordinate of the Feature


GENERAL_COMMENT General comment field

GWIS Version: 1.6



Simple feature classHISTORICAL_WATER_LEVELS Contains Z values


NoNo


Allow nulls

OBJECTID Object ID

Shape Geometry Yes



XCOORDINATE Double Yes 0 0

YCOORDINATE Double Yes 0 0

POINT_TYPE String Yes dHIGHWATERTYPE 25

ELEVATION Double Yes 0 0

EVENT_DATE String Yes 25

SOURCE String Yes 100

SOURCE_DATE String Yes 25

DATUM_CONVERSION Double Yes 0 0

BENCH_ADJUSTMENT Double Yes 0 0

TOTAL_ADJUSTMENT Double Yes 0 0

ELEV_NAVD88 Double Yes 0 0

CORRECTION_COMMENT String Yes 255

GENERAL_COMMENT String Yes 255





XCOORDINATE X-Coordinate of the Point (Easting)

YCOORDINATE Y-Coordinate of the Point (Northing)

POINT_TYPE Type of High Water Mark Represented by Point (see Domain: dHIGHWATERTYPE)

ELEVATION Recorded Elevation (ft)

EVENT_DATE Date of the Storm Event Corresponding to the High Water Mark, if known

SOURCE Source of Record (Field Survey, Department of Transportation Roadway Plans, etc.)

SOURCE_DATE Source Date (Field Survey Date, Date of DOT Plans, etc.)

DATUM_CONVERSION Datum Conversion (ft) used to convert Recorded Elevation to NAVD88, if necessary

BENCH_ADJUSTMENT Benchmark Adjustment (ft), used for gage add-ons, known adjustments, etc.

TOTAL_ADJUSTMENT Sum of Datum_Conversion and Bench_Adjustment fields (ft)

ELEV_NAVD88 Elevation (ft) in NAVD88

CORRECTION_COMMENT Comment Field used to describe the Datum and Bench Adjustments, if necessary

GENERAL_COMMENT General Comments

Simple feature classIRREGULAR_WEIR Contains Z values


YesYes


Allow nulls

OBJECTID Object ID

Shape Geometry Yes



NONFILTERED_AREA Double Yes 0 0

FILTERED_AREA Double Yes 0 0






NONFILTERED_AREA Cross-Sectional Area (ft2) of the Non-Thinned Irregular CrossSection

FILTERED_AREA Cross-Sectional Area (ft2) of the Thinned Irregular CrossSection


GWIS Version: 1.6



Simple feature classIRREGULAR_CROSSSECTION Contains Z values


YesYes


Allow nulls

OBJECTID Object ID

Shape Geometry Yes





CROSSSECTION_NAME String Yes 55

CROSSSECTION_TYPE_DESC String Yes dCROSSECTIONTYPE 55






NONFILTERED_AREA Cross-Sectional Area (ft2) of the Non-Thinned CrossSection

FILTERED_AREA Cross-Sectional Area (ft2) of the Thinned CrossSection

CROSSSECTION_NAME User Assigned Name of the CrossSection

CROSSSECTION_TYPE_DESC Description of the CrossSection Type (see Domain dCROSSSECTIONTYPE)


Simple feature classPROFILE_LINE Contains Z values


YesYes


Allow nulls

OBJECTID Object ID

Shape Geometry Yes





PROFILE_NAME String Yes 55






NONFILTERED_AREA Cross-Sectional Area (ft2) of the Non-Thinned Profile

FILTERED_AREA Cross-Sectional Area (ft2) of the Thinned Profile

PROFILE_NAME User Assigned Name of the Profile


GWIS Version: 1.6



2.7.2 Domain(s):

Coded value domain

dHEP_SUBELEMENTTYPEDescription

Field type

Split policy

Merge policy

Long integer

Default value

Default value

DescriptionCode

1 BARREL

2 PIPE

3 WEIR

4 BRIDGE DECK

5 BRIDGE OPENING

6 BRIDGE PIER

7 GENERAL POINTS

Coded value domain

dPOINTTYPE_GENERALPOINTSDescription

Field type

Split policy

Merge policy

String

Default value

Default value

DescriptionCode

GR Natural Ground

ERM Elevation Reference Mark

TR Top of Road

DG Disturbed Ground

CL Centerline Channel

TB Top of Bank

BS Bank Slope

TS Toe of Slope

BR Top of Berm

BRS Berm Slope

BRT Toe of Berm

OTHER Other

Coded value domain

dPOINTTYPE_BRIDGEDECKDescription

Field type

Split policy

Merge policy

String

Default value

Default value

DescriptionCode

TR Top of Road

ERM Elevation Reference Mark

RAIL Rail on Bridge

USSTRUCT Top of Bridge at Upstream Face

DSSTRUCT Top of Bridge at Downstream Face

Coded value domain

dPOINTTYPE_BRIDGEOPENINGDescription

Field type

Split policy

Merge policy

String

Default value

Default value

DescriptionCode

LC Low Chord of Bridge

DSINV Downstream Invert of Bridge

BEGIN Beginning of Bridge Abutment

END End of Bridge Abutment

TOE Toe of Fill

Coded value domain

dPOINTTYPE_BRIDGEPIERDescription

Field type

Split policy

Merge policy

String

Default value

Default value

DescriptionCode

PIER Bridge Pier

Coded value domain

dPOINTTYPE_WEIRDescription

Field type

Split policy

Merge policy

String

Default value

Default value

DescriptionCode

WC Weir Crest

Coded value domain

dPOINTTYPE_PIPEBARRELDescription

Field type

Split policy

Merge policy

String

Default value

Default value

DescriptionCode

UIC Upstream Invert of Culvert

DIC Downstream Invert of Culvert

Coded value domain

dHORUNITSDescription

Field type

Split policy

Merge policy

String

Default value

Default value

DescriptionCode

FEET FEET

METERS METERS

Coded value domain

dHORDATUMDescription

Field type

Split policy

Merge policy

String

Default value

Default value

DescriptionCode

NAD27 NAD27

NAD83 NAD83

HARN NAD83 HARN

Coded value domain

dSYSSCALEDescription

Field type

Split policy

Merge policy

String

Default value

Default value

DescriptionCode

LOCAL LOCAL

INTERMEDIATE INTERMEDIATE

REGIONAL REGIONAL

Coded value domain

dVERTDATUMDescription

Field type

Split policy

Merge policy

String

Default value

Default value

DescriptionCode

NGVD29 NGVD29

NAVD88 NAVD88

Coded value domain

dVERTUNITSDescription

Field type

Split policy

Merge policy

String

Default value

Default value

DescriptionCode

FEET FEET

METERS METERS

GWIS Version: 1.6



Coded value domain

dHIGHWATERTYPEDescription

Field type

Split policy

Merge policy

String

Default value

Default value

DescriptionCode

PWL PRESENT WATER LEVEL

PEAK PEAK RECORDED STAGE

HW HIGH WATER

NHW NORMAL HIGH WATER

EHW EXTREME HIGH WATER

DHW DESIGN HIGH WATER

IND INDICATOR OF WATER LEVEL

Coded value domain

dPROJTDescription

Field type

Split policy

Merge policy

String

Default value

Default value

DescriptionCode

SPE STATEPLANE FLORIDA EAST FIPS 0901

SPW STATEPLANE FLORIDA WEST FIPS 0902

UTM UTM ZONE 17N


Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


HydraulicElementMetadataHasHydraulicElementPoints


Simple

One to many

None


HYDRAULIC_ELEMENT_METADATA

HYDRAULIC_ELEMENT_METADATA

HYDRAULIC_ELEMENT_METADATA_ID

HYDRAULIC_ELEMENT_METADATA_ID


Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


HydraulicElementPointHasHyperLinks


Simple

One to many

None

HYPERLINK



HYPERLINK_ID

HYPERLINK_ID

HYPERLINKName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


HydraulicElementPointHasMetadata


Simple

One to many

None

METADATA



METADATA_ID

METADATA_ID

GWIS_METADATAName


TableHYDRAULIC_ELEMENT_METADATA


Allow nulls

OBJECTID Object ID

HYDRAULIC_ELEMENT_METADATA_ID Long integer Yes 0

VERTICAL_DATUM_DESC String Yes dVERTDATUM 6

VERTICAL_UNITS_DESC String Yes dVERTUNITS 6

HORIZONTAL_DATUM_DESC String Yes dHORDATUM 5

HORIZONTAL_UNITS_DESC String Yes dHORUNITS 6

PROJECTION_DESC String Yes dPROJT 11



HYDRAULIC_ELEMENT_METADATA_ID Primary Key Identifier Relating Table to Associated Hydraulic Element Point(s)

VERTICAL_DATUM_DESC Vertical Datum (see Domain: dVERTDATUM)

VERTICAL_UNITS_DESC Vertical Units (see Domain: dVERTUNITS)

HORIZONTAL_DATUM_DESC Horizontal Datum (see Domain: dHORDATUM)

HORIZONTAL_UNITS_DESC Horizontal Units (see Domain: dHORUNITS)

PROJECTION_DESC Projection (see Domain: dPROJT)


GWIS Version: 1.6



2.8 Model:

The model feature dataset includes model specific feature classes that can be loaded directly into

an ICPR model through XML. The feature classes are related to ICPR specific tables (described

in this section) and the general Sub Element tables (described in section 2.6). Records in the

Sub Element tables that are used by model will have the ICPR_LINK_NAME or

ICPR_NODE_NAME fields populated. The domain codes in this section are designed to match

the stored values used by ICPR.


Simple feature classICPR_BASIN Contains Z values


NoNo


Allow nulls

OBJECTID Object ID

Shape Geometry Yes

NAME String Yes 15

NODENAME String Yes 15

ICPR_GROUP String Yes 15

TYPE Long integer Yes dICPR_BASINTYPE 0

STATUS Long integer Yes dICPR_BASINSTATUS 0

UNITHYD String Yes 15

RAINFILE String Yes 15

RAINAMOUNT Double Yes 0 0

PEAKFACTOR Double Yes 0 0

DURATION Double Yes 0 0

TC Double Yes 0 0

TIMESHIFT Double Yes 0 0

MAXQ Double Yes 0 0

TIMEINC Double Yes 0 0

AREA_ACRES Double Yes 0 0

CN Double Yes 0 0

DCIA Double Yes 0 0





NAME Basin Name

NODENAME Node Name

ICPR_GROUP Name of ICPR Subset or Tributary

TYPE Hydrograph Type (see Domain: dICPR_BASINTYPE)

STATUS Runoff Status (see Domain: dICPR_BASINSTATUS)

UNITHYD Dimensionless Unit Hydrograph

RAINFILE Rainfall Distribution Name

RAINAMOUNT Rainfall Amount (in)

PEAKFACTOR Peaking Factor associated with the Unit Hydrograph

DURATION Storm Duration (hrs)

TC Time of Concentration (min)

TIMESHIFT Lag Time (hrs)

MAXQ Maximum Allowable Flow (ft3/sec)

TIMEINC Time Increment (minutes) used by Santa Barbara and Overland Flow Hydrograph methods

AREA_ACRES Total Basin Drainage Area (acres)

CN Curve Number

DCIA Percent Directly Connected Impervious Area (percent of total basin area)



GWIS Version: 1.6



Simple feature classICPR_SLURP Contains Z values


NoNo


Allow nulls

OBJECTID Object ID

Shape Geometry Yes

NAME String Yes 15

PCT_IMPERV Double Yes 0 0

DCIA Double Yes 0 0

KSAT Double Yes 0 0

SST Double Yes 0 0

SSU Double Yes 0 0

EFF_POROSITY Double Yes 0 0





NAME Basin Name

PCT_IMPERV Percent Impervious Area within Sub-Basin

DCIA Percent Directly Connected Impervious Area (percent of sub-basin area)

KSAT Hydraulic Conductivity (in/hr) *

SST Soil Storage (in)

SSU Soil Suction Head (in)

EFF_POROSITY Effective Porosity (decimal value between 0 and 1)



* Note: during the XML export process KSAT is converted from in/hr to ft/day.

Simple edge feature classICPR_LINK Contains Z values


YesNo


Allow nulls

OBJECTID Object ID

Shape Geometry Yes


NAME String Yes 15

TYPE Long integer Yes dICPR_LINKTYPE 0


FROM_NODE String Yes 15

TO_NODE String Yes 15

FLOW String Yes 0 dICPR_FLOWDIRECTION 15




NAME Link Name

TYPE Link Type (see Domain: dICPR_LINKTYPE)


FROM_NODE Name of “From” Node

TO_NODE Name of “To” Node

FLOW Direction of Flow (see Domain: dICPR_FLOWDIRECTION)


GWIS Version: 1.6



Simple junction feature classICPR_NODE Contains Z values


NoNo


Allow nulls

OBJECTID Object ID

Shape Geometry Yes



NAME String Yes 15

TYPE Long integer Yes dICPR_NODETYPE 255


BASE_FLOW Double Yes 0 0

INITIAL_STAGE Double Yes 0 0

WARNING_STAGE Double Yes 0 0



NAME Node Name

TYPE Node Type (see Domain: dICPR_NODETYPE)


BASE_FLOW Base Flow Rate (ft3/sec)

INITIAL_STAGE Initial Stage (ft)

WARNING_STAGE Warning Stage (ft)

Simple feature classICPR_XSECT Contains Z values


YesYes


Allow nulls

OBJECTID Object ID

Shape Geometry Yes

NAME String Yes 15


ENCROACH String Yes dXSECT_ENCROACHMENT 255

LSTATION Double Yes 0 0

RSTATION Double Yes 0 0






NAME Cross Section Name


ENCROACH Account For Encroachment? (see Domain: dXSECT_ENCROACHMENT)

LSTATION Left Station of Encroachment (ft)

RSTATION Right Station of Encroachment (feet)

FILTERED_AREA Cross-Sectional Area (ft2) of the Thinned Irregular CrossSection

NONFILTERED_AREA Cross-Sectional Area (ft2) of the Non-Thinned Irregular CrossSection


GWIS Version: 1.6



2.8.2 Domain(s):

Coded value domain

dFILTERSLOPEDescription

Field type

Split policy

Merge policy

Long integer

Default value

Default value

DescriptionCode

0 NO (FLAT)

1 YES (SLOPED)

Coded value domain

dEXFILTRATIONENDTREATMENTDescription

Field type

Split policy

Merge policy

Long integer

Default value

Default value

DescriptionCode

0 EXCLUDE

1 INCLUDE

Coded value domain

dFRICTION_EQUATIONDescription

Field type

Split policy

Merge policy

Long integer

Default value

Default value

DescriptionCode

0 Average Conveyance

1 Average Friction Slope

2 Geometric Mean Friction Slope

3 Harmonic Mean Friction Slope

4 Automatic

Coded value domain

dICPR_BASINTYPEDescription

Field type

Split policy

Merge policy

Long integer

Default value

Default value

DescriptionCode

0 SCS UNIT HYDROGRAPH

1 SANTA BARBARA

2 OVERLAND FLOW

3 SCS UNIT HYDROGRAPH GA

4 SANTA BARBARA GA

Coded value domain

dICPR_BASINSTATUSDescription

Field type

Split policy

Merge policy

Long integer

Default value

Default value

DescriptionCode

0 ON SITE

1 OFF SITE

2 INACTIVE

Coded value domain

dICPR_FLOWDIRECTIONDescription

Field type

Split policy

Merge policy

Long integer

Default value

Default value

DescriptionCode

0 BOTH

1 POSITIVE

2 NONE

Coded value domain

dTOPBOTTOMCLIP_FUNCTIONDescription

Field type

Split policy

Merge policy

Long integer

Default value

Default value

DescriptionCode

0 Time(X) vs. Depth of Clip(Y)

1 Upstream Depth Above Invert(X) vs. Depth of Clip(Y)

2 Downstream Depth Above Invert(X) vs. Depth of Clip(Y)

3 Head Across Invert(X) vs. Depth of Clip(Y)

Coded value domain

dMANHOLE_TYPEDescription

Field type

Split policy

Merge policy

Long integer

Default value

Default value

DescriptionCode

3 Manhole, Flat Floor

4 Manhole, 1/2 Diameter Grooved

5 Manhole, 1 Diameter Grooved

6 Manhole, 1 Diameter Grooved with Top

Coded value domain

dRUN_WSPRODescription

Field type

Split policy

Merge policy

Long integer

Default value

Default value

DescriptionCode

0 No

1 Yes

Coded value domain

dORIFICECOEF_FUNCTIONDescription

Field type

Split policy

Merge policy

Long integer

Default value

Default value

DescriptionCode

0 U/S Depth Above Invert(X) vs. Orifice Discharge Coef(Y)

Coded value domain

dWEIRCOEF_FUNCTIONDescription

Field type

Split policy

Merge policy

Long integer

Default value

Default value

DescriptionCode

0 U/S Depth Above Invert(X) vs. Weir Discharge Coef(Y)

Coded value domain

dINLET_CONTROLDescription

Field type

Split policy

Merge policy

Long integer

Default value

Default value

DescriptionCode

0 Use dn

1 Use dc

GWIS Version: 1.6



Coded value domain

dOUTLET_CONTROLDescription

Field type

Split policy

Merge policy

Long integer

Default value

Default value

DescriptionCode

0 Use dc or tw

1 Use dn or tw

Coded value domain

dBREACHEQUATIONDescription

Field type

Split policy

Merge policy

Long integer

Default value

Default value

DescriptionCode

0 MAVIS

1 FREAD

Coded value domain

dXSECT_ENCROACHMENTDescription

Field type

Split policy

Merge policy

Long integer

Default value

Default value

DescriptionCode

1 YES

0 NO

Coded value domain

dRATINGCURVE_FUNCTIONDescription

Field type

Split policy

Merge policy

Long integer

Default value

Default value

DescriptionCode

0 Upstream Stage(X) vs. Discharge(Y)

1 Tailwater(X)-Headwater(Y)-Discharge(Z)

2 Time(X) vs. Discharge(Y)

3 Head(X) vs. Discharge(Y)

Coded value domain

dSOLUTION_ALGORITHMDescription

Field type

Split policy

Merge policy

Long integer

Default value

Default value

DescriptionCode

0 Automatic

1 Always Outlet

2 Always Inlet

3 Most Restrictive

Coded value domain

dPERCSURFAREAOPTIONDescription

Field type

Split policy

Merge policy

Long integer

Default value

Default value

DescriptionCode

0 USE 1ST POINT IN STAGE/AREA TABLE

1 VARY BASED ON STAGE/AREA TABLE

2 USER SPECIFIED

Coded value domain

dPERCVERTFLOWTERMINATIONDescription

Field type

Split policy

Merge policy

Long integer

Default value

Default value

DescriptionCode

0 HORIZONTAL FLOW ALGORITHM

1 PERCENT OF FINAL RATE

2 CONSTANT RATE

Coded value domain

dICPR_LINKTYPEDescription

Field type

Split policy

Merge policy

Long integer

Default value

Default value

DescriptionCode

0 PIPE

1 CHANNEL

2 WEIR

3 DROP STRUCTURE

4 BRIDGE

5 RATING CURVE

6 BREACH

7 PERCOLATION

8 EXFILTRATION TRENCH

9 FILTER

Coded value domain

dICPR_NODETYPEDescription

Field type

Split policy

Merge policy

Long integer

Default value

Default value

DescriptionCode

0 STAGE/AREA

1 TIME/STAGE

2 STAGE/VOLUME

3 MANHOLE

4 CHANNEL

5 WEIR

6 PIPE

7 DROP STRUCTURE

GWIS Version: 1.6




Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRBasinHasSLURP


Simple

One to one

None

ICPR_SLURP

ICPR_BASIN

ICPR_BASIN

NAME

NAME

ICPR_SLURPName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRBasinHasComment


Simple

One to one

None

ICPR_COMMENT

ICPR_BASIN

ICPR_BASIN

NAME

NAME

ICPR_COMMENTName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRBasinHasOverlandFlowPlane


Simple

One to one

None

ICPR_OVFLOWPLANE

ICPR_BASIN

ICPR_BASIN

NAME

BASINNAME

ICPR_OVFLOWPLANEName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


BridgeOpeningHasICPRXsect


Simple

One to one

None

ICPR_XSECT

BRIDGE_OPENING

BRIDGE_OPENING

SECTION_NAME

NAME

ICPR_XSECTName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


BridgeSpurDikeHasICPRXsect


Simple

One to one

None

ICPR_XSECT

BRIDGE_SPURDIKE

BRIDGE_SPURDIKE

SECTION_NAME

NAME

ICPR_XSECTName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


BridgeSectionTypeHasICPRXsect


Simple

One to one

None

ICPR_XSECT

BRIDGESECTION_TYPE

BRIDGESECTION_TYPE

SECTION_NAME

NAME

ICPR_XSECTName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRLinkHasBridgeDeck


Simple

One to one

None

BRIDGE_DECK

ICPR_LINK

ICPR_LINK

NAME

ICPR_LINK_NAME

BRIDGE_DECKName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRLinkHasBridgeOpening


Simple

One to one

None

BRIDGE_OPENING

ICPR_LINK

ICPR_LINK

NAME

ICPR_LINK_NAME

BRIDGE_OPENINGName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRLinkHasBridgePiers


Simple

One to many

None

BRIDGE_PIER

ICPR_LINK

ICPR_LINK

NAME

ICPR_LINK_NAME

BRIDGE_PIERName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRLinkHasBridgeSpurDike


Simple

One to one

None

BRIDGE_SPURDIKE

ICPR_LINK

ICPR_LINK

NAME

ICPR_LINK_NAME

BRIDGE_SPURDIKEName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRLinkHasBridgeSectionTypes


Simple

One to many

None

BRIDGESECTION_TYPE

ICPR_LINK

ICPR_LINK

NAME

ICPR_LINK_NAME

BRIDGESECTION_TYPEName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRLinkHasChannel


Simple

One to one

None

CHANNEL

ICPR_LINK

ICPR_LINK

NAME

ICPR_LINK_NAME

CHANNELName

GWIS Version: 1.6



Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ChannelHasUpstreamMainICPRXsect


Simple

One to one

None

ICPR_XSECT_US_MAIN

CHANNEL

CHANNEL

US_MAIN_XS_NAME

NAME

ICPR_XSECTName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ChannelHasDownstreamMainICPRXsect


Simple

One to one

None

ICPR_XSECT_DS_MAIN

CHANNEL

CHANNEL

DS_MAIN_XS_NAME

NAME

ICPR_XSECTName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ChannelHasUpstreamAuxICPRXsect1


Simple

One to one

None

ICPR_XSECT_US_AUX1

CHANNEL

CHANNEL

US_AUX1_XS_NAME

NAME

ICPR_XSECTName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ChannelHasDownstreamAuxICPRXsect1


Simple

One to one

None

ICPR_XSECT_DS_AUX1

CHANNEL

CHANNEL

DS_AUX1_XS_NAME

NAME

ICPR_XSECTName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ChannelHasUpstreamAuxICPRXsect2


Simple

One to one

None

ICPR_XSECT_US_AUX2

CHANNEL

CHANNEL

US_AUX2_XS_NAME

NAME

ICPR_XSECTName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ChannelHasDownstreamAuxICPRXsect2


Simple

One to one

None

ICPR_XSECT_DS_AUX2

CHANNEL

CHANNEL

DS_AUX2_XS_NAME

NAME

ICPR_XSECTName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRLinkHasPipe


Simple

One to one

None

PIPE_BARREL

ICPR_LINK

ICPR_LINK

NAME

ICPR_LINK_NAME

PIPE_BARRELName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRLinkHasDropStructure


Simple

One to one

None

DROP_STRUCTURE

ICPR_LINK

ICPR_LINK

NAME

ICPR_LINK_NAME

DROP_STRUCTUREName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRLinkHasWeir


Simple

One to one

None

WEIR

ICPR_LINK

ICPR_LINK

NAME

ICPR_LINK_NAME

WEIRName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRLinkHasICPRLinkHydrographs


Simple

One to many

None

ICPR_LINK_HYDROGRAPH

ICPR_LINK

ICPR_LINK

NAME

ICPR_LINK_NAME

ICPR_LINK_HYDROGRAPHName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRLinkHasICPRLinkResults


Simple

One to one

None

ICPR_LINK_RESULT

ICPR_LINK

ICPR_LINK

NAME

ICPR_LINK_NAME

ICPR_LINK_RESULTName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRLinkHasTimeDischarge


Simple

One to many

None

ICPR_LINK_TIMEDISCHARGE

ICPR_LINK

ICPR_LINK

NAME

NAME

ICPR_LINK_TIMEDISCHARGEName

GWIS Version: 1.6



Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRNodeHasICPRNodeHydrographs


Simple

One to many

None

ICPR_NODE_HYDROGRAPH

ICPR_NODE

ICPR_NODE

NAME

ICPR_NODE_NAME

ICPR_NODE_HYDROGRAPHName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRNodeHasICPRNodeResults


Simple

One to one

None

ICPR_NODE_RESULT

ICPR_NODE

ICPR_NODE

NAME

ICPR_NODE_NAME

ICPR_NODE_RESULTName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRNodeHasBoundDischarges


Simple

One to many

None

ICPR_NODE_BOUNDDISCHARGE

ICPR_NODE

ICPR_NODE

NAME

NAME

ICPR_NODE_TIMEDISCHARGEName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRNodeHasTimeStage


Simple

One to many

None

TIMESTAGE

ICPR_NODE

ICPR_NODE

NAME

NAME

ICPR_NODE_TIMESTAGEName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRNodeHasStageDischarge


Simple

One to many

None

ICPR_NODE_STAGE_DISCHARGE

ICPR_NODE

ICPR_NODE

NAME

NAME

ICPR_NODE_STAGEDISCHARGEName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRNodeHasICPRNodeStorage


Simple

One to many

None

ICPR_NODE_STORAGE

ICPR_NODE

ICPR_NODE

NAME

NAME

ICPR_NODE_STORAGEName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRNodeHasManholeType


Simple

One to one

None

ICPR_MANHOLETYPE

ICPR_NODE

ICPR_NODE

NAME

NAME

ICPR_MANHOLETYPEName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRLinkHasBreach


Simple

One to one

None

ICPR_BREACH

ICPR_LINK

ICPR_LINK

NAME

NAME

ICPR_BREACHName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRLinkHasPercolation


Simple

One to one

None

ICPR_PERCOLATION

ICPR_LINK

ICPR_LINK

NAME

NAME

ICPR_PERCOLATIONName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRLinkHasICPRParameters


Simple

One to one

None

ICPR_PARAMETERS

ICPR_LINK

ICPR_LINK

NAME

NAME

ICPR_PARAMETERSName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRLinkHasFilter


Simple

One to one

None

ICPR_FILTER

ICPR_LINK

ICPR_LINK

NAME

NAME

ICPR_FILTERName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRLinkHasBridgeRatingCurve


Simple

One to many

None

BRIDGE_RATINGCURVE

ICPR_LINK

ICPR_LINK

NAME

ICPR_LINK_NAME

BRIDGE_RATINGCURVEName

GWIS Version: 1.6



Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRLinkHasExfiltrationTrench


Simple

One to one

None

ICPR_EXFILTRATIONTRENCH

ICPR_LINK

ICPR_LINK

NAME

NAME

ICPR_EXFILTRATIONTRENCHName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRLinkHasRatingCurve


Simple

One to one

None

ICPR_RATINGCURVE

ICPR_LINK

ICPR_LINK

NAME

NAME

ICPR_RATINGCURVEName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRRatingCurveHasOperatingTable1


Simple

One to one

None

ICPR_RATINGCURVE_OPTABLE1

ICPR_RATINGCURVE

ICPR_RATINGCURVE

OPTABLE1

NAME

ICPR_RATINGCURVE_OPTABLEName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label




Simple

One to one

None


ICPR_RATINGCURVE

ICPR_RATINGCURVE

OPTABLE2

NAME


Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label




Simple

One to one

None


ICPR_RATINGCURVE

ICPR_RATINGCURVE

OPTABLE3

NAME


Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label




Simple

One to one

None


ICPR_RATINGCURVE

ICPR_RATINGCURVE

OPTABLE4

NAME


Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRRatingCurveOpTableHasComment


Simple

One to one

None

ICPR_COMMENT

ICPR_RATINGCURVE_OPTABLE

ICPR_RATINGCURVE_OPTABLE

NAME

NAME

ICPR_COMMENTName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRXsectHasComment


Simple

One to one

None

ICPR_COMMENT

ICPR_XSECT

ICPR_XSECT

NAME

NAME

ICPR_COMMENTName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRXsectHasXsectStations


Simple

One to many

None

ICPR_XSECT_STATIONS

ICPR_XSECT

ICPR_XSECT

NAME

NAME

ICPR_XSECT_STATIONSName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


WeirHasICPRXsect


Simple

One to one

None

ICPR_XSECT

WEIR

WEIR

SECTION_NAME

NAME

ICPR_XSECTName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


WeirHasBottomClipOpTable


Simple

One to many

None

BOTTOMCLIP_OPTABLE

WEIR

WEIR

BOTTOMCLIP_OPTABLE

NAME

ICPR_BOTTOMCLIP_OPTABLEName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRBottomClipOpTableHasComment


Simple

One to one

None

ICPR_COMMENT

ICPR_BOTTOMCLIP_OPTABLE

ICPR_BOTTOMCLIP_OPTABLE

NAME

NAME

ICPR_COMMENTName

GWIS Version: 1.6



Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


WeirHasTopClipOpTable


Simple

One to many

None

TOPCLIP_OPTABLE

WEIR

WEIR

TOPCLIP_OPTABLE

NAME

ICPR_TOPCLIP_OPTABLEName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRTopClipOpTableHasComment


Simple

One to one

None

ICPR_COMMENT

ICPR_TOPCLIP_OPTABLE

ICPR_TOPCLIP_OPTABLE

NAME

NAME

ICPR_COMMENTName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


WeirHasWeirCoefOpTable


Simple

One to many

None

WEIRCOEF_OPTABLE

WEIR

WEIR

WEIRCOEF_OPTABLE

NAME

ICPR_WEIRCOEF_OPTABLEName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRWeirCoefOpTableHasComment


Simple

One to one

None

ICPR_COMMENT

ICPR_WEIRCOEF_OPTABLE

ICPR_WEIRCOEF_OPTABLE

NAME

NAME

ICPR_COMMENTName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


WeirHasOrificeCoefOpTable


Simple

One to many

None

ORIFICECOEF_OPTABLE

WEIR

WEIR

ORIFICECOEF_OPTABLE

NAME

ICPR_ORIFICECOEF_OPTABLEName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPROrificeCoefOpTableHasComment


Simple

One to one

None

ICPR_COMMENT

ICPR_ORIFICECOEF_OPTABLE

ICPR_ORIFICECOEF_OPTABLE

NAME

NAME

ICPR_COMMENTName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRLinkHasComment


Simple

One to one

None

ICPR_COMMENT

ICPR_LINK

ICPR_LINK

NAME

NAME

ICPR_COMMENTName

Relationship class

Name

Primary key

Foreign key

Type

Cardinality

Notification

Forward label

Backward label


ICPRNodeHasComment


Simple

One to one

None

ICPR_COMMENT

ICPR_NODE

ICPR_NODE

NAME

NAME

ICPR_COMMENTName


TableICPR_COMMENT


Allow nulls

OBJECTID Object ID

NAME String Yes 15

COMMENT String Yes 255


NAME Name of Associated ICPR Element (Basin, Link, Node, etc.)

COMMENT Comment Containing Useful Information (data sources, assumptions, etc.)

* Note: avoid using special characters (&, #, <, >, %, etc.) in the comment field. These may cause errors during the XML

export/transfer process.

GWIS Version: 1.6



TableICPR_MANHOLETYPE


Allow nulls

OBJECTID Object ID

NAME String Yes 15

TYPE Long integer Yes dMANHOLE_TYPE 0

PLUNGE_FACTOR Double Yes 0 0


NAME Name of Associated ICPR Node with Type = 3 (Manhole)

TYPE Manhole Type (see Domain: dMANHOLE_TYPE)

PLUNGE_FACTOR Plunging Flow Factor

TableICPR_NODE_STAGEDISCHARGE


Allow nulls

OBJECTID Object ID

NAME String Yes 15

STAGE_VAL Double Yes 0 0

FLOW_VAL Double Yes 0 0


NAME Name of Associated ICPR Node

STAGE_VAL Stage (ft)

FLOW_VAL Flow (ft3/sec)

TableICPR_NODE_STORAGE


Allow nulls

OBJECTID Object ID

NAME String Yes 15


AREA_MS Double Yes 0 0

VOLUME_VAL Double Yes 0 0




AREA_MS Area (acres)

VOLUME_VAL Volume (acre-ft)

TableICPR_NODE_TIMEDISCHARGE


Allow nulls

OBJECTID Object ID

NAME String Yes 15

TIME_VAL Double Yes 0 0




TIME_VAL Time (hrs)

FLOW_VAL Flow (ft3/sec)

*Input Time Series

*

GWIS Version: 1.6



TableICPR_NODE_TIMESTAGE


Allow nulls

OBJECTID Object ID

NAME String Yes 15




NAME Name of Associated ICPR Node with Type = 1 (Time/Stage)

TIME_VAL Time (hrs)


*Input Time Series

TableICPR_LINK_HYDROGRAPH


Allow nulls

OBJECTID Object ID

NAME String Yes 15

VARIABLE String Yes 255




NAME Name of Associated ICPR Link

VARIABLE Model Simulation Variable Name (e.g. 100yr24hr, 100Y5D, etc.)

TIME_VAL Time Series Time Value (hrs)

FLOW_VAL Time Series Flow Value (ft3/sec)

^Output Time Series

TableICPR_NODE_HYDROGRAPH


Allow nulls

OBJECTID Object ID

NAME String Yes 15

VARIABLE String Yes 255





VARIABLE Model Simulation Variable Name (e.g. 100yr24hr, 100Y5D, etc.)

TIME_VAL Time Series Time Value (hrs)

STAGE_VAL Time Series Stage Value (ft)

^ Output Time Series

*

^

^

GWIS Version: 1.6



TableICPR_LINK_RESULT


Allow nulls

OBJECTID Object ID

NAME String Yes 15

FLOW_500YR5DAY_VAL Double Yes 0 0













FLOW_500YR5DAY_VAL 500 Year, 5 Day Peak Flow (ft3/sec)










FLOW_233YR1DAY_VAL 2.33 Year, 1 Day Peak Flow (ft3/sec)

TableICPR_OVFLOWPLANE


Allow nulls

OBJECTID Object ID

BASINNAME String Yes 15

AREA_MS Double Yes 0 0

CN_VAL Double Yes 0 0

DCIA_PCT Double Yes 0 0

LENGTH_MS Double Yes 0 0

SLOPE_MS Double Yes 0 0

MANNINGSN_VAL Double Yes 0 0


BASINNAME Name of Associated ICPR Basin

AREA_MS Area (acres) of the Flow Plane Element

CN_VAL Curve Number of the Flow Plane Element

DCIA_PCT Directly Connected Impervious Area (percent) for the Flow Plane Element

LENGTH_MS Average Distance Traveled in the Direction of Flow (ft) for the Flow Plane Element

SLOPE_MS Average Slope (percent) for the Flow Plane Element

MANNINGSN_VAL Average Manning’s N Value for the Flow Plane Element

GWIS Version: 1.6



TableICPR_LINK_TIMEDISCHARGE


Allow nulls

OBJECTID Object ID

NAME String Yes 15





TIME_VAL Time Value (hrs)

FLOW_VAL Flow (ft3/sec) at corresponding Time Value

TableICPR_NODE_RESULT


Allow nulls

OBJECTID Object ID

NAME String Yes 15

ELEVATION_500YR_5DAY_VAL Double Yes 0 0













ELEVATION_500YR_5DAY_VAL 500 Year, 5 Day Maximum Water Surface Elevation (ft)










ELEVATION_233YR_1DAY_VAL 2.33 Year, 1 Day Maximum Water Surface Elevation (ft)

GWIS Version: 1.6



TableICPR_BREACH


Allow nulls

OBJECTID Object ID

NAME String Yes 15

EQUATION_DESC Long integer Yes dBREACHEQUATION 0

BOTTOMWIDTH_MS Double Yes 0 0

LEFTSIDESLOPE_MS Double Yes 0 0

RIGHTSIDESLOPE_MS Double Yes 0 0

BOTTOMELEV_MS Double Yes 0 0

TOPELEV_MS Double Yes 0 0

WSURFELEV_MS Double Yes 0 0

DURATION_VAL Double Yes 0 0

POWERCOEF_VAL Double Yes 0 0

WEIRCOEF_VAL Double Yes 0 0



EQUATION_DESC Breach Equation (see Domain: dBREACHEQUATION)

BOTTOMWIDTH_MS Bottom Width (ft) of Trapezoidal Breach

LEFTSIDESLOPE_MS Left Side Slope (horizontal/vertical) of Trapezoidal Breach

RIGHTSIDESLOPE_MS Right Side Slope (horizontal/vertical) of Trapezoidal Breach

BOTTOMELEV_MS Elevation (ft) of Breach at Completion

TOPELEV_MS Elevation (ft) of Breach at Commencement

WSURFELEV_MS Water Surface Elevation (ft) to Initiate Breach

DURATION_VAL Breach Duration (hrs)

POWERCOEF_VAL Breach Power Coefficient

WEIRCOEF_VAL Weir Discharge Coefficient

TableICPR_PARAMETERS


Allow nulls

OBJECTID Object ID

NAME String Yes 15

FRICTION_EQUATION Long integer Yes dFRICTION_EQUATION 0

SOLUTION_ALGORITHM Long integer Yes dSOLUTION_ALGORITHM 0

OUTLET_CTRL_SPEC Long integer Yes dOUTLET_CONTROL 0

INLET_CTRL_SPEC Long integer Yes dINLET_CONTROL 0

SOLUTION_INCS Double Yes 0 0

RUN_WSPRO Long integer Yes dRUN_WSPRO 0



FRICTION_EQUATION Friction Loss Averaging Method (see Domain: dFRICTION_EQUATION)

SOLUTION_ALGORITHM Solution Algorithm Method (see Domain: dSOLUTION_ALGORITHM)

OUTLET_CTRL_SPEC Outlet Control Option (see Domain: dOUTLET_CONTROL)

OUTLET_CTRL_SPEC Inlet Control Option (see Domain: dINLET_CONTROL)

SOLUTION_INCS Number of Solution Increments (used for Drop Structure Calculations)

RUN_WSPRO Run WSPRO Option for Bridges (Yes/No)

* Note: these are optional parameters. If not specified ICPR will assign default values.

GWIS Version: 1.6



TableICPR_PERCOLATION


Allow nulls

OBJECTID Object ID

NAME String Yes 15

SURFAREA_OPTION_DESC Long integer Yes dPERCSURFAREAOPTION 0

BOTTOMELEV_MS Double Yes 0 0

SURFAREA_MS Double Yes 0 0

VERTFLOW_TERMINATION_DESC Long integer Yes dPERCVERTFLOWTERMINATION 0

PERCENT_RATE_VAL Double Yes 0 0

CONSTANT_RATE_VAL Double Yes 0 0

AQUIFER_BASE_ELEV_MS Double Yes 0 0

WATERTABLE_ELEV_MS Double Yes 0 0

ANNUALRECHARGE_RATE_VAL Double Yes 0 0

HORIZ_CONDUCTIVITY_VAL Double Yes 0 0

VERT_CONDUCTIVITY_VAL Double Yes 0 0

EFFECTIVEPOROSITY_VAL Double Yes 0 0

SUCTIONHEAD_VAL Double Yes 0 0

LAYERTHICKNESS_VAL Double Yes 0 0

PERIMETER1_MS Double Yes 0 0



DISTANCE_1TO2_MS Double Yes 0 0

DISTANCE_2TO3_MS Double Yes 0 0

NUMCELLS_1TO2_CNT Long integer Yes 0

NUMCELLS_2TO3_CNT Long integer Yes 0



SURFAREA_OPTION_DESC Surface Area Option (see Domain: dPERCSURFAREAOPTION)

BOTTOMELEV_MS Bottom Elevation (ft)

SURFAREA_MS Surface Area (acres)

VERTFLOW_TERMINATION_DESC Vertical Flow Termination Option (see Domain: dPERCVERTFLOWTERMINATION)

PERCENT_RATE_VAL Percent Infiltration Rate (%)

CONSTANT_RATE_VAL Constant Rate (ft/day)

AQUIFER_BASE_ELEV_MS Aquifer Base Elevation (ft)

WATERTABLE_ELEV_MS Ambient Water Table Elevation (ft)

ANNUALRECHARGE_RATE_VAL Annual Recharge Rate (in/yr)

HORIZ_CONDUCTIVITY_VAL Average Soil Permeability (ft/day) in the Horizontal Direction

VERT_CONDUCTIVITY_VAL Average Soil Permeability (ft/day) in the Vertical Direction

EFFECTIVEPOROSITY_VAL Effective Porosity (decimal value between 0 and 1)

SUCTIONHEAD_VAL Wetting Front Suction Head (in)

LAYERTHICKNESS_VAL Distance (ft) Between the Pond Bottom and the Ambient Water Table Elevation

PERIMETER1_MS P1 Perimeter Length (ft)



DISTANCE_1TO2_MS Distance from P1 to P2 (ft)

DISTANCE_2TO3_MS Distance from P2 to P3 (ft)

NUMCELLS_1TO2_CNT Number of Computational Cells Between P1 and P2

NUMCELLS_2TO3_CNT Number of Computational Cells Between P2 and P3

GWIS Version: 1.6



TableICPR_FILTER


Allow nulls

OBJECTID Object ID

NAME String Yes 15

SLOPED_FLG Long integer Yes dFILTERSLOPE 0

SIDESLOPE_MS Double Yes 0 0

FILTERELEV_MS Double Yes 0 0

FILTERWIDTH_MS Double Yes 0 0

FILTERLENGTH_MS Double Yes 0 0

FILTERPERMEABILITY_MS Double Yes 0 0

PIPEINVERT_MS Double Yes 0 0

PIPEDIAMETER_MS Double Yes 0 0

XGRAVELTHICKNESS_MS Double Yes 0 0

YGRAVELTHICKNESS_MS Double Yes 0 0



SLOPED_FLG Flat or Sloped Filter Orientation (see Domain: dFILTERSLOPE)

SIDESLOPE_MS Number of Horizontal Units to one Vertical Unit for a Sloped Filter

FILTERELEV_MS Lowest Elevation (ft) at the Surface of the Filter Media

FILTERWIDTH_MS Distance (ft) at the Surface Across the Filter Media

FILTERLENGTH_MS Longitudinal Distance (ft) of the Filter

FILTERPERMEABILITY_MS Hydraulic Conductivity (ft/dat) of the Filter Media

PIPEINVERT_MS Pipe Invert (ft)

PIPEDIAMETER_MS Pipe Diameter (in)

XGRAVELTHICKNESS_MS Gravel Thickness in the X Direction (in)

YGRAVELTHICKNESS_MS Gravel Thickness in the Y Direction (in)

TableICPR_EXFILTRATIONTRENCH


Allow nulls

OBJECTID Object ID

NAME String Yes 15

AQUIFER_BASE_ELEV_MS Double Yes 0 0

WATERTABLE_ELEV_MS Double Yes 0 0

ANNUALRECHARGE_RATE_VAL Double Yes 0 0

HORIZ_CONDUCTIVITY_VAL Double Yes 0 0

VERT_CONDUCTIVITY_VAL Double Yes 0 0

EFFECTIVEPOROSITY_VAL Double Yes 0 0

SUCTIONHEAD_VAL Double Yes 0 0

TRENCHBOTTOMELEV_MS Double Yes 0 0

TRENCHWIDTH_MS Double Yes 0 0

TRENCHLENGTH_MS Double Yes 0 0

TRENCHHEIGHT_MS Double Yes 0 0

GRAVELPOROSITY_VAL Double Yes 0 0

PIPEDIAMETER_MS Double Yes 0 0

PIPEINVERTELEV_MS Double Yes 0 0

ENDTREATMENT_DESC Long integer Yes dEXFILTRATIONENDTREATMENT 0

CELLSPACING_VAL Double Yes 0 0

NUMCELLS_VAL Double Yes 0 0



AQUIFER_BASE_ELEV_MS Aquifer Base Elevation (ft)

WATERTABLE_ELEV_MS Ambient Water Table Elevation (ft)

ANNUALRECHARGE_RATE_VAL Annual Recharge Rate (in/yr)

HORIZ_CONDUCTIVITY_VAL Average Soil Permeability (ft/day) in the Horizontal Direction

VERT_CONDUCTIVITY_VAL Average Soil Permeability (ft/day) in the Vertical Direction

GWIS Version: 1.6



EFFECTIVEPOROSITY_VAL Effective Porosity (decimal value between 0 and 1)

SUCTIONHEAD_VAL Wetting Front Suction Head (in)

TRENCHBOTTOMELEV_MS Lowest Elevation of the Trench (ft)

TRENCHWIDTH_MS Distance (ft) Across the Gravel Envelope

TRENCHLENGTH_MS Longitudinal Distance (ft) of the Trench

TRENCHHEIGHT_MS Distance (ft) from the Bottom of the Trench to the Top of the Gravel Envelope

GRAVELPOROSITY_VAL Porosity of the Gravel (decimal value between 0 and 1)

PIPEDIAMETER_MS Diameter of the Pipe (in)

PIPEINVERTELEV_MS Invert Elevation of the Pipe (ft)

ENDTREATMENT_DESC End Treatment (see Domain: dEXFILTRATIONENDTREATMENT)

CELLSPACING_VAL Cell Spacing (ft)

NUMCELLS_VAL Total Number of Finite Difference Computational Cells

TableICPR_RATINGCURVE


Allow nulls

OBJECTID Object ID

NAME String Yes 15

OPTABLE1 String Yes 15

ELEV_ON1 Double Yes 0 0

ELEV_OFF1 Double Yes 0 0












OPTABLE1 Name of Related Rating Curve Operating Table 1

ELEV_ON1 Water Level (ft) that turns on Rating Curve 1

ELEV_OFF1 Water Level (ft) that turns off Rating Curve 1










GWIS Version: 1.6



TableICPR_RATINGCURVE_OPTABLE


Allow nulls

OBJECTID Object ID

NAME String Yes 15


FUNCTION_DESC Long integer Yes dRATINGCURVE_FUNCTION 0

X Double Yes 0 0

Y Double Yes 0 0

Z Double Yes 0 0


NAME Name of Rating Curve Operating Table


FUNCTION_DESC Operating Table Type (see Domain: dRATINGCURVE_FUNCTION)

X Operating Table X Parameter

Y Operating Table Y Parameter

Z Operating Table Z Parameter

TableICPR_BOTTOMCLIP_OPTABLE


Allow nulls

OBJECTID Object ID

NAME String Yes 15


FUNCTION_DESC Long integer Yes dTOPBOTTOMCLIP_FUNCTION 0

X Double Yes 0 0

Y Double Yes 0 0


NAME Name of Bottom Clip Operating Table


FUNCTION_DESC Operating Table Function (see Domain: dTOPBOTTOMCLIP_FUNCTION)



TableICPR_TOPCLIP_OPTABLE


Allow nulls

OBJECTID Object ID

NAME String Yes 15


FUNCTION_DESC Long integer Yes dTOPBOTTOMCLIP_FUNCTION 0

X Double Yes 0 0

Y Double Yes 0 0


NAME Name of Top Clip Operating Table


FUNCTION_DESC Operating Table Function (see Domain: dTOPBOTTOMCLIP_FUNCTION)



GWIS Version: 1.6



TableICPR_WEIRCOEF_OPTABLE


Allow nulls

OBJECTID Object ID

NAME String Yes 15


FUNCTION_DESC Long integer Yes dWEIRCOEF_FUNCTION 0

X Double Yes 0 0

Y Double Yes 0 0


NAME Name of Weir Coefficient Operating Table


FUNCTION_DESC Operating Table Function (see Domain: dWEIRCOEF_FUNCTION)

X U/S Depth Above Invert (ft)

Y Weir Discharge Coefficient

TableICPR_ORIFICECOEF_OPTABLE


Allow nulls

OBJECTID Object ID

NAME String Yes 15


FUNCTION_DESC Long integer Yes dORIFICECOEF_FUNCTION 0

X Double Yes 0 0

Y Double Yes 0 0


NAME Name of Orifice Coefficient Operating Table


FUNCTION_DESC Operating Table Function (see Domain: dORIFICECOEF_FUNCTION)

X U/S Depth Above Invert (ft)

Y Orifice Discharge Coefficient

TableICPR_XSECT_STATIONS


Allow nulls

OBJECTID Object ID

NAME String Yes 15



ELEV Double Yes 0 0

MANNINGS_N Double Yes 0 0






STATION Station (ft) along Cross Section Line

ELEV Elevation (ft) along Cross Section Line

MANNINGS_N Manning’s N


TOLERANCE Tolerance used when Thinning the Number of Points Along the Cross Section Line

GWIS Version: 1.6



TableBRIDGE_RATINGCURVE


Allow nulls

OBJECTID Object ID


TAILWATER_VAL Double Yes 0 0

QMIN_VAL Double Yes 0 0

QMAX_VAL Double Yes 0 0

QINCREMENTAL_VAL Double Yes 0 0


ICPR_LINK_NAME Name of Associated ICPR Bridge Link

TAILWATER_VAL Tailwater Elevation (ft)

QMIN_VAL Minimum Flow (ft3/sec)

QMAX_VAL Maximum Flow (ft3/sec)

QINCREMENTAL_VAL Incremental Flow (ft3/sec)

2.9 Metadata

Metadata and Hyperlinks provide information about the data. Metadata is feature based and may

be a comment or may be a link to additional information. Hyperlink is incorporated at this point in

time to point to additional documentation, which will be implemented into a document

management system as the District is ready to implement document management.


None identified.

2.9.2 Domain(s):

None identified.


None identified.


TableHYPERLINK


Allow nulls

OBJECTID Object ID


STORAGE_PATH_ADDR String Yes 255

FILE_NAME String Yes 255

STORAGE_FULL_PATH_ADDR String Yes 255


HYPERLINK_ID Primary Key Identifier Relating Hyperlink Table to Associated Feature(s)

STORAGE_PATH_ADDR Hyperlink Storage Path Address

FILE_NAME Hyperlink File Name

STORAGE_FULL_PATH_ADDR* Concatenation of Hyperlink Storage Path Address and Hyperlink File Name

* Note: can use full or relative path names. Relative path names are relative to the .mxd location.

GWIS Version: 1.6



TableGWIS_METADATA


Allow nulls

OBJECTID Object ID


METADATA_FILE_ADDR String Yes 255

METADATA_FILE_NAME String Yes 255

METADATA_FULL_PATH_ADDR String Yes 255


METADATA_ID Primary Key Identifier Relating Metadata Table to Associated Feature(s)

METADATA_FILE_ADDR Metadata File Storage Path Address

METADATA_FILE_NAME Metadata File Name

METADATA_FULL_PATH_ADDR Concatenation of Metadata Storage Path Address and Metadata File Name

2.10 Arc Hydro Generated Information

The tables described in this section are not part of the standard GWIS schema. They are

automatically created in the target workspace when using the Arc Hydro tools.


None identified.

2.10.2 Domain(s):

None identified.


None identified.


TableAPUNIQUEID


Allow nulls

OBJECTID Object ID

IDNAME String Yes 35

LASTID Double Yes 0 0


IDNAME Unique ID Name (e.g. HYDROID, MARINEID, etc.)

LASTID Last Assigned ID

GWIS Version: 1.6



TableLAYERKEYTABLE


Allow nulls

OBJECTID Object ID

IDFLDNAME String Yes 35

LAYERNAME String Yes 35

LAYERKEY String Yes 35


IDFLDNAME Unique ID Field Name

LAYERNAME Name of the Layer

LAYERKEY Layer Key for micromanaging HydroIDs between feature classes

The related tables APUNIQUEID and LAYERKEYTABLE allow the user the ability to specify the HydroID

starting point for each feature class. For example, to assign HydroIDs starting at 1000 for Catchments,

2000 for HydroJunctions, and 5000 for HydroEdges the tables could be set up as shown below.

gwis data dictionary v1.6 20140411

Documents