Census 2010: Blocks For San Francisco by US Government | Demographics and Population Studies

About this Dataset

Census 2010: Blocks For San Francisco

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. Census Blocks are statistical areas bounded on all sides by visible features, such as streets, roads, streams, and railroad tracks, and/or by nonvisible boundaries such as city, town, township, and county limits, and short line-of-sight extensions of streets and roads. Census blocks are relatively small in area; for example, a block in a city bounded by streets. However, census blocks in remote areas are often large and irregular and may even be many square miles in area. A common misunderstanding is that data users think census blocks are used geographically to build all other census geographic areas, rather all other census geographic areas are updated and then used as the primary constraints, along with roads and water features, to delineate the tabulation blocks. As a result, all 2010 Census blocks nest within every other 2010 Census geographic area, so that Census Bureau statistical data can be tabulated at the block level and aggregated up to the appropriate geographic areas.
Organization: City of San Francisco
Last updated: 2023-12-02T06:10:13.978301

Tables

Table 1

@usgov.city_of_san_francisco_tl_2010_06075_tabblock10.table_1

1.32 MB
7386 rows
15 columns


CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "countyfp10" BIGINT,
  "tractce10" BIGINT,
  "statefp10" BIGINT,
  "blockce10" BIGINT,
  "geoid10" BIGINT,
  "name10" VARCHAR,
  "mtfcc10" VARCHAR,
  "ur10" VARCHAR,
  "uace10" VARCHAR,
  "funcstat10" VARCHAR,
  "aland10" BIGINT,
  "awater10" BIGINT,
  "intptlat10" DOUBLE,
  "intptlon10" DOUBLE
);