crn_aus_basins

297 rows


Description

Is flat GeoServer input table. Refer to http://dx.doi.org/10.25900/5WBX-N779. Table creation date: 2024-08-22 11:01:11 UTC

Columns

Column Type Size Nulls Auto Default Children Parents Comments
geom geometry 2147483647 √ null
OBSID1 text 2147483647 √ null
OBSID2 text 2147483647 √ null
STUDYID varchar 5 √ null
crn_studynote.STUDYID Implied Constraint R
CRN_SUBCMP varchar 3 √ null
DBDOI varchar 256 √ null
DBVERNO text 2147483647 √ null
CNTRY varchar 2147483647 √ null
REGION_INT text 2147483647 √ null
REGION_REG varchar 2147483647 √ null
DIV_ADMIN varchar 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
REFDBID text 2147483647 √ null
OAID varchar 11 √ null
global_Author.OAID Implied Constraint R
AUTHOR text 2147483647 √ null
PUBYEAR int2 5 √ null
REFID text 2147483647 √ null
REFDOI text 2147483647 √ null
MATERIAL varchar 6 √ null
SIZEMIN int4 10 √ null
SIZEMAX int4 10 √ null
PROJEPSGID int2 5 √ null
crn_projepsgID.PROJEPSGID Implied Constraint R
PROJECTION varchar 13 √ null
AREA numeric 12,2 √ null
ELEV_AVE numeric 6,2 √ null
ELEV_STD numeric 6,2 √ null
SLP_AVE numeric 6,2 √ null
SLP_STD numeric 6,2 √ null
CENTR_LAT numeric 6,4 √ null
ATM_PRESS numeric 6,2 √ null
SMP_DAY int2 5 √ null
SMP_MONTH int2 5 √ null
SMP_YEAR int2 5 √ null
SMP_COMMT text 2147483647 √ null
BE10NP int8 19 √ null
BE10NP_ERR int8 19 √ null
BE10EP numeric 0 √ null
BE10EP_ERR numeric 0 √ null
BESTND text 2147483647 √ null
BECORR numeric 5,4 √ null
BEAMS text 2147483647 √ null
BE10NC int8 19 √ null
BE10NC_ERR int8 19 √ null
BEPROD numeric 12,3 √ null
BETOPO numeric 12,3 √ null
BESELF numeric 12,3 √ null
BESNOW numeric 12,3 √ null
BETOTS numeric 12,3 √ null
EBE_GCMYR numeric 12,5 √ null
ERRBE_AMS numeric 12,5 √ null
ERRBE_MUON numeric 12,5 √ null
ERRBE_PROD numeric 12,5 √ null
ERRBE_TOT numeric 12,5 √ null
EBE_MMKYR numeric 12,2 √ null
EBE_ERR numeric 12,2 √ null
AL26NP int8 19 √ null
AL26NP_ERR int8 19 √ null
AL26EP numeric 0 √ null
AL26EP_ERR numeric 0 √ null
ALSTND text 2147483647 √ null
ALCORR numeric 5,4 √ null
ALAMS text 2147483647 √ null
AL26NC int8 19 √ null
AL26NC_ERR int8 19 √ null
ALPROD numeric 12,3 √ null
ALTOPO numeric 12,3 √ null
ALSELF numeric 12,3 √ null
ALSNOW numeric 12,3 √ null
ALTOTS numeric 12,3 √ null
EAL_GCMYR numeric 12,5 √ null
ERRAL_AMS numeric 12,5 √ null
ERRAL_MUON numeric 12,5 √ null
ERRAL_PROD numeric 12,5 √ null
ERRAL_TOT numeric 12,5 √ null
EAL_MMKYR numeric 12,2 √ null
EAL_ERR numeric 12,2 √ null
id serial 10 √ nextval('crn_aus_basins_id_seq'::regclass)

Indexes

Constraint Name Type Sort Column(s)
crn_aus_basins_pkey Primary key Asc id
crn_aus_basins_geom_idx Performance Asc geom

Relationships

Close relationships within degrees of separation