Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
---|---|---|---|---|---|---|---|---|---|---|---|
geom | geometry | 2147483647 | √ | null |
|
|
|||||
OBSID1 | text | 2147483647 | √ | null |
|
|
|||||
OBSID2 | text | 2147483647 | √ | null |
|
|
|||||
LABID | text | 2147483647 | √ | null |
|
|
|||||
LAB_FACLTY | text | 2147483647 | √ | null |
|
|
|||||
IGSNID | text | 2147483647 | √ | null |
|
|
|||||
DBDOI | varchar | 256 | √ | null |
|
|
|||||
DBVERNO | text | 2147483647 | √ | null |
|
|
|||||
SMPID | text | 2147483647 | √ | null |
|
|
|||||
SITEID | text | 2147483647 | √ | null |
|
|
|||||
METASITEID | text | 2147483647 | √ | null |
|
|
|||||
METANAME | text | 2147483647 | √ | null |
|
|
|||||
METHODABBR | text | 2147483647 | √ | null |
|
|
|||||
CNTRY | varchar | 2147483647 | √ | null |
|
|
|||||
REGION_INT | text | 2147483647 | √ | null |
|
|
|||||
REGION_REG | varchar | 2147483647 | √ | null |
|
|
|||||
DIV_ADMIN | varchar | 2147483647 | √ | null |
|
|
|||||
DIV_OTHER | text | 2147483647 | √ | null |
|
|
|||||
ISL_NAME | text | 2147483647 | √ | null |
|
|
|||||
LAKE | text | 2147483647 | √ | null |
|
|
|||||
BASIN | text | 2147483647 | √ | null |
|
|
|||||
AHGFL1 | varchar | 3 | √ | null |
|
|
|||||
AHGFL2 | varchar | 6 | √ | null |
|
|
|||||
RIVNAME | text | 2147483647 | √ | null |
|
|
|||||
RIVDIV | text | 2147483647 | √ | null |
|
|
|||||
IBRACODE | varchar | 3 | √ | null |
|
|
|||||
IBRAREGION | text | 2147483647 | √ | null |
|
|
|||||
CORDS_ELEV | varchar | 2147483647 | √ | null |
|
|
|||||
ELEVATION | numeric | 6,2 | √ | null |
|
|
|||||
SITENAME | text | 2147483647 | √ | null |
|
|
|||||
SITE_SPEC | text | 2147483647 | √ | null |
|
|
|||||
ALTNAME1 | text | 2147483647 | √ | null |
|
|
|||||
ALTNAME2 | text | 2147483647 | √ | null |
|
|
|||||
ALTNAME3 | text | 2147483647 | √ | null |
|
|
|||||
SITECODE | text | 2147483647 | √ | null |
|
|
|||||
OPENCLOSED | varchar | 2147483647 | √ | null |
|
|
|||||
SITE_COMMT | text | 2147483647 | √ | null |
|
|
|||||
REFDBID1 | text | 2147483647 | √ | null |
|
|
|||||
OAID1 | varchar | 11 | √ | null |
|
|
|||||
AUTHOR1 | text | 2147483647 | √ | null |
|
|
|||||
PUBYEAR1 | int2 | 5 | √ | null |
|
|
|||||
REFID1 | text | 2147483647 | √ | null |
|
|
|||||
REFDOI1 | text | 2147483647 | √ | null |
|
|
|||||
REFDBID2 | text | 2147483647 | √ | null |
|
|
|||||
OAID2 | varchar | 11 | √ | null |
|
|
|||||
AUTHOR2 | text | 2147483647 | √ | null |
|
|
|||||
PUBYEAR2 | int2 | 5 | √ | null |
|
|
|||||
REFID2 | text | 2147483647 | √ | null |
|
|
|||||
REFDOI2 | text | 2147483647 | √ | null |
|
|
|||||
REFDBID3 | text | 2147483647 | √ | null |
|
|
|||||
OAID3 | varchar | 11 | √ | null |
|
|
|||||
AUTHOR3 | text | 2147483647 | √ | null |
|
|
|||||
PUBYEAR3 | int2 | 5 | √ | null |
|
|
|||||
REFID3 | text | 2147483647 | √ | null |
|
|
|||||
REFDOI3 | text | 2147483647 | √ | null |
|
|
|||||
REFDBID4 | text | 2147483647 | √ | null |
|
|
|||||
OAID4 | varchar | 11 | √ | null |
|
|
|||||
AUTHOR4 | text | 2147483647 | √ | null |
|
|
|||||
PUBYEAR4 | int2 | 5 | √ | null |
|
|
|||||
REFID4 | text | 2147483647 | √ | null |
|
|
|||||
REFDOI4 | text | 2147483647 | √ | null |
|
|
|||||
FEATDATED | text | 2147483647 | √ | null |
|
|
|||||
SQUARE | text | 2147483647 | √ | null |
|
|
|||||
XU | text | 2147483647 | √ | null |
|
|
|||||
SMPDEPTH | numeric | 9,2 | √ | null |
|
|
|||||
OCCUPATION | varchar | 3 | √ | null |
|
|
|||||
CONTEXT | varchar | 10 | √ | null |
|
|
|||||
SMP_COMMT | text | 2147483647 | √ | null |
|
|
|||||
COL_MTD | text | 2147483647 | √ | null |
|
|
|||||
MATERIAL1 | text | 2147483647 | √ | null |
|
|
|||||
MATERIAL2 | text | 2147483647 | √ | null |
|
|
|||||
BURNT | varchar | 3 | √ | null |
|
|
|||||
ARCHSPECIS | text | 2147483647 | √ | null |
|
|
|||||
ORGPART | text | 2147483647 | √ | null |
|
|
|||||
HUM_MOD | text | 2147483647 | √ | null |
|
|
|||||
SINGULAR | varchar | 3 | √ | null |
|
|
|||||
CONSERV | varchar | 3 | √ | null |
|
|
|||||
AGEMTD | varchar | 4 | √ | null |
|
|
|||||
PHYSCLEAN | varchar | 3 | √ | null |
|
|
|||||
CONTAM | text | 2147483647 | √ | null |
|
|
|||||
CHEMPREPAB | text | 2147483647 | √ | null |
|
|
|||||
SOLVENT1 | varchar | 3 | √ | null |
|
|
|||||
SOLVENT2AB | text | 2147483647 | √ | null |
|
|
|||||
YIELD_MG | numeric | 0 | √ | null |
|
|
|||||
YIELD_PCT | numeric | 0 | √ | null |
|
|
|||||
C | numeric | 0 | √ | null |
|
|
|||||
C_ERR | numeric | 0 | √ | null |
|
|
|||||
C_MTD | text | 2147483647 | √ | null |
|
|
|||||
PCT_C | numeric | 0 | √ | null |
|
|
|||||
PCT_C_ERR | numeric | 0 | √ | null |
|
|
|||||
PCT_C_MTD | text | 2147483647 | √ | null |
|
|
|||||
PCT_N | numeric | 0 | √ | null |
|
|
|||||
PCT_N_ERR | numeric | 0 | √ | null |
|
|
|||||
PCT_N_MTD | text | 2147483647 | √ | null |
|
|
|||||
CN_RATIO | numeric | 0 | √ | null |
|
|
|||||
CN_ERR | numeric | 0 | √ | null |
|
|
|||||
CN_MTD | text | 2147483647 | √ | null |
|
|
|||||
C13 | numeric | 0 | √ | null |
|
|
|||||
C13_ERR | numeric | 0 | √ | null |
|
|
|||||
C13_MTD | text | 2147483647 | √ | null |
|
|
|||||
O18 | numeric | 0 | √ | null |
|
|
|||||
O18_ERR | numeric | 0 | √ | null |
|
|
|||||
O18_MTD | text | 2147483647 | √ | null |
|
|
|||||
N15 | numeric | 0 | √ | null |
|
|
|||||
N15_ERR | numeric | 0 | √ | null |
|
|
|||||
N15_MTD | text | 2147483647 | √ | null |
|
|
|||||
S34 | numeric | 0 | √ | null |
|
|
|||||
S34_ERR | numeric | 0 | √ | null |
|
|
|||||
S34_MTD | text | 2147483647 | √ | null |
|
|
|||||
RECRYST | varchar | 3 | √ | null |
|
|
|||||
PCT_RE_VAL | numeric | 0 | √ | null |
|
|
|||||
PCT_RE_ERR | numeric | 0 | √ | null |
|
|
|||||
PCT_RE_MTD | varchar | 5 | √ | null |
|
|
|||||
C14_AGE | numeric | 0 | √ | null |
|
|
|||||
C14_ERRPOS | numeric | 0 | √ | null |
|
|
|||||
C14_ERRNEG | numeric | 0 | √ | null |
|
|
|||||
C14_INF | varchar | 3 | √ | null |
|
|
|||||
F14C | numeric | 0 | √ | null |
|
|
|||||
F14C_ERR | numeric | 0 | √ | null |
|
|
|||||
C13_VAL | text | 2147483647 | √ | null |
|
|
|||||
AGE_COMMT | text | 2147483647 | √ | null |
|
|
|||||
id | serial | 10 | √ | nextval('sahularch_c14_id_seq'::regclass) |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
sahularch_c14_pkey | Primary key | Asc | id |
sahularch_c14_geom_idx | Performance | Asc | geom |