{"id":23384,"date":"2022-11-25T17:14:12","date_gmt":"2022-11-25T11:44:12","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-passing-coordinates-values-from-google-sheets-columns-in-static-map-url\/"},"modified":"2022-11-25T17:14:12","modified_gmt":"2022-11-25T11:44:12","slug":"solved-passing-coordinates-values-from-google-sheets-columns-in-static-map-url","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-passing-coordinates-values-from-google-sheets-columns-in-static-map-url\/","title":{"rendered":"[Solved] Passing coordinates values from google sheets columns in static map URL"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-53815852\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"53815852\" data-parentid=\"53801375\" data-score=\"0\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>I think you had Lat, long wrong way around. Some mapping systems require Lat, Lng and others Lng, Lat (go figure!)<\/p>\n<p>If you change as below, you will get an image, but you may need to play with other parameters to get it working as you need.<\/p>\n<pre><code>=IMAGE(\"https:\/\/api.mapbox.com\/styles\/v1\/mapbox\/streets-v10\/static\/\"&amp;K3&amp;\",\"&amp;J3&amp;\",14.25,0,60\/600x600?access_token=API_KEY\")\n<\/code><\/pre>\n<p>You can also use the form below which is another way to construct the API string from the component parts.<\/p>\n<pre><code>=image(concatenate(\"https:\/\/api.mapbox.com\/styles\/v1\/mapbox\/streets-v10\/static\/\",K3,\",\",J3,\",14.25,0,60\/600x600?access_token=ACCESS_KEY\"))\n<\/code><\/pre>\n<p>In both cases, the parameters after the Coordinates represent the desired zoom, orientation angles and image resolution. You can play around with image formats here <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.mapbox.com\/help\/static-api-playground\/\">https:\/\/www.mapbox.com\/help\/static-api-playground\/<\/a>.<\/p>\n<p>Also note that you have options in Google sheets to adjust how the image is displayed (resize, stretch etc) in the cell, using the IMAGE parameters. This is explained here <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/support.google.com\/docs\/answer\/3093333?hl=en\">https:\/\/support.google.com\/docs\/answer\/3093333?hl=en<\/a><\/p>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\">12<\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved Passing coordinates values from google sheets columns in static map URL <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] I think you had Lat, long wrong way around. Some mapping systems require Lat, Lng and others Lng, Lat (go figure!) If you change as below, you will get an image, but you may need to play with other parameters to get it working as you need. =IMAGE(&#8220;https:\/\/api.mapbox.com\/styles\/v1\/mapbox\/streets-v10\/static\/&#8221;&amp;K3&amp;&#8221;,&#8221;&amp;J3&amp;&#8221;,14.25,0,60\/600&#215;600?access_token=API_KEY&#8221;) You can also use the form &#8230; <a title=\"[Solved] Passing coordinates values from google sheets columns in static map URL\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-passing-coordinates-values-from-google-sheets-columns-in-static-map-url\/\" aria-label=\"More on [Solved] Passing coordinates values from google sheets columns in static map URL\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[1835,1955,1192,5035],"class_list":["post-23384","post","type-post","status-publish","format-standard","hentry","category-solved","tag-arcgis","tag-google-sheets","tag-image","tag-mapbox"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] Passing coordinates values from google sheets columns in static map URL - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-passing-coordinates-values-from-google-sheets-columns-in-static-map-url\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] Passing coordinates values from google sheets columns in static map URL - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] I think you had Lat, long wrong way around. Some mapping systems require Lat, Lng and others Lng, Lat (go figure!) If you change as below, you will get an image, but you may need to play with other parameters to get it working as you need. =IMAGE(&quot;https:\/\/api.mapbox.com\/styles\/v1\/mapbox\/streets-v10\/static\/&quot;&amp;K3&amp;&quot;,&quot;&amp;J3&amp;&quot;,14.25,0,60\/600x600?access_token=API_KEY&quot;) You can also use the form ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-passing-coordinates-values-from-google-sheets-columns-in-static-map-url\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-25T11:44:12+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-passing-coordinates-values-from-google-sheets-columns-in-static-map-url\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-passing-coordinates-values-from-google-sheets-columns-in-static-map-url\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] Passing coordinates values from google sheets columns in static map URL\",\"datePublished\":\"2022-11-25T11:44:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-passing-coordinates-values-from-google-sheets-columns-in-static-map-url\/\"},\"wordCount\":162,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"arcgis\",\"google-sheets\",\"image\",\"mapbox\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-passing-coordinates-values-from-google-sheets-columns-in-static-map-url\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-passing-coordinates-values-from-google-sheets-columns-in-static-map-url\/\",\"name\":\"[Solved] Passing coordinates values from google sheets columns in static map URL - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-11-25T11:44:12+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-passing-coordinates-values-from-google-sheets-columns-in-static-map-url\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-passing-coordinates-values-from-google-sheets-columns-in-static-map-url\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-passing-coordinates-values-from-google-sheets-columns-in-static-map-url\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] Passing coordinates values from google sheets columns in static map URL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] Passing coordinates values from google sheets columns in static map URL - JassWeb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jassweb.com\/solved\/solved-passing-coordinates-values-from-google-sheets-columns-in-static-map-url\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] Passing coordinates values from google sheets columns in static map URL - JassWeb","og_description":"[ad_1] I think you had Lat, long wrong way around. Some mapping systems require Lat, Lng and others Lng, Lat (go figure!) If you change as below, you will get an image, but you may need to play with other parameters to get it working as you need. =IMAGE(\"https:\/\/api.mapbox.com\/styles\/v1\/mapbox\/streets-v10\/static\/\"&amp;K3&amp;\",\"&amp;J3&amp;\",14.25,0,60\/600x600?access_token=API_KEY\") You can also use the form ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-passing-coordinates-values-from-google-sheets-columns-in-static-map-url\/","og_site_name":"JassWeb","article_published_time":"2022-11-25T11:44:12+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-passing-coordinates-values-from-google-sheets-columns-in-static-map-url\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-passing-coordinates-values-from-google-sheets-columns-in-static-map-url\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] Passing coordinates values from google sheets columns in static map URL","datePublished":"2022-11-25T11:44:12+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-passing-coordinates-values-from-google-sheets-columns-in-static-map-url\/"},"wordCount":162,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["arcgis","google-sheets","image","mapbox"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-passing-coordinates-values-from-google-sheets-columns-in-static-map-url\/","url":"https:\/\/jassweb.com\/solved\/solved-passing-coordinates-values-from-google-sheets-columns-in-static-map-url\/","name":"[Solved] Passing coordinates values from google sheets columns in static map URL - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-11-25T11:44:12+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-passing-coordinates-values-from-google-sheets-columns-in-static-map-url\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-passing-coordinates-values-from-google-sheets-columns-in-static-map-url\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-passing-coordinates-values-from-google-sheets-columns-in-static-map-url\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] Passing coordinates values from google sheets columns in static map URL"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/23384","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=23384"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/23384\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=23384"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=23384"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=23384"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}