Public Rights Of Way

Wigan Metropolitan Borough Council

@ukgov.public_rights_of_way51

Table List

1 table(36.37 KB)

Table 1

@ukgov.public_rights_of_way51.table_1

36.37 KB
1450 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/01/10	1	1	01	10	Abram	Footpath	ROW	1	WKL	2	202
001/02/10	1	1	02	10	Abram	Footpath	ROW	1	WKL	3	200
001/03/10	1	1	03	10	Abram	Footpath	ROW	1	WKL	4	201
001/04/10	1	1	04	10	Abram	Footpath	ROW	1	WKL	5	203
001/04/10	1	1	04	10	Abram	Footpath	ROW	1	WKL	6	203
001/05/10	1	1	05	10	Abram	Footpath	ROW	1	WKL	7	204
001/07/20	1	1	07	20	Abram	Footpath	ROW	1	WKL	10	205
001/08/10	1	1	08	10	Abram	Footpath	ROW	1	WKL	11	206
001/08/20	1	1	08	20	Abram	Footpath	ROW	1	WKL	12	207
001/08/30	1	1	08	30	Abram	Footpath	ROW	1	WKL	13	208


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