Name: CityworksWorkorder

Display Field: WORKORDERID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Cityworks Workorders - Al l Caterories

Copyright Text: DDOT

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 100000

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: -9082179.9197
YMin: -3110498.18090996
XMax: 8571183.8662
YMax: 6804645.93079291
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: STATUS
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: PENDING
  Label: Pending
  Description: N/A
  Symbol:
  
• Value: APPROVED
  Label: Approved
  Description: N/A
  Symbol:
  
• Value: COMPLETE
  Label: Completed
  Description: N/A
  Symbol:
  
• Value: OPEN
  Label: Open
  Description: N/A
  Symbol:
  
• Value: CLOSED
  Label: Closed
  Description: N/A
  Symbol:
  
• Value: MCP
  Label: MCP
  Description: N/A
  Symbol:
  
• Value: INCMPLT
  Label: Incomplete
  Description: N/A
  Symbol:
  
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: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• WORKORDERID ( type: esriFieldTypeString, alias: WORKORDERID, length: 60 )
• PROJECTID ( type: esriFieldTypeInteger, alias: PROJECTID )
• DESCRIPTION ( type: esriFieldTypeString, alias: DESCRIPTION, length: 60 )
• STATUS ( type: esriFieldTypeString, alias: STATUS, length: 50 , Coded Values: [APPROVED: Approved] , [CANCEL: Cancel] , [CLOSED: Closed] , ...6 more... )
• INITIATEDDATE ( type: esriFieldTypeDate, alias: INITIATEDDATE, length: 8 )
• WORKORDERCLOSEDDATE ( type: esriFieldTypeDate, alias: WORKORDERCLOSEDDATE, length: 8 )
• ACTUALSTARTDATE ( type: esriFieldTypeDate, alias: ACTUALSTARTDATE, length: 8 )
• ACTUALFINISHDATE ( type: esriFieldTypeDate, alias: ACTUALFINISHDATE, length: 8 )
• PROJECTNAME ( type: esriFieldTypeString, alias: PROJECTNAME, length: 130 )
• PRIORITY ( type: esriFieldTypeString, alias: PRIORITY, length: 2 )
• SOURCEWORKORDERID ( type: esriFieldTypeString, alias: SOURCEWORKORDERID, length: 20 )
• CYCLETYPE ( type: esriFieldTypeString, alias: CYCLETYPE, length: 1 )
• SCHEDULEDATE ( type: esriFieldTypeDate, alias: SCHEDULEDATE, length: 8 )
• WORKORDERCATEGORY ( type: esriFieldTypeString, alias: WORKORDERCATEGORY, length: 50 )
• UNATTACHED ( type: esriFieldTypeString, alias: UNATTACHED, length: 1 )
• WORKORDERCOST ( type: esriFieldTypeDouble, alias: WORKORDERCOST )
• WORKORDERLABORCOST ( type: esriFieldTypeDouble, alias: WORKORDERLABORCOST )
• WORKORDERMATERIALCOST ( type: esriFieldTypeDouble, alias: WORKORDERMATERIALCOST )
• WORKORDEREQUIPMENTCOST ( type: esriFieldTypeDouble, alias: WORKORDEREQUIPMENTCOST )
• SUBMITTEDTO ( type: esriFieldTypeString, alias: SUBMITTEDTO, length: 50 )
• SUBMITTEDTODATE ( type: esriFieldTypeDate, alias: SUBMITTEDTODATE, length: 8 )
• WORKCOMPLETEDBY ( type: esriFieldTypeString, alias: WORKCOMPLETEDBY, length: 50 )
• WORKORDERCLOSEDBY ( type: esriFieldTypeString, alias: WORKORDERCLOSEDBY, length: 50 )
• ISCANCELED ( type: esriFieldTypeString, alias: ISCANCELED, length: 1 )
• CANCELEDBY ( type: esriFieldTypeString, alias: CANCELEDBY, length: 50 )
• CANCELEDDATE ( type: esriFieldTypeDate, alias: CANCELEDDATE, length: 8 )
• ASSETGROUP ( type: esriFieldTypeString, alias: ASSETGROUP, length: 20 )
• SUPERVISOR ( type: esriFieldTypeString, alias: SUPERVISOR, length: 50 )
• REQUESTEDBY ( type: esriFieldTypeString, alias: REQUESTEDBY, length: 50 )
• INITIATEDBY ( type: esriFieldTypeString, alias: INITIATEDBY, length: 50 )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 130 )
• FISCALYEAR ( type: esriFieldTypeSmallInteger, alias: FISCALYEAR )
• WARD ( type: esriFieldTypeString, alias: WARD, length: 1 )
• QUADRANT ( type: esriFieldTypeString, alias: QUADRANT, length: 2 )
• ZIPCODE ( type: esriFieldTypeString, alias: ZIPCODE, length: 5 )
• ANC ( type: esriFieldTypeString, alias: ANC, length: 2 )
• SMD ( type: esriFieldTypeString, alias: SMD, length: 4 )
• NEIGHBORHOODCLUSTERS ( type: esriFieldTypeString, alias: NEIGHBORHOODCLUSTERS, length: 50 )
• NEIGHBORHOODNAMES ( type: esriFieldTypeString, alias: NEIGHBORHOODNAMES, length: 50 )
• BID ( type: esriFieldTypeString, alias: BID, length: 100 )
• AWI ( type: esriFieldTypeString, alias: AWI, length: 100 )
• EDZ ( type: esriFieldTypeString, alias: EDZ, length: 100 )
• NIF ( type: esriFieldTypeString, alias: NIF, length: 100 )
• HISTORICDISTRICT ( type: esriFieldTypeString, alias: HISTORICDISTRICT, length: 100 )
• ZONING ( type: esriFieldTypeString, alias: ZONING, length: 10 )
• PUD ( type: esriFieldTypeString, alias: PUD, length: 100 )
• CFAR ( type: esriFieldTypeString, alias: CFAR, length: 100 )
• PSA ( type: esriFieldTypeString, alias: PSA, length: 5 )
• PD ( type: esriFieldTypeString, alias: PD, length: 5 )
• DAYSTOCLOSE ( type: esriFieldTypeInteger, alias: DAYSTOCLOSE )
• UPDATEDATE ( type: esriFieldTypeDate, alias: UPDATEDATE, length: 8 )
• XCOORD ( type: esriFieldTypeDouble, alias: XCOORD )
• YCOORD ( type: esriFieldTypeDouble, alias: YCOORD )
• ONSEGX ( type: esriFieldTypeDouble, alias: ONSEGX )
• ONSEGY ( type: esriFieldTypeDouble, alias: ONSEGY )
• LONGITUDE ( type: esriFieldTypeDouble, alias: LONGITUDE )
• LATITUDE ( type: esriFieldTypeDouble, alias: LATITUDE )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )

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

  Iteminfo   Thumbnail   Metadata