Street Range
City of Baton Rouge
@usgov.city_of_baton_rouge_street_range_2ca24
City of Baton Rouge
@usgov.city_of_baton_rouge_street_range_2ca24
CREATE TABLE table_1 (
"street_segment_id" BIGINT,
"street_name_id" BIGINT,
"street_name" VARCHAR,
"from_address_left" DOUBLE,
"to_address_left" DOUBLE,
"parity_left" VARCHAR,
"from_address_right" DOUBLE,
"to_address_right" DOUBLE,
"parity_right" VARCHAR,
"street_type" VARCHAR,
"access_restriction" VARCHAR,
"one_way" VARCHAR,
"one_way_direction" VARCHAR,
"from_elevation_level" BIGINT,
"to_elevation_level" BIGINT,
"road_class" VARCHAR,
"road_type" VARCHAR,
"subdivision" VARCHAR,
"jurisdiction" VARCHAR,
"postal_community_left" VARCHAR,
"postal_community_right" VARCHAR,
"zip_code_left" BIGINT,
"zip_code_right" BIGINT,
"community_left" VARCHAR,
"community_right" VARCHAR,
"street_owner" VARCHAR,
"drainage_maintenance_responsibility" VARCHAR,
"curb_and_gutter" VARCHAR,
"shoulder" VARCHAR,
"speed_limit_mph" BIGINT,
"truck_route" VARCHAR,
"federal_route" VARCHAR,
"federal_route_type" VARCHAR,
"alt_federal_route" VARCHAR,
"alt_federal_route_type" VARCHAR,
"state_route" VARCHAR,
"state_route_type" VARCHAR,
"alt_state_route" DOUBLE,
"alt_state_route_type" VARCHAR,
"emergency_funding" VARCHAR,
"priority_to_keep_open" VARCHAR,
"street_incept_date" VARCHAR,
"data_source" VARCHAR,
"lrs_id" BIGINT,
"notation" VARCHAR,
"private_street" VARCHAR,
"street_segment_no" BIGINT,
"street_direction" VARCHAR,
"street_elevation_level" BIGINT,
"lrs_begin_measurement_ft" BIGINT,
"lrs_end_measurement_ft" BIGINT,
"census_fcc" VARCHAR,
"parish_left" VARCHAR,
"parish_right" VARCHAR,
"created_date" VARCHAR,
"last_edited_date" VARCHAR,
"geometry" VARCHAR,
"number_of_lanes" DOUBLE
);
Anyone who has the link will be able to view this.