Free full dataset
USACE Waterway Lock Inventory — Free
The complete 234-row physical lock inventory is available free on Hugging Face.
Records: 234 lock records; 56 fields
Coverage: 26 states and 60 waterways; age reference year 2024
Format: Complete public CSV; all 234 rows and 56 fields
Package uploaded: 2026-03-31
Listing reviewed: 2026-09-18
The upload and review dates do not extend the source coverage. This is a dated snapshot; future updates are not included.
The public file contains the entire inventory. No paid purchase is required.
Get all 234 rows freeNew annual update subscriptions are unavailable. Existing customers can use their purchase download links or contact support.
Known limitations
- This is a physical inventory, not traffic, throughput, delay or performance history.
- age_years was calculated relative to 2024; it is not a current age field.
- The public CSV already includes every row and all 56 fields. No paid dataset purchase is needed.
Files in the existing snapshot
Row counts are per table and should not be added as independent events. Expand a file to see its delivered Parquet field names and types.
usace_waterway_locks.parquet — 234 rows · 56 fields
| Field | Type |
|---|---|
| objectid | int64 |
| lock_id | int64 |
| ndc_code | string |
| region_code | string |
| river_code | string |
| lock_code | string |
| chamber_code | string |
| num_chambers | int64 |
| has_lpms_data | bool |
| nav_structure_name | string |
| chamber_name | string |
| chb1 | string |
| structure_type | string |
| lock_name | string |
| status_code | string |
| waterway | string |
| river_mile | double |
| bank_side | string |
| lift_ft | int64 |
| chamber_length_ft | int64 |
| chamber_usable_length_ft | int64 |
| chamber_width_ft | int64 |
| chamber_usable_width_ft | int64 |
| upper_approach_depth_ft | int64 |
| lower_approach_depth_ft | int64 |
| upper_miter_sill_depth_ft | int64 |
| lower_miter_sill_depth_ft | int64 |
| year_opened | int64 |
| gate_type | string |
| gate | string |
| channel_length_miles | int64 |
| channel_depth_upper_ft | int64 |
| channel_depth_lower_ft | int64 |
| channel_width_upper_ft | int64 |
| channel_width_lower_ft | int64 |
| waterway_project | string |
| has_mooring | bool |
| multi_structure | string |
| division | string |
| district | string |
| state | string |
| maint1 | string |
| oper1 | string |
| owner1 | string |
| town | string |
| county | string |
| mooring_r | string |
| se_anno_cad_data | string |
| longitude | double |
| latitude | double |
| status | string |
| region | string |
| gate_type_label | string |
| chamber_volume_index | int64 |
| capacity_tier | string |
| age_years | int64 |
Inspect the public CSV
import pandas as pd
df = pd.read_csv(
"https://huggingface.co/datasets/claritystorm/usace-waterway-lock-performance/resolve/main/sample_1000.csv"
)
print(df.shape)
print(df.columns.tolist())
print(df.head())This CSV contains the full inventory. License details are on the Hugging Face card.
Source: government source portal · Dataset changelog