Help Files

NID Data Dictionary

NID Columns

Column NameDefinitionField Name
DAM_NAMEField DefinitionDam Name
OTHER_DAM_NAMEField DefinitionOther Dam Name
DAM_FORMER_NAMEField DefinitionDam Former Name
NIDIDField DefinitionNID ID
LONGITUDEField DefinitionLongitude
LATITUDEField DefinitionLatitude
SECTIONField DefinitionSection, Township, Range Location
COUNTYField DefinitionCounty
RIVERField DefinitionRiver
CITYField DefinitionCity
DISTANCEField DefinitionDistance to Nearest City/Town
OWNER_NAMEField DefinitionOwner Name
OWNER_TYPEField DefinitionOwner Type
DAM_DESIGNERField DefinitionDam Designer
PRIVATE_DAMField DefinitionNon-Federal Dam On Federal Property
DAM_TYPEField DefinitionDam Type
COREField DefinitionCore
FOUNDATIONField DefinitionFoundation
PURPOSESField DefinitionPurposes
YEAR_COMPLETEDField DefinitionYear Completed
YEAR_MODIFIEDField DefinitionYear Modified
DAM_LENGTHField DefinitionDam Length
DAM_HEIGHTField DefinitionDam Height
STRUCTURAL_HEIGHTField DefinitionStructural Height
HYDRAULIC_HEIGHTField DefinitionHydraulic Height
NID_HEIGHTField DefinitionNID Height
MAX_DISCHARGEField DefinitionMaximum Discharge
MAX_STORAGEField DefinitionMaximum Storage
NORMAL_STORAGEField DefinitionNormal Storage
NID_STORAGEField DefinitionNID Storage
SURFACE_AREAField DefinitionSurface Area
DRAINAGE_AREAField DefinitionDrainage Area
HAZARDField DefinitionDownstream Hazard Potential
EAPField DefinitionEmergency Action Plan
INSPECTION_DATEField DefinitionInspection Date
INSPECTION_FREQUENCYField DefinitionInspection Frequency
STATE_REG_DAMField DefinitionState Regulated Dam
STATE_REG_AGENCYField DefinitionState Regulatory Agency
SPILLWAY_TYPEField DefinitionSpillway Type
SPILLWAY_WIDTHField DefinitionSpillway Width
OUTLET_GATESField DefinitionOutlet Gates
VOLUMEField DefinitionVolume
NUMBER_OF_LOCKSField DefinitionNumber of Locks
LENGTH_OF_LOCKSField DefinitionLength of Locks
WIDTH_OF_LOCKSField DefinitionWidth of Locks
FED_FUNDINGField DefinitionFederal Agency Involvement in Funding
FED_DESIGNField DefinitionFederal Agency Involvement in Design
FED_CONSTRUCTIONField DefinitionFederal Agency Involvement in Construction
FED_REGULATORYField DefinitionFederal Agency Involvement in Regulatory
FED_INSPECTIONField DefinitionFederal Agency Involvement in Inspection
FED_OPERATIONField DefinitionFederal Agency Involvement in Operation
FED_OWNERField DefinitionFederal Agency Owner
FED_OTHERField DefinitionFederal Agency Other
SOURCE_AGENCYField DefinitionSource Agency
STATEField DefinitionState
URL_ADDRESSField DefinitionURL Address
CONG_NAMEField DefinitionCongressional Representative
PARTYField DefinitionCongressional Representative Party
CONG_DISTField DefinitionCongressional Representative District
OTHERSTRUCTUREIDField DefinitionOther Structure ID
NUMSEPARATESTRUCTURESField DefinitionNumber Separate Structures
PERMITTINGAUTHORITYField DefinitionPermitting Authority
INSPECTIONAUTHORITYField DefinitionInspection Authority
ENFORCEMENTAUTHORITYField DefinitionEnforcement Authority
JURISDICTIONALDAMField DefinitionState Jurisdictional Dam
CONDITIONASSESSMENTField DefinitionCondition Assessment*
CONDITIONASSESSMENTDETAILField DefinitionCondition Assessment Detail*
CONDITIONASSESSMENTDATEField DefinitionCondition Assessment Date*
EAP_LAST_REV_DATEField DefinitionDate of Last Revision of Emergency Action Plan
Fields marked with a * are restricted to Government users only.

Modification Type (from Year Modified)

CodeValue
Sstructural
Ffoundation
Mmechanical
Eseismic
Hhydraulic
Oother

Hazard (Potential)

CodeValue
LLow
SSignificant
HHigh
UUndetermined
NNot Available

Core Type

CODEVALUE
ABituminous Concrete
CConcreate
EEarth
MMetal
PPlastic
XUnknown

Dam Type

CodeValue
REEarth
ERRockfill
PGGravity
CBButtress
VAArch
MVMulti-Arch
CNConcrete
MSMasonry
STStone
TCTimber Crib
OTOther
RCRCC

Core Position

CODEVALUE
FUpstream Facing
HHomogeneous
ICore
XUnknown

Owner Type

CodeValue
FFederal
SState
LLocal Government
UPublic Utility
PPrivate
XNot Listed

Core Certainty

CODEVALUE
KKnown
ZEstimated

EAP

CODEVALUE
YYes
NNo
NRNot Required

Foundation Type

CODEVALUE
RSRock & Soil
RRock
SSoil
UUnknown

Foundation Certainty

CODEVALUE
KKnown
ZEstimated

Spillway Type

CODEVALUE
CControlled
UUncontrolled
NNone

Purposes

CodeValue
IIrrigation
HHydroelectric
CFlood Control
NNavigation
SWater Supply
RRecreation
PFire Protection, Stock, Or Small Fish Pond
FFish and Wildlife Pond
DDebris Control
TTailings
OOther
GGrade Stabilization