This document will be updated as discussion via the CaveData Internet mailing list proceeds.
The definitions below are arranged in Field ID (FID) order. The FID and field name are shown first, followed by the other details. See also the Notes at the end for the meanings of the various codes.
Finding a field in this list may be difficult unless you already know its FID, or what text to search for. Normally access to the definitions is made from the Field List document, which has arranged the fields firstly into the entities they belong to, then into subject headings within those entities. However if you know the FID, you can go straight to the field by adding #fid to the URL in your browser window and pressing <Return>.
[ Legend ] [ Field List ] [ Field value codes ] [ Updates ] [ UISIC ] [ UIS ]
Data type: A Max length: 2. Coding: I Single/Multi-valued: S
Codes
Definition:
For those karst features which are not caves, this field denotes
what type of karst feature they are. It is mutually exclusive with
8[Cave type].
Data type: A Max length: 1. Coding: I Single/Multi-valued: S
Codes
Definition:
The degree of submersion of THIS entrance. Blank if the
entrance is never submerged.
Data type: A Max length: 1. Coding: I Single/Multi-valued: S
Codes
Definition:
Describes how active THIS entrance is.
Comment:
(1) An entrance is classified as 'dry' only when it is NEVER active.
(2) Sea caves should not be classified as 'active' unless they
contain a flowing stream, permanent or intermittent. If water in
them is from the sea they should be described under 2[Submersion].
Data type: A Max length: 1. Coding: I Single/Multi-valued: S
Codes
Definition:
Describes the flow direction if THIS entrance is active, otherwise
it is blank.
Comment:
(1) An "inflow-outflow" is an entrance where sometimes the stream flow
is inwards, and at other times outwards. It is not used to describe a
through-cave with an inflow at one end and an outflow at the other:
such a cave is two items, an inflow and an outflow.
(2) An inundated sea cave does not normally qualify as an inflow-
outflow because the term refers to stream flow.
Data type: A Max length: 1. Coding: I Single/Multi-valued: S
Codes
Definition:
Describes the flow conditions inside a cave, if they differ from
the flow conditions at THIS entrance, otherwise left blank.
Example:
This field would be completed where a dry entrance led to an internal
stream, or where an intermittently active entrance led to a
permanent stream. A perennially active entrance would not have this
field completed unless its stream was joining another independent
stream inside the cave.
Data type: A Max length: 1. Coding: I Single/Multi-valued: S
Codes
Definition:
Describes the internal standing water conditions in a cave if they
differ from the water conditions at THIS entrance, otherwise left
blank.
Data type: A Max length: 2. Coding: I Single/Multi-valued: M
Codes
Definition:
Describes the type(s) of rock in which the cave or karst feature is
formed.
Usage:
If this is a further entrance to a cave and its rock type is
different from the rest of the cave, then record the respective
rock type against this entrance also.
Data type: A Max length: 2. Coding: I Single/Multi-valued: M
Codes
Definition:
Describes the cave type(s), but left blank if 1[Karst feature type]
has a value.
Comment:
One of either 8[Cave type] or 1[Karst feature type] must be completed
for an item to be recorded.
Data type: I Max length: 3. Coding: U Single/Multi-valued: S Definition: The total quantity of entrances to the cave, whether they are numbered or not, and including this one. Comment: Normally completed only for the main record for the cave and if there is more than one entrance.
Data type: A Max length: 1. Coding: I Single/Multi-valued: S
Codes
Definition:
Identifies whether this entrance is a vertical pothole-type entrance
or not, ignoring any inconsequential effects due to collapse in the
immediate entrance area.
Data type: A Max length: 3. Coding: I Single/Multi-valued: M
Codes
Definition:
Key words related to the development of the cave or karst feature,
and sequenced so that a reasonably readable statement of development
is the result.
Comment:
This is not intended to replace a description of the cave or karst
feature, but to provide a finite number of terms for development
searches. Of course the result is also a kind of description.
Usage:
(1) The same word can be used more than once.
(2) A "through-cave" should be noted using this field.
(3) A suggested method is to scan the list of available terms a few
times to become more familiar with it,
assess the significant aspects of the cave's development,
construct a brief statement, write the code numbers against each
word, and when OK, transfer the code numbers into the computer in
the correct sequence.
Data type: A Max length: 2. Coding: I Single/Multi-valued: M
Codes
Definition:
The degree of decoration or secondary deposits (speleothems) in the
cave.
Data type: N Max length: 5.1 Coding: U Single/Multi-valued: S Definition: The minimum air temperature known to exist in the cave, expressed in degrees Celsius (but omitting the degrees symbol). Comment: This field is obviously too simplified to serve as an adequate scientific statement of a cave's minimum temperature. Its purpose is to give an approximate guide and allow preliminary comparison/searching/sorting on the basis of temperature.
Data type: N Max length: 5.1 Coding: U Single/Multi-valued: S Definition: The maximum air temperature known to exist in the cave, expressed in degrees Celcius (but omitting the degrees symbol). Comment: See comment in 13[Minimum temperature].
Data type: N Max length: 6.1 Coding: U Single/Multi-valued: S Definition: The minimum humidity percent humidity known to exist in the cave. Comment: This field is obviously too simplified to serve as an adequate scientific statement of a cave's humidity. Its purpose is to give an approximate guide and allow preliminary comparison/searching/sorting on the basis of humidity.
Data type: N Max length: 6.1 Coding: U Single/Multi-valued: S Definition: The maximum percent humidity known to exist in the cave. Comment: See comment under 15[Minimum humidity].
Data type: A Max length: 2. Coding: I Single/Multi-valued: S
Codes
Definition:
A guide as to how wet or dry the cave is as a whole.
Usage:
If substantial areas of the cave depart from this average, then
choose "wide moisture range".
Data type: A Max length: 2. Coding: L Single/Multi-valued: S Definition: The component of a cave or karst feature number which identifies the country's State in which the cave is considered to be located. Usage: (1) In some cases a cave may straddle a State border. It is a matter for local policy to decide which State the cave is considered to be in, and whether any further entrances are considered to be in the same State or in their actual State, for cave number purposes. The 53[Comments] field can also be used to indicate their actual State. The cave's or entrances' locational fields would of course show their actual position. (2) State code is filled indirectly via the Lookup on 303[Area lookup] (3) The local codes for a country's States can be set in 286[State code], 287[State name], and 354[State abbreviation].
Data type: A Max length: 3. Coding: L Single/Multi-valued: S Definition: The component of the cave or karst feature number which identifies the area or region where the cave is located, and is unique within its parent State code. Comment: In deciding new area codes, it is best to avoid using the letters I and O as they can become confused with the adjacent numerical serial number component, and also with any numeric State code. Usage: Area codes are auto-filled via lookup on 303[Area lookup].
Data type: A Max length: 1. Coding: I Single/Multi-valued: S
Codes
Definition:
Whether this entrance is penetrable or not, including entry by diving.
Data type: N Max length: 8.4 Coding: U Single/Multi-valued: S Definition: The latitude given not closer than the precision specified in 294[Coarse - geogr. precision] in order not to reveal the exact location. Expressed as +/- degrees.decimal degrees. Positive if north of or on the Equator, negative if south of the Equator. Comment: (1) Expression as a real number instead of deg:min simplifies location-based searches, and geo-coding in GIS systems. (2) Because grid references are discontinuous at grid-zone boundaries, lat/longs are needed to allow wide-area searches. They also allow finding the location using an ordinary atlas. (3) This field is available for where coarse latitude is not being auto-derived from the exact latitude in 245[Position - latitude]. (4) Max text length: sign(1)+whole(2)+sep(1)+dec(4)=total 8, scale 4.
Data type: N Max length: 9.4 Coding: U Single/Multi-valued: S Definition: The longitude given not closer than the precision specified in 294[Coarse - geogr. precision], in order not to reveal the exact location. Expressed as +/- degrees.decimal degrees. Positive if east of Greenwich or on the Prime Meridian, or negative if west of Greenwich or on the 180-degree meridian. Comment: (1) See comments in field 21[Latitude - coarse]. (2) Max text length: sign(1)+whole(3)+sep(1)+dec(4)=total 9, scale 4.
Data type: A Max length: 30. Coding: U Single/Multi-valued: S Definition: The official name of the map or mapsheet used for giving a coarse grid reference for the cave or karst feature. Comment: (1) The map series to which this mapsheet belongs is given in 412[Coarse - map series] normally in the Site Parameters table. (2) Coarse locations are OK for publication or distribution studies, but not good enough to find the cave.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Replaced by 414[Map or sheet name], normally found in the grid references table.
Data type: A Max length: 4. Coding: L Single/Multi-valued: S Definition: A value used in order to distinguish between similar grid references on the one mapsheet when giving the coarse grid reference for a cave. Comment: The description of this grid reference qualifier is given in 413[Coarse - gr.ref qualifier], normally found in the site parameters table.
Data type: A Max length: 4. Coding: U Single/Multi-valued: S Definition: The approximate grid reference for this cave, given only to the coarse precision agreed as being suitable for publication, yet still reasonable for local distribution analyses. Expressed using the method described on the respective mapsheet, but omitting digits to achieve the required coarse precision. Comment: (1) The precision used is defined in 295[Coarse - gr.ref precision] in the site parameters table. (2) Accurate grid refs can be recorded in 241[Grid ref - easting] etc.
Data type: A Max length: 30. Coding: U Single/Multi-valued: S Definition: The name of the village, locality or named geographical feature nearest to the cave or karst feature. Usage: Normally required only when lat/long and grid references are not available.
Data type: N Max length: 7.1 Coding: U Single/Multi-valued: S Definition: The approximate altitude of this entrance of the cave, or of this karst feature, to a precision suitable for publication. Comment: The altitude units are set in 446[Coarse - altitude units], and its allowed precision in 526[Coarse altitude precision], both normally found in the site parameters table.
Data type: A Max length: 2. Coding: I Single/Multi-valued: S
Codes
Definition:
The degree to which this cave or karst feature has been explored.
Usage: Where data is being stored per entrance as well as for the
cave, this field should be completed only for the cave.
Data type: A Max length: 1. Coding: I Single/Multi-valued: M
Codes
Definition:
The type of event now being recorded about the original discovery
or recording of this cave or karst feature.
Example: It could be when the cave was first found, explored, or
recorded.
Usage:
(1) This entry is mandatory if the discovery name or date fields
are filled in.
(2) These discovery fields are multi-valued, therefore the various
discovery and first exploration and recording events can all be
recorded if known.
(3) The discovery of later extensions can be recorded in field
35[Extension discovery].
Data type: A Max length: 45. Coding: U Single/Multi-valued: M Definition: The name of the person(s) and/or organisation(s) who were involved in this original event for the cave or karst feature. The preferred formats are surname then initials for people, or initials without full stops for organisations. Comment: Ideally the value for this field would be shown on the screen simply by a link to 478[Person ID] or 380[Organisation ID] in the person or org databases, via links on the discovery fields for Person ID or Organisation ID. A 'names' field would then not be needed in the 'caves discovery' table at all. An actual field is needed in the caves-discovery table only when the database software does not allow such a link to the People or Organisations databases. Usage: Normally you would need to enter a value here only if: - the information was not autofilled by your lookup on Person or Organisation ID. - the person or organisation details were not available in a Person or Organisation database at this site.
Data type: A Max length: 2. Coding: U Single/Multi-valued: M Definition: The day of the month of the respective discovery event, in the range 1-31. Usage: If unknown, leave blank.
Data type: A Max length: 2. Coding: U Single/Multi-valued: M Definition: The month number of the respective discovery event, in the range 1-12. Usage: If unknown, leave blank.
Data type: A Max length: 4. Coding: U Single/Multi-valued: M Definition: The year, in full, of the respective discovery event. Usage: If unknown, leave blank.
Data type: A Max length: 52. Coding: U Single/Multi-valued: M Definition: Brief information about the discovery of a later extension to a cave, including extension name, discoverer name(s), and date. Examples: (1) Starburst Chamber: TCC, 26 Jan 1958. (2) Kelly's passage: Kelly J C & Downs X A, 13 June 1987. Usage: For multiple extensions, these are best entered in date order, earliest first. (Edit the value sequence numbers to alter the order.)
Data type: D Max length: 10. Coding: U Single/Multi-valued: M Definition: The full date of the respective discovery event, in database date format. Usage: Normally used only where a date-format field is wanted. Note that this field can accept only fully specified dates.
Data type: A Max length: 30. Coding: U Single/Multi-valued: M Definition: The genus name of a biological specimen found in the cave. Usage: (1) The accuracy of the genus identification should be indicated in 509[Genus confidence level]. (2) A Genus value can be entered only via a lookup table. This ensures that only valid and correctly spelt species can be entered, which aids later searching. To achieve this, the lookup table on this 37[Genus name] field allows loading of both the genus and the species values, with no separate lookup table for 38[Species name], except for allowing special species notations (See 38[Species name] help). (3) If your site also has a Specimen database as part of this system, then Genus/species can be automatically filled in via a lookup on the nearby 364[Specimen ID] field. (4) If a wanted Genus/species is missing from the Genus lookup table, please contact your database administrator to have it added.
Data type: A Max length: 30. Coding: U Single/Multi-valued: M Definition: The species name of a biological specimen found in a cave. Usage: (1) The accuracy of the species identification should be indicated in the 510[Species confidence level] field. (2) If the Genus is known but the species is not, or, if it is a new species, then the correct notation can be entered by loading the Genus field with any species having the correct Genus in the Genus lookup table, then using the lookup table on this 38[Species name] field to overwrite the species with the correct notation. (3) If a wanted species is not in the Genus/species lookup table, please contact your database administrator to have it added.
Data type: A Max length: 45. Coding: U Single/Multi-valued: M Definition: The surname(s) and initials of the author(s) of a reference describing the occurrence. Otherwise, the surname and initials of the person identifying the species occurrence in the cave, or the name of the person whose collection is holding it. The format for an author should be: "surname, initials". Example: Brown, D.E. and McDougal, M.A. Usage: This field would normally only need to be filled in if the value could not be auto-filled via a lookup on the relevant Article ID in 263[Species ref - article ID], or on a specimen via 364[Specimen ID].
Data type: A Max length: 1. Coding: I Single/Multi-valued: M
Codes
Definition:
Any special significance which this species occurrence in the
cave or karst feature may have. Expressed as a coded value.
Usage:
This field would normally only need to be filled in if the value
was not shown or auto-filled via a link to the relevant
Specimen ID in 364[Specimen ID].
Data type: A Max length: 2. Coding: I Single/Multi-valued: M
Codes
Definition:
The present use (if any) being made of the cave, or of this entrance
if a multi-entrance cave.
Comment: "wild tourist cave" in the value means a cave which is
more or less in its wild state without added construction work for
tourists, but is known to and accessible to the general public, as
opposed to cavers, via some form of entry management or control.
Data type: A Max length: 2. Coding: I Single/Multi-valued: S
Codes
Definition:
The owner category for this particular entrance.
Comment:
(1) A multi-entrance cave could have several owner categories.
(2) Ownership of normal public reserves should be stated as
"govt owned" - the phrase "community owned" means joint possession
and control by the community, and generally applies to tribal
ownership.
Data type: A Max length: 2. Coding: I Single/Multi-valued: M
Codes
Definition:
The types of damage present in the cave.
Data type: A Max length: 8. Coding: L Single/Multi-valued: S Definition: The state-agreed initials or abbreviation for the organisation who has allocated the management classification to the cave. Usage: (1) Left blank if not formally classified. (2) Mandatory if 45[Management category] is completed. (3) If this field is completed, then 45[Management category] should also be completed.
Data type: A Max length: 2. Coding: I Single/Multi-valued: S
Codes
Definition:
The formal category into which the cave or karst feature has been
placed by the management authority.
Usage:
(1) If a cave has more than one classification, or different parts
of it are classified differently, then choose "multi-category" and
give details in 53[Comments].
(2) If this field is completed, then 44[Management classifier] should
also be completed.
Data type: A Max length: 2. Coding: I Single/Multi-valued: M
Codes
Definition:
The situation or measures which assist in the protection of the cave
or karst feature.
Data type: A Max length: 8. Coding: L Single/Multi-valued: S Definition: The state-agreed initials of the controlling organisation. Comment: Normally omitted if controlled by a private owner or manager. Usage: If no per-trip permission is required, enter "nobody" (See pre-text, "entry permission from".)
Data type: A Max length: 2. Coding: I Single/Multi-valued: M
Codes
Definition:
Aspects for which this cave or karst feature is important, including
the type(s) of any specific studies made in the cave.
Usage: If studies have been performed, include them in the References
database and cross-reference to them via cave field 270[Article ID].
Data type: A Max length: 2. Coding: I Single/Multi-valued: M
Codes
Definition:
The present surface use(s) of the land in which this cave entrance or
karst feature is located.
Data type: A Max length: 2. Coding: I Single/Multi-valued: M
Codes
Definition:
Unusual equipment, skills or activities which are unavoidable in a
normal visit or reasonable exploration of the cave, rather than when
pushing the cave to its limits.
Data type: A Max length: 2. Coding: I Single/Multi-valued: M
Codes
Definition:
Indications which point to the likelihood of further extensions to
the known cave being possible.
Data type: A Max length: 2. Coding: I Single/Multi-valued: M
Codes
Definition:
Dangers which could be encountered in some parts of the cave or
karst feature.
Data type: A Max length: 62. Coding: U Single/Multi-valued: M Definition: Comments lines about a cave or karst feature. Usage: (1) This field should be used only when a suitable more specific field is not available because (1) the comments cannot easily be displayed in various languages, and (2) its information is difficult to make use of in analyses and searches. (2) One valid use of Comments is for qualifying an entry in another field or for specifying a field value choice which was not available. (3) Each field value is one line of the overall comments. (4) Use semicolons (;) between separate comments.
Data type: I Max length: 4.0 Coding: U Single/Multi-valued: S Definition: The approximate percentage of the known extent of the cave which has been mapped. Usage: Do not include the % symbol.
Data type: A Max length: 3. Coding: U Single/Multi-valued: M Definition: The standard 3-letter organisation code for the organisation which produced the map which is being referenced for the cave or karst feature. Comment: See Comment in field 264[Map sequence number]. Usage: You would normally need to enter this value only when: - the information was not auto-filled by the lookup on 265[Map ID], or - the map details were not available in a map database on the site.
Data type: N Max length: 10.1 Coding: U Single/Multi-valued: S Definition: The aggregate length of the cave or karst feature in metres. Usage: (1) The method used should be indicated in 57[Length method]. (2) Dimensions which are better described as horizontal extent can be entered in 67[Extent length] and 68[Extent width]. (3) When caves join, or when there is more than one numbered entrance, the total length should be recorded only in the nominated "cave" record, not in any entrance records.
Data type: A Max length: 2. Coding: I Single/Multi-valued: S
Codes
Definition:
The method used in arriving at the stated length of a cave or karst
feature.
Usage: This field should always be used when 56[Length] is completed,
but not if it is empty.
Data type: N Max length: 10.2 Coding: U Single/Multi-valued: S Definition: The accuracy of the stated length of a cave or karst feature, stated in +/- metres. Example: If the length is between 510 and 520 metres, then the length should be given as 515 and the value of this field as 5, i.e. 515m +/-5m.
Data type: N Max length: 8.2 Coding: U Single/Multi-valued: S Definition: The vertical distance the cave extends below the lowest point of this entrance, in metres. Usage: (1) If only the overall vertical range is known, or if this is a karst feature, use 511[Vertical extent] instead of this field. (2) If the entrance is in a karst feature, such as a doline, the entrance is taken to be where the cave leaves the profile of the karst feature. (3) If this field is completed, then 61[Vertical method] should be completed, and also 62[Vertical accuracy] if possible. (4) Any underwater depth, if known, should be included. The depth to the watertable can be shown in 53[Comments], e.g. "wtable -50m;"
Data type: N Max length: 8.2 Coding: U Single/Multi-valued: S Definition: The vertical distance the cave extends above the lowest point of this entrance, in metres. Usage: See notes in 59[Extent below entrance].
Data type: A Max length: 2. Coding: I Single/Multi-valued: S
Codes
Definition:
The method used in arriving at the stated vertical dimensions of
the cave or karst feature.
Usage: This field should always be completed if any of the vertical
dimension fields have been completed, but not otherwise.
Data type: N Max length: 7.2 Coding: U Single/Multi-valued: S Definition: The accuracy of the stated vertical dimensions of the cave or karst feature, stated in +/- metres. Example: If the vertical range was calculated or estimated to be between 70 and 80 metres, then the vertical range should be stated as 75 and this field as 5, i.e. 75m +/-5m.
Data type: N Max length: 8.2 Coding: U Single/Multi-valued: S Definition: The length of the largest chamber in a cave, in metres. Usage: Normally completed only for a chamber of notable size.
Data type: N Max length: 8.2 Coding: U Single/Multi-valued: S Definition: The width of the largest chamber in a cave, in metres. Usage: Normally completed only for a chamber of notable size.
Data type: N Max length: 8.2 Coding: U Single/Multi-valued: S Definition: The height of the largest chamber in a cave, in metres. Usage: Normally completed only for a chamber of notable size.
Data type: N Max length: 7.1 Coding: U Single/Multi-valued: M Definition: All pitch lengths (not rope or ladder lengths) in a cave, in metres, and listed nominally in sequence from upper to lower level.
Data type: N Max length: 8.1 Coding: U Single/Multi-valued: S Definition: The maximum overall horizontal extent of a cave or karst feature, in metres, i.e. the straight-line horizontal distance between its furthermost ends. Comment: When combined with 68[Extent width] it forms the length of the smallest horizontal rectangle which would just encompass the cave or karst feature.
Data type: N Max length: 8.1 Coding: U Single/Multi-valued: S Definition: The maximum overall horizontal width of a cave or karst feature, in metres, the width being measured in a direction at right angles to the dimension recorded in 67[Extent length]. Comment: See comment in 67[Extent length].
Data type: A Max length: 52. Coding: U Single/Multi-valued: M Definition: Further names which a cave or karst feature has or has had beyond its current name as given in 70[Principal name], and expressed in the local language. Usage: See usage notes in 70[Principal name].
Data type: A Max length: 52. Coding: U Single/Multi-valued: S Definition: The current formal agreed name for a cave or karst feature, expressed in the local language. Usage: (1) When choosing new names, be mindful of any local naming guidelines which may be in effect. (2) Where a new name is awaiting ratification, enclose it in round brackets. (3) Because this recorded name is likely to be propagated, take special care to record it with the correct spelling and form. (4) If you want the word "cave" or the like to appear in the name, include it in the field.
Data type: A Max length: 45. Coding: U Single/Multi-valued: M Definition: The surname and initials of the author(s) of a reference which is relevant to the cave or karst feature, expressed as "surname, initials". Examples: "Smith, A.B., Brown, Y.L. & White, X.A.", "Smith, A.B.", "White, X.A. et al". Usage: (1) Normally only needs to be filled in when the author surname(s) cannot be auto-filled via a lookup on 270[Article ID]. (2) If the article does not yet exist in the Articles tables, enter the surname(s) manually. (3) If more than three authors, just enter the first author and initials, plus "et al".
Data type: A Max length: 3. Coding: I Single/Multi-valued: M
Codes
Definition:
What the cave contains.
Comment:
The purpose of this field is to be the 'plain language guide' to
what is in the cave by summarising any entries in scientific
fields such as 37[Genus name], and listing any other items which do
not have a formal classification system.
Usage:
(1) If any 'scientific' field has a contents entry, include an entry
in this field also, so that this field summarises ALL contents.
(2) If a required entry in not available in the picklist, enter it
in 53[Comments] instead.
(3) In the case of sensitive items, consider including them in the
database but flagging their security level in 467[Data security level]
or suppressing this field from printing via 75[Cave list exclusion
FID].
Data type: I Max length: 5.0 Coding: U Single/Multi-valued: M Definition: The sequence number of one record among several which represent the values of a multi-valued field, and forming part of each such record's key. Example: Three records describing three different items representing the contents of a cave would have "Value sequences" of 1, 2, & 3 resp. Comments: The purpose of this field is (1) to make the key of each multi-valued record unique, and (2) to set the sequence in which the multi-valued records are stored and displayed.
Data type: A Max length: 4. Coding: U Single/Multi-valued: M Definition: The serial number component of the number of other connected caves, entrances or other karst features. Usage: (1) Usage will depend to some extent on how cave and karst feature numbers have been used, for example, whether further entrances to a cave have their own number. See the Australian 'Local help' for examples of one method.
Data type: I Max length: 6.0 Coding: I Single/Multi-valued: M
Codes
Definition:
The FID of a field for this cave which is to be excluded from the
output for a Cave List.
Comment:
(1) This would normally be because the field has the same value for
all caves in the area, and the value can therefore better be covered
for Cave List purposes in the overall Area Description. Examples
could be 7[Rock type] or 42[Owner type].
(2) However where the issue is security, see 467[Data security level].
Usage:
Enter the FID of each field for this cave which does have data in
it but whose data is not to be printed out in a Cave List.
The technique is to record this common or almost common data instead
in the Region/Area entity, so that it can appear in the area notes
preceding the cave details, and then not print it in the individual
cave details. Any caves which are an exception to the norm for the
area can omit suppression of that particular field so that their
different data does get printed in the individual listings.
However, note that this common data DOES still need to be
entered into every cave's data. This is so that each cave's data is
complete in itself, and the cave will respond correctly to a
search looking for those characteristics.
Fields which are usually candidates for suppression are:
7, 21, 22, 23, 414, 25, 26, 27, 28, 42, 49, 46, 47, 78, 13-16,
71/270, 76/431.
Fields which normally should not be suppressed are:
18, 19, 77, 1, 69/70, 74, 9, 10/20/3/4/5/6, 11, 56, 57/58, 59/60/511,
61/62, 63/64/65, 66, 67/68, 52, 50, 29, 51.
This field should normally be re-assessed at each update.
Data type: A Max length: 40. Coding: U Single/Multi-valued: S Definition: The first name, surname, and organisation of the person who most recently provided the update data for the database for this cave or karst feature, together with the date they supplied the information, as opposed to the date the original information was generated. Usage: (1) The entry should refer only to this latest update, because the system keeps track of previous updates. (2) It is good practice when supplying particular updates to review other data for the cave to see if it is still correct. Comments: (1) This field would normally only be available for users to enter a value if the database system was not using the fields available for capturing information about each update batch. (2) Normally this field would be read-only information. (3) A better alternative to this field is to use 431[Latest update ID], which derives from 421-424, which allow separate fields for Update ID, person, org, and date. (4) For the supplier of the original information itself, see 470[Data supplier - person ID] and/or 471[Data supplier - org ID] in the Data Quality fields.
Data type: A Max length: 4. Coding: U Single/Multi-valued: S Definition: The component of the Cave Number, within the given area code, which identifies the cave. Normally numeric. Does not repeat within that area code. Right-justified if numeric. Usage: (1) Do not include any karst feature letter suffix in the field.
Data type: A Max length: 2. Coding: I Single/Multi-valued: S
Codes
Definition:
The type of identification marked on this particular entrance or
karst feature.
Usage:
(1) If the mark is not the cave or entrance number, but some
other identifying mark from say a surface survey or surface
exploration, choose from codes 12-18, i.e. 'identifier' rather than
cave/entrance number.
(2) If more than one type of marking is present, choose the best.
Data type: A Max length: 50. Coding: U Single/Multi-valued: S Definition: The title given to a trip report or equivalent, published or unpublished. If the author gave no title, a nominal descriptive one may be given by the Records Keeper.
Data type: A Max length: 50. Coding: U Single/Multi-valued: S Definition: The agreed name of a karst area or region.
Data type: A Max length: 3. Coding: L Single/Multi-valued: S Definition: An alphabetic code of up to 3 letters to designate a karst area or region. Normally issued by State Speleo organisation. Comment: This is where the code is defined rather than used.
Data type: I Max length: 5.0 Coding: I Single/Multi-valued: S
Codes
Definition:
The standard international identification number for a standard
cave/karst data field. Always an integer. Issued only from the UIS
master field database.
Comments:
(1) Unlike normal data entities, standard field keys do not need
to include country and organisation codes
because they are generated only by a single master database.
(2) Non-standard fields from other databases use keys which use
principles similar to 227[Cave ID].
(3) If standard field keys are stored in the same database as
non-standard fields, then they should be prefixed by AAUIS and their
standard ID zero-filled to a width of 5 digits, e.g.
in a foreign database, Field 34 should be stored as Field AAUIS00034.
Data type: A Max length: 10. Coding: L Single/Multi-valued: S Definition: The record ID used locally by an organisation for the definition of a field they use.
Data type: I Max length: 1.0 Coding: I Single/Multi-valued: S
Codes
Definition:
For a field which has been issued by UIS, this is the local status
regardless of the UIS status.
Data type: A Max length: 8. Coding: U Single/Multi-valued: S Definition: The name of the database table where the value of the respective field is set, as opposed to used.
Data type: A Max length: 8. Coding: U Single/Multi-valued: S Definition: The filename of the master database table for an entity. Example: For the Cave entity, the master table filename in the UISIC system is CA0000.
Data type: I Max length: 5.0 Coding: U Single/Multi-valued: S Definition: The maximum number of character positions needed to contain any possible value which the field may have when its value is expressed using text characters. Example: A numeric field which has a range +/-10,000 and up to two decimal places, would need 9 character positions to ensure all values could be accomodated: (sign(1) + whole number digits(5) + decimal separator(1) + decimal digits(2) = total(9)). A date field may require a field length of 10 for text representation: (day digits(2) + day/month separator(1) + month digits(2) + month/year separator(1) + year digits(4) = total(10)). Comment: This field is needed when non-text fields are converted to text representation for transfer between databases.
Data type: I Max length: 5.0 Coding: U Single/Multi-valued: S Definition: The number of decimal places which a particular numeric field requires.
Data type: I Max length: 5.0 Coding: U Single/Multi-valued: S Definition: The character position for the start of a particular field when its table has been exported to fixed-length text format. Comment: (1) This would normally be in preparation for construction of a text-based Karst Data Interchange (KDI) file. (2) This value will vary according to the database design being used at the specific source site.
Data type: I Max length: 5.0 Coding: U Single/Multi-valued: S Definition: The sequence position (1st, 2nd, 3rd, etc) of a particular field when its table has been exported to delimited text format. Comment: As for 89[Field position when fixed]. Example: If it is the third field, then the value would be '3'.
Data type: I Max length: 1.0 Coding: I Single/Multi-valued: S
Codes
Definition:
Whether the field is of nominally 'long' or 'short' type. Long-type
is where the value in
the field could be quite long, spanning one or more lines,
and may contain delimiting characters such as commas, quotes, etc.
Short-type is where the length is quite short and limited, and does
not contain any delimiting characters.
Comment:
The main purpose for this field is to help with writing and reading
Karst Data Interchange files.
Usage:
If there is any doubt whether the field may contain delimiting
characters such as commas, quotes, etc, choose 'long' type.
Data type: I Max length: 1.0 Coding: I Single/Multi-valued: S
Codes
Definition:
Not yet ready.
Data type: I Max length: 1.0 Coding: I Single/Multi-valued: S
Codes
Definition:
The type of coding, if any, used as values for the field. The
values for this field are numeric codes.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The sequence number assigned to the SSC ID for this field in order to put the field in a convenient sequence when fields are listed by SSC ID. Can be changed at will to rearrange order of field listing.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Not yet ready.
Data type: Max length: . Coding: Single/Multi-valued: Definition: For a field definition issued by UIS, this is the UIS status of the definition.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Not yet ready.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Not yet ready.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Not yet ready.
Data type: A Max length: 12. Coding: Single/Multi-valued: S Definition: The local identification for a field on the current data-entry form. Example: ASF's local designation for Field 10 (Entrance type) is 8.1 Comment: The user is able to define the equivalence between this current local designation and the standard ID of the field. This allows a range of custom data-entry forms with their fields conveniently identified for quick data entry, yet still calling up the correct standard field.
Data type: A Max length: 12. Coding: Single/Multi-valued: S Definition: Any permanent identification used by an organisation for a field definition other than its database Record ID.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Not yet ready.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Not yet ready.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Not yet ready.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Not yet ready.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Not yet ready.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Not yet ready.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Not yet ready.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Not yet ready.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Not yet ready.
Data type: Max length: . Coding: Single/Multi-valued: Definition: This field holds allowable codes which can be entered in a data field. Normally UIS standard codes. A closed range of uncoded actual values (e.g. map sheet names) should not be entered: instead, they should be included in a lookup table.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Not yet ready.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Not yet ready.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Not yet ready.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Not yet ready.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Another table which this field appears in, apart from the table where its value is set (Field 85).
Data type: Max length: . Coding: Single/Multi-valued: Definition: Whether this instance of the field is for setting/defining its value, or for using a value already set elsewhere. This would be the case where the instance was a 'foreign key', for example. Normally a field would be set in only one place (Field 85), so that this field here should normally be set to 'used'.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Not yet ready.
Data type: Max length: . Coding: Single/Multi-valued: Definition: This is the Field ID of the key field which this field is a foreign key of.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The name of the lookup table, if any, for this field. May vary from site to site.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The maximum numeric value allowed for this field at this site.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The minimum numeric value allowed for this field at this site.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The equivalent local code, if any, for a UIS-coded field value. For example, the UIS system always uses numeric codes for coded field values, but local codes for the field might be alphabetic, e.g. letter codes for a State or a geologic formation.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The internal record ID of an organisation which uses the current field.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Not yet ready.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Not yet ready.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Not yet ready.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Not yet ready.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Not yet ready.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Not yet ready.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Not yet ready.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The identifier and database key for an Entity. It consists always of a unique pair of letters, chosen to represent as closely as possible and in as many languages as possible, the name of the entity, while remaining a unique pair.
Data type: Max length: . Coding: Single/Multi-valued: Definition: This is the version of the entity name to be used locally, and in the local language.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The quantity of characters forming the zero-filled, fixed-width, numeric part of the Record ID for instances of this entity. Example: For the Cave Record ID "AUASF00035" created by ASF in Australia, the fixed numeric width is "5". Comment: The numeric part is right-justified and zero-filled so that the alphanumeric keys will sort in numeric order.
Data type: A Max length: 8. Coding: Single/Multi-valued: Definition: The ID code assigned to a subject in the Speleological Subject Classification (SSC) System. It can be up to 8 digits long, each successive digit representing a subdivision of the subject represented by the previous digit. Its data type is alphabetic so that it will stay left-justified for proper sorting.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Not yet ready.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Not yet ready.
Data type: A Max length: 15. Coding: U Single/Multi-valued: S Definition: Not yet ready.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Not yet ready.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Not yet ready.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Not yet ready.
Data type: A Max length: 2. Coding: I Single/Multi-valued: S
Codes
Definition:
Not yet ready.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Not yet ready.
Data type: A Max length: 70. Coding: U Single/Multi-valued: M Definition: Not yet ready.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Not yet ready.
Data type: A Max length: 210. Coding: U Single/Multi-valued: S Definition: Not yet ready.
Data type: A Max length: 140. Coding: U Single/Multi-valued: S Definition: Not yet ready.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Not yet ready.
Data type: A Max length: 210. Coding: U Single/Multi-valued: S Definition: Not yet ready.
Data type: A Max length: 140. Coding: U Single/Multi-valued: S Definition: Not yet ready.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Not yet ready.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Not yet ready.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Not yet ready.
Data type: A Max length: 1. Coding: I Single/Multi-valued: S
Codes
Definition:
The code for the UIS status of a field or value definition issued
by UIS.
Data type: A Max length: . Coding: U Single/Multi-valued: S Definition: The English text for the UIS status of a field or value definition issued by UIS.
Data type: A Max length: 2. Coding: U Single/Multi-valued: S Definition: The country in which this database site is located. Usage: This field can be set only by the Central Database Administrator.
Data type: A Max length: 3. Coding: L Single/Multi-valued: S Definition: The standard three-letter code for the organisation operating this database site. Comment: (1) See also 178[Organisation code], 182[Database org code]. Usage: This field can be set only by the Regional Database Administrator.
Data type: A Max length: 2. Coding: U Single/Multi-valued: S Definition: The spoken language normally used by this database site, expressed as an ISO 2-letter language code, normally in lower case.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The plural version of text which precedes data values in a text listing.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The plural version of text which follows data values in a text listing
Data type: Max length: . Coding: Single/Multi-valued: Definition: The prompt to be inserted on the form for this field during data entry
Data type: Max length: . Coding: Single/Multi-valued: Definition: The sequence number of a line of help text for a field value.
Data type: Max length: . Coding: Single/Multi-valued: Definition: A line of local help text for a field value.
Data type: A Max length: 10. Coding: U Single/Multi-valued: S Definition: The record ID of a person adding a new field.
Data type: A Max length: 9. Coding: U Single/Multi-valued: S Definition: The record ID of the organisation the person represents who is proposing the new field.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The date when a person added a proposed new field to the database.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The status of local existing usage of a new field proposed by a user.
Data type: A Max length: 10. Coding: U Single/Multi-valued: S Definition: The temporary record ID of a person who is proposing a new coded field value for consideration by UISIC.
Data type: A Max length: 9. Coding: U Single/Multi-valued: S Definition: The temporary record ID of the organisation which the person is representing who is proposing a new coded field value.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Date when person added proposed new coded field value to database.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The status of local existing usage of a new coded field value proposed by a user.
Data type: A Max length: 10. Coding: U Single/Multi-valued: S Definition: The database temporary Record ID for a person. Similar principles to Field 177 for Organisation temporary IDs. Comment: Typically used where there is a need to record the name of a person against other data before the name of that person has been formally included in the Person Database.
Data type: A Max length: 30. Coding: U Single/Multi-valued: S Definition: Surname or family name of person being temporarily registered.
Data type: A Max length: 20. Coding: U Single/Multi-valued: S Definition: Given name of a person being temporarily registered.
Data type: A Max length: 20. Coding: U Single/Multi-valued: S Definition: Title of person being temporarily registered, e.g. Dr, Mr. Ms., etc.
Data type: A Max length: 200. Coding: U Single/Multi-valued: S Definition: The postal address of a person being temporarily registered. This is a temporary field for the whole address - later it will be split into separate fields in the UIS 'Person' database.
Data type: A Max length: 9. Coding: U Single/Multi-valued: S Definition: A database temporary Record ID for an organisation. Constructed using same principles as Field 227 Cave ID, but using the 3-letter Organisation Code of the site where it is being entered, as opposed to the code for the organisation being described. Comments: (1) Typically used where a person is entering their organisation's name into a database in response to a question, but is not the organisation operating the site database currently being used. (2) The code for the organisation may not be known, hence the code for the current site is used to identify the record in the interim. (3) This ID and the associated organisation details are stored in a separate table to the site's main Organisation Tables. (4) Eventually the organisation will be allocated a permanent formal ID and its temporary record deleted.
Data type: A Max length: 3. Coding: U Single/Multi-valued: S Definition: A 3-letter code, unique within a country, to designate an organisation within that country, and formally issued by the country's speleological community. Comment: (1) There is no requirement for the code to reflect the name or initials of the organisation, however it is obviously beneficial if, where possible, it relates to the name or initials of the organisation in that country's language. However because of the many organisations in a country, it may not always be possible to allocate the ideal code for any particular organisation. (2) This code can be used anywhere a short or fixed-length identifier is needed to uniquely specify an organisation. Example: The database internal keys to identify each cave entry need to permanently distinguish the site which initially created the entry. The Organisation Code is therefore used in the prefix in this key, i.e. the prefix is Country Code + Organisation Code. So the prefix used by the Australian Speleological Federation (Org Code = "ASF") is AU + ASF = AUASF. The rest of the ID is a serial number from a series unique to this prefix. (3) The 3-letter Organisation Code is the human-usable identification for an organisation, whereas 380[Organisation ID] is the computer-oriented internal record ID for the organisation in the database system. Usage: (1) A new Organisation Code can be issued only by the country's formally appointed person. Send the details of the new organisation so that they can be entered into the master Org database and a new code issued.
Data type: A Max length: 60. Coding: U Single/Multi-valued: S Definition: Temporary storage for the name of an organisation, expressed in its national language. Comment: Typically used when gathering data from a passing user.
Data type: A Max length: 200. Coding: U Single/Multi-valued: S Definition: Temporary storage for the complete address of an organisation, excluding the name but including the country. Comment: Used when obtaining data from a passing user, not from the site of data entry.
Data type: A Max length: 2. Coding: I Single/Multi-valued: S
Codes
Definition:
Temporary storage for the geographical coverage of an organisation,
expressed as a numeric code.
Examples: Codes for International, National, Regional or Local.
Comment: Typically used when gathering data from a passing user.
Data type: A Max length: 3. Coding: U Single/Multi-valued: S Definition: The standard 3-letter code for the organisation controlling the standards and design for the database being used at this site. Comment: See also 178[Organisation code]. Usage: This field can be set only by the Central Database Administrator.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The sequence number of a form which this field appears on.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The tablename of the detail form for this instance of the field.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The form number of the detail table for this instance of the field.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The page number of the form for this instance of the field.
Data type: Max length: . Coding: Single/Multi-valued: Definition: For a field value issued by UIS, this is the local status, regardless of its UIS status.
Data type: Max length: . Coding: Single/Multi-valued: Definition: For a field value issued by UIS, this is the UIS status.
Data type: Max length: . Coding: Single/Multi-valued: Definition: This flag becomes set if the field definition has been altered by a user since it was issued by UIS.
Data type: Max length: . Coding: Single/Multi-valued: Definition: This flag becomes set if this field value has been modified by a user since it was issued by UIS.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The code to indicate the local status of a field or value definition which has been issued by UIS, regardless of the UIS status of that definition.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The English text to indicate the local status of a field or value definition which has been issued by UIS, regardless of the UIS status of that definition.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The code to indicate the local status of a new field or value definition proposed to UIS.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The English text to indicate the local status of a new field or value definition proposed to UIS.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The unique database key for a map record. Same principles as Cave ID.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The country where the subject of the map is located, expressed as its standard 2-letter country code.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The state in which the subject of the map is located, expressed as the standard code for the state.
Data type: A Max length: 5. Coding: Single/Multi-valued: Definition: If required, the code for the main area or region covered by the map. Comments: (1) In the case of a cave map, this would be the cave area code. (2) If the map covers more than one region, further regions can be added via Field 409.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The cave serial number part of a cave map number. Right-justified to cause this alpha-numeric value to sort into numeric order.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The standard 3-letter code for the organisation which produced the map.
Data type: A Max length: 5. Coding: U Single/Multi-valued: S Definition: The map sequence number used by the organisation which issued the map number. Comment: This may or may not be the same as the organisation which produced the map, e.g. a caving club numbering a government cave map. The map producer can be recorded in 200[Map source - org code].
Data type: A Max length: 30. Coding: U Single/Multi-valued: S Definition: The name of the map, or, if a map series, then the name of the sheet. If there is no name, then a brief description. Comment: In the case of a cave map which shows only the silhouetted relationship between caves, then an entry such as 'Relates 21, 22 and 27' would be appropriate.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The code for the organisation whose survey grading system has been used to grade the survey and map.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The quality level for the survey and map chosen from a particular grading scheme.
Data type: N Max length: . Coding: U Single/Multi-valued: S Definition: The scale of the map using the system "1:scale", but omitting the "1:" from the entered data, e.g. for 1:200 enter only the 200. If the map is not to scale, enter 0 (zero). If unknown, leave empty.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Codes to indicate what types of views the map presents from among plan (P), long sections (L), and cross-sections (X). Examples: PLX = shows plan, long section, and cross-sections. PX = shows plan and cross-sections only.
Data type: A Max length: 4. Coding: U Single/Multi-valued: S Definition: The year (in full) in which the survey was done.
Data type: I Max length: . Coding: Single/Multi-valued: S Definition: The internal ID of the person principally responsible for the surveying for the map.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The name of the map source if it has a "source code" of GEN, the code for covering miscellaneous sources who do not have a specific code.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Who currently controls the original of the map, if the original source no longer does so, and if the controller does not have a record ID on this database site.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The internal Record ID of the area map on which this cave map exists, if the cave map exists only on the area map and the area map cannot be identified from the cave map number. Comment: A cave area map is here defined as a map showing the inter- relationship of two or more caves, as well as the normal definition of depicting a cave area.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Whether or not there is some restriction on access to the map.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Whether or not the map has been microfilmed.
Data type: A Max length: 25. Coding: Single/Multi-valued: S Definition: The size of the map sheet, expressed either as a standard size, or by stating its overall dimensions. Where the map consists of several sheets, state the size of an individual sheet. Examples: A4 1000mmH x 700mmV 2 x 3 ft.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The internal Record ID of the person who most recently supplied updates for this map bibliographic information.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The internal Record ID of the organisation which most recently supplied updates for this map bibliographic information. Comment: Normally this would be the organisation to which the updating person belonged.
Data type: A Max length: 4. Coding: Single/Multi-valued: S Definition: The year (in full) in which the map bibliographic information was most recently updated.
Data type: A Max length: 70. Coding: U Single/Multi-valued: M Definition: A line of comment about the map.
Data type: A Max length: 70. Coding: U Single/Multi-valued: S Definition: The publication details, in the case where the map has been published but no Article ID is yet available.
Data type: A Max length: 2. Coding: U Single/Multi-valued: S Definition: The component in the cave number which identifies the country in which the cave is located, expressed as a standard two-letter ISO country code. Usage: This country code is filled indirectly via the lookup on 303[Area lookup].
Data type: Max length: . Coding: Single/Multi-valued: Definition: Table used when the value for this field is being updated. If it is a single-valued field, then it will probably be updated directly in place in its normal table. But if it is multi-valued, then it may be done in a temporary table before being copied to its permanent table. NB: Is this still so???
Data type: Max length: . Coding: Single/Multi-valued: Definition: The form number of the form used with the table used for updating this field. (See also Field 221).
Data type: Max length: . Coding: Single/Multi-valued: Definition: The combination of country, state, and area codes which uniquely identifies an area. Generally used as a single-value-lookup for an area, e.g. AU3B for Buchan (B) area in Victoria (3) in Australia (AU). Comment: It is not generally feasible to use a lookup on area alone, because the one area code may be repeated in different States.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The country in which a defined cave or karst area is located.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The State in which a defined cave or karst area is located.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The unique database key for a defined Cave or Karst Area record. Same principles as Cave ID.
Data type: A Max length: 10. Coding: U Single/Multi-valued: S Definition: The unique database key for a cave record. It consists of the concatenation of the ISO 2-letter country code of the creating organisation, their 3-letter organisation code, and a right-justified integer serial number, zero-filled to the standard width for the entity as given in Field 134[Numeric width in keys]. Example: 35th cave for ASF in Australia: AU+ASF+00035 ==> AUASF00035 The numeric width for caves is 5 digits, hence 35 ==> 00035 Comments: (1) This ID is normally used only within a database system. (2) It is originally generated by the site creating the original record, and is retained regardless of where the record is subsequently copied to, in order to maintain the correct links between relational tables. (3) It is not the same as the "International Cave Number", which is the published national cave number, prefixed with the 2-letter country code.
Data type: A Max length: 10. Coding: U Single/Multi-valued: S Definition: The unique record ID of the owner of the cave or karst feature, if it is a person as opposed to an organisation. Usage: (1) If it is an organisation rather than a person, use Field 417[Owner - organisation ID] instead. (2) If there are no record IDs available, enter the name of the person or organisation in Field 418[Owner - name].
Data type: A Max length: 30. Coding: U Single/Multi-valued: S Definition: The name of the municipality or local-government area in which the cave or karst feature is located. Comment: This is the area based on administration or government, typically by a local council, as opposed to the area name based on land definition as found in the cadastre. Example: "Surfcoast Shire"
Data type: A Max length: 2. Coding: I Single/Multi-valued: S
Codes
Definition:
The degree to which the database is up to date for this cave or
karst feature, as opposed to the amount of data stored. Numeric coded
using the codes of generic field 512[Entity update status].
Data type: A Max length: 2. Coding: U Single/Multi-valued: M Definition: The country code in any previous cave number which this cave may have had. The country code is the 2-letter code according to international standard ISO-3166. See also 220[Country in cave number]. Usage: This field is filled indirectly via the lookup on 304[Previous area lookup].
Data type: A Max length: 2. Coding: L Single/Multi-valued: M Definition: The State code in any previous cave number which this cave may have had. See also 18[State in cave number]. Usage: This field is filled indirectly via the lookup on 304[Previous area lookup].
Data type: A Max length: 3. Coding: L Single/Multi-valued: M Definition: The area code in any previous cave number which this cave may have had. See also 19[Area in cave number]. Usage: This field is filled indirectly via the lookup on 304[Previous area lookup].
Data type: A Max length: 4. Coding: U Single/Multi-valued: M Definition: The serial number in any previous cave number which this cave may have had. See also 77[Serial in cave number].
Data type: A Max length: 2. Coding: U Single/Multi-valued: M Definition: The country component in the number of any cave or karst feature which is associated with this cave or karst feature. See also 220[Country in cave number] re country. See also 74[Cross-reference serial] re cross-referencing issues. Usage: This country code is filled indirecly via the lookup on 305[Cross-reference lookup].
Data type: A Max length: 2. Coding: L Single/Multi-valued: M Definition: The State code in the number of any cave or karst feature associated with this cave or karst feature. Usage: This field is filled indirectly via the lookup on 305[Cross-reference lookup]. See also 18[State in cave number] re state code issues. See also 74[Cross-reference serial] re cross-reference issues.
Data type: A Max length: 3. Coding: L Single/Multi-valued: M Definition: The area code in the number of any cave or karst feature associated with this cave or karst feature. Usage: This field is filled indirectly via the lookup on 305[Cross-reference lookup]. See also 19[Area in cave number] re area code issues. See also 74[Cross-reference serial] re cross-reference issues.
Data type: N Max length: 8.0 Coding: U Single/Multi-valued: M Definition: The scale of the map sheet used for giving the current grid reference of the cave, omitting the leading "1:". Example: 25000. Comment: Its field properties are the same as those for 205[Map scale] for that sheet. Usage: (1) Normally auto-supplied when you use the lookup on the Map ID, 411[Grid ref - map ID]. (2) This field needs to be actually filled in only when the map is not already in the site's map table, or the information is not otherwise automatically available via a lookup on the Map ID.
Data type: A Max length: 25. Coding: U Single/Multi-valued: M Definition: The official map number of the map used for giving the current grid reference of the cave or karst feature. Example: 4324 Comment: To qualify the grid reference, the Map Number can be used in place of the normal Grid Zone Designation and 100km-square pair of letters. Usage: (1) Normally auto-supplied when you use the lookup on the Map ID, 411[Grid ref - map ID] on this screen. (2) This field needs to be actually filled in only when the map is not already in the site's map table, or the information is not otherwise automatically available via a lookup on the Map ID.
Data type: A Max length: 8. Coding: U Single/Multi-valued: M Definition: The edition identification for the map which has been used for the current grid reference for the cave or karst feature.
Data type: N Max length: 6.0 Coding: U Single/Multi-valued: M Definition: The easting part of a grid reference for a cave or karst feature, as shown on a particular map, and expressed in the manner described on that map. Comment: The purpose of this field is to locate the item on the associated mapsheet, not to give its actual physical position. The actual position can be given using 249[Position - easting]. Usage: The associated mapsheet used should be given using 411[Grid ref - map ID], or if the map description is not yet in the site's database, using 239[Map number] and 414[Map or sheet name], on the grid ref screen. Max text length: sign(0)+whole(6)+sep(0)+dec(0) = total 6, scale 0
Data type: N Max length: 6.0 Coding: U Single/Multi-valued: M Definition: The northing part of a grid reference for a cave or karst feature, as shown on a particular map, and expressed in the manner described on that map. Comment: The purpose of this field is to locate the item on the associated mapsheet, not to give its actual physical position. The actual position can be given using 250[Position - northing]. Usage: As for Easting, 241[Grid ref - easting]. Max text length: sign(0)+whole(6)+sep(0)+dec(0) = total 6, scale 0.
Data type: A Max length: 1. Coding: I Single/Multi-valued: M
Codes
Definition:
The length units in which the grid reference for a cave or karst
feature have been given, which should be the same as those of
the associated topographic map used, but expressed as a UIS coded
value.
Data type: N Max length: 7.0 Coding: U Single/Multi-valued: M Definition: The +/- precision used in the grid reference values given in the "grid reference" fields, 241[Grid ref - easting] and 242[Grid ref - northing], for the cave or karst feature, and expressed in the same length units as that grid reference. Example: If the map units are metres, and the grid reference has been specified to the nearest +/- 1 km, then the precision would be given as "1000". Comment: The precision is how closely (number of significant digits) the grid ref has been expressed, not necessarily how accurate (true) its value is. Its accuracy can be given in field 302[Grid ref - accuracy used]. Max text length: sign(0)+whole(7)+sep(0)+dec(0) = total 7, scale 0.
Data type: N Max length: 11.7 Coding: U Single/Multi-valued: S Definition: The exact latitude of this cave entrance or karst feature, expressed as +/- degrees and decimal degrees. The sign is +ve if north of or on the Equator, or -ve if south of the Equator. Comment: Expression as a real number, rather than as degress, minutes, and seconds, simplifies location-based searches, and the geo-coding of the position in GIS systems. Example: -38.38274 Usage: The Geodetic Datum on which the latitude is based can be given in 288[Geodetic Datum used]. Max text length: sign(1)+whole(2)+sep(1)+dec(7) = total 11, scale 7.
Data type: N Max length: 12.7 Coding: U Single/Multi-valued: S Definition: The exact longitude of this cave entrance or karst feature, expressed as +/- degrees and decimal degrees. The sign is +ve if east of Greenwich or on the Prime Meridian, or -ve if west of Greenwich or on the 180th meridian. Comment: Expression as a real number, rather than as degrees, minutes, and seconds, simplifies location-based searches, and the geo-coding of the position in GIS systems. Example: 143.38543 Usage: The Geodetic Datum on which the longitude has been based can be given in 288[Geodetic Datum used]. Max text length: sign(1)+whole(3)+sep(1)+dec(7) = total 12, scale 7.
Data type: A Max length: 3. Coding: U Single/Multi-valued: S Definition: The Universal Transverse Mercator Grid Zone in which the cave or karst feature lies. Example: "55" for Grid Zone 55. Comment: (1) The Grid Zone is required in order to qualify full co-ordinate eastings and northings. (2) Sometimes the north-south Grid Zone letter is also included (giving a Grid Zone Designation of e.g. 55H), but this letter is not actually needed when full co-ordinates are given. (3) Sometimes a map sheet number is given instead of a Grid Zone in order to make a set of co-ordinates unique within a country, e.g. using 248[Position - sheet number].
Data type: A Max length: 4. Coding: U Single/Multi-valued: S Definition: The map sheet number used in order to qualify a set of eastings and northings, instead of using a Grid Zone Designation for this purpose. Comment: However, Grid Zones are more internationally useful for this purpose. Example: In Australia, the 4-figure sheet number for the relevant 1:100 000 sheet is commonly used to make a set of grid co-ordinates unique within the country.
Data type: N Max length: 10.3 Coding: U Single/Multi-valued: S Definition: The full easting co-ordinate value for the actual ground position of this cave entrance or karst feature. Comment: This is an actual ground position as opposed to a position shown on a particular mapsheet, e.g. in 241[Grid ref - easting]. Example: 497346.623 (for an easting of 497,346.623 metres). Usage: The units for the co-ordinate value should be as specified in 251[Position - grid ref units]. Max text length: sign(0)+whole(6)+sep(1)+dec(3) = total 10, scale 3.
Data type: N Max length: 12.3 Coding: U Single/Multi-valued: S Definition: The full northing co-ordinate value for the actual ground position of this cave entrance or karst feature. Comment: This is an actual ground position as opposed to a position shown on a particular mapsheet, e.g. in 242[Grid ref - northing]. Example: 6852369.432 (for a northing of 6,852,369.432 metres). Usage: The units for the co-ordinate value should be as specified in field 251[Position - grid ref units]. Max text length: sign(0)+whole(8)+sep(1)+dec(3) = total 12, scale 3.
Data type: A Max length: 1. Coding: I Single/Multi-valued: S
Codes
Definition:
The length units in which the full easting and northing positional
co-ordinates have been given, expressed as a coded value.
Data type: N Max length: 10.3 Coding: U Single/Multi-valued: S Definition: The +/- precision of the stated full easting and northing positional co-ordinates, expressed in the same length units as the co-ordinates. Example: An easting stated as 497 300 metres could have a precision of 100, 10 or 1 metre. The actual value needs to be stated. Comment: The precision says nothing about the accuracy of the stated position. Its accuracy should be stated in 300[Position - gref accuracy]. Max text length: sign(0)+whole(6)+sep(1)+dec(3) = total 10, scale 3.
Data type: A Max length: 30. Coding: U Single/Multi-valued: S Definition: The official name of the cadastral land unit in which this cave or karst feature is located, this land unit being the 4th smallest in the cadastral hierarchy. Example: In the hierarchy from smallest to largest of : allotment, section, parish, county, and state, this field would contain the name of the "county" where the cave was located, e.g. Tambo, for the County of Tambo. Comments: (1) The names of the various land unit types forming the hierarchy, e.g. County here, are defined in the Site Parameters using the multi-valued field, 293[Land unit name]. (2) These land units are distinct from "local government" or municipal subdivisions, such as shires or cities.
Data type: A Max length: 30. Coding: U Single/Multi-valued: S Definition: The official name of the cadastral land unit within which this cave or karst feature is located, this unit being the 3rd smallest in the cadastral hierarchy. Example: In the hierarchy from smallest to largest of: allotment, section, parish, county, and state, this field would contain the name of the "parish" where the cave was located. For example, "Buchan" for the Parish of Buchan within the County of Tambo. Comment: These land units are distinct from "local government" or municipal subdivisions, such as shires or cities.
Data type: A Max length: 30. Coding: U Single/Multi-valued: S Definition: The official name of the 2nd-smallest cadastral land unit within which this cave or karst feature is located. Example: In the cadastral hierarchy from smallest to largest of: allotment, section, parish, county, and state, this field would contain the name or designation of the "section" where the cave was located. For example, "F" for Section F within the Parish of Buchan. Comment: (1) The names forming the land unit hierarchy, e.g. "section" in this example, are defined in the database site parameters using Field 293[Land unit names]. (2) These cadastral land units are distinct from "local government" or municipal subdivisions, such as shires, or cities.
Data type: A Max length: 10. Coding: U Single/Multi-valued: S Definition: The designation of the smallest separately identifiable cadastral land parcel in which this cave entrance or karst feature is located. See also 255[Second-smallest land unit]. Example: "21a" for Crown Allotment 21a.
Data type: A Max length: 62. Coding: U Single/Multi-valued: M Definition: One line of the directions on how to get to the cave entrance or karst feature. As many lines as necessary may be used. Usage: Normally a narrative of how to find the cave, starting from an a readily found point. The cave's locational co-ordinates should be recorded elsewhere.
Data type: A Max length: 2. Coding: I Single/Multi-valued: M
Codes
Definition:
The situation regarding any restrictions on access to the cave.
Data type: A Max length: 10. Coding: U Single/Multi-valued: M Definition: Any database internal record IDs this cave has had in other database sytems. Example: If data for this cave had also been generated in VSA's database in Australia, then one of its "Other cave IDs" in this database here might be "AUVSA00516". Usage: This is normally a read-only field for informational purposes only. It would normally be completed only by the central database administrator.
Data type: A Max length: 4. Coding: U Single/Multi-valued: M Definition: The publication year in full for a reference or identification of a species occurrence in the cave or karst feature. Example: 1964 Usage: See Usage note in 39[Species ref - surname].
Data type: A Max length: 1. Coding: U Single/Multi-valued: M Definition: The year suffix for a reference for a species occurrence in the cave where it is necessary to distinguish between references which have the same author(s) and year. Comment: This is normally necessary only when producing a particular reference list, and it may vary per reference list. Example: "a" or "b" in the case 1964a and 1964b for the same author(s) Usage: See usage note in 39[Species ref - surname].
Data type: A Max length: 25. Coding: U Single/Multi-valued: M Definition: A comment related to a reference or an identification of a species occurrence in the cave or karst feature. Usage: See Usage comment in 40[Species significance].
Data type: A Max length: 11. Coding: U Single/Multi-valued: M Definition: The internal Article ID in the Articles database for a reference for a species occurrence in the cave. Usage: If an Articles database is part of the system, this field would be auto-filled by a lookup on the Articles database. This lookup might also auto-fill other nearby Species Ref fields.
Data type: A Max length: 5. Coding: U Single/Multi-valued: M Definition: The serial number part of a cave map number, that map having been referenced for this cave or karst feature. Example: For a map number of Australian cave 3B-16 equal to AU3B16.VSA245, this field would be "245", the map serial number. Comment: (1) This cave database field reflects the value of field 201[Map sequence number] in the map database. (2) Ideally the value for this field would be shown on the screen simply by a link to 201[Map sequence number] in the map database, via the Map ID field on this screen. A [Map sequence number] field would then not be needed in this "Widest map" table in the cave database. An actual field is needed in the cave database only when the database software does not allow such a linkage to the map database. (3) The field should be right-justified to aid sorting - it is an alpha field rather than numeric in order that letters can also be included if desired. Usage: Normally you would need to enter a value here only if: - the information was not autofilled by your lookup on the Map ID, or - the map details were not available in a map database at this site.
Data type: A Max length: 10. Coding: U Single/Multi-valued: M Definition: The database internal record ID of a map which has been referenced as giving an extensive coverage of this cave or karst feature, even though it may not be the most accurate map available of the cave. Usage: If the details of the map have not yet been entered into the map tables, then no ID will be available for lookup, so instead, enter the map's details in the other fields nearby. Similarly if there is no map database on this site.
Data type: A Max length: 4. Coding: U Single/Multi-valued: M Definition: The publication year in full for a reference which has been cited for this cave or karst feature. Example: 1987 Usage: See usage notes 1 & 2 in 71[Ref - surnames].
Data type: A Max length: 1. Coding: U Single/Multi-valued: M Definition: The year suffix for a reference cited for this cave or karst feature where it is necessary to distinguish between references which have the same author and year. Comment: This is normally necessary only when producing a particular reference list, and it may vary per reference list. Normally its value is not known until the reference list has been completed. Example: "a" or "b" in the case 1964a and 1964b for the same authors. Usage: See usage notes 1 & 2 in 71[Ref - surnames].
Data type: A Max length: 25. Coding: U Single/Multi-valued: M Definition: The subject(s) addressed in a reference cited for this cave or karst feature, expressed as key words separated by commas. Comment: The purpose is to give some quick guidance as to the relevance of the article. Examples: (1) "bones". (2) "habitation, artifacts".
Data type: A Max length: 20. Coding: U Single/Multi-valued: M Definition: The relevant page number range in a reference cited for this cave or karst feature. Examples: (1) "112-7". (2) "27, 30-4, 120".
Data type: A Max length: 11. Coding: U Single/Multi-valued: M Definition: The database internal record ID in the Articles database for a reference cited for this cave or karst feature. Blank if the article is not yet in the Articles database but the details are available for the cave database entry. Usage: This field would normally be auto-filled by a lookup on the Articles database, which might at the same time auto-fill other cave references fields on the screen.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The official number allocated to a map, or to a map sheet in a series.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The sheet name in the case where a single map is spread over several sheets. If the subsheet has no name, then enter a short distinguishing description. Comment: Do not use this field for the sheet name in a map series: instead, use Field 202 and the Map Series table.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The year in which the map was last updated, expressed in full.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The latitude of the northern main boundary of the map sheet. Format: +/- degrees.decimal degrees, e.g. -38.5 Comment: Any small extensions are handled separately.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The latitude of the southern main boundary of the map sheet. Format: +/- degrees.decimal degrees, e.g. -39.5 Comment: Any small extensions are handled separately.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The longitude of the eastern main boundary of the map sheet. Format: +/- degrees.decimal degrees, e.g. 144.75 Comment: Any small extensions are handled separately.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The longitude of the western main boundary of the map sheet. Format: +/- degrees.decimal degrees, e.g. 144.25 Comment: Any small extensions are handled separately.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The official number or code for a Map Series.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The official name of a Map Series.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The length units used on a map series, expressed as a coded value.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The officially recognised Genus name of a biological specimen.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The officially recognised Species name of a biological specimen.
Data type: A Max length: 8. Coding: U Single/Multi-valued: S Definition: Temporary storage for the officially recognised initials for an organisation. Comment: Typically used when gathering data from a passing user.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The "Alpha-2" two-letter country code according to ISO Standard 3166. Comment: Codes which ISO has designated for user allocation are AA, QM-QZ, XA-XZ, and ZZ. It is therefore proposed to use AA for "International", and XA-XZ for country regional groupings, e.g. XA = Australasia.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The country name, sometimes abbreviated, based on ISO Standard 3166, which corresponds to an Alpha-2 Country Code.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The local code for a State within a country. For example, "7" for Tasmania within Australia, or "TX" for Texas within USA.
Data type: Max length: . Coding: Single/Multi-valued: Definition: The name of a State within a country, in the local language.
Data type: A Max length: 30. Coding: U Single/Multi-valued: S Definition: The official name of the Geodetic Datum upon which actual location values for latitude, longitude and co-ordinates are based. Example: "Australian Geodetic Datum" in Australia. Usage: (1) Depending on the table structure being used at your database site, this field might appear once for the whole site, or else for each location entered. (2) This field can be set only by the Regional Database Administrator.
Data type: A Max length: 30. Coding: U Single/Multi-valued: S Definition: The official name of the Map Grid upon which the actual location co-ordinates are based, as opposed to the map grid co-ordinates given using any specific mapsheet. Example: "Australian Map Grid" in Australia. Usage: (1) Depending on the table structure being used at your database site, this field might appear once for the whole site, or else for each location entered. (2) This field can be set only by the Regional Database Administrator.
Data type: L Max length: 1. Coding: U Single/Multi-valued: S Definition: The default value for whether the database site wants the arrows which indicate the scrolling situation for the detail tables on a multi-table screen to be available or not. Comment: (1) Leaving them off allows better performance on a low-powered PC. (2) This value can be overridden for the duration of a particular session. Example: 1 = Yes, 0 = No.
Data type: L Max length: 1. Coding: U Single/Multi-valued: S Definition: The default value for whether the database site wants to have field value codes translated into the selected language on the screen during operation. Comment: (1) Leaving them off will improve performance on a low-powered PC. (2) This value can be overridden during any particular session. Example: 1 = Yes, 0 = No.
Data type: A Max length: 15. Coding: U Single/Multi-valued: M Definition: The name of one of the levels of government in the country. Comment: (1) The levels should be stored in order of size with the largest first and the smallest last. Example: In Australia there are two levels below "country" - the first is "State", and the second is "Local Government Area", i.e. municipality. Usage: This field can be set only by the Central Database Administrator.
Data type: A Max length: 15. Coding: U Single/Multi-valued: M Definition: The name of one of the series of land units used within the country to subdivide land. Comment: These should be stored in order of size with the largest first and the smallest last. Example: In the State of Victoria in Australia, land is divided first by "State", then by "County", "Parish", "Section", "Crown allotment", "LP" (lot on plan), "Lot". Usage: (1) This field can be set only by the Regional Database Administrator. (2) It is vital that once this field is set and in use, that it not be changed, because these names are also used as the screen prompts for data entry for these values for a cave or karst feature. If the relative prompts are changed, then thereafter the affected fields will contain a mixture of data, some of it wrong.
Data type: N Max length: 8.4 Coding: U Single/Multi-valued: S Definition: The precision to which the coarse geographic co-ordinates, 21[Latitude - coarse] and 22[Longitude - coarse], can be given, expressed in degrees.decimal degrees. Comment: (1) Having coarse co-ordinates available allows publication of an approximate location to enable spatial searches and reports without revealing the exact location. This field chooses the coarse precision which is suitable for coarse lat/longs in this country. Example: In Australia the precision used is 0.0833 degrees (5 minutes). Max text length: sign(1)+whole(2)+sep(1)+dec(4) = total 8, scale 4. Usage: This field can be set only by the Central Database Administrator.
Data type: N Max length: 10.3 Coding: U Single/Multi-valued: S Definition: The precision to which the coarse grid references, 26[Grid reference - coarse], can be given, using the same units as the grid references. Comment: Having coarse co-ordinates available allows publication of an approximate location to enable spatial searches and reports without revealing the exact location. This field chooses the coarse precision which is suitable for coarse grid refs in this country. Example: In Australia coarse grid references are given to a precision of 10 000 metres (10km). Max text length: sign(0)+whole(6)+sep(1)+dec(3) = total 10, scale 3. Usage: This field can be set only by the Central Database Administrator.
Data type: A Max length: 1. Coding: I Single/Multi-valued: S
Codes
Definition:
The length units in which the coarse grid references are given,
expressed as a coded value.
Usage:
This field can be set only by the Central Database Administrator.
Data type: A Max length: 1. Coding: I Single/Multi-valued: S
Codes
Definition:
The broad length grouping to which the cave belongs, expressed as
a coded value ranging from 0 to 9, 0 meaning of unknown category.
Comment:
(1) These categories are based on those currently being used in the
Austrian cave database system.
(2) Benefits of this field include (1) often enabling a cave to be
length-classified before the actual length is known, (2) reducing
length updating load in national/central databases where the latest
actual length is stored with the local club, (3) forming part of a
convenient size category field 528[Size category] which concatenates
297[Length category] and 527[Depth category].
Data type: A Max length: 1. Coding: I Single/Multi-valued: S
Codes
Definition:
A generic coded field which can be used for translating the coded
values used by any field containing codes which specify the units
of length used.
Usage:
UIS fields related to length measurement will already specify the
unit to be used, i.e. the units are always fixed for a particular
field, so this field is not needed. However, where a field is
describing lengths set outside our control, e.g. the grid units used
on a government-produced topographic map, then the field's length
units are not pre-determined and so a further field is needed to
specify the length units used. Having length units fixed for a
particular field greatly simplifies data transfers; a further
possibility would be separate fields for different units (not
recommended!).
Data type: A Max length: 1. Coding: I Single/Multi-valued: S
Codes
Definition:
A generic coded field which can be used for translating the codes
used by any length unit field into abbreviations for the length units.
Data type: N Max length: 10.3 Coding: U Single/Multi-valued: S Definition: The +/- accuracy of the stated full easting and northing positional co-ordinates, expressed in the same length units as the co-ordinates. Example: An easting stated as 497 300 metres could have an accuracy ranging from + or - hundreds of metres down to + or - 1 metre. The accuracy needs to be stated. Comment: The accuracy says nothing about the precision with which the value has been stated. Its precision should be stated in 252[Position - gref precision]. Max text length: sign(0)+whole(6)+sep(1)+dec(3) = total 10, scale 3.
Data type: Max length: . Coding: Single/Multi-valued: Definition: Flag to show that this field cannot be included among those which are to be suppressed from a cave listing. (Many fields can be suppressed from a listing because they have the same value for every cave in an area, and can instead be covered in the area part of the listing. They must still be stored in the database however to enable searches on their value.)
Data type: N Max length: 7.0 Coding: U Single/Multi-valued: M Definition: The +/- accuracy of the grid reference values given for the cave or karst feature in the "grid ref" fields, 241[Grid ref - easting] and 242[Grid ref - northing], and expressed in the same length units as that grid reference. Example: If the map units are metres, and the accuracy of the given grid reference is +/- 50m, then enter the accuracy as "50". Comment: The accuracy is how close the given value is to the true value, not how precisely (number of significant digits) it has been expressed. The precision can be given in 244[Grid ref - precision used]. Max text length: sign(0)+whole(7)+sep(0)+dec(0) = total 7, scale 0.
Data type: A Max length: 7. Coding: L Single/Multi-valued: S Definition: An auxiliary field to aid using a lookup table for a cave area. To make it unique it concatenates country+state+area codes. See also 223[Area designation], which is the lookup for this field.
Data type: A Max length: 7. Coding: L Single/Multi-valued: M Definition: An auxiliary field to aid the use of an area code lookup for 'previous cave numbers'. To make it unique it concatenates country+state+area codes. See also 223[Area designation], which is the lookup for this field.
Data type: A Max length: 7. Coding: L Single/Multi-valued: M Definition: An auxiliary field to aid the use of an area lookup table on Cross-references. To make it unique it concatenates country+state+area codes. See also 223[Area designation], which is the lookup for this field.
Data type: A Max length: 8. Coding: U Single/Multi-valued: S Definition: The name of an auxmaster table. Enables each auxmaster table to be kept up to date with its respective entity ID. This field will appear in the auxmaster table for each entity, e.g. for caves, will appear in CA0000x0.
Data type: A Max length: 11. Coding: U Single/Multi-valued: S Definition: The uni