Name: 2010 Census Block Groups
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

2010 Census Block Groups

Pittsburgh 2010 Census Blockgroups
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:06:54.505926
Tags: demographics, harvested, pittsburgh

Tables

Table 1

@usgov.allegheny_county_city_of_pitts_2010_census_block_groups_ebcfb.table_1

42.26 kB
361 rows
21 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "statefp10" BIGINT,
  "countyfp10" BIGINT,
  "tractce10" BIGINT,
  "blkgrpce10" BIGINT,
  "geoid10" BIGINT,
  "namelsad10" VARCHAR,
  "mtfcc10" VARCHAR,
  "funcstat10" VARCHAR,
  "aland10" BIGINT,
  "awater10" BIGINT,
  "intptlat10" DOUBLE,
  "intptlon10" DOUBLE,
  "hood" VARCHAR,
  "hood_no" BIGINT,
  "acres" DOUBLE,
  "sqmiles" DOUBLE,
  "sectors" BIGINT,
  "censusblockgroup" BIGINT,
  "shape_area" DOUBLE  -- Shape, Area,
  "shape_length" DOUBLE  -- Shape, Length
);