US National Inventory of Dams

From OpenStreetMap Wiki
Jump to navigation Jump to search
Front page of the United States National Inventory of Dams
Front page of the National Inventory of Dams

The United States National Inventory of Dams is maintained by the U.S. Army Corp of Engineers and has an ID number for each dam they've cataloged in the United States. In OpenStreetMap the NID's ID number can be stored on dams and weirs using ref:US:NID=*.

The U.S. Army Corp of Engineers maintains the database as well as many of the largest dams in it. However information on most of the over 90,000 dams recorded in it are provided to them by state-level agencies. This article was created to document progress on tagging dams in OSM with their NID ID where applicable. This article also serves as a place to record information on the other state-level agencies in the United States that catalog information on dams.

For more information about the NID, please also see Key:ref:US:NID.

Identifying and tagging dams in the United States

Map from Mapshaper showing OSM objects tagged with ref:US:NID
OSM objects tagged with ref:US:NID=* as of December 29, 2023
Map from Mapshaper showing locations from the U.S. National Inventory of Dams not represented in OpenStreetMap
NID dams not tagged in OSM as of December 29, 2023
Map from Mapshaper OSM objects tagged with ref:US:NID in green, and coordinates from the U.S. National Inventory of Dams not tagged in OSM in blue
NID dams tagged in OSM in green, and not tagged in OSM in blue as of December 29, 2023

As of December 28, 2023 47,339 dams and weirs in the United States have been tagged with ref:US:NID=*, representing 46,687 unique NID dams. This number is most likely the high-water mark, at least until more dams are created in OSM.

From the 50 MapRoulette challenges listed below, all have been completed. Nine users participated, accepting 11,031 of the 12,263 tag change tasks.

At present 55.08% of the 85,942 existing dams and weirs in the United States in OSM have been tagged with ref:US:NID=*. These cover 50.83% of the 91,843 dams in the NID.

Map from Overpass turbo showing waterway=dam nodes in OSM not tagged with ref:US:NID
Remaining waterway=dam nodes not matched to the NID as of December 29, 2023 https://overpass-turbo.eu/s/1FmS

Regarding GNIS, there are 56,959 dams listed in the historical files updated for the final time in 2021 and 48,969 of them still exist in OSM, the 8k difference having been deleted sometime in the past decade or possibly never imported. Of the 49k still existing, 41,836 have been matched and tagged with ref:US:NID=*. Of the remaining 7 thousand, about 1 thousand have been turned into ways already and likely exist where they are drawn. Of the remaining just over 6,000 GNIS-imported nodes still out there that couldn't be cross referenced with the NID, the data from the individual states could still be used to confirm their names and locations but no action on that front has been taken yet.

During the past two months, approximately 4,700 GNIS dam nodes were manually moved at least 100 meters to put them closer to where they belong thanks to the coordinates from the NID. Approximately 2,000 of those also had a reservoir node at the same coordinates that was moved with it. (Examples: 143630801 (achavi, OSMLab), 143628532 (achavi, OSMLab))

For the 30,586 dam nodes tagged with ref:US:NID=*, they should mostly be within 500 meters or less of where they belong and it should hopefully be possible for mappers to tell what body of water they belong next to based on satellite imagery.

There are still some dam nodes where both GNIS and the NID confirm the location of a dam and yet nothing is visible on satellite. These dams may be gone, or the NID could still be updated in the future with better coordinates. For example, Alabama's office in charge of regulating dams was only established in 2023, and will likely provide updates to the NID in the future.


The below table details efforts during November and December 2023 to tag existing OSM dams and weirs.

  • Matches by name and location
    • If a dam in the NID is within about a kilometer of a dam in OSM and one of its name fields matches after considering differences such as "Number One" vs. "No. 1", then the OSM node, way, or relation was tagged with ref:US:NID=*.
  • Possible matches by location
    • If the coordinates of a dam in the NID are within about 750 meters of a dam or weir in OSM, and the additional dam data from the particular state doesn't show another non-NID dam existing any closer, then a MapRoulette task was created to ask if tagging the dam or weir is appropriate (example).

A table of the conflated data is at US National Inventory of Dams/Data Conflation (Page 2) (Page 3) (Page 4) (Page 5) (Page 6) (Page 7) (Page 8).

