Baselight

Cambridgeshire Postcodes

Cambridgeshire Insight

@ukgov.cambridgeshire_postcodes1

MK' Postcode District
@ukgov.cambridgeshire_postcodes1.mk_postcode_district

  • 10.89 KB
  • 3 rows
  • 15 columns
postcode

Postcode

positional_quality_indicator

Positional Quality Indicator

eastings

Eastings

northings

Northings

latitude

Latitude

longitude

Longitude

country_code

Country Code

nhs_regional_ha_code

NHS Regional HA Code

nhs_ha_code

NHS HA Code

admin_county_code

Admin County Code

admin_district_code

Admin District Code

admin_ward_code

Admin Ward Code

county

County

census_code

Census Code

hectares

Hectares

MK442AL1050910326612052.282403-0.40208103E92000001E19000001E18000006E10000003E07000011E05008578CambridgeshireE10000003305400.769
MK442BN1051211226168952.241979-0.35946175E92000001E19000001E18000006E10000003E07000011E05008578CambridgeshireE10000003305400.769
MK442LD1051149226088552.234879-0.36880301E92000001E19000001E18000006E10000003E07000011E05008578CambridgeshireE10000003305400.769

CREATE TABLE mk_postcode_district (
  "postcode" VARCHAR,
  "positional_quality_indicator" BIGINT,
  "eastings" BIGINT,
  "northings" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "country_code" VARCHAR,
  "nhs_regional_ha_code" VARCHAR,
  "nhs_ha_code" VARCHAR,
  "admin_county_code" VARCHAR,
  "admin_district_code" VARCHAR,
  "admin_ward_code" VARCHAR,
  "county" VARCHAR,
  "census_code" VARCHAR,
  "hectares" DOUBLE
);

Share link

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