Loading TIGER otherstuff

a. giant polygon

CREATE TABLE giant_polygon AS
 SELECT envelope('BOX3D(-180 -90,180 90)'::box3d) as the_geom;

10. geometry_columns

insert into geometry_columns values ('','public','point_landmark','wkb_geometry',2,1,'GEOMETRY');
 insert into geometry_columns values ('','public','poly_landmarks','buffer',2,1,'GEOMETRY');
 insert into geometry_columns values ('','public','finalroads','wkb_geometry',2,1,'GEOMETRY');
 insert into geometry_columns values ('','public','giant_polygon','the_geom',2,-1,'GEOMETRY');

11. load into geoserver:

A) point_landmark - label points & mark
B) poly_landmark - label and colour
C) roads - wide and label
D) giant polygon

12. indexes

CREATE index point_landmark_idx on point_landmark using gist (wkb_geometry gist_geometry_ops);
CREATE index poly_landmarks_idx on poly_landmarks using gist (buffer gist_geometry_ops);
CREATE index finalroads_idx on finalroads using gist (wkb_geometry gist_geometry_ops);

analyse;

13. WATER - lines

Fill in later

14. WATER - polygons

Fill in later