Dataset: Census Tracts In 2010

About this Dataset

Census Tracts In 2010

The TIGER/Line Files are shapefiles and related database files (.dbf) that are an extract of selected geographic and cartographic information from the U.S. Census Bureau's Master Address File / Topologically Integrated Geographic Encoding and Referencing (MAF/TIGER) Database (MTDB). The MTDB represents a seamless national file with no overlaps or gaps between parts, however, each TIGER/Line File is designed to stand alone as an independent data set, or they can be combined to cover the entire nation. Face refers to the areal (polygon) topological primitives that make up MTDB. A face is bounded by one or more edges; its boundary includes only the edges that separate it from other faces, not any interior edges contained within the area of the face. The Topological Faces Shapefile contains the attributes of each topological primitive face. Each face has a unique topological face identifier (TFID) value. Each face in the shapefile includes the key geographic area codes for almost all geographic areas for which the Census Bureau tabulates data for both the 2010 Census and Census 2000. The geometries of each of these geographic areas can then be built by dissolving the face geometries on the appropriate key geographic area codes in the Topological Faces Shapefile.
Organization: District of Columbia
Last updated: 2024-04-30T19:05:56.472049
Tags: 1-percent-public-use-microdata-area-code, 106th-congressional-district-code, 108th-congressional-district-code, 3-digit-zip-code-tabulation-area-code, 5-digit-zip-code-tabulation-area-code, 5-percent-public-use-microdata-area-code, alaska-native-regional-corporation-fips-code, american-indian-alaska-native-native-hawaiian-areas-census-code, boundaries, census, census-tract-number, consolidated-city-fips-code, county-fips-code, county-or-equivalent-entity, county-subdivision-fips-code, dc-gis, demographic, district-of-columbia, elementary-school-district-local-education-agency-code, fips-55-place-code-for-all-places, income, legislative-session-year, metropolitan-statistical-area-consolidated-metropolitan-statistical-area-fips-code, new-england-county-metropolitan-area-fips-code, people, primary-metropolitan-statistical-area-fips-code, rreservation-or-off-reservation-trust-land-indicator, secondary-school-district-local-education-agency-code, state-fips-code, state-legislative-district-lower-chamber-code, state-legislative-district-upper-chamber-code, sub-minor-civil-division-fips-code-in-puerto-rico, tabulation-block-number, tribal-subdivision-code, u-s, unified-school-district-local-education-agency-code, urban-growth-area-code, voting-district-code, washington-dc

Tables

Table 1

@usgov.district_of_columbia_census_tracts_in_2010.table_1

93.75 KB
179 rows
72 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "tract" BIGINT,
  "geoid" BIGINT,
  "p0010001" BIGINT,
  "p0010002" BIGINT,
  "p0010003" BIGINT,
  "p0010004" BIGINT,
  "p0010005" BIGINT,
  "p0010006" BIGINT,
  "p0010007" BIGINT,
  "p0010008" BIGINT,
  "op000001" BIGINT,
  "op000002" BIGINT,
  "op000003" BIGINT,
  "op000004" BIGINT,
  "p0020002" BIGINT,
  "p0020005" BIGINT,
  "p0020006" BIGINT,
  "p0020007" BIGINT,
  "p0020008" BIGINT,
  "p0020009" BIGINT,
  "p0020010" BIGINT,
  "op00005" BIGINT,
  "op00006" BIGINT,
  "op00007" BIGINT,
  "op00008" BIGINT,
  "p0030001" BIGINT,
  "p0030003" BIGINT,
  "p0030004" BIGINT,
  "p0030005" BIGINT,
  "p0030006" BIGINT,
  "p0030007" BIGINT,
  "p0030008" BIGINT,
  "op00009" BIGINT,
  "op00010" BIGINT,
  "op00011" BIGINT,
  "op00012" BIGINT,
  "p0040002" BIGINT,
  "p0040005" BIGINT,
  "p0040006" BIGINT,
  "p0040007" BIGINT,
  "p0040008" BIGINT,
  "p0040009" BIGINT,
  "p0040010" BIGINT,
  "op000013" BIGINT,
  "op000014" BIGINT,
  "op000015" BIGINT,
  "op000016" BIGINT,
  "h0010001" BIGINT,
  "h0010002" BIGINT,
  "h0010003" BIGINT,
  "acres" DOUBLE,
  "sq_miles" DOUBLE,
  "fagi_total_2010" DOUBLE,
  "fagi_median_2010" DOUBLE,
  "fagi_total_2011" DOUBLE,
  "fagi_median_2011" DOUBLE,
  "fagi_total_2012" DOUBLE,
  "fagi_median_2012" DOUBLE,
  "fagi_total_2013" DOUBLE,
  "fagi_median_2013" DOUBLE,
  "fagi_total_2014" DOUBLE,
  "fagi_median_2014" DOUBLE,
  "fagi_total_2015" DOUBLE,
  "fagi_median_2015" DOUBLE,
  "gis_id" VARCHAR,
  "creator" VARCHAR,
  "created" VARCHAR,
  "editor" VARCHAR,
  "edited" VARCHAR,
  "shapearea" BIGINT,
  "shapelen" BIGINT
);