Name: Rides

Display Field: clientfirstname

Type: Table

Geometry Type: N/A

Description:

Service Item Id: c56ca4b207f54fe483e5bfc8a61b5b07

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

N/A

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: false
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: false
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• department ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: department, alias: Department , Coded Values: [DSS: DSS] , [OFA: OFA] , [MH: Mental Health] , ...5 more... )
• caseworkeremail ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: caseworkeremail, alias: Staff Email )
• appointmenttime ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: appointmenttime, alias: Appointment Time )
• appointmenttimetype ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: appointmenttimetype, alias: Appointment Time Type , Coded Values: [Fixed: Fixed] , [Flexible all day: Flexible all day] , [Flexible morning: Flexible morning] , ...1 more... )
• clientfirstname ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: clientfirstname, alias: Client First Name )
• clientmiddleinitial ( nullable: true, editable: true, defaultValue: null, length: 10, type: esriFieldTypeString, modelName: clientmiddleinitial, alias: Client Middle Initial )
• clientlastname ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: clientlastname, alias: Client Last Name )
• clientsuffix ( nullable: true, editable: true, defaultValue: null, length: 10, type: esriFieldTypeString, modelName: clientsuffix, alias: Client Suffix )
• clientdob ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: clientdob, alias: Client DOB )
• clientphone ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: clientphone, alias: Client Phone )
• clientemail ( nullable: true, editable: true, defaultValue: null, length: 100, type: esriFieldTypeString, modelName: clientemail, alias: Client Email )
• clientpreferredcontacttype ( nullable: true, editable: true, defaultValue: null, length: 10, type: esriFieldTypeString, modelName: clientpreferredcontacttype, alias: Client Preferred Contact Type , Coded Values: [Phone: Phone] , [Email: Email] , [Text: Text] )
• casenumber ( nullable: true, editable: true, defaultValue: null, length: 20, type: esriFieldTypeString, modelName: casenumber, alias: Case Number )
• mobilitysupport ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: mobilitysupport, alias: Mobility Support , Coded Values: [Door to Door: Door to Door] , [Curb to Curb: Curb to Curb] )
• supportdevices ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: supportdevices, alias: Support Devices , Coded Values: [Wheelchair: Wheelchair] , [Cane: Cane] , [Walker: Walker] )
• additionalrider ( nullable: true, editable: true, defaultValue: null, length: 10, type: esriFieldTypeString, modelName: additionalrider, alias: Additional Rider , Coded Values: [0: 0] , [1: 1] , [2: 2] , ...3 more... )
• carseatneeded ( nullable: true, editable: true, defaultValue: null, length: 20, type: esriFieldTypeString, modelName: carseatneeded, alias: Car Seat Needed , Coded Values: [0: 0] , [1: 1] , [2: 2] , ...3 more... )
• pickupaddress ( nullable: true, editable: true, defaultValue: null, length: 100, type: esriFieldTypeString, modelName: pickupaddress, alias: Pick-up Address )
• pickupaddressother ( nullable: true, editable: true, defaultValue: null, length: 100, type: esriFieldTypeString, modelName: pickupaddressother, alias: Pick-up Address Other )
• pickupaddressunit ( nullable: true, editable: true, defaultValue: null, length: 10, type: esriFieldTypeString, modelName: pickupaddressunit, alias: Pick-up Address Unit# )
• dropoffaddress ( nullable: true, editable: true, defaultValue: null, length: 100, type: esriFieldTypeString, modelName: dropoffaddress, alias: Drop-off Address )
• dropoffaddressother ( nullable: true, editable: true, defaultValue: null, length: 100, type: esriFieldTypeString, modelName: dropoffaddressother, alias: Drop-off Address Other )
• dropoffaddressunit ( nullable: true, editable: true, defaultValue: null, length: 10, type: esriFieldTypeString, modelName: dropoffaddressunit, alias: Drop-off Address Unit )
• returntriprequested ( nullable: true, editable: true, defaultValue: null, length: 10, type: esriFieldTypeString, modelName: returntriprequested, alias: Return Trip Requested , Coded Values: [Yes: Yes] , [No: No] )
• returntripappropriatetime ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: returntripappropriatetime, alias: Return Trip Approximate Time )
• reoccuringtrip ( nullable: true, editable: true, defaultValue: null, length: 10, type: esriFieldTypeString, modelName: reoccuringtrip, alias: Recurring Trip , Coded Values: [Yes: Yes] , [No: No] )
• reoccuringfrequency ( nullable: true, editable: true, defaultValue: null, length: 20, type: esriFieldTypeString, modelName: reoccuringfrequency, alias: Recurring Frequency , Coded Values: [Weekly: Weekly] , [Bi-weekly: Bi-weekly] , [Monthly: Monthly] , ...1 more... )
• reoccuringenddate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: reoccuringenddate, alias: Recurring End Date )
• specialinstructions ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: specialinstructions, alias: Notes on Special Instructions )
• fundingsource ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: fundingsource, alias: Funding Source )
• rideid ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: rideid, alias: Ride ID )
• statusofride ( nullable: true, editable: true, defaultValue: null, length: 20, type: esriFieldTypeString, modelName: statusofride, alias: Status of Ride , Coded Values: [Submitted: Submitted] , [Scheduled: Scheduled] , [Cancelled: Cancelled] , ...3 more... )
• vendorassigned ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: vendorassigned, alias: Vendor Assigned , Coded Values: [RTS: RTS] , [Arc GLOW: Arc GLOW] , [Medical Motor Service: Medical Motor Service] )
• fare ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: fare, alias: Fare($) )
• highpriority ( nullable: true, editable: true, defaultValue: null, length: 10, type: esriFieldTypeString, modelName: highpriority, alias: High Priority , Coded Values: [Yes: Yes] , [No: No] )
• pickuptime ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: pickuptime, alias: Pick-up Time )
• dropofftime ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: dropofftime, alias: Drop-off Time )
• notification1 ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: notification1, alias: Notification #1 )
• notification1method ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: notification1method, alias: Notification #1 Method , Coded Values: [Phone: Phone] , [Email: Email] , [Text: Text] , ...1 more... )
• notification2 ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: notification2, alias: Notification #2 )
• notification2method ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: notification2method, alias: Notification #2 Method , Coded Values: [Phone: Phone] , [Email: Email] , [Text: Text] , ...1 more... )
• notes ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: notes, alias: Notes )
• laststatusofride ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: laststatusofride, alias: Last Status of Ride , Coded Values: [Submitted: Submitted] , [Scheduled: Scheduled] , [Cancelled: Cancelled] , ...3 more... )
• emailnotificationsent ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: emailnotificationsent, alias: EmailNotificationSent )
• retruntripgenerated ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: retruntripgenerated, alias: RetrunTripGenerated )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: globalid, alias: GlobalID )
• created_user ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_user, alias: created_user )
• created_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: created_date )
• last_edited_user ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: last_edited_user, alias: last_edited_user )
• last_edited_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: last_edited_date )
• pickup_location_text ( nullable: true, editable: true, defaultValue: null, length: 100, alias: Pickup Location Text, type: esriFieldTypeString )
• dropoff_location_text ( nullable: true, editable: true, defaultValue: null, length: 100, alias: Dropoff Location Text, type: esriFieldTypeString )
• pickupxy ( nullable: true, quotesRequired: true, editable: true, defaultValue: null, length: 100, alias: PickupXY, type: esriFieldTypeString )
• dropoffxy ( nullable: true, quotesRequired: true, editable: true, defaultValue: null, length: 100, alias: DropoffXY, type: esriFieldTypeString )
• minor ( nullable: true, quotesRequired: true, editable: true, defaultValue: null, length: 10, type: esriFieldTypeString, alias: Minor , Coded Values: [Yes: Yes] , [No: No] )
• boosterseatneeded ( nullable: true, editable: true, defaultValue: null, length: 10, alias: Booster Seat Needed, type: esriFieldTypeString )

