RAD Data Model

The RAD data model is closely related to the NHD Event Data Model with some extensions added to track historical data and supplemental attribute data. A RAD program stores two sets of event data - the current RAD program event data and the archive of all program event data. All current RAD program event data are also duplicated in the archive program event data. These layers contain dates to indicate the time frame for when an event is considered valid, and when appropriate a date indicating the cycle for the data. While most consumers of the RAD (mapping and database services) deal exclusively with current RAD program event data, a growing number of reporting tools allow historical analysis of RAD data via the archive.

Each RAD event is comprised of several records that tie together in the following manner:

Event Geometry Record:
Following the ESRI data model of separating point, linear and areal features into discrete layers, a RAD event is first defined as a point, line or area event. Point and line events describe observations occurring along NHD flowline features and area events describe observations occurring upon NHD waterbody features. Each geometry record is stored twice - once as ESRI SDE.ST_GEOMETRY and a second time as Oracle SDO_GEOMETRY.
Event to Metadata:
The event to metadata record ties together the event geometry record with its metadata record(s) and original id reference records. This table exists to allow the model to accommodate multiple metadata records for each event geometry record.
Event Metadata:
Event metadata tracks critical information about the submitter of the event. Note that the metadata record does not contain information about the particulars of the event itself. This must be obtained from the Water Program Databases.
Original Event ID Reference:
The original event ID reference records the original comid/event_id submitted with the event. This is useful when event records need to be traced back to their submission source.
Original Metadata ID:
The original metadata ID reference records the original duuid/metadata_id submitted with the event. This is useful when metadata records need to be traced back to their source.

So for any given RAD event program, there are twenty database tables interacting to provide current and archive information in both ESRI SDE.ST_GEOMETRY and Oracle Spatial SDO_GEOMETRY storage formats. The following illustration represents the twenty tables interacting the form the RAD 303D event program.

Each table data dictionary is outlined below.

RAD Point Event

Field Name
Data Type
NULL?
Description

comid
NUMBER(11) N
Unique numeric identification number for the event assigned during the RAD Event Maintenance process. This value replaces the comid/event_id submitted with the event in order to overcome problems of multiple originators submitting events with the same comid/entity_id.

eventdate
DATE
Y
The date the event was created or updated.

eventtype
VARCHAR2(30)
N
Value indicating the program for which the event has been created. Historically this has been the program abbreviation text but the integer domain value of the program is also acceptable. See RAD Programs for values of each program.

reachcode
VARCHAR2(14)
Y
The reach code value of the NHD waterbody feature the event occurs upon. When submitting custom or nonstandard event types, this field may be left NULL.

reachsmdate
DATE
Y
Date that the NHD reach code was assigned thus tying the event to a specific version of the NHD.

reachresolution
VARCHAR2(30)
N
Value indicating the resolution of the NHD waterbody feature the event occurs upon. Historically this field has been left NULL to indicate the default medium resolution but the field has been backfilled with 3 to expressly indicate this. See NHD Resolution Domain Table for the list of values.

source_originator
VARCHAR2(30)
N
Abbreviated name of the organization submitting the event.

source_datadesc
VARCHAR2(100)
Y
Descriptive field used to store auxiliary information about the indexing process or other critical data quality measures.

source_featureid
VARCHAR2(60)
Y
Foreign key to external program database.

featuredetailurl
VARCHAR2(99)
Y
Internet hyperlink to supplemental program information for the event record.

offset
NUMBER(12,7)
Y
Event display offset.

measure
NUMBER(12,4)
N
Point measure that the event occurs at upon the reached flowline.

geogstate
VARCHAR2(2)
N
Abbreviation of the state where the event takes place regardless of the source originator. In most cases this will be the same as source_originator, but they may differ in cases such that tribes, state cooperators, and other non-state specific organizations manage the data. This distinction allows for both state based and management-based analysis

cycle_year
VARCHAR2(4) Y
Optional field indicating a year for which the event is considered to be valid. Only a subset of programs track events via cycle year.

start_date
DATE
Y
The date by which the event first is considered to be valid.

