View In:   ArcGIS Online Map Viewer

Name: CityworksRequest

Display Field: REQUESTID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Cityworks Service Requests - All 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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: -9075744.0374
YMin: 4519978.7946000025
XMax: -8561529.940469397
YMax: 4720992.115819838
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: INSPCOMP
  Label: Inspection Completed
  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:
  
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: STATUS

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: [ALLEY REPAIR: Alley Repair] , [ALLEY REPAVE: Alley Repave] , [ALLEYLIGHT REPAIR: Alleylight Repair] , ...72 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... )
• REQUESTCATEGORY ( type: esriFieldTypeString, alias: REQUESTCATEGORY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: REQUESTCATEGORY , Coded Values: [EMERG: Snow Emergency Services] , [IPMA: Infrastructure Project Management Administration ] , [NULL: Department of Public Works] , ...11 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 )
• SUBMITTEDTODATE ( type: esriFieldTypeDate, alias: SUBMITTEDTODATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SUBMITTEDTODATE )
• DISPATCHEDTODATE ( type: esriFieldTypeDate, alias: DISPATCHEDTODATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DISPATCHEDTODATE )
• CANCELEDDATE ( type: esriFieldTypeDate, alias: CANCELEDDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CANCELEDDATE )
• 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 )
• SUBMITTEDTO ( type: esriFieldTypeString, alias: SUBMITTEDTO, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SUBMITTEDTO )
• DISPATCHEDTO ( type: esriFieldTypeString, alias: DISPATCHEDTO, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DISPATCHEDTO )
• CLOSEDBY ( type: esriFieldTypeString, alias: CLOSEDBY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CLOSEDBY )
• PROJECTNAME ( type: esriFieldTypeString, alias: PROJECTNAME, editable: true, nullable: true, length: 130, defaultValue: null, modelName: PROJECTNAME )
• 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 )
• 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 )
• 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 )
• UPDATEDATE ( type: esriFieldTypeDate, alias: UPDATEDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: UPDATEDATE )
• 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 )
• LONGITUDE ( type: esriFieldTypeDouble, alias: LONGITUDE, editable: true, nullable: true, defaultValue: null, modelName: LONGITUDE )
• LATITUDE ( type: esriFieldTypeDouble, alias: LATITUDE, editable: true, nullable: true, defaultValue: null, modelName: LATITUDE )
• SQUARE ( type: esriFieldTypeString, alias: SQUARE, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SQUARE )
• SUFFIX ( type: esriFieldTypeString, alias: SUFFIX, editable: true, nullable: true, length: 2, defaultValue: null, modelName: SUFFIX )
• LOT ( type: esriFieldTypeString, alias: LOT, editable: true, nullable: true, length: 5, defaultValue: null, modelName: LOT )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Types:

ID: PENDING
Name: Pending
Domains:
• DESCRIPTION:
  Inherited
• STATUS:
  Inherited
• REQUESTCATEGORY:
  Inherited
Templates:
• Name: Pending
  Description:
  Prototype:
  DESCRIPTION: null
  LOT: null
  REQUESTID: null
  WORKORDERID: null
  CSRNUMBER: null
  STATUS: PENDING
  REQUESTCATEGORY: null
  INITIATEDDATE: null
  CLOSEDDATE: null
  INSPECTIONDATE: null
  INSPECTIONCOMPLETE: null
  SUBMITTEDTODATE: null
  DISPATCHEDTODATE: null
  CANCELEDDATE: null
  PRIORITY: null
  INITIATEDBY: null
  SUBMITTEDTO: null
  DISPATCHEDTO: null
  CLOSEDBY: null
  PROJECTNAME: null
  ISCANCELED: null
  CANCELEDBY: 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
  DAYSTOCLOSE: null
  DAYSTOINSPECT: null
  UPDATEDATE: null
  XCOORD: null
  YCOORD: null
  ONSEGX: null
  ONSEGY: null
  LONGITUDE: null
  LATITUDE: null
  SQUARE: null
  SUFFIX: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: INSPCOMP
Name: Inspection Completed
Domains:
• DESCRIPTION:
  Inherited
• STATUS:
  Inherited
• REQUESTCATEGORY:
  Inherited
