{"id":19815,"date":"2022-11-07T20:17:11","date_gmt":"2022-11-07T14:47:11","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-fetchxml-geocode-distance-search-by-distance\/"},"modified":"2022-11-07T20:17:11","modified_gmt":"2022-11-07T14:47:11","slug":"solved-fetchxml-geocode-distance-search-by-distance","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-fetchxml-geocode-distance-search-by-distance\/","title":{"rendered":"[Solved] FetchXML – GeoCode Distance search by distance"},"content":{"rendered":"

[ad_1]
\n<\/p>\n

\n
\n
<\/div>\n
\n
\n

You won’t be able to do this directly via FetchXml as geocoding is not offered as a feature. <\/p>\n

This means you’ll need to start rolling something by hand which will not be easy. This site<\/a> has a pretty good overview of what you’d need to do (even if the language is different to what you’d likely use with CRM).<\/p>\n

One option may be to relax your requirement and just use FetchXml to look for records with a longitude +\/- 1.5 miles and<\/strong> latitude +\/- 1.5 miles (which of course queries an area shaped like a square rather than a radius).<\/p>\n

If you need to be more strict, you could try to rewrite the following MySQL<\/strong> (i.e. not MSSQL!) query and use it alongside some sort of QueryExpression instead? So, for example, a query expression to determine a rough subset of data, as above (e.g. where longitude and latitude is with 1.5 miles of central point) and then after returning those results, for each one calculate if it falls within the desired radius…<\/p>\n

SELECT id, X(gm_coor) AS latitude, Y(gm_coor) AS longitude,\n  ATAN2(\n    SQRT(\n      POW(COS(RADIANS(__LAT__)) *\n           SIN(RADIANS(Y(gm_coor) - __LNG__)), 2) + \n      POW(COS(RADIANS(X(gm_coor))) * SIN(RADIANS(__LAT__)) - \n          SIN(RADIANS(X(gm_coor))) * COS(RADIANS(__LAT__)) * \n          COS(RADIANS(Y(gm_coor) - __LNG__)), 2)), \n    (SIN(RADIANS(X(gm_coor))) * SIN(RADIANS(__LAT__)) + \n     COS(RADIANS(X(gm_coor))) * COS(RADIANS(__LAT__)) * \n     COS(RADIANS(Y(gm_coor) - __LNG__)))\n  ) * 6372.795 AS distance \nFROM geocoded\nHAVING distance < [RANGE IN KILOMETRES]\n<\/code><\/pre>\n<\/p><\/div>\n
<\/div>\n<\/div>\n
            1<\/span> <\/p><\/div>\n<\/div>\n
[ad_2]<\/p>\n
solved FetchXML – GeoCode Distance search by distance <\/p>\n","protected":false},"excerpt":{"rendered":"
[ad_1] You won’t be able to do this directly via FetchXml as geocoding is not offered as a feature. This means you’ll need to start rolling something by hand which will not be easy. This site has a pretty good overview of what you’d need to do (even if the language is different to what … 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":[4682,4684,4685,4683],"class_list":["post-19815","post","type-post","status-publish","format-standard","hentry","category-solved","tag-dynamics-crm","tag-dynamics-crm-2011","tag-fetchxml","tag-geocoding"],"yoast_head":"\n[Solved] FetchXML - GeoCode Distance search by distance - 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-fetchxml-geocode-distance-search-by-distance\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] FetchXML - GeoCode Distance search by distance - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] You won’t be able to do this directly via FetchXml as geocoding is not offered as a feature. This means you’ll need to start rolling something by hand which will not be easy. This site has a pretty good overview of what you’d need to do (even if the language is different to what ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-fetchxml-geocode-distance-search-by-distance\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-07T14:47:11+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-fetchxml-geocode-distance-search-by-distance\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-fetchxml-geocode-distance-search-by-distance\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] FetchXML – GeoCode Distance search by distance\",\"datePublished\":\"2022-11-07T14:47:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-fetchxml-geocode-distance-search-by-distance\/\"},\"wordCount\":193,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"dynamics-crm\",\"dynamics-crm-2011\",\"fetchxml\",\"geocoding\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-fetchxml-geocode-distance-search-by-distance\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-fetchxml-geocode-distance-search-by-distance\/\",\"name\":\"[Solved] FetchXML - GeoCode Distance search by distance - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-11-07T14:47:11+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-fetchxml-geocode-distance-search-by-distance\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-fetchxml-geocode-distance-search-by-distance\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-fetchxml-geocode-distance-search-by-distance\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] FetchXML – GeoCode Distance search by distance\"}]},{\"@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=1775193939\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] FetchXML - GeoCode Distance search by distance - 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-fetchxml-geocode-distance-search-by-distance\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] FetchXML - GeoCode Distance search by distance - JassWeb","og_description":"[ad_1] You won’t be able to do this directly via FetchXml as geocoding is not offered as a feature. This means you’ll need to start rolling something by hand which will not be easy. This site has a pretty good overview of what you’d need to do (even if the language is different to what ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-fetchxml-geocode-distance-search-by-distance\/","og_site_name":"JassWeb","article_published_time":"2022-11-07T14:47:11+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-fetchxml-geocode-distance-search-by-distance\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-fetchxml-geocode-distance-search-by-distance\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] FetchXML – GeoCode Distance search by distance","datePublished":"2022-11-07T14:47:11+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-fetchxml-geocode-distance-search-by-distance\/"},"wordCount":193,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["dynamics-crm","dynamics-crm-2011","fetchxml","geocoding"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-fetchxml-geocode-distance-search-by-distance\/","url":"https:\/\/jassweb.com\/solved\/solved-fetchxml-geocode-distance-search-by-distance\/","name":"[Solved] FetchXML - GeoCode Distance search by distance - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-11-07T14:47:11+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-fetchxml-geocode-distance-search-by-distance\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-fetchxml-geocode-distance-search-by-distance\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-fetchxml-geocode-distance-search-by-distance\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] FetchXML – GeoCode Distance search by distance"}]},{"@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=1775193939","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939","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\/19815","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=19815"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/19815\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=19815"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=19815"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=19815"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}