View In:   ArcGIS Online Map Viewer

Name: wpsgndb.DBO.Seguin_PW_WorkOrders

Display Field: TicketNumber

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 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: -8883476.9121
YMin: 5665234.379699998
XMax: -8883476.9121
YMax: 5665234.379699998
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [61, 127, 59, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

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
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: true

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• TicketNumber ( type: esriFieldTypeString, alias: Ticket Number, editable: true, nullable: true, length: 13, defaultValue: null, modelName: TicketNumber )
• WorkTitle ( type: esriFieldTypeString, alias: Work Title, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WorkTitle )
• WorkDescription ( type: esriFieldTypeString, alias: Work Description, editable: true, nullable: true, length: 256, defaultValue: null, modelName: WorkDescription )
• WOType ( type: esriFieldTypeString, alias: WOType, editable: true, nullable: true, length: 10, defaultValue: null, modelName: WOType , Coded Values: [Roads: Roads] , [Waste: Waste] )
• WorkStatus ( type: esriFieldTypeString, alias: Work Status, editable: true, nullable: true, length: 40, defaultValue: New Ticket, modelName: WorkStatus , Coded Values: [In Progress: In Progress] , [Completed: Completed] , [Deferred: Deferred] , ...4 more... )
• Priority ( type: esriFieldTypeString, alias: Priority, editable: true, nullable: true, length: 20, defaultValue: Normal, modelName: Priority , Coded Values: [High: High] , [Normal: Normal] , [Low: Low] )
• AssignedTo ( type: esriFieldTypeString, alias: Assigned To, editable: true, nullable: true, length: 256, defaultValue: None, modelName: AssignedTo , Coded Values: [None: None] , [Gerry Spooner {7055555555}: Gerry Spooner {7055555555}] , [Sifft Electric {7055555555}: Sifft Electric {7055555555}] )
• StartDate ( type: esriFieldTypeDate, alias: Start Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: StartDate )
• DueDate ( type: esriFieldTypeDate, alias: Due Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DueDate )
• CompletedDate ( type: esriFieldTypeDate, alias: Completed Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CompletedDate )
• LocatesRequired ( type: esriFieldTypeString, alias: Locates Required, editable: true, nullable: true, length: 3, defaultValue: No, modelName: LocatesRequired , Coded Values: [No: No] , [Yes: Yes] , [NA: Not Applicable] )
• LocateClearedDate ( type: esriFieldTypeDate, alias: Locate Cleared Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LocateClearedDate )
• LocateID ( type: esriFieldTypeString, alias: LocateID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: LocateID )
• LocationDescription ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 256, defaultValue: null, modelName: LocationDescription )
• ListOfOperators ( type: esriFieldTypeString, alias: List Of Operators, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ListOfOperators )
• PercentageComplete ( type: esriFieldTypeInteger, alias: Percentage Complete, editable: true, nullable: true, defaultValue: 0, modelName: PercentageComplete )
• TotalHours ( type: esriFieldTypeString, alias: Total Hours, editable: true, nullable: true, length: 100, defaultValue: null, modelName: TotalHours )
• NecessaryEquipment ( type: esriFieldTypeString, alias: Necessary Equipment, editable: true, nullable: true, length: 100, defaultValue: null, modelName: NecessaryEquipment )
• Source ( type: esriFieldTypeString, alias: Source, editable: true, nullable: true, length: 255, defaultValue: No Source, modelName: Source )
• WorkOrderID ( type: esriFieldTypeString, alias: Work Order ID, editable: true, nullable: true, length: 12, defaultValue: Not Assigned, modelName: WorkOrderID )
• Archive ( type: esriFieldTypeSmallInteger, alias: Archive Status, editable: true, nullable: true, defaultValue: 1, modelName: Archive , Coded Values: [1: Show Internally] , [3: Hide-Archive] )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• WorkOrderType ( type: esriFieldTypeString, alias: WorkOrderType, editable: true, nullable: true, length: 10, defaultValue: null, modelName: WorkOrderType , Coded Values: [Roads: Roads] , [Waste: Waste] )

Templates:

• Name: wpsgndb.DBO.Seguin_PW_WorkOrders
  Description:
  Prototype:
  Archive: 1
  WorkOrderType: null
  TicketNumber: null
  WorkTitle: null
  WorkDescription: null
  WOType: null
  WorkStatus: New Ticket
  Priority: Normal
  AssignedTo: None
  StartDate: null
  DueDate: null
  CompletedDate: null
  LocatesRequired: No
  LocateClearedDate: null
  LocateID: null
  LocationDescription: null
  ListOfOperators: null
  PercentageComplete: 0
  TotalHours: null
  NecessaryEquipment: null
  Source: No Source
  WorkOrderID: Not Assigned
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• wpsgndb.DBO.Seguin_PW_WorkOrder_Comments (0) -- Related To: Seguin_PW_WorkOrder_Comments (964)

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

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

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

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