About this Dataset

Parcel Centroids In Allegheny County With Geographic Identifiers

Parcel centroids in Allegheny County. Centroids created by the Western PA Regional Data Center using County parcel shapes found on PASDA or WPRDC. Centroids have been drawn within the parcel boundary in most cases. The Data Center also appended a number of geographic codes to the data, including 2010 Census Blocks, Blockgroups, and Census Tracts, County Subdivisions (Municipalities), School Districts, State House and Senate Districts, and Allegheny County Council Districts.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:07:51.535265
Tags: centroid, coordinate, crosswalk, latitude, longitude, parcel, xy

Tables

Data Dictionary

@usgov.allegheny_county_city_of_pitts_parcel_centroids_in_all_6f03b4f8.data_dictionary

6.73 kB
40 rows
5 columns

CREATE TABLE data_dictionary (
  "field" VARCHAR,
  "definition" VARCHAR,
  "samplerecord1" VARCHAR,
  "samplerecord2" VARCHAR,
  "samplerecord3" VARCHAR
);

Parcel Centroid August 2016

@usgov.allegheny_county_city_of_pitts_parcel_centroids_in_all_6f03b4f8.parcel_centroid_august_2016

26.82 MB
579,473 rows
46 columns

CREATE TABLE parcel_centroid_august_2016 (
  "pin" VARCHAR,
  "mapblocklo" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE,
  "statefp10" BIGINT,
  "countyfp10" BIGINT,
  "tractce10" BIGINT,
  "blockce10" BIGINT,
  "geoid10" DOUBLE,
  "name10" VARCHAR,
  "geo_name_county" VARCHAR,
  "geo_id_county" BIGINT,
  "level_county" VARCHAR,
  "geo_name_nhood" VARCHAR,
  "geo_id_nhood" DOUBLE,
  "level_nhood" VARCHAR,
  "geo_name_tract" BIGINT,
  "geo_id_tract" BIGINT,
  "level_tract" VARCHAR,
  "geo_name_blockgp" VARCHAR,
  "geo_id_blockgp" DOUBLE,
  "level_blockgp" VARCHAR,
  "geo_name_cousub" VARCHAR,
  "geo_id_cousub" BIGINT,
  "level_cousub" VARCHAR,
  "geo_name_zipcode" BIGINT,
  "geo_id_zipcode" BIGINT,
  "level_zipcode" VARCHAR,
  "geo_name_schooldist" VARCHAR,
  "geo_id_schooldist" BIGINT,
  "level_schooldist" VARCHAR,
  "geo_name_housepa" VARCHAR,
  "geo_id_housepa" VARCHAR,
  "level_housepa" VARCHAR,
  "geo_name_senatepa" VARCHAR,
  "geo_id_senatepa" VARCHAR,
  "level_senatepa" VARCHAR,
  "geo_name_countycouncil" VARCHAR,
  "geo_id_countycouncil" VARCHAR,
  "level_countycouncil" VARCHAR,
  "pgh_pli_zone" BIGINT,
  "pgh_citycouncil2012" BIGINT,
  "pgh_policezone" BIGINT,
  "pgh_firedistrict" VARCHAR,
  "pgh_dpw_division" BIGINT,
  "pgh_ward" BIGINT
);

Parcel Centroid Data Dictionary August 10, 2016

@usgov.allegheny_county_city_of_pitts_parcel_centroids_in_all_6f03b4f8.parcel_centroid_data_dictionary_august_10_2016

8.52 kB
45 rows
6 columns

CREATE TABLE parcel_centroid_data_dictionary_august_10_2016 (
  "pin" VARCHAR,
  "preferred_parcel_id_consistent_with_county_gis_and_assessment" VARCHAR,
  "n_0764b00296000000" VARCHAR  -- 0764B00296000000,
  "n_0764b00299000000" VARCHAR  -- 0764B00299000000,
  "n_0665k00080000000" VARCHAR  -- 0665K00080000000,
  "n_0665k00100000000" VARCHAR  -- 0665K00100000000
);

Parcel Centroids April, 2016

@usgov.allegheny_county_city_of_pitts_parcel_centroids_in_all_6f03b4f8.parcel_centroids_april_2016

45.25 MB
578,955 rows
55 columns

CREATE TABLE parcel_centroids_april_2016 (
  "pin" VARCHAR,
  "mapblocklo" VARCHAR,
  "shapearea" DOUBLE,
  "shapelen" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "objectid_1" BIGINT,
  "statefp10" VARCHAR,
  "countyfp10" VARCHAR,
  "tractce10" VARCHAR,
  "blockce10" VARCHAR,
  "geoid10" VARCHAR,
  "name10" VARCHAR,
  "mtfcc10" VARCHAR,
  "ur10" VARCHAR,
  "uace10" VARCHAR,
  "uatyp10" VARCHAR,
  "funcstat10" VARCHAR,
  "aland10" BIGINT,
  "awater10" BIGINT,
  "intptlat10" VARCHAR,
  "intptlon10" VARCHAR,
  "geoid2" DOUBLE,
  "geo_name_c" VARCHAR,
  "geo_id_cou" VARCHAR,
  "level_coun" VARCHAR,
  "geo_name_n" VARCHAR,
  "geo_id_nho" VARCHAR,
  "level_nhoo" VARCHAR,
  "geo_name_t" VARCHAR,
  "geo_id_tra" VARCHAR,
  "level_trac" VARCHAR,
  "geo_name_b" VARCHAR,
  "geo_id_blo" VARCHAR,
  "level_bloc" VARCHAR,
  "geo_name_1" VARCHAR,
  "geo_id_c_1" VARCHAR,
  "level_cous" VARCHAR,
  "geo_name_z" VARCHAR,
  "geo_id_zip" VARCHAR,
  "level_zipc" VARCHAR,
  "geo_name_s" VARCHAR,
  "geo_id_sch" VARCHAR,
  "level_scho" VARCHAR,
  "geo_name_h" VARCHAR,
  "geo_id_hou" VARCHAR,
  "level_hous" VARCHAR,
  "geo_name_2" VARCHAR,
  "geo_id_sen" VARCHAR,
  "level_sena" VARCHAR,
  "geo_name_3" VARCHAR,
  "geo_id_c_2" VARCHAR,
  "level_co_1" VARCHAR,
  "shape_leng" DOUBLE,
  "shape_area" DOUBLE
);