About this Dataset

Allegheny County Municipal Land Use Ordinances

Many municipalities have their own land use ordinances and establish standards and requirements for land use and development in that municipality. This dataset is reviewed and tracked by Allegheny County Economic Development. The data dictionary contains additional information that is helpful for navigation.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:08:21.071557
Tags: business-and-economy, local-government, municipalities

Tables

Allegheny County Municipal Land Use Ordinances

@usgov.allegheny_county_city_of_pitts_allegheny_county_munici_b1667b0c.allegheny_county_municipal_land_use_ordinances

60.94 kB
817 rows
28 columns

CREATE TABLE allegheny_county_municipal_land_use_ordinances (
  "new_identifier" BIGINT,
  "municipality" VARCHAR,
  "multi_municipal" VARCHAR,
  "muni2" VARCHAR,
  "muni3" VARCHAR,
  "muni4" VARCHAR,
  "cog" VARCHAR,
  "acedfile" VARCHAR,
  "n_1st_submittal_date" VARCHAR  -- 1st Submittal Date,
  "n_1st_review_date" VARCHAR  -- 1st Review Date,
  "n_2nd_submittal_date" VARCHAR  -- 2nd Submittal Date,
  "n_2nd_review_date" TIMESTAMP  -- 2nd Review Date,
  "n_3rd_submittal_date" TIMESTAMP  -- 3rd Submittal Date,
  "n_3rd_review_date" VARCHAR  -- 3rd Review Date,
  "applicationtype" VARCHAR,
  "new_or_substantial" VARCHAR,
  "amendment" VARCHAR,
  "keyword" VARCHAR,
  "rezoning_location" VARCHAR,
  "existing_zoning" VARCHAR,
  "proposed_zoning" VARCHAR,
  "acreage_for_rezoning" VARCHAR,
  "tax_parcel_id1" VARCHAR,
  "tax_parcel_id2" VARCHAR,
  "adopted" VARCHAR,
  "ordinance_or_resolution_no" VARCHAR,
  "date_enacted" VARCHAR,
  "date_received_by_aced" VARCHAR
);