Jefferson County KY Street Centerlines 2005
Louisville Metro Government
@usgov.louisville_metro_government_jefferson_county_ky_street_e37a194d
Louisville Metro Government
@usgov.louisville_metro_government_jefferson_county_ky_street_e37a194d
CREATE TABLE table_1 (
"objectid" BIGINT,
"fnode" BIGINT,
"tnode" BIGINT,
"lpoly" BIGINT,
"rpoly" BIGINT,
"length" DOUBLE,
"streetcl" BIGINT,
"streetcl_id" BIGINT,
"sifcode" VARCHAR,
"low_address" BIGINT,
"hi_address" BIGINT,
"from_address" BIGINT,
"to_address" BIGINT,
"lfrom" BIGINT,
"lto" BIGINT,
"rfrom" BIGINT,
"rto" BIGINT,
"street_direction" VARCHAR,
"street_name" VARCHAR,
"street_type" VARCHAR,
"street_suffix" VARCHAR,
"road_name" VARCHAR,
"one_way" VARCHAR,
"avdir" VARCHAR,
"avpretype" VARCHAR,
"avstname" VARCHAR,
"avsttype" VARCHAR,
"avsufdir" VARCHAR,
"locrosspr" VARCHAR,
"locrossna" VARCHAR,
"locrosssu" VARCHAR,
"locrosssif" VARCHAR,
"hicrosspr" VARCHAR,
"hicrossna" VARCHAR,
"hicrosssu" VARCHAR,
"hicrosssif" VARCHAR,
"rwcompkey" BIGINT,
"ftimp" DOUBLE,
"tfimp" DOUBLE,
"speed" BIGINT,
"main_dist" VARCHAR,
"mapno" VARCHAR,
"owner_name" VARCHAR,
"owner_abrv" VARCHAR,
"main_resp" VARCHAR,
"main_abrv" VARCHAR,
"coundist" BIGINT,
"core_class" VARCHAR,
"class_abrv" VARCHAR,
"compkey" BIGINT,
"comptype" BIGINT,
"unitid" VARCHAR,
"unitid2" BIGINT,
"edit_date" TIMESTAMP,
"scfkey" VARCHAR,
"shape_length" DOUBLE
);
Anyone who has the link will be able to view this.