Bridleways

Wigan Metropolitan Borough Council

@ukgov.bridleways20

Table List

1 table(13.13 KB)

Table 1

@ukgov.bridleways20.table_1

13.13 KB
201 rows
13 columns

routecode RouteCode	status Status	legaltype LegalType	pathno PathNo	linkno LinkNo	district District	statusdescr StatusDescr	legaltypedescr LegalTypeDescr	districtcode DistrictCode	dataset Dataset	mi_prinx MI PRINX	esri_oid ESRI OID
001/05/20	2	1	05	20	Abram	Bridleway	ROW	1	WKL	8	641
001/07/10	2	1	07	10	Abram	Bridleway	ROW	1	WKL	9	642
001/30/10	2	1	30	10	Abram	Bridleway	ROW	1	WKL	47	643
001/35/10	2	1	35	10	Abram	Bridleway	ROW	1	WKL	52	644
001/42/10	2	1	42	10	Abram	Bridleway	ROW	1	WKL	59	645
001/43/10	2	1	43	10	Abram	Bridleway	ROW	1	WKL	60	646
003/02/10	2	1	02	10	Aspull	Bridleway	ROW	3	WKL	122	647
003/09/10	2	1	09	10	Aspull	Bridleway	ROW	3	WKL	131	648
003/13/10	2	1	13	10	Aspull	Bridleway	ROW	3	WKL	137	649
003/13/20	2	1	13	20	Aspull	Bridleway	ROW	3	WKL	138	650


CREATE TABLE table_1 (
  "routecode" VARCHAR,
  "status" BIGINT,
  "legaltype" BIGINT,
  "pathno" VARCHAR,
  "linkno" BIGINT,
  "district" VARCHAR,
  "statusdescr" VARCHAR,
  "legaltypedescr" VARCHAR,
  "districtcode" BIGINT,
  "dataset" VARCHAR,
  "mi_style" VARCHAR,
  "mi_prinx" BIGINT,
  "esri_oid" BIGINT
);