-
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|course name|runner 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. Its consists of comma-separated cumulative seconds at each control plus the finish.
RG2 from version 0.9.8 abuses the db_id field to store position and status information. The field is formatted as dbid_#position#status.
The GPS co-ords field is only populated if a GPS file has been uploaded.
Event details.
event id|map id|format|name|date|club|level|comment
122|119|1|St Albans City Race|2013-04-28|Happy Herts|R|Comments
Format values are from the original Routegadget file definitions: 1: Normal event (courses plus results) 2: Event with no results 3: Score event
This is a problem since it doesn't cope with score events with no results. This needs some further thought to solve, since it would be useful to support this format. But this needs not to break RG1 installations.
Comments.
course id|result id|runner name|?|comment
5|115|Simon Errington||Comment text
There is one line for each route added, even if there are no comments. This means the file can be used to get a list of the most recenly added routes simply by reading through it backwards.
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
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.