-
Notifications
You must be signed in to change notification settings - Fork 19
File formats
Data files are stored in the kartat directory. File names include _X to indicate association with a specific event ID.
Sequence of controls for score events (and relays when treated as score events). May not always exist. Variant id is an index into ratapisteet_X.txt. For score events this is probably one per runner (although they could be combined). For relays this is one per gaffle.
variant id|name|control list
45|Score Simon Errington|127_112_125_133_134_124_135_123_117_136_137_118_139_120
Map details. The map file is map id.jpg. The georef info is optional. If present it allows creation of a worldfile to translate from GPS co-ordinates to map image pixels so that GPS routes can be aligned.
map id|name|georef info
164|Oaklands College|0|-0.294841|0|51.757|2059|-0.281971|1442|51.7521|2059|-0.282226|0|51.757
Cookies. Not used by RG2.
Results and splits.
result id|course id|name|start time|db id|variant id|time|splits|GPS co-ords
12|3|Brown|Simon Errington|36363|182971__Simon Errington||44:45|118;170;219;387;499;
The splits field is only populated for results from the original results upload or where a result has been drawn and added to an event that started with no results.
The GPS co-ords field is only populated if a GPS file has been uploaded.
Event details.
event id|map id|type|name|date|club|level|comment
122|119|1|St Albans City Race|2013-04-28|Happy Herts|R|Comments
Comments.
course id|result id|runner name|?|comment
5|115|Simon Errington||Comment text
Drawn routes
course id|result id|name|variant id|co-ordinate list
1|12| Bennett Mike|null|N1313;-966N1328;-897N1180;-777N1065;-709
Template for drawing courses. Not used by RG2, but created for compatibility with RG1.
variant id|?|name|drawing template
1|1|Navy|2;567;-128;0;0N1;580;-333;0;0N4;576;-182;579;-314N1;496;-340;0;0N
Temporary file that is deleted once event is set up correctly. Not used or created by RG2. Can be ignored.
Temporary file that is deleted once event is set up correctly. Not used or created by RG2. Can be ignored.
Control locations for each course. For normal events there is one line per course, indexed by course number. For score events and relays treated as score events there is one line per result, indexed by variant number. The list includes the start and finish locations.
course/variant id|co-ordinate list
98|748;-1015N811;-692N481;-404N685;-311N809;-208N586;-852N423;-918N414;-1072N914;-1020N
User name and hashed password for RG2 manager.
Temporary file that is deleted once event is set up correctly. Not used or created by RG2. Can be ignored.
Course names.
course id|name
1|Brown
##sarjojenkoodit_X.txt Controls on each course. May not always exist.
variant id|start code|(code|)finish code
14|S|31|32|33|34|35|36|37|F
Password for RG1 manager. Not used by RG2, which uses rg2userinfo.txt instead.
Worldfile to convert georeferenced map to pixels. This is the original worldfile loaded when you add a map. Only exists if map is georeferenced.