UIS Cave and Karst Data Fields - Draft

This version generated on 7-Nov-2000

Caution: The material below is under preparation and has not yet been released for discussion. Its details are being changed.

This is the current full list of the draft cave and karst data fields under discussion as referred to in the Cave Data Exchange Proposal of the Informatics Commission (UISIC) of the International Union of Speleology. It is part of UISIC's project to facilitate data exchange between different cave/karst databases. When the definitions have been finalised in English, they will be translated to other languages.

The list will be updated as discussion proceeds.

Further fields will be added whenever necessary. The fields and their definitions and coded values will be discussed, one group at a time, via the CaveData mailing list prior to circulation to UISIC delegates for voting. The first group for discusion will be "basic" fields used by most databases.

In this initial full list, the fields have been grouped firstly according to the entity they belong to (such as caves, maps, articles, etc), and then by their subject, according to UISIC's interim Speleological Subject Classification (SSC) scheme.

For each field listed below, its Standard Field ID (FID) and the English version of its fieldname are shown. Its draft definition is linked to the Field ID, and then its coded values, where used, are linked to its definition.

[ Contents ] [ Definitions ] [ Field value codes ] [ Tables ] [ UISIC ] [ UIS ] [ ASF ]


Contents

The entity to which the field belongs:
    AR  Article
    AT  Attribute/Field
    AV  Attribute Value
    CA  Cave or karst feature
    EN  Entity
    JN  Journal
    OR  Organisation
    PA  Land Parcel
    PE  Person
    PH  Photograph
    PL  Plan/Map
    PM  Permanent Mark
    PS  Map Series
    RE  Region/Area
    RP  Report
    SM  Specimen
    SP  Species
    ST  Site/Place
    SU  Subject
    SY  System
    XK  Key-in Batch
    XL  Upload Batch
    XU  Update Batch

Entity : AR : Article


AR : 20 : REGIONAL SPELEOLOGY - GENERAL AND WORLD
319   Country where published
AR : 810 : TOPOGRAPHY - GENERAL
321   State supplying this ref
314   Book publisher and city
AR : 812 : CARTOGRAPHY
317   Quantity of maps
AR : 816 : DIMENSIONS
315   Page range or quantity
AR : 82 : TOPONYMY, TERMINOLOGY, TAXONOMY
335   Ref - name of article
311   Ref - name of publication
328   SSC code
AR : 831 : BIBLIOGRAPHIES
316   Bibliography present?
322   Type of publication
323   Local abstract year
324   Local abstract category
325   Local abstract reference
326   BBS year
327   BBS sequence number
333   Article comment
AR : 841 : PHOTOGRAPHY
318   Quantity of plates
AR : 862 : DATA STORAGE
334   Compacted surnames
329   Flag if surname overflow
AR : 866 : DATA QUALITY
331   Author surname
332   Author initials
330   Author sequence
310   Book author or editor
308   Ref - year of publication
309   Ref - suffix to year
AR : 87 : IDENTIFICATION SYSTEMS
307   Article ID
312   Ref - volume number
313   Ref - issue number
320   ISSN or ISBN
[ Contents ] [ Top ]

Entity : AT : Field


AT : 45 : ORGANISATIONS
124   Organisation ID
126   Date org started field
129   Date org started fld val
AT : 816 : DIMENSIONS
87    Field length when text
88    Field scale
91    Length type
AT : 82 : TOPONYMY, TERMINOLOGY, TAXONOMY
102   Field name - full
103   Field name - short
141   SSC ID
94    SSC ID seq
142   Entity ID of field owner
92    Data type
95    Single or multi-valued
93    Coding type
AT : 862 : DATA STORAGE
85    Table where value set
116   Field also in table
115   Table usage seq
117   Value set or used here?
120   Local lookup table name
513   Field ID used for codes
221   Master table if updating
222   Form number when updating
118   Primary/secondary key?
119   A foreign key of key ID
89    Field position when fixed
90    Field seq when delimited
161   Data-entry prompt
504   Field design comment line
108   Field definition line
107   Field definition seq
110   Field help text line
109   Field help text seq
111   Field value code
123   Field value local code
112   Field value translation
114   Field value defn line
113   Field value defn seq
121   Value numeric range MAX
122   Value numeric range MIN
163   Field value help line
162   Field value help seq
125   System field used in
128   Field usage comment line
127   Field usage comment seq
131   Fldval usage comment line
130   Fldval usage comment seq
AT : 863 : DATA ANALYSIS. REPORTING
104   Pre-data text (singular)
159   Pre-data text (plural)
105   Post-data text (singular)
160   Post-data text (plural)
106   Between-data text
301   Field is not suppressible
AT : 865 : DATA SECURITY
97    Transfer to Level 1 OK
98    Transfer to Level 2 OK
99    Transfer to Level 3 OK
AT : 866 : DATA QUALITY
164   Person adding new field
165   Person's organisation
166   Date of adding new field
167   Local status of new field
168   Person adding new value
169   Person's organisation
170   Date of adding new value
171   Local status of new value
96    UIS status of UIS field
188   UIS status of UIS value
84    Local status of UIS field
187   Local status of UIS value
189   Flag if field modified
190   Flag if value modified
AT : 87 : IDENTIFICATION SYSTEMS
82    Standard short field ID
83    Local field ID
100   Local field designation
101   Local field code
405   Other field ID
[ Contents ] [ Top ]

