Name: CityWorksServiceReq

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: FID

Unique ID Field:

Name : FID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• REQUESTID (type: esriFieldTypeInteger, alias: REQUESTID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• PROBLEM_DESCRIPTION (type: esriFieldTypeString, alias: PROBLEM_DESCRIPTION, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• PROBLEM_ADDRESS (type: esriFieldTypeString, alias: PROBLEM_ADDRESS, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• PROBLEM_CITY (type: esriFieldTypeString, alias: PROBLEM_CITY, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• PROBLEM_ZIP (type: esriFieldTypeString, alias: PROBLEM_ZIP, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• APARTMENT (type: esriFieldTypeString, alias: APARTMENT, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• DATETIME_INITIATED (type: esriFieldTypeDate, alias: DATETIME_INITIATED, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• DATETIME_CLOSED (type: esriFieldTypeDate, alias: DATETIME_CLOSED, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• SRX (type: esriFieldTypeDouble, alias: SRX, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• SRY (type: esriFieldTypeDouble, alias: SRY, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• COUNCIL_PERSON (type: esriFieldTypeString, alias: COUNCIL_PERSON, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• STATUS (type: esriFieldTypeString, alias: STATUS, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• COUNCIL_DISTRICT (type: esriFieldTypeInteger, alias: COUNCIL_DISTRICT, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• CANCEL_REASON (type: esriFieldTypeString, alias: CANCEL REASON, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• NO_SERVICES_RESOLUTION (type: esriFieldTypeString, alias: NO_SERVICES_RESOLUTION, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• FID (type: esriFieldTypeInteger, alias: FID, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat