[Data-modeling] Help. I am getting bogged down in the Mountains of the Tour de France, and the rest day is almost over.

[Gordon Mackenzie]

Kinda...

There's a race type for the recurring event, eg. 2009 Tour de France.

Race stage since these "Grand Tours" and other smaller "Tours" are multi-week events.

Then we get to the race stage type for each stage topic, which is where I am probably trying to capture too much...

- There's the famous climbs that are featured on certain stages, and I had hoped to capture who were the first few riders over the top and got points for the race-long Mountains Classification. I see that maybe I should just allow the entry of who was the winner of that climb and list in another type else where the cyclists and the points earned.

My head hurts.

----- Original Message -----
From: "Ed Laurent" <spatial.db at gmail.com>
To: "Freebase data modeling mailing list" <data-modeling at freebase.com>
Sent: Monday, July 13, 2009 6:56:01 PM GMT -08:00 US/Canada Pacific
Subject: Re: [Data-modeling] Help. I am getting bogged down in the Mountains of the Tour de France, and the rest day is almost over.


Without getting too deep into the model, I'm wondering if you just want to add race, rider, and award to your first CVT? The CVT w/ your notable properties would then be 

race 

mountain pass/mountain location 

type of climb (category) 

rider 

points 

award (e.g., winner) 

Does this cover it or am I missing something? 

-Ed 



On Mon, Jul 13, 2009 at 9:07 PM, Gordon Mackenzie < gordon at metaweb.com > wrote: 


I am unsure if I am able to do what I want to do for capturing the 
King of the Mountains (Mountains Classification) competition in the 
2009 Tour de France. 

http://www.freebase.com/type/schema/base/peleton/road_bicycle_race_climbs 

For every stage of the 3 week race, I want to capture the significant 
climbs where the first few riders who reach the designated KOM point 
get points awarded. The daily leader gets to proudly (and probably 
very tiredly) wear on the next stage race day the KOM/MC jersey (Red 
Polka dots on a white jersey). 

I most notably want to have: 

mountain pass/mountain location 

type of climb (category) 

winners and the points awarded to each rider 

So if I make this a mediator (CVT) in client, everything seems to 
display as I want it, except the cyclists. the only way I could figure 
out how to link cyclist to points won is another CVT. However there is 
no way to add the data for the awarded points from Road Bicycle Race 
climbs edit windows, just adding the riders. I would have to edit the 
road_bicycle_race_mountain_points_awarded CVT itself to add the points 
awarded to each rider. 

Is this just too much? Should I be happy to just list the riders in 
winning order? link to the basic competition type from Mountain points 
winners? I do have a tendency to over design and get too intricate 
(precious) in my schema design. 

Example topic doconnor and I were working on: 

http://www.freebase.com//edit/topic/guid/9202a8c04000641f800000000c684163 

~ Gordon 

<<< gordon at metaweb.com >>> 



_______________________________________________ 
Data-modeling mailing list 
Data-modeling at freebase.com 
http://lists.freebase.com/mailman/listinfo/data-modeling 


_______________________________________________
Data-modeling mailing list
Data-modeling at freebase.com
http://lists.freebase.com/mailman/listinfo/data-modeling