A project containing all of the MapRoulette challenges is at Dam IDs in the United States.

State Relation Date OSM dams & weirs NID dam count Already tagged Matched by name and location Changeset Possible match by location MapRoulette Challenge Done
Ohio relation 162061 2023-10-30 1,030 1,425 43 430 [1] 143393429 (achavi, OSMLab) 252 [1] Add dam ID tags in Ohio
Kentucky relation 161655 2023-10-31 329 1,083 5 33 [1] 143449963 (achavi, OSMLab) 139 [1] Add dam ID tags in Kentucky
Indiana relation 161816 2023-11-01 718 1,092 34 354 [1] 143507242 (achavi, OSMLab) 181 [1] Add dam ID tags in Indiana
West Virginia relation 162068 2023-11-02 506 562 41 165 [1] 143555791 (achavi, OSMLab) 136 [1] Add dam ID tags in West Virginia
Michigan relation 165789 2023-11-03 464 1,040 14 75 [1] 143595055 (achavi, OSMLab) 170 [1] Add dam ID tags in Michigan
Oklahoma relation 161645 2023-11-04 4,640 5,021 210 2,547 [1] 143633583 (achavi, OSMLab) 1,168 [1] Add dam ID tags in Oklahoma
Georgia relation 161957 2023-11-05 9,237 5,455 110 1,710 [2] 143671762 (achavi, OSMLab) 1,294 [2] Add dam ID tags in Georgia
Florida relation 162050 2023-11-05 1,150 1,069 23 47 [2] 143675040 (achavi, OSMLab) 51 [2] Add dam ID tags in Florida
Tennessee relation 161838 2023-11-06 1,751 1,238 53 427 [2] 143711427 (achavi, OSMLab) 263 [2] Add dam ID tags in Tennessee
Delaware relation 162110 2023-11-06 58 83 3 1 [2] 143716074 (achavi, OSMLab) 13 [2] Add dam ID tags in Delaware
Rhode Island relation 392915 2023-11-07 181 235 12 107 [2] 143760415 (achavi, OSMLab) 19 [2] Add dam ID tags in Rhode Island
Connecticut relation 165794 2023-11-08 1,437 834 59 480 [2] 143804982 (achavi, OSMLab) 197 [2] Add dam ID tags in Connecticut
Arkansas relation 161646 2023-11-09 1,098 1,269 29 827 [2] 143844691 (achavi, OSMLab) 147 [2] Add dam ID tags in Arkansas
Hawaii relation 166563 2023-11-10 73 128 6 0 N/A 11 [2] Add dam ID tags in Hawaii
Alaska relation 1116270 2023-11-10 80 111 5 8 [2] 143877111 (achavi, OSMLab) 17 [2] Add dam ID tags in Alaska
New Jersey relation 224951 2023-11-11 666 829 24 249 [2] 143919224 (achavi, OSMLab) 155 [2] Add dam ID tags in New Jersey
Kansas relation 161644 2023-11-12 619 6,427 15 136 [2] 143938814 (achavi, OSMLab) 209 [2] Add dam ID tags in Kansas
Texas relation 114690 2023-11-12 6,940 7,381 104 4,413 [3] 143955671 (achavi, OSMLab) 663 [3] Add dam ID tags in Texas
California relation 165475 2023-11-13 2,996 1,530 44 828 [3] 143991584 (achavi, OSMLab) 480 [3] Add dam ID tags in California
New Mexico relation 162014 2023-11-14 1,275 401 22 177 [4] 144033260 (achavi, OSMLab) 121 [4] Add dam ID tags in New Mexico
Arizona relation 162018 2023-11-15 2,151 375 35 159 [4] 144077011 (achavi, OSMLab) 54 [4] Add dam ID tags in Arizona
Alabama relation 161950 2023-11-16 1,939 2,266 95 1,221 [4] 144119374 (achavi, OSMLab) 135 [4] Add dam ID tags in Alabama
Washington relation 165479 2023-11-17 939 830 31 293 [4] 144157340 (achavi, OSMLab) 67 [4] Add dam ID tags in Washington
Maine relation 63512 2023-11-18 778 590 34 349 [4] 144187895 (achavi, OSMLab) 135 [4] Add dam ID tags in Maine
Minnesota relation 165471 2023-11-18 269 1,150 39 18 [4] 144194103 (achavi, OSMLab) 100 [4] Add dam ID tags in Minnesota
Iowa relation 161650 2023-11-18 541 4,054 147 52 [4] 144195380 (achavi, OSMLab) 124 [4] Add dam ID tags in Iowa
Missouri relation 161638 2023-11-20 3,810 5,400 84 2,730 [4] 144257370 (achavi, OSMLab) 550 [4] Add dam ID tags in Missouri
Wisconsin relation 165466 2023-11-21 1,346 1,004 65 674 [5] 144309294 (achavi, OSMLab) 166 [5] Add dam ID tags in Wisconsin
Illinois relation 122586 2023-11-22 1,394 1,639 51 718 [5] 144341053 (achavi, OSMLab) 179 [5] Add dam ID tags in Illinois
Maryland relation 162112 2023-11-22 403 422 22 88 [5] 144349535 (achavi, OSMLab) 80 [5] Add dam ID tags in Maryland
Louisiana relation 224922 2023-11-23 795 678 19 183 [5] 144379604 (achavi, OSMLab) 87 [5] Add dam ID tags in Louisiana
Mississippi relation 161943 2023-11-26 2,834 6,096 247 1,775 [5] 144481133 (achavi, OSMLab) 415 [5] Add dam ID tags in Mississippi
New Hampshire relation 67213 2023-11-26 745 665 45 302 [5] 144489749 (achavi, OSMLab) 165 [5] Add dam ID tags in New Hampshire
Vermont relation 60759 2023-11-27 385 371 24 207 [5] 144522069 (achavi, OSMLab) 48 [5] Add dam ID tags in Vermont
Massachusetts relation 61315 2023-11-27 1,536 1,328 49 646 [5] 144529995 (achavi, OSMLab) 283 [5] Add dam ID tags in Massachusetts
Nevada relation 165473 2023-11-28 504 509 8 109 [5] 144560137 (achavi, OSMLab) 60 [5] Add dam ID tags in Nevada
New York relation 61320 2023-11-28 1,477 1,920 28 236 [6] 144571246 (achavi, OSMLab) 567 [6] Add dam ID tags in New York
Pennsylvania relation 162109 2023-11-29 1,997 1,494 70 632 [6] 144605938 (achavi, OSMLab) 283 [6] Add dam ID tags in Pennsylvania
Virginia relation 224042 2023-11-30 1,880 2,717 89 944 [6] 144646342 (achavi, OSMLab) 281 [6] Add dam ID tags in Virginia
North Carolina relation 224045 2023-12-02 3,215 3,496 83 858 [6] 144695471 (achavi, OSMLab) 708 [6] Add dam ID tags in North Carolina
South Carolina relation 224040 2023-12-03 1,573 2,430 56 709 [6] 144735257 (achavi, OSMLab) 403 [6] Add dam ID tags in South Carolina
Oregon relation 165476 2023-12-04 1,097 889 23 338 [6] 144766677 (achavi, OSMLab) 178 [6] Add dam ID tags in Oregon
Idaho relation 162116 2023-12-04 744 410 20 207 [6] 144773461 (achavi, OSMLab) 75 [6] Add dam ID tags in Idaho
Utah relation 161993 2023-12-06 1,123 852 54 195 [7] 144836651 (achavi, OSMLab) 93 [7] Add dam ID tags in Utah
Colorado relation 161961 2023-12-09 5,324 1,985 126 1,069 [7] 144946025 (achavi, OSMLab) 232 [7] Add dam ID tags in Colorado
Nebraska relation 161648 2023-12-10 2,505 2,940 75 1,125 [7] 144972341 (achavi, OSMLab) 405 [7] Add dam ID tags in Nebraska
South Dakota relation 161652 2023-12-10 2,090 2,572 113 1,359 [7] 144983835 (achavi, OSMLab) 233 [7] Add dam ID tags in South Dakota
North Dakota relation 161653 2023-12-13 1,179 950 41 226 [7] 145081172 (achavi, OSMLab) 102 [7] Add dam ID tags in North Dakota
Wyoming relation 161991 2023-12-14 2,019 1,519 81 675 [7] 145132774 (achavi, OSMLab) 117 [7] Add dam ID tags in Wyoming
Montana relation 162115 2023-12-17 4,121 3,007 136 2,460 [8] 145231013 (achavi, OSMLab) 258 [8] Add dam ID tags in Montana

API

The NID can be queried through its API, with documentation at: https://nid.sec.usace.army.mil/api/developer/static/index.html

Some examples (using Guam because there's only one dam):

You can also query by coordinates, the radius parameter is in miles: https://nid.sec.usace.army.mil/api/query?nr={lon},{lat},{radius}

Dam type IDs:

1 Arch
2 Multi-Arch
3 Stone
4 Roller-Compacted Concrete
5 Rockfill
6 Buttress
7 Masonry
8 Earth
9 Gravity
10 Timber Crib
11 Concrete
12 Other

Viewing as a JOSM layer

Here you can download the complete National Inventory of Dams as a either a *.gpkg or *.csv file. Currently the GeoPackage file is about 76 MB while the csv is about 64 MB. Before opening in JOSM, the csv file will need its first line removed since the actual header is on line 2. And its columns need rearranged so latitude and longitude are first or else the OpenData plugin will have trouble opening it.

Once opened in JOSM as its own layer the data can be formatted using MapCSS. If using the GeoPackage file (no modification necessary), or if using the csv with the header replaced with the below text, then the following MapCSS will display each dam as a large orange dot with other useful information off to the side:

CSV header:

latitude,longitude,name,otherNames,formerNames,nidId,otherStructureId,federalId,ownerNames,ownerTypes,primaryOwnerType,numberofAssociatedStructures,isAssociatedStructure,designerNames,nonFederalDamonFederalProperty,primaryPurpose,purposes,sourceAgency,stateorFederalAgencyId,state,county,city,distancetoNearestCity,riverName,congressionalDistrict,sectionTownshipOrRangeLocation,stateRegulatedDam,federallyRegulatedDam,stateJurisdictionalDam,stateRegulatoryAgency,statePermittingAuthority,stateInspectionAuthority,stateEnforcementAuthority,federalAgencyOwners,federalAgencyInvolvementFunding,federalAgencyInvolvementDesign,federalAgencyInvolvementConstruction,federalAgencyInvolvementRegulatory,federalAgencyInvolvementInspection,federalAgencyInvolvementOperation,federalAgencyInvolvementOther,builtUndertheAuthorityoftheSecretaryofAgriculture,nRCSWatershedDamAuthorization,primaryDamType,damTypeIds,coreTypes,foundation,damHeight,hydraulicHeight,structuralHeight,nidHeight,nidHeightCategory,damLength,volume,yearCompleted,yearCompletedCategory,yearsModified,nidStorage,maxStorage,normalStorage,surfaceArea,drainageArea,maxDischarge,spillwayType,spillwayWidth,numberofLocks,lengthofLocks,lengthofSecondaryLock,lockWidth,secondaryLockWidth,outletGateType,dataLastUpdated,lastInspectionDate,inspectionFrequency,hazardPotentialClassification,conditionAssessment,conditionAssessmentDate,eAPPrepared,eAPLastRevisionDate,websiteURL,operationalStatus,operationalStatusDate,americanIndianAlaskaNativeNativeHawaiian

MapCSS:

node|z7-[federalId]
{
	symbol-stroke-color: #00ffff;  
	symbol-fill-color: orange;
	symbol-shape: circle;
}
node|z7-[damTypeIds~=Earth]
{
	symbol-stroke-color: brown;  
}
node|z7-9[federalId]
{
	symbol-size:10;
}
node|z10[federalId]
{
	symbol-size:25;
	text: eval(tag("federalId"));
	font-size: 14;
}
node|z11-12[federalId]
{
	symbol-size:25;
	text-halo-color: black;
	text-halo-radius: 1;
	text: eval(concat(tag("federalId"), " ", tag("name")));
	font-size: 14;
}
node|z13-[federalId]
{
	symbol-size:30;
	symbol-stroke-width: 3;
	text-halo-color: black;
	text-halo-radius: 2;
	text: eval(concat(tag("federalId"), " ", tag("name")));
	font-size: 14;
}
node|z15-[federalId]::layer_1
{
	text: eval(concat(tag("damLength")," feet"));
	font-size: 12;
	text-color: #555555;
	font-weight: bold;
	text-halo-color: white;
	text-halo-radius: 2;
	text-offset-x: 16;                                    
	text-offset-y: 17; 
}
node|z15-[federalId]::layer_2
{
	text: eval(concat(tag("damTypeIds")," - ",tag("riverName")));
	font-size: 12;
	text-color: #555555;
	font-weight: bold;
	text-halo-color: white;
	text-halo-radius: 2;
	text-offset-x: 16;                                    
	text-offset-y: 6; 
}
node|z15-[federalId]::layer_3
{
	text: eval(concat(tag("county"), ", ", tag("state")));
	font-size: 12;
	text-color: #555555;
	font-weight: bold;
	text-halo-color: white;
	text-halo-radius: 2;
	text-offset-x: 16;                                    
	text-offset-y: -26; 
}

The result:

Orange dots representing two dams in Nebraska

State notes

The states of the United States have their own agencies responsible for regulating dams. They provide that data to the U.S. Army Corp of Engineers for the National Inventory of Dams, but not all dams make the cut. Getting the data for all of the other dams that have been recorded can be useful when identifying dams in OpenStreetMap. For this project, this data is being used to help avoid conflating OSM dams with dams in the NID incorrectly. In the future, this information could be useful when looking at GNIS-imported dam nodes that still haven't been turned into ways, to confirm their coordinates from GNIS are correct and that they still exist. The below information is recorded in the hope that it is of use to anyone else.

When querying ArcGIS APIs and outputting to json, it will include exceededTransferLimit: true if your query returned more than 1000 records. In which case you can use the URL parameter resultOffset=1000 to skip the first 1000 when querying it again, and so on. It may be necessary to sort the results with orderByFields=OBJECTID when doing this. Also resultRecordCount can be used to limit the number of results.

In the National Inventory of Dams they store state dam IDs in the field "stateFedId". This can be used to correlate the state data to the NID.

Some states simply use NID formatted identifiers (KY00000) for all of their dams.

Alabama

Alabama's dam safety program was established in 2023.

In some cases the NID's coordinates match those from GNIS, which may or may not have been very precise. In some instances the dams in OSM look good and the coordinates in the NID appear off. In these cases, the dam length measurements from the NID can help identify the correct nearby body of water with one flat side of the same length. Or, when multiple NID dams are at the same coordinates (which they've fixed already in other states) dam length can be used to figure out which goes to which nearby body of water if their sizes are different enough.

