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

166.14 kB
1,024 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
);