Difference between revisions of "StatPack"

Latest revision as of 12:30, 15 July 2016

This page contains information specific to Geocaching Australia.

The Geocaching Australia StatPack was designed to allow you to create your own statistics, but has since been decommissioned. Only empty versions of the files remain.

There were three files in the StatPack: cachers.csv, caches.csv and logs.csv. At the time of writing, the cachers.csv file was about 15kb, caches file was about 800kb and the logs file was 6mb, so you needed to keep this in mind and try not to download it more than once a day. The remnants of StatPack is located here.

All of the records in the file were double-quote encapsulated with the exception of the header record. Some special characters such as double quotes and single quotes were escaped with the UNIX \ character.

There was a header record contained in the file which described the field names. This header record was not double-quote encapsulated.

Some cache and cacher names such as ¢ha®lie Ðelta had special characters. In a MySQL or postgres database these would not have cause problems. In a Microsoft Access database you may have found that these records did not get imported. Keep in mind that cache and cacher names could have contained double-quotes, single-quotes, ampersands and commas as well as others which may have caused formatting or import issues as well.

• The cachers.csv file contained records for each member at geocaching.com.au that had registered a country and state in their profile. At the time of writing, this was not 100% of all members.
• The caches.csv file contained records for each cache that existed in the geocaching.com.au database.
• The logs.csv file contained records for each log that existed in the geocaching.com.au database.

Read more below for the file layout.

Applications

Applications that have been developed from the StatPack are:

• Caught at Work's Geocaching Graphs. This application is no longer available.

An Explanation and the Useage of the graphs can be found here

Cachers

The cachers.csv file contained records for each member at geocaching.com.au that had registered a country and state in their profile. At the time of writing, this was not 100% of all members.

The format was as follows

• Cacher name
• State
  • ACT: Australian Capital Territory
  • NSW: New South Wales
  • NT: Northern Territory
  • QLD: Queensland
  • SA: South Australia
  • TAS: Tasmania
  • VIC: Victoria
  • WA: Western Australia
  • NI: North Island (New Zealand)
  • SI: South Island (New Zealand)
• Number of geocaching.com.au caches Hidden
• Number of geocaching.com.au caches Found

Caches

The caches.csv file contained records for each cache that existed in the geocaching.com.au database.

The format was as follows

• Hidden date in YYYY-MM-DD format
• Waypoint
• Cache name
• Cache owner
• Terrain
• Difficulty
• Cache Type
  • B: Moveable
  • C: CITO
  • E: Event
  • L: Locationless
  • M: Multi-cache
  • O: Other
  • R: Earthcache
  • T: Traditional
  • U: Unknown
  • V: Virtual
  • W: Webcam
  • X: Letterbox
• Cache Container
  • V: Virtual
  • M: Micro
  • S: Small
  • R: Regular
  • L: Large
  • O: Other
  • U: Unknown
• Status
  • A: Available
  • U: Unavailable
  • V: Archived
• Recommended (number of people recommending the cache)
• Planning
• Watching

Logs

The logs.csv file contained records for each log that existed in the geocaching.com.au database.

• Log date in YYYY-MM-DD format
• Waypoint logged
• Cacher who made the log
• Log type, consisting of:
  • A: Attended
  • B: Published
  • D: Didn't Find it
  • E: Needs Archiving
  • F: Found it
  • I: Disabled
  • L: Enabled
  • N: Noted
  • P: Photographed
  • U: Unarchived
  • V: Archived
  • W: Will Attend

See Also

• Statistics