sql/create-blocks-table.sql

   1 /*
   2   Create a new "blocks" table to comprise the
   3   sf1_blocks and tiger_blocks tables.
   4 */
   5
   6 CREATE TABLE blocks (
   7        id                 SERIAL           PRIMARY KEY,
   8        state              varchar(2)       NOT NULL,
   9        county             varchar(3)       NOT NULL,
  10        tract              varchar(6)       NOT NULL,
  11        block              varchar(4)       NOT NULL,
  12        blkidfp00          varchar(15)      NOT NULL,
  13        pop100             integer          NOT NULL,
  14        total_area         double precision NOT NULL,
  15        population_density double precision NOT NULL,
  16        the_geom           geometry         NOT NULL
  17 );