California Electric Transmission Lines by US Government | Environmental and Climate Sciences

About this Dataset

California Electric Transmission Lines

The California Energy Commission (CEC) Electric Transmission Line geospatial data layer has been created to illustrate electric transmission in California. When used in association with the other energy related geospatial data layers, viewers can analyze the geographic relationships with the electric transmission across the state. The transmission line data is used to:

1. Support the CEC Transmission Planning;

2. Support the CEC electric system analysis in California;

3. Enhance electric transmission communication among California electric stakeholders ;

4. Support CEC's illustrations of electric infrastructure

Data Dictionary:

Object ID: a unique, not null integer field used to uniquely identify rows in tables in a geodatabase.
Name: abbreviated transmission line owner and transmission line capacity in kilovolts (kV).
kV: transmission line capacity in kilovolts (kV), data structure is a text string.
kV (Sort): transmission line capacity in kilovolts (kV), data structure is a numeric double.
Owner: abbreviated transmission line owner name.
Status - last reported operational, proposed, closed, or unknown status of the transmission line.
Circuit - notes if the transmission line segment is a Single, double, or triple circuit. Null values are unknown.
Type - OH is overhead transmission lines, UG is underground, UW is underwater, null values are unknown.
Legend - a summarized categories of transmission line owner and transmission capacity value in kilowatts (kV) for map legend purposes.
Length (Mile) - the length of the transmission line segment in miles.
Length (Feet) - the length of the transmission line segment in feet.
TLine Name - the name of the transmission line segment reported to the California Energy Commission
Source - the data source used by California Energy Commission.
Comments
Creator
Creator Date
Last Editor
Last Editor Date
GlobalID
Shape__Length
Shape
Organization: State of California
Last updated: 2024-03-30T03:38:34.866051
Tags: california-energy-commission, california-natural-resources-agency, caopendata, electric, transmission-line

Tables

Table 1

@usgov.ca_gov_california_electric_transmission_lines_770f8.table_1

471.35 KB
6839 rows
20 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "name" VARCHAR,
  "kv" VARCHAR,
  "kv_sort" DOUBLE,
  "owner" VARCHAR,
  "status" VARCHAR,
  "circuit" VARCHAR,
  "type" VARCHAR,
  "legend" VARCHAR,
  "length_mile" DOUBLE,
  "length_feet" DOUBLE,
  "tline_name" VARCHAR,
  "source" VARCHAR,
  "comments" VARCHAR,
  "creator" VARCHAR,
  "creator_date" VARCHAR,
  "last_editor" VARCHAR,
  "last_editor_date" VARCHAR,
  "globalid" VARCHAR,
  "shape_length" DOUBLE
);