Name: Master Tracker Table

Display Field: table_names

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 400

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

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• uid ( type: esriFieldTypeOID, alias: uid, editable: false, nullable: false, defaultValue: null, modelName: uid )
• table_names ( type: esriFieldTypeString, alias: table_names, editable: true, nullable: true, length: 300, defaultValue: null, modelName: table_names )
• maintenance_suggestion_old ( type: esriFieldTypeString, alias: maintenance_suggestion_old, editable: true, nullable: true, length: 50, defaultValue: null, modelName: maintenance_suggestion_old )
• lobound_old ( type: esriFieldTypeSmallInteger, alias: lobound_old, editable: true, nullable: true, defaultValue: null, modelName: lobound_old )
• upbound_old ( type: esriFieldTypeSmallInteger, alias: upbound_old, editable: true, nullable: true, defaultValue: null, modelName: upbound_old )
• unitcost_old ( type: esriFieldTypeSmallInteger, alias: unitcost_old, editable: true, nullable: true, defaultValue: null, modelName: unitcost_old )
• maintenance_suggestion_new ( type: esriFieldTypeString, alias: maintenance_suggestion_new, editable: true, nullable: true, length: 50, defaultValue: null, modelName: maintenance_suggestion_new )
• lobound_new ( type: esriFieldTypeSmallInteger, alias: lobound_new, editable: true, nullable: true, defaultValue: null, modelName: lobound_new )
• upbound_new ( type: esriFieldTypeSmallInteger, alias: upbound_new, editable: true, nullable: true, defaultValue: null, modelName: upbound_new )
• unitcost_new ( type: esriFieldTypeSmallInteger, alias: unitcost_new, editable: true, nullable: true, defaultValue: null, modelName: unitcost_new )
• weight_old ( type: esriFieldTypeSmallInteger, alias: weight_old, editable: true, nullable: true, defaultValue: null, modelName: weight_old )
• weight_new ( type: esriFieldTypeSmallInteger, alias: weight_new, editable: true, nullable: true, defaultValue: null, modelName: weight_new )
• ss_id ( type: esriFieldTypeInteger, alias: ss_id, editable: true, nullable: true, defaultValue: null, modelName: ss_id )
• pci_old ( type: esriFieldTypeSmallInteger, alias: pci_old, editable: true, nullable: true, defaultValue: null, modelName: pci_old )
• estimated_cost_old ( type: esriFieldTypeDouble, alias: estimated_cost_old, editable: true, nullable: true, defaultValue: null, modelName: estimated_cost_old )
• repair_priority_old ( type: esriFieldTypeSmallInteger, alias: repair_priority_old, editable: true, nullable: true, defaultValue: null, modelName: repair_priority_old )
• pci_new ( type: esriFieldTypeSmallInteger, alias: pci_new, editable: true, nullable: true, defaultValue: null, modelName: pci_new )
• estimated_cost_new ( type: esriFieldTypeDouble, alias: estimated_cost_new, editable: true, nullable: true, defaultValue: null, modelName: estimated_cost_new )
• repair_priority_new ( type: esriFieldTypeSmallInteger, alias: repair_priority_new, editable: true, nullable: true, defaultValue: null, modelName: repair_priority_new )
• last_repair_method_old ( type: esriFieldTypeString, alias: last_repair_method_old, editable: true, nullable: true, length: 50, defaultValue: null, modelName: last_repair_method_old )
• last_repair_cost_old ( type: esriFieldTypeDouble, alias: last_repair_cost_old, editable: true, nullable: true, defaultValue: null, modelName: last_repair_cost_old )
• last_repair_date_old ( type: esriFieldTypeDate, alias: last_repair_date_old, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_repair_date_old )
• last_repair_method_new ( type: esriFieldTypeString, alias: last_repair_method_new, editable: true, nullable: true, length: 50, defaultValue: null, modelName: last_repair_method_new )
• last_repair_cost_new ( type: esriFieldTypeDouble, alias: last_repair_cost_new, editable: true, nullable: true, defaultValue: null, modelName: last_repair_cost_new )
• last_repair_date_new ( type: esriFieldTypeDate, alias: last_repair_date_new, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_repair_date_new )
• surface_type_old ( type: esriFieldTypeString, alias: surface_type_old, editable: true, nullable: true, length: 50, defaultValue: null, modelName: surface_type_old )
• surface_type_new ( type: esriFieldTypeString, alias: surface_type_new, editable: true, nullable: true, length: 50, defaultValue: null, modelName: surface_type_new )
• sw_id ( type: esriFieldTypeInteger, alias: sw_id, editable: true, nullable: true, defaultValue: null, modelName: sw_id )
• sci_old ( type: esriFieldTypeInteger, alias: sci_old, editable: true, nullable: true, defaultValue: null, modelName: sci_old )
• update_table ( type: esriFieldTypeString, alias: update_table, editable: true, nullable: true, length: 5, defaultValue: null, modelName: update_table )
• objected ( type: esriFieldTypeInteger, alias: objected, editable: true, nullable: true, defaultValue: null, modelName: objected )
• factor_old ( type: esriFieldTypeString, alias: factor_old, editable: true, nullable: true, length: 150, defaultValue: null, modelName: factor_old )
• factor_new ( type: esriFieldTypeString, alias: factor_new, editable: true, nullable: true, length: 150, defaultValue: null, modelName: factor_new )
• editor_id ( type: esriFieldTypeInteger, alias: editor_id, editable: true, nullable: true, defaultValue: null, modelName: editor_id )
• editor_name ( type: esriFieldTypeString, alias: editor_name, editable: true, nullable: true, length: 300, defaultValue: null, modelName: editor_name )
• last_edit ( type: esriFieldTypeDate, alias: last_edit, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_edit )
• editor_notes ( type: esriFieldTypeString, alias: editor_notes, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: editor_notes )
• fc_old ( type: esriFieldTypeString, alias: fc_old, editable: true, nullable: true, length: 20, defaultValue: null, modelName: fc_old )
• fc_new ( type: esriFieldTypeString, alias: fc_new, editable: true, nullable: true, length: 20, defaultValue: null, modelName: fc_new )
• globalid ( type: esriFieldTypeGlobalID, alias: globalid, editable: false, nullable: false, length: 38, defaultValue: null, modelName: globalid )

Templates:

• Name: Master Tracker Table
  Description:
  Prototype:
  fc_new: null
  fc_old: null
  table_names: null
  maintenance_suggestion_old: null
  lobound_old: null
  upbound_old: null
  unitcost_old: null
  maintenance_suggestion_new: null
  lobound_new: null
  upbound_new: null
  unitcost_new: null
  weight_old: null
  weight_new: null
  ss_id: null
  pci_old: null
  estimated_cost_old: null
  repair_priority_old: null
  pci_new: null
  estimated_cost_new: null
  repair_priority_new: null
  last_repair_method_old: null
  last_repair_cost_old: null
  last_repair_date_old: null
  last_repair_method_new: null
  last_repair_cost_new: null
  last_repair_date_new: null
  surface_type_old: null
  surface_type_new: null
  sw_id: null
  sci_old: null
  update_table: null
  objected: null
  factor_old: null
  factor_new: null
  editor_id: null
  editor_name: null
  last_edit: null
  editor_notes: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata