runningahead collection had cut/paste error from ultrasignup, and consequently all results saved from runsignup have race.surface as "trail". The races shorter than 1 mile need to be updated to "track"
update `race` set surface='track' WHERE `distance` < 1 AND `surface` = 'trail'
But athlinks may have the same problem. Probably best to just let agegrade make the decision when we don't know the surface. This should recover from previous collections. Note can't use distance < 1 because athlinks returns 0.999997 for mile races. fixeddist seems accurate to 4 places.
update `race` set surface=null WHERE `fixeddist` < 1 AND `external` = 1
runningahead collection had cut/paste error from ultrasignup, and consequently all results saved from runsignup have race.surface as "trail". The races shorter than 1 mile need to be updated to "track"
But athlinks may have the same problem. Probably best to just let agegrade make the decision when we don't know the surface. This should recover from previous collections. Note can't use
distance < 1because athlinks returns 0.999997 for mile races.fixeddistseems accurate to 4 places.