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.