Infrastructure

Wigan Metropolitan Borough Council

@ukgov.infrastructure18

Table List

1 table(55.32 KB)

Table 1

@ukgov.infrastructure18.table_1

55.32 KB
1745 rows
7 columns

x X	y Y	infracode InfraCode	infratype InfraType	typedescr TypeDescr	mi_prinx MI PRINX	esri_oid ESRI OID
361191.998	402350.997500001	001/10	3.10c	Sign/waym (road)/Metal	3	1
361191.998	402350.997500001	001/10	3.10c	Sign/waym (road)/Metal	4	1
362357.9981	401011.0011	001/11	3.20f	Stile/Other	5	2
362357.9981	401011.0011	001/11	3.20f	Stile/Other	6	2
362012.0023	400171.001499999	001/12	3.30d	Gate/Field	7	3
362012.0023	400171.001499999	001/12	3.30d	Gate/Field	8	3
362093.9994	400247.999500001	001/13	3.30d	Gate/Field	9	4
362093.9994	400247.999500001	001/13	3.30d	Gate/Field	10	4
362212.0027	400362.9965	001/14	3.30c	Gate/Other	11	5
362212.0027	400362.9965	001/14	3.30c	Gate/Other	12	5


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "infracode" VARCHAR,
  "infratype" VARCHAR,
  "typedescr" VARCHAR,
  "mi_prinx" BIGINT,
  "esri_oid" BIGINT
);