Signed Bike Routes by US Government | Transportation and Logistics

About this Dataset

Signed Bike Routes

The dataset contains locations and attributes of Signed Bike Routes, created as part of the District of Columbia, Department of Transportation (DDOT) Street Spatial Database (SSD). A database provided by the District of Columbia, Department of Transportation identified StreetSegment locations.
Organization: District of Columbia
Last updated: 2024-04-30T17:59:43.304222
Tags: bicycle, bike, dc-signed-bike-routes, district-of-columbia, transportation, washington-dc

Tables

Table 1

@usgov.district_of_columbia_signed_bike_routes_0144b.table_1

162.25 KB
1024 rows
37 columns


CREATE TABLE table_1 (
  "street" VARCHAR,
  "ward" BIGINT,
  "notes" VARCHAR,
  "length_mi" DOUBLE,
  "streetsegid" BIGINT,
  "facilityid" VARCHAR,
  "sourceid" BIGINT,
  "streetid" BIGINT,
  "registered" VARCHAR,
  "streettype" VARCHAR,
  "quadrant" VARCHAR,
  "directiona" BIGINT,
  "segmenttype" BIGINT,
  "fromnodeid" BIGINT,
  "tonodeid" BIGINT,
  "fromaddres" BIGINT,
  "toaddressl" BIGINT,
  "fromaddr_1" BIGINT,
  "toaddressr" BIGINT,
  "beginmeasu" BIGINT,
  "endmeasure" DOUBLE,
  "updatetime" TIMESTAMP,
  "sisid" BIGINT,
  "quadrant_1" VARCHAR,
  "frominters" VARCHAR,
  "tointersec" VARCHAR,
  "year_signed" BIGINT,
  "oid" BIGINT,
  "objectid" BIGINT,
  "se_anno_cad_data" VARCHAR,
  "gis_id" VARCHAR,
  "globalid" VARCHAR,
  "creator" VARCHAR,
  "created" VARCHAR,
  "editor" VARCHAR,
  "edited" VARCHAR,
  "shapelen" BIGINT
);