Roy,

If all the stops along a route are valid stops (i.e. no express services that don't 
stop or different stops along a road for different services - a situation we have here 
where trams and buses run on the same routes), then a simple intersect query should do 
the trip (i.e. select * where stops.obj intersects routes.obj and routes.routeno = ## 
from stops, routes)

If you don't have this luxury then the only way to do this that I can see is to do 
what we do. We have a routes field in our stops file, with -1 indicating all services, 
or the route number for the appropriate services. This of course implies multiple 
stops records, which suits the use we make of the data (transport modelling), and 
requires some processing to check whether there is a specific or general stop. This 
sophistication also allows us to code four types of stops (boarding and alighting, 
boarding only, alighting only, no stops).

You might prefer a different method such as listing all the routes that use a stop or 
all stops on a route (all pretty manual).

Good luck

Mark Knudsen
___________________________________________________________________

Veitch Lister Consulting Pty Ltd
Suite 14, 663 Victoria Street           Phone:  +61 3 9427 7400
ABBOTSFORD  VIC  3067                           Fax:            +61 3 9427 0481
AUSTRALIA                                               email:  [EMAIL PROTECTED]
___________________________________________________________________


-----Original Message-----
From:   Roy Chiappini 
Sent:   Monday, March 19, 2001 8:37 AM
To:     MI List
Subject:        MI-L MI Question

Hi folks:

I have many point objects in a layer.  These points are bus stops.
There are several bus routes.  When it comes time to display a single
bus route I wish to show only the stops for that route.  Is there a
simple way to accomplish this?

TIA

Roy


~~~~~~~~~~~~~~~~~~~~~~~~ List Sponsor ~~~~~~~~~~~~~~~~~~~~~~~~~
Navglobe.com is the journal of global navigation and wireless communication.
It covers issues, products, and services without emphasizing any one vendor.
Interested?  Visit http://www.navglobe.com and click "Subscribe."  This also
makes you eligible to win DeLorme's Earthmate GPS receiver and Solus Pro 3.0.
Using Solus, you can download and view vector and raster street-level maps on
a PalmOS handheld.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.


~~~~~~~~~~~~~~~~~~~~~~~~ List Sponsor ~~~~~~~~~~~~~~~~~~~~~~~~~
Navglobe.com is the journal of global navigation and wireless communication.
It covers issues, products, and services without emphasizing any one vendor.
Interested?  Visit http://www.navglobe.com and click "Subscribe."  This also
makes you eligible to win DeLorme's Earthmate GPS receiver and Solus Pro 3.0.
Using Solus, you can download and view vector and raster street-level maps on
a PalmOS handheld.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.

Reply via email to