Track Codes
For all you data mavens, if your data supplier does not use the old standard track identifier, ask them if they can do this, otherwise you will have to write a conversion routine on data import for both today's races and pp lines as well.
The problem is when obscure tracks change their codes and you are unaware, and have to retrospectively change codes after the fact in your database.
I agree with the concept of error checking the imported data to see if the track id matches up with your database of known tracks. This is an extra step which takes time to write and debug, but saves time later as the user is notified immediately when new tracks, or bad data shows up.
The other issue is when tracks significantly change their surface and geometry, as happened at Aqueduct in the past few years.
You have to write code to treat AQU 6F races before and after the changeover date as a different courses.
Last edited by Trackjudge; 08-30-2022 at 10:42 AM.
|