Templates:
• Name: Inspection Completed
  Description:
  Prototype:
  DESCRIPTION: null
  LOT: null
  REQUESTID: null
  WORKORDERID: null
  CSRNUMBER: null
  STATUS: INSPCOMP
  REQUESTCATEGORY: null
  INITIATEDDATE: null
  CLOSEDDATE: null
  INSPECTIONDATE: null
  INSPECTIONCOMPLETE: null
  SUBMITTEDTODATE: null
  DISPATCHEDTODATE: null
  CANCELEDDATE: null
  PRIORITY: null
  INITIATEDBY: null
  SUBMITTEDTO: null
  DISPATCHEDTO: null
  CLOSEDBY: null
  PROJECTNAME: null
  ISCANCELED: null
  CANCELEDBY: 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
  DAYSTOCLOSE: null
  DAYSTOINSPECT: null
  UPDATEDATE: null
  XCOORD: null
  YCOORD: null
  ONSEGX: null
  ONSEGY: null
  LONGITUDE: null
  LATITUDE: null
  SQUARE: null
  SUFFIX: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: COMPLETE
Name: Completed
Domains:
• DESCRIPTION:
  Inherited
• STATUS:
  Inherited
• REQUESTCATEGORY:
  Inherited
Templates:
• Name: Completed
  Description:
  Prototype:
  DESCRIPTION: null
  LOT: null
  REQUESTID: null
  WORKORDERID: null
  CSRNUMBER: null
  STATUS: COMPLETE
  REQUESTCATEGORY: null
  INITIATEDDATE: null
  CLOSEDDATE: null
  INSPECTIONDATE: null
  INSPECTIONCOMPLETE: null
  SUBMITTEDTODATE: null
  DISPATCHEDTODATE: null
  CANCELEDDATE: null
  PRIORITY: null
  INITIATEDBY: null
  SUBMITTEDTO: null
  DISPATCHEDTO: null
  CLOSEDBY: null
  PROJECTNAME: null
  ISCANCELED: null
  CANCELEDBY: 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
  DAYSTOCLOSE: null
  DAYSTOINSPECT: null
  UPDATEDATE: null
  XCOORD: null
  YCOORD: null
  ONSEGX: null
  ONSEGY: null
  LONGITUDE: null
  LATITUDE: null
  SQUARE: null
  SUFFIX: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: OPEN
Name: Open
Domains:
• DESCRIPTION:
  Inherited
• STATUS:
  Inherited
• REQUESTCATEGORY:
  Inherited
Templates:
• Name: Open
  Description:
  Prototype:
  DESCRIPTION: null
  LOT: null
  REQUESTID: null
  WORKORDERID: null
  CSRNUMBER: null
  STATUS: OPEN
  REQUESTCATEGORY: null
  INITIATEDDATE: null
  CLOSEDDATE: null
  INSPECTIONDATE: null
  INSPECTIONCOMPLETE: null
  SUBMITTEDTODATE: null
  DISPATCHEDTODATE: null
  CANCELEDDATE: null
  PRIORITY: null
  INITIATEDBY: null
  SUBMITTEDTO: null
  DISPATCHEDTO: null
  CLOSEDBY: null
  PROJECTNAME: null
  ISCANCELED: null
  CANCELEDBY: 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
  DAYSTOCLOSE: null
  DAYSTOINSPECT: null
  UPDATEDATE: null
  XCOORD: null
  YCOORD: null
  ONSEGX: null
  ONSEGY: null
  LONGITUDE: null
  LATITUDE: null
  SQUARE: null
  SUFFIX: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: CLOSED
Name: Closed
Domains:
• DESCRIPTION:
  Inherited
• STATUS:
  Inherited
• REQUESTCATEGORY:
  Inherited
Templates:
• Name: Closed
  Description:
  Prototype:
  DESCRIPTION: null
  LOT: null
  REQUESTID: null
  WORKORDERID: null
  CSRNUMBER: null
  STATUS: CLOSED
  REQUESTCATEGORY: null
  INITIATEDDATE: null
  CLOSEDDATE: null
  INSPECTIONDATE: null
  INSPECTIONCOMPLETE: null
  SUBMITTEDTODATE: null
  DISPATCHEDTODATE: null
  CANCELEDDATE: null
  PRIORITY: null
  INITIATEDBY: null
  SUBMITTEDTO: null
  DISPATCHEDTO: null
  CLOSEDBY: null
  PROJECTNAME: null
  ISCANCELED: null
  CANCELEDBY: 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
  DAYSTOCLOSE: null
  DAYSTOINSPECT: null
  UPDATEDATE: null
  XCOORD: null
  YCOORD: null
  ONSEGX: null
  ONSEGY: null
  LONGITUDE: null
  LATITUDE: null
  SQUARE: null
  SUFFIX: 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