rogers1000/cyclingchaos

UK National Cycling Scene Transformation

Opened this issue · 6 comments

Transform British Cycling ingestion into results df

Need to think about how I implement results from first cycling to British Cycling...

UCI Classification will probably be "British Nat A" etc.

Category will be "Road" or "Criterium"

Need to do mapping between British Cycling IDs and Names and FirstCycling.

Route will likely be location-location

Basis calendar transform done in order to get link to ingest race results.

Will look into make it aligned with FirstCycling and Paralympic unioned calendar.

Not yet looked at results data.

Calendar transform so far...

  • * Dates transform doesn't work for stage races...
  • * Need to work out what if it is a stage race or not
  • * Need to work out what category the race is (probably do GB as prefix) for UCI Race Classification
  • * Stage Number is related to stage races (not sure yet)
  • * distance not sure yet
  • * stage profile not sure yet
  • * Route uses location but probably too detailed. Need to look into that.

Race Results...

All working for riders who finished... for DNFs or DNSs there is an issue with position. Shouldn't be too complex, hopefully.

Currently working through the transform relating to Race Category as it isn't working in the current transform.

Transform isn't possible with current ingestion process.

Need to look to implement standard scoring for all racers (international riders or riders without proper licence don't collect points but should still be tracked)