Name: Electric System Equipment
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Electric System Equipment

Browse the number of substations, miles of transmission lines, and more by year.
Organization: City of Austin
Last updated: 2020-11-12T13:24:56.261116
Tags: distributions, electric-system, equipment, man-holes, poles, service-boxes, transmission-lines

Tables

Table 1

@usgov.city_of_austin_electric_system_equipment.table_1

14.16 kB
17 rows
16 columns

CREATE TABLE table_1 (
  "fiscal_year" BIGINT,
  "overhead_primary_miles" BIGINT  -- Overhead Primary (miles),
  "overhead_secondary_miles" BIGINT  -- Overhead Secondary (miles),
  "underground_primary_miles" BIGINT  -- Underground Primary (miles),
  "underground_secondary_miles" BIGINT  -- Underground Secondary (miles),
  "poles" BIGINT,
  "overhead_transformers" BIGINT,
  "underground_transformers" BIGINT,
  "switch_gear" BIGINT,
  "risers" BIGINT,
  "man_holes" BIGINT,
  "pull_boxes" BIGINT,
  "service_boxes" BIGINT,
  "transmission_lines_miles" DOUBLE  -- Transmission Lines (miles),
  "distribution_substations" DOUBLE,
  "transmission_substations" DOUBLE
);