drop view if exists cd106;
create view cd106 as
select * from tiger_01.cd106
UNION ALL
select * from tiger_02.cd106
UNION ALL
select * from tiger_04.cd106
UNION ALL
select * from tiger_05.cd106
UNION ALL
select * from tiger_06.cd106
UNION ALL
select * from tiger_08.cd106
UNION ALL
select * from tiger_09.cd106
UNION ALL
select * from tiger_10.cd106
UNION ALL
select * from tiger_11.cd106
UNION ALL
select * from tiger_12.cd106
UNION ALL
select * from tiger_13.cd106
UNION ALL
select * from tiger_15.cd106
UNION ALL
select * from tiger_16.cd106
UNION ALL
select * from tiger_17.cd106
UNION ALL
select * from tiger_18.cd106
UNION ALL
select * from tiger_19.cd106
UNION ALL
select * from tiger_20.cd106
UNION ALL
select * from tiger_21.cd106
UNION ALL
select * from tiger_22.cd106
UNION ALL
select * from tiger_23.cd106
UNION ALL
select * from tiger_24.cd106
UNION ALL
select * from tiger_25.cd106
UNION ALL
select * from tiger_26.cd106
UNION ALL
select * from tiger_27.cd106
UNION ALL
select * from tiger_28.cd106
UNION ALL
select * from tiger_29.cd106
UNION ALL
select * from tiger_30.cd106
UNION ALL
select * from tiger_31.cd106
UNION ALL
select * from tiger_32.cd106
UNION ALL
select * from tiger_33.cd106
UNION ALL
select * from tiger_34.cd106
UNION ALL
select * from tiger_35.cd106
UNION ALL
select * from tiger_36.cd106
UNION ALL
select * from tiger_37.cd106
UNION ALL
select * from tiger_38.cd106
UNION ALL
select * from tiger_39.cd106
UNION ALL
select * from tiger_40.cd106
UNION ALL
select * from tiger_41.cd106
UNION ALL
select * from tiger_42.cd106
UNION ALL
select * from tiger_44.cd106
UNION ALL
select * from tiger_45.cd106
UNION ALL
select * from tiger_46.cd106
UNION ALL
select * from tiger_47.cd106
UNION ALL
select * from tiger_48.cd106
UNION ALL
select * from tiger_49.cd106
UNION ALL
select * from tiger_50.cd106
UNION ALL
select * from tiger_51.cd106
UNION ALL
select * from tiger_53.cd106
UNION ALL
select * from tiger_54.cd106
UNION ALL
select * from tiger_55.cd106
UNION ALL
select * from tiger_56.cd106
UNION ALL
select * from tiger_60.cd106
UNION ALL
select * from tiger_66.cd106
UNION ALL
select * from tiger_69.cd106
UNION ALL
select * from tiger_72.cd106
UNION ALL
select * from tiger_78.cd106
;
drop view if exists cd108;
create view cd108 as
select * from tiger_01.cd108
UNION ALL
select * from tiger_02.cd108
UNION ALL
select * from tiger_04.cd108
UNION ALL
select * from tiger_05.cd108
UNION ALL
select * from tiger_06.cd108
UNION ALL
select * from tiger_08.cd108
UNION ALL
select * from tiger_09.cd108
UNION ALL
select * from tiger_10.cd108
UNION ALL
select * from tiger_11.cd108
UNION ALL
select * from tiger_12.cd108
UNION ALL
select * from tiger_13.cd108
UNION ALL
select * from tiger_15.cd108
UNION ALL
select * from tiger_16.cd108
UNION ALL
select * from tiger_17.cd108
UNION ALL
select * from tiger_18.cd108
UNION ALL
select * from tiger_19.cd108
UNION ALL
select * from tiger_20.cd108
UNION ALL
select * from tiger_21.cd108
UNION ALL
select * from tiger_22.cd108
UNION ALL
select * from tiger_23.cd108
UNION ALL
select * from tiger_24.cd108
UNION ALL
select * from tiger_25.cd108
UNION ALL
select * from tiger_26.cd108
UNION ALL
select * from tiger_27.cd108
UNION ALL
select * from tiger_28.cd108
UNION ALL
select * from tiger_29.cd108
UNION ALL
select * from tiger_30.cd108
UNION ALL
select * from tiger_31.cd108
UNION ALL
select * from tiger_32.cd108
UNION ALL
select * from tiger_33.cd108
UNION ALL
select * from tiger_34.cd108
UNION ALL
select * from tiger_35.cd108
UNION ALL
select * from tiger_36.cd108
UNION ALL
select * from tiger_37.cd108
UNION ALL
select * from tiger_38.cd108
UNION ALL
select * from tiger_39.cd108
UNION ALL
select * from tiger_40.cd108
UNION ALL
select * from tiger_41.cd108
UNION ALL
select * from tiger_42.cd108
UNION ALL
select * from tiger_44.cd108
UNION ALL
select * from tiger_45.cd108
UNION ALL
select * from tiger_46.cd108
UNION ALL
select * from tiger_47.cd108
UNION ALL
select * from tiger_48.cd108
UNION ALL
select * from tiger_49.cd108
UNION ALL
select * from tiger_50.cd108
UNION ALL
select * from tiger_51.cd108
UNION ALL
select * from tiger_53.cd108
UNION ALL
select * from tiger_54.cd108
UNION ALL
select * from tiger_55.cd108
UNION ALL
select * from tiger_56.cd108
UNION ALL
select * from tiger_60.cd108
UNION ALL
select * from tiger_66.cd108
UNION ALL
select * from tiger_69.cd108
UNION ALL
select * from tiger_72.cd108
UNION ALL
select * from tiger_78.cd108
;
drop view if exists cd110;
create view cd110 as
select * from tiger_01.cd110
UNION ALL
select * from tiger_02.cd110
UNION ALL
select * from tiger_04.cd110
UNION ALL
select * from tiger_05.cd110
UNION ALL
select * from tiger_06.cd110
UNION ALL
select * from tiger_08.cd110
UNION ALL
select * from tiger_09.cd110
UNION ALL
select * from tiger_10.cd110
UNION ALL
select * from tiger_11.cd110
UNION ALL
select * from tiger_12.cd110
UNION ALL
select * from tiger_13.cd110
UNION ALL
select * from tiger_15.cd110
UNION ALL
select * from tiger_16.cd110
UNION ALL
select * from tiger_17.cd110
UNION ALL
select * from tiger_18.cd110
UNION ALL
select * from tiger_19.cd110
UNION ALL
select * from tiger_20.cd110
UNION ALL
select * from tiger_21.cd110
UNION ALL
select * from tiger_22.cd110
UNION ALL
select * from tiger_23.cd110
UNION ALL
select * from tiger_24.cd110
UNION ALL
select * from tiger_25.cd110
UNION ALL
select * from tiger_26.cd110
UNION ALL
select * from tiger_27.cd110
UNION ALL
select * from tiger_28.cd110
UNION ALL
select * from tiger_29.cd110
UNION ALL
select * from tiger_30.cd110
UNION ALL
select * from tiger_31.cd110
UNION ALL
select * from tiger_32.cd110
UNION ALL
select * from tiger_33.cd110
UNION ALL
select * from tiger_34.cd110
UNION ALL
select * from tiger_35.cd110
UNION ALL
select * from tiger_36.cd110
UNION ALL
select * from tiger_37.cd110
UNION ALL
select * from tiger_38.cd110
UNION ALL
select * from tiger_39.cd110
UNION ALL
select * from tiger_40.cd110
UNION ALL
select * from tiger_41.cd110
UNION ALL
select * from tiger_42.cd110
UNION ALL
select * from tiger_44.cd110
UNION ALL
select * from tiger_45.cd110
UNION ALL
select * from tiger_46.cd110
UNION ALL
select * from tiger_47.cd110
UNION ALL
select * from tiger_48.cd110
UNION ALL
select * from tiger_49.cd110
UNION ALL
select * from tiger_50.cd110
UNION ALL
select * from tiger_51.cd110
UNION ALL
select * from tiger_53.cd110
UNION ALL
select * from tiger_54.cd110
UNION ALL
select * from tiger_55.cd110
UNION ALL
select * from tiger_56.cd110
UNION ALL
select * from tiger_60.cd110
UNION ALL
select * from tiger_66.cd110
UNION ALL
select * from tiger_69.cd110
UNION ALL
select * from tiger_72.cd110
UNION ALL
select * from tiger_78.cd110
;
drop view if exists county;
create view county as
select * from tiger_01.county
UNION ALL
select * from tiger_02.county
UNION ALL
select * from tiger_04.county
UNION ALL
select * from tiger_05.county
UNION ALL
select * from tiger_06.county
UNION ALL
select * from tiger_08.county
UNION ALL
select * from tiger_09.county
UNION ALL
select * from tiger_10.county
UNION ALL
select * from tiger_11.county
UNION ALL
select * from tiger_12.county
UNION ALL
select * from tiger_13.county
UNION ALL
select * from tiger_15.county
UNION ALL
select * from tiger_16.county
UNION ALL
select * from tiger_17.county
UNION ALL
select * from tiger_18.county
UNION ALL
select * from tiger_19.county
UNION ALL
select * from tiger_20.county
UNION ALL
select * from tiger_21.county
UNION ALL
select * from tiger_22.county
UNION ALL
select * from tiger_23.county
UNION ALL
select * from tiger_24.county
UNION ALL
select * from tiger_25.county
UNION ALL
select * from tiger_26.county
UNION ALL
select * from tiger_27.county
UNION ALL
select * from tiger_28.county
UNION ALL
select * from tiger_29.county
UNION ALL
select * from tiger_30.county
UNION ALL
select * from tiger_31.county
UNION ALL
select * from tiger_32.county
UNION ALL
select * from tiger_33.county
UNION ALL
select * from tiger_34.county
UNION ALL
select * from tiger_35.county
UNION ALL
select * from tiger_36.county
UNION ALL
select * from tiger_37.county
UNION ALL
select * from tiger_38.county
UNION ALL
select * from tiger_39.county
UNION ALL
select * from tiger_40.county
UNION ALL
select * from tiger_41.county
UNION ALL
select * from tiger_42.county
UNION ALL
select * from tiger_44.county
UNION ALL
select * from tiger_45.county
UNION ALL
select * from tiger_46.county
UNION ALL
select * from tiger_47.county
UNION ALL
select * from tiger_48.county
UNION ALL
select * from tiger_49.county
UNION ALL
select * from tiger_50.county
UNION ALL
select * from tiger_51.county
UNION ALL
select * from tiger_53.county
UNION ALL
select * from tiger_54.county
UNION ALL
select * from tiger_55.county
UNION ALL
select * from tiger_56.county
UNION ALL
select * from tiger_60.county
UNION ALL
select * from tiger_66.county
UNION ALL
select * from tiger_69.county
UNION ALL
select * from tiger_72.county
UNION ALL
select * from tiger_78.county
;
drop view if exists place;
create view place as
select * from tiger_01.place
UNION ALL
select * from tiger_02.place
UNION ALL
select * from tiger_04.place
UNION ALL
select * from tiger_05.place
UNION ALL
select * from tiger_06.place
UNION ALL
select * from tiger_08.place
UNION ALL
select * from tiger_09.place
UNION ALL
select * from tiger_10.place
UNION ALL
select * from tiger_11.place
UNION ALL
select * from tiger_12.place
UNION ALL
select * from tiger_13.place
UNION ALL
select * from tiger_15.place
UNION ALL
select * from tiger_16.place
UNION ALL
select * from tiger_17.place
UNION ALL
select * from tiger_18.place
UNION ALL
select * from tiger_19.place
UNION ALL
select * from tiger_20.place
UNION ALL
select * from tiger_21.place
UNION ALL
select * from tiger_22.place
UNION ALL
select * from tiger_23.place
UNION ALL
select * from tiger_24.place
UNION ALL
select * from tiger_25.place
UNION ALL
select * from tiger_26.place
UNION ALL
select * from tiger_27.place
UNION ALL
select * from tiger_28.place
UNION ALL
select * from tiger_29.place
UNION ALL
select * from tiger_30.place
UNION ALL
select * from tiger_31.place
UNION ALL
select * from tiger_32.place
UNION ALL
select * from tiger_33.place
UNION ALL
select * from tiger_34.place
UNION ALL
select * from tiger_35.place
UNION ALL
select * from tiger_36.place
UNION ALL
select * from tiger_37.place
UNION ALL
select * from tiger_38.place
UNION ALL
select * from tiger_39.place
UNION ALL
select * from tiger_40.place
UNION ALL
select * from tiger_41.place
UNION ALL
select * from tiger_42.place
UNION ALL
select * from tiger_44.place
UNION ALL
select * from tiger_45.place
UNION ALL
select * from tiger_46.place
UNION ALL
select * from tiger_47.place
UNION ALL
select * from tiger_48.place
UNION ALL
select * from tiger_49.place
UNION ALL
select * from tiger_50.place
UNION ALL
select * from tiger_51.place
UNION ALL
select * from tiger_53.place
UNION ALL
select * from tiger_54.place
UNION ALL
select * from tiger_55.place
UNION ALL
select * from tiger_56.place
UNION ALL
select * from tiger_60.place
UNION ALL
select * from tiger_66.place
UNION ALL
select * from tiger_69.place
UNION ALL
select * from tiger_72.place
UNION ALL
select * from tiger_78.place
;
drop view if exists puma100;
create view puma100 as
select * from tiger_01.puma100
UNION ALL
select * from tiger_02.puma100
UNION ALL
select * from tiger_04.puma100
UNION ALL
select * from tiger_05.puma100
UNION ALL
select * from tiger_06.puma100
UNION ALL
select * from tiger_08.puma100
UNION ALL
select * from tiger_09.puma100
UNION ALL
select * from tiger_10.puma100
UNION ALL
select * from tiger_11.puma100
UNION ALL
select * from tiger_12.puma100
UNION ALL
select * from tiger_13.puma100
UNION ALL
select * from tiger_15.puma100
UNION ALL
select * from tiger_16.puma100
UNION ALL
select * from tiger_17.puma100
UNION ALL
select * from tiger_18.puma100
UNION ALL
select * from tiger_19.puma100
UNION ALL
select * from tiger_20.puma100
UNION ALL
select * from tiger_21.puma100
UNION ALL
select * from tiger_22.puma100
UNION ALL
select * from tiger_23.puma100
UNION ALL
select * from tiger_24.puma100
UNION ALL
select * from tiger_25.puma100
UNION ALL
select * from tiger_26.puma100
UNION ALL
select * from tiger_27.puma100
UNION ALL
select * from tiger_28.puma100
UNION ALL
select * from tiger_29.puma100
UNION ALL
select * from tiger_30.puma100
UNION ALL
select * from tiger_31.puma100
UNION ALL
select * from tiger_32.puma100
UNION ALL
select * from tiger_33.puma100
UNION ALL
select * from tiger_34.puma100
UNION ALL
select * from tiger_35.puma100
UNION ALL
select * from tiger_36.puma100
UNION ALL
select * from tiger_37.puma100
UNION ALL
select * from tiger_38.puma100
UNION ALL
select * from tiger_39.puma100
UNION ALL
select * from tiger_40.puma100
UNION ALL
select * from tiger_41.puma100
UNION ALL
select * from tiger_42.puma100
UNION ALL
select * from tiger_44.puma100
UNION ALL
select * from tiger_45.puma100
UNION ALL
select * from tiger_46.puma100
UNION ALL
select * from tiger_47.puma100
UNION ALL
select * from tiger_48.puma100
UNION ALL
select * from tiger_49.puma100
UNION ALL
select * from tiger_50.puma100
UNION ALL
select * from tiger_51.puma100
UNION ALL
select * from tiger_53.puma100
UNION ALL
select * from tiger_54.puma100
UNION ALL
select * from tiger_55.puma100
UNION ALL
select * from tiger_56.puma100
UNION ALL
select * from tiger_72.puma100
;
drop view if exists puma500;
create view puma500 as
select * from tiger_01.puma500
UNION ALL
select * from tiger_02.puma500
UNION ALL
select * from tiger_04.puma500
UNION ALL
select * from tiger_05.puma500
UNION ALL
select * from tiger_06.puma500
UNION ALL
select * from tiger_08.puma500
UNION ALL
select * from tiger_09.puma500
UNION ALL
select * from tiger_10.puma500
UNION ALL
select * from tiger_11.puma500
UNION ALL
select * from tiger_12.puma500
UNION ALL
select * from tiger_13.puma500
UNION ALL
select * from tiger_15.puma500
UNION ALL
select * from tiger_16.puma500
UNION ALL
select * from tiger_17.puma500
UNION ALL
select * from tiger_18.puma500
UNION ALL
select * from tiger_19.puma500
UNION ALL
select * from tiger_20.puma500
UNION ALL
select * from tiger_21.puma500
UNION ALL
select * from tiger_22.puma500
UNION ALL
select * from tiger_23.puma500
UNION ALL
select * from tiger_24.puma500
UNION ALL
select * from tiger_25.puma500
UNION ALL
select * from tiger_26.puma500
UNION ALL
select * from tiger_27.puma500
UNION ALL
select * from tiger_28.puma500
UNION ALL
select * from tiger_29.puma500
UNION ALL
select * from tiger_30.puma500
UNION ALL
select * from tiger_31.puma500
UNION ALL
select * from tiger_32.puma500
UNION ALL
select * from tiger_33.puma500
UNION ALL
select * from tiger_34.puma500
UNION ALL
select * from tiger_35.puma500
UNION ALL
select * from tiger_36.puma500
UNION ALL
select * from tiger_37.puma500
UNION ALL
select * from tiger_38.puma500
UNION ALL
select * from tiger_39.puma500
UNION ALL
select * from tiger_40.puma500
UNION ALL
select * from tiger_41.puma500
UNION ALL
select * from tiger_42.puma500
UNION ALL
select * from tiger_44.puma500
UNION ALL
select * from tiger_45.puma500
UNION ALL
select * from tiger_46.puma500
UNION ALL
select * from tiger_47.puma500
UNION ALL
select * from tiger_48.puma500
UNION ALL
select * from tiger_49.puma500
UNION ALL
select * from tiger_50.puma500
UNION ALL
select * from tiger_51.puma500
UNION ALL
select * from tiger_53.puma500
UNION ALL
select * from tiger_54.puma500
UNION ALL
select * from tiger_55.puma500
UNION ALL
select * from tiger_56.puma500
UNION ALL
select * from tiger_72.puma500
UNION ALL
select * from tiger_78.puma500
;
drop view if exists sldl;
create view sldl as
select * from tiger_01.sldl
UNION ALL
select * from tiger_02.sldl
UNION ALL
select * from tiger_04.sldl
UNION ALL
select * from tiger_05.sldl
UNION ALL
select * from tiger_06.sldl
UNION ALL
select * from tiger_08.sldl
UNION ALL
select * from tiger_09.sldl
UNION ALL
select * from tiger_10.sldl
UNION ALL
select * from tiger_12.sldl
UNION ALL
select * from tiger_13.sldl
UNION ALL
select * from tiger_15.sldl
UNION ALL
select * from tiger_16.sldl
UNION ALL
select * from tiger_17.sldl
UNION ALL
select * from tiger_18.sldl
UNION ALL
select * from tiger_19.sldl
UNION ALL
select * from tiger_20.sldl
UNION ALL
select * from tiger_21.sldl
UNION ALL
select * from tiger_22.sldl
UNION ALL
select * from tiger_23.sldl
UNION ALL
select * from tiger_24.sldl
UNION ALL
select * from tiger_25.sldl
UNION ALL
select * from tiger_26.sldl
UNION ALL
select * from tiger_27.sldl
UNION ALL
select * from tiger_28.sldl
UNION ALL
select * from tiger_29.sldl
UNION ALL
select * from tiger_30.sldl
UNION ALL
select * from tiger_32.sldl
UNION ALL
select * from tiger_33.sldl
UNION ALL
select * from tiger_34.sldl
UNION ALL
select * from tiger_35.sldl
UNION ALL
select * from tiger_36.sldl
UNION ALL
select * from tiger_37.sldl
UNION ALL
select * from tiger_38.sldl
UNION ALL
select * from tiger_39.sldl
UNION ALL
select * from tiger_40.sldl
UNION ALL
select * from tiger_41.sldl
UNION ALL
select * from tiger_42.sldl
UNION ALL
select * from tiger_44.sldl
UNION ALL
select * from tiger_45.sldl
UNION ALL
select * from tiger_46.sldl
UNION ALL
select * from tiger_47.sldl
UNION ALL
select * from tiger_48.sldl
UNION ALL
select * from tiger_49.sldl
UNION ALL
select * from tiger_50.sldl
UNION ALL
select * from tiger_51.sldl
UNION ALL
select * from tiger_53.sldl
UNION ALL
select * from tiger_54.sldl
UNION ALL
select * from tiger_55.sldl
UNION ALL
select * from tiger_56.sldl
UNION ALL
select * from tiger_72.sldl
;
drop view if exists sldu;
create view sldu as
select * from tiger_01.sldu
UNION ALL
select * from tiger_02.sldu
UNION ALL
select * from tiger_04.sldu
UNION ALL
select * from tiger_05.sldu
UNION ALL
select * from tiger_06.sldu
UNION ALL
select * from tiger_08.sldu
UNION ALL
select * from tiger_09.sldu
UNION ALL
select * from tiger_10.sldu
UNION ALL
select * from tiger_11.sldu
UNION ALL
select * from tiger_12.sldu
UNION ALL
select * from tiger_13.sldu
UNION ALL
select * from tiger_15.sldu
UNION ALL
select * from tiger_16.sldu
UNION ALL
select * from tiger_17.sldu
UNION ALL
select * from tiger_18.sldu
UNION ALL
select * from tiger_19.sldu
UNION ALL
select * from tiger_20.sldu
UNION ALL
select * from tiger_21.sldu
UNION ALL
select * from tiger_22.sldu
UNION ALL
select * from tiger_23.sldu
UNION ALL
select * from tiger_24.sldu
UNION ALL
select * from tiger_25.sldu
UNION ALL
select * from tiger_26.sldu
UNION ALL
select * from tiger_27.sldu
UNION ALL
select * from tiger_28.sldu
UNION ALL
select * from tiger_29.sldu
UNION ALL
select * from tiger_30.sldu
UNION ALL
select * from tiger_31.sldu
UNION ALL
select * from tiger_32.sldu
UNION ALL
select * from tiger_33.sldu
UNION ALL
select * from tiger_34.sldu
UNION ALL
select * from tiger_35.sldu
UNION ALL
select * from tiger_36.sldu
UNION ALL
select * from tiger_37.sldu
UNION ALL
select * from tiger_38.sldu
UNION ALL
select * from tiger_39.sldu
UNION ALL
select * from tiger_40.sldu
UNION ALL
select * from tiger_41.sldu
UNION ALL
select * from tiger_42.sldu
UNION ALL
select * from tiger_44.sldu
UNION ALL
select * from tiger_45.sldu
UNION ALL
select * from tiger_46.sldu
UNION ALL
select * from tiger_47.sldu
UNION ALL
select * from tiger_48.sldu
UNION ALL
select * from tiger_49.sldu
UNION ALL
select * from tiger_50.sldu
UNION ALL
select * from tiger_51.sldu
UNION ALL
select * from tiger_53.sldu
UNION ALL
select * from tiger_54.sldu
UNION ALL
select * from tiger_55.sldu
UNION ALL
select * from tiger_56.sldu
UNION ALL
select * from tiger_72.sldu
;
drop view if exists unsd;
create view unsd as
select * from tiger_01.unsd
UNION ALL
select * from tiger_02.unsd
UNION ALL
select * from tiger_04.unsd
UNION ALL
select * from tiger_05.unsd
UNION ALL
select * from tiger_06.unsd
UNION ALL
select * from tiger_08.unsd
UNION ALL
select * from tiger_09.unsd
UNION ALL
select * from tiger_10.unsd
UNION ALL
select * from tiger_11.unsd
UNION ALL
select * from tiger_12.unsd
UNION ALL
select * from tiger_13.unsd
UNION ALL
select * from tiger_15.unsd
UNION ALL
select * from tiger_16.unsd
UNION ALL
select * from tiger_17.unsd
UNION ALL
select * from tiger_18.unsd
UNION ALL
select * from tiger_19.unsd
UNION ALL
select * from tiger_20.unsd
UNION ALL
select * from tiger_21.unsd
UNION ALL
select * from tiger_22.unsd
UNION ALL
select * from tiger_23.unsd
UNION ALL
select * from tiger_24.unsd
UNION ALL
select * from tiger_25.unsd
UNION ALL
select * from tiger_26.unsd
UNION ALL
select * from tiger_27.unsd
UNION ALL
select * from tiger_28.unsd
UNION ALL
select * from tiger_29.unsd
UNION ALL
select * from tiger_30.unsd
UNION ALL
select * from tiger_31.unsd
UNION ALL
select * from tiger_32.unsd
UNION ALL
select * from tiger_33.unsd
UNION ALL
select * from tiger_34.unsd
UNION ALL
select * from tiger_35.unsd
UNION ALL
select * from tiger_36.unsd
UNION ALL
select * from tiger_37.unsd
UNION ALL
select * from tiger_38.unsd
UNION ALL
select * from tiger_39.unsd
UNION ALL
select * from tiger_40.unsd
UNION ALL
select * from tiger_41.unsd
UNION ALL
select * from tiger_42.unsd
UNION ALL
select * from tiger_44.unsd
UNION ALL
select * from tiger_45.unsd
UNION ALL
select * from tiger_46.unsd
UNION ALL
select * from tiger_47.unsd
UNION ALL
select * from tiger_48.unsd
UNION ALL
select * from tiger_49.unsd
UNION ALL
select * from tiger_50.unsd
UNION ALL
select * from tiger_51.unsd
UNION ALL
select * from tiger_53.unsd
UNION ALL
select * from tiger_54.unsd
UNION ALL
select * from tiger_55.unsd
UNION ALL
select * from tiger_56.unsd
UNION ALL
select * from tiger_60.unsd
UNION ALL
select * from tiger_66.unsd
UNION ALL
select * from tiger_69.unsd
UNION ALL
select * from tiger_72.unsd
UNION ALL
select * from tiger_78.unsd
;
ALTER TABLE tiger_01.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('01');
ALTER TABLE tiger_02.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('02');
ALTER TABLE tiger_04.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('04');
ALTER TABLE tiger_05.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('05');
ALTER TABLE tiger_06.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('06');
ALTER TABLE tiger_08.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('08');
ALTER TABLE tiger_09.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('09');
ALTER TABLE tiger_10.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('10');
ALTER TABLE tiger_11.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('11');
ALTER TABLE tiger_12.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('12');
ALTER TABLE tiger_13.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('13');
ALTER TABLE tiger_15.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('15');
ALTER TABLE tiger_16.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('16');
ALTER TABLE tiger_17.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('17');
ALTER TABLE tiger_18.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('18');
ALTER TABLE tiger_19.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('19');
ALTER TABLE tiger_20.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('20');
ALTER TABLE tiger_21.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('21');
ALTER TABLE tiger_22.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('22');
ALTER TABLE tiger_23.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('23');
ALTER TABLE tiger_24.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('24');
ALTER TABLE tiger_25.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('25');
ALTER TABLE tiger_26.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('26');
ALTER TABLE tiger_27.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('27');
ALTER TABLE tiger_28.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('28');
ALTER TABLE tiger_29.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('29');
ALTER TABLE tiger_30.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('30');
ALTER TABLE tiger_31.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('31');
ALTER TABLE tiger_32.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('32');
ALTER TABLE tiger_33.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('33');
ALTER TABLE tiger_34.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('34');
ALTER TABLE tiger_35.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('35');
ALTER TABLE tiger_36.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('36');
ALTER TABLE tiger_37.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('37');
ALTER TABLE tiger_38.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('38');
ALTER TABLE tiger_39.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('39');
ALTER TABLE tiger_40.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('40');
ALTER TABLE tiger_41.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('41');
ALTER TABLE tiger_42.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('42');
ALTER TABLE tiger_44.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('44');
ALTER TABLE tiger_45.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('45');
ALTER TABLE tiger_46.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('46');
ALTER TABLE tiger_47.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('47');
ALTER TABLE tiger_48.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('48');
ALTER TABLE tiger_49.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('49');
ALTER TABLE tiger_50.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('50');
ALTER TABLE tiger_51.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('51');
ALTER TABLE tiger_53.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('53');
ALTER TABLE tiger_54.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('54');
ALTER TABLE tiger_55.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('55');
ALTER TABLE tiger_56.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('56');
ALTER TABLE tiger_60.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('60');
ALTER TABLE tiger_66.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('66');
ALTER TABLE tiger_69.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('69');
ALTER TABLE tiger_72.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('72');
ALTER TABLE tiger_78.addr ADD COLUMN statefp varchar(2) not null DEFAULT ('78');
;
drop view if exists addr;
create view addr as
select * tiger_01.addr
UNION ALL
select * tiger_02.addr
UNION ALL
select * tiger_04.addr
UNION ALL
select * tiger_05.addr
UNION ALL
select * tiger_06.addr
UNION ALL
select * tiger_08.addr
UNION ALL
select * tiger_09.addr
UNION ALL
select * tiger_10.addr
UNION ALL
select * tiger_11.addr
UNION ALL
select * tiger_12.addr
UNION ALL
select * tiger_13.addr
UNION ALL
select * tiger_15.addr
UNION ALL
select * tiger_16.addr
UNION ALL
select * tiger_17.addr
UNION ALL
select * tiger_18.addr
UNION ALL
select * tiger_19.addr
UNION ALL
select * tiger_20.addr
UNION ALL
select * tiger_21.addr
UNION ALL
select * tiger_22.addr
UNION ALL
select * tiger_23.addr
UNION ALL
select * tiger_24.addr
UNION ALL
select * tiger_25.addr
UNION ALL
select * tiger_26.addr
UNION ALL
select * tiger_27.addr
UNION ALL
select * tiger_28.addr
UNION ALL
select * tiger_29.addr
UNION ALL
select * tiger_30.addr
UNION ALL
select * tiger_31.addr
UNION ALL
select * tiger_32.addr
UNION ALL
select * tiger_33.addr
UNION ALL
select * tiger_34.addr
UNION ALL
select * tiger_35.addr
UNION ALL
select * tiger_36.addr
UNION ALL
select * tiger_37.addr
UNION ALL
select * tiger_38.addr
UNION ALL
select * tiger_39.addr
UNION ALL
select * tiger_40.addr
UNION ALL
select * tiger_41.addr
UNION ALL
select * tiger_42.addr
UNION ALL
select * tiger_44.addr
UNION ALL
select * tiger_45.addr
UNION ALL
select * tiger_46.addr
UNION ALL
select * tiger_47.addr
UNION ALL
select * tiger_48.addr
UNION ALL
select * tiger_49.addr
UNION ALL
select * tiger_50.addr
UNION ALL
select * tiger_51.addr
UNION ALL
select * tiger_53.addr
UNION ALL
select * tiger_54.addr
UNION ALL
select * tiger_55.addr
UNION ALL
select * tiger_56.addr
UNION ALL
select * tiger_60.addr
UNION ALL
select * tiger_66.addr
UNION ALL
select * tiger_69.addr
UNION ALL
select * tiger_72.addr
UNION ALL
select * tiger_78.addr
;
ALTER TABLE tiger_01.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('01');
ALTER TABLE tiger_02.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('02');
ALTER TABLE tiger_04.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('04');
ALTER TABLE tiger_05.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('05');
ALTER TABLE tiger_06.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('06');
ALTER TABLE tiger_08.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('08');
ALTER TABLE tiger_09.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('09');
ALTER TABLE tiger_10.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('10');
ALTER TABLE tiger_11.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('11');
ALTER TABLE tiger_12.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('12');
ALTER TABLE tiger_13.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('13');
ALTER TABLE tiger_15.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('15');
ALTER TABLE tiger_16.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('16');
ALTER TABLE tiger_17.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('17');
ALTER TABLE tiger_18.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('18');
ALTER TABLE tiger_19.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('19');
ALTER TABLE tiger_20.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('20');
ALTER TABLE tiger_21.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('21');
ALTER TABLE tiger_22.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('22');
ALTER TABLE tiger_23.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('23');
ALTER TABLE tiger_24.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('24');
ALTER TABLE tiger_25.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('25');
ALTER TABLE tiger_26.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('26');
ALTER TABLE tiger_27.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('27');
ALTER TABLE tiger_28.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('28');
ALTER TABLE tiger_29.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('29');
ALTER TABLE tiger_30.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('30');
ALTER TABLE tiger_31.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('31');
ALTER TABLE tiger_32.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('32');
ALTER TABLE tiger_33.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('33');
ALTER TABLE tiger_34.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('34');
ALTER TABLE tiger_35.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('35');
ALTER TABLE tiger_36.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('36');
ALTER TABLE tiger_37.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('37');
ALTER TABLE tiger_38.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('38');
ALTER TABLE tiger_39.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('39');
ALTER TABLE tiger_40.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('40');
ALTER TABLE tiger_41.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('41');
ALTER TABLE tiger_42.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('42');
ALTER TABLE tiger_44.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('44');
ALTER TABLE tiger_45.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('45');
ALTER TABLE tiger_46.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('46');
ALTER TABLE tiger_47.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('47');
ALTER TABLE tiger_48.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('48');
ALTER TABLE tiger_49.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('49');
ALTER TABLE tiger_50.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('50');
ALTER TABLE tiger_51.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('51');
ALTER TABLE tiger_53.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('53');
ALTER TABLE tiger_54.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('54');
ALTER TABLE tiger_55.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('55');
ALTER TABLE tiger_56.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('56');
ALTER TABLE tiger_60.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('60');
ALTER TABLE tiger_66.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('66');
ALTER TABLE tiger_69.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('69');
ALTER TABLE tiger_72.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('72');
ALTER TABLE tiger_78.addrfn ADD COLUMN statefp varchar(2) not null DEFAULT ('78');
;
drop view if exists addrfn;
create view addrfn as
select * tiger_01.addrfn
UNION ALL
select * tiger_02.addrfn
UNION ALL
select * tiger_04.addrfn
UNION ALL
select * tiger_05.addrfn
UNION ALL
select * tiger_06.addrfn
UNION ALL
select * tiger_08.addrfn
UNION ALL
select * tiger_09.addrfn
UNION ALL
select * tiger_10.addrfn
UNION ALL
select * tiger_11.addrfn
UNION ALL
select * tiger_12.addrfn
UNION ALL
select * tiger_13.addrfn
UNION ALL
select * tiger_15.addrfn
UNION ALL
select * tiger_16.addrfn
UNION ALL
select * tiger_17.addrfn
UNION ALL
select * tiger_18.addrfn
UNION ALL
select * tiger_19.addrfn
UNION ALL
select * tiger_20.addrfn
UNION ALL
select * tiger_21.addrfn
UNION ALL
select * tiger_22.addrfn
UNION ALL
select * tiger_23.addrfn
UNION ALL
select * tiger_24.addrfn
UNION ALL
select * tiger_25.addrfn
UNION ALL
select * tiger_26.addrfn
UNION ALL
select * tiger_27.addrfn
UNION ALL
select * tiger_28.addrfn
UNION ALL
select * tiger_29.addrfn
UNION ALL
select * tiger_30.addrfn
UNION ALL
select * tiger_31.addrfn
UNION ALL
select * tiger_32.addrfn
UNION ALL
select * tiger_33.addrfn
UNION ALL
select * tiger_34.addrfn
UNION ALL
select * tiger_35.addrfn
UNION ALL
select * tiger_36.addrfn
UNION ALL
select * tiger_37.addrfn
UNION ALL
select * tiger_38.addrfn
UNION ALL
select * tiger_39.addrfn
UNION ALL
select * tiger_40.addrfn
UNION ALL
select * tiger_41.addrfn
UNION ALL
select * tiger_42.addrfn
UNION ALL
select * tiger_44.addrfn
UNION ALL
select * tiger_45.addrfn
UNION ALL
select * tiger_46.addrfn
UNION ALL
select * tiger_47.addrfn
UNION ALL
select * tiger_48.addrfn
UNION ALL
select * tiger_49.addrfn
UNION ALL
select * tiger_50.addrfn
UNION ALL
select * tiger_51.addrfn
UNION ALL
select * tiger_53.addrfn
UNION ALL
select * tiger_54.addrfn
UNION ALL
select * tiger_55.addrfn
UNION ALL
select * tiger_56.addrfn
UNION ALL
select * tiger_60.addrfn
UNION ALL
select * tiger_66.addrfn
UNION ALL
select * tiger_69.addrfn
UNION ALL
select * tiger_72.addrfn
UNION ALL
select * tiger_78.addrfn
;
drop view if exists arealm;
create view arealm as
select * from tiger_01.arealm
UNION ALL
select * from tiger_02.arealm
UNION ALL
select * from tiger_04.arealm
UNION ALL
select * from tiger_05.arealm
UNION ALL
select * from tiger_06.arealm
UNION ALL
select * from tiger_08.arealm
UNION ALL
select * from tiger_09.arealm
UNION ALL
select * from tiger_10.arealm
UNION ALL
select * from tiger_11.arealm
UNION ALL
select * from tiger_12.arealm
UNION ALL
select * from tiger_13.arealm
UNION ALL
select * from tiger_15.arealm
UNION ALL
select * from tiger_16.arealm
UNION ALL
select * from tiger_17.arealm
UNION ALL
select * from tiger_18.arealm
UNION ALL
select * from tiger_19.arealm
UNION ALL
select * from tiger_20.arealm
UNION ALL
select * from tiger_21.arealm
UNION ALL
select * from tiger_22.arealm
UNION ALL
select * from tiger_23.arealm
UNION ALL
select * from tiger_24.arealm
UNION ALL
select * from tiger_25.arealm
UNION ALL
select * from tiger_26.arealm
UNION ALL
select * from tiger_27.arealm
UNION ALL
select * from tiger_28.arealm
UNION ALL
select * from tiger_29.arealm
UNION ALL
select * from tiger_30.arealm
UNION ALL
select * from tiger_31.arealm
UNION ALL
select * from tiger_32.arealm
UNION ALL
select * from tiger_33.arealm
UNION ALL
select * from tiger_34.arealm
UNION ALL
select * from tiger_35.arealm
UNION ALL
select * from tiger_36.arealm
UNION ALL
select * from tiger_37.arealm
UNION ALL
select * from tiger_38.arealm
UNION ALL
select * from tiger_39.arealm
UNION ALL
select * from tiger_40.arealm
UNION ALL
select * from tiger_41.arealm
UNION ALL
select * from tiger_42.arealm
UNION ALL
select * from tiger_44.arealm
UNION ALL
select * from tiger_45.arealm
UNION ALL
select * from tiger_46.arealm
UNION ALL
select * from tiger_47.arealm
UNION ALL
select * from tiger_48.arealm
UNION ALL
select * from tiger_49.arealm
UNION ALL
select * from tiger_50.arealm
UNION ALL
select * from tiger_51.arealm
UNION ALL
select * from tiger_53.arealm
UNION ALL
select * from tiger_54.arealm
UNION ALL
select * from tiger_55.arealm
UNION ALL
select * from tiger_56.arealm
UNION ALL
select * from tiger_60.arealm
UNION ALL
select * from tiger_66.arealm
UNION ALL
select * from tiger_69.arealm
UNION ALL
select * from tiger_72.arealm
UNION ALL
select * from tiger_78.arealm
;
drop view if exists areawater;
create view areawater as
select * from tiger_01.areawater
UNION ALL
select * from tiger_02.areawater
UNION ALL
select * from tiger_04.areawater
UNION ALL
select * from tiger_05.areawater
UNION ALL
select * from tiger_06.areawater
UNION ALL
select * from tiger_08.areawater
UNION ALL
select * from tiger_09.areawater
UNION ALL
select * from tiger_10.areawater
UNION ALL
select * from tiger_11.areawater
UNION ALL
select * from tiger_12.areawater
UNION ALL
select * from tiger_13.areawater
UNION ALL
select * from tiger_15.areawater
UNION ALL
select * from tiger_16.areawater
UNION ALL
select * from tiger_17.areawater
UNION ALL
select * from tiger_18.areawater
UNION ALL
select * from tiger_19.areawater
UNION ALL
select * from tiger_20.areawater
UNION ALL
select * from tiger_21.areawater
UNION ALL
select * from tiger_22.areawater
UNION ALL
select * from tiger_23.areawater
UNION ALL
select * from tiger_24.areawater
UNION ALL
select * from tiger_25.areawater
UNION ALL
select * from tiger_26.areawater
UNION ALL
select * from tiger_27.areawater
UNION ALL
select * from tiger_28.areawater
UNION ALL
select * from tiger_29.areawater
UNION ALL
select * from tiger_30.areawater
UNION ALL
select * from tiger_31.areawater
UNION ALL
select * from tiger_32.areawater
UNION ALL
select * from tiger_33.areawater
UNION ALL
select * from tiger_34.areawater
UNION ALL
select * from tiger_35.areawater
UNION ALL
select * from tiger_36.areawater
UNION ALL
select * from tiger_37.areawater
UNION ALL
select * from tiger_38.areawater
UNION ALL
select * from tiger_39.areawater
UNION ALL
select * from tiger_40.areawater
UNION ALL
select * from tiger_41.areawater
UNION ALL
select * from tiger_42.areawater
UNION ALL
select * from tiger_44.areawater
UNION ALL
select * from tiger_45.areawater
UNION ALL
select * from tiger_46.areawater
UNION ALL
select * from tiger_47.areawater
UNION ALL
select * from tiger_48.areawater
UNION ALL
select * from tiger_49.areawater
UNION ALL
select * from tiger_50.areawater
UNION ALL
select * from tiger_51.areawater
UNION ALL
select * from tiger_53.areawater
UNION ALL
select * from tiger_54.areawater
UNION ALL
select * from tiger_55.areawater
UNION ALL
select * from tiger_56.areawater
UNION ALL
select * from tiger_60.areawater
UNION ALL
select * from tiger_66.areawater
UNION ALL
select * from tiger_69.areawater
UNION ALL
select * from tiger_72.areawater
UNION ALL
select * from tiger_78.areawater
;
drop view if exists bg00;
create view bg00 as
select * from tiger_01.bg00
UNION ALL
select * from tiger_02.bg00
UNION ALL
select * from tiger_04.bg00
UNION ALL
select * from tiger_05.bg00
UNION ALL
select * from tiger_06.bg00
UNION ALL
select * from tiger_08.bg00
UNION ALL
select * from tiger_09.bg00
UNION ALL
select * from tiger_10.bg00
UNION ALL
select * from tiger_11.bg00
UNION ALL
select * from tiger_12.bg00
UNION ALL
select * from tiger_13.bg00
UNION ALL
select * from tiger_15.bg00
UNION ALL
select * from tiger_16.bg00
UNION ALL
select * from tiger_17.bg00
UNION ALL
select * from tiger_18.bg00
UNION ALL
select * from tiger_19.bg00
UNION ALL
select * from tiger_20.bg00
UNION ALL
select * from tiger_21.bg00
UNION ALL
select * from tiger_22.bg00
UNION ALL
select * from tiger_23.bg00
UNION ALL
select * from tiger_24.bg00
UNION ALL
select * from tiger_25.bg00
UNION ALL
select * from tiger_26.bg00
UNION ALL
select * from tiger_27.bg00
UNION ALL
select * from tiger_28.bg00
UNION ALL
select * from tiger_29.bg00
UNION ALL
select * from tiger_30.bg00
UNION ALL
select * from tiger_31.bg00
UNION ALL
select * from tiger_32.bg00
UNION ALL
select * from tiger_33.bg00
UNION ALL
select * from tiger_34.bg00
UNION ALL
select * from tiger_35.bg00
UNION ALL
select * from tiger_36.bg00
UNION ALL
select * from tiger_37.bg00
UNION ALL
select * from tiger_38.bg00
UNION ALL
select * from tiger_39.bg00
UNION ALL
select * from tiger_40.bg00
UNION ALL
select * from tiger_41.bg00
UNION ALL
select * from tiger_42.bg00
UNION ALL
select * from tiger_44.bg00
UNION ALL
select * from tiger_45.bg00
UNION ALL
select * from tiger_46.bg00
UNION ALL
select * from tiger_47.bg00
UNION ALL
select * from tiger_48.bg00
UNION ALL
select * from tiger_49.bg00
UNION ALL
select * from tiger_50.bg00
UNION ALL
select * from tiger_51.bg00
UNION ALL
select * from tiger_53.bg00
UNION ALL
select * from tiger_54.bg00
UNION ALL
select * from tiger_55.bg00
UNION ALL
select * from tiger_56.bg00
UNION ALL
select * from tiger_60.bg00
UNION ALL
select * from tiger_66.bg00
UNION ALL
select * from tiger_69.bg00
UNION ALL
select * from tiger_72.bg00
UNION ALL
select * from tiger_78.bg00
;
drop view if exists cousub;
create view cousub as
select * from tiger_01.cousub
UNION ALL
select * from tiger_02.cousub
UNION ALL
select * from tiger_04.cousub
UNION ALL
select * from tiger_05.cousub
UNION ALL
select * from tiger_06.cousub
UNION ALL
select * from tiger_08.cousub
UNION ALL
select * from tiger_09.cousub
UNION ALL
select * from tiger_10.cousub
UNION ALL
select * from tiger_11.cousub
UNION ALL
select * from tiger_12.cousub
UNION ALL
select * from tiger_13.cousub
UNION ALL
select * from tiger_15.cousub
UNION ALL
select * from tiger_16.cousub
UNION ALL
select * from tiger_17.cousub
UNION ALL
select * from tiger_18.cousub
UNION ALL
select * from tiger_19.cousub
UNION ALL
select * from tiger_20.cousub
UNION ALL
select * from tiger_21.cousub
UNION ALL
select * from tiger_22.cousub
UNION ALL
select * from tiger_23.cousub
UNION ALL
select * from tiger_24.cousub
UNION ALL
select * from tiger_25.cousub
UNION ALL
select * from tiger_26.cousub
UNION ALL
select * from tiger_27.cousub
UNION ALL
select * from tiger_28.cousub
UNION ALL
select * from tiger_29.cousub
UNION ALL
select * from tiger_30.cousub
UNION ALL
select * from tiger_31.cousub
UNION ALL
select * from tiger_32.cousub
UNION ALL
select * from tiger_33.cousub
UNION ALL
select * from tiger_34.cousub
UNION ALL
select * from tiger_35.cousub
UNION ALL
select * from tiger_36.cousub
UNION ALL
select * from tiger_37.cousub
UNION ALL
select * from tiger_38.cousub
UNION ALL
select * from tiger_39.cousub
UNION ALL
select * from tiger_40.cousub
UNION ALL
select * from tiger_41.cousub
UNION ALL
select * from tiger_42.cousub
UNION ALL
select * from tiger_44.cousub
UNION ALL
select * from tiger_45.cousub
UNION ALL
select * from tiger_46.cousub
UNION ALL
select * from tiger_47.cousub
UNION ALL
select * from tiger_48.cousub
UNION ALL
select * from tiger_49.cousub
UNION ALL
select * from tiger_50.cousub
UNION ALL
select * from tiger_51.cousub
UNION ALL
select * from tiger_53.cousub
UNION ALL
select * from tiger_54.cousub
UNION ALL
select * from tiger_55.cousub
UNION ALL
select * from tiger_56.cousub
UNION ALL
select * from tiger_60.cousub
UNION ALL
select * from tiger_66.cousub
UNION ALL
select * from tiger_69.cousub
UNION ALL
select * from tiger_72.cousub
UNION ALL
select * from tiger_78.cousub
;
drop view if exists edges;
create view edges as
select * from tiger_01.edges
UNION ALL
select * from tiger_02.edges
UNION ALL
select * from tiger_04.edges
UNION ALL
select * from tiger_05.edges
UNION ALL
select * from tiger_06.edges
UNION ALL
select * from tiger_08.edges
UNION ALL
select * from tiger_09.edges
UNION ALL
select * from tiger_10.edges
UNION ALL
select * from tiger_11.edges
UNION ALL
select * from tiger_12.edges
UNION ALL
select * from tiger_13.edges
UNION ALL
select * from tiger_15.edges
UNION ALL
select * from tiger_16.edges
UNION ALL
select * from tiger_17.edges
UNION ALL
select * from tiger_18.edges
UNION ALL
select * from tiger_19.edges
UNION ALL
select * from tiger_20.edges
UNION ALL
select * from tiger_21.edges
UNION ALL
select * from tiger_22.edges
UNION ALL
select * from tiger_23.edges
UNION ALL
select * from tiger_24.edges
UNION ALL
select * from tiger_25.edges
UNION ALL
select * from tiger_26.edges
UNION ALL
select * from tiger_27.edges
UNION ALL
select * from tiger_28.edges
UNION ALL
select * from tiger_29.edges
UNION ALL
select * from tiger_30.edges
UNION ALL
select * from tiger_31.edges
UNION ALL
select * from tiger_32.edges
UNION ALL
select * from tiger_33.edges
UNION ALL
select * from tiger_34.edges
UNION ALL
select * from tiger_35.edges
UNION ALL
select * from tiger_36.edges
UNION ALL
select * from tiger_37.edges
UNION ALL
select * from tiger_38.edges
UNION ALL
select * from tiger_39.edges
UNION ALL
select * from tiger_40.edges
UNION ALL
select * from tiger_41.edges
UNION ALL
select * from tiger_42.edges
UNION ALL
select * from tiger_44.edges
UNION ALL
select * from tiger_45.edges
UNION ALL
select * from tiger_46.edges
UNION ALL
select * from tiger_47.edges
UNION ALL
select * from tiger_48.edges
UNION ALL
select * from tiger_49.edges
UNION ALL
select * from tiger_50.edges
UNION ALL
select * from tiger_51.edges
UNION ALL
select * from tiger_53.edges
UNION ALL
select * from tiger_54.edges
UNION ALL
select * from tiger_55.edges
UNION ALL
select * from tiger_56.edges
UNION ALL
select * from tiger_60.edges
UNION ALL
select * from tiger_66.edges
UNION ALL
select * from tiger_69.edges
UNION ALL
select * from tiger_72.edges
UNION ALL
select * from tiger_78.edges
;
drop view if exists faces;
create view faces as
select * from tiger_01.faces
UNION ALL
select * from tiger_02.faces
UNION ALL
select * from tiger_04.faces
UNION ALL
select * from tiger_05.faces
UNION ALL
select * from tiger_06.faces
UNION ALL
select * from tiger_08.faces
UNION ALL
select * from tiger_09.faces
UNION ALL
select * from tiger_10.faces
UNION ALL
select * from tiger_11.faces
UNION ALL
select * from tiger_12.faces
UNION ALL
select * from tiger_13.faces
UNION ALL
select * from tiger_15.faces
UNION ALL
select * from tiger_16.faces
UNION ALL
select * from tiger_17.faces
UNION ALL
select * from tiger_18.faces
UNION ALL
select * from tiger_19.faces
UNION ALL
select * from tiger_20.faces
UNION ALL
select * from tiger_21.faces
UNION ALL
select * from tiger_22.faces
UNION ALL
select * from tiger_23.faces
UNION ALL
select * from tiger_24.faces
UNION ALL
select * from tiger_25.faces
UNION ALL
select * from tiger_26.faces
UNION ALL
select * from tiger_27.faces
UNION ALL
select * from tiger_28.faces
UNION ALL
select * from tiger_29.faces
UNION ALL
select * from tiger_30.faces
UNION ALL
select * from tiger_31.faces
UNION ALL
select * from tiger_32.faces
UNION ALL
select * from tiger_33.faces
UNION ALL
select * from tiger_34.faces
UNION ALL
select * from tiger_35.faces
UNION ALL
select * from tiger_36.faces
UNION ALL
select * from tiger_37.faces
UNION ALL
select * from tiger_38.faces
UNION ALL
select * from tiger_39.faces
UNION ALL
select * from tiger_40.faces
UNION ALL
select * from tiger_41.faces
UNION ALL
select * from tiger_42.faces
UNION ALL
select * from tiger_44.faces
UNION ALL
select * from tiger_45.faces
UNION ALL
select * from tiger_46.faces
UNION ALL
select * from tiger_47.faces
UNION ALL
select * from tiger_48.faces
UNION ALL
select * from tiger_49.faces
UNION ALL
select * from tiger_50.faces
UNION ALL
select * from tiger_51.faces
UNION ALL
select * from tiger_53.faces
UNION ALL
select * from tiger_54.faces
UNION ALL
select * from tiger_55.faces
UNION ALL
select * from tiger_56.faces
UNION ALL
select * from tiger_60.faces
UNION ALL
select * from tiger_66.faces
UNION ALL
select * from tiger_69.faces
UNION ALL
select * from tiger_72.faces
UNION ALL
select * from tiger_78.faces
;
ALTER TABLE tiger_01.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('01');
ALTER TABLE tiger_02.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('02');
ALTER TABLE tiger_04.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('04');
ALTER TABLE tiger_05.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('05');
ALTER TABLE tiger_06.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('06');
ALTER TABLE tiger_08.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('08');
ALTER TABLE tiger_09.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('09');
ALTER TABLE tiger_10.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('10');
ALTER TABLE tiger_11.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('11');
ALTER TABLE tiger_12.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('12');
ALTER TABLE tiger_13.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('13');
ALTER TABLE tiger_15.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('15');
ALTER TABLE tiger_16.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('16');
ALTER TABLE tiger_17.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('17');
ALTER TABLE tiger_18.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('18');
ALTER TABLE tiger_19.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('19');
ALTER TABLE tiger_20.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('20');
ALTER TABLE tiger_21.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('21');
ALTER TABLE tiger_22.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('22');
ALTER TABLE tiger_23.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('23');
ALTER TABLE tiger_24.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('24');
ALTER TABLE tiger_25.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('25');
ALTER TABLE tiger_26.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('26');
ALTER TABLE tiger_27.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('27');
ALTER TABLE tiger_28.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('28');
ALTER TABLE tiger_29.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('29');
ALTER TABLE tiger_30.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('30');
ALTER TABLE tiger_31.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('31');
ALTER TABLE tiger_32.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('32');
ALTER TABLE tiger_33.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('33');
ALTER TABLE tiger_34.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('34');
ALTER TABLE tiger_35.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('35');
ALTER TABLE tiger_36.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('36');
ALTER TABLE tiger_37.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('37');
ALTER TABLE tiger_38.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('38');
ALTER TABLE tiger_39.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('39');
ALTER TABLE tiger_40.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('40');
ALTER TABLE tiger_41.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('41');
ALTER TABLE tiger_42.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('42');
ALTER TABLE tiger_44.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('44');
ALTER TABLE tiger_45.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('45');
ALTER TABLE tiger_46.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('46');
ALTER TABLE tiger_47.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('47');
ALTER TABLE tiger_48.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('48');
ALTER TABLE tiger_49.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('49');
ALTER TABLE tiger_50.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('50');
ALTER TABLE tiger_51.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('51');
ALTER TABLE tiger_53.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('53');
ALTER TABLE tiger_54.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('54');
ALTER TABLE tiger_55.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('55');
ALTER TABLE tiger_56.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('56');
ALTER TABLE tiger_60.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('60');
ALTER TABLE tiger_66.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('66');
ALTER TABLE tiger_69.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('69');
ALTER TABLE tiger_72.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('72');
ALTER TABLE tiger_78.facesah ADD COLUMN statefp varchar(2) not null DEFAULT ('78');
;
drop view if exists facesah;
create view facesah as
select * tiger_01.facesah
UNION ALL
select * tiger_02.facesah
UNION ALL
select * tiger_04.facesah
UNION ALL
select * tiger_05.facesah
UNION ALL
select * tiger_06.facesah
UNION ALL
select * tiger_08.facesah
UNION ALL
select * tiger_09.facesah
UNION ALL
select * tiger_10.facesah
UNION ALL
select * tiger_11.facesah
UNION ALL
select * tiger_12.facesah
UNION ALL
select * tiger_13.facesah
UNION ALL
select * tiger_15.facesah
UNION ALL
select * tiger_16.facesah
UNION ALL
select * tiger_17.facesah
UNION ALL
select * tiger_18.facesah
UNION ALL
select * tiger_19.facesah
UNION ALL
select * tiger_20.facesah
UNION ALL
select * tiger_21.facesah
UNION ALL
select * tiger_22.facesah
UNION ALL
select * tiger_23.facesah
UNION ALL
select * tiger_24.facesah
UNION ALL
select * tiger_25.facesah
UNION ALL
select * tiger_26.facesah
UNION ALL
select * tiger_27.facesah
UNION ALL
select * tiger_28.facesah
UNION ALL
select * tiger_29.facesah
UNION ALL
select * tiger_30.facesah
UNION ALL
select * tiger_31.facesah
UNION ALL
select * tiger_32.facesah
UNION ALL
select * tiger_33.facesah
UNION ALL
select * tiger_34.facesah
UNION ALL
select * tiger_35.facesah
UNION ALL
select * tiger_36.facesah
UNION ALL
select * tiger_37.facesah
UNION ALL
select * tiger_38.facesah
UNION ALL
select * tiger_39.facesah
UNION ALL
select * tiger_40.facesah
UNION ALL
select * tiger_41.facesah
UNION ALL
select * tiger_42.facesah
UNION ALL
select * tiger_44.facesah
UNION ALL
select * tiger_45.facesah
UNION ALL
select * tiger_46.facesah
UNION ALL
select * tiger_47.facesah
UNION ALL
select * tiger_48.facesah
UNION ALL
select * tiger_49.facesah
UNION ALL
select * tiger_50.facesah
UNION ALL
select * tiger_51.facesah
UNION ALL
select * tiger_53.facesah
UNION ALL
select * tiger_54.facesah
UNION ALL
select * tiger_55.facesah
UNION ALL
select * tiger_56.facesah
UNION ALL
select * tiger_60.facesah
UNION ALL
select * tiger_66.facesah
UNION ALL
select * tiger_69.facesah
UNION ALL
select * tiger_72.facesah
UNION ALL
select * tiger_78.facesah
;
ALTER TABLE tiger_01.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('01');
ALTER TABLE tiger_02.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('02');
ALTER TABLE tiger_04.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('04');
ALTER TABLE tiger_05.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('05');
ALTER TABLE tiger_06.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('06');
ALTER TABLE tiger_08.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('08');
ALTER TABLE tiger_09.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('09');
ALTER TABLE tiger_10.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('10');
ALTER TABLE tiger_11.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('11');
ALTER TABLE tiger_12.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('12');
ALTER TABLE tiger_13.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('13');
ALTER TABLE tiger_15.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('15');
ALTER TABLE tiger_16.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('16');
ALTER TABLE tiger_17.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('17');
ALTER TABLE tiger_18.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('18');
ALTER TABLE tiger_19.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('19');
ALTER TABLE tiger_20.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('20');
ALTER TABLE tiger_21.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('21');
ALTER TABLE tiger_22.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('22');
ALTER TABLE tiger_23.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('23');
ALTER TABLE tiger_24.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('24');
ALTER TABLE tiger_25.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('25');
ALTER TABLE tiger_26.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('26');
ALTER TABLE tiger_27.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('27');
ALTER TABLE tiger_28.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('28');
ALTER TABLE tiger_29.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('29');
ALTER TABLE tiger_30.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('30');
ALTER TABLE tiger_31.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('31');
ALTER TABLE tiger_32.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('32');
ALTER TABLE tiger_33.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('33');
ALTER TABLE tiger_34.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('34');
ALTER TABLE tiger_35.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('35');
ALTER TABLE tiger_36.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('36');
ALTER TABLE tiger_37.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('37');
ALTER TABLE tiger_38.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('38');
ALTER TABLE tiger_39.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('39');
ALTER TABLE tiger_40.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('40');
ALTER TABLE tiger_41.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('41');
ALTER TABLE tiger_42.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('42');
ALTER TABLE tiger_44.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('44');
ALTER TABLE tiger_45.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('45');
ALTER TABLE tiger_46.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('46');
ALTER TABLE tiger_47.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('47');
ALTER TABLE tiger_48.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('48');
ALTER TABLE tiger_49.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('49');
ALTER TABLE tiger_50.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('50');
ALTER TABLE tiger_51.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('51');
ALTER TABLE tiger_53.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('53');
ALTER TABLE tiger_54.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('54');
ALTER TABLE tiger_55.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('55');
ALTER TABLE tiger_56.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('56');
ALTER TABLE tiger_60.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('60');
ALTER TABLE tiger_66.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('66');
ALTER TABLE tiger_69.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('69');
ALTER TABLE tiger_72.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('72');
ALTER TABLE tiger_78.facesal ADD COLUMN statefp varchar(2) not null DEFAULT ('78');
;
drop view if exists facesal;
create view facesal as
select * tiger_01.facesal
UNION ALL
select * tiger_02.facesal
UNION ALL
select * tiger_04.facesal
UNION ALL
select * tiger_05.facesal
UNION ALL
select * tiger_06.facesal
UNION ALL
select * tiger_08.facesal
UNION ALL
select * tiger_09.facesal
UNION ALL
select * tiger_10.facesal
UNION ALL
select * tiger_11.facesal
UNION ALL
select * tiger_12.facesal
UNION ALL
select * tiger_13.facesal
UNION ALL
select * tiger_15.facesal
UNION ALL
select * tiger_16.facesal
UNION ALL
select * tiger_17.facesal
UNION ALL
select * tiger_18.facesal
UNION ALL
select * tiger_19.facesal
UNION ALL
select * tiger_20.facesal
UNION ALL
select * tiger_21.facesal
UNION ALL
select * tiger_22.facesal
UNION ALL
select * tiger_23.facesal
UNION ALL
select * tiger_24.facesal
UNION ALL
select * tiger_25.facesal
UNION ALL
select * tiger_26.facesal
UNION ALL
select * tiger_27.facesal
UNION ALL
select * tiger_28.facesal
UNION ALL
select * tiger_29.facesal
UNION ALL
select * tiger_30.facesal
UNION ALL
select * tiger_31.facesal
UNION ALL
select * tiger_32.facesal
UNION ALL
select * tiger_33.facesal
UNION ALL
select * tiger_34.facesal
UNION ALL
select * tiger_35.facesal
UNION ALL
select * tiger_36.facesal
UNION ALL
select * tiger_37.facesal
UNION ALL
select * tiger_38.facesal
UNION ALL
select * tiger_39.facesal
UNION ALL
select * tiger_40.facesal
UNION ALL
select * tiger_41.facesal
UNION ALL
select * tiger_42.facesal
UNION ALL
select * tiger_44.facesal
UNION ALL
select * tiger_45.facesal
UNION ALL
select * tiger_46.facesal
UNION ALL
select * tiger_47.facesal
UNION ALL
select * tiger_48.facesal
UNION ALL
select * tiger_49.facesal
UNION ALL
select * tiger_50.facesal
UNION ALL
select * tiger_51.facesal
UNION ALL
select * tiger_53.facesal
UNION ALL
select * tiger_54.facesal
UNION ALL
select * tiger_55.facesal
UNION ALL
select * tiger_56.facesal
UNION ALL
select * tiger_60.facesal
UNION ALL
select * tiger_66.facesal
UNION ALL
select * tiger_69.facesal
UNION ALL
select * tiger_72.facesal
UNION ALL
select * tiger_78.facesal
;
ALTER TABLE tiger_01.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('01');
ALTER TABLE tiger_02.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('02');
ALTER TABLE tiger_04.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('04');
ALTER TABLE tiger_05.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('05');
ALTER TABLE tiger_06.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('06');
ALTER TABLE tiger_08.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('08');
ALTER TABLE tiger_09.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('09');
ALTER TABLE tiger_10.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('10');
ALTER TABLE tiger_11.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('11');
ALTER TABLE tiger_12.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('12');
ALTER TABLE tiger_13.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('13');
ALTER TABLE tiger_15.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('15');
ALTER TABLE tiger_16.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('16');
ALTER TABLE tiger_17.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('17');
ALTER TABLE tiger_18.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('18');
ALTER TABLE tiger_19.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('19');
ALTER TABLE tiger_20.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('20');
ALTER TABLE tiger_21.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('21');
ALTER TABLE tiger_22.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('22');
ALTER TABLE tiger_23.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('23');
ALTER TABLE tiger_24.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('24');
ALTER TABLE tiger_25.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('25');
ALTER TABLE tiger_26.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('26');
ALTER TABLE tiger_27.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('27');
ALTER TABLE tiger_28.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('28');
ALTER TABLE tiger_29.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('29');
ALTER TABLE tiger_30.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('30');
ALTER TABLE tiger_31.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('31');
ALTER TABLE tiger_32.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('32');
ALTER TABLE tiger_33.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('33');
ALTER TABLE tiger_34.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('34');
ALTER TABLE tiger_35.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('35');
ALTER TABLE tiger_36.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('36');
ALTER TABLE tiger_37.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('37');
ALTER TABLE tiger_38.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('38');
ALTER TABLE tiger_39.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('39');
ALTER TABLE tiger_40.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('40');
ALTER TABLE tiger_41.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('41');
ALTER TABLE tiger_42.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('42');
ALTER TABLE tiger_44.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('44');
ALTER TABLE tiger_45.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('45');
ALTER TABLE tiger_46.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('46');
ALTER TABLE tiger_47.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('47');
ALTER TABLE tiger_48.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('48');
ALTER TABLE tiger_49.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('49');
ALTER TABLE tiger_50.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('50');
ALTER TABLE tiger_51.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('51');
ALTER TABLE tiger_53.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('53');
ALTER TABLE tiger_54.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('54');
ALTER TABLE tiger_55.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('55');
ALTER TABLE tiger_56.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('56');
ALTER TABLE tiger_60.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('60');
ALTER TABLE tiger_66.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('66');
ALTER TABLE tiger_69.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('69');
ALTER TABLE tiger_72.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('72');
ALTER TABLE tiger_78.featnames ADD COLUMN statefp varchar(2) not null DEFAULT ('78');
;
drop view if exists featnames;
create view featnames as
select * tiger_01.featnames
UNION ALL
select * tiger_02.featnames
UNION ALL
select * tiger_04.featnames
UNION ALL
select * tiger_05.featnames
UNION ALL
select * tiger_06.featnames
UNION ALL
select * tiger_08.featnames
UNION ALL
select * tiger_09.featnames
UNION ALL
select * tiger_10.featnames
UNION ALL
select * tiger_11.featnames
UNION ALL
select * tiger_12.featnames
UNION ALL
select * tiger_13.featnames
UNION ALL
select * tiger_15.featnames
UNION ALL
select * tiger_16.featnames
UNION ALL
select * tiger_17.featnames
UNION ALL
select * tiger_18.featnames
UNION ALL
select * tiger_19.featnames
UNION ALL
select * tiger_20.featnames
UNION ALL
select * tiger_21.featnames
UNION ALL
select * tiger_22.featnames
UNION ALL
select * tiger_23.featnames
UNION ALL
select * tiger_24.featnames
UNION ALL
select * tiger_25.featnames
UNION ALL
select * tiger_26.featnames
UNION ALL
select * tiger_27.featnames
UNION ALL
select * tiger_28.featnames
UNION ALL
select * tiger_29.featnames
UNION ALL
select * tiger_30.featnames
UNION ALL
select * tiger_31.featnames
UNION ALL
select * tiger_32.featnames
UNION ALL
select * tiger_33.featnames
UNION ALL
select * tiger_34.featnames
UNION ALL
select * tiger_35.featnames
UNION ALL
select * tiger_36.featnames
UNION ALL
select * tiger_37.featnames
UNION ALL
select * tiger_38.featnames
UNION ALL
select * tiger_39.featnames
UNION ALL
select * tiger_40.featnames
UNION ALL
select * tiger_41.featnames
UNION ALL
select * tiger_42.featnames
UNION ALL
select * tiger_44.featnames
UNION ALL
select * tiger_45.featnames
UNION ALL
select * tiger_46.featnames
UNION ALL
select * tiger_47.featnames
UNION ALL
select * tiger_48.featnames
UNION ALL
select * tiger_49.featnames
UNION ALL
select * tiger_50.featnames
UNION ALL
select * tiger_51.featnames
UNION ALL
select * tiger_53.featnames
UNION ALL
select * tiger_54.featnames
UNION ALL
select * tiger_55.featnames
UNION ALL
select * tiger_56.featnames
UNION ALL
select * tiger_60.featnames
UNION ALL
select * tiger_66.featnames
UNION ALL
select * tiger_69.featnames
UNION ALL
select * tiger_72.featnames
UNION ALL
select * tiger_78.featnames
;
drop view if exists pointlm;
create view pointlm as
select * from tiger_01.pointlm
UNION ALL
select * from tiger_02.pointlm
UNION ALL
select * from tiger_04.pointlm
UNION ALL
select * from tiger_05.pointlm
UNION ALL
select * from tiger_06.pointlm
UNION ALL
select * from tiger_08.pointlm
UNION ALL
select * from tiger_09.pointlm
UNION ALL
select * from tiger_10.pointlm
UNION ALL
select * from tiger_11.pointlm
UNION ALL
select * from tiger_12.pointlm
UNION ALL
select * from tiger_13.pointlm
UNION ALL
select * from tiger_15.pointlm
UNION ALL
select * from tiger_16.pointlm
UNION ALL
select * from tiger_17.pointlm
UNION ALL
select * from tiger_18.pointlm
UNION ALL
select * from tiger_19.pointlm
UNION ALL
select * from tiger_20.pointlm
UNION ALL
select * from tiger_21.pointlm
UNION ALL
select * from tiger_22.pointlm
UNION ALL
select * from tiger_23.pointlm
UNION ALL
select * from tiger_24.pointlm
UNION ALL
select * from tiger_25.pointlm
UNION ALL
select * from tiger_26.pointlm
UNION ALL
select * from tiger_27.pointlm
UNION ALL
select * from tiger_28.pointlm
UNION ALL
select * from tiger_29.pointlm
UNION ALL
select * from tiger_30.pointlm
UNION ALL
select * from tiger_31.pointlm
UNION ALL
select * from tiger_32.pointlm
UNION ALL
select * from tiger_33.pointlm
UNION ALL
select * from tiger_34.pointlm
UNION ALL
select * from tiger_35.pointlm
UNION ALL
select * from tiger_36.pointlm
UNION ALL
select * from tiger_37.pointlm
UNION ALL
select * from tiger_38.pointlm
UNION ALL
select * from tiger_39.pointlm
UNION ALL
select * from tiger_40.pointlm
UNION ALL
select * from tiger_41.pointlm
UNION ALL
select * from tiger_42.pointlm
UNION ALL
select * from tiger_44.pointlm
UNION ALL
select * from tiger_45.pointlm
UNION ALL
select * from tiger_46.pointlm
UNION ALL
select * from tiger_47.pointlm
UNION ALL
select * from tiger_48.pointlm
UNION ALL
select * from tiger_49.pointlm
UNION ALL
select * from tiger_50.pointlm
UNION ALL
select * from tiger_51.pointlm
UNION ALL
select * from tiger_53.pointlm
UNION ALL
select * from tiger_54.pointlm
UNION ALL
select * from tiger_55.pointlm
UNION ALL
select * from tiger_56.pointlm
UNION ALL
select * from tiger_60.pointlm
UNION ALL
select * from tiger_66.pointlm
UNION ALL
select * from tiger_69.pointlm
UNION ALL
select * from tiger_72.pointlm
UNION ALL
select * from tiger_78.pointlm
;
drop view if exists tabblock;
create view tabblock as
select * from tiger_01.tabblock
UNION ALL
select * from tiger_02.tabblock
UNION ALL
select * from tiger_04.tabblock
UNION ALL
select * from tiger_05.tabblock
UNION ALL
select * from tiger_06.tabblock
UNION ALL
select * from tiger_08.tabblock
UNION ALL
select * from tiger_09.tabblock
UNION ALL
select * from tiger_10.tabblock
UNION ALL
select * from tiger_11.tabblock
UNION ALL
select * from tiger_12.tabblock
UNION ALL
select * from tiger_13.tabblock
UNION ALL
select * from tiger_15.tabblock
UNION ALL
select * from tiger_16.tabblock
UNION ALL
select * from tiger_17.tabblock
UNION ALL
select * from tiger_18.tabblock
UNION ALL
select * from tiger_19.tabblock
UNION ALL
select * from tiger_20.tabblock
UNION ALL
select * from tiger_21.tabblock
UNION ALL
select * from tiger_22.tabblock
UNION ALL
select * from tiger_23.tabblock
UNION ALL
select * from tiger_24.tabblock
UNION ALL
select * from tiger_25.tabblock
UNION ALL
select * from tiger_26.tabblock
UNION ALL
select * from tiger_27.tabblock
UNION ALL
select * from tiger_28.tabblock
UNION ALL
select * from tiger_29.tabblock
UNION ALL
select * from tiger_30.tabblock
UNION ALL
select * from tiger_31.tabblock
UNION ALL
select * from tiger_32.tabblock
UNION ALL
select * from tiger_33.tabblock
UNION ALL
select * from tiger_34.tabblock
UNION ALL
select * from tiger_35.tabblock
UNION ALL
select * from tiger_36.tabblock
UNION ALL
select * from tiger_37.tabblock
UNION ALL
select * from tiger_38.tabblock
UNION ALL
select * from tiger_39.tabblock
UNION ALL
select * from tiger_40.tabblock
UNION ALL
select * from tiger_41.tabblock
UNION ALL
select * from tiger_42.tabblock
UNION ALL
select * from tiger_44.tabblock
UNION ALL
select * from tiger_45.tabblock
UNION ALL
select * from tiger_46.tabblock
UNION ALL
select * from tiger_47.tabblock
UNION ALL
select * from tiger_48.tabblock
UNION ALL
select * from tiger_49.tabblock
UNION ALL
select * from tiger_50.tabblock
UNION ALL
select * from tiger_51.tabblock
UNION ALL
select * from tiger_53.tabblock
UNION ALL
select * from tiger_54.tabblock
UNION ALL
select * from tiger_55.tabblock
UNION ALL
select * from tiger_56.tabblock
UNION ALL
select * from tiger_60.tabblock
UNION ALL
select * from tiger_66.tabblock
UNION ALL
select * from tiger_69.tabblock
UNION ALL
select * from tiger_72.tabblock
UNION ALL
select * from tiger_78.tabblock
;
drop view if exists tract00;
create view tract00 as
select * from tiger_01.tract00
UNION ALL
select * from tiger_02.tract00
UNION ALL
select * from tiger_04.tract00
UNION ALL
select * from tiger_05.tract00
UNION ALL
select * from tiger_06.tract00
UNION ALL
select * from tiger_08.tract00
UNION ALL
select * from tiger_09.tract00
UNION ALL
select * from tiger_10.tract00
UNION ALL
select * from tiger_11.tract00
UNION ALL
select * from tiger_12.tract00
UNION ALL
select * from tiger_13.tract00
UNION ALL
select * from tiger_15.tract00
UNION ALL
select * from tiger_16.tract00
UNION ALL
select * from tiger_17.tract00
UNION ALL
select * from tiger_18.tract00
UNION ALL
select * from tiger_19.tract00
UNION ALL
select * from tiger_20.tract00
UNION ALL
select * from tiger_21.tract00
UNION ALL
select * from tiger_22.tract00
UNION ALL
select * from tiger_23.tract00
UNION ALL
select * from tiger_24.tract00
UNION ALL
select * from tiger_25.tract00
UNION ALL
select * from tiger_26.tract00
UNION ALL
select * from tiger_27.tract00
UNION ALL
select * from tiger_28.tract00
UNION ALL
select * from tiger_29.tract00
UNION ALL
select * from tiger_30.tract00
UNION ALL
select * from tiger_31.tract00
UNION ALL
select * from tiger_32.tract00
UNION ALL
select * from tiger_33.tract00
UNION ALL
select * from tiger_34.tract00
UNION ALL
select * from tiger_35.tract00
UNION ALL
select * from tiger_36.tract00
UNION ALL
select * from tiger_37.tract00
UNION ALL
select * from tiger_38.tract00
UNION ALL
select * from tiger_39.tract00
UNION ALL
select * from tiger_40.tract00
UNION ALL
select * from tiger_41.tract00
UNION ALL
select * from tiger_42.tract00
UNION ALL
select * from tiger_44.tract00
UNION ALL
select * from tiger_45.tract00
UNION ALL
select * from tiger_46.tract00
UNION ALL
select * from tiger_47.tract00
UNION ALL
select * from tiger_48.tract00
UNION ALL
select * from tiger_49.tract00
UNION ALL
select * from tiger_50.tract00
UNION ALL
select * from tiger_51.tract00
UNION ALL
select * from tiger_53.tract00
UNION ALL
select * from tiger_54.tract00
UNION ALL
select * from tiger_55.tract00
UNION ALL
select * from tiger_56.tract00
UNION ALL
select * from tiger_60.tract00
UNION ALL
select * from tiger_66.tract00
UNION ALL
select * from tiger_69.tract00
UNION ALL
select * from tiger_72.tract00
UNION ALL
select * from tiger_78.tract00
;
drop view if exists vtd00;
create view vtd00 as
select * from tiger_01.vtd00
UNION ALL
select * from tiger_02.vtd00
UNION ALL
select * from tiger_04.vtd00
UNION ALL
select * from tiger_05.vtd00
UNION ALL
select * from tiger_06.vtd00
UNION ALL
select * from tiger_08.vtd00
UNION ALL
select * from tiger_09.vtd00
UNION ALL
select * from tiger_10.vtd00
UNION ALL
select * from tiger_11.vtd00
UNION ALL
select * from tiger_12.vtd00
UNION ALL
select * from tiger_13.vtd00
UNION ALL
select * from tiger_15.vtd00
UNION ALL
select * from tiger_16.vtd00
UNION ALL
select * from tiger_17.vtd00
UNION ALL
select * from tiger_18.vtd00
UNION ALL
select * from tiger_19.vtd00
UNION ALL
select * from tiger_20.vtd00
UNION ALL
select * from tiger_21.vtd00
UNION ALL
select * from tiger_22.vtd00
UNION ALL
select * from tiger_23.vtd00
UNION ALL
select * from tiger_24.vtd00
UNION ALL
select * from tiger_25.vtd00
UNION ALL
select * from tiger_26.vtd00
UNION ALL
select * from tiger_27.vtd00
UNION ALL
select * from tiger_28.vtd00
UNION ALL
select * from tiger_29.vtd00
UNION ALL
select * from tiger_30.vtd00
UNION ALL
select * from tiger_31.vtd00
UNION ALL
select * from tiger_32.vtd00
UNION ALL
select * from tiger_33.vtd00
UNION ALL
select * from tiger_34.vtd00
UNION ALL
select * from tiger_35.vtd00
UNION ALL
select * from tiger_36.vtd00
UNION ALL
select * from tiger_37.vtd00
UNION ALL
select * from tiger_38.vtd00
UNION ALL
select * from tiger_39.vtd00
UNION ALL
select * from tiger_40.vtd00
UNION ALL
select * from tiger_41.vtd00
UNION ALL
select * from tiger_42.vtd00
UNION ALL
select * from tiger_44.vtd00
UNION ALL
select * from tiger_45.vtd00
UNION ALL
select * from tiger_46.vtd00
UNION ALL
select * from tiger_47.vtd00
UNION ALL
select * from tiger_48.vtd00
UNION ALL
select * from tiger_49.vtd00
UNION ALL
select * from tiger_50.vtd00
UNION ALL
select * from tiger_51.vtd00
UNION ALL
select * from tiger_53.vtd00
UNION ALL
select * from tiger_54.vtd00
UNION ALL
select * from tiger_55.vtd00
UNION ALL
select * from tiger_56.vtd00
UNION ALL
select * from tiger_60.vtd00
UNION ALL
select * from tiger_66.vtd00
UNION ALL
select * from tiger_69.vtd00
UNION ALL
select * from tiger_72.vtd00
UNION ALL
select * from tiger_78.vtd00
;