About this Dataset

City Council Districts

This dataset contains two versions of the map of Pittsburgh City Council Districts, the current one (dating from 2022) and an earlier one (dating from 2012), each in multiple formats.

For older city council district maps going back to 2022, see
https://data.wprdc.org/dataset/pittsburgh-city-council-district-map
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-03-14T22:58:02.338147
Tags: _etl, city-council-districts, civic-vitality-and-governance, geography, pittsburgh

Tables

Table 1

@usgov.allegheny_county_city_of_pitts_city_council_districts_2012.table_1

7.1 kB
9 rows
8 columns

CREATE TABLE table_1 (
  "n__id" BIGINT  -- Id,
  "objectid_1" BIGINT,
  "objectid" BIGINT,
  "dist_id" BIGINT,
  "dist_name" VARCHAR,
  "global_id" VARCHAR,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE
);

Table 2

@usgov.allegheny_county_city_of_pitts_city_council_districts_2012.table_2

8.97 kB
9 rows
11 columns

CREATE TABLE table_2 (
  "n__id" BIGINT  -- Id,
  "fid" BIGINT,
  "council" BIGINT,
  "transparency" BIGINT,
  "created_user" VARCHAR,
  "created_date" TIMESTAMP,
  "last_edited_user" VARCHAR,
  "last_edited_date" TIMESTAMP,
  "council_district" BIGINT,
  "shape_length" DOUBLE,
  "shape_area" DOUBLE
);