Baselight

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
objectid

OBJECTID

parish_code

Parish Code

parish_name

Parish Name

welsh_name

Welsh Name

local_authority_code

Local Authority Code

local_authority_name

Local Authority Name

easting

Easting

northing

Northing

longitude

Longitude

latitude

Latitude

shape_area

Shape, Area

shape_length

Shape, Length

globalid

GlobalID

1E04000001Blackrod E08000001Bolton361020410662-2.5903599353.591091168596085.6091003416276.2133442454a6683e48-7ff8-4c83-b856-0c23a4aeb8c7
2E04000002Horwich E08000001Bolton365741411963-2.5191900753.6031112714282785.589233421467.8548037933d8507346-c020-44a4-aed7-894ffdda427a
3E04000003Westhoughton E08000001Bolton365008406179-2.5296099253.551078817858254.949249321823.548469686c2eaf7ad-880d-4b64-aabf-bc2c63f13fe3
4E04000004Ringway E08000003Manchester381192384606-2.2840499953.358009346547862.8392639213995.74849485014e41e6a1-2aba-43de-b8ea-8fd8b5111fbf
5E04000005Saddleworth E08000004Oldham400672407034-1.9913200153.5599403476114791.167846743920.014375410532d94e26-c753-4396-ab7f-b5a71b9a1bbb
6E04000008Mossley E08000008Tameside398535402188-2.0235600553.516380318670405.8256378216933.498643908456c167c5-1639-4527-b01b-bae55594cb2a
7E04000009Carrington E08000009Trafford374451392138-2.3859400753.425418858937336.0872192418064.3800027256feedab9e-a9ea-4cec-b5c5-0e7fb6be032a
8E04000010Dunham Massey E08000009Trafford373580388755-2.3987600853.394969949522172.8315734917028.9030632635af1e9dea-f433-42c4-b438-fc9abfc423b2
9E04000011Partington E08000009Trafford371708391423-2.4271500153.418849953090721.197723398099.01766045615a4a744b6-8503-4f13-a277-e1b46279ce19
10E04000012Warburton E08000009Trafford370992389438-2.4377400953.400970467978102.4330902114604.58599654425a1f52b9-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
);

Share link

Anyone who has the link will be able to view this.