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

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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: false
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: true
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: null

Fields:

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

Relationships:

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

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata