Louisville Metro KY - Pool Inspections

Descriptions of violations recorded during inspections by Louisville Metro Department of Public Health and Wellness. The Inspection_id column corresponds to the InspectionID column in the Inspections table. There are 0 to many inspection violations associated with each inspection in the Inspections table. Data Dictionary: inspection_id-system id of inspection InspTypeSpecificViolID-violatio number for type of inspection ViolationDesc-description of the violation weight-points taken off for violation critical_yn-is this a critical violation? If so means inspection failure comments rpt_area_id-facility type code delete_mark_id-system indicator id-violation system id Contact: Gerald Kaforski gerald.kaforski@louisvilleky.gov

A list of the violations recorded against permitted restaurants that failed inspection. Data Dictionary: EstablishmentID - Permit Number InspectionDate - date of inspection InspectionID - system inspection id EstTypeDesc - desciption of facility type premise_name - facility name premise_adr1_num - facility street number premise_adr1_street - facility street premise_city - facility city premise_state - facility state premise_zip - facility zip code InspectionType - description of inspection type score - inspection score InspTypeSpecificViolID - Violation ID for specific type of facility ViolationDesc - text description of violation critical_yn - Is the violation critical? Insp_Viol_Comments - violation comments rpt_area_id - Establishment Type Code Health and Wellness Protects and promotes the health, environment and well being of the people of Louisville, providing health-related programs and health office locations community wide. Contact: Gerald Kaforski gerald.kaforski@louisvilleky.gov

The data provided in this dataset is preliminary in nature and may have not been investigated by a detective at the time of download. The data is therefore subject to change after a complete investigation. This data represents only calls for police service where a police incident report was taken. Due to the variations in local laws and ordinances involving crimes across the nation, whether another agency utilizes Uniform Crime Report (UCR) or National Incident Based Reporting System (NIBRS) guidelines, and the results learned after an official investigation, comparisons should not be made between the statistics generated with this dataset to any other official police reports. Totals in the database may vary considerably from official totals following the investigation and final categorization of a crime. Therefore, the data should not be used for comparisons with Uniform Crime Report or other summary statistics.   Data is broken out by year into separate CSV files. Note the file grouping by year is based on the crime's Date Reported (not the Date Occurred). Older cases found in the 2003 data are indicative of cold case research. Older cases are entered into the Police database system and tracked but dates and times of the original case are maintained. Data may also be viewed off-site in map form for just the last 6 months on communitycrimemap.com Data Dictionary: Field Name Field Description Incident Number the number associated with either the incident or used as reference to store the items in our evidence rooms Date Reported the date the incident was reported to LMPD Date Occurred the date the incident actually occurred Badge ID Badge ID of responding Officer Offense Classification NIBRS Reporting category for the criminal act committed Offense Code Name NIBRS Reporting code for the criminal act committed NIBRS_CODE the code that follows the guidelines of the National Incident Based Reporting System. For more details visit https://ucr.fbi.gov/nibrs/2011/resources/nibrs-offense-codes/view NIBRS Group hierarchy that follows the guidelines of the FBI National Incident Based Reporting System Was Offense Completed Status indicating whether the incident was an attempted crime or a completed crime. LMPD Division the LMPD division in which the incident actually occurred LMPD Beat the LMPD beat in which the incident actually occurred Location Category the type of location in which the incident occurred (e.g. Restaurant) Block Address the location the incident occurred City the city associated to the incident block location Zip Code the zip code associated to the incident block location Contact: LMPD Open Records    lmpdopenrecords@louisvilleky.gov

Section 305(b) of the Clean Water Act requires states to assess the condition of the Waters of the US. The Kentucky Division of Water, in cooperation with other agencies, collects biological and water quality data to assess the condition of the resource and reports this to Congress every two years in the Integrated Report to Congress. (https://www.water.ky.gov/sw/swmonitor/305b/) These data represent the assessment results for surface waters of the Commonwealth of Kentucky. Box Download: https://ky.box.com/v/energy-environment/file/850630980093

The location of water tanks for public water systems in the Commonwealth of Kentucky. A water tank is a feature that is used for water storage in a distribution system or at a water treatment plant.

The purpose of this feature class is to illustrate the location of wastewater treatment plants in public wastewater systems in the Commonwealth of Kentucky as collected by Kentucky’s Area Development Districts and provided by the Kentucky Division of Water. The locations of wastewater treatment plants, along with the basic attribute data concerning those features, are used by the Kentucky Infrastructure Authority, Area Development Districts, public wastewater systems, and other state/local agencies for the purpose of wastewater infrastructure planning and management, project development, asset inventories, capital improvement plans, data analysis, and for any other purpose that will improve the wastewater infrastructure and service in the Commonwealth of Kentucky.