About this Dataset

Allegheny County Dam Locations

This dataset shows the point locations of dams in Allegheny County.

If viewing this description on the Western Pennsylvania Regional Data Center’s open data portal (http://www.wprdc.org), this dataset is harvested on a weekly basis from Allegheny County’s GIS data portal (http://openac.alcogis.opendata.arcgis.com/). The full metadata record for this dataset can also be found on Allegheny County’s GIS portal. You can access the metadata record and other resources on the GIS portal by clicking on the “Explore” button (and choosing the “Go to resource” option) to the right of the “ArcGIS Open Dataset” text below.

Category: Energy

Organization: Allegheny County

Department: Geographic Information Systems Group; Department of Administrative Services

Temporal Coverage: 2003

**Data Notes: **

Coordinate System: Pennsylvania State Plane South Zone 3702; U.S. Survey Foot

Development Notes: none

Other: none****

Related Document(s): Data Dictionary (none)

Frequency - Data Change: As needed

Frequency - Publishing: As needed

Data Steward Name: Eli Thomas

Data Steward Email: gishelp@alleghenycounty.us
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:02:31.198276
Tags: _etl, energy, environment, water

Tables

Table 1

@usgov.allegheny_county_city_of_pitts_allegheny_county_dam_locations.table_1

23.89 kB
46 rows
26 columns

CREATE TABLE table_1 (
  "n__id" BIGINT  -- Id,
  "x" DOUBLE,
  "y" DOUBLE,
  "fid" BIGINT,
  "perimeter" BIGINT,
  "dams_id" BIGINT,
  "dam_no" VARCHAR,
  "dam_name" VARCHAR,
  "stream" VARCHAR,
  "permittee" VARCHAR,
  "zone" BIGINT,
  "northing" BIGINT,
  "easting" BIGINT,
  "north" DOUBLE,
  "east" DOUBLE,
  "quad_name" VARCHAR,
  "type" VARCHAR,
  "purpose" VARCHAR,
  "dam_height" DOUBLE,
  "crest" BIGINT,
  "class" VARCHAR,
  "drain_area" DOUBLE,
  "storage_no" DOUBLE,
  "storage_to" DOUBLE,
  "surface_no" DOUBLE,
  "surface_to" DOUBLE
);