Bicycle Lanes
District of Columbia
@usgov.district_of_columbia_bicycle_lanes
District of Columbia
@usgov.district_of_columbia_bicycle_lanes
For a city, street blocks are a very common way in which to organize and relate asset types such as bicycle lanes. The bicycle lane layer is an extract of its parent layer Roadway Blocks. The bicycle lane layer provides locations for a variety of different types of lane types throughout Washington, DC. Bicycle lane dataset is derived from the Roadway Block centerlines.
Organization: District of Columbia
Last updated: 2024-04-30T17:32:29.432852
Tags: bicycle, bike, bike-lane, dc, ddot, district-of-columbia, transportation, washington-dc
CREATE TABLE table_1 (
"routeid" BIGINT,
"routename" VARCHAR,
"roadtype" BIGINT,
"subblockkey" VARCHAR,
"bikelane_parkinglane_adjacent" VARCHAR,
"bikelane_throughlane_adjacent" VARCHAR,
"bikelane_pocketlane_adjacent" VARCHAR,
"bikelane_contraflow" VARCHAR,
"bikelane_conventional" VARCHAR,
"bikelane_dual_protected" VARCHAR,
"bikelane_dual_buffered" VARCHAR,
"bikelane_protected" VARCHAR,
"bikelane_buffered" VARCHAR,
"subblockid" VARCHAR,
"blockid" VARCHAR,
"blockkey" VARCHAR,
"quadrant" DOUBLE,
"streetname" VARCHAR,
"streettype" VARCHAR,
"totalbikelanes" BIGINT,
"totalbikelanewidth" BIGINT,
"ward_id" BIGINT,
"smd_id" VARCHAR,
"anc_id" VARCHAR,
"objectid" BIGINT,
"shapelen" BIGINT
);Anyone who has the link will be able to view this.