end_date
DATE
Y
The date by which the event is considered to be closed.

wbd_huc12
VARCHAR2(12)
Y
WBD HUC12 unit that most encompasses the NHD feature.

wbd_huc12_percent
NUMBER
Y
Percentage of the feature contained within the WBD HUC12 unit.

navigable VARCHAR2(1) N Y/N flag indicating whether an event exists upon a NHD flowline feature which may be navigated using the Navigation Service. Mainly utilized by mapping services to either display or not display a navigation interface for a given event.

vertices
NUMBER
Y
Numeric count of individual vertices in the NHD feature.

shape
<geometry>
Y
MDSYS.SDO_GEOMETRY or SDE.ST_GEOMETRY object holding the unprojected NAD83 geometry of the event.

objectid
INTEGER
N
Unique numeric key used by ArcSDE.

RAD Line Event

Field Name
Data Type
NULL?
Description

comid
NUMBER(11) N
Unique numeric identification number for the event assigned during the RAD Event Maintenance process. This value replaces the comid/event_id submitted with the event in order to overcome problems of multiple originators submitting events with the same comid/entity_id.

eventdate
DATE
Y
The date the event was created or updated.

eventtype
VARCHAR2(30)
N
Value indicating the program for which the event has been created. Historically this has been the program abbreviation text but the integer domain value of the program is also acceptable. See RAD Programs for values of each program.

reachcode
VARCHAR2(14)
Y
The reach code value of the NHD waterbody feature the event occurs upon. When submitting custom or nonstandard event types, this field may be left NULL.

reachsmdate
DATE
Y
Date that the NHD reach code was assigned thus tying the event to a specific version of the NHD.

reachresolution
VARCHAR2(30)
N
Value indicating the resolution of the NHD waterbody feature the event occurs upon. Historically this field has been left NULL to indicate the default medium resolution but the field has been backfilled with 3 to expressly indicate this. See NHD Resolution Domain Table for the list of values.

source_originator
VARCHAR2(30)
N
Abbreviated name of the organization submitting the event.

source_datadesc
VARCHAR2(100)
Y
Descriptive field used to store auxiliary information about the indexing process or other critical data quality measures.

source_featureid
VARCHAR2(60)
Y
Foreign key to external program database.

featuredetailurl
VARCHAR2(99)
Y
Internet hyperlink to supplemental program information for the event record.

offset
NUMBER(12,7)
Y
Event display offset.

fmeasure
NUMBER(12,4) N
Linear Reference starting measure.

tmeasure
NUMBER(12,4)
N
Linear Reference ending measure.

shape_length
NUMBER(12,4)
N
Length of linear event in meters.

geogstate
VARCHAR2(2)
N
Abbreviation of the state where the event takes place regardless of the source originator. In most cases this will be the same as source_originator, but they may differ in cases such that tribes, state cooperators, and other non-state specific organizations manage the data. This distinction allows for both state based and management-based analysis

cycle_year
VARCHAR2(4) Y
Optional field indicating a year for which the event is considered to be valid. Only a subset of programs track events via cycle year.

start_date
DATE
Y
The date by which the event first is considered to be valid.

end_date
DATE
Y
The date by which the event is considered to be closed.

wbd_huc12
VARCHAR2(12)
Y
WBD HUC12 unit that most encompasses the NHD feature.

wbd_huc12_percent
NUMBER
Y
Percentage of the feature contained within the WBD HUC12 unit.

navigable VARCHAR2(1) N Y/N flag indicating whether an event exists upon a NHD flowline feature which may be navigated using the Navigation Service. Mainly utilized by mapping services to either display or not display a navigation interface for a given event.

vertices
NUMBER
Y
Numeric count of individual vertices in the NHD feature.

shape
<geometry>
Y
MDSYS.SDO_GEOMETRY or SDE.ST_GEOMETRY object holding the unprojected NAD83 geometry of the event.

objectid
INTEGER
N
Unique numeric key used by ArcSDE.

RAD Area Event

Field Name
Data Type
NULL?
Description