For the dams in Alabama now tagged with NID numbers that based on satellite still appear to be misplaced, checking if their coordinates in the NID are updated in the future would be a good idea.

Alaska

If the Alaska Department of Natural Resources provides their dam inventory anywhere, it wasn't readily findable.

Arizona

If the Arizona Department of Water Resources provides their dam inventory anywhere, it wasn't readily findable.

Arkansas

NID formatted IDs are in the field "arnum". Then latitude and longitude are "latdd" and "longdd". When querying, the limit is 500 items at a time, so the resultOffset parameter is needed.

California

Under Publications on the below website, there are pdfs containing lists of the same dams available from the GIS api. Either way, they contain fields for State_ID and National_ID, Longitude and Latitude. Also either way, they contain almost exactly what is in the NID. Interestingly, many of the dams in OSM in California that were imported from GNIS contain the state's dam ID in their names. This information from the field "stateFedId" from the NID was helpful in matching, and was added to the conflated data in the "former_name" column since most NID dams didn't have anything there.

Colorado

The Colorado Division of Water Resources split their dams into two categories: jurisdictional and non-jurisdictional. For each group, they provide their dam inventory in multiple formats. All four of the API endpoints below work. Whether using the data.colorado.gov one or the dwr.state.co.us option the same information for the same number of dams is returned, the only difference is format and field names. Either way, the state's dam ID, latitude, and longitude are present. The data.colorado.gov endpoints do not force dam names to be in all caps.

