Name: CRCTransitReport_Coaches
Display Field: Trip_ID
Type: Table
Geometry Type: N/A
Description: null
Service Item Id: 6b1d745b40f24bd5887067e8afb04356
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 2000
Supported Query Formats: JSON, PBF
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Extent:
Drawing Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: null
Fields:
-
OBJECTID
(
type: esriFieldTypeOID, alias: ObjectID
)
-
Weekday
(
type: esriFieldTypeString, alias: Weekday, length: 10
)
-
Trip_ID
(
type: esriFieldTypeString, alias: Trip ID, length: 20
)
-
SO_ID
(
type: esriFieldTypeString, alias: SO ID, length: 20
)
-
Driver_LastName
(
type: esriFieldTypeString, alias: Driver Last Name, length: 50
)
-
Driver_FirstName
(
type: esriFieldTypeString, alias: Driver First Name, length: 50
)
-
Res_City
(
type: esriFieldTypeString, alias: Residency City, length: 30
)
-
Pickup_Location
(
type: esriFieldTypeString, alias: Pickup Location, length: 100
)
-
Pickup_Hse
(
type: esriFieldTypeString, alias: Pickup Hse, length: 10
)
-
Pickup_Street
(
type: esriFieldTypeString, alias: Pickup Street, length: 50
)
-
Pickup_Unit
(
type: esriFieldTypeString, alias: Pickup Unit, length: 20
)
-
Pickup_City
(
type: esriFieldTypeString, alias: Pickup City, length: 30
)
-
Dropoff_Location
(
type: esriFieldTypeString, alias: Dropoff Location, length: 100
)
-
Dropoff_Hse
(
type: esriFieldTypeString, alias: Dropoff Hse, length: 10
)
-
Dropoff_Street
(
type: esriFieldTypeString, alias: Dropoff Street, length: 50
)
-
Dropoff_Unit
(
type: esriFieldTypeString, alias: Dropoff Unit, length: 20
)
-
Dropoff_City
(
type: esriFieldTypeString, alias: Dropoff City, length: 30
)
-
Passenger_Hours
(
type: esriFieldTypeSmallInteger, alias: Passenger Hours
)
-
Pickup_Vehicle
(
type: esriFieldTypeString, alias: Pickup Vehicle, length: 10
)
-
Dropoff_Vehicle
(
type: esriFieldTypeString, alias: Dropoff Vehicle, length: 10
)
-
SpecialNeeds
(
type: esriFieldTypeString, alias: Special Needs, length: 10
)
-
FundingSource
(
type: esriFieldTypeString, alias: Funding Source, length: 15
)
-
County
(
type: esriFieldTypeString, alias: County, length: 30
)
-
Segment
(
type: esriFieldTypeString, alias: Segment, length: 10
)
-
ClientNotes
(
type: esriFieldTypeString, alias: Client Notes, length: 300
)
-
DriverNotes
(
type: esriFieldTypeString, alias: Driver Notes, length: 300
)
-
MileageReimbursement
(
type: esriFieldTypeString, alias: Mileage Reimbursement, length: 5
)
-
Purpose
(
type: esriFieldTypeString, alias: Purpose, length: 30
)
-
Disposition
(
type: esriFieldTypeString, alias: Disposition, length: 30
)
-
Mobility
(
type: esriFieldTypeString, alias: Mobility, length: 100
)
-
Date
(
type: esriFieldTypeDate, alias: Date, length: 8
)
-
Driver_FullName
(
type: esriFieldTypeString, alias: Driver Full Name, length: 70
)
-
Passenger_Miles
(
type: esriFieldTypeSmallInteger, alias: Passenger Miles
)
-
Fare_Expected
(
type: esriFieldTypeSmallInteger, alias: Fare Expected
)
-
Fare_Collected
(
type: esriFieldTypeSmallInteger, alias: Fare Collected
)
-
Escort
(
type: esriFieldTypeSmallInteger, alias: Escort
)
-
Ridership
(
type: esriFieldTypeSmallInteger, alias: Ridership
)
-
Ambulatory
(
type: esriFieldTypeSmallInteger, alias: Ambulatory
)
-
Accessible
(
type: esriFieldTypeSmallInteger, alias: Accessible
)
-
GlobalID
(
type: esriFieldTypeGlobalID, alias: GlobalID, length: 38
)
-
created_user
(
type: esriFieldTypeString, alias: created_user, length: 255
)
-
created_date
(
type: esriFieldTypeDate, alias: created_date, length: 8
)
-
last_edited_user
(
type: esriFieldTypeString, alias: last_edited_user, length: 255
)
-
last_edited_date
(
type: esriFieldTypeDate, alias: last_edited_date, length: 8
)
-
Pickup_Requested
(
type: esriFieldTypeString, alias: Pickup Requested Time, length: 30
)
-
Dropoff_Requested
(
type: esriFieldTypeString, alias: Dropoff Requested Time, length: 30
)
-
Pickup_Arrive
(
type: esriFieldTypeString, alias: Pickup Arrive Time, length: 30
)
-
Pickup_Depart
(
type: esriFieldTypeString, alias: Pickup Depart Time, length: 30
)
-
Dropoff_Arrive
(
type: esriFieldTypeString, alias: Dropoff Arrive Time, length: 30
)
-
Dropoff_Depart
(
type: esriFieldTypeString, alias: Dropoff Depart Time, length: 30
)
-
Pickup_RequestedDT
(
type: esriFieldTypeDate, alias: Pickup_RequestedDT, length: 8
)
-
Dropoff_RequestedDT
(
type: esriFieldTypeDate, alias: Dropoff_RequestedDT, length: 8
)
-
Pickup_ArriveDT
(
type: esriFieldTypeDate, alias: Pickup_ArriveDT, length: 8
)
-
Pickup_DepartDT
(
type: esriFieldTypeDate, alias: Pickup_DepartDT, length: 8
)
-
Dropoff_ArriveDT
(
type: esriFieldTypeDate, alias: Dropoff_ArriveDT, length: 8
)
-
Dropoff_DepartDT
(
type: esriFieldTypeDate, alias: Dropoff_DepartDT, length: 8
)
-
Weekday_Seq
(
type: esriFieldTypeString, alias: Weekday_Seq, length: 15
)
-
YearMonth
(
type: esriFieldTypeString, alias: YearMonth, length: 10
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata