Name: bct_fixed_routes_timetables

Display Field: STOP_NAME

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID_2

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ROWID_ (type: esriFieldTypeDouble, alias: ROWID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TRIP_ID (type: esriFieldTypeString, alias: trip_id, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• ARRIVAL_TIME (type: esriFieldTypeString, alias: arrival_time, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• DEPARTURE_TIME (type: esriFieldTypeString, alias: departure_time, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• STOP_ID (type: esriFieldTypeInteger, alias: stop_id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STOP_ID_LABEL (type: esriFieldTypeString, alias: stop_id_label, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• STOP_NAME (type: esriFieldTypeString, alias: stop_name, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• STOP_SEQUENCE (type: esriFieldTypeInteger, alias: stop_sequence, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SHAPE_DIST_TRAVELED (type: esriFieldTypeDouble, alias: shape_dist_traveled, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BLOCK_ID (type: esriFieldTypeString, alias: block_id, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• ROUTE_ID (type: esriFieldTypeString, alias: route_id, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• DIRECTION_ID (type: esriFieldTypeInteger, alias: direction_id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TRIP_HEADSIGN (type: esriFieldTypeString, alias: trip_headsign, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• SHAPE_ID (type: esriFieldTypeString, alias: shape_id, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• SERVICE_ID (type: esriFieldTypeString, alias: service_id, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• ROUTE_LONG_NAME (type: esriFieldTypeString, alias: route_long_name, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• ROUTE_SORT_ORDER (type: esriFieldTypeInteger, alias: route_sort_order, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ROUTE_TYPE (type: esriFieldTypeInteger, alias: route_type, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SERVICE_1 (type: esriFieldTypeString, alias: SERVICE_1, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• SUNDAY_1 (type: esriFieldTypeString, alias: SUNDAY_1, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• WKDAY_1 (type: esriFieldTypeString, alias: WKDAY_1, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• OFFPK_HD_1 (type: esriFieldTypeString, alias: OFFPK_HD_1, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• CORRIDOR_1 (type: esriFieldTypeString, alias: CORRIDOR_1, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• ROUTE_SHORT_NAME (type: esriFieldTypeInteger, alias: route_short_name, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SATURDAY_1 (type: esriFieldTypeString, alias: SATURDAY_1, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• PEAK_HDW_1 (type: esriFieldTypeString, alias: PEAK_HDW_1, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• START_DATE (type: esriFieldTypeInteger, alias: start_date, SQL Type: sqlTypeOther, nullable: true, editable: true)
• END_DATE (type: esriFieldTypeInteger, alias: end_date, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MONDAY (type: esriFieldTypeInteger, alias: monday, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TUESDAY (type: esriFieldTypeInteger, alias: tuesday, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WEDNESDAY (type: esriFieldTypeInteger, alias: wednesday, SQL Type: sqlTypeOther, nullable: true, editable: true)
• THURSDAY (type: esriFieldTypeInteger, alias: thursday, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FRIDAY (type: esriFieldTypeInteger, alias: friday, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SATURDAY (type: esriFieldTypeInteger, alias: saturday, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SUNDAY (type: esriFieldTypeInteger, alias: sunday, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ARRIVALSECONDS (type: esriFieldTypeInteger, alias: arrivalSeconds, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STOP_LAT (type: esriFieldTypeDouble, alias: stop_lat, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STOP_LON (type: esriFieldTypeDouble, alias: stop_lon, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GLOBALID (type: esriFieldTypeString, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: true)
• GLOBALID_1 (type: esriFieldTypeGUID, alias: GLOBALID_1, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• GlobalID_2 (type: esriFieldTypeGlobalID, alias: GlobalID_2, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: bct_fixed_routes_timetables
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Relationships:

• vehicle_adherence_report (1) -- Related To: Vehicle Adherence Report Inspections (3)
• Bus Stops (0) -- Related To: Bus Stop (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/26/2026 1:56:15 PM

Schema Last Edit Date: 10/3/2023 8:50:35 PM

Data Last Edit Date: 1/26/2026 1:56:15 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat