{"id":25,"date":"2012-01-18T18:40:31","date_gmt":"2012-01-18T18:40:31","guid":{"rendered":"http:\/\/www.haroldstreet.org.uk\/osgb\/?page_id=25"},"modified":"2012-06-18T06:28:04","modified_gmt":"2012-06-18T06:28:04","slug":"map-references","status":"publish","type":"page","link":"https:\/\/www.haroldstreet.org.uk\/osgb\/map-references\/","title":{"rendered":"Map References"},"content":{"rendered":"<p>A full reference which is unique across\u00a0Britain\u00a0will consist of two letters followed by (typically) six digits giving resolution to 100 metres eg (SS 599 939).\u00a0 Eight digits are needed for 10 metre resolution and 10 digits for one metre.\u00a0\u00a0 The two letters indicate the 100Km by 100Km square in which the point lies and are often omitted since this is usually unambiguous.<\/p>\n<p>The first letter gives the 500Km by 500Km square.\u00a0\u00a0 25 different letters (omitting I)\u00a0could be given here though only five actually map to the covered land areas: S for south west, T for south east, N for the north and\u00a0Scotland\u00a0and H for the\u00a0Shetland Islands.\u00a0 The &#8220;O&#8221; square contains a tiny area of the North Riding of Yorkshire near point OV000000, but it looked pretty inaccessible when I paid a pilgrimage there!\u00a0 See\u00a0<a title=\"here\" href=\"http:\/\/www.geograph.org.uk\/article\/In-Search-of-OV0000\" target=\"_blank\">http:\/\/www.geograph.org.uk\/article\/In-Search-of-OV0000<\/a> for a description by Peter Standing. \u00a0 The second letter gives the 100Km by 100Km square within that and is laid out with A in the\u00a0North Westcorner, Z in the South East thus:<\/p>\n<blockquote><p><tt>ABCDE<\/tt><br \/>\n<tt>FGHJK<\/tt><br \/>\n<tt>LMNOP<\/tt><br \/>\n<tt>QRSTU<\/tt><br \/>\n<tt>VWXYZ<\/tt><\/p><\/blockquote>\n<p>See\u00a0<a href=\"http:\/\/www.ordnancesurvey.co.uk\/oswebsite\/gi\/nationalgrid\/nghelp1.html\" target=\"_blank\">http:\/\/www.ordnancesurvey.co.uk\/oswebsite\/gi\/nationalgrid\/nghelp1.html<\/a>\u00a0\u00a0for a map of the squares and a good tutorial on references.<\/p>\n<p>The digits should be split into two groups &#8211; in the above example of SS 599 939 the point is 59.9 Km east and 93.9 Km north of the south west corner of square SS.<\/p>\n<p>The measurement of a reference is made easier by the regular grid of squares representing 1Km (or 10Km for motoring maps) on the ground and printed on every map.\u00a0 The references of those grid lines are shown on the margins of the map and, on some, at intervals across the map.\u00a0\u00a0 To determine a reference on a map with a 1Km grid:<\/p>\n<ul>\n<li>note the letters square from a description in the margins of the map or overprinted in the corners (eg SS)<\/li>\n<li>read off the two digit eastings number at the bottom or top of the map against the vertical line to the left of the point (eg 59)<\/li>\n<li>estimate the horizontal distance in tenths from the line (eg 9)<\/li>\n<li>read off the two digit northings number against the side of the map (eg 93)<\/li>\n<li>estimate tenths north from this (9)<\/li>\n<\/ul>\n<p>The resulting reference SS 599939 resolves to 100 metres and the procedure is described on the margin of every OS map.\u00a0 If you wish you can use a centimetre ruler (there is one on my compass) to help you achieve more accuracy or you could invest a pound and buy a plastic scale called a romer.\u00a0 Be warned though that a romer is transparent and easily lost &#8211; mine vanished a week after I purchased it, re-surfaced briefly after a year and has not been seen since! \u00a0 Note that dividers or special scales are not needed as I understand they are with some US maps.<\/p>\n<p>The margins of the maps also have &#8216;ticks&#8217; and the body of the map has blue crosses to show latitude and longitude.\u00a0 Note that these are relative to the OS 1936 datum and not WGS84 which is becoming increasingly standard across the world.\u00a0 Also note that the lines of latitude and longitude are both curved and are not parallel to the printed OS grid.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A full reference which is unique across\u00a0Britain\u00a0will consist of two letters followed by (typically) six digits giving resolution to 100 metres eg (SS 599 939).\u00a0 Eight digits are needed for 10 metre resolution and 10 digits for one metre.\u00a0\u00a0 The two letters indicate the 100Km by 100Km square in which the point lies and are [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":30,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-25","page","type-page","status-publish","hentry"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.1.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"Excel routines for calculations and conversions with latitude, longitude and Ordnance Survey references. Import GPX, Export GPX, export KML data.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"keywords\" content=\"excel,ordnance survey,conversions,gpx,kml\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/www.haroldstreet.org.uk\/osgb\/map-references\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.1.1\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.haroldstreet.org.uk\\\/osgb\\\/map-references\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.haroldstreet.org.uk\\\/osgb#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.haroldstreet.org.uk\\\/osgb\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.haroldstreet.org.uk\\\/osgb\\\/map-references\\\/#listItem\",\"name\":\"Map References\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.haroldstreet.org.uk\\\/osgb\\\/map-references\\\/#listItem\",\"position\":2,\"name\":\"Map References\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.haroldstreet.org.uk\\\/osgb#listItem\",\"name\":\"Home\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.haroldstreet.org.uk\\\/osgb\\\/#person\",\"name\":\"Philip Brady\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.haroldstreet.org.uk\\\/osgb\\\/map-references\\\/#webpage\",\"url\":\"https:\\\/\\\/www.haroldstreet.org.uk\\\/osgb\\\/map-references\\\/\",\"name\":\"Ordnance Survey Excel routines. | Ordnance Survey FAQ and Excel Mapping Routines\",\"description\":\"Excel routines for calculations and conversions with latitude, longitude and Ordnance Survey references. Import GPX, Export GPX, export KML data.\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.haroldstreet.org.uk\\\/osgb\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.haroldstreet.org.uk\\\/osgb\\\/map-references\\\/#breadcrumblist\"},\"datePublished\":\"2012-01-18T18:40:31+00:00\",\"dateModified\":\"2012-06-18T06:28:04+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.haroldstreet.org.uk\\\/osgb\\\/#website\",\"url\":\"https:\\\/\\\/www.haroldstreet.org.uk\\\/osgb\\\/\",\"name\":\"Ordnance Survey FAQ and Excel Mapping Routines\",\"description\":\"Phil Brady \\u00a9 2020\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.haroldstreet.org.uk\\\/osgb\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Ordnance Survey Excel routines. | Ordnance Survey FAQ and Excel Mapping Routines","description":"Excel routines for calculations and conversions with latitude, longitude and Ordnance Survey references. Import GPX, Export GPX, export KML data.","canonical_url":"https:\/\/www.haroldstreet.org.uk\/osgb\/map-references\/","robots":"max-image-preview:large","keywords":"excel,ordnance survey,conversions,gpx,kml","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BreadcrumbList","@id":"https:\/\/www.haroldstreet.org.uk\/osgb\/map-references\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/www.haroldstreet.org.uk\/osgb#listItem","position":1,"name":"Home","item":"https:\/\/www.haroldstreet.org.uk\/osgb","nextItem":{"@type":"ListItem","@id":"https:\/\/www.haroldstreet.org.uk\/osgb\/map-references\/#listItem","name":"Map References"}},{"@type":"ListItem","@id":"https:\/\/www.haroldstreet.org.uk\/osgb\/map-references\/#listItem","position":2,"name":"Map References","previousItem":{"@type":"ListItem","@id":"https:\/\/www.haroldstreet.org.uk\/osgb#listItem","name":"Home"}}]},{"@type":"Person","@id":"https:\/\/www.haroldstreet.org.uk\/osgb\/#person","name":"Philip Brady"},{"@type":"WebPage","@id":"https:\/\/www.haroldstreet.org.uk\/osgb\/map-references\/#webpage","url":"https:\/\/www.haroldstreet.org.uk\/osgb\/map-references\/","name":"Ordnance Survey Excel routines. | Ordnance Survey FAQ and Excel Mapping Routines","description":"Excel routines for calculations and conversions with latitude, longitude and Ordnance Survey references. Import GPX, Export GPX, export KML data.","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/www.haroldstreet.org.uk\/osgb\/#website"},"breadcrumb":{"@id":"https:\/\/www.haroldstreet.org.uk\/osgb\/map-references\/#breadcrumblist"},"datePublished":"2012-01-18T18:40:31+00:00","dateModified":"2012-06-18T06:28:04+00:00"},{"@type":"WebSite","@id":"https:\/\/www.haroldstreet.org.uk\/osgb\/#website","url":"https:\/\/www.haroldstreet.org.uk\/osgb\/","name":"Ordnance Survey FAQ and Excel Mapping Routines","description":"Phil Brady \u00a9 2020","inLanguage":"en-US","publisher":{"@id":"https:\/\/www.haroldstreet.org.uk\/osgb\/#person"}}]}},"aioseo_meta_data":{"post_id":"25","title":"Ordnance Survey Excel routines. | #site_title","description":"Excel routines for calculations and conversions with latitude, longitude and Ordnance Survey references.  Import GPX, Export GPX, export KML data.","keywords":[{"label":"Excel","value":"Excel"},{"label":"Ordnance Survey","value":"Ordnance Survey"},{"label":"conversions","value":"conversions"},{"label":"GPX","value":"GPX"},{"label":"KML","value":"KML"}],"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[],"defaultGraph":"","defaultPostTypeGraph":""},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"location":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2021-01-10 15:01:16","updated":"2025-06-04 02:20:04","seo_analyzer_scan_date":null,"focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"_links":{"self":[{"href":"https:\/\/www.haroldstreet.org.uk\/osgb\/wp-json\/wp\/v2\/pages\/25","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.haroldstreet.org.uk\/osgb\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.haroldstreet.org.uk\/osgb\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.haroldstreet.org.uk\/osgb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.haroldstreet.org.uk\/osgb\/wp-json\/wp\/v2\/comments?post=25"}],"version-history":[{"count":8,"href":"https:\/\/www.haroldstreet.org.uk\/osgb\/wp-json\/wp\/v2\/pages\/25\/revisions"}],"predecessor-version":[{"id":219,"href":"https:\/\/www.haroldstreet.org.uk\/osgb\/wp-json\/wp\/v2\/pages\/25\/revisions\/219"}],"wp:attachment":[{"href":"https:\/\/www.haroldstreet.org.uk\/osgb\/wp-json\/wp\/v2\/media?parent=25"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}