Name: Louisville Metro KY - Property Maintenance Inspection Violations
Creator: US Government
License: https://louisville-metro-opendata-lojic.hub.arcgis.com/pages/terms-of-use-and-license

About this Dataset

Louisville Metro KY - Property Maintenance Inspection Violations

Codes and Regulations inspects and enforces Property Maintenance Code (housing) , Land Development Code (zoning), and administers the Code Enforcement Board. The following data provides a list of property maintenance violations over the last 30 days.

Data Dictionary

Field Name	Field Description
SERV_PROV_CODE	Field that is used for linking the data with Accela and identifies the agency
B1_PER_ID1	Identifies the specific record for joining the data in Accela
B1_PER_ID2
B1_PER_ID3
B1_SPECIAL_TEXT	Identifies the inspection visit number
B1_ALT_ID	Record ID
FullAdress	Location of the site visit including city, state and zip
PartialAddress	Location of the site visit excluding the city, state and zip
Longitude	Point location of the site visit
Latitude
EXT_ADDRESS_UID	Identifier for joining the address to LOJIC address data
PARCEL_ID	Parcel Identifier
CouncilDist	Council District
G6A_G6_COMPL_T1	Identifies whether the inspection was completed AM or PM
G6A_G6_COMPL_T2	Identifies the time of the inspection on a 12 hour clock
G6A_G6_COMPL_DD	Is the date/time of the inspection
G6A_G6_STATUS	Inspection result of the site visit
G6A_G6_STATUS_DD	The Date when the inspection result was issued
GA_USERID	Unique identifier of the inspector
GAFML	Full Name of the inspector
OccupancyStatus	Occupancy Status of the property observed by the inspector at the time of the inspection
GUIDE_ITEM_TEXT	Description of the violation
VIOLATION_CODE	Violation Code
GUIDE_ITEM_STATUS	Individual violation status
CitationAmount	The fine levied against the property owner for violations on that inspection
ColumnCounts	Sequential Number of violations on a site visit
Organization: Louisville Metro Government
Last updated: 2025-07-30T14:10:20.739844
Tags: codes-and-regs, codes-and-regulations, inspection-violations, inspections, jefferson-county, kentucky, louisville, louisville-metro, louisville-metro-ky, maintenance, property-maintenance, recent_odp, updated-daily, violations

Tables

Table 1

@usgov.louisville_metro_government_louisville_metro_ky_proper_b0cc0a16.table_1

1.07 MB
16283 rows
29 columns


CREATE TABLE table_1 (
  "serv_prov_code" VARCHAR,
  "b1_per_id1" VARCHAR,
  "b1_per_id2" BIGINT,
  "b1_per_id3" VARCHAR,
  "b1_special_text" VARCHAR,
  "b1_alt_id" VARCHAR,
  "fulladdress" VARCHAR,
  "partialaddress" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "ext_address_uid" VARCHAR,
  "parcel_id" VARCHAR,
  "councildist" DOUBLE,
  "g6a_g6_compl_t1" VARCHAR,
  "g6a_g6_compl_t2" VARCHAR,
  "g6a_g6_compl_dd" VARCHAR,
  "g6a_g6_status" VARCHAR,
  "g6a_g6_status_dd" VARCHAR,
  "ga_userid" VARCHAR,
  "ga_fml" VARCHAR,
  "occupancystatus" VARCHAR,
  "guide_item_text" VARCHAR,
  "violation_code" VARCHAR,
  "guide_item_status" VARCHAR,
  "citationamount" BIGINT,
  "columncounts" BIGINT,
  "objectid" BIGINT,
  "x" DOUBLE,
  "y" DOUBLE
);