StatPack

From GeoWiki
Revision as of 19:01, 20 September 2005 by 60.230.133.40 (talk)
Jump to: navigation, search

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.

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:

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 yy-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 yy-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
    • I: Disabled
    • L: Enabled
    • N: Noted
    • P: Photographed
    • U: Unarchived
    • V: Archived
    • W: Will Attend