Database variabelen

Database Variables 

 

All Database variables begin with $d_ and each variable has a given type. Caches database variables are displayed as columns and more information can be found here. (“string” database variables have a physical limit of 2gb)

Most database variables can be updated simply by using the statement $d_SomeVariable = $SomeValue, where $d_SomeVariable is a valid database variable and $SomeValue is any valid variable or literal (but it must match the data type of the database variable). This actually updates your database, but as some variables are calculated from other items in the database there are exceptions. These are: $d_Bearing, $d_Changed, $d_Degrees, $d_Distance, $d_FoundCount, $d_HasCorrected, $d_HasUserNote, $d_HastravelBug, $d_LastFoundDate, $d_LastGPXDate, $d_LastLog, $d_LastUserDate, $d_LatOriginal, $d_LonOriginal, $d_NumberOfLogs, $d_UserNoteDate, $d_cByUser, $d_cParent, $d_cPrefix, $d_kBeforeCounty, $d_kBeforeState, $d_kCode, $d_kBeforeLat, $d_kBeforeLon, $d_lIsowner, $d_lParent, $d_aName

$d_ Database variables are separated into 5 GSAK tables – caches, corrected, logs, waypoints, and attributes You can navigate through each of these tables using the Table and Goto commands. Note: The tables CacheImages, LogImages and Custom are not supported in this manner – use Sqlite to read these tables. 

Caches

Variable 

Type 

Description

 

 

 

$d_Archived 

Boolean 

Deprecated – use $d_Status instead

$d_Bearing 

String 

Bearing (NW, SW, etc) from current centre point

$d_CacheID 

String 

Unique cache ID 

$d_CacheType 

String 

A 1 character string representing the cache type (See below)

$d_Code 

String 

Unique Waypoint code

$d_Changed 

Date 

Date data was actually changed in this waypoint

$d_Container 

String 

Container size

$d_County 

String 

County 

$d_Country 

String 

Country 

$d_Created 

Date 

Date the waypoint was created in the database

$d_Degrees 

Numeric 

Bearing in degrees from your current centre point

$d_Difficulty 

Numeric 

Difficulty rating 

$d_Distance 

Numeric 

Distance from current centre point

$d_DNF 

Boolean 

Cache currently has the DNF flag 

$d_DNFDate 

Date 

Date of most recent DNF 

$d_Elevation 

Numeric 

Elevation (always in meters)

$d_FavPoints 

Numeric

Geocaching.com favorite points

$d_Found 

Boolean 

Found Status

$d_FoundCount 

Number 

Found Count (number of times you have found this cache)

$d_FoundByMeDate 

Date 

Date of your most recent find for a cache 

$d_FTF 

Boolean 

First to find 

$d_GcNote

String

Geocaching.com personal note

$d_Guid

String

Geocaching.com cache GUID

$d_HasCorrected 

Boolean 

Waypoint has corrected coordinates

$d_HasTravelBug 

Boolean 

Cache has a travel bug

$d_HasUserNote 

Boolean 

Waypoint has a user note

$d_Hints 

String 

Hints for this cache (decoded)

$d_IsPremium

Boolean

Geocaching.com member only cache status

$d_LastFoundDate 

Date 

Date the cache was last found (by anybody)

$d_LastGPXDate 

Date 

Date this waypoint was last updated by loading a GPX file

$d_LastLog 

Date 

Date of the last log for this cache (any log)

$d_LastUserDate 

Date 

Date this waypoint was last updated manually by any user action

$d_LatOriginal 

String 

Original Latitude (before change by corrected coordinates)

$d_Latitude 

String 

Latitude in decimal degrees format

$d_Lock 

Boolean 

Waypoint is locked see columns

$d_LongDescription 

String 

Cache Long description

$d_LongHTM 

Boolean 

Long description contains HTML code

$d_LonOriginal 

String 

Original Longitude (before change by corrected coordinates)

$d_Longitude 

String 

Longitude in decimal degrees format

$d_MacroFlag 

Boolean 

Macro only “UserFlag” see MacroFlag command

$d_MacroSort 

String 

Internal “macro sort” more information

$d_Name 

String 

Waypoint name

$d_NumberOfLogs 

Numeric 

Number of logs linked to this cache

$d_OwnerId 

String 

ID (usually a number) of the owner of this cache (not all source data contains this)

$d_OwnerName 

String 

Owner name (more information)

$d_PlacedBy 

String 

Name of cache placer/hider

$d_PlacedDate 

Date 

Date the cache was placed/hidden

$d_Resolution 

String

Elevation resolution

$d_ShortDescription 

String 

Cache Short description

$d_ShortHTM 

Boolean 

Short description contains HTML code

$d_SmartName 

String 

Waypoint smart name

$d_SmartOverride 

Boolean 

Smart name override flag

$d_Source 

String 

Source of data from GPX/LOC see columns

$d_State 

String 

State/Province name the cache is in

$d_Status 

String 

Cache Status (see below)

$d_Symbol 

String 

Symbol name for this waypoint

$d_TempDisabled 

Boolean 

Deprecated – use $d_Status instead

$d_Terrain 

Numeric 

Terrain rating

$d_TravelBugs 

String 

Details of any travel bugs in this cache. See also $d_HasTravelBug

$d_Url 

String 

Waypoint URL

$d_UserData 

String 

User data

$d_User2 

String 

