]>
gitweb.michael.orlitzky.com - dead/census-tools.git/blob - sql/create-blocks-table.sql
2 Create a new "blocks" table to comprise the
3 sf1_blocks and tiger_blocks tables.
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