comid
NUMBER(11) N
Unique numeric identification number for the event assigned during the RAD Event Maintenance process. This value replaces the comid/event_id submitted with the event in order to overcome problems of multiple originators submitting events with the same comid/entity_id.

eventdate
DATE
Y
The date the event was created or updated.

eventtype
VARCHAR2(30)
N
Value indicating the program for which the event has been created. Historically this has been the program abbreviation text but the integer domain value of the program is also acceptable. See RAD Programs for values of each program.

reachcode
VARCHAR2(14)
Y
The reach code value of the NHD waterbody feature the event occurs upon. When submitting custom or nonstandard event types, this field may be left NULL.

reachsmdate
DATE
Y
Date that the NHD reach code was assigned thus tying the event to a specific version of the NHD.

reachresolution
VARCHAR2(30)
N
Value indicating the resolution of the NHD waterbody feature the event occurs upon. Historically this field has been left NULL to indicate the default medium resolution but the field has been backfilled with 3 to expressly indicate this. See NHD Resolution Domain Table for the list of values.

source_originator
VARCHAR2(30)
N
Abbreviated name of the organization submitting the event.

source_datadesc
VARCHAR2(100)
Y
Descriptive field used to store auxiliary information about the indexing process or other critical data quality measures.

source_featureid
VARCHAR2(60)
Y
Foreign key to external program database.

featuredetailurl
VARCHAR2(99)
Y
Internet hyperlink to supplemental program information for the event record.

shape_area
NUMBER(18,3)
N
Area of the event in square kilometers.

geogstate
VARCHAR2(2)
N
Abbreviation of the state where the event takes place regardless of the source originator. In most cases this will be the same as source_originator, but they may differ in cases such that tribes, state cooperators, and other non-state specific organizations manage the data. This distinction allows for both state based and management-based analysis

cycle_year
VARCHAR2(4) Y
Optional field indicating a year for which the event is considered to be valid. Only a subset of programs track events via cycle year.

start_date
DATE
Y
The date by which the event first is considered to be valid.

end_date
DATE
Y
The date by which the event is considered to be closed.

wbd_huc12
VARCHAR2(12)
Y
WBD HUC12 unit that most encompasses the NHD feature.

wbd_huc12_percent
NUMBER
Y
Percentage of the feature contained within the WBD HUC12 unit.

vertices
NUMBER
Y
Numeric count of individual vertices in the NHD feature.

shape
<geometry>
Y
MDSYS.SDO_GEOMETRY or SDE.ST_GEOMETRY object holding the unprojected NAD83 geometry of the event.

objectid
INTEGER
N
Unique numeric key used by ArcSDE.

RAD Event to Metadata

Field Name
Data Type
NULL?
Description

duuid
NUMBER(11)
N
Unique numeric identification number for the metadata record assigned during the RAD Event Maintenance process. This value replaces the duuid/meta_id submitted with the event in order to overcome problems of multiple originators submitting events with the same duuid/meta_id.

comid
NUMBER(11)
N
Unique numeric identification number for the event assigned during the RAD Event Maintenance process. This value replaces the comid/event_id submitted with the event in order to overcome problems of multiple originators submitting events with the same comid/entity_id.

RAD Metadata

Field Name
Data Type
NULL?
Description

duuid
NUMBER(9)
N
Unique numeric identification number for the metadata record assigned during the RAD Event Maintenance process. This value replaces the duuid/meta_id submitted with the event in order to overcome problems of multiple originators submitting events with the same duuid/meta_id.

processdescription
VARCHAR2(254)
N
Process used to create the event data.

processdate
DATE
N
Date the event data was processed.

contactorganization
VARCHAR2(50)
Y
Name of the organization responsible for the metadata record.

addresstype
VARCHAR2(15) Y
Type of address given (mail/physical).

address
VARCHAR2(100)
Y
Address of contact person.

city
VARCHAR2(25)
Y
City of contact person.

stateorprovince
VARCHAR2(30)
Y
State of contact person.

postalcode
VARCHAR2(11)
Y
Zip Code or Postal Code of contact person.

