Revision 8110
Added by Aaron Marcuse-Kubitza almost 12 years ago
| inputs/FIA/PLOT/postprocess.sql | ||
|---|---|---|
| 6 | 6 |
SELECT functions.rename_if_exists($$ALTER TABLE "PLOT" RENAME "PLOT.PLOT" TO ".PLOT" $$); |
| 7 | 7 |
SELECT functions.rename_if_exists($$ALTER TABLE "PLOT" RENAME "PLOT.INVYR" TO ".INVYR" $$); |
| 8 | 8 |
|
| 9 |
SELECT functions.set_col_types(:table_str, ARRAY[ |
|
| 10 |
('.STATECD' , 'integer')
|
|
| 11 |
, ('.UNITCD' , 'integer')
|
|
| 12 |
, ('.COUNTYCD', 'integer')
|
|
| 13 |
, ('.PLOT' , 'integer')
|
|
| 14 |
, ('.INVYR' , 'integer')
|
|
| 15 |
]::functions.col_cast[]); |
|
| 16 |
|
|
| 9 | 17 |
SELECT functions.create_if_not_exists($$ALTER TABLE "PLOT" ADD CONSTRAINT "PLOT.unique" UNIQUE (".STATECD", ".UNITCD", ".COUNTYCD", ".PLOT", ".INVYR")$$);
|
| inputs/FIA/COND/postprocess.sql | ||
|---|---|---|
| 7 | 7 |
SELECT functions.rename_if_exists($$ALTER TABLE "COND" RENAME "COND.INVYR" TO ".INVYR" $$); |
| 8 | 8 |
SELECT functions.rename_if_exists($$ALTER TABLE "COND" RENAME "COND.CONDID" TO ".CONDID" $$); |
| 9 | 9 |
|
| 10 |
SELECT functions.set_col_types(:table_str, ARRAY[ |
|
| 11 |
('.STATECD' , 'integer')
|
|
| 12 |
, ('.UNITCD' , 'integer')
|
|
| 13 |
, ('.COUNTYCD', 'integer')
|
|
| 14 |
, ('.PLOT' , 'integer')
|
|
| 15 |
, ('.INVYR' , 'integer')
|
|
| 16 |
, ('.CONDID' , 'integer')
|
|
| 17 |
]::functions.col_cast[]); |
|
| 18 |
|
|
| 10 | 19 |
SELECT functions.create_if_not_exists($$ |
| 11 | 20 |
ALTER TABLE "COND" ADD COLUMN "COND.oldgrowth" boolean; |
| 12 | 21 |
ALTER TABLE "COND" ALTER COLUMN "COND.oldgrowth" TYPE boolean USING |
| inputs/FIA/TREE/postprocess.sql | ||
|---|---|---|
| 9 | 9 |
SELECT functions.rename_if_exists($$ALTER TABLE "TREE" RENAME "TREE.SUBP" TO ".SUBP" $$); |
| 10 | 10 |
SELECT functions.rename_if_exists($$ALTER TABLE "TREE" RENAME "TREE.SPCD" TO ".SPCD" $$); |
| 11 | 11 |
|
| 12 |
SELECT functions.set_col_types(:table_str, ARRAY[ |
|
| 13 |
('.STATECD' , 'integer')
|
|
| 14 |
, ('.UNITCD' , 'integer')
|
|
| 15 |
, ('.COUNTYCD', 'integer')
|
|
| 16 |
, ('.PLOT' , 'integer')
|
|
| 17 |
, ('.INVYR' , 'integer')
|
|
| 18 |
, ('.SUBP' , 'integer')
|
|
| 19 |
, ('.CONDID' , 'integer')
|
|
| 20 |
, ('.SPCD' , 'integer')
|
|
| 21 |
]::functions.col_cast[]); |
|
| 22 |
|
|
| 12 | 23 |
-- ("STATECD", "UNITCD", "COUNTYCD", "PLOT", "INVYR", "CONDID", "SUBP", "TREE", "STATUSCD") is not unique
|
| 13 | 24 |
SELECT functions.create_if_not_exists($$ALTER TABLE "TREE" ADD CONSTRAINT "TREE.unique" UNIQUE ("TREE.CN")$$);
|
| 14 | 25 |
|
| inputs/FIA/SUBPLOT/postprocess.sql | ||
|---|---|---|
| 7 | 7 |
SELECT functions.rename_if_exists($$ALTER TABLE "SUBPLOT" RENAME "SUBPLOT.INVYR" TO ".INVYR" $$); |
| 8 | 8 |
SELECT functions.rename_if_exists($$ALTER TABLE "SUBPLOT" RENAME "SUBPLOT.SUBP" TO ".SUBP" $$); |
| 9 | 9 |
|
| 10 |
SELECT functions.set_col_types(:table_str, ARRAY[ |
|
| 11 |
('.STATECD' , 'integer')
|
|
| 12 |
, ('.UNITCD' , 'integer')
|
|
| 13 |
, ('.COUNTYCD', 'integer')
|
|
| 14 |
, ('.PLOT' , 'integer')
|
|
| 15 |
, ('.INVYR' , 'integer')
|
|
| 16 |
, ('.SUBP' , 'integer')
|
|
| 17 |
]::functions.col_cast[]); |
|
| 18 |
|
|
| 10 | 19 |
SELECT functions.create_if_not_exists($$ALTER TABLE "SUBPLOT" ADD CONSTRAINT "SUBPLOT.unique" UNIQUE (".STATECD", ".UNITCD", ".COUNTYCD", ".PLOT", ".INVYR", ".SUBP")$$);
|
Also available in: Unified diff
inputs/FIA/*/postprocess.sql: Cast ID columns to integer using new functions.set_col_types()