Parishes (May 2023) Boundaries EW BGC

Office for National Statistics

@ukgov.parishes_may_2023_boundaries_ew_bgc

Table List

1 table(1.23 MB)

Table 1

@ukgov.parishes_may_2023_boundaries_ew_bgc.table_1

1.23 MB
11344 rows
11 columns

fid FID	par23cd PAR23CD	par23nm PAR23NM	bng_e BNG E	bng_n BNG N	long LONG	lat LAT	shape_area Shape, Area	shape_length Shape, Length	globalid GlobalID
1	E04000001	Blackrod	361040	410661	-2.59006	53.59108	8597757.28721619	16240.7048881675	0f17e7a6-1def-43c2-83de-eb21467aff03
2	E04000002	Horwich	365741	411963	-2.51919	53.60311	14281824.2785034	21462.586843	0d0f6d7b-2904-46a4-861b-d12acfae323f
3	E04000003	Westhoughton	365008	406179	-2.52961	53.55108	17858657.109848	21814.6094526373	9c665e74-68ce-4e33-8869-d4f5637fbec0
4	E04000004	Ringway	381192	384606	-2.28405	53.35801	6547375.67858887	14046.9053892352	3ece8f14-417c-4489-b5b5-b02e84fbdca5
5	E04000005	Saddleworth	400672	407034	-1.99132	53.55994	76107988.4932404	43889.6074816931	a521005f-96cd-4764-9708-be465e2d0931
6	E04000008	Mossley	398518	402180	-2.02381	53.51631	8672170.32516479	16972.7794579269	fba900c7-ec0e-421f-a0da-e8a970d2487b
7	E04000009	Carrington	374450	392134	-2.38596	53.42539	8945898.92018127	17491.5913036164	476cb846-15d9-4990-8aef-25af15facc7c
8	E04000010	Dunham Massey	373580	388755	-2.39876	53.39497	9520771.05625916	17011.243411955	7708c453-e2d1-4659-9573-cf720f506226
9	E04000011	Partington	371708	391423	-2.42715	53.41885	3090721.19772339	8099.01766045615	4ab6f412-fcce-470c-a7e0-439587aae49f
10	E04000012	Warburton	370992	389439	-2.43774	53.40098	7975650.29226685	14659.1914282678	99d23431-4108-423e-8d21-560554b2c38a


CREATE TABLE table_1 (
  "fid" BIGINT,
  "par23cd" VARCHAR,
  "par23nm" VARCHAR,
  "par23nmw" VARCHAR,
  "bng_e" BIGINT,
  "bng_n" BIGINT,
  "long" DOUBLE,
  "lat" DOUBLE,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE,
  "globalid" VARCHAR
);