The possible relationships between baboon groups and sleeping groves; whether there is such a relationship and if so whether it the group descended from the grove or ascended into it.
The system uses the ADN column value to enforce data integrity rules.
ADCODES defines values for SWERB_LOC_DATA.ADcode.
Code used to designate the existence and type of relationship between groups and sleeping groves.
This column cannot be changed and must not be
NULL.
The values A
and D are used by
the SWERB_UPLOAD view. These 2 codes must
require SWERB_LOC_DATA.ADtime values -- the
ADCODES.Time values must be
TRUE.[221]
The value N is
used by the SWERB_UPLOAD view when
recording a drinking event.
The values of this column have special meaning to the system. The allowed values are:
A
The ADcode indicates that the group has ascended into a sleeping grove.
N
The ADcode indicates that the landscape feature was not used as a sleeping grove.
This column cannot be changed and must not be
NULL.[222]
The values of this column have special meaning to the system. The allowed values are:
TRUE
The related SWERB_LOC_DATA
rows must have non-NULL ADtime values.
FALSE
The related SWERB_LOC_DATA
rows must have NULL ADtime values.
This column may not be NULL.
The different kinds of landscape features.
This table exists to allow for landmarks other than groves and waterholes.
The following special codes can only be altered by suitably privileged individuals. See Special Values.
Special PLACE_TYPES codes
W
Code used for a waterhole or rain pool.
G
Code used for a grove.
The possible different levels of confidence in the locations on record.
SWERB_LOC_CONFS defines values for SWERB_LOC_DATA.Conf.
The code C means
certain. It is the default used by the SWERB_UPLOAD when there is no other indication
of certainty.
The code P means
probable. It used by the SWERB_UPLOAD
when there is an indication in the data that the sleeping
grove is not identified with 100% certainty.
The different sources from which times or time estimates were obtained of the SWERB daily group observation starting and ending times. These are the times used when each group began to be observed for the day and when observation of the group was finished for the day when, for some reason, begin or end times were not recorded directly in SWERB.
The code G is
used by the SWERB_UPLOAD view when
uploading data obtained from the GPS units in the
field.
The code
NR indicates that there is no
record of any time source. When this code is used the
related time value must be NULL and the
estimated time flag must be FALSE. See
the explanation in the
SWERB_BES documentation for further
detail.
The different sources from which UTM XY coordinates were obtained for landscape features.
SWERB_XYSOURCES defines values for SWERB_GW_LOC_DATA.XYSource.
The value quad is
prohibited from use because this value is used by the SWERB_GW_LOCS view as a XYSource value and intermingled
there with SWERB_XYSources.XYSource values.
[221] Otherwise missing SWERB_LOC_DATA.ADtime values might not be detected in those cases where the data entry protocol calls for 2 waypoints to record sleeping grove information but only 1 waypoint was entered.
[222] In the unlikely event that this column must be changed the following procedure can be followed: Create a new, temporary, ADCODES value with the changed ADN column. Update the SWERB_LOC_DATA table to use the new code. Delete the old code. Re-create the old code with the desired ADN value. Again update SWERB_LOC_DATA to use the re-created code. Delete the temporary ADCODES value.
Because it is unlikely that existing ADCODES.ADN values will need to change it was not thought worthwhile to do the work involved in adding the integrity checking rules to the database which would allow the ADN value to be changed.