Traffic Signal

District of Columbia

@usgov.district_of_columbia_traffic_signal_a46dd

Table List

1 table(171.82 KB)

Table 1

@usgov.district_of_columbia_traffic_signal_a46dd.table_1

171.82 KB
1688 rows
11 columns

x X	y Y	intersectionid INTERSECTIONID	routeid ROUTEID	measure MEASURE	intersectionname INTERSECTIONNAME	grade GRADE	intersectionkey INTERSECTIONKEY	acisa ACISA	objectid OBJECTID
-8574689.54499029	4711604.23676887	11001102_11052322	11052322	1066.89697266	KENYON ST NW & 11TH ST NW	13	42c6bf548959a605cb811ea0f0e759c6	5028	4895430
-8573643.41906181	4710611.19661337	11000402_11046672_11060182	11060182	491.63000488	MCMILLAN DR NW & HOWARD PL NW & 4TH ST NW	13	0354bbc7d80bc42167c1382bb2b03e3a	3240	4895444
-8572256.40500138	4707718.39692461	12000102_12050892	12000102	1337.4510498	1ST ST NE & K ST NE		40736cafb4216780e39074395946fe5a	2161	4895449
-8575244.55811994	4712663.6944422	11001402_11081832	11081832	690.7880249	SPRING RD NW & 14TH ST NW	13	b65e64d79d058905a412a01497125dc7	5071	4895463
-8574898.93372156	4708585.28047894	11001302_11065842_36000032_36001452	36000032		Ramp-36000032 & Ramp-36001452 & O ST NW & 13TH ST NW	13	62f4b95771fa91f26711777f2a3bbfbb	2247	4895470
-8570584.55423008	4709131.27991647	12062462_36005422	12062462	118.13300323	MOUNT OLIVET RD NE & Ramp-36005422	13	158563882ccef9690324d10e86bc679d	3176	4895473
-8575167.45408975	4710604.13482273	11001402_11024112	11024112	431.38800049	CLIFTON ST NW & 14TH ST NW	13	a4b57f457231043a2a4fceb0a6596f56	5054	4895477
-8581193.70973378	4712738.16155253	11063762_11090702*1	11063762	1123.33398438	NEBRASKA AVE NW & WARD CIR NW	13	b99df8c28614c2005b59b74c7e133275	6157	4895497
-8580470.29422538	4714213.88009636	11009492_11094052	11009492	2347.75708008	ALBEMARLE ST NW & WISCONSIN AVE NW	13	fe95b644f0cbdfef91948d510c084a4d	6130	4895507
-8574493.48943372	4708165.92410995	11001002_11057852	11001002	1505.59802246	10TH ST NW & M ST NW		de37d14cb54cc657a2cc62fcf07f38c2	2094	4895508


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "intersectionid" VARCHAR,
  "routeid" VARCHAR,
  "measure" DOUBLE,
  "intersectionname" VARCHAR,
  "grade" DOUBLE,
  "intersectionkey" VARCHAR,
  "acisa" VARCHAR,
  "se_anno_cad_data" VARCHAR,
  "objectid" BIGINT
);