Back to fileView metadata
Schema
National Inventory of Dams (NID) / National Inventory of Dams (NID) / v1.0.0
Schema from national-inventory-of-dams-nid-1.parquet, gcs-hifld-next-datasets-prod, v1.0.0.
A Brief History of the NIDThe site we see today was first conceptualized in the 1970s when Congress tasked the U.S. Army Corps of Engineers (USACE) with identifying, inspecting, and inventorying dams in the U.S (National Dam Inspection Act, PL 92-367).Early data gathering for the NID was led by USACE, which published the first inventory in 1975. By 1982, the NID included 68,153 dam records gathered from dam inspections, extensive record searches, and some feature extraction from aerial imagery. These NID databases were available on diskettes and compact discs.In the late 1990s, the NID was transitioned to a web-based platform and viewing the data on a map. Gathering data on dams also transitioned during this time - the most accurate data was now coming from states, territories, and federal agencies. This transition aligned with the establishment of the National Dam Safety Program.Information Available in the NIDSince transitioning to a web-based platform, site visitors have been able to download or export certain data. The NID is currently the only place to find and download national data at such a detailed level.Today, the database contains information for more than 91,000 dams that meet the following criteria:Dams where a failure or mis-operation will likely result in loss of human life (high hazard potential).Dams where a failure or mis-operation would likely result in disruption of access to critical facilities, damage to public and private facilities, and require difficult mitigation efforts (significant hazard potential).Dams that meet minimum height and reservoir size requirements, even though they do not pose the same level of life or economic risk as those above – these dams are equal to or exceed 25 feet in height and exceed 15 acre-feet in storage, or equal to or exceeding 50 acre-feet in storage and exceeding 6 feet in height.The NID does not yet contain all dams in the U.S. that meet these criteria. Continued, routine updates to the NID and enhanced data collection efforts, focused on the most reliable data sources (primarily the many federal and state government dam regulatory programs), will help capture these dams and result in a more robust dataset over time.National Inventory of DamsContact NID at NID@usace.army.mil
Columns
83 columns
Features
92,366
Geometry
Point Z
| Column | Type | Nullable | Nulls | Unique | Description | Examples / Values |
|---|---|---|---|---|---|---|
| geometry | geometry | No | 0 | — | — Range: —Length: — | Examples: — Values: — |
| OBJECTID | integer | No | 0 | — | — Range: 1 to 5000Length: — | Examples: 399, 3834, 4837, 4573, 637 Values: — |
| NIDID | string | No | 0 | — | — Range: —Length: 8 | Examples: GA01167, IA01609, CA01039, MO10051, IA01170 Values: — |
| OTHER_STRU | string | Yes | 4,945 | — | — Range: —Length: 16 | Examples: S02, S001, S001, MT01090, S002 Values: MT00072, MT00653, MT01090, S001, S002, S003, S004, S005, S006, S009, S02 |
| FEDERAL_ID | string | No | 0 | — | — Range: —Length: 11 | Examples: GA01167, IA01609, CA01039, MO10051, IA01170 Values: — |
| DATA_UPDAT | string | No | 0 | — | — Range: —Length: 10 | Examples: 2021-04-20, 2025-03-06, 2025-04-02, 2018-05-25, 2025-03-06 Values: — |
| NAME | string | Yes | 235 | — | — Range: —Length: 78 | Examples: Cecil Lake Dam, Hungerford Lake Dam, R & F Lamira Freshwater Dam, Twin Forks, Linde Values: — |
| OTHER_NAME | string | Yes | 3,602 | — | — Range: —Length: 69 | Examples: Wilburn Morris Dam, Little Delaware Mission Cr WS Dam 10, Simpson Site E-74 Dam, Willisburg Lake, Upper Verdigris Watershed Dam 9-2 Values: — |
| OWNER_TYPE | string | No | 0 | — | — Range: —Length: 25 | Examples: Private, Local Government, Private, Local Government, Local Government Values: Federal, Local Government, Local Government, Private, Local Government, State, Not Listed, Private, Private, Public Utility, Private, State, Public Utility, State |
| PRIMARY_OW | string | No | 0 | — | — Range: —Length: 16 | Examples: Private, Local Government, Private, Local Government, Local Government Values: Federal, Local Government, Not Listed, Private, Public Utility, State |
| STATE_FED_ | string | Yes | 1,441 | — | — Range: —Length: 15 | Examples: 01889-01-06, 163-0170, 4143, 400503, 019008 Values: — |
| NUMBER_ASS | integer | No | 0 | — | — Range: 0 to 11Length: — | Examples: 0, 0, 0, 0, 0 Values: — |
| DESIGNER_N | string | Yes | 2,491 | — | — Range: —Length: 109 | Examples: USDA NRCS, USDA NRCS, SCS, DONALD J. LIVINGSTON, J. RUSSELL HOCHSTETLER Values: — |
| NON_FED_ON | string | Yes | 687 | — | — Range: —Length: 3 | Examples: Yes, No, No, No, No Values: No, Yes |
| STATE_REGU | string | Yes | 244 | — | — Range: —Length: 3 | Examples: Yes, Yes, No, Yes, No Values: No, Yes |
| STATE_JURI | string | Yes | 29 | — | — Range: —Length: 3 | Examples: No, No, No, Yes, Yes Values: No, Yes |
| STATE_RE_1 | string | Yes | 1,120 | — | — Range: —Length: 51 | Examples: Department of Conservation and Recreation, DANR, SEO, Pennsylvania Department of Environmental Protection, NYS DEC Values: — |
| STATE_PERM | string | Yes | 29 | — | — Range: —Length: 3 | Examples: Yes, Yes, Yes, Yes, Yes Values: No, Yes |
| STATE_INSP | string | Yes | 29 | — | — Range: —Length: 3 | Examples: Yes, Yes, Yes, Yes, Yes Values: No, Yes |
| STATE_ENFO | string | Yes | 29 | — | — Range: —Length: 3 | Examples: Yes, Yes, Yes, Yes, Yes Values: No, Yes |
| PRIMARY_SO | string | No | 0 | — | — Range: —Length: 9 | Examples: GA, IA, CA, MO, IA Values: — |
| LATITUDE | float | No | 0 | — | — Range: 18.16167 to 61.350500000000004Length: — | Examples: 33.898194, 42.2569, 38.437200000000004, 40.28688261, 42.4223 Values: — |
| LONGITUDE | float | No | 0 | — | — Range: -176.67633 to -66.52665999999999Length: — | Examples: -85.09141699999999, -95.60390000000001, -122.944, -94.02620319, -95.9809 Values: — |
| STATE | string | No | 0 | — | — Range: —Length: 14 | Examples: Georgia, Iowa, California, Missouri, Iowa Values: — |
| COUNTYSTAT | string | Yes | 1 | — | — Range: —Length: 36 | Examples: Henry, Missouri, Barton, Missouri, Mitchell, Georgia, Madison, Iowa, Lowndes, Alabama Values: — |
| CITY | string | Yes | 1,489 | — | — Range: —Length: 34 | Examples: PRINCETON, TARRY, NEVADA, WORLAND WY, SHANES DAIRY Values: — |
| DISTANCE | float | Yes | 2,081 | — | — Range: 0 to 154Length: — | Examples: 0.0, 20.0, 0.0, 0.04, 1.0 Values: — |
| RIVER_OR_S | string | Yes | 463 | — | — Range: —Length: 77 | Examples: Allen Mill Creek, TR-TERRE BLEUE CREEK, HOLMES CREEK, HENRY BRANCH, TR-ROBINSON CREEK Values: — |
| CONGDIST | string | No | 0 | — | — Range: —Length: 41 | Examples: Congressional District 03, Georgia, Congressional District 04, Iowa, Congressional District 02, California, Congressional District 06, Missouri, Congressional District 04, Iowa Values: — |
| CONG_REPRE | string | Yes | 233 | — | — Range: —Length: 36 | Examples: Bruce Westerman (R), Greg Gianforte (R), Roger W. Marshall (R), Vicky Hartzler (R), Richard E. Neal (D) Values: — |
| FED_AGENCY | string | Yes | 4,848 | — | — Range: —Length: 36 | Examples: US Army Corps of Engineers, Bureau of Land Management, Department of Energy, Bureau of Land Management, US Army Corps of Engineers Values: Bureau of Indian Affairs, Bureau of Land Management, Bureau of Reclamation, Department of Energy, Federal Energy Regulatory Commission, Fish and Wildlife Service, Forest Service, National Park Service, Tennessee Valley Authority, US Air Force, US Army, US Army Corps of Engineers, US Navy |
| FED_AGEN_1 | string | Yes | 4,280 | — | — Range: —Length: 38 | Examples: Bureau of Land Management, Natural Resources Conservation Service, Natural Resources Conservation Service, Natural Resources Conservation Service, Natural Resources Conservation Service Values: Bureau of Indian Affairs, Bureau of Land Management, Bureau of Reclamation, Department of Energy, Forest Service, National Park Service, Natural Resources Conservation Service, Tennessee Valley Authority, US Air Force, US Army, US Army Corps of Engineers, US Navy |
| FED_AGEN_2 | string | Yes | 3,599 | — | — Range: —Length: 54 | Examples: US Army Corps of Engineers, Natural Resources Conservation Service, Natural Resources Conservation Service, Natural Resources Conservation Service, Natural Resources Conservation Service Values: Bureau of Indian Affairs, Bureau of Land Management, Department of Energy, Fish and Wildlife Service, Forest Service, Forest Service, Natural Resources Conservation Service, Forest Service, US Army Corps of Engineers, Natural Resources Conservation Service, Natural Resources Conservation Service, US Army, Tennessee Valley Authority, US Air Force, US Army, US Army Corps of Engineers, US Army, US Navy, US Navy |
| FED_AGEN_3 | string | Yes | 4,294 | — | — Range: —Length: 54 | Examples: Natural Resources Conservation Service, Natural Resources Conservation Service, Natural Resources Conservation Service, Natural Resources Conservation Service, Natural Resources Conservation Service Values: Bureau of Indian Affairs, Bureau of Land Management, Department of Energy, Fish and Wildlife Service, Forest Service, Forest Service, Natural Resources Conservation Service, Natural Resources Conservation Service, Tennessee Valley Authority, US Air Force, US Army, US Army Corps of Engineers, US Navy |
| FED_AGEN_4 | string | Yes | 4,744 | — | — Range: —Length: 64 | Examples: Federal Energy Regulatory Commission, US Army Corps of Engineers, Bureau of Land Management, US Army Corps of Engineers, US Army, US Army Corps of Engineers Values: Bureau of Indian Affairs, Bureau of Land Management, Bureau of Reclamation, Department of Energy, Federal Energy Regulatory Commission, Federal Energy Regulatory Commission, US Army Corps of Engineers, Fish and Wildlife Service, Forest Service, Mine Safety and Health Administration, National Park Service, Nuclear Regulatory Commission, Tennessee Valley Authority, US Air Force, US Army, US Army Corps of Engineers, US Navy |
| FED_AGEN_5 | string | Yes | 4,167 | — | — Range: —Length: 64 | Examples: Federal Energy Regulatory Commission, Natural Resources Conservation Service, Natural Resources Conservation Service, Natural Resources Conservation Service, Natural Resources Conservation Service Values: Bureau of Indian Affairs, Bureau of Land Management, Bureau of Reclamation, Department of Energy, Federal Energy Regulatory Commission, Federal Energy Regulatory Commission, US Army Corps of Engineers, Fish and Wildlife Service, Forest Service, Mine Safety and Health Administration, National Park Service, Natural Resources Conservation Service, Nuclear Regulatory Commission, Tennessee Valley Authority, US Air Force, US Army, US Army Corps of Engineers, US Navy |
| FED_AGEN_6 | string | Yes | 4,854 | — | — Range: —Length: 26 | Examples: Tennessee Valley Authority, Bureau of Reclamation, Tennessee Valley Authority, Bureau of Reclamation, Tennessee Valley Authority Values: Bureau of Indian Affairs, Bureau of Land Management, Bureau of Reclamation, Department of Energy, Fish and Wildlife Service, Forest Service, National Park Service, Tennessee Valley Authority, US Air Force, US Army, US Army Corps of Engineers, US Navy |
| FED_AGEN_7 | string | Yes | 4,942 | — | — Range: —Length: 36 | Examples: US Army Corps of Engineers, US Army Corps of Engineers, US Army Corps of Engineers, Federal Energy Regulatory Commission, Fish and Wildlife Service Values: Bureau of Indian Affairs, Bureau of Reclamation, Federal Energy Regulatory Commission, Fish and Wildlife Service, US Air Force, US Army Corps of Engineers, US Navy |
| PRIMARY_PU | string | Yes | 316 | — | — Range: —Length: 42 | Examples: Recreation, Flood Risk Reduction, Recreation, Recreation, Recreation Values: Debris Control, Fire Protection, Stock, Or Small Fish Pond, Fish and Wildlife Pond, Flood Risk Reduction, Grade Stabilization, Hydroelectric, Irrigation, Navigation, Other, Recreation, Tailings, Water Supply |
| PURPOSES | string | Yes | 316 | — | — Range: —Length: 107 | Examples: Recreation, Flood Risk Reduction, Recreation, Recreation, Recreation Values: — |
| PRIMARY_DA | string | Yes | 421 | — | — Range: —Length: 25 | Examples: Earth, Earth, Earth, Earth, Earth Values: Arch, Buttress, Concrete, Earth, Gravity, Masonry, Multi-Arch, Other, Rockfill, Roller-Compacted Concrete, Stone, Timber Crib |
| DAM_TYPES | string | Yes | 392 | — | — Range: —Length: 40 | Examples: Earth, Gravity, Earth, Earth, Earth Values: — |
| CORE_TYPES | string | Yes | 2,549 | — | — Range: —Length: 25 | Examples: Buttress, Multi-Arch, Stone, Buttress, Buttress Values: Arch, Buttress, Buttress, Multi-Arch, Buttress, Stone, Multi-Arch, Multi-Arch, Stone, Rockfill, Roller-Compacted Concrete, Stone |
| FOUNDATION | string | Yes | 2,577 | — | — Range: —Length: 16 | Examples: Soil, Unlisted/Unknown, Unlisted/Unknown, Unlisted/Unknown, Soil Values: Rock, Rock, Soil, Soil, Unlisted/Unknown |
| DAM_HEIGHT | float | Yes | 541 | — | — Range: 2 to 482Length: — | Examples: 20.0, 26.0, 42.0, 20.0, 26.0 Values: — |
| HYDRAULIC_ | float | Yes | 2,001 | — | — Range: 0 to 424Length: — | Examples: 43.0, 13.0, 13.0, 8.0, 38.0 Values: — |
| STRUCTURAL | float | Yes | 2,097 | — | — Range: 0 to 440Length: — | Examples: 28.0, 33.0, 23.0, 17.0, 25.0 Values: — |
| NID_HEIGHT | integer | No | 0 | — | — Range: 0 to 482Length: — | Examples: 39, 40, 44, 33, 25 Values: — |
| DAM_LENGTH | float | Yes | 746 | — | — Range: 0 to 61166Length: — | Examples: 1800.0, 1200.0, 440.0, 2140.0, 28800.0 Values: — |
| DAM_VOLUME | string | Yes | 4,971 | — | — Range: —Length: 7 | Examples: 186000, 315200, 376300, 7370000, 8144000 Values: — |
| YEAR_COMPL | float | Yes | 995 | — | — Range: 1637 to 2023Length: — | Examples: 1955.0, 1977.0, 1973.0, 1975.0, 1995.0 Values: — |
| NID_STORAG | float | Yes | 134 | — | — Range: 0 to 7535400Length: — | Examples: 92.0, 8.0, 270.0, 468.0, 640.0 Values: — |
| MAX_STORAG | float | Yes | 167 | — | — Range: 0 to 7535400Length: — | Examples: 237.0, 86.0, 520.0, 110.0, 1084.0 Values: — |
| NORMAL_STO | float | Yes | 361 | — | — Range: 0 to 6127470Length: — | Examples: 171.0, 43.0, 258.0, 66.0, 21.3 Values: — |
| SURFACE_AR | float | Yes | 1,000 | — | — Range: 0 to 160300Length: — | Examples: 43.0, 13.5, 80.0, 20.0, 1000.0 Values: — |
| DRAINAGE_A | float | Yes | 1,450 | — | — Range: 0 to 8300000Length: — | Examples: 0.1, 992.0, 2.2, 1.2, 0.19 Values: — |
| MAX_DISCHA | float | Yes | 2,560 | — | — Range: 0 to 775000Length: — | Examples: 26.0, 0.0, 64.0, 270.0, 625.0 Values: — |
| SPILLWAY_T | string | Yes | 1,950 | — | — Range: —Length: 12 | Examples: Uncontrolled, Controlled, None, Controlled, Uncontrolled Values: Controlled, None, Uncontrolled |
| SPILLWAY_W | float | Yes | 2,669 | — | — Range: 0 to 18530Length: — | Examples: 50.0, 200.0, 160.0, 16.0, 89.0 Values: — |
| NUMBER_OF_ | float | Yes | 3,073 | — | — Range: 0 to 2Length: — | Examples: 0.0, 0.0, 0.0, 0.0, 0.0 Values: — |
| LENGTH_OF_ | float | Yes | 3,091 | — | — Range: 0 to 1200Length: — | Examples: 0.0, 0.0, 0.0, 0.0, 0.0 Values: — |
| WIDTH_OF_L | float | Yes | 3,091 | — | — Range: 0 to 110Length: — | Examples: 0.0, 0.0, 0.0, 0.0, 0.0 Values: — |
| YEARS_MODI | string | Yes | 4,876 | — | — Range: —Length: 111 | Examples: 1968 - Hydraulic, 2008 - Hydraulic, 2008 - Mechanical, 2010 - Mechanical, 1993 - Structural, 2002 - Hydraulic, 2002 - Mechanical, 2002 - Seismic, 2004 - Hydraulic, 2004 - Structural, 2020 - Hydraulic Values: — |
| OUTLET_GAT | string | Yes | 2,865 | — | — Range: —Length: 67 | Examples: Uncontrolled, Uncontrolled - 2, Uncontrolled, None, Valve - 1 Values: — |
| ASSOCIATED | string | Yes | 4,932 | — | — Range: —Length: 141 | Examples: KY05017, KY05017S002, KY05017S003, KY05017S004, KY05017S005, MI00153S001, MI00153S002, MI00153S003, MI00153S004, TN15501S001, TN15501S002, TN15501S003, TN15501S004, TN15501S005, TN15501S006, TN15501S007, TN15501S008, TN15501S009, TN15501S010, TN15501S011, CA00420S001, SC00706S001, SC00706S002, SC00706S003, SC00706S004, SC00706S005, SC00706S006, SC00706S007 Values: — |
| LAST_INSPE | string | Yes | 1,898 | — | — Range: —Length: 10 | Examples: 2025-03-06, 2018-05-23, 2017-08-09, 2018-08-22, 2020-08-27 Values: — |
| INSPECTION | float | Yes | 1,875 | — | — Range: 0 to 12Length: — | Examples: 5.0, 5.0, 2.0, 5.0, 1.0 Values: — |
| HAZARD_POT | string | No | 0 | — | — Range: —Length: 12 | Examples: Low, Low, High, High, Low Values: High, Low, Significant, Undetermined |
| CONDITION_ | string | Yes | 929 | — | — Range: —Length: 14 | Examples: Not Rated, Satisfactory, Not Rated, Satisfactory, Not Rated Values: Fair, Not Available, Not Rated, Poor, Satisfactory, Unsatisfactory |
| CONDITIO_1 | string | Yes | 2,814 | — | — Range: —Length: 10 | Examples: 2023-09-29, 2022-10-12, 2021-12-15, 2018-06-28, 2022-05-17 Values: — |
| EAP_PREPAR | string | Yes | 4,968 | — | — Range: —Length: 3 | Examples: Yes, Yes, Yes, Yes, Yes Values: Yes |
| EAP_LAST_R | string | Yes | 4,047 | — | — Range: —Length: 10 | Examples: 2024-04-15, 2012-12-11, 2024-03-01, 2013-02-01, 2019-06-12 Values: — |
| SE_ANNO_CA | string | Yes | 5,000 | — | — Range: —Length: — | Examples: — Values: — |
| FORMER_NAM | string | Yes | 4,495 | — | — Range: —Length: 70 | Examples: Str R-38, 0, SCS-Salt Creek Site-38, Cox Richard, Columbus Values: — |
| IS_ASSOCIA | string | No | 0 | — | — Range: —Length: 3 | Examples: No, No, No, No, No Values: No, Yes |
| AIANNH | string | Yes | 4,701 | — | — Range: —Length: 70 | Examples: Standing Rock Reservation, Kiowa-Comanche-Apache-Fort Sill Apache OTSA, Kickapoo (KS) Reservation, Uintah and Ouray Reservation, Creek OTSA Values: — |
| FEDERALLY_ | string | No | 0 | — | — Range: —Length: 3 | Examples: No, No, No, No, No Values: No, Yes |
| BUILT_UNDE | string | No | 0 | — | — Range: —Length: 3 | Examples: No, Yes, No, No, Yes Values: No, Yes |
| NRCS_WATER | string | Yes | 94 | — | — Range: —Length: 73 | Examples: Flood Control Act of 1944 (Public Law 78-534), N/A, N/A, N/A, N/A Values: 1953 Pilot Watershed Program (Public Law 83-156), 1962 Resource Conservation and Development Act (Public Law 87-703), Flood Control Act of 1944 (Public Law 78-534), N/A, Watershed Protection and Flood Prevention Act of 1954 (Public Law 83-566) |
| OPERATIONA | string | Yes | 4,054 | — | — Range: —Length: 68 | Examples: Normal Operations, Normal Operations, Normal Operations, Not Applicable, Not Applicable Values: Enforcement Pending/Ongoing, Normal Operations, Not Applicable, Under Investigation, Planning, Permitting, or Design for Remediation, Under Remediation |
| OPERATIO_1 | string | Yes | 4,074 | — | — Range: —Length: 10 | Examples: 2022-05-21, 2024-01-23, 2017-05-25, 2023-09-29, 2024-05-28 Values: — |
| WEBSITE_UR | string | No | 0 | — | — Range: —Length: 106 | Examples: https://damsafety.org/georgia, https://damsafety.org/iowa, https://damsafety.org/california, https://damsafety.org/missouri, https://damsafety.org/iowa Values: — |
| id | integer | No | 0 | — | — Range: 1 to 5000Length: — | Examples: 399, 3834, 4837, 4573, 637 Values: — |
Quality checks: Passed
Invalid geometry count: 0
Columns hash: 1093afaa874d836b0edd36253f8b99257a66e5cf6e843ca0faea7b6fcd3f0767