Jefferson County KY Address Points by US Government | Demographics and Population Studies

About this Dataset

Jefferson County KY Address Points

Address point data is maintained by the Louisville MetroSafe, the addressing authority in Jefferson County. The data is updated daily. View detailed metadata.
Organization: Louisville Metro Government
Last updated: 2023-04-13T13:26:26.728912
Tags: address, address-points, addresses, addressing, geocode, house-numbers, jefferson, kentucky, ky, lojic, louisville, modp, open-data, popular

Tables

Table 1

@usgov.louisville_metro_government_jefferson_county_ky_addres_2482fa57.table_1

60.14 MB
446979 rows
87 columns


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "address" VARCHAR,
  "sifcode" VARCHAR,
  "houseno" BIGINT,
  "hafhouse" VARCHAR,
  "apt" VARCHAR,
  "dir" VARCHAR,
  "strname" VARCHAR,
  "type" VARCHAR,
  "parcelid" VARCHAR,
  "lrsn" BIGINT,
  "sitecad" BIGINT,
  "zipcode" BIGINT,
  "avdir" VARCHAR,
  "avpretype" VARCHAR,
  "avstname" VARCHAR,
  "avsttype" VARCHAR,
  "avsufdir" VARCHAR,
  "active" BIGINT,
  "entered_on" TIMESTAMP,
  "entered_by" VARCHAR,
  "updated_on" TIMESTAMP,
  "updated_by" VARCHAR,
  "sifid" BIGINT,
  "nh_code" BIGINT,
  "muncode" DOUBLE,
  "ezone" VARCHAR,
  "ward" BIGINT,
  "congdist" BIGINT,
  "sendist" BIGINT,
  "legisdist" BIGINT,
  "precinct" VARCHAR,
  "commdist" VARCHAR,
  "coundist" BIGINT,
  "histdist" BIGINT,
  "presdist" BIGINT,
  "overlay" BIGINT,
  "urbrenew" BIGINT,
  "sra_day" VARCHAR,
  "sra_route" VARCHAR,
  "sra_week" VARCHAR,
  "sra_recycle" VARCHAR,
  "metro_page" VARCHAR,
  "m200_name" VARCHAR,
  "atname_ab" VARCHAR,
  "omregio_ab" VARCHAR,
  "nghdcode" BIGINT,
  "pddistrict" VARCHAR,
  "pdbeat" VARCHAR,
  "pdpra" VARCHAR,
  "esn" VARCHAR,
  "zoning_code" VARCHAR,
  "census_1990" VARCHAR,
  "tract_1990" VARCHAR,
  "x_coord" BIGINT,
  "y_coord" BIGINT,
  "inspdist" VARCHAR,
  "muni_name" VARCHAR,
  "nh_name" VARCHAR,
  "om_dist" VARCHAR,
  "service_dist" VARCHAR,
  "district_abbr" VARCHAR,
  "cen_tract" VARCHAR,
  "zone_name" VARCHAR,
  "pdsector" VARCHAR,
  "pdzone" VARCHAR,
  "csonum" VARCHAR,
  "cssarea" VARCHAR,
  "sdcdist" VARCHAR,
  "firedist" VARCHAR,
  "full_address" VARCHAR,
  "cad_primary" VARCHAR,
  "rwcompkey" DOUBLE,
  "blockgroup" VARCHAR,
  "funding" VARCHAR,
  "drsa" BIGINT,
  "county" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "state" VARCHAR,
  "urbrenew_name" VARCHAR,
  "histdist_name" VARCHAR,
  "overlays_name" VARCHAR,
  "presdist_name" VARCHAR,
  "hna_name" VARCHAR
);