Difference between revisions of "StatPack"

Revision as of 20:20, 23 June 2007

This page contains information specific to Geocaching Australia.

The Geocaching Australia StatPack is designed to allow you to create your own statistics.

There are currently 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 please keep this in mind and try not to download it more than once a day. The StatPack is located here.

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

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

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

• The cachers.csv file contains records for each member at geocaching.com.au that have registered a country and state in their profile. At the time of writing, this was not 100% of all members.
• The caches.csv file contains records for each cache that exists in the geocaching.com.au database.
• The logs.csv file contains records for each log that exists 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

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

Cachers

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

The format is 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 contains records for each cache that exists in the geocaching.com.au database.

The format is 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 contains records for each log that exists 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