Entity : CA : Cave


CA : 11 : KARSTOLOGY
1     Karst feature type
532   Entrance feature type
CA : 112 : HYDROLOGY
2     Submersion
3     Flow presence
4     Flow direction
5     Internal flow
6     Internal water
CA : 113 : GEOLOGY AND PEDOLOGY
7     Rock type
CA : 121 : MORPHOLOGY AND SPELEOGENESIS IN CARBONATE ROCKS
8     Cave type
11    Development
531   Orientation
10    Entrance type
533   Entrance development
9     Quantity of entrances
CA : 123 : SUBTERRANEAN DEPOSITS AND FILLINGS
12    Decoration
CA : 124 : SUBTERRANEAN CLIMATOLOGY
13    Minimum temperature
14    Maximum temperature
15    Minimum humidity
16    Maximum humidity
17    Moisture level
CA : 20 : REGIONAL SPELEOLOGY - GENERAL AND WORLD
220   Country in cave number
235   Cross-reference country
231   Previous country
CA : 330 : REGIONAL BIOSPELEOLOGY - GENERAL AND WORLD
364   Specimen ID
37    Genus name
509   Genus confidence level
38    Species name
510   Species confidence level
40    Species significance
263   Species ref - article ID
39    Species ref - surname
260   Species ref - year
261   Species ref - year suffix
262   Species ref - comment
CA : 60 : APPLIED SPELEOLOGY - GENERAL
41    Cave use
72    Contents
CA : 63 : LAW, PROTECTION
228   Owner - person ID
418   Owner - name
417   Owner - organisation ID
42    Owner type
229   Local government area
258   Access status
46    Protection methods
43    Damage
CA : 64 : RECREATION, TOURISM, GEOSYSTEM
44    Management classifier
45    Management category
47    Controller
48    Importances
49    Surface use
CA : 71 : EXPLORATION
530   Cave description memo
525   Cave description line
534   Entrance description memo
535   Entrance description line
20    Penetrability
51    Prospects
29    Degree explored
30    Discoverer type
419   Discoverer - person ID
522   Discoverer surname
523   Discoverer firstname
420   Discoverer - org ID
524   Discoverer - org initials
31    Discoverer name
36    Discoverer date
477   Discoverer date qualifier
32    Discoverer day
33    Discoverer month
34    Discoverer year
35    Extension discovery
50    Difficulties
52    Hazards
CA : 80 : DOCUMENTATION - GENERAL
53    Comments
CA : 810 : TOPOGRAPHY - GENERAL
18    State in cave number
19    Area in cave number
303   Area lookup
232   Previous state
233   Previous area
304   Previous area lookup
27    Nearest locality
257   Directions to find cave
542   Entrance land parcel ID
441   Fifth-smallest land unit
253   Fourth-smallest land unit
254   Third-smallest land unit
255   Second-smallest land unit
256   Smallest land unit
365   Special land parcel
439   Land unit - coarse
21    Latitude - coarse
22    Longitude - coarse
23    Map sheet name - coarse
26    Grid reference - coarse
25    Gr.ref qualifier - coarse
24    Topo 100K sheet name
411   Grid ref - map ID
414   Map or sheet name
239   Map number
238   Map scale
240   Grid ref - map edition
241   Grid ref - easting
242   Grid ref - northing
243   Grid ref - units
244   Grid ref - precision used
302   Grid ref - accuracy used
245   Position - latitude
246   Position - longitude
514   Position - geog precision
515   Position - geog accuracy
247   Position - grid zone
248   Position - sheet number
249   Position - easting
250   Position - northing
251   Position - grid ref units
252   Position - gref precision
300   Position - gref accuracy
28    Altitude - coarse
442   Altitude
443   Altitude - units
444   Altitude - precision +/-
445   Altitude - accuracy +/-
CA : 812 : CARTOGRAPHY
54    Percent mapped
265   Map ID
55    Map source - org code
518   Map numberer org code
264   Map sequence number
359   Map or sheet name
360   Map & survey grade org
361   Map & survey grade value
362   Map scale
363   Dates of surv/issue/amend
CA : 816 : DIMENSIONS
297   Length category
527   Depth category
528   Size category
56    Length
57    Length method
58    Length accuracy
511   Vertical extent
59    Extent below entrance
60    Extent above entrance
61    Vertical method
62    Vertical accuracy
63    Length of largest chamber
64    Width of largest chamber
65    Height of largest chamber
67    Extent length
68    Extent width
66    Pitches
CA : 82 : TOPONYMY, TERMINOLOGY, TAXONOMY
70    Principal name
69    Other names
CA : 831 : BIBLIOGRAPHIES
270   Article ID
71    Ref - surnames
266   Ref - year of publication
267   Ref - suffix to year
355   Ref - name of article
356   Ref - name of publication
357   Ref - volume number
358   Ref - issue number
269   Ref - relevant page range
268   Ref - subjects
CA : 841 : PHOTOGRAPHY
540   Cave photo ID
CA : 862 : DATA STORAGE
236   Cross-reference state
237   Cross-reference area
74    Cross-reference serial
305   Cross-reference lookup
CA : 863 : DATA ANALYSIS. REPORTING
75    Cave list exclusion FID
CA : 865 : DATA SECURITY
467   Data security level
CA : 866 : DATA QUALITY
230   Update status
447   Data awaits uploading
461   Values qty before upload
462   Values qty after upload
463   Qty of new/changed values
519   Updating organisation ID
460   Field ID updated
469   Type of update
464   Value ID
465   Data source type
466   Data confidence level
468   Data - reference ID
520   Data - key-in ID
521   Data - upload ID
470   Data supplier - person ID
471   Data supplier - org ID
476   Data date
472   Data date - year
473   Data date - month
474   Data date - day
475   Data date - qualifier
76    Latest update by
431   Latest update ID
432   Latest update - person
433   Latest update - org code
434   Latest update - date
435   Latest key-in ID
436   Latest key-in - person
437   Latest key-in start date
448   Latest key-in end date
456   Latest upload ID
457   Latest upload - person
458   Latest upload - org code
459   Latest upload - date
CA : 87 : IDENTIFICATION SYSTEMS
227   Cave ID
259   Other cave IDs
77    Serial in cave number
234   Previous serial
78    Entrance marking
538   Entrance photoID - tag
536   Entrance photoID - near
537   Entrance photoID - locale
[ Contents ] [ Top ]

