Trail Mile Markers by US Government | Transportation and Logistics

About this Dataset

Trail Mile Markers

The Trail Mile Marker dataset includes mile marker locations on the sections of the Anacostia River Trail, Metropolitan Branch Trail, and Klingle Valley Trail. The markers are generally marked every tenth of a mile with a sign and/or pavement marking. Mile markers are used to report maintenance needs and assist in emergency response.
Organization: District of Columbia
Last updated: 2024-04-30T17:36:59.679940
Tags: 911, anacostia-river, anacostia-river-trail, bikes, emergency, trails, wayfinding

Tables

Table 1

@usgov.district_of_columbia_trail_mile_markers.table_1

31.93 KB
122 rows
23 columns


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "aliasname" VARCHAR,
  "name" VARCHAR,
  "mile_marker_num" DOUBLE,
  "routeid" VARCHAR,
  "fromdate" TIMESTAMP,
  "todate" VARCHAR,
  "measure" DOUBLE,
  "eventid" VARCHAR,
  "addralias_id" DOUBLE,
  "mar_id" BIGINT,
  "status" VARCHAR,
  "xcoord" DOUBLE,
  "ycoord" DOUBLE,
  "gis_id" VARCHAR,
  "se_anno_cad_data" VARCHAR,
  "globalid" VARCHAR,
  "created_user" VARCHAR,
  "created_date" TIMESTAMP,
  "last_edited_user" VARCHAR,
  "last_edited_date" TIMESTAMP,
  "objectid" BIGINT
);