View In:   ArcGIS Online Map Viewer

Name: Workorder

Display Field: WORKORDERID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Cityworks Workorders - UFA Trees

Copyright Text: DDOT, UFA

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 10000

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: 390098.6019999981
YMin: 127298.21999999881
XMax: 419114.6950000003
YMax: 160192.39499999955
Spatial Reference: 26985  (26985)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• WORKORDERID ( type: esriFieldTypeString, alias: WORKORDERID, editable: true, nullable: false, length: 60, defaultValue: null, modelName: WORKORDERID )
• ENTITYUID ( type: esriFieldTypeString, alias: ENTITYUID, editable: true, nullable: false, length: 50, defaultValue: null, modelName: ENTITYUID )
• MATERIALID ( type: esriFieldTypeString, alias: MATERIALID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MATERIALID )
• PROJECTID ( type: esriFieldTypeInteger, alias: PROJECTID, editable: true, nullable: true, defaultValue: null, modelName: PROJECTID )
• DESCRIPTION ( type: esriFieldTypeString, alias: DESCRIPTION, editable: true, nullable: true, length: 60, defaultValue: null, modelName: DESCRIPTION , Coded Values: [GINKGO INJECTION: Injection to control fruiting of Female Ginkgo] , [INSPECTION: Inspection Work Order] , [PERMITS: Work Order related to Permit Review] , ...17 more... )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STATUS , Coded Values: [APPROVED: Approved] , [CANCEL: Cancel] , [CLOSED: Closed] , ...6 more... )
• INITIATEDDATE ( type: esriFieldTypeDate, alias: INITIATEDDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INITIATEDDATE )
• WORKORDERCLOSEDDATE ( type: esriFieldTypeDate, alias: WORKORDERCLOSEDDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WORKORDERCLOSEDDATE )
• ACTUALSTARTDATE ( type: esriFieldTypeDate, alias: ACTUALSTARTDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ACTUALSTARTDATE )
• ACTUALFINISHDATE ( type: esriFieldTypeDate, alias: ACTUALFINISHDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ACTUALFINISHDATE )
• PROJECTNAME ( type: esriFieldTypeString, alias: PROJECTNAME, editable: true, nullable: true, length: 130, defaultValue: null, modelName: PROJECTNAME )
• WORKORDERMATERIALCOST ( type: esriFieldTypeDouble, alias: WORKORDERMATERIALCOST, editable: true, nullable: true, defaultValue: null, modelName: WORKORDERMATERIALCOST )
• UNITSACCOMPLISHED ( type: esriFieldTypeDouble, alias: UNITSACCOMPLISHED, editable: true, nullable: true, defaultValue: null, modelName: UNITSACCOMPLISHED )
• UNITSACCOMPISHEDDESCRIPTION ( type: esriFieldTypeString, alias: UNITSACCOMPISHEDDESCRIPTION, editable: true, nullable: true, length: 40, defaultValue: null, modelName: UNITSACCOMPISHEDDESCRIPTION )
• PRIORITY ( type: esriFieldTypeString, alias: PRIORITY, editable: true, nullable: true, length: 2, defaultValue: null, modelName: PRIORITY )
• INITIATEDBY ( type: esriFieldTypeString, alias: INITIATEDBY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INITIATEDBY )
• WORKORDERCLOSEDBY ( type: esriFieldTypeString, alias: WORKORDERCLOSEDBY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WORKORDERCLOSEDBY )
• PEPCONEEDED ( type: esriFieldTypeString, alias: PEPCONEEDED, editable: true, nullable: true, length: 1, defaultValue: null, modelName: PEPCONEEDED )
• SENTTOCONTRACTOR ( type: esriFieldTypeString, alias: SENTTOCONTRACTOR, editable: true, nullable: true, length: 1, defaultValue: null, modelName: SENTTOCONTRACTOR )
• ISCANCELED ( type: esriFieldTypeString, alias: ISCANCELED, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ISCANCELED )
• CANCELEDBY ( type: esriFieldTypeString, alias: CANCELEDBY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CANCELEDBY )
• CANCELEDDATE ( type: esriFieldTypeDate, alias: CANCELEDDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CANCELEDDATE )
• CONTRACTORID ( type: esriFieldTypeInteger, alias: CONTRACTORID, editable: true, nullable: true, defaultValue: null, modelName: CONTRACTORID )
• WORKCOMPLETEDBY ( type: esriFieldTypeString, alias: WORKCOMPLETEDBY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WORKCOMPLETEDBY )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, editable: true, nullable: true, length: 130, defaultValue: null, modelName: ADDRESS )
• FISCALYEAR ( type: esriFieldTypeSmallInteger, alias: FISCALYEAR, editable: true, nullable: true, defaultValue: null, modelName: FISCALYEAR )
• WARD ( type: esriFieldTypeString, alias: WARD, editable: true, nullable: true, length: 1, defaultValue: null, modelName: WARD )
• QUADRANT ( type: esriFieldTypeString, alias: QUADRANT, editable: true, nullable: true, length: 2, defaultValue: null, modelName: QUADRANT )
• ZIPCODE ( type: esriFieldTypeString, alias: ZIPCODE, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ZIPCODE )
• ANC ( type: esriFieldTypeString, alias: ANC, editable: true, nullable: true, length: 2, defaultValue: null, modelName: ANC )
• SMD ( type: esriFieldTypeString, alias: SMD, editable: true, nullable: true, length: 4, defaultValue: null, modelName: SMD )
• NEIGHBORHOODCLUSTERS ( type: esriFieldTypeString, alias: NEIGHBORHOODCLUSTERS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NEIGHBORHOODCLUSTERS )
• NEIGHBORHOODNAMES ( type: esriFieldTypeString, alias: NEIGHBORHOODNAMES, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NEIGHBORHOODNAMES )
• BID ( type: esriFieldTypeString, alias: BID, editable: true, nullable: true, length: 100, defaultValue: null, modelName: BID )
• AWI ( type: esriFieldTypeString, alias: AWI, editable: true, nullable: true, length: 100, defaultValue: null, modelName: AWI )
• EDZ ( type: esriFieldTypeString, alias: EDZ, editable: true, nullable: true, length: 100, defaultValue: null, modelName: EDZ )
• NIF ( type: esriFieldTypeString, alias: NIF, editable: true, nullable: true, length: 100, defaultValue: null, modelName: NIF )
• HISTORICDISTRICT ( type: esriFieldTypeString, alias: HISTORICDISTRICT, editable: true, nullable: true, length: 100, defaultValue: null, modelName: HISTORICDISTRICT )
• ZONING ( type: esriFieldTypeString, alias: ZONING, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ZONING )
• PUD ( type: esriFieldTypeString, alias: PUD, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PUD )
• CFAR ( type: esriFieldTypeString, alias: CFAR, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CFAR )
• PSA ( type: esriFieldTypeString, alias: PSA, editable: true, nullable: true, length: 5, defaultValue: null, modelName: PSA )
• PD ( type: esriFieldTypeString, alias: PD, editable: true, nullable: true, length: 5, defaultValue: null, modelName: PD )
• ARBORIST ( type: esriFieldTypeString, alias: ARBORIST, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ARBORIST )
• TEAM ( type: esriFieldTypeSmallInteger, alias: TEAM, editable: true, nullable: true, defaultValue: null, modelName: TEAM )
• DAYSTOCLOSE ( type: esriFieldTypeInteger, alias: DAYSTOCLOSE, editable: true, nullable: true, defaultValue: null, modelName: DAYSTOCLOSE )
• XCOORD ( type: esriFieldTypeDouble, alias: XCOORD, editable: true, nullable: true, defaultValue: null, modelName: XCOORD )
• YCOORD ( type: esriFieldTypeDouble, alias: YCOORD, editable: true, nullable: true, defaultValue: null, modelName: YCOORD )
• ONSEGX ( type: esriFieldTypeDouble, alias: ONSEGX, editable: true, nullable: true, defaultValue: null, modelName: ONSEGX )
• ONSEGY ( type: esriFieldTypeDouble, alias: ONSEGY, editable: true, nullable: true, defaultValue: null, modelName: ONSEGY )
• UPDATEDATE ( type: esriFieldTypeDate, alias: UPDATEDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: UPDATEDATE )
• DAYSELAPSEDTOCLOSE ( type: esriFieldTypeDouble, alias: DAYSELAPSEDTOCLOSE, editable: true, nullable: true, defaultValue: null, modelName: DAYSELAPSEDTOCLOSE )
• CONTRACTORNAME ( type: esriFieldTypeString, alias: CONTRACTORNAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CONTRACTORNAME )
• EXISTINGSPECIES ( type: esriFieldTypeString, alias: EXISTINGSPECIES, editable: true, nullable: true, length: 100, defaultValue: null, modelName: EXISTINGSPECIES )
• PLANTINGSPECIES ( type: esriFieldTypeString, alias: PLANTINGSPECIES, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PLANTINGSPECIES )
• TREEOWNER ( type: esriFieldTypeString, alias: TREEOWNER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TREEOWNER )
• DBH ( type: esriFieldTypeString, alias: DBH, editable: true, nullable: true, length: 6, defaultValue: null, modelName: DBH )
• DBH1 ( type: esriFieldTypeSmallInteger, alias: DBH1, editable: true, nullable: true, defaultValue: null, modelName: DBH1 )

