Name: BusLogisticsSurvey

Display Field: SiteName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -13044943.1043817
YMin: -1E-06
XMax: 1E-06
YMax: 4664159.76891732
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[74,155,76,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• AssetSource (type: esriFieldTypeString, alias: Asset Source, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AssetNumber (type: esriFieldTypeString, alias: DOTD Asset Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MobilizationTime (type: esriFieldTypeDate, alias: Mobilization Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• TotalSeatCapacity (type: esriFieldTypeInteger, alias: Total Number of Seats, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ADAAccessible (type: esriFieldTypeString, alias: ADA Accessible, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ADACapacity (type: esriFieldTypeInteger, alias: ADA Capacity, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NonADACapacity (type: esriFieldTypeInteger, alias: Non-ADA Capacity, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ReplacementVehicle (type: esriFieldTypeString, alias: Replacement Vehicle, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SiteName (type: esriFieldTypeString, alias: Site Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SchoolDistrict (type: esriFieldTypeString, alias: School District, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SchoolBusNum (type: esriFieldTypeString, alias: School Bus Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SchoolBusHorsepower (type: esriFieldTypeString, alias: School Bus Horsepower, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MobCheckInQR (type: esriFieldTypeString, alias: Scan QR Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GUID (type: esriFieldTypeGUID, alias: GUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• AssetType (type: esriFieldTypeString, alias: Asset Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• VendorNumber (type: esriFieldTypeString, alias: Vendor Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MobilizationPerson (type: esriFieldTypeString, alias: Person, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• CheckoutTime (type: esriFieldTypeDate, alias: Checkout Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DeMobLocation (type: esriFieldTypeString, alias: Demoblization Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DeMobPerson (type: esriFieldTypeString, alias: Demoblization Person, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Active: Active], [Inactive: Inactive])
• Action (type: esriFieldTypeString, alias: Actions, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Regular: Regular Check-in/out], [Convenience: Convenience Check-in/out])
• CurrentLocation (type: esriFieldTypeString, alias: Current Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CreationDate_1 (type: esriFieldTypeDate, alias: CreationDate_1, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Creator_1 (type: esriFieldTypeString, alias: Creator_1, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• EditDate_1 (type: esriFieldTypeDate, alias: EditDate_1, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Editor_1 (type: esriFieldTypeString, alias: Editor_1, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• ConveinceCheckInLocation (type: esriFieldTypeString, alias: Conveince Check In Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ConveinceCheckInTime (type: esriFieldTypeDate, alias: Conveince Check-In Date and Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ConveinceCheckOutTime (type: esriFieldTypeDate, alias: Conveince Check Out Date and Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ConveinceCheckOutLocation (type: esriFieldTypeString, alias: Conveince Check Out Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• StaffLastName (type: esriFieldTypeString, alias: Staff Last Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RegularCheckInTime (type: esriFieldTypeDate, alias: Regular Check In Date and Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RegularCheckInLocation (type: esriFieldTypeString, alias: Regular Check In Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RegularCheckOutTime (type: esriFieldTypeDate, alias: Regular Check Out Date and Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RegularCheckOutLocation (type: esriFieldTypeString, alias: Regular Check Out Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• EventName (type: esriFieldTypeString, alias: Event Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• EventID (type: esriFieldTypeString, alias: Event ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AssetStatus (type: esriFieldTypeString, alias: Asset Status, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Available: Available], [InTransit: In-Transit], [Unavailable: Currently Unavailable], ... 1 more ...)
• CreationDate_2 (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator_2 (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate_2 (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor_2 (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• Username (type: esriFieldTypeString, alias: Username, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• CoachBus (type: esriFieldTypeInteger, alias: Coach Bus, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SiteName_Actual (type: esriFieldTypeString, alias: SiteName_Actual, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Latitude (type: esriFieldTypeString, alias: Latitude, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Longitude (type: esriFieldTypeString, alias: Longitude, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Paratransit (type: esriFieldTypeInteger, alias: Paratransit, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SchoolBus (type: esriFieldTypeInteger, alias: School Bus, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Van (type: esriFieldTypeInteger, alias: Van, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Other (type: esriFieldTypeInteger, alias: Other, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EventName_Actual (type: esriFieldTypeString, alias: Actual Event Name, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• statusnote (type: esriFieldTypeString, alias: statusnote, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• ReplacementAssetNumber (type: esriFieldTypeString, alias: ReplacementAssetNumber, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• CurrentlyUnavailableReason (type: esriFieldTypeString, alias: Reason, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [OnBreak: On Break (Sleep, etc.)], [Problem: Problem with the vehicle (needs time to repair)], [Maintenance: Standard Maintenance (gas, changing driver)], ... 1 more ...)
• CoachBusUnavailable (type: esriFieldTypeInteger, alias: Coach Buses Unavailable, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ParatransitUnavailable (type: esriFieldTypeInteger, alias: Unavailable Paratransit, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SchoolBusUnavailable (type: esriFieldTypeInteger, alias: Unavailable School Bus, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VanUnavailable (type: esriFieldTypeInteger, alias: Unavailable Van, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OtherUnavailable (type: esriFieldTypeInteger, alias: Unavailable Other, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TotalBusesAvailable (type: esriFieldTypeInteger, alias: Available Total, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TotalBusesUnavailable (type: esriFieldTypeInteger, alias: Unavailable Total, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ParatransitAvailable (type: esriFieldTypeInteger, alias: Paratransit Availablt, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CoachBusAvailable (type: esriFieldTypeInteger, alias: Available Coach Bus, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SchoolBusAvailable (type: esriFieldTypeInteger, alias: Available School Bus, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VanAvailable (type: esriFieldTypeInteger, alias: Available Van, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OtherAvailable (type: esriFieldTypeInteger, alias: Available Other, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Assignment (type: esriFieldTypeString, alias: Assignment or Task, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TotalBuses (type: esriFieldTypeInteger, alias: Total Buses, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: BusLogisticsSurvey
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• Status: Active

Relationships:

• Convenience (0) -- Related To: Convenience (2)
• (1) -- Related To: regular (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/1/2021 5:47:28 PM

Schema Last Edit Date: 6/1/2021 5:47:28 PM

Data Last Edit Date: 6/1/2021 5:47:28 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat