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

32.69 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
);