Baselight

Pittsburgh 2014 CDBG Block Groups

Allegheny County / City of Pittsburgh / Western PA Regional Data Center

@usgov.allegheny_county_city_of_pitts_pittsburgh_2014_cdbg_bl_29097c84

Loading...
Loading...

About this Dataset

Pittsburgh 2014 CDBG Block Groups

2014 PGH Community Development Block Grant (CDBG) Areas Block Groups
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:07:28.379013
Tags: _etl, cdbg, census-block-groups, demographics, pittsburgh

Tables

Table 1

@usgov.allegheny_county_city_of_pitts_pittsburgh_2014_cdbg_bl_29097c84.table_1
  • 124.27 KB
  • 361 rows
  • 69 columns
Loading...

CREATE TABLE table_1 (
  "n__id" BIGINT,
  "census_11" BIGINT,
  "n_lowmodun" BIGINT,
  "objectid" BIGINT,
  "acres" DOUBLE,
  "fid" BIGINT,
  "funcstat10" VARCHAR,
  "blkgrp" VARCHAR,
  "blkgrpce10" BIGINT,
  "shape_le_2" DOUBLE,
  "dpwdiv" BIGINT,
  "tract" VARCHAR,
  "pclowmod" DOUBLE,
  "shape_le_1" DOUBLE,
  "census_b_3" BIGINT,
  "area" DOUBLE,
  "intptlat10" DOUBLE,
  "census_13" DOUBLE,
  "neighbor_i" BIGINT,
  "awater10" BIGINT,
  "census_b_2" BIGINT,
  "census_b_4" BIGINT,
  "sectors" BIGINT,
  "mtfcc10" VARCHAR,
  "namelsad10" VARCHAR,
  "censusbg_1" VARCHAR,
  "hood" VARCHAR,
  "tractce10" BIGINT,
  "f2014cdbg" VARCHAR,
  "census_b_5" BIGINT,
  "statefp10" BIGINT,
  "cdbguogid" VARCHAR,
  "oid" BIGINT,
  "fid_blockg" BIGINT,
  "countyname" VARCHAR,
  "shape_area" DOUBLE,
  "countyfp10" BIGINT,
  "cdbg2014" VARCHAR,
  "census_b_6" BIGINT,
  "census_b_8" VARCHAR,
  "hood_no" BIGINT,
  "unique_id" BIGINT,
  "shape_leng" DOUBLE,
  "state" VARCHAR,
  "bgtext" VARCHAR,
  "shape_length" DOUBLE,
  "county" VARCHAR,
  "shape_ar_1" DOUBLE,
  "geoid10" BIGINT,
  "census_b_7" VARCHAR,
  "census_b_9" VARCHAR,
  "sqmiles" DOUBLE,
  "fid_neighb" BIGINT,
  "census_14" DOUBLE,
  "aland10" BIGINT,
  "census_blo" BIGINT,
  "perimeter" DOUBLE,
  "intptlon10" DOUBLE,
  "censusbg" BIGINT,
  "cdbgty" VARCHAR,
  "n_lowmod" BIGINT,
  "stusab" VARCHAR,
  "census_10" BIGINT,
  "cdbgname" VARCHAR,
  "census_15" DOUBLE,
  "census_12" DOUBLE,
  "neighbor" BIGINT,
  "tract10" BIGINT,
  "lowmodpct" DOUBLE
);

Share link

Anyone who has the link will be able to view this.