The field nidId is only present for 'jurisdictional' dams and when prefixed with "CO" forms a valid NID ID. Some of the NID dams come from the 'non-jurisdictional' set however. The NID's field stateFedID or just name and coordinates can be used to match them up.

Connecticut

DAM_NO is used as the ID. It corresponds to stateFedId for some but not all of what is in the NID from Connecticut. Fields LATITUDE and LONGITUDE contain coordinates.

Delaware

Delaware doesn't seem to have any information outside of the dams in the NID. From their website: “The NID lists 83 regulated and unregulated dams in Delaware.” And: “Since 2008 however, further, more in-depth review of each dam has reduced the number of regulated dams to the current 45.”

Florida

Florida's data closely matches almost exactly what is in the NID. IDs are in the fields NID_ID and FEDERAL_ID. LATITUDE and LONGITUDE are included in the regular json.

Georgia

Georgia offers their dam inventory as a file download currently dated November 2019. Some lines appear duplicated due to multiple owners of the same dam.

Hawaii

Hawaii's dam information almost exactly matches exactly what is in the NID. Fields stateid and nidid contain ID. Fields latitude and longitude are part of the regular json output.

Idaho

StateID and NIDID contain IDs. Coordinates require outputting to GeoJson.

Illinois

If the Illinois Department of Natural Resources provides their dam inventory anywhere, it wasn't readily findable.