Entity : EN : Entity


EN : 82 : TOPONYMY, TERMINOLOGY, TAXONOMY
151   Entity name - English
152   Entity name - French
153   Entity name - German
133   Local short entity name
EN : 862 : DATA STORAGE
86    Master table filename
134   Numeric width in keys
438   Site current maximum ID
EN : 87 : IDENTIFICATION SYSTEMS
132   Entity ID
[ Contents ] [ Top ]

Entity : OR : Org


OR : 20 : REGIONAL SPELEOLOGY - GENERAL AND WORLD
376   Organisation country code
506   Country name
395   Address country code
OR : 45 : ORGANISATIONS
382   Organisation defunct Y/N
383   Final year if defunct
OR : 810 : TOPOGRAPHY - GENERAL
385   Address line
386   Address line 1
387   Address line 2
388   Address line 3
389   Address line 4
392   City
377   State code
505   State abbreviation
378   Postcode
379   Postcode first Y/N
393   Organisation coverage
181   Org coverage - temporary
180   Org address - temporary
OR : 82 : TOPONYMY, TERMINOLOGY, TAXONOMY
391   Organisation name
381   Organisation type
394   Organisation grouping
179   Org name - temporary
283   Org initials - temporary
OR : 87 : IDENTIFICATION SYSTEMS
380   Organisation ID
178   Organisation code
390   Organisation initials
384   Current org ID if defunct
416   Initials of current org
177   Org ID - temporary
[ Contents ] [ Top ]

Entity : PA : Landparcel


PA : 87 : IDENTIFICATION SYSTEMS
541   Official land parcel ID
[ Contents ] [ Top ]

Entity : PE : Person


PE : 20 : REGIONAL SPELEOLOGY - GENERAL AND WORLD
492   Country name
493   Country code
PE : 45 : ORGANISATIONS
501   Organisation code 1
502   Organisation code 2
503   Organisation code 3
PE : 810 : TOPOGRAPHY - GENERAL
484   Address line 1
485   Address line 2
486   Address line 3
487   Address line 4
488   City or suburb
489   State abbreviation
490   State code
491   Postcode
494   Email address
495   Phone numbers prefix
496   Home phone number
497   Work phone number
498   Mobile phone number
499   Fax phone number
500   Pager phone & user number
176   Person address - temp
PE : 82 : TOPONYMY, TERMINOLOGY, TAXONOMY
479   Surname
480   Usual first name
481   Middle initial
482   Initials for given names
483   Title
410   Person type
173   Surname - temporary
174   Given name - temporary
175   Title - temporary
PE : 87 : IDENTIFICATION SYSTEMS
478   Person ID
172   Person ID - temporary
[ Contents ] [ Top ]

Entity : PL : Map


PL : 20 : REGIONAL SPELEOLOGY - GENERAL AND WORLD
196   Map scope - country code
368   Map scope - other country
PL : 810 : TOPOGRAPHY - GENERAL
197   Map scope - state code
198   Map scope - area code
274   Map scope - N latitude
275   Map scope - S latitude
276   Map scope - E longitude
277   Map scope - W longitude
369   Map scope - other state
409   Map scope - other area
397   Map scope - other N lat
398   Map scope - other S lat
399   Map scope - other E long
400   Map scope - other W long
PL : 812 : CARTOGRAPHY
206   Map views shown
218   Map comment
PL : 816 : DIMENSIONS
205   Map scale
214   Map sheet size
404   Map sheet quantity
PL : 82 : TOPONYMY, TERMINOLOGY, TAXONOMY
202   Map or sheet name
272   Map subsheet name
367   Map type
PL : 832 : CATALOGUES
219   Map publication - no ID
PL : 862 : DATA STORAGE
211   Map host area map ID
213   Map microfilmed Y/N
403   Map digitised Y/N
PL : 865 : DATA SECURITY
407   Map controller person ID
406   Map controller org ID
210   Map controller if no ID
408   Map controller comment
212   Map restricted Y/N
PL : 866 : DATA QUALITY
370   Map source - country
396   Map source - type
200   Map source - org code
209   Map source if no ID
517   Map numberer org code
207   Map survey year
401   Map issue year
273   Map update year
208   Map surveyor ID
402   Map drafter ID
203   Map & survey grade org
204   Map & survey grade value
215   Map biblio updater ID
216   Map biblio updater org ID
217   Map biblio updater year
PL : 87 : IDENTIFICATION SYSTEMS
195   Map ID
271   Map number
199   Map cave serial number
201   Map sequence number
366   Map series ID
[ Contents ] [ Top ]

Entity : PS : Mapseries


PS : 816 : DIMENSIONS
280   Map series length units
373   Map series scale
PS : 82 : TOPONYMY, TERMINOLOGY, TAXONOMY
279   Map series name
PS : 831 : BIBLIOGRAPHIES
374   Map series publisher ID
PS : 87 : IDENTIFICATION SYSTEMS
371   Map series ID
278   Map series code
372   Map series abbreviation
[ Contents ] [ Top ]

Entity : RE : Area


RE : 20 : REGIONAL SPELEOLOGY - GENERAL AND WORLD
224   Area country
RE : 810 : TOPOGRAPHY - GENERAL
225   Area state
RE : 82 : TOPONYMY, TERMINOLOGY, TAXONOMY
80    Area name
RE : 87 : IDENTIFICATION SYSTEMS
226   Area ID
81    Area code
223   Area designation
[ Contents ] [ Top ]

Entity : RP : Report


RP : 82 : TOPONYMY, TERMINOLOGY, TAXONOMY
79    Report title
[ Contents ] [ Top ]

Entity : SP : Species


SP : 82 : TOPONYMY, TERMINOLOGY, TAXONOMY
281   Genus name
282   Species name
[ Contents ] [ Top ]

Entity : SU : Subject


SU : 80 : DOCUMENTATION - GENERAL
146   Subject descrip - English
149   Subject descrip - French
147   Subject instr - English
150   Subject instr - French
144   Subject comment line
143   Subject comment sequence
SU : 82 : TOPONYMY, TERMINOLOGY, TAXONOMY
145   Subject name - English
148   Subject name - French
SU : 866 : DATA QUALITY
140   SSC status
139   SSC attention needed?
SU : 87 : IDENTIFICATION SYSTEMS
135   SSC ID
138   SSC designation
136   SSC parent ID
137   SSC grandparent ID
[ Contents ] [ Top ]

Entity : SY : System


SY : 20 : REGIONAL SPELEOLOGY - GENERAL AND WORLD
156   Site country code
284   Country code ISO-3166
285   Country name
SY : 810 : TOPOGRAPHY - GENERAL
286   State code
287   State name
354   State abbreviation
292   Government level name
293   Land unit name
288   Geodetic Datum used
289   Map Grid used
516   Height Datum used
440   Coarse - land unit name
294   Coarse - geogr. precision
295   Coarse - gr.ref precision
296   Coarse - grid ref units
412   Coarse - map series
413   Coarse - gr.ref qualifier
446   Coarse - altitude units
526   Coarse altitude precision
SY : 816 : DIMENSIONS
298   Length units
299   Length units abbreviation
SY : 831 : BIBLIOGRAPHIES
336   Local abstracts name
337   Local abstracts initials
SY : 861 : DATA COLLECTING
415   Agent type
SY : 862 : DATA STORAGE
73    Value sequence
375   Sequence for lookup
183   Form seq
184   Detail form tablename
185   Detail form form number
186   Page number of form
306   Auxmaster name
290   Table scroll arrows Y/N
291   Code translations Y/N
338   AT coding-type code
339   AT coding-type text
340   Field length-type code
341   Field length-type text
344   AT cardinality code
345   AT cardinality text
346   Value set code
347   Value set text
348   AT data-type code
349   AT data-type text
SY : 863 : DATA ANALYSIS. REPORTING
350   Language code ISO-639
351   Language text
158   Site default language
SY : 866 : DATA QUALITY
157   Site organisation code
182   Database org code
539   Program version number
529   Software upgrade level
154   UIS status UIS code
155   UIS status UIS text
191   Local status UIS code
192   Local status UIS text
193   Local status new code
194   Local status new text
342   Key status code
343   Key status text
352   SSC update-status code
353   SSC update-status text
507   Data confidence level
508   Data confidence symbol
512   Entity update status
[ Contents ] [ Top ]

Entity : XK : Key-in


XK : 866 : DATA QUALITY
428   Key-in - person ID
430   Key-in - person
429   Key-in - start date
449   Key-in - end date
XK : 87 : IDENTIFICATION SYSTEMS
427   Key-in ID
[ Contents ] [ Top ]

Entity : XL : Upload


XL : 866 : DATA QUALITY
451   Upload - person ID
454   Upload - person
452   Upload - organisation ID
455   Upload - org code
453   Upload - date
XL : 87 : IDENTIFICATION SYSTEMS
450   Upload ID
[ Contents ] [ Top ]

Entity : XU : Update


XU : 866 : DATA QUALITY
422   Update - person ID
425   Update - person
423   Update - organisation ID
426   Update - org code
424   Update - date
XU : 87 : IDENTIFICATION SYSTEMS
421   Update ID
[ Contents ] [ Top ]
This page copyright © 1998-2000 Peter Matthews. May be reproduced for non-commercial use provided this copyright paragraph is retained. This ongoing development of field definitions etc is being conducted by the Informatics Commission (UISIC) of the International Union of Speleology (UIS). The Australian Speleological Federation's ( ASF) national Karst Index Database is being used as a pilot.
This page: http://rubens.its.unimelb.edu.au/~pgm/uisic/exchange/atenlist.html
Updated: 7-Nov-2000.
P. Matthews | Email: matthews@melbpc.org.au