Neighborhoods
Allegheny County / City of Pittsburgh / Western PA Regional Data Center
@usgov.allegheny_county_city_of_pitts_neighborhoods_57111
Allegheny County / City of Pittsburgh / Western PA Regional Data Center
@usgov.allegheny_county_city_of_pitts_neighborhoods_57111
Pittsburgh Neighborhoods
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:03:57.758231
Tags: _etl, allegheny-county-gis, civic-vitality-and-governance, demographics, geography, pittsburgh
CREATE TABLE table_1 (
"n__id" BIGINT -- Id,
"objectid" BIGINT,
"fid_blockg" BIGINT,
"statefp10" VARCHAR,
"countyfp10" VARCHAR,
"tractce10" VARCHAR,
"blkgrpce10" VARCHAR,
"geoid10" VARCHAR,
"namelsad10" VARCHAR,
"mtfcc10" VARCHAR,
"funcstat10" VARCHAR,
"aland10" BIGINT,
"awater10" BIGINT,
"intptlat10" VARCHAR,
"intptlon10" VARCHAR,
"shape_leng" DOUBLE,
"fid_neighb" BIGINT,
"pghdb_sde_neighborhood_2010_area" DOUBLE,
"perimeter" DOUBLE,
"neighbor" BIGINT,
"neighbor_i" BIGINT,
"hood" VARCHAR,
"hood_no" BIGINT,
"acres" DOUBLE,
"sqmiles" DOUBLE,
"dpwdiv" BIGINT,
"unique_id" BIGINT,
"sectors" BIGINT,
"shape_le_1" DOUBLE,
"shape_ar_1" DOUBLE,
"page_number" BIGINT,
"plannerassign" VARCHAR,
"globalid" VARCHAR,
"created_user" VARCHAR,
"created_date" TIMESTAMP,
"last_edited_user" VARCHAR,
"last_edited_date" TIMESTAMP,
"temp" VARCHAR,
"shape_area" DOUBLE,
"shape_length" DOUBLE
);Anyone who has the link will be able to view this.