Indiana

The main ID is in the field state_id, but then the NID ID is in the field national_id whether the dam is in the NID or not. Latitude and longitude not in any of the fields, so it's necessary to query this one as f=geojson and returnGeometry=true. The geometries are all points.

Iowa

Iowa offers a download of their dam inventory as *.shp and *.dbf files. These contain all of the relevant information including coordinates.

Kansas

Kansas has publicly available GIS data on reservoirs and on what areas would flood if a particular dam was breached but no obvious listing of all the dams they've inventoried.

Something to note is Kansas has over 6,000 dams in the NID and 3,700 of those only have a name in the "otherNames" field. The main "name" field is blank. Then another 460 don't have a name in either field. The completely unnamed dams do visibly exist on satellite at their coordinates though.

Kentucky

The main ID is in the field SUBJECT_ITEM_DESIGNATION. When combined with "KY" it forms an NID ID. As the states get to pick how to number their dams in the NID, Kentucky assigns valid "KY#####" numbers to all of their dams, even if they're not actually included in the NID. Latitude and longitude are in the fields Y_COORD_VALUE and X_COORD_VALUE.

Louisiana

If the Louisiana Department of Transportation and Development provides their dam inventory anywhere, it wasn't readily findable.

Maine

Maine's dam inventory is great. If layer 1 is queried as geojson each dam is represented as a point. If layer 3 is queried then each dam is represented as a polygon. Relevant fields in layer 1 include ID which is the NID formatted identifier (whether the dam is in the NID or not), and MSV_ID seems to be the main state identifier.

Maryland

Fields State_ID and National_ID contain identifiers and Latitude and Longitude have coordinates.

Massachusetts

The data from Massachusetts is good, but it's only available as a shapefile download or an online geoserver map.

Michigan

Michigan has dam ID numbers in the field Dam_ID and then federal IDs in NIDID. Dam_ID is just the number taken out of the NID ID. Latitude and longitude have their own fields of the same names.

Minnesota

GeoJson is necessary for coordinates. The field nid_id has IDs for all dams, in the NID or not.

Mississippi

The field STATEID contains NID formatted IDs (MS12345). LatDD and LongDD have coordinates. This data contains almost 7,000 dams.

Mississippi dams in the old GNIS data versus the current NID have an interesting phenomenon where GNIS will have multiple dams with the same name (example, there are five different instances of "Farm Land Company Lake Dam"). However they aren't duplicates, the NID will have given them distinct names, adding "Number 2", etc. Then, the coordinates from GNIS will have been accurate but not precise - they'll all be offset from their bodies of water in one direction or another by up to several hundred meters. In these cases it was mostly straightforward to figure out which dam went where when looking at them visually. Hopefully most of the occurrences of this are now fixed.

Missouri

Layer 0 is regulated dams (about 700 of them), layer 1 is non-regulated (about 4,800 dams). Fields LATITUDE and LONGITUDE have coordinates, ID_NO has the NID-compatible identifier. Many dams have additional descriptions included in their names in parenthesis (dry, not built, too small, breached, ...).