Templates:

• Name: Rides
  Description:
  Prototype:
  pickuptime: null
  fare: null
  dropofftime: null
  notes: null
  notification2method: null
  clientemail: null
  appointmenttime: null
  vendorassigned: null
  clientphone: null
  clientdob: null
  additionalrider: null
  pickupaddress: null
  casenumber: null
  laststatusofride: null
  clientfirstname: null
  clientmiddleinitial: null
  statusofride: null
  caseworkeremail: null
  department: null
  reoccuringfrequency: null
  highpriority: null
  mobilitysupport: null
  notification1method: null
  returntriprequested: null
  clientsuffix: null
  specialinstructions: null
  dropoffaddressunit: null
  carseatneeded: null
  reoccuringenddate: null
  dropoffaddress: null
  dropoffaddressother: null
  reoccuringtrip: null
  rideid: null
  appointmenttimetype: null
  clientlastname: null
  clientpreferredcontacttype: null
  notification1: null
  notification2: null
  supportdevices: null
  retruntripgenerated: null
  emailnotificationsent: null
  returntripappropriatetime: null
  pickupaddressother: null
  pickupaddressunit: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Create,Editing,Uploads

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Ownership Based Access Control:

• Allow Others to Update: false
• Allow Others to Delete: false
• Allow Others to Query: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query Attachments   Query Analytic   Query Top Features   Query Bins   Apply Edits   Add Features   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata