Wigan Council Asset Boundaries

Wigan Metropolitan Borough Council

@ukgov.wigan_council_asset_boundaries26

Table List

1 table(110.55 KB)

Table 1

@ukgov.wigan_council_asset_boundaries26.table_1

110.55 KB
1839 rows
16 columns

gisdatacorporateasset_boundariesobjectid GISDataCORPORATEAsset BoundariesOBJECTID	gisdatacorporateasset_boundariesurn GISDataCORPORATEAsset BoundariesURN	gisdatacorporateasset_boundariessite_area GISDataCORPORATEAsset BoundariesSITE AREA	gisdatacorporatelapd_view_locationlocation GISDataCORPORATELAPD View LocationLocation	gisdatacorporatelapd_view_locationlocnum GISDataCORPORATELAPD View LocationLocNum	gisdatacorporatelapd_view_locationaddress1 GISDataCORPORATELAPD View LocationAddress1	gisdatacorporatelapd_view_locationaddress2 GISDataCORPORATELAPD View LocationAddress2	gisdatacorporatelapd_view_locationtownname GISDataCORPORATELAPD View LocationTownName	gisdatacorporatelapd_view_locationcountyname GISDataCORPORATELAPD View LocationCountyName	gisdatacorporatelapd_view_locationpostcode GISDataCORPORATELAPD View LocationPostCode	gisdatacorporatelapd_view_locationcommitteename GISDataCORPORATELAPD View LocationCommitteeName	gisdatacorporatelapd_view_locationarea GISDataCORPORATELAPD View LocationArea	gisdatacorporatelapd_view_locationredaction GISDataCORPORATELAPD View LocationRedaction	gisdatacorporatelapd_view_locationvacantbuildings GISDataCORPORATELAPD View LocationVacantBuildings
1	8320	354.12982999	PEMBERTON CHAPEL STREET REST GARDEN		CHAPEL STREET	PEMBERTON	WIGAN	Greater Manchester		POLICY-WLCT	354.13	N	N
2	7110	565.5085824	ASHTON CANSFIELD ESTATE TEMPORARY ALLOTMENT SITE	R/O 34-58	OSBORNE ROAD		ASHTON-IN-MAKERFIELD	Greater Manchester		HOUSING REVENUE	565.51	N	N
3	1036	2835.61967	ATHERTON BUXTON CLOSE FLATS		1-4, 1A-4A, 5-8, 5A-8A BUXTON CLOSE (AND	23-23A, 25-25A CAR BANK STREET, M46 9SA)	ATHERTON	Greater Manchester	M46 9NA	HOUSING REVENUE	2835.62	Y	N
4	4248	793.15794806	INCE INDUSTRIAL LAND HOLDING		BALDWIN STREET / RICHARD STREET	INCE	WIGAN	Greater Manchester		PLANNING	793.16	N	N
5	893	39.76396075	ELECTRICITY SUB STATION SITES (LEISURE)		W.M.B.C.		WIGAN	Greater Manchester		POLICY-LeisureClient	39.76	N	N
6	8186	149166.41601747	WIGAN RED ROCK LINEAR WALKWAY		RED ROCK	HAIGH	WIGAN	Greater Manchester		PLANNING	149166.42	N	N
7	8274	1737.51027101	LEIGH SANDERLING DRIVE DEDICATED ESTATE INFILL		SANDERLING DRIVE		LEIGH	Greater Manchester		PLANNING	1824.89	N	N
8	436	7195.6029477	ST OSWALDS CATHOLIC PRIMARY ASHTON		COUNCIL AVENUE	OFF BRYN STREET	ASHTON-IN-MAKERFIELD	Greater Manchester	WN4 9AZ	Children & Young Peoples Services	7195.6	N	N
9	1068	162.42375	H.R.A. GARAGE COLONIES		W.M.B.C.		WIGAN	Greater Manchester		HOUSING REVENUE	70.76	N	N
10	8499	855.22912352	HINDLEY KING STREET CAR PARK		KING STREET		HINDLEY	Greater Manchester		ADULT SERVICES	949.91	N	N


CREATE TABLE table_1 (
  "gisdatacorporateasset_boundariesobjectid" BIGINT,
  "gisdatacorporateasset_boundariesurn" BIGINT,
  "gisdatacorporateasset_boundariessite_area" DOUBLE,
  "gisdatacorporatelapd_view_locationlocation" VARCHAR,
  "gisdatacorporatelapd_view_locationlocnum" VARCHAR,
  "gisdatacorporatelapd_view_locationaddress1" VARCHAR,
  "gisdatacorporatelapd_view_locationaddress2" VARCHAR,
  "gisdatacorporatelapd_view_locationaddress3" VARCHAR,
  "gisdatacorporatelapd_view_locationaddress4" VARCHAR,
  "gisdatacorporatelapd_view_locationtownname" VARCHAR,
  "gisdatacorporatelapd_view_locationcountyname" VARCHAR,
  "gisdatacorporatelapd_view_locationpostcode" VARCHAR,
  "gisdatacorporatelapd_view_locationcommitteename" VARCHAR,
  "gisdatacorporatelapd_view_locationarea" DOUBLE,
  "gisdatacorporatelapd_view_locationredaction" VARCHAR,
  "gisdatacorporatelapd_view_locationvacantbuildings" VARCHAR
);