Name: Orders

Display Field: Name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 1155582

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -74.2525117850502
YMin: 40.4338316262102
XMax: -73.7014092619717
YMax: 40.9727571157899
Spatial Reference: 4326 (4326)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[77,44,135,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:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Name (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 500, nullable: false, editable: true)
• Description (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ServiceTime (type: esriFieldTypeDouble, alias: ServiceTime, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TimeWindowStart (type: esriFieldTypeDate, alias: TimeWindowStart, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• TimeWindowEnd (type: esriFieldTypeDate, alias: TimeWindowEnd, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MaxViolationTime (type: esriFieldTypeDouble, alias: MaxViolationTime, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TimeWindowStart2 (type: esriFieldTypeDate, alias: TimeWindowStart2, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• TimeWindowEnd2 (type: esriFieldTypeDate, alias: TimeWindowEnd2, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MaxViolationTime2 (type: esriFieldTypeDouble, alias: MaxViolationTime2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InboundArriveTime (type: esriFieldTypeDate, alias: InboundArriveTime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• OutboundDepartTime (type: esriFieldTypeDate, alias: OutboundDepartTime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DeliveryQuantity_1 (type: esriFieldTypeDouble, alias: DeliveryQuantity_1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DeliveryQuantity_2 (type: esriFieldTypeDouble, alias: DeliveryQuantity_2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DeliveryQuantity_3 (type: esriFieldTypeDouble, alias: DeliveryQuantity_3, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DeliveryQuantity_4 (type: esriFieldTypeDouble, alias: DeliveryQuantity_4, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DeliveryQuantity_5 (type: esriFieldTypeDouble, alias: DeliveryQuantity_5, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DeliveryQuantity_6 (type: esriFieldTypeDouble, alias: DeliveryQuantity_6, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DeliveryQuantity_7 (type: esriFieldTypeDouble, alias: DeliveryQuantity_7, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DeliveryQuantity_8 (type: esriFieldTypeDouble, alias: DeliveryQuantity_8, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DeliveryQuantity_9 (type: esriFieldTypeDouble, alias: DeliveryQuantity_9, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PickupQuantity_1 (type: esriFieldTypeDouble, alias: PickupQuantity_1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PickupQuantity_2 (type: esriFieldTypeDouble, alias: PickupQuantity_2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PickupQuantity_3 (type: esriFieldTypeDouble, alias: PickupQuantity_3, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PickupQuantity_4 (type: esriFieldTypeDouble, alias: PickupQuantity_4, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PickupQuantity_5 (type: esriFieldTypeDouble, alias: PickupQuantity_5, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PickupQuantity_6 (type: esriFieldTypeDouble, alias: PickupQuantity_6, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PickupQuantity_7 (type: esriFieldTypeDouble, alias: PickupQuantity_7, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PickupQuantity_8 (type: esriFieldTypeDouble, alias: PickupQuantity_8, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PickupQuantity_9 (type: esriFieldTypeDouble, alias: PickupQuantity_9, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Revenue (type: esriFieldTypeDouble, alias: Revenue, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AssignmentRule (type: esriFieldTypeInteger, alias: AssignmentRule, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: Exclude], [1: Preserve route and relative sequence], [2: Preserve route], ... 3 more ...)
• RouteName (type: esriFieldTypeString, alias: RouteName, SQL Type: sqlTypeOther, length: 1024, nullable: true, editable: true)
• Sequence (type: esriFieldTypeInteger, alias: Sequence, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [1 - 2147483647])
• ViolatedConstraint_1 (type: esriFieldTypeInteger, alias: ViolatedConstraint_1, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: MaxOrderCount exceeded], [1: Capacities exceeded], [2: MaxTotalTime exceeded], ... 14 more ...)
• ViolatedConstraint_2 (type: esriFieldTypeInteger, alias: ViolatedConstraint_2, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: MaxOrderCount exceeded], [1: Capacities exceeded], [2: MaxTotalTime exceeded], ... 14 more ...)
• ViolatedConstraint_3 (type: esriFieldTypeInteger, alias: ViolatedConstraint_3, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: MaxOrderCount exceeded], [1: Capacities exceeded], [2: MaxTotalTime exceeded], ... 14 more ...)
• ViolatedConstraint_4 (type: esriFieldTypeInteger, alias: ViolatedConstraint_4, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: MaxOrderCount exceeded], [1: Capacities exceeded], [2: MaxTotalTime exceeded], ... 14 more ...)
• FromPrevTravelTime (type: esriFieldTypeDouble, alias: FromPrevTravelTime, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FromPrevDistance (type: esriFieldTypeDouble, alias: FromPrevDistance, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CumulTravelTime (type: esriFieldTypeDouble, alias: CumulTravelTime, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CumulDistance (type: esriFieldTypeDouble, alias: CumulDistance, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CumulTime (type: esriFieldTypeDouble, alias: CumulTime, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ArriveCurbApproach (type: esriFieldTypeInteger, alias: ArriveCurbApproach, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Either side of vehicle], [1: Right side of vehicle], [2: Left side of vehicle], ... 1 more ...)
• DepartCurbApproach (type: esriFieldTypeInteger, alias: DepartCurbApproach, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Either side of vehicle], [1: Right side of vehicle], [2: Left side of vehicle], ... 1 more ...)
• ArriveTime (type: esriFieldTypeDate, alias: ArriveTime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DepartTime (type: esriFieldTypeDate, alias: DepartTime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ArriveTimeUTC (type: esriFieldTypeDate, alias: ArriveTimeUTC, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DepartTimeUTC (type: esriFieldTypeDate, alias: DepartTimeUTC, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• WaitTime (type: esriFieldTypeDouble, alias: WaitTime, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ViolationTime (type: esriFieldTypeDouble, alias: ViolationTime, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CumulWaitTime (type: esriFieldTypeDouble, alias: CumulWaitTime, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CumulViolationTime (type: esriFieldTypeDouble, alias: CumulViolationTime, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SourceID (type: esriFieldTypeInteger, alias: SourceID, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [-1: ], [1: Routing_Streets], [4: Routing_Streets_Override], ... 1 more ...)
• SourceOID (type: esriFieldTypeInteger, alias: SourceOID, SQL Type: sqlTypeOther, nullable: false, editable: true, Range: [-1 - 2147483647])
• PosAlong (type: esriFieldTypeDouble, alias: PosAlong, SQL Type: sqlTypeOther, nullable: false, editable: true, Range: [0 - 1])
• SideOfEdge (type: esriFieldTypeInteger, alias: SideOfEdge, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [1: Right Side], [2: Left Side])
• CurbApproach (type: esriFieldTypeInteger, alias: CurbApproach, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: Either side of vehicle], [1: Right side of vehicle], [2: Left side of vehicle], ... 1 more ...)
• Status (type: esriFieldTypeInteger, alias: Status, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: OK], [1: Not located], [2: Network element not located], ... 5 more ...)
• SnapX (type: esriFieldTypeDouble, alias: SnapX, SQL Type: sqlTypeOther, nullable: false, editable: true)
• SnapY (type: esriFieldTypeDouble, alias: SnapY, SQL Type: sqlTypeOther, nullable: false, editable: true)
• SnapZ (type: esriFieldTypeDouble, alias: SnapZ, SQL Type: sqlTypeOther, nullable: false, editable: true)
• DistanceToNetworkInMeters (type: esriFieldTypeDouble, alias: DistanceToNetworkInMeters, SQL Type: sqlTypeOther, nullable: false, editable: true)
• Specialty (type: esriFieldTypeString, alias: Specialty, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Office (type: esriFieldTypeString, alias: Office, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)

Templates:

Name: Orders
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/10/2023 10:05:41 PM

Schema Last Edit Date: 3/10/2023 10:05:41 PM

Data Last Edit Date: 3/10/2023 10:05:41 PM

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