[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]

Well, I just took out the mediator within a mediator...I'll have to just add a property for the cyclist who won points for various competitions during each stage, or not.

Next step is to finally learn what's possible currently to create a geographic route mapping, so a near-future Road Racing Acre app could display route map and race profile in little side windows.

----- 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