sahulchar

48234 rows


Description

Is flat GeoServer input table. Refer to http://dx.doi.org/10.25900/KKDX-XH23. Table creation date: 2024-08-22 11:02:16 UTC

Columns

Column Type Size Nulls Auto Default Children Parents Comments
geom geometry 2147483647 √ null
OBSID int4 10 √ null
char_DataCore.OBSID Implied Constraint R
OBSNAME text 2147483647 √ null
LABID text 2147483647 √ null
LAB_ORIGIN text 2147483647 √ null
DBDOI varchar 256 √ null
DBVERNO text 2147483647 √ null
METASITEID text 2147483647 √ null
global_MetaSite.METASITEID Implied Constraint R
METANAME text 2147483647 √ null
META_DESCR text 2147483647 √ null
SITEID text 2147483647 √ null
global_SiteMaster.SITEID Implied Constraint R
SITENAME text 2147483647 √ null
CNTRY varchar 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
AHGFL1 varchar 3 √ null
AHGFL2 varchar 6 √ null
RIVNAME text 2147483647 √ null
RIVDIV text 2147483647 √ null
IBRACODE varchar 3 √ null
IBRAREGION text 2147483647 √ null
X_WGS84 numeric 10,6 √ null
Y_WGS84 numeric 10,6 √ null
CORDS_ELEV varchar 2147483647 √ null
ELEVATION numeric 6,2 √ null
BIOME text 2147483647 √ null
CATCHSIZE varchar 3 √ null
BASINSIZE varchar 3 √ null
FLOWTYPE varchar 7 √ null
NEO_SITEID int4 10 √ null
SITEDESCR text 2147483647 √ null
SITE_SPEC text 2147483647 √ null
SITECODE text 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
UNITID int4 10 √ null
global_UnitMaster.UNITID Implied Constraint R
UNITNAME text 2147483647 √ null
UNITHANDLE varchar 10 √ null
UNITTYPE text 2147483647 √ null
COL_MTD text 2147483647 √ null
DEPOSIT text 2147483647 √ null
COLLDATE varchar 10 √ null
WATERDEPTH numeric 0 √ null
NEO_HANDLE varchar 10 √ null
COLL_SPEC text 2147483647 √ null
UNIT_COMMT text 2147483647 √ null
SMPID int4 10 √ null
char_Sample.SMPID Implied Constraint R
SMPNAME text 2147483647 √ null
THICKNESS numeric 8,2 √ null
SMPDEPTH numeric 0 √ null
SMPCOMMT text 2147483647 √ null
WHATAMI text 2147483647 √ null
AGE numeric 12,2 √ null
AGE_ERROR numeric 12,2 √ null
AGETYPE text 2147483647 √ null
AGE_SPEC varchar 12 √ null
METHOD text 2147483647 √ null
MATERIAL text 2147483647 √ null
EST_AGE numeric 12,2 √ null
CALCURVE text 2147483647 √ null
CALPROGVER text 2147483647 √ null
CHARCOUNTS numeric 0 √ null
CHARMETHOD text 2147483647 √ null
CHARMEAS text 2147483647 √ null
CHARMAX numeric 0 √ null
CHARMIN numeric 0 √ null
CHARSIZE text 2147483647 √ null
DATASOURCE text 2147483647 √ null
OBS_COMMT text 2147483647 √ null
id serial 10 √ nextval('sahulchar_id_seq'::regclass)

Indexes

Constraint Name Type Sort Column(s)
sahulchar_pkey Primary key Asc id
sahulchar_geom_idx Performance Asc geom

Relationships

Close relationships within degrees of separation