How can I get a list of all intersections in every virtual corridor?

Solution

The data file produced contains the following columns:

CorridorId

The unique identifier for this corridor. This value is also the unique identifier used in the Access database that IMW maintains its virtual locations in.

IntCount

The number of intersections in this corridor. This value does not include aliases. (i.e. there may be 3 intersections “IntCount” and several aliases for each intersection)

CurInt

The index of the intersection represented on this line. This relates directly to IntCount, and thus will repeat if aliases exist fot this intersection.

CorName

A human readable name for this corridor. (simply primary cross1 to cross2). This name name is not stored anywhere. It is calculated for this routine only.

PrimaryStreet

The primary street that was used to define this corridor. (will stay the same within any corridor)

CurStreet

The current cross street that was used to define this location. This value will repeat with each intersection alias.

AliasCount

The number of intersections that represent the current intersection.

CurAlias

The index of the alias represented on this line. This value directly relates to AliasCount.

IntID

The unique ID for this intersection. This is an internal number used by IMW. It is calculated using the primary and cross street indices. If a new database is created and streets are added to it again, this number will change.

Root

A boolean value indicating whether this line represents the root intersection in IMW. This value will be true for one and only one line per intersection alias.

AsDefined

A boolean value indicating whether this line represents the intersection as defined in the corridor list. This value will be true for one and only one line per intersection alias.

Street1

One of the two streets refered to by this intersection.

Street2

One of the two streets refered to by this intersection.