About this Dataset

Louisville Metro KY - Right Of Way Permits (Historical)

Public Works and Assets maintains public streets & rights-of-way, administers capital construction projects, provides professional engineering and planning services.

Data Dictionary:

ID - Internal reference ID
APNO - the number assigned to the work to occur, unique identifier, permit number
Fullname
ISCONTRACTOR
APDTTM - date created into the permit system
APBY - who created the record
ISSDTTM - date modified
ISSBY - who modified the record
From Date - date that work will be started in the public Right of Way (ROW)
To Date - date that work will be completed in the public ROW
COOBY
COMMENTS_SEARCH
WORKTYPE - code for work type to be done
WORKTYPE_DESCRIPTION
PROCESS_STATE
LOCATION - text description of the locations
Street Address - address for which the work will occur
CITY
STATE
ZIP
GPSX,GPSY - state plane coordinates of the location
Latitude,Longitude - geographic coordinates for the work

Homepage URL
Organization: Louisville Metro Government
Last updated: 2025-07-30T13:18:23.905590
Tags: closure, construction, jefferson-county, kentucky, louisville, louisville-metro, louisville-metro-ky, permits, public-works-and-assets, right-of-way, road, row, static

Tables

Table 1

@usgov.louisville_metro_government_louisville_metro_ky_right__fe5b1d2b.table_1

81.54 kB
421 rows
25 columns

CREATE TABLE table_1 (
  "id" BIGINT,
  "apno" VARCHAR,
  "fullname" VARCHAR,
  "iscontractor" VARCHAR,
  "apdttm" TIMESTAMP,
  "apby" VARCHAR,
  "issdttm" VARCHAR,
  "issby" VARCHAR,
  "from_date" VARCHAR,
  "to_date" VARCHAR,
  "cooby" VARCHAR,
  "comments_search" VARCHAR,
  "worktype" VARCHAR,
  "worktype_description" VARCHAR,
  "process_state" VARCHAR,
  "location" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "gpsx" BIGINT,
  "gpsy" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "objectid" BIGINT
);