Baselight

Cambridgeshire Postcodes

Cambridgeshire Insight

@ukgov.cambridgeshire_postcodes1

SG' Postcode District
@ukgov.cambridgeshire_postcodes1.sg_postcode_district

  • 37.96 KB
  • 794 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

SG192BP1051921825444552.175391-0.25798825E92000001E19000001E18000006E10000003E07000011E05008528CambridgeshireE10000003305400.769
SG192HU1052185325311552.162865-0.21995135E92000001E19000001E18000006E10000003E07000011E05008528CambridgeshireE10000003305400.769
SG192HX1052253925288952.160682-0.21000895E92000001E19000001E18000006E10000003E07000012E05002802CambridgeshireE10000003305400.769
SG192HY1052236525288252.160658-0.21255385E92000001E19000001E18000006E10000003E07000011E05008528CambridgeshireE10000003305400.769
SG192HZ1052260025332152.164551-0.20896181E92000001E19000001E18000006E10000003E07000011E05008528CambridgeshireE10000003305400.769
SG192JA1052160825458652.176137-0.22300472E92000001E19000001E18000006E10000003E07000011E05008528CambridgeshireE10000003305400.769
SG192JD1052247525170952.150093-0.21136919E92000001E19000001E18000006E10000003E07000012E05002802CambridgeshireE10000003305400.769
SG192JE1052207225165852.149724-0.21727449E92000001E19000001E18000006E10000003E07000012E05002802CambridgeshireE10000003305400.769
SG192JH1052168725112052.144974-0.223091E92000001E19000001E18000006E10000003E07000012E05002802CambridgeshireE10000003305400.769
SG192JJ1052115725123952.14616-0.23078999E92000001E19000001E18000006E10000003E07000012E05002802CambridgeshireE10000003305400.769

CREATE TABLE sg_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.