User data 2

$d_User3 

String 

User data 3

$d_User4 

String 

User data 4

$d_UserFlag 

Boolean 

User flag

$d_UserNote 

String 

User Note [1]. See also $d_HasUserNote

$d_UserNoteDate 

Date 

Date the last time the user note was updated

$d_UserSort 

Numeric 

User sort

$d_Watch 

Boolean 

Cache is being watched

[1] – The user note is comprised of two sections, the note section and the log section (see notes dialog) These two sections are separated by the literal string “$~ “. If you wish to split the user notes into these two discreet sections then the macro code would go something like:

$NoteSection = Extract($d_UserNote,”$~”,1) 

$LogSection = Extract($d_UserNote,”$~”,2)

For a more complete explanation of some of these fields please this topic

$d_Status (Cache Status):

A = Available

T = Temporary disabled

X = Archived

$d_CacheType (Cache Types):

A = Project Ape

B = Letterbox

C = Cache In Trash Out

D = Groundspeak Lost and Found Celebration

E = Event

F = Lost and Found Event

G = BenchMark

H = Groundspeak HQ Cache

I = Wherigo

L = Locationless

M = Multi

O = Other

P = Groundspeak Block Party

Q = Lab cache

R = Earth

T = Traditional

U = Unknown/Mystery

V = Virtual

W = Webcam

X = Maze Exhibit

Y = Waymark

Z = Mega event

Also see the CacheType() function 

Corrected 

Variable 

Type 

Description 

$d_kCode

String 

Parent waypoint code

$d_kBeforeLat

String 

Latitude before correction (from load of last GPX file)

$d_kBeforeLon

String 

Longitude before correction (from load of last GPX file)

$d_kBeforeState

String

State before correction (from load of last GPX file)

$d_kBeforeCounty

String

County before correction

$d_kAfterLat

String

Latitude after correction

$d_kAfterLon

String

Longitude after correction

$d_kAfterState

String

State after correction

$d_kAfterCounty

String

County after correction

$d_kType

String

Type to indicate how created.

 

kType – possible values, api – when a corrected coordinate is added/changed via the api. gui – when a corrected coordinate is added/change via the GSAK GUI. macro – when using the macro command “Addnew” .

Note: GSAK automatically keeps the fields $d_kBeforeLat and $d_kBeforeLon in sync with the caches table $d_LatOriginal and $d_LonOriginal. Consider these corresponding fields ans “synonymous” if you will. 

Logs 

Variable 

Type 

Description 

$d_lParent 

String 

Parent waypoint code

$d_lType 

String 

Log type

$d_lText

String 

Full log text

$d_lBy 

String 

Logged by name

$d_lDate 

Date 

Date of log

$d_lTime

String 

Time of log (read only and can not be updated)

$d_lLogid 

Numeric 

Unique log id number

$d_lLat 

String 

Latitude coordinate if given

$d_lLon 

String 

Longitude coordinate if given

$d_lEncoded 

Boolean 

Text encoded status

$d_lOwnerid 

Numeric 

Owner ID of log creator

$d_lIsOwner

Boolean 

User owns this log (as per matching settings

 

Currently known values for $d_lType from Geocaching.com include:

Announcement

Archive

Attended

Didn’t find it

Enable Listing

Found it

Needs Archived

Needs Maintenance

Owner Maintenance

Post Reviewer Note

Publish Listing

Retract Listing

Temporarily Disable Listing

Unarchive

Update Coordinates

Webcam Photo Taken

Will Attend

Write note

Waypoints

Variable 

Type 

Description

$d_cParent 

String 

Parent waypoint code

$d_cCode 

String 

Child waypoint code

$d_cPrefix 

String 

Child prefix (same as first 2 characters of code)

$d_cName 

String 

Child waypoint name

$d_cType 

String 

Child waypoint type (see notes)

$d_cLat 

String 

Child waypoint latitude (decimal degrees – string)

$d_cLon 

String 

Child waypoint longitude (decimal degrees – string)

$d_cUrl 

String 

Child waypoint URL

$d_cComment 

String 

Child comment

$d_cByUser 

Boolean 

Child waypoint created by user (not Geocaching.com) 

$d_cDate 

Date 

CDate the child waypoint was created 

$d_cFlag 

Boolean 

Child user flag

Notes: 

User created ($d_cByUser = True) child waypoints are effectively locked from updates by Geocaching.com additional waypoints that have the same code

$d_cPrefix is provided for version 6 compatibility and is read only because it is set via $d_cCode. That is, $d_cPrefix is always equal to the first 2 characters of $d_cCode

The current possible values for $d_cType are set by GroundSpeak and they include:

Final Location

Parking Area

Question to Answer

Stages of a Multicache

Trailhead

Reference Point

Physical Stage

Virtual Stage

You can also add your own types (more information)

By setting the $d_cFlag in a macro you can control which child waypoints will be selected for export. Most export dialogs have the following option: 

more information

Attributes (use view “attname” to also include $d_aName) 

Variable 

Type

Description

$d_aCode 

String 

Cache waypoint code

$d_aId 

Numeric 

Attribute ID number 

$d_aName

String 

Attribute name/description

$d_aInc

Boolean 

1=Include, 0 = exclude 

 

Note: currently the attributes table is read only. It is provided here for consistency with other tables, but it is recommend that you use sqlite() in macros to read and interrogate attribute data.