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.535263
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.58 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

25.57 MB
579473 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.32 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,
  "n_0764b00299000000" VARCHAR,
  "n_0665k00080000000" VARCHAR,
  "n_0665k00100000000" VARCHAR
);

Parcel Centroid February 2018

@usgov.allegheny_county_city_of_pitts_parcel_centroids_in_all_6f03b4f8.parcel_centroid_february_2018

44.49 MB
580071 rows
59 columns


CREATE TABLE parcel_centroid_february_2018 (
  "pin" VARCHAR,
  "mapblocklo" VARCHAR,
  "municode" BIGINT,
  "globalid" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE,
  "statefp10" BIGINT,
  "countyfp10" BIGINT,
  "tractce10" BIGINT,
  "blockce10" BIGINT,
  "geoid10" BIGINT,
  "name10" VARCHAR,
  "mtfcc10" VARCHAR,
  "ur10" VARCHAR,
  "uace10" VARCHAR,
  "uatyp10" VARCHAR,
  "funcstat10" VARCHAR,
  "intptlat10" DOUBLE,
  "intptlon10" DOUBLE,
  "geoid2" DOUBLE,
  "geo_name_c" VARCHAR,
  "geo_id_cou" BIGINT,
  "level_coun" VARCHAR,
  "geo_name_n" VARCHAR,
  "geo_id_nho" VARCHAR,
  "level_nhoo" VARCHAR,
  "geo_name_t" BIGINT,
  "geo_id_tra" BIGINT,
  "level_trac" VARCHAR,
  "geo_name_b" VARCHAR,
  "geo_id_blo" BIGINT,
  "level_bloc" VARCHAR,
  "geo_name_1" VARCHAR,
  "geo_id_c_1" BIGINT,
  "level_cous" VARCHAR,
  "geo_name_z" BIGINT,
  "geo_id_zip" BIGINT,
  "level_zipc" VARCHAR,
  "geo_name_s" VARCHAR,
  "geo_id_sch" BIGINT,
  "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,
  "objectid_2_1" BIGINT,
  "pgh_pli_zo" BIGINT,
  "pgh_cityco" BIGINT,
  "pgh_police" BIGINT,
  "pgh_firedi" VARCHAR,
  "pgh_dpw_di" BIGINT,
  "pgh_ward" BIGINT,
  "distance" BIGINT,
  "shape_leng_1" DOUBLE
);

Parcel Centroids April, 2016

@usgov.allegheny_county_city_of_pitts_parcel_centroids_in_all_6f03b4f8.parcel_centroids_april_2016

43.15 MB
578955 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
);