Name: Violations_Cited_per_Restaurant_Inspection

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

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• Inspection_ID (type: esriFieldTypeInteger, alias: Inspection ID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Inspection_Date (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Establishment_ID (type: esriFieldTypeInteger, alias: Establishment ID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Name (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Inspection_Type (type: esriFieldTypeString, alias: Inspection Type, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Violation_Code (type: esriFieldTypeString, alias: Violation Code, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Violation_Description (type: esriFieldTypeString, alias: Violation Description, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
• Violation_Type (type: esriFieldTypeString, alias: Violation Type, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Location_Description (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Sub_Location (type: esriFieldTypeString, alias: Sub Location, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Item_Description (type: esriFieldTypeString, alias: Item Description, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Sub_Item (type: esriFieldTypeString, alias: Sub Item, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Problem_Description (type: esriFieldTypeString, alias: Problem Description, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Sub_Problem (type: esriFieldTypeString, alias: Sub Problem, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Correction_Description (type: esriFieldTypeString, alias: Correction Description, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Corrected (type: esriFieldTypeString, alias: Corrected, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Days_to_Correct (type: esriFieldTypeInteger, alias: Days to Correct, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Date_Corrected (type: esriFieldTypeDate, alias: Date Corrected, SQL Type: sqlTypeTimestamp2, length: 8, 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: 3/14/2025 4:07:08 AM

Schema Last Edit Date: 3/14/2025 4:07:08 AM

Data Last Edit Date: 3/14/2025 4:07:08 AM

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