Metro Bus Stops by US Government | Transportation and Logistics

About this Dataset

Metro Bus Stops

WMATA Regional Bus Stops (permanent and temporary). The dataset includes bus stop identification, location, and inventory information (KFH bus stop inventory survey).
Organization: District of Columbia
Last updated: 2024-04-30T17:37:33.798213
Tags: bus-stop, metro, public-transit, public-transportation, transportation, wmata

Tables

Table 1

@usgov.district_of_columbia_metro_bus_stops.table_1

1.74 MB
10044 rows
79 columns


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "egis_id" BIGINT,
  "reg_id" BIGINT,
  "bstp_geo_id" BIGINT,
  "bstp_ops_tcd" VARCHAR,
  "bstp_eff_date" TIMESTAMP,
  "bstp_tcd" VARCHAR,
  "at_str" VARCHAR,
  "on_str" VARCHAR,
  "bstp_hdg" BIGINT,
  "bstp_pos_tcd" VARCHAR,
  "bstp_ldc" VARCHAR,
  "bstp_msg_text" VARCHAR,
  "bstp_lon" DOUBLE,
  "bstp_lat" DOUBLE,
  "bstp_lat_lon_tcd" VARCHAR,
  "bstp_inv_syr_tcd" VARCHAR,
  "bstp_inv_srv_date" TIMESTAMP,
  "bstp_bnh_cnt" BIGINT,
  "bstp_bst_tcd" VARCHAR,
  "bstp_ifc_own" VARCHAR,
  "bstp_has_bkrs" VARCHAR,
  "bstp_has_prs" VARCHAR,
  "bstp_has_pvm" VARCHAR,
  "bstp_has_prm" VARCHAR,
  "bstp_pdp_size_tcd" VARCHAR,
  "bstp_pdp_mtr_tcd" VARCHAR,
  "bstp_pdp_obs_tcd" VARCHAR,
  "bstp_pdp_has_ccn" VARCHAR,
  "bstp_has_bdr_pdp" VARCHAR,
  "bstp_bdr_pdp_obs" VARCHAR,
  "bstp_swk_wdt" BIGINT,
  "bstp_swk_has_ccn" VARCHAR,
  "bstp_swk_has_ppc" VARCHAR,
  "bstp_swk_slp_wvl" VARCHAR,
  "bstp_swk_obs_tcd" VARCHAR,
  "bstp_swk_ipd_tcd" VARCHAR,
  "ons_crp_slp" DOUBLE,
  "ons_crp" VARCHAR,
  "ofs_crp" VARCHAR,
  "at_str_abs_crp" VARCHAR,
  "at_str_oss_crp" VARCHAR,
  "ons_cwk" VARCHAR,
  "ofs_cwk" VARCHAR,
  "at_str_abs_cwk" VARCHAR,
  "at_str_oss_cwk" VARCHAR,
  "on_str_sts_or_tfl" VARCHAR,
  "on_str_pdc_sgl" VARCHAR,
  "at_str_pdc_sgl" VARCHAR,
  "bstp_prk_rst_tcd" VARCHAR,
  "bstp_npk_zne_lth" BIGINT,
  "cnf_npk_sns" VARCHAR,
  "str_lgt_wtn_30_ft" VARCHAR,
  "bstp_has_led_dsp" VARCHAR,
  "bstp_acc_rating" VARCHAR,
  "bstp_brdg_stp" VARCHAR,
  "bstp_has_lum_sign" VARCHAR,
  "bstp_has_pwr_src" VARCHAR,
  "metro_accs_stp" VARCHAR,
  "ward_id" BIGINT,
  "anc_id" VARCHAR,
  "smd_id" VARCHAR,
  "routeid" VARCHAR,
  "measure" DOUBLE,
  "offset" DOUBLE,
  "blockkey" VARCHAR,
  "blockfacekey" VARCHAR,
  "gis_id" VARCHAR,
  "se_anno_cad_data" VARCHAR,
  "globalid" VARCHAR,
  "creator" VARCHAR,
  "created" TIMESTAMP,
  "editor" VARCHAR,
  "edited" TIMESTAMP,
  "objectid" BIGINT,
  "snowpriority" VARCHAR,
  "bstp_ops_ftu_tcd" VARCHAR,
  "mstn_id" VARCHAR
);