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

Print this

Sections