About this Dataset

Pittsburgh Neighborhood Atlas, 1977

This compilation includes five historical datasets that are part of the University of Pittsburgh Library collection. The datasets were transcribed from The Pittsburgh Neighborhood Atlas, published in 1977. The atlas was prepared by the Pittsburgh Neighborhood Alliance. The information provides an insight into the neighborhoods conditions and the direction in which they were moving at the time of preparation. Much of the material describing neighborhood characteristics came from figures compiled for smaller areas: voting districts or census blocks.
The five datasets in this collection provide data about overall neighborhood satisfaction and satisfaction with public services, based on a city-wide citizen survey. Also included are statistics about public assistance, the crime rate and the changes in real estate and mortgage loans transactions.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:11:42.312156
Tags: 1977, archives, crime, demographics, historic-pittsburgh, mortgage-loans, neighborhood, pittsburgh, problems, public-assistance, real-estate, satisfaction

Tables

Neighborhood Problems, 1976

@usgov.allegheny_county_city_of_pitts_pittsburgh_neighborhood_758ce01b.neighborhood_problems_1976

34.23 kB
71 rows
31 columns

CREATE TABLE neighborhood_problems_1976 (
  "neighborhood" VARCHAR,
  "unsafe_streets_not_problem" BIGINT,
  "unsafe_streets_minor_moderate_problem" BIGINT,
  "unsafe_streets_very_serious_problem" BIGINT,
  "vandalism_not_problem" BIGINT,
  "vandalism_minor_moderate_problem" BIGINT,
  "vandalism_very_serious_problem" BIGINT,
  "rats_not_problem" BIGINT,
  "rats_minor_moderate_problem" BIGINT,
  "rats_very_serious_problem" BIGINT,
  "burglary_streets_not_problem" BIGINT,
  "burglary_minor_moderate_problem" BIGINT,
  "burglary_very_serious_problem" BIGINT,
  "poor_roads_not_problem" BIGINT,
  "poor_roads_minor_moderate_problem" BIGINT,
  "poor_roads_very_serious_problem" BIGINT,
  "trash_not_problem" BIGINT,
  "trash_minor_moderate_problem" BIGINT,
  "trash_very_serious_problem" BIGINT,
  "vacant_buildings_not_problem" BIGINT,
  "vacant_buildings_minor_moderate_problem" BIGINT,
  "vacant_buildings_very_serious_problem" BIGINT,
  "undesirable_peoplenot_problem" BIGINT,
  "undesirable_people_minor_moderate_problem" BIGINT,
  "undesirable_people_very_serious_problem" BIGINT,
  "stray_dogs_not_problem" BIGINT,
  "stray_dogs_minor_moderate_problem" BIGINT,
  "stray_dogs_very_serious_problem" BIGINT,
  "dog_litter_not_problem" BIGINT,
  "dog_litter_minor_moderate_problem" BIGINT,
  "dog_litter_very_serious_problem" BIGINT
);

Neighborhood Satisfaction, 1976

@usgov.allegheny_county_city_of_pitts_pittsburgh_neighborhood_758ce01b.neighborhood_satisfaction_1976

32.11 kB
71 rows
31 columns

CREATE TABLE neighborhood_satisfaction_1976 (
  "neighborhood" VARCHAR,
  "parks_satisfied" BIGINT,
  "parks_neither" BIGINT,
  "parks_dissatisfied" BIGINT,
  "schools_satisfied" BIGINT,
  "schools_neither" BIGINT,
  "schools_dissatisfied" BIGINT,
  "street_maintenance_satisfied" BIGINT,
  "street_maintenance_neither" BIGINT,
  "street_maintenance_dissatisfied" BIGINT,
  "alley_maintenance_satisfied" BIGINT,
  "alley_maintenance_neither" BIGINT,
  "alley_mainenance_dissatisfied" BIGINT,
  "garbage_collection_satisfied" BIGINT,
  "garbage_collection_neither" BIGINT,
  "garbage_collection_dissatisfied" BIGINT,
  "police_satisfied" BIGINT,
  "police_neither" BIGINT,
  "police_dissatisfied" BIGINT,
  "public_transportation_satisfied" BIGINT,
  "public_transportation_neither" BIGINT,
  "public_transportation_dissatisfied" BIGINT,
  "fire_department_satisfied" BIGINT,
  "fire_department_neither" BIGINT,
  "fire_department_disatisfied" BIGINT,
  "sewage_system_satisfied" BIGINT,
  "sewage_system_neither" BIGINT,
  "sewage_system_dissatisfied" BIGINT,
  "condition_cost_housing_satisfied" BIGINT,
  "condition_cost_housing_neither" BIGINT,
  "condition_cost_housing_dissatisfied" BIGINT
);

Public Assistance, 1974-1976

@usgov.allegheny_county_city_of_pitts_pittsburgh_neighborhood_758ce01b.public_assistance_1974_1976

11.99 kB
69 rows
7 columns

CREATE TABLE public_assistance_1974_1976 (
  "neighborhood" VARCHAR,
  "number_households_receiving_grants_1974" VARCHAR,
  "percentage_households_receiving_grants_1974" DOUBLE,
  "number_households_receiving_grants_1975" DOUBLE,
  "percentage_households_receiving_grants_1975" DOUBLE,
  "number_households_receiving_grants_1976" DOUBLE,
  "percentage_households_receiving_grants_1976" DOUBLE
);

Real Estate And Mortgage Loan Transactions 1973-1975

@usgov.allegheny_county_city_of_pitts_pittsburgh_neighborhood_758ce01b.real_estate_and_mortgage_loan_transactions_1973_1975

12.96 kB
68 rows
12 columns

CREATE TABLE real_estate_and_mortgage_loan_transactions_1973_1975 (
  "neighborhood" VARCHAR,
  "average_sales_price_1974" DOUBLE,
  "average_sales_price_1975" BIGINT,
  "number_residential_mortgages_1973" BIGINT,
  "number_residential_mortgages_1974" BIGINT,
  "number_residential_mortgages_1975" BIGINT,
  "percentage_transactions_with_mortgages_1974" BIGINT,
  "percentage_transactions_with_mortgages_1975" BIGINT,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11
);