contactvoicetelephone
VARCHAR2(10)
Y
Voice phone number of contact person.

contactinstructions
VARCHAR2(99)
Y

contactemailaddress
VARCHAR2(75)
Y
Email Address of contact person.

status
VARCHAR2(4)
Y

supplinfo
VARCHAR2(99)
Y

RAD Original Event ID Reference

Field Name
Data Type
NULL?
Description

source_id
VARCHAR2(19)
N
The original comid/event_id value submitted with the event.

comid
NUMBER(11)
N
Unique numeric identification number for the event assigned during the RAD Event Maintenance process.

source_originator
VARCHAR2(30)
Y
The source originator value of the event, used to aid in creating a unique reference record.

start_date
DATE
Y
The start date value of the event, used to aid in creating a unique reference record.

RAD Original Metadata ID Reference

Field Name
Data Type
NULL?
Description

source_id
VARCHAR2(19)
N
The original duuid/meta_id value submitted with the metadata record.

duuid
NUMBER(9)
N
Unique numeric identification number for the metadata record assigned during the RAD Event Maintenance process.

Field Name	Data Type	NULL?	Description
comid	NUMBER(11)	N	Unique numeric identification number for the event assigned during the RAD Event Maintenance process. This value replaces the comid/event_id submitted with the event in order to overcome problems of multiple originators submitting events with the same comid/entity_id.
eventdate	DATE	Y	The date the event was created or updated.
eventtype	VARCHAR2(30)	N	Value indicating the program for which the event has been created. Historically this has been the program abbreviation text but the integer domain value of the program is also acceptable. See RAD Programs for values of each program.
reachcode	VARCHAR2(14)	Y	The reach code value of the NHD waterbody feature the event occurs upon. When submitting custom or nonstandard event types, this field may be left NULL.
reachsmdate	DATE	Y	Date that the NHD reach code was assigned thus tying the event to a specific version of the NHD.
reachresolution	VARCHAR2(30)	N	Value indicating the resolution of the NHD waterbody feature the event occurs upon. Historically this field has been left NULL to indicate the default medium resolution but the field has been backfilled with 3 to expressly indicate this. See NHD Resolution Domain Table for the list of values.
source_originator	VARCHAR2(30)	N	Abbreviated name of the organization submitting the event.
source_datadesc	VARCHAR2(100)	Y	Descriptive field used to store auxiliary information about the indexing process or other critical data quality measures.
source_featureid	VARCHAR2(60)	Y	Foreign key to external program database.
featuredetailurl	VARCHAR2(99)	Y	Internet hyperlink to supplemental program information for the event record.
offset	NUMBER(12,7)	Y	Event display offset.
measure	NUMBER(12,4)	N	Point measure that the event occurs at upon the reached flowline.
geogstate	VARCHAR2(2)	N	Abbreviation of the state where the event takes place regardless of the source originator. In most cases this will be the same as source_originator, but they may differ in cases such that tribes, state cooperators, and other non-state specific organizations manage the data. This distinction allows for both state based and management-based analysis
cycle_year	VARCHAR2(4)	Y	Optional field indicating a year for which the event is considered to be valid. Only a subset of programs track events via cycle year.
start_date	DATE	Y	The date by which the event first is considered to be valid.
end_date	DATE	Y	The date by which the event is considered to be closed.
wbd_huc12	VARCHAR2(12)	Y	WBD HUC12 unit that most encompasses the NHD feature.
wbd_huc12_percent	NUMBER	Y	Percentage of the feature contained within the WBD HUC12 unit.
navigable	VARCHAR2(1)	N	Y/N flag indicating whether an event exists upon a NHD flowline feature which may be navigated using the Navigation Service. Mainly utilized by mapping services to either display or not display a navigation interface for a given event.
vertices	NUMBER	Y	Numeric count of individual vertices in the NHD feature.
shape	<geometry>	Y	MDSYS.SDO_GEOMETRY or SDE.ST_GEOMETRY object holding the unprojected NAD83 geometry of the event.
objectid	INTEGER	N	Unique numeric key used by ArcSDE.