View In:   ArcGIS Online Map Viewer

Name: Service Request

Display Field: REQUESTID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Cityworks Service Request - UFA Trees

Copyright Text: DDOT, UFA

Default Visibility: true

MaxRecordCount: 2000

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: 0
YMin: 0
XMax: 407828.7281565732
YMax: 1472414.449000001
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 )
• REQUESTID ( type: esriFieldTypeInteger, alias: REQUESTID, editable: true, nullable: true, defaultValue: null, modelName: REQUESTID )
• WORKORDERID ( type: esriFieldTypeString, alias: WORKORDERID, editable: true, nullable: true, length: 60, defaultValue: null, modelName: WORKORDERID )
• CSRNUMBER ( type: esriFieldTypeString, alias: CSRNUMBER, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CSRNUMBER )
• DESCRIPTION ( type: esriFieldTypeString, alias: DESCRIPTION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DESCRIPTION , Coded Values: [TREE INSPECTION: General Tree Inspection Request] , [TREE REMOVAL: Tree Removal Request] , [TREE PRUNING: Tree Pruning Request] , ...1 more... )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STATUS , Coded Values: [CANCEL: Cancel] , [CLOSED: Closed] , [COMPLETE: Completed] , ...3 more... )
• INITIATEDDATE ( type: esriFieldTypeDate, alias: INITIATEDDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INITIATEDDATE )
• CLOSEDDATE ( type: esriFieldTypeDate, alias: CLOSEDDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CLOSEDDATE )
• INSPECTIONDATE ( type: esriFieldTypeDate, alias: INSPECTIONDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSPECTIONDATE )
• INSPECTIONCOMPLETE ( type: esriFieldTypeString, alias: INSPECTIONCOMPLETE, editable: true, nullable: true, length: 1, defaultValue: null, modelName: INSPECTIONCOMPLETE )
• 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 )
• CLOSEDBY ( type: esriFieldTypeString, alias: CLOSEDBY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CLOSEDBY )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, editable: true, nullable: true, length: 100, 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 )
• DAYSTOINSPECT ( type: esriFieldTypeInteger, alias: DAYSTOINSPECT, editable: true, nullable: true, defaultValue: null, modelName: DAYSTOINSPECT )
• 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 )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 250, defaultValue: null, modelName: COMMENTS )
• UPDATEDATE ( type: esriFieldTypeDate, alias: UPDATEDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: UPDATEDATE )
• ResolutionTimeFrame ( type: esriFieldTypeString, alias: ResolutionTimeFrame, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ResolutionTimeFrame )
• DAYSELAPSEDTOCLOSE ( type: esriFieldTypeDouble, alias: DAYSELAPSEDTOCLOSE, editable: true, nullable: true, defaultValue: null, modelName: DAYSELAPSEDTOCLOSE )
• DAYSELAPSEDTOINSPECT ( type: esriFieldTypeDouble, alias: DAYSELAPSEDTOINSPECT, editable: true, nullable: true, defaultValue: null, modelName: DAYSELAPSEDTOINSPECT )

Templates:

• Name: Service Request
  Description:
  Prototype:
  DAYSELAPSEDTOCLOSE: null
  REQUESTID: null
  WORKORDERID: null
  CSRNUMBER: null
  DESCRIPTION: null
  STATUS: null
  INITIATEDDATE: null
  CLOSEDDATE: null
  INSPECTIONDATE: null
  INSPECTIONCOMPLETE: null
  PRIORITY: null
  INITIATEDBY: null
  CLOSEDBY: 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
  DAYSTOINSPECT: null
  XCOORD: null
  YCOORD: null
  ONSEGX: null
  ONSEGY: null
  COMMENTS: null
  UPDATEDATE: null
  ResolutionTimeFrame: null
  DAYSELAPSEDTOINSPECT: 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