About this Dataset

Allegheny County Beltway System Street Centerlines

Authoritative dataset of the beltway system in Allegheny County. The system was developed to help motorists navigate through Allegheny County on low-traffic roads. The belts are arranged in concentric circles and color-coded red, orange, yellow, green, blue, and purple.

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: Transportation

Organization: Allegheny County

Department: Geographic Information Systems Group; Department of Administrative Services

Temporal Coverage: 2015

**Data Notes: **

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

Development Notes: none

Other: none****

Related Document(s): Data Dictionary (https://docs.google.com/spreadsheets/d/1WNzi_JLaIL1eR5RWw0FlSAwqIrdExs9Vy2Iui_NE9Go/edit?usp=sharing)

Frequency - Data Change: Not updated (historical only)

Frequency - Publishing: Not updated (historical only)

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:13.360820
Tags: _etl, planning, roads, street-centerlines, streets, transportation

Tables

Table 1

@usgov.allegheny_county_city_of_pitts_allegheny_county_beltwa_884fbc3d.table_1

132.93 KB
2930 rows
37 columns


CREATE TABLE table_1 (
  "n__id" BIGINT,
  "fid" BIGINT,
  "prefix" VARCHAR,
  "name" VARCHAR,
  "type" VARCHAR,
  "suffix" VARCHAR,
  "street_name" VARCHAR,
  "alternate_n" VARCHAR,
  "lleft" BIGINT,
  "hleft" BIGINT,
  "lrgt" BIGINT,
  "hrgt" BIGINT,
  "fromstreet" VARCHAR,
  "tostreet" VARCHAR,
  "zipl" VARCHAR,
  "zipr" VARCHAR,
  "mcdl" VARCHAR,
  "mcdr" VARCHAR,
  "owner" VARCHAR,
  "beltway" VARCHAR,
  "major_rd" VARCHAR,
  "no_lanes" BIGINT,
  "cfcc" VARCHAR,
  "gdtlink" VARCHAR,
  "oneway" VARCHAR,
  "unique_id" BIGINT,
  "route_no" VARCHAR,
  "systemid" BIGINT,
  "userid" BIGINT,
  "featurecod" BIGINT,
  "update_year" BIGINT,
  "modified_by" VARCHAR,
  "modified_on" VARCHAR,
  "created_by" VARCHAR,
  "created_on" VARCHAR,
  "shape_leng" DOUBLE,
  "shape_length" VARCHAR
);