Name: Louisville_Metro_KY_Environmental_Health_Bulk_Data_Establishments

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)
• CountyID (type: esriFieldTypeInteger, alias: CountyID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• RCode (type: esriFieldTypeInteger, alias: RCode, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• RCodeDesc (type: esriFieldTypeString, alias: RCodeDesc, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• EstType (type: esriFieldTypeString, alias: EstType, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PremiseName (type: esriFieldTypeString, alias: PremiseName, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PermiseStreetNo (type: esriFieldTypeString, alias: PermiseStreetNo, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• PremiseStreet (type: esriFieldTypeString, alias: PremiseStreet, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PremiseExtraAddrLine (type: esriFieldTypeString, alias: PremiseExtraAddrLine, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PremiseCity (type: esriFieldTypeString, alias: PremiseCity, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PremiseState (type: esriFieldTypeString, alias: PremiseState, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PremiseZip (type: esriFieldTypeString, alias: PremiseZip, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• InspectionIntervalDays (type: esriFieldTypeInteger, alias: InspectionIntervalDays, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• IsPayFee (type: esriFieldTypeString, alias: IsPayFee, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• IsStateOwned (type: esriFieldTypeString, alias: IsStateOwned, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• WaterProvider (type: esriFieldTypeString, alias: WaterProvider, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SewageProvider (type: esriFieldTypeString, alias: SewageProvider, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• IsBonded (type: esriFieldTypeString, alias: IsBonded, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• RenewalStatus (type: esriFieldTypeString, alias: RenewalStatus, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PermitPrinted (type: esriFieldTypeString, alias: PermitPrinted, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Language (type: esriFieldTypeString, alias: Language, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• RiskType (type: esriFieldTypeString, alias: RiskType, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• MenuType (type: esriFieldTypeString, alias: MenuType, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• IsCaterer (type: esriFieldTypeString, alias: IsCaterer, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• IsDriveThru (type: esriFieldTypeString, alias: IsDriveThru, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• IsTrucksOnly (type: esriFieldTypeString, alias: IsTrucksOnly, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Area (type: esriFieldTypeString, alias: Area, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• MailAppIDDesc (type: esriFieldTypeString, alias: MailAppIDDesc, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• MailPermitIDDesc (type: esriFieldTypeString, alias: MailPermitIDDesc, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• HoursOfOperation (type: esriFieldTypeString, alias: HoursOfOperation, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• DaysOfOperation (type: esriFieldTypeString, alias: DaysOfOperation, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• MonthsOfOperation (type: esriFieldTypeString, alias: MonthsOfOperation, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• opening_date (type: esriFieldTypeString, alias: opening_date, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• renewal_sent_date (type: esriFieldTypeString, alias: renewal_sent_date, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• renewal_received_date (type: esriFieldTypeString, alias: renewal_received_date, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• permit_print_date (type: esriFieldTypeString, alias: permit_print_date, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• permit_expiration_date (type: esriFieldTypeString, alias: permit_expiration_date, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• next_inspection_date (type: esriFieldTypeString, alias: next_inspection_date, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• bond_expiration_date (type: esriFieldTypeString, alias: bond_expiration_date, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Quantity1 (type: esriFieldTypeInteger, alias: Quantity1, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Quantity1Unit (type: esriFieldTypeString, alias: Quantity1Unit, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Quantity2 (type: esriFieldTypeInteger, alias: Quantity2, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Quantity2Units (type: esriFieldTypeString, alias: Quantity2Units, SQL Type: sqlTypeNVarchar, length: 4000, 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)
• comments (type: esriFieldTypeString, alias: comments, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• TotalFeeAmt (type: esriFieldTypeDouble, alias: TotalFeeAmt, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• PermitFeeAmt (type: esriFieldTypeDouble, alias: PermitFeeAmt, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• InspectionFeeAmt (type: esriFieldTypeDouble, alias: InspectionFeeAmt, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• VarianceGranted (type: esriFieldTypeString, alias: VarianceGranted, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• FollowUpDate (type: esriFieldTypeString, alias: FollowUpDate, 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: 11/1/2025 12:39:10 PM

Schema Last Edit Date: 11/1/2025 12:39:10 PM

Data Last Edit Date: 11/1/2025 12:38:57 PM

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