About this Dataset

Jefferson County KY Street Centerlines

Street Centerline 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:31.228422
Tags: addressing, centerlines, jefferson, kentucky, ky, lojic, louisville, modp, open-data, popular, roads, streets, transportation

Tables

Table 1

@usgov.louisville_metro_government_jefferson_county_ky_street_8d454846.table_1

5.28 MB
34992 rows
76 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "rwcompkey" BIGINT,
  "rwcompkeyparent" BIGINT,
  "low_address" BIGINT,
  "from_address" BIGINT,
  "to_address" BIGINT,
  "lfrom" BIGINT,
  "lto" BIGINT,
  "rfrom" BIGINT,
  "rto" BIGINT,
  "sifid" BIGINT,
  "sifcode" VARCHAR,
  "roadname" VARCHAR,
  "avdir" VARCHAR,
  "avpretype" VARCHAR,
  "avstname" VARCHAR,
  "avsttype" VARCHAR,
  "avsufdir" VARCHAR,
  "dir" VARCHAR,
  "strname" VARCHAR,
  "type" VARCHAR,
  "sifidlow" BIGINT,
  "locrosssif" VARCHAR,
  "locrosspr" VARCHAR,
  "locrossna" VARCHAR,
  "locrosssu" VARCHAR,
  "sifidhi" BIGINT,
  "hicrosssif" VARCHAR,
  "hicrosspr" VARCHAR,
  "hicrossna" VARCHAR,
  "hicrosssu" VARCHAR,
  "one_way" VARCHAR,
  "ftimp" DOUBLE,
  "tfimp" DOUBLE,
  "speed" BIGINT,
  "muni_name" VARCHAR,
  "coundist" BIGINT,
  "main_dist" VARCHAR,
  "mapno" VARCHAR,
  "owner_name" VARCHAR,
  "owner_abrv" VARCHAR,
  "main_resp" VARCHAR,
  "main_abrv" VARCHAR,
  "core_class" VARCHAR,
  "class_abrv" VARCHAR,
  "stcl_class" BIGINT,
  "zip_left" BIGINT,
  "zip_right" BIGINT,
  "compkey" BIGINT,
  "comptype" BIGINT,
  "unitid" VARCHAR,
  "unitid2" VARCHAR,
  "entered_by" VARCHAR,
  "entered_on" TIMESTAMP,
  "updated_by" VARCHAR,
  "updated_on" TIMESTAMP,
  "route_lbl" VARCHAR,
  "length" DOUBLE,
  "alias1_dir" VARCHAR,
  "alias1_strname" VARCHAR,
  "alias1_type" VARCHAR,
  "alias1_sifid" BIGINT,
  "alias2_dir" VARCHAR,
  "alias2_strname" VARCHAR,
  "alias2_type" VARCHAR,
  "alias2_sifid" BIGINT,
  "alias3_dir" VARCHAR,
  "alias3_strname" VARCHAR,
  "alias3_type" VARCHAR,
  "alias3_sifid" BIGINT,
  "alias4_dir" VARCHAR,
  "alias4_strname" VARCHAR,
  "alias4_type" VARCHAR,
  "alias4_sifid" BIGINT,
  "globalid" VARCHAR,
  "shapelen" DOUBLE
);