2018 Traffic Count Sites

City of Bradford Metropolitan District Council

@ukgov.n_2018_traffic_count_sites7

Table 1

@ukgov.n_2018_traffic_count_sites7.table_1

x X	y Y	fid FID	site_id Site ID	coverage Coverage	data_link Data Link
-212594.057025728	7162026.42559759	1	10201	2.5	https://maps.bradford.gov.uk/LocalViewext/traffic/000000010201_2018.html
-209492.160806908	7162494.6092068	2	10202	2.5	https://maps.bradford.gov.uk/LocalViewext/traffic/000000010202_2018.html
-217615.554578974	7153912.46869131	3	10302	2.5	https://maps.bradford.gov.uk/LocalViewext/traffic/000000010302_2018.html
-218631.743285428	7151817.14303126	4	10306	2.5	https://maps.bradford.gov.uk/LocalViewext/traffic/000000010306_2018.html
-216230.398894276	7150414.66299928	5	10601	2.5	https://maps.bradford.gov.uk/LocalViewext/traffic/000000010601_2018.html
-213811.722144903	7148605.95951102	6	10602	2.5	https://maps.bradford.gov.uk/LocalViewext/traffic/000000010602_2018.html
-210210.719392991	7146725.57368018	7	10709	2.5	https://maps.bradford.gov.uk/LocalViewext/traffic/000000010709_2018.html
-210807.8265539	7145983.17107829	8	10710	2.5	https://maps.bradford.gov.uk/LocalViewext/traffic/000000010710_2018.html
-211630.033521157	7146417.09924437	9	10715	2.5	https://maps.bradford.gov.uk/LocalViewext/traffic/000000010715_2018.html
-199387.085892444	7156844.65975958	10	20101	3	https://maps.bradford.gov.uk/LocalViewext/traffic/000000020101_2018.html


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "fid" BIGINT,
  "site_id" BIGINT,
  "coverage" DOUBLE,
  "data_link" VARCHAR
);