{"version":"1.0","provider_name":"Snowflake in the Carolinas","provider_url":"https:\/\/snowflake.pavlik.us","author_name":"Greg Pavlik","author_url":"https:\/\/snowflake.pavlik.us\/index.php\/author\/greg_nozz9ly9\/","title":"Geolocation of IP Addresses in Snowflake \u2013 Part 3 - Snowflake in the Carolinas","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"LwHEucqhbo\"><a href=\"https:\/\/snowflake.pavlik.us\/index.php\/2020\/11\/30\/geolocation-of-ip-addresses-in-snowflake-part-3\/\">Geolocation of IP Addresses in Snowflake \u2013 Part 3<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/snowflake.pavlik.us\/index.php\/2020\/11\/30\/geolocation-of-ip-addresses-in-snowflake-part-3\/embed\/#?secret=LwHEucqhbo\" width=\"600\" height=\"338\" title=\"&#8220;Geolocation of IP Addresses in Snowflake \u2013 Part 3&#8221; &#8212; Snowflake in the Carolinas\" data-secret=\"LwHEucqhbo\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script type=\"text\/javascript\">\n\/* <![CDATA[ *\/\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/\/# sourceURL=https:\/\/snowflake.pavlik.us\/wp-includes\/js\/wp-embed.min.js\n\/* ]]> *\/\n<\/script>\n","description":"Programming Note This is a continuation of the Part 1 and Part 2 of this series. Since considerable time has passed and changes made to the testing since posting those articles, this post will start from the beginning. The Business Case for Geolocating IP Numbers Business intelligence and data science teams can get valuable insights [&hellip;]","thumbnail_url":"https:\/\/snowflake.pavlik.us\/wp-content\/uploads\/2020\/11\/IP2Location_LeftJoin-1024x904.jpg"}