Import Future Bus Routes Tool

This tool is used to import planned bus routes from a future bus coding spreadsheet into the MHN's bus_future feature class and corresponding itinerary table. The new route data will be appended to the feature class (unless routes with the same TRANSIT_LINE value already exist, in which case the old version will be overwritten).

The program import_future_bus_routes_2.sas is called (via sasrun.bat) to import the coding data directly from the spreadsheet, perform some error checking and reformat the data for import into the coverage. This program checks for the following errors:

• Route data without corresponding itinerary data and vice-versa
• Unavailable ANODE-BNODE values or itinerary segment directional issues
• Coding applied to zone centroid connectors
• Itinerary gaps
• Too many layovers coded in an itinerary
• If errors are encountered, they are written to temp/import_future_bus_routes_2.lst, all processing stops before any data are imported into the geodatabase, and the user is prompted to correct the issues before re-running the tool

To import currently operational bus routes, the Import GTFS Bus Routes tool should be run.