About this Dataset

I17 California Jurisdictional Dams

This dataset is a feature class identifying all dams currently under the jurisdiction of the Division of Safety of Dams (DSOD). The dataset is extracted from DSOD internal records and contains basic information about the dam including the type of construction, basic dimensions such as height, length, and maximum storage capacity; abbreviated owner information to identify the entity legally responsible for the dam; an assessment of the downstream hazard associated with the dam; an assessment of the current condition of the dam; and indication as to whether the dam is operating at a restricted storage level. Several dams span rivers that define county boundaries, so DSOD references the right abutment of the dam to identify the location of the structure and to associate it with a singular administrative subdivision of California. Data version published in April 2024 is an update to the data published in January 2024.
Organization: State of California
Last updated: 2025-07-23T20:28:43.876286
Tags: 20180117, california, california-department-of-water-resources, critical-infrastructure, dams, division-of-safety-of-dams, dwr, dwr-gis-atlas, hydrographic, infrastructure, jurisdictional, jurisdictional-dams, structure, water-management

Tables

Table 1

@usgov.ca_gov_i17_california_jurisdictional_dams_77b1f.table_1

129.37 kB
1,230 rows
26 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "internal_id" BIGINT,
  "state_id" VARCHAR,
  "dam_name" VARCHAR,
  "national_id" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "county" VARCHAR,
  "owner_name" VARCHAR,
  "owner_type" VARCHAR,
  "dam_type" VARCHAR,
  "year_built" DOUBLE,
  "dam_height_feet" DOUBLE,
  "dam_length_feet" DOUBLE,
  "capacity_acre_feet" DOUBLE,
  "jurisdictional_status" VARCHAR,
  "downstream_hazard" VARCHAR,
  "condition_assessment" VARCHAR,
  "restricted" VARCHAR,
  "date_data_applies" TIMESTAMP,
  "data_source" VARCHAR,
  "record_last_edited" TIMESTAMP,
  "record_last_edited_by" VARCHAR,
  "comment" VARCHAR
);