Name: Census2000 Tracts Nowater
Creator: US Government
License: http://opendatacommons.org/licenses/pddl/1.0/

About this Dataset

Census2000 Tracts Nowater

US Census 2000 Tract Geography modified to conform with SFGIS Library Geography (Streets, Lakes, et al). Water areas have been clipped from this layer. Please refer to the Federal Census for the latest data, these boundaries provided as a convenience.
Organization: City of San Francisco
Last updated: 2023-12-02T06:14:29.594345
Tags: boundaries, census

Tables

Table 1

@usgov.city_of_san_francisco_census2000_tracts_nowater.table_1

562.43 KB
176 rows
47 columns


CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "fipsstco" BIGINT,
  "trt2000" BIGINT,
  "stfid" BIGINT,
  "tractid" DOUBLE,
  "state" BIGINT,
  "county" BIGINT,
  "tract" BIGINT,
  "pop2000" BIGINT,
  "white" BIGINT,
  "black" BIGINT,
  "ameri_es" BIGINT,
  "asian" BIGINT,
  "hawn_pi" BIGINT,
  "other" BIGINT,
  "mult_race" BIGINT,
  "hispanic" BIGINT,
  "males" BIGINT,
  "females" BIGINT,
  "age_under5" BIGINT,
  "age_5_17" BIGINT,
  "age_18_21" BIGINT,
  "age_22_29" BIGINT,
  "age_30_39" BIGINT,
  "age_40_49" BIGINT,
  "age_50_64" BIGINT,
  "age_65_up" BIGINT,
  "med_age" DOUBLE,
  "med_age_m" DOUBLE,
  "med_age_f" DOUBLE,
  "households" BIGINT,
  "ave_hh_sz" DOUBLE,
  "hsehld_1_m" BIGINT,
  "hsehld_1_f" BIGINT,
  "marhh_chd" BIGINT,
  "marhh_no_c" BIGINT,
  "mhh_child" BIGINT,
  "fhh_child" BIGINT,
  "families" BIGINT,
  "ave_fam_sz" DOUBLE,
  "hse_units" BIGINT,
  "urban" BIGINT,
  "rural" BIGINT,
  "vacant" BIGINT,
  "owner_occ" BIGINT,
  "renter_occ" BIGINT
);