DART Bus Schedules
DART Bus Schedules
This contains all the routes, stop location, stop times, and trip information for all DART bus routes.
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| STOP_ABBR | stop_abbr | stop_abbr | Text | Contains short text or alpha numeric value that used in identifying the stop, referenced by the StopID column. |
| DESTINATIONSIGN_NAME | destinationsign_name | destinationsign_name | Text | Contains the text that appears on the bus sign that identifies the trip's destination to passengers. This field is also used to distinguish between different patterns (PatternID) of service in the same route. Usually, major landmark names are used in this data. |
| SERVICE_NAME | service_name | service_name | Text | Contains the full name of the service. This text often indicates what type of service is being used. Example: Weekday, Saturday, Sunday, Resort Weekday. |
| WEEK_TEMPLATE | week_template | week_template | Text | Contains a binary value that indicates whether the service is valid for the day(s) of the week starting from Sunday to Saturday. “Sunday Monday Tuesday Wednesday Thursday Friday Saturday.” Example: 0111110. A value of ‘0’ indicates that service is not available for that day, whereas 1 represents service is available for that day. Note: Transit day Start time and End time of all days is from 3:00 am to next day 2:59 am. |
| SERVICE_ID | service_id | service_id | Number | Contains an ID that uniquely identifies a service. It is referenced by the Service_Name and Week_Template columns. |
| STOPID | stopid | stopid | Number | Contains an ID that uniquely identifies a stop. Multiple routes may use the same stop. The StopID is unique. |
| STOP_SEQUENCE | stop_sequence | stop_sequence | Number | Identifies the order of the stops for a particular trip. The values for Stop_Sequence will be increasing along the trip. There might be missing Stop_Sequence values in the order, which is common. |
| STOP_LON | stop_lon | stop_lon | Number | Contains the longitude of a stop. |
| STOP_LAT | stop_lat | stop_lat | Number | Contains the latitude of a stop. |
| TRIP_FROMTIME | trip_fromtime | trip_fromtime | Text | Contains specific Trip start time. The first stop time(Stop_Time) value of a specific Trip(TripID) is entered here. |
| TRIPID | tripid | tripid | Number | Contains an ID that identifies a trip. |
| STOP_TIME | stop_time | stop_time | Text | Specifies the stop arrival time at a specific stop for a specific trip on a route. |
| PATTERNID | patternid | patternid | Text | Contains an ID that uniquely identifies a Pattern. Multiple blocks are a combination of a specific Pattern. |
| Geocoded Location | geocoded_location | geocoded_location | Point | This field is used to combine latitude and longitude into one field to be able to display on a map. |
| Geocoded Location (address) | geocoded_location_address | geocoded_location_address | Text | |
| Geocoded Location (city) | geocoded_location_city | geocoded_location_city | Text | |
| Geocoded Location (zip) | geocoded_location_zip | geocoded_location_zip | Text | |
| ROUTE | route | route | Number | Contains an ID that uniquely identifies a route. |
| ROUTE_NAME | route_name | route_name | Text | Contains the full name of a route. This name will often include the route's destination sign name or last stop name. |
| DIRECTION_NAME | direction_name | direction_name | Text | Contains text which indicates the direction of travel for a Trip. Used for separating trips by direction when publishing time tables and distinguishing between bi-directional trips with the same Route. Values = Outbound, Inbound Outbound: Travel in one direction Inbound: Travel in opposite direction. |
| TRIP_TOTIME | trip_totime | trip_totime | Text | Contains specific Trip end time. The last stop time(Stop_Time) value of a specific Trip(TripID) is entered here. |
| STOP_NAME | stop_name | stop_name | Text | Contains the name of a stop. |
| POCKETSCHEDULE_NAME | pocketschedule_name | pocketschedule_name | Text | Contains the alias name of a stop used on DART pocket schedule time table. |
| BLOCK_NUM | block_num | block_num | Number | Contains an ID that uniquely identifies a Block. It used in identifying which trip belongs to a block. A block consists of two or more sequential trips made using the same vehicle, where a passenger can transfer from one trip to the next just by staying in the vehicle. The block_num is referenced by two or more TripID’s. |
| Geocoded Location (state) | geocoded_location_state | geocoded_location_state | Text |