HOME   UP   bottom of document  

picture


Descriptions of Loading Tables for CERA Core and CERA Module Data_Access as used at PIK, Version 2.3 (19 Dez 1997)

Meaning, type, and size of CERA Core 2.3 loading table attributes; required attributes are preceded by an asterrisk; all table attributes are divided into 9 tables: LOAD_ENTRY, LOAD_CONTA, LOAD_REFER, LOAD_PARAM, LOAD_COVER, LOAD_DISTR, LOAD_SPATI, LOAD_PROCE, LOAD_KEY_C. Below the structure of some lists of values (LOVs) is given, too.

Table LOAD_ENTRYTYPE*SIZEIn this table general information for the data record is entered.
entry_namechar*160* Entry name uniquely identifying this meta data record.
entry_acronymchar*31* Acronym of the entry_name, uniquely identifying the entry.
project_acronymchar*31Abbreviated version of project_name.
progress_descrchar*31The state of the data set in the institute (e.g. complete, in work, planned).
creation_datedateDate of data creation.
review_datedateDate of the latest review for accuracy of scientific content of the data.
revision_datedateDate of last update of data.
future_review_datedateFuture time at which the meta data should be reviewed for accuracy of scientific or technical content.
summarychar*2000Contains an abstract and additional information not contained in other fields.
accuracy_reportchar*2000Quantitative accuracy of the attributes described by the data (e.g. information on error bars).
consistency_reportchar*2000An explanation of the fidelity of the relationships in the data set and the tests used for their proof.
completeness_reportchar*2000Information about omissions, selection criteria, generalization, definitions used, and other rules to derive the data set.
horizontal_acc_repor tchar*2000Quantitative horizontal position accuracy.
vertical_acc_reportchar*2000Quantitative vertical position accuracy.
Table LOAD_CONTATYPE*SIZEAny type of contact should be given here. A contact information consists of the information on a person and/or an institute (e.g. the person/institute that has the metadata entered: contact_type "Metadata").
contact_typechar*80Type of the contact (investigator, technical info, copyright etc.).
institute_info-The institute related to the contact. Select an institute from the LOV, supply a new institute record if necessary.
person_info-The person related to the contact. Select a person from the LOV, supply a new person record if necessary.
Table LOAD_REFERTYPE*SIZEEnter here any reference to a publication, that is related to the data (e.g. papers, that made use of the data or the reference where the data is published).
ref_type_descrchar*2000Description of the relation, the publication has to the entry (e.g. publication uses entry data, publication provides entry data).
citation_info-Publication related to the entry. Normally the Publication is to be inserted into the value list.
Table LOAD_PARAMTYPE*SIZEThis table shall provide information on the physical quantities actually measured or given in the data, as e.g. precipitation, sea level etc.) and the storage information, necessary to access the data.
topic_namechar*80* Kinds of measurements/physical quantities represented by the data.
unit_namechar*80Unit of the physical quantity found in topic_name (e.g. meter, Volt, class).
aggregation_descrchar*80Description of the aggregation of the meeasured topic (e.g. monthly mean, daily maximum, none...).
reference_methodchar*80Form by that the data of this topic references the space (e.g. point, vector, raster, spectral...).
access_structure_namechar*80Short form of access_structure_descr.
access_structure_descrchar*2000Explanation/description of the contents of the following 4 storage fields.
storage1char*250Name of the host, data is lying on (not necessary, when file systems are joined).
storage2char*250Name of the path the user has to enter, to find the data.
storage3char*250Name of the file containing the data. Set to * if data consists of several files in the directory "storage2" (and its subdirectories).
storage4char*250Additional storage information (e.g. approx. number of files, if there are several).
modification_datedate=Date, for which the information in storage* was valid.
Table LOAD_COVERTYPE*SIZEThe spacetime volume covered by the data: area, elevation, time period.
location_namechar*80Name of the location of the area covered by the data.
min_latfloat*4* Southernmost latitude of the area covered by the data (south of Equator negative).
max_latfloat*4* Northernmost latitude of the area covered by the data (south of Equator negative).
min_lonfloat*4* Westernmost longitude of the area covered by the data (west of Greenwich negative).
max_lonfloat*4* Easternmost longitude of the area covered by the data (west of Greenwich negative).
min_altitudefloat*4Lowest depth/altitude of the vertical coverage of the data. Leave empty (NULL), if data has no vertical extension.
min_alt_unitchar*31Unit of min_altitude.
max_altitudefloat*4Highest depth/altitude of the vertical coverage of the data. Leave empty (NULL), if data has no vertical extension.
max_alt_unitchar*31Unit of max_altitude.
start_yearinteger*8* Start year of the time covered by the data (YYYYYY...).
start_monthinteger*1Start month (MM), NULL if unknown.
start_dayinteger*1Start day (DD), NULL if unknown.
stop_yearinteger*8End year of the time covered by the data (YYYYYY...), NULL if unknown.
stop_monthinteger*1End month (MM), NULL if unknown.
stop_dayinteger*1End day (DD), NULL if unknown.
currentness_ref_descrchar*2000* Basis, for determining the time period of content information (e.g. time information may refer tocalendar, model time etc.).
Table LOAD_DISTRTYPE*SIZEInformation related to the distribution of the data.
data_sizeinteger*8Size of data (set) in Bytes.
format_acronymchar*31Entry format, e.g. GIF, GRIB, PS.
access_acronymchar*31Medium keeping the information (3,5" diskette, CD, paper, physical model, etc.).
fees_acronymchar*31Fees one has (officially) to pay for the data.
access_constr_descrchar*2000Description of the permits of the data: Permit to see and know about the data.
use_constr_descrchar*2000Description of the permits of the data: Permit to use and publish the data.
Table LOAD_SPATITYPE*SIZEThe form of spatial reference that relates the data to space.
hor_sys_descrchar*2000Description of the horizontal coordinate system(s) (e.g. geographical, planar...).
ver_sys_descrchar*2000Description of the vertical coordinate system(s) (e.g. length, pressure...).
Table LOAD_PROCETYPE*SIZEProcedures applied to the data (if there are any) by PIK or collaborators (e.g. mathematical procedures or other). Not just format changes.
process_descrchar*2000* If data has been processed/changed: description of processing.
process_datedateIf data has been processed/changed: date of processing. Set month and/or day to "1", if only year is known.
person_info-Person that performed the procedure (to be selected from the LOV). Extend the LOV if the person is not given there.
Table LOAD_KEY_CTYPE*SIZEKeywords, for the time being not treelike organized, just flat.
general_keychar*31* Keyword list: any words or phrases used to further describe the entry. A LOV provides the data of a GCMD Thesaurus (for entries of the lowest level, the above level is given in parenthesis).
LOV INSTITUTE TYPE*SIZEDesription of an Institution. Enter different records for different departments of an institute.
institute_namechar*80* Name of the institute. Use the original name given by the institute to itself (if translation is necessary, translate to english).
institute_acronymchar*31Abbreviated version of the institute name.
department_namechar*160Name of the department or institute sub-division. Use multiple records for different departments.
department_acronymchar*31Abbreviated version of the department name.
countrychar*80Full name of the country (address).
state_or_provincechar*80Name of the state or province (address).
placechar*80Name of the place/city (address).
streetchar*80Name of the street (address).
street_postal_codechar*10Postal code of the street address.
poboxchar*80Pobox (address).
pobox_postal_codechar*10Postal code of the Post box address (if different from street_postal_code).
inst_urlchar*80Universal Resource Locator of the institute's homepage.
additional_infochar*400Additional address information, or other information about the institute.
LOV PERSON TYPE*SIZEDescription of a person.
first_namechar*80First name.
second_namechar*80Second name.
last_namechar*80* Last name. Instead of a person's name a position or office may be given (e.g. secretary, central office).
titlechar*31Title of the person.
telephonechar*80Phone.
faxchar*80FAX.
person_urlchar*80Universal Resource Locator of the person's home page.
emailchar*80email address.
person_inst_IDchar*31ID no. of the institute, the person is affilated to. Select an institute from the list of values. Add the institute to the LOV if necessary.
LOV CITATIONTYPE*SIZEEnter here any publication, that is related to the data (e.g. papers, that made use of the data or the reference where the data is published).
titlechar*2000* Title of a publication related to the entry.
authorschar*2000* List of the authors as given in the citation.
publicationchar*80Name of the publication (e.g. of the journal, entology, editorial).
publisherchar*80Name of the publisher.
editorchar*80Name of the editor(s).
publication_datedateDate of the publication. If day and/or month unknown, set to 1.
countrychar*80Name of the country (address).
statechar*80Name of the state (address).
placechar*80Name of the place (address).
editionchar*80Name of the edition.
access_specchar*160Specification (number) of the citation_type (the URL, the ISBN, etc.)
presentation_descrchar*2000Type of the data presentation, e.g. graph, picture, table...

Go to top of document.

Pages are optimized for NETSCAPE. For comments and suggestions contact Frank Toussaint.

Last change: Fri May 28 21:40:24 NFT 1999