Discussing: Travel routes and distances tables - structure?
Travel routes and distances tables - structure?
Lyllyn
Message: 26366
02 Jun 04 9:05 PM
Original Post
General Audience
Read-Only
Message: 26366
02 Jun 04 9:05 PM
Original Post
General Audience
Read-Only
Re: Travel routes and distances tables - structure?
Re: Travel routes and distances tables - structure?
Re: Travel routes and distances tables - structure?
I think it's worth starting from this question because if we can work out what people want, then the how ought to flow from that!
From the requests in the thread, there seem to be three different ways people approach this.
1) There are some specific long journeys (with alternate routes) that are very commonly requested such as Thranduil's Halls/Rivendell and Minas Tirith/Rivendell.
2) Then there are the local travel requirements. I'll hold up my hand and admit to asking for a lot of the Gondor stuff. (And not just because I was writing a particular journey but because I need to understand stuff like how long it would take to send messages between Minas Tirith and Dol Amroth and how often it's likely the Prince of Dol Amroth would attend councils in Minas Tirith.)
3) FInally, there's sometimes a need to construct a completely new journey no-one has considered before, which requires digging out all the individual legs of the journey.
Which leads on to another question: do you want to have just a single copy of the data (good for data integrity) or are you happy to have multiple copies of the same information in different tables (given these are static copies and not being generated out of the same data source, so if something changes in one place, it needs to be changed in all the others)?
There's also the issue that the journey from, say the Crossings of Poros to the Crossroads in Ithilien is (in term of travel time and terrain notes) essentially the same as the trip from the Crossroads in Ithilien to the Crossings of Poros. Are you going to list the trip one way round (and how do you choose which place is depature and which is destination) or are you going to list the trip both ways?
Now, HASA members are smart and can do a bit of digging to find the individual legs they need, whichever way round they are listed, but I have my long-term planning head on here and I'm thinking about future uses of this data (the trip calculator, perhaps).
So my thoughts are:
Would it be possible to have a "summary chapter" with a table that does list every possible leg, both ways round, in alphabetical order by departure point - and the have a hyperlink to the local area page where that leg is included. This would be a long table, but it would also be a complete "single source" and index to all the other data.
So the summary chapter would have:
departure destination area/region
Crossings of Poros Crossroads in Ithilien link to Gondor page
Crossroads in Ithilien Crossings of Poros link to Gondor page
Then the other chapters could be "regional chapters" and list all the legs in that region, with the full six columns of detail. In the notes section, as well as terrain notes we could put hyperlinks to relevant entries in the resources section on terrain (for example, the Forest Path, Great Spiders etc)?
And finally we could have some chapters that list some of the most commonly journeys by different routes, complied from the legs in the area/region pages.
Umm, sorry, rambled on there, but that's the way I think I would try and solve this.
Cheers, Liz
Re: Travel routes and distances tables - structure?
Re: Travel routes and distances tables - structure?
Re: Travel routes and distances tables - structure?
ch.2
I think should be the full table, basically as it is now with the direct trips and the longer trips with legs.
A technical point which might improve the speed at which the page loads is that the table could be split into several pieces from an HTML point of view (although this would not be apparent on the page when viewed). I think this would allow the first table to load and display while the second is being loaded, rather than having to wait for the whole table to load before it can be displayed.
I know it isn't very technical, but do most users have the kind of 'find' function like IE does, to find something on that page. That way, if someone was looking for anything, they could search that page.
Works for me and something I do actually use at HASA sometimes already!
additional chapters could be set up regionally in sets of two, with the notes and comments from the thread (if it is ok with the authors) pasted into a chapter, and a following chapter with the travel chart cooresponding to those notes.
Good idea.
almost forgot. I think you thought I meant to suggest putting the thread comments in the comment section of the chart. I didn't mean that because the comments on the thread are too long and most of the routes already have comments. ....hope I have caused less confusion, not more.
Thanks for clarifying (I wasn't completely clear what was meant).
Crossings of Poros Crossroads in Ithilien link to Gondor page
Crossroads in Ithilien Crossings of Poros link to Gondor page
in the regional chapter divisions, this would fall into place automatically in many cases because the Minas Tirith to Rivendell would be in the Gondor regional section and the Rivendell to Minas Tirith travel would be in the Rivendell section
OK, I obviously saw this working differently to you
I saw the regional sections only including legs that were in that region. So the way I saw it working, for the Minas Tirith- Rivendell journey, the Gondor section would only cover getting as far as the Mering Stream (?) which is the border with Rohan. Then you would look in the Rohan section either for the legs that get you to the Gap of Rohan or the ones that get you up to the Limlight and the border with the Vale of Anduin.
Witn the first route, you then would need to look in the Eriador section to get you from the Gap of Rohan to Rivendell. With the second. you would need to look in the Vale of Anduin (and Mirkwood?) part to get you through the Gladden Fields and to one of the two passes (Caradhras or the High Pass) and after that look in the Eriador part to get you from wherever you are on the other side of the Misty Mountains to Rivendell.
Does that make any kind of sense?
Another reason for saying we need the trip listed in both directions was that there was a whisper of some day (and let me emphasise the some day, because this is a really difficult coding challenge) there being a "trip calculator" that would allow you to automatically construct (and save) details of any journey from the available legs held in a database. So I was thinking about the best way to capture the data now to make that programming easier.
In the notes section, as well as terrain notes we could put hyperlinks to relevant entries in the resources section on terrain (for example, the Forest Path, Great Spiders etc)?
And the depature and destination points could also be linked to their entries in the resources entries if they exist as well.
Cheers, Liz
Re: Travel routes and distances tables - structure?
Re: Travel routes and distances tables - structure?
What I did suggest further up the thread was that a limited number of the most "popular" routes could be put in a separate chapter, with the regional chapters just having the legs in those regions.
I think we probably need more input from other people here
Cheers, Liz
Re: Travel routes and distances tables - structure?
Re: Travel routes and distances tables - structure?
Re: Travel routes and distances tables - structure?
), or modifications only have to be added in one place.
Second, the user should be presented with a single, all-encompassing Index of Trips, indexed by the names of the end points, with both directions listed. If a user wants a trip from A to B, they should be able to find it under 'A'; and the return trip under 'B'. All of the individual trip segments would be indexed, as well as the multi-segment trips. If we wanted to keep things simpler internally, we could also include alternate routes in this Index (eg both "C to D via X" and "C to D via Y" - which also implies "D to C via X" and "D to C via Y", if those are also possible routes [e.g. don't involve, say, rowing a boat upstream in a fast-flowing river]). (Technical: there should be a "Trips" table, where alternate routes are separate Trips.)
Third, the *ideal* situation would be for the user to select a Trip, and all the Segments (and *only* the segments) used for that trip are displayed. (Technical: there should be a link between the Trips table and the Segments table, where each Trip links to one or more Segments.) I do not recommend breaking the information up by Region (though region could certainly be one of the pieces of data stored for each Segment).
Fourth, if you want to include non-structured text (Comments), there should be a separate "Comments" table, [tech: where each record is variable-length, or fixed-length ("Lines") and any number of Lines can be chained for one Comment]. Then, one or more Comments could be linked to a Trip. (Hmmm, maybe also need to link to a Segment?), and a single Comment can be linked to any number of Trips.
So much for my potential database design
. If you have any questions, let me know...
- Barbara
P.S. Breaking information up into Regions only makes sense if you can't display the information selectively; I think the ideal situation is to present the user with only the specific information they need for that Trip.
(Edit: ) And then it would be nice if the user could print or download the information into a nicely-formatted text file... but File/Print or Save As will probably be enough at first.
Re: Travel routes and distances tables - structure?
Re: Travel routes and distances tables - structure?
Re: Travel routes and distances tables - structure?
Re: Travel routes and distances tables - structure?
Re: Travel routes and distances tables - structure?
Re: Travel routes and distances tables - structure?
Cheers, Liz