LOCATIONS_GPS (spatial LOCATIONS in UTM coordinates)

Contains one row for each moment in time the spatial location of an individual was taken, and recorded in UTM coordinates.

The system will generate a warning if the community of the follow related to the location information, or that of the WATCHES row that exists to support the location record, is not the comm unity associated with the location record. This means, if the LOCATIONS_GPS.CommID is not the WATCHES.CommID of the related WATCHES row.

EID (Event IDentifier)

The EVENTS.EID identifying the spatial map location event. A unique, automatically generated, positive integer which serves to identify the row. The value of this column cannot be changed. The related event contains information on the time associated with the location, and the related WATCHES row information on the located individual and the date.

This column may not be NULL.

X (X utm coordinate)

The X coordinate of the (UTM WGS84 encoded) location. An integer between 79246 and 9486544, inclusive. This column may not be NULL.

Y (Y utm coordinate)

The Y coordinate of the (UTM WGS84 encoded) location. An integer between 791268 and 9503828 inclusive. This column may not be NULL.

Elevation

The elevation of the location, in meters. An integer between sdb_min_elevation_utm and sdb_max_elevation_utm inclusive. This value may be NULL when there is no elevation information.

CommID

A code for the community the observers associated with the location record; the COMM_IDS.CommID of the community. This is not necessarily the community the individual is a member of, although it usually is.

Note

This is not the canonical source of information on the focal’s community at the time of observation or the community under observation when the data was collected. It may, in fact, differ from the community recorded elsewhere.

This column exists because of the way the community was recorded in the old MS Access database. There, the community was recorded twice, once in the follow and again with the record of location.

When there is no related follow, there is still a related WATCHES row that exists solely to provide information concerning location data. In this case the community information in the WATCHES row was initially the same as the value of this column. But the data could change and become out of sync.

This column exists so no information was lost in the conversion of the MS Access data to SokweDB. At some point in the future, perhaps when all inconsistencies between the value of this column and the community information recorded elsewhere are resolved, this column may be removed from this table.

This column may not be NULL.

FollowNum

A text string used for checking. This column may be empty text. It need not contain characters, but it may not contain only whitespace characters. This column may not be NULL.

Origin

A code indicating the source of the location information. A LOCATION_ORIGINS.Code value. This column may not be NULL.

Notes

Free form textual notes on the individual’s spatial placement. This column may be empty text. It need not contain characters, but it may not contain only whitespace characters. This column may not be NULL.

Entered

The person who recorded the location. A PEOPLE.Person value. This column may not be NULL.

Page last generated: 2026-07-01 00:11:55 UTC