[postgis-users] Loading Tiger2007fe data - Thoughts on using inherited tables

[Stephen Woodbridge]

Stephen,

Changing the subject on this thread.

Have look into using inherited tables? This would allow you to have a 
nation view or a state view of the county data. View being used in the 
literal not postgres in this case.

create table us_tiger.blocks ....;

create table ST_tiger.blocks inherits us_tiger.blocks;

create table STCCC_tiger.blocks inherits ST_tiger.blocks;

load data into STCCC_tiger.blocks

now you can query on any level of these. Displaying in mapserver at the 
national level is as easy as a LAYER that references us_tiger.blocks.

You have to set up indexes, I'm not sure what the best we to do this is.

This scheme also allows you to drop and replace one STCCC_tiger.blocks 
table with new data and it is magically integrated back into the model.

Thoughts?

-Stephen Woodbridge
  http://imaptools.com/