Name: Louisville_Metro_KY_Inspection_Violations_of_Failed_Restaurants

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:

• EstablishmentID (type: esriFieldTypeInteger, alias: EstablishmentID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• InspectionDate (type: esriFieldTypeDate, alias: InspectionDate, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• InspectionID (type: esriFieldTypeInteger, alias: InspectionID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• EstTypeDesc (type: esriFieldTypeString, alias: EstTypeDesc, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• premise_name (type: esriFieldTypeString, alias: premise_name, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• premise_adr1_num (type: esriFieldTypeString, alias: premise_adr1_num, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• premise_adr1_street (type: esriFieldTypeString, alias: premise_adr1_street, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• premise_city (type: esriFieldTypeString, alias: premise_city, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• premise_state (type: esriFieldTypeString, alias: premise_state, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• premise_zip (type: esriFieldTypeInteger, alias: premise_zip, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• InspectionType (type: esriFieldTypeString, alias: InspectionType, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• score (type: esriFieldTypeInteger, alias: score, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• InspTypeSpecificViolID (type: esriFieldTypeInteger, alias: InspTypeSpecificViolID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• ViolationDesc (type: esriFieldTypeString, alias: ViolationDesc, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• critical_yn (type: esriFieldTypeString, alias: critical_yn, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Insp_Viol_Comments (type: esriFieldTypeString, alias: Insp_Viol_Comments, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• rpt_area_id (type: esriFieldTypeString, alias: rpt_area_id, SQL Type: sqlTypeNVarchar, length: 256, 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: 7/31/2025 12:42:45 PM

Schema Last Edit Date: 7/31/2025 12:42:45 PM

Data Last Edit Date: 7/31/2025 12:42:41 PM

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