Sections
You are here: Home → Climate Data → CERA → Data Model → Tables & Attributes → Block COVERAGE and others

Block COVERAGE and others

Blocks COVERAGE, LOCATION_CONNECT, LANGUAGES, DISTRIBUTION

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 COVERAGE, LOCATION CONNECT, DISTRIBUTION and LANGUAGE

Block COVERAGE (4 TABLES)
Table
SPATIAL_COVERAGE E		 TYPE*SIZE EXPLANATION / COMMENT
spatial_coverage_id integer Primary key.
min_lat float*4 * Southernmost latitude of the area covered by the data (south of Equator negative).
max_lat float*4 * Northernmost latitude of the area covered by the data (south of Equator negative).
min_lon float*4 * Westernmost longitude of the area covered by the data (west of Greenwich negative).
max_lon float*4 * Easternmost longitude of the area covered by the data (west of Greenwich negative).
min_altitude float*4 Lowest depth/altitude of the vertical coverage of the data.
min_alt_unit_id integer Foreign key to UNIT.
max_altitude float*4 Highest depth/altitude of the vertical coverage of the data.
max_alt_unit_id integer Foreign key to UNIT.
Table
TEMPORAL_COVERAGE E		 TYPE*SIZE EXPLANATION / COMMENT
temporal_coverage_id integer Primary key.
start_year integer*8 * Start year of the time covered by the data (YYYYYY...).
start_month integer*1 Start month (MM), 0 (zero) if unknown or undefined.
start_day integer*1 Start day (DD), 0 (zero) if unknown or undefined.
stop_year integer*8 * End year of the time covered by the data (YYYYYY...). stop_year=999999 stands for continously supplemented data (an appropriate item in CURRENTNESS_REF should be selected).
stop_month integer*1 End month (MM), 0 (zero) if unknown or undefined.
stop_day integer*1 End day (DD), 0 (zero) if unknown or undefined.
currentness_ref_id integer Foreign key to CURRENTNESS_REF.
Table
CURRENTNESS_REF L		 TYPE*SIZE EXPLANATION / COMMENT
currentness_ref_id integer Primary key.
currentness_ref_descr char*2000 Basis, for determining the time period of content information (metadata: temporal coverage).
basic set of values : descr present ground condition; calendrical publication date; arbitrary numbered years; calendrical time coverage of data; calendrical time coverage of data (continued); climate model time; unchecked data; time before present (1950=0).
Table
COVERAGE R		 TYPE*SIZE EXPLANATION / COMMENT
entry_id integer Foreign key to ENTRY.
temporal_coverage_id integer Foreign key to TEMPORAL_COVERAGE.
spatial_coverage_id integer Foreign key to SPATIAL_COVERAGE.

Block LOCATION_CONNECT (2 TABLES)
Table
LOCATION_CONNECT R		 TYPE*SIZE EXPLANATION / COMMENT
entry_id integer Foreign key to ENTRY.
location_id integer Foreign key to LOCATION.
Table
LOCATION L		 TYPE*SIZE aliased as LOCATION1, LOCATION2, LOCATION3
location_id integer Primary key.
location_name char*80 Names of place/region.
location_descr char*2000 Description of place/region.
location_pointer integer location_id of the preceeding location in the hierarchical structure of the table LOCATION.
location_level integer*2 Level of location_id in the hierachical structure of this table.
ref_date char*15 A date or year, when the information of this record was valid.
min_lat float*4 Southernmost geogr. latitude of the location area (south of Equator negative), in degrees.
max_lat float*4 Northernmost geogr. latitude of the location area (south of Equator negative), in degrees.
min_lon float*4 Westernmost geogr. longitude of the location area (west of Greenwich negative), in degrees.
max_lon float*4 Easternmost geogr. longitude of the location area (west of Greenwich negative), in degrees.
basic set of values :   see Table LOCATION.

Block DISTRIBUTION (6 TABLES)
Table
ACCESS_CONSTRAINT L		 TYPE*SIZE EXPLANATION / COMMENT
access_constraint_id integer Primary key.
constraint_descr char*2000 Description of the permits of the data: Permit to see the data, permit to copy for own purpose.
basic set of values : descr unrestricted; institute only; work group only; owner only (supply owner in CONTACT in this case); inhouse unrestricted, externally only in collaborations.
Table
ACCESS_TYPE L		 TYPE*SIZE Dependent on the value of PROGRESS.progress_descr the access type may refer to the inhouse storage medium or to the form of distribution (in case of remote data).
access_type_id integer Primary key.
access_acronym char*31 Short version of access_descr.
access_descr char*2000 Description of physical access to the data.
basic set of values : acronym remote; 3 1/2" diskette; 5 1/4" diskette; audiocassette; cartridge tape; CD-ROM; chart; computer programme; disc: DB Table; disc: DB blob pointer; disc: normal file; disc: other; electronic bulletin board; electronic mail system; filmstrip; magnetic tape; microfiche; microfilm; online: other; offline: other; paper; physical model; stable-base material; transparency; videocassette; videodisc; videotape.
Table
FEES L		 TYPE*SIZE EXPLANATION / COMMENT
fees_id integer Primary key.
fees_acronym char*31 Short version of fees_descr.
fees_descr char*2000 Description of the fees charged for the data.
basic set of values : acronym none; UIG GebVO; like UIG GebVO; low price (<100 Eu); medium price (100-500 Eu); high price (>500 Eu).
Table
FORMAT L		 TYPE*SIZE EXPLANATION / COMMENT
format_id integer Primary key.
format_acronym char*31 Entry format, e.g. GIF, GRIB.
format_descr char*2000 Explanation of the format_acronym.
basic set of values :   see Table FORMAT.
Table
USE_CONSTRAINT L		 TYPE*SIZE EXPLANATION / COMMENT
use_constraint_id integer Primary key.
constraint_descr char*2000 Description of the permits of the data: Permit to use and publish the data.
basic set of values : descr unrestricted; institute only; work group only; owner only (supply owner in CONTACT in this case); inhouse unrestricted, externally only in collaborations.
Table
DISTRIBUTION R		 TYPE*SIZE aliased as DISTRIBUTION1
entry_id integer Foreign key to ENTRY.
access_type_id integer Foreign key to ACCESS_TYPE.
data_size float*8 Size of data set in Bytes. The data_size should be a whole number. However, it is not defined as integer to enable input in scientific format (e.g. 2E+9).
format_id integer Foreign key to FORMAT.
fees_id integer Foreign key to FEES.
access_constraint_id integer Foreign key to ACCESS_CONSTRAINT.
use_constraint_id integer Foreign key to USE_CONSTRAINT.

Block LAGUAGES (2 TABLES)
Table
LANGUAGES		 TYPE*SIZE EXPLANATION / COMMENT
language_id integer Primary key.
language_name char*250 The language of the data document.
Table
LANGUAGES R		 TYPE*SIZE EXPLANATION / COMMENT
entry_id integer Foreign key to ENTRY.
language_id integer Foreign key to LANGUAGE.
Document Actions