]> gitweb.michael.orlitzky.com - dead/census-tools.git/blob - sql/create-blocks-table.sql
Added the LinearProgramming module.
[dead/census-tools.git] / 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 );