Layers:

Layer: Depots (1)

Name: Depots

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 624529f1bba14edd8d03e0119271298d

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:
XMin: 106.81433661100004
YMin: -6.303889485999946
XMax: 106.83559698600004
YMax: -6.184738822999975
Spatial Reference: 4326  (4326)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
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: true
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: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: true

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• objectid ( modelName: objectid, nullable: false, editable: false, defaultValue: N/A, alias: OBJECTID, type: esriFieldTypeOID )
• depot_id ( modelName: depot_id, nullable: true, editable: true, defaultValue: N/A, length: 5, alias: Depot ID, type: esriFieldTypeString )
• depot_name ( modelName: depot_name, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Depot Name, type: esriFieldTypeString )
• address ( modelName: address, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Address, type: esriFieldTypeString )
• sub_region ( modelName: sub_region, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Sub Region, type: esriFieldTypeString )
• region ( modelName: region, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Region, type: esriFieldTypeString )
• postal_code ( modelName: postal_code, nullable: true, editable: true, defaultValue: N/A, alias: Postal Code, type: esriFieldTypeInteger )
• stock ( modelName: stock, nullable: true, editable: true, defaultValue: N/A, alias: Stock, type: esriFieldTypeInteger )
• capacity ( modelName: capacity, nullable: true, editable: true, defaultValue: N/A, alias: Capacity, type: esriFieldTypeInteger )
• longitude ( modelName: longitude, nullable: true, editable: true, defaultValue: N/A, alias: Longitude, type: esriFieldTypeDouble )
• latitude ( modelName: latitude, nullable: true, editable: true, defaultValue: N/A, alias: Latitude, type: esriFieldTypeDouble )
Templates:
• Name: Depots
  Description:
  Prototype:
  depot_name: null
  address: null
  latitude: null
  depot_id: null
  sub_region: null
  region: null
  postal_code: null
  stock: null
  longitude: null
  capacity: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• prd_herewego.sde.Sample_Vehicle_Feature (0) -- Related To: Vehicle (3)

Layer: Orders (2)

Name: Orders

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:
XMin: 106.77696419900008
YMin: -6.321263688999977
XMax: 106.86340137900004
YMax: -6.163848233999943
Spatial Reference: 4326  (4326)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
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: true
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: true
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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• objectid ( modelName: objectid, nullable: false, editable: false, defaultValue: N/A, alias: OBJECTID, type: esriFieldTypeOID )
• order_id ( modelName: order_id, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Order ID, type: esriFieldTypeString )
• customer_id ( modelName: customer_id, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Customer ID, type: esriFieldTypeString )
• customer_name ( modelName: customer_name, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Customer Name, type: esriFieldTypeString )
• order_date ( modelName: order_date, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: Order Date, type: esriFieldTypeDate )
• delivery_date ( modelName: delivery_date, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: Delivery Date, type: esriFieldTypeDate )
• quantity ( modelName: quantity, nullable: true, editable: true, defaultValue: N/A, alias: Quantity, type: esriFieldTypeInteger )
• tw_start ( modelName: tw_start, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: Time Window Start, type: esriFieldTypeTimeOnly )
• tw_end ( modelName: tw_end, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: Time Window End, type: esriFieldTypeTimeOnly )
• status ( modelName: status, nullable: true, editable: true, defaultValue: N/A, alias: Status, type: esriFieldTypeInteger )
• longitude ( modelName: longitude, nullable: true, editable: true, defaultValue: N/A, alias: Longitude, type: esriFieldTypeDouble )
• latitude ( modelName: latitude, nullable: true, editable: true, defaultValue: N/A, alias: Latitude, type: esriFieldTypeDouble )
Templates:
• Name: Orders
  Description:
  Prototype:
  order_date: null
  delivery_date: null
  quantity: null
  tw_start: null
  tw_end: null
  latitude: null
  customer_name: null
  customer_id: null
  order_id: null
  longitude: null
  status: null
  
  Drawing Tool: esriFeatureEditToolPoint

Layer: Vehicle (3)

Name: Vehicle

Display Field: vehicle_id

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 624529f1bba14edd8d03e0119271298d

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:
XMin: 106.81433700000008
YMin: -6.30388899999997
XMax: 106.83559700000006
YMax: -6.184738999999979
Spatial Reference: 4326  (4326)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
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: true
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: true
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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• objectid ( modelName: objectid, nullable: false, editable: false, defaultValue: N/A, alias: OBJECTID, type: esriFieldTypeOID )
• vehicle_id ( modelName: vehicle_id, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: vehicle_id, type: esriFieldTypeString )
• vehicle_type_id ( modelName: vehicle_type_id, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: vehicle_type_id, type: esriFieldTypeString )
• plate_number ( modelName: plate_number, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: plate_number, type: esriFieldTypeString )
• driver ( modelName: driver, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: driver, type: esriFieldTypeString )
• depot_id ( modelName: depot_id, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: depot_id, type: esriFieldTypeString )
• status ( modelName: status, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: status, type: esriFieldTypeString , Coded Values: [IDLE: IDLE] , [ASSIGNED: ASSIGNED] , [OUT_OF_SERVICES: OUT_OF_SERVICES] )
• longitude ( modelName: longitude, nullable: true, editable: true, defaultValue: N/A, alias: longitude, type: esriFieldTypeDouble )
• latitude ( modelName: latitude, nullable: true, editable: true, defaultValue: N/A, alias: latitude, type: esriFieldTypeDouble )
Templates:
• Name: Vehicle
  Description:
  Prototype:
  vehicle_type_id: null
  driver: null
  latitude: null
  depot_id: null
  plate_number: null
  vehicle_id: null
  longitude: null
  status: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• prd_herewego.sde.sample_vehicle_type (1) -- Related To: Sample Vehicle Type (4)
• prd_herewego.sde.sample_depots (0) -- Related To: Depots (1)

Tables:

Table: Sample Vehicle Type (4)

Name: Sample Vehicle Type

Display Field: vehicle_type_id

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 624529f1bba14edd8d03e0119271298d

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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: true
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: true
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 ( modelName: objectid, nullable: false, editable: false, defaultValue: N/A, alias: OBJECTID, type: esriFieldTypeOID )
• vehicle_type_id ( modelName: vehicle_type_id, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Vehicle Type Id, type: esriFieldTypeString )
• vehicle_type_name ( modelName: vehicle_type_name, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: Vehicle Type Name, type: esriFieldTypeString )
• capacity ( modelName: capacity, nullable: true, editable: true, defaultValue: N/A, alias: Capacity, type: esriFieldTypeInteger )
• fixed_trip_cost_rp ( modelName: fixed_trip_cost_rp, nullable: true, editable: true, defaultValue: N/A, alias: Fixed Trip Cost (Rp), type: esriFieldTypeBigInteger )
• fuel_cost_per_km ( modelName: fuel_cost_per_km, nullable: true, editable: true, defaultValue: N/A, alias: Fuel Cost (/km), type: esriFieldTypeBigInteger )
Templates:
• Name: Sample Vehicle Type
  Description:
  Prototype:
  fuel_cost_per_km: null
  fixed_trip_cost_rp: null
  vehicle_type_id: null
  vehicle_type_name: null
  capacity: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• prd_herewego.sde.Sample_Vehicle_Feature (1) -- Related To: Vehicle (3)