SWERB Data

ADCODES (SWERB Ascent and Descent relationships)

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.

Vocabulary For

ADCODES defines values for SWERB_LOC_DATA.ADcode.

Key Name: 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.

Special Values

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.[248]

The value N is used by the SWERB_UPLOAD view when recording a drinking event.

The ADN column

The values of this column have special meaning to the system. The allowed values are:

A

This ADcode indicates that the group has ascended into a sleeping grove.

D

This ADcode indicates that the group has descended from a sleeping grove.

N

This ADcode indicates that the landscape feature was not used as a sleeping grove.

This column cannot be changed and must not be NULL.[249]

The Time column

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.

PLACE_TYPES (codes for various landscape features)

The different kinds of landscape features.

Note

This table exists to allow for landmarks other than groves and waterholes.

Vocabulary For

PLACE_TYPES defines values for SWERB_GWS.Type.

Key Name: Place

Code identifying the kind of place.

Special Values

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.

PREDATORS (codes for observed predators)

The different kinds of predators that may be seen in the field.

Vocabulary For

PREDATORS defines values for SWERB_DATA.Predator.

Key Name: Predator

Code identifying the type[250] of predator.

Special Values

None.

SWERB_LOC_CONFIDENCES (SWERB Location Confidence Values)

This support table lists the possible confidence scores used when analyzing the accuracy of locations noted in SWERB data.[251]

Vocabulary For

SWERB_LOC_CONFIDENCES defines values for SWERB_LOC_DATA_CONFIDENCES.Confidence.

Key Name: Confidence

Code used to indicate confidence in the accuracy of an observation of a location.

Special Values

None.

SWERB_LOC_STATUSES (SWERB Location Statuses)

This support table lists the possible different statuses for the observations of specified loacations in SWERB data.

Vocabulary For

SWERB_LOC_STATUSES defines values for SWERB_LOC_DATA.Loc_Status.

Key Name: Loc_Status

Code used to indicate the status of the observation of a location.

Special Values

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.

SWERB_TIME_SOURCES (SWERB Time Sources)

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.

Vocabulary For

SWERB_TIME_SOURCES defines values for SWERB_BES.Bsource, and SWERB_BES.Esource.

Key Name: Source

Code for the source used when estimating the time.

Special Values

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.

SWERB_XYSOURCES (SWERB Time Sources)

The different sources from which UTM XY coordinates were obtained for landscape features.

Vocabulary For

SWERB_XYSOURCES defines values for SWERB_GW_LOC_DATA.XYSource.

Key Name: XYSource

Code for the source used when estimating the time.

Special Values

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.



[248] 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.

[249] 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.

[250] These divisions into different "types" could be subdivided separated by species, genus, or something more arbitrary. A decision for data managers.

[251] See SWERB_LOC_DATA_CONFIDENCES for more info about these analyses.


Page generated: 2022-09-15T15:33:33-04:00.