Parishes (December 2018) Boundaries EW BGC
Office for National Statistics
@ukgov.parishes_december_2018_boundaries_ew_bgc
Table 1
@ukgov.parishes_december_2018_boundaries_ew_bgc.table_1
- 1.23 MB
- 11337 rows
- 13 columns
objectidOBJECTID | parish_codeParish Code | parish_nameParish Name | welsh_nameWelsh Name | local_authority_codeLocal Authority Code | local_authority_nameLocal Authority Name | eastingEasting | northingNorthing | longitudeLongitude | latitudeLatitude | shape_areaShape, Area | shape_lengthShape, Length | globalidGlobalID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | E04000001 | Blackrod | E08000001 | Bolton | 361020 | 410662 | -2.59035993 | 53.59109116 | 8596085.60910034 | 16276.2133442454 | a6683e48-7ff8-4c83-b856-0c23a4aeb8c7 | |
| 2 | E04000002 | Horwich | E08000001 | Bolton | 365741 | 411963 | -2.51919007 | 53.60311127 | 14282785.5892334 | 21467.8548037933 | d8507346-c020-44a4-aed7-894ffdda427a | |
| 3 | E04000003 | Westhoughton | E08000001 | Bolton | 365008 | 406179 | -2.52960992 | 53.5510788 | 17858254.9492493 | 21823.548469686 | c2eaf7ad-880d-4b64-aabf-bc2c63f13fe3 | |
| 4 | E04000004 | Ringway | E08000003 | Manchester | 381192 | 384606 | -2.28404999 | 53.35800934 | 6547862.83926392 | 13995.7484948501 | 4e41e6a1-2aba-43de-b8ea-8fd8b5111fbf | |
| 5 | E04000005 | Saddleworth | E08000004 | Oldham | 400672 | 407034 | -1.99132001 | 53.55994034 | 76114791.1678467 | 43920.0143754105 | 32d94e26-c753-4396-ab7f-b5a71b9a1bbb | |
| 6 | E04000008 | Mossley | E08000008 | Tameside | 398535 | 402188 | -2.02356005 | 53.51638031 | 8670405.82563782 | 16933.4986439084 | 56c167c5-1639-4527-b01b-bae55594cb2a | |
| 7 | E04000009 | Carrington | E08000009 | Trafford | 374451 | 392138 | -2.38594007 | 53.42541885 | 8937336.08721924 | 18064.3800027256 | feedab9e-a9ea-4cec-b5c5-0e7fb6be032a | |
| 8 | E04000010 | Dunham Massey | E08000009 | Trafford | 373580 | 388755 | -2.39876008 | 53.39496994 | 9522172.83157349 | 17028.9030632635 | af1e9dea-f433-42c4-b438-fc9abfc423b2 | |
| 9 | E04000011 | Partington | E08000009 | Trafford | 371708 | 391423 | -2.42715001 | 53.41884995 | 3090721.19772339 | 8099.01766045615 | a4a744b6-8503-4f13-a277-e1b46279ce19 | |
| 10 | E04000012 | Warburton | E08000009 | Trafford | 370992 | 389438 | -2.43774009 | 53.40097046 | 7978102.43309021 | 14604.5859965442 | 5a1f52b9-764f-4710-b7ca-95ba0de64c60 |
CREATE TABLE table_1 (
"objectid" BIGINT,
"parish_code" VARCHAR,
"parish_name" VARCHAR,
"welsh_name" VARCHAR,
"local_authority_code" VARCHAR,
"local_authority_name" VARCHAR,
"easting" BIGINT,
"northing" BIGINT,
"longitude" DOUBLE,
"latitude" DOUBLE,
"shape_area" DOUBLE,
"shape_length" DOUBLE,
"globalid" VARCHAR
);