Off the turf races in databases?

[Inglewood Flamingo]

Does anyone out there know if it is possible for a program to remove races that were taken off the turf so that they aren't lumped into a programs database, particularly when using the BRIS XRD results file?

[Secretariat]

Generally, Bris stores surface as four types: D, d, T, t. I would suggest you contact the Programmer, or Vendor and ask him to add a one byte new field to his database model called SurfaceChanges. In his modeling procedure he could then store a variable such as "X" or "O" to indicate the surface change. It would entail him changing the database, and the queries as well as the model evaluation. Using the XRD files he'd have to look at the surface run on and compare to the DRF surface the race was supposed to be run, and store the change.

[Larry Hamilton]

nothing to it. When you relate the results to the pps AFTER THE RACE, just hook it up Date, Track, Race Number, HorseName and Surface. This relationship in the query will force out all the races in which the surface changed between the race specs' and the race.

[Inglewood Flamingo]

Thanks guys. Any other input would be greatly appreciated.

[VetScratch]

For XRD files, some tracks occasionally go on streaks where surface is missing but track condition is given, or where surface and track condition are obviously mismatched. If you have the scheduled surface from PPs, you can resolve these circumstances by validating the correspondence between all three fields.

Just One Example:
PP Surface = T (from among D,d,T,t,s,h)
XRD Surface = T
XRD Track Condition = MY

Race came off the turf, but you would have to guess/analyze whether distance may have changed by looking at the final time.