You are here: Home / Systems / CERA / Data Model / Tables & Attributes / Block PARAMETER and others

Block PARAMETER and others

Blocks PARAMETER, SPATIAL_REFERENCE, KEY_CONNECT, REFERENCE

Meaning, type, and size of CERA Core 2.5 and CERA Modules' table attributes

Required attributes are marked with an asterisk; no NULL values should occur in any CERA field (neutral items are in the selection lists or are defaulted, in case meanigful input can not be given, e.g., "n/a" for not available or not applicable information).

 

Tables are divided into the CERA Core blocks and the CERA Modules, marked as "entities E" (except LOVs), "lists of values L" (LOVs), and "relations R". For the LOVs the default values "not filled" and "n/a" are not displayed. The basic sets of values are to be understood as suggestion.

 

Attributes Definition for CERA Blocks PARAMETER, SPTIAL_REFERENCE, KEY_CONNECT and REFERENCE

Block PARAMETER (5 TABLES)


Table
AGGREGATION L
TYPE*SIZE EXPLANATION / COMMENT
aggregation_id integer Primary key.
aggregation_descr char*80 Description of the aggregation of the meeasured TOPIC, e.g. monthly mean, daily maximum.
basic set of values : descr none; any combination of: annual, biannual, bimonthly, daily, hourly, monthly, quarterly, weekly ---- interval, max., mean, min., scatter, std.dev., sum.
Table
SPATIAL_DATA_ORG L
TYPE*SIZE EXPLANATION / COMMENT
spatial_dat_org_id integer Primary key.
reference_method char*80 Form by that the data references the space (e.g. point, vector, raster, spectral...).
basic set of values : method indirect spatial reference (e.g. by names of types of geographic features); point(s), non gridded; vector; points: gridded; LON:spectral/LAT:gridded.
Table
TOPIC L
TYPE*SIZE aliased as TOPIC1, TOPIC2, TOPIC3
topic_id integer Primary key.
topic_name char*80 Kinds of measurements/physical quantities represented by the data. A keyword list exists (e.g. sea level).
topic_acronym char*31 Abbreviated version of topic_name.
topic_descr char*2000 Description of the topic.
topic_pointer integer topic_id of the preceeding topic in the hierarchical structure of the table TOPIC.
topic_level integer*2 Level of topic in the hierachical structure of this table.
basic set of values : - see Table TOPIC.
Table
UNIT L
TYPE*SIZE aliased as UNIT1, UNIT2
unit_id integer Primary key.
unit_name char*80 Unit of the physical quantity found in table TOPIC.
unit_acronym char*31 Abbreviated version of unit_name.
unit_descr char*2000 Definition of units in measured physical quantities.
basic set of values : - Any unit necessary for the data the institute deals with.
Table
PARAMETER R
TYPE*SIZE EXPLANATION / COMMENT
entry_id integer Foreign key to ENTRY.
topic_id integer Foreign key to TOPIC.
unit_id integer Foreign key to UNIT.
aggregation_id integer Foreign key to AGGREGATION.
spatial_data_org_id integer Foreign key to SPATIAL_DATA_ORG.
optional: data_access_id integer Foreign key to Module DATA_ACCESS
optional: data_org_id integer Foreign key to Module DATA_ORGANIZATION
optional: data_org_seq integer Sequence of topics, if ordered

Block SPATIAL REFERENCE (3 TABLES)


Table
HOR_COORD_SYS L
TYPE*SIZE EXPLANATION / COMMENT
hor_coord_sys_id integer Primary key.
sys_descr char*2000 Description of the horizontal coordinate system(s).
basic set of values : descr LON and LAT: geographic; LON and LAT: planar; local; LON: geographic, LAT: spectral.
Table
VER_COORD_SYS L
TYPE*SIZE EXPLANATION / COMMENT
ver_coord_sys_id integer Primary key.
sys_descr char*2000 Description of the vertical coordinate system(s).
basic set of values : descr no vertical extension; altitude: length; altitude: pressure; altitude and depth: length; altitude: pressure, depth: length; depth: length.
Table
SPATIAL_REFERENCE R
TYPE*SIZE EXPLANATION / COMMENT
entry_id integer Foreign key to ENTRY.
hor_coord_sys_id integer Foreign key to HOR_COORD_SYS.
ver_coord_sys_id integer Foreign key to VER_COORD_SYS.

Block KEY_CONNECT (2 TABLES)


Table
GENERAL_KEY L
TYPE*SIZE EXPLANATION / COMMENT
general_key_id integer Primary key.
general_key char*250 * Keyword list: any words or phrases used to further describe the entry.
Table
KEY_CONNECT R
TYPE*SIZE EXPLANATION / COMMENT
entry_id integer Foreign key to ENTRY.
general_key_id integer Foreign key to GENERQAL_KEY.

Block REFERNCE (5 TABLES)


Table
CITATION E
TYPE*SIZE EXPLANATION / COMMENT
citation_id integer Primary key.
title char*2000 Title of a publication related to the entry.
authors char*2000 List of the authors as given in the citation.
publication char*80 Name of the publication (e.g. of the journal, entology, editorial).
publisher char*80 Name of the publisher.
editor char*80 Name of the editor(s).
publication_date date Date of the publication. If day and/or month unknown set to 1.
country char*80 Name of the country (address).
state char*80 Name of the state (address).
place char*80 Name of the place (address).
edition char*80 Name of the edition.
access_spec char*160 Specification (number) of the citation_type (the URL, the ISBN, etc.).
additional_info char*250 Comment.
presentation_id integer Foreign key to PRESENTATION.
citation_type_id integer Foreign key CITATION_TYPE.
Table
CITATION_TYPE L
TYPE*SIZE EXPLANATION / COMMENT
citation_type_id integer Primary key.
citation_type char*80 Type of the citation (e.g. book, journal, web publication etc.).
citation_type_descr char*2000 Description of citation_type.
basic set of values : type other; www publication; other internet access; CD publication; book; journal; unreviewed publication.
Table
PRESENTATION L
TYPE*SIZE EXPLANATION / COMMENT
presentation_id integer Primary key.
presentation_descr char*2000 Type of the data presentation, e.g. graph, picture, table...
basic set of values : descr atlas; diagram; globe; image: remote sensing; image: view/aerial photograph; map: political; map: thematic; map; numerical data; profile; section.
Table
REF_TYPE L
TYPE*SIZE EXPLANATION / COMMENT
ref_type_id integer Primary key.
ref_type_descr char*2000 Description of the relation, the publication has to the entry.
basic set of values : descr publication provides data; publication uses data.
Table
REFERENCE R
TYPE*SIZE EXPLANATION / COMMENT
entry_id integer Foreign key to ENTRY.
citation_id integer Foreign key to CITATION.
ref_type_id integer Foreign key to REF_TYPE.

Document Actions