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 |