Name: Complaint_Violation_Notices

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 1000

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: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)
• RECORD_ID (type: esriFieldTypeString, alias: RECORD_ID, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• FILE_DATE (type: esriFieldTypeDate, alias: FILE_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PARCEL_NUMBER (type: esriFieldTypeString, alias: PARCEL_NUMBER, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• PRIMARY_ADDRESS (type: esriFieldTypeString, alias: PRIMARY_ADDRESS, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• SOURCE (type: esriFieldTypeString, alias: SOURCE, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• VIOLATION_NUMBER (type: esriFieldTypeString, alias: VIOLATION_NUMBER, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• VIOLATION_APP_STATUS (type: esriFieldTypeString, alias: VIOLATION_APP_STATUS, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• COMPLAINT_ACCELA_CITIZEN_ACCESS_URL (type: esriFieldTypeString, alias: COMPLAINT_ACCELA_CITIZEN_ACCESS_URL, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• VIOLATION_ACCELA_CITIZEN_ACCESS_URL (type: esriFieldTypeString, alias: VIOLATION_ACCELA_CITIZEN_ACCESS_URL, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• DW_Ward (type: esriFieldTypeString, alias: DW_Ward, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• DW_Ward2026 (type: esriFieldTypeDouble, alias: DW_Ward2026, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DW_Ward2014 (type: esriFieldTypeDouble, alias: DW_Ward2014, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DW_Tract2020 (type: esriFieldTypeString, alias: DW_Tract2020, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• DW_Neighborhood (type: esriFieldTypeString, alias: DW_Neighborhood, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• DW_Associated_Parcels (type: esriFieldTypeString, alias: DW_Associated_Parcels, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/27/2025 10:20:42 AM

Schema Last Edit Date: 7/27/2025 10:20:42 AM

Data Last Edit Date: 7/27/2025 10:20:42 AM

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