Jefferson County KY Street Centerlines 2015

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,
  "shape_length" DOUBLE
);