Name: Code Violations

Display Field:

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

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:

• Complaint_Type_Description (type: esriFieldTypeString, alias: Complaint_Type_Description, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Location_1 (type: esriFieldTypeString, alias: Location_1, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Count_ (type: esriFieldTypeInteger, alias: Count, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Case_ID (type: esriFieldTypeString, alias: Case_ID, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Violation_ID (type: esriFieldTypeInteger, alias: Violation_ID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• CFWLand_ObjectID (type: esriFieldTypeInteger, alias: CFWLand_ObjectID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Violation_Address (type: esriFieldTypeString, alias: Violation_Address, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Case_Created_Date (type: esriFieldTypeDate, alias: Case_Created_Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Code_Officer (type: esriFieldTypeString, alias: Code_Officer, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Code_Officer_PhoneNo (type: esriFieldTypeString, alias: Code_Officer_PhoneNo, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Violation_Current_Status (type: esriFieldTypeString, alias: Violation_Current_Status, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Case_Current_Status (type: esriFieldTypeString, alias: Case_Current_Status, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Next_Activity_Due_Date (type: esriFieldTypeString, alias: Next_Activity_Due_Date, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Violation_Created_Date (type: esriFieldTypeDate, alias: Violation_Created_Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Update_Date (type: esriFieldTypeDate, alias: Update_Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• GeoCodeScore (type: esriFieldTypeInteger, alias: GeoCodeScore, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• X_Coordinate (type: esriFieldTypeDouble, alias: X_Coordinate, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Y_Coordinate (type: esriFieldTypeDouble, alias: Y_Coordinate, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/9/2026 1:11:37 PM

Schema Last Edit Date: 1/9/2026 1:11:37 PM

Data Last Edit Date: 1/9/2026 1:11:37 PM

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