Montana

This information comes from Montana Fish, Wildlife & Parks which published it in 2019. Unfortunately it seems mostly the same as what GNIS had. Coordinates are in the fields LAT and LONG_.

Nebraska

Field NIDID contains the NID ID. Latitude and Longitude are part of the regular json. Use the url parameter resultOffset to get up to 2000 records at a time.

About 270 of Nebraska's dams in the NID have the number part of their NID ID tacked onto their name for some reason, most likely to cause dams to have unique names. This was stripped out for data conflation purposes as it couldn't possibly match otherwise.

Nevada

Fields NATID and STATEID have identifiers. LATITUDE and LONGITUDE have coordinates.

New Hampshire

State ID is in the filed DAM. NID IDs are in the field NATDAMID but only some of the time. LATITUDE and LONGITUDE contain coordinates. The field STATUS seems to indicate which dams no longer exist with the values "REMOVED" or "RUINS".

New Jersey

If the New Jersey Department of Environmental Protection provides their dam inventory anywhere, it wasn't readily findable.

New Mexico

Closest thing to a state dam inventory is at the url below. It contains 105 dams described as "major". 83 match what is in the NID, leaving 22 extra dams.

New York

The New York Department of Environmental Conservation provides their dam inventory as either a KMZ file or through an ArcGIS service. Both have roughly the same number of dams and both look to have been last updated in the past year. The KMZ (zipped KML) file contains more fields however, including FEDERAL_ID. If using the service, requesting GeoJson is necessary to get coordinates. The maximum number of results at a time is 2000.

North Carolina

The North Carolina dam inventory can be downloaded as an Excel spreadsheet, a KML file, or a zipped shapefile. Last updated May 2023, which is really good.

North Dakota

The dam inventory from the North Dakota Department of Water Resources can be downloaded as a shapefile from their map page. Dams is under "Water Resources". They also have a search page but no api.

Ohio

The main identifier for Ohio is called FILENO. Most though not all of the NID dams are in classes 1 thorugh 3. Latitude and longitude are in the fields LAT_CALC and LONG_CALC.

Oklahoma

Oklahoma uses the field nidid for the ID every dam. No fields for latitude and longitude, so f=geojson and returnGeometry=true are needed. Interesting are the dams with a "gis_type" of "OWRB - Drained". So, according to the Oklahoma Water Resources Board, who provides all of this information, these dams may be gone.

Oregon

The Oregon Water Resources Department provides a user interface for searching their dam inventory. Searching without providing any parameters simply returns all of their data as an HTML table. The first column is an NID-formatted string (OR00000) whether the dam is in the NID or not.

Pennsylvania

From the Pennsylvania Department of Environmental Protection: “For security reasons, information regarding Dams, Explosive Storage Locations, Public Water Supplies, and certain Water Pollution Control, Water Resource, and Radiation Facilities are not displayed on eMapPA.”

Many dams in Pennsylvania include their state ID number as part of their name, e.g. "Core Creek (Pa-620)", or even as their entire name: "Pa-470 Dam". This occurs in a few dozen instances in both OpenStreetMap and in the National Inventory of Dams for dams in Pennsylvania, but not necessarily for the same ones at the same time. So, for this project both the name before the ID number, and the ID number itself were used to find matches.

Rhode Island

GeoJson/returnGeometry is necessary to get coordinates. It might be possible to relate STATE_ID in the Rhode Island data to stateFedId in the NID but correlating dams between the two of them by coordinates and name also works.

South Dakota

The South Dakota Department of Agriculture & Natural Resources doesn't seem to publish a dam inventory. They have a Dry Draw Location Notice Search that displays owners and coordinates for certain dams but nothing like a name or ID number for them.

South Carolina

The fields Site_name_alt and SITE_NUMBER appear to be the state ID to compare to the NID's stateFedId field. Latitude and Longitude are fields in the plain json.

Many of the dams in OSM in South Carolina that were imported from GNIS contain the state's dam ID in their names. This is the same as in California. This information from the field "stateFedId" from the NID was helpful in matching, and was added to the conflated data in the "former_name" column just as a place to stick it for reference.

A note that states are alowed to use letters in their NID ids and South Carolina actually does it with 52 dams having ids beginning "SCD" followed by four numerical digits.

Tennessee

Tennessee's data includes an ID field, but the stateFedId in the NID is blank for everything from the state so correlating which dams from this source are already in the NID is tricky. Coordinates are in the fields LAT_DD and LONG_DD.

Texas

If the Texas Comission on Environmental Quality provides their dam inventory anywhere, it wasn't readily findable. There are some pdfs and spreadsheets listing a few dams at a time, but that's it.

Utah

DamNum is both the state and federal ID. Output to GeoJson for coordinates. Page size is 2000 when using resultOffset to get the next batch of results.

Comparing the dams that are common to both the NID and the inventory from the Utah Division of Water Resources, most of them have different coordinates. The coordinates for about 750 of the 830 dams that are in both sources are between 200 and 215 meters apart - for the same dam in the NID versus the Utah inventory. This is odd since it affects so many dams by almost the same distance. In both sources, the latitude and longitude go out to 8+ decimal places so it isn't a rounding or truncating issue. In most, but absolutely not all, cases the Utah inventory appears more correct. 200 meters can make the difference from being on the water's edge to the middle of a forest, highway, or housing development. A couple of dozen OSM dams were matched to the NID manually to work around this issue.

Since the dam info from the Utah Division of Water Resources feeds into the NID, hopefully this will be sorted out in the future.

Vermont

IDs are in the fields StateID and NationalID, coordinates in LatNAD83 and LongNAD83. Field DamStatus also exists, values include "Drained", "Not in Use", and "Removed" which may be of interest in the future for GNIS-imported nodes still out there.

Virginia

Fields latitude and longitude contain coordinates. The field IdNumber is the state ID and also an NID formatted identifier if "VA" is added to the beginning of it. Note: Virginia in the NID uses 6-digit identifiers (VA123456) instead of every other state's 5-digits.

The ArcGIS service will return up to 2000 records at a time.

Washington

Access to Washington's dam inventory can be requested or it can be immediately downloaded as a pdf. The information in the pdf looks complete, it includes about 1200 dams compared to the NID's 800 for the state.

West Virginia

All four of these return different but overlapping lists of dams. IDs and latitude and longitude are all over the place. The one consistent thing is that the state ID is always a five digit number, equal to the NID ID without the "WV".

Wisconsin

DAM_KEY_SEQ_NO is the main state ID. The field NID is populated when applicable. Fields INTERSECT_LATITUDE and INTERSECT_LONGITUDE contain coordinates. When querying, it returns 2000 results at a time. &resultOffset=2000 can be added to get the second page, etc.

The field PHYSICAL_STATUS seems to indicate whether a dam exists or not, which could be useful in the future when trying to further corral GNIS-imported dam nodes.

A large number of Wisconsin dams existing in OpenStreetMap have a string of letters and numbers included in their name tag (ex: "Twin Parks 6 2WP1780 Dam"). This value ("2WP1780") is an "Authorization Approval Description", stored in the field AUTHORIZATION in the data from the Wisconsin DNR. Unlike California, where many dams have the state's dam ID included in the name, this isn't a unique identifier.

For conflating the OSM dams to the NID's data, which does not include this serial number in the name or any other field, it was simplest to just strip it out of the OSM dam's name when making comparisons. This was done with the following regular expression patterns, in the order listed, which covered most but not all cases and allowed about 400 more dams to become exact name matches. The rest, when still physically close to an NID dam, became MapRoulette tasks as normal.

\b2[ -]?WP ?[0-9-]+a?\b
\b3[ -]?WR ?[0-9-]+a?\b
\bWP ?[0-9\.-]+a?\b
\b[CGDEH][ -]?[0-9\.-]+a?\b
\b[A-Z]?[0-9]+[A-Z]+[0-9]+a?\b

If anyone in the future wanted to actually remove these values from the name tags of the dams in OSM, if including them in the name was something only GNIS did, doing so would be possible by using data from the NID or the Wisconsin Department of Natural Resources. But that is outside the scope of this current project.

Wyoming

If the Wyoming State Engineer's Office provides their dam inventory anywhere, it wasn't readily findable.