Templates:

• Name: Workorder
  Description:
  Prototype:
  DBH: null
  WORKORDERID:
  ENTITYUID:
  MATERIALID: null
  PROJECTID: null
  DESCRIPTION: null
  STATUS: null
  INITIATEDDATE: null
  WORKORDERCLOSEDDATE: null
  ACTUALSTARTDATE: null
  ACTUALFINISHDATE: null
  PROJECTNAME: null
  WORKORDERMATERIALCOST: null
  UNITSACCOMPLISHED: null
  UNITSACCOMPISHEDDESCRIPTION: null
  PRIORITY: null
  INITIATEDBY: null
  WORKORDERCLOSEDBY: null
  PEPCONEEDED: null
  SENTTOCONTRACTOR: null
  ISCANCELED: null
  CANCELEDBY: null
  CANCELEDDATE: null
  CONTRACTORID: null
  WORKCOMPLETEDBY: null
  ADDRESS: null
  FISCALYEAR: null
  WARD: null
  QUADRANT: null
  ZIPCODE: null
  ANC: null
  SMD: null
  NEIGHBORHOODCLUSTERS: null
  NEIGHBORHOODNAMES: null
  BID: null
  AWI: null
  EDZ: null
  NIF: null
  HISTORICDISTRICT: null
  ZONING: null
  PUD: null
  CFAR: null
  PSA: null
  PD: null
  ARBORIST: null
  TEAM: null
  DAYSTOCLOSE: null
  XCOORD: null
  YCOORD: null
  ONSEGX: null
  ONSEGY: null
  UPDATEDATE: null
  DAYSELAPSEDTOCLOSE: null
  CONTRACTORNAME: null
  EXISTINGSPECIES: null
  PLANTINGSPECIES: null
  TREEOWNER: null
  DBH1: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata