Name: Louisville_Metro_KY_Environmental_Health_Bulk_Data_Inspections

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:

• InspectionID (type: esriFieldTypeInteger, alias: InspectionID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• EstablishmentID (type: esriFieldTypeInteger, alias: EstablishmentID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• RequestID (type: esriFieldTypeInteger, alias: RequestID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• EHSNumber (type: esriFieldTypeString, alias: EHSNumber, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• CountyID (type: esriFieldTypeInteger, alias: CountyID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• InspectionDate (type: esriFieldTypeDate, alias: InspectionDate, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• InspectionType (type: esriFieldTypeString, alias: InspectionType, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• IsFollowUpInsp (type: esriFieldTypeString, alias: IsFollowUpInsp, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• R_F_InspIDDesc (type: esriFieldTypeString, alias: R_F_InspIDDesc, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• req_section (type: esriFieldTypeString, alias: req_section, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• GradeID (type: esriFieldTypeString, alias: GradeID, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• score (type: esriFieldTypeInteger, alias: score, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• InspTimeHours (type: esriFieldTypeInteger, alias: InspTimeHours, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• InspTimeMins (type: esriFieldTypeInteger, alias: InspTimeMins, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• sample_attendance (type: esriFieldTypeString, alias: sample_attendance, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SampleAttendance (type: esriFieldTypeString, alias: SampleAttendance, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• NextInspDate (type: esriFieldTypeString, alias: NextInspDate, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• ACTION_CODE_DESC (type: esriFieldTypeString, alias: ACTION_CODE_DESC, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• IsComplaintResolved (type: esriFieldTypeString, alias: IsComplaintResolved, SQL Type: sqlTypeNVarchar, length: 4000, 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: 12/3/2025 1:42:04 PM

Schema Last Edit Date: 12/3/2025 1:42:04 PM

Data Last Edit Date: 12/3/2025 1:41:40 PM

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