{"id":6052,"date":"2020-03-24T18:18:04","date_gmt":"2020-03-24T18:18:04","guid":{"rendered":"https:\/\/max-drake.cc\/?p=6052"},"modified":"2020-03-24T18:18:04","modified_gmt":"2020-03-24T18:18:04","slug":"covid-by-region-nz-map-representation-part-1","status":"publish","type":"post","link":"https:\/\/max-drake.cc\/?p=6052","title":{"rendered":"Covid by region NZ -map representation- Part 1"},"content":{"rendered":"\n<script src='https:\/\/api.mapbox.com\/mapbox-gl-js\/v1.8.1\/mapbox-gl.js'><\/script>\n<link href='https:\/\/api.mapbox.com\/mapbox-gl-js\/v1.8.1\/mapbox-gl.css' rel='stylesheet' \/>\n\n\n\n<div id='map' style='width: 400px; height: 300px;'><\/div>\n<script>\nmapboxgl.accessToken = 'pk.eyJ1IjoiZHJha2VtYXgiLCJhIjoiY2owaGNtcGdxMDB0NzJxbjVobGRia3F2ZSJ9.42QJTUL-tgR8Sw-sUuTB5Q';\nvar map = new mapboxgl.Map({\ncontainer: 'map',\nstyle: 'mapbox:\/\/styles\/mapbox\/light-v10',\nzoom: 4,\ncenter: [174.796359, -41.321203]\n});\n<\/script>\n\n\n\n<p>I&#8217;m thinking of trying to do an NZ map of regions where cases are. <\/p>\n\n\n\n<p>I&#8217;m using link to <strong><a rel=\"noreferrer noopener\" aria-label=\"Wikipedia 2020 coronavirus pandemic in New Zealand  (opens in a new tab)\" href=\"https:\/\/en.wikipedia.org\/wiki\/2020_coronavirus_pandemic_in_New_Zealand\" target=\"_blank\">Wikipedia 2020 coronavirus pandemic in New Zealand <\/a><\/strong>page for data on region data. <\/p>\n\n\n\n<p>I have been looking for polylines for these regions and also centroids for region polylines. No luck so far with centroids but I got the region polygons from the wiki site<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"547\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-15_44_49-2020-coronavirus-pandemic-in-New-Zealand-Wikipedia-1024x547.jpg\" alt=\"\" class=\"wp-image-6054 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-15_44_49-2020-coronavirus-pandemic-in-New-Zealand-Wikipedia-1024x547.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-15_44_49-2020-coronavirus-pandemic-in-New-Zealand-Wikipedia-300x160.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-15_44_49-2020-coronavirus-pandemic-in-New-Zealand-Wikipedia-768x410.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-15_44_49-2020-coronavirus-pandemic-in-New-Zealand-Wikipedia-1536x821.jpg 1536w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-15_44_49-2020-coronavirus-pandemic-in-New-Zealand-Wikipedia-2048x1094.jpg 2048w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-15_44_49-2020-coronavirus-pandemic-in-New-Zealand-Wikipedia-50x27.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-15_44_49-2020-coronavirus-pandemic-in-New-Zealand-Wikipedia-94x50.jpg 94w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-15_44_49-2020-coronavirus-pandemic-in-New-Zealand-Wikipedia-100x53.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-15_44_49-2020-coronavirus-pandemic-in-New-Zealand-Wikipedia-187x100.jpg 187w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-15_44_49-2020-coronavirus-pandemic-in-New-Zealand-Wikipedia-1198x640.jpg 1198w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-15_44_49-2020-coronavirus-pandemic-in-New-Zealand-Wikipedia-640x342.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-15_44_49-2020-coronavirus-pandemic-in-New-Zealand-Wikipedia-1437x768.jpg 1437w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-15_44_49-2020-coronavirus-pandemic-in-New-Zealand-Wikipedia-2021x1080.jpg 2021w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-15_44_49-2020-coronavirus-pandemic-in-New-Zealand-Wikipedia-1920x1026.jpg 1920w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/547;\" \/><\/figure>\n\n\n\n<p>If I copy that data across to Sheets I get a set of  information with a &lt;path> tag for each region:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"\"><tbody><tr><td>&lt;g\n  class=&#8221;nzmap__sector&#8221; data-for=&#8221;Marlborough&#8221;\n  data-island=&#8221;south-island&#8221;&nbsp;\n  style=&#8221;fill:#ffc0c0;fill-opacity:1&#8243;;&#8221;&gt;<\/td><\/tr><tr><td>&lt;path d=&#8221;M280.664482,296.742857   L280.140888,302.129323 L279.319387,301.596992 L276.168795,303.681203   L275.284101,303.004511 L272.955011,303.978947 L277.47778,300.415038   L279.247167,300.839098 L279.364524,299.440602 L277.33334,299.251128 L280.664482,296.742857   L280.664482,296.742857 Z M267.032981,288.487218 L268.071142,288.523308   L267.75518,289.723308 L267.132283,290.228571 L266.21148,288.649624   L265.705941,291.103759 L263.701839,291.618045 L264.77611,291.870677   <strong>&#8230;&#8230;&#8230;&#8230;&#8230;.<\/strong><br><br><strong><span style=\"color:#cf2e2e\" class=\"color\">LOTS OF INFO IN HERE DELETED AS I ONLY WANTED TO INDICATE POLYLINE CODE<\/span><\/strong><br>&#8230;&#8230;&#8230;&#8230;..<br>   L262.708816,280.015038 L262.555349,283.687218 L263.494207,282.35188   L264.63167,282.631579 L264.821247,281.891729 L263.142135,281.918797   L265.462199,280.06015 L265.850381,281.729323 L265.850381,281.729323   Z&#8221;>&lt;\/path><\/td><\/tr><tr><td>&lt;\/g&gt;<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>If I put this in an HTML file I get map of NZ in black, so I need to be able to control the fill of the regions.  As per the Wiki page I need to colour code based on numbers in the region.  I&#8217;ve used the wiki page and an Xpath<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"\"><tbody><tr><td>url<\/td><td><a href=\"https:\/\/en.wikipedia.org\/wiki\/2020_coronavirus_pandemic_in_New_Zealand\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/en.wikipedia.org\/wiki\/2020_coronavirus_pandemic_in_New_Zealand<\/a><\/td><td><\/td><\/tr><tr><td>xpath<\/td><td>\/\/ul[3]\/li<\/td><td><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>and then used :  <strong>=IMPORTXML($C$2,C3) <\/strong> to import the numbers confirmed in each region.<\/p>\n\n\n\n<p>In the HTML there is : <\/p>\n\n\n\n<g id=\"g5243\" style=\"fill:#ffc0c0;fill-opacity:1\"\tclass=\"nzmap__sector\" data-for=\"Canterbury\" data-island=\"south-island\" onclick=\"Drupal.behaviors.map.go('Canterbury');\">\t\n\n\n\n<p>I need to get rid of the :<\/p>\n\n\n\nonclick=&#8221;Drupal.behaviors.map.go(&#8216;Canterbury&#8217;);&#8221;>\t\n\n\n\n<p>and  add in :<\/p>\n\n\n\n style=&#8221;fill:#ffc0c0;fill-opacity:1&#8243;\n\n\n\n<p>Which will give the fill colour. Now the fill colour will be determined by the number of people. So I need arange of colours. i also need to rebuild the html code to put in the correct colour depending on the number. <\/p>\n\n\n\n<p class=\"has-background has-luminous-vivid-amber-background-color\">There are 2 ways I know to do this, both rather manual processes:<\/p>\n\n\n\n<p>One is with PyCharm with <span style=\"color:#cf2e2e\" class=\"color\">Python<\/span> where I built up the script\/file based on importing information from a spreadsheet that i used when creating Panorama files for multiple files of a project. <\/p>\n\n\n\n<p>The second method is a type of<span style=\"color:#cf2e2e\" class=\"color\"> concatenation within a spreadsheet<\/span>. Then, after building up the correct information I need to cut\/paste that information into an HTML file. <\/p>\n\n\n\n<p>A follow on from the first process is  that  I could think of <strong>using Google Cloud and running a container that will run the python script daily<\/strong> to update the file, then open that html fil in a web browser.  That may be a further iteration. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Back to the beginning<\/h3>\n\n\n\n<p>Initially as I was playing with this data I was thinking of creating some sort of GlideApp. So I started using Google Sheets to get the data using  <strong>=IMPORTXML() <\/strong> to pull in the data, then use the spreadsheet to manipulate and display in some other format such as a graph. <\/p>\n\n\n\n<p>So, now I have a source of data that I can grab from a web page (that is not generated by JavaScript) so I can now manipulate that information. <\/p>\n\n\n\n<p>Now, in Google Sheets I can get a Bar chart for the data just fine. After importing I just need to chage numbers in text format to numbers by using <strong>=VALUE()<\/strong> function to convert, then the info works in the charts fine. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"501\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_17_35-covid-importXML-Google-Sheets-1024x501.jpg\" alt=\"\" class=\"wp-image-6055 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_17_35-covid-importXML-Google-Sheets-1024x501.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_17_35-covid-importXML-Google-Sheets-300x147.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_17_35-covid-importXML-Google-Sheets-768x376.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_17_35-covid-importXML-Google-Sheets-1536x751.jpg 1536w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_17_35-covid-importXML-Google-Sheets-2048x1002.jpg 2048w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_17_35-covid-importXML-Google-Sheets-50x24.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_17_35-covid-importXML-Google-Sheets-102x50.jpg 102w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_17_35-covid-importXML-Google-Sheets-100x49.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_17_35-covid-importXML-Google-Sheets-204x100.jpg 204w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_17_35-covid-importXML-Google-Sheets-1309x640.jpg 1309w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_17_35-covid-importXML-Google-Sheets-640x313.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_17_35-covid-importXML-Google-Sheets-1570x768.jpg 1570w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_17_35-covid-importXML-Google-Sheets-1920x939.jpg 1920w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/501;\" \/><\/figure>\n\n\n\n<p>But for maps, the closest I can get for New Zealand is Oceania, and on a map it does not differentiate between NZ regional districts. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"689\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_20_25-covid-importXML-Google-Sheets-1024x689.jpg\" alt=\"\" class=\"wp-image-6056 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_20_25-covid-importXML-Google-Sheets-1024x689.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_20_25-covid-importXML-Google-Sheets-300x202.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_20_25-covid-importXML-Google-Sheets-768x517.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_20_25-covid-importXML-Google-Sheets-50x34.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_20_25-covid-importXML-Google-Sheets-74x50.jpg 74w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_20_25-covid-importXML-Google-Sheets-100x67.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_20_25-covid-importXML-Google-Sheets-149x100.jpg 149w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_20_25-covid-importXML-Google-Sheets-951x640.jpg 951w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_20_25-covid-importXML-Google-Sheets-640x431.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_20_25-covid-importXML-Google-Sheets-1141x768.jpg 1141w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_20_25-covid-importXML-Google-Sheets.jpg 1330w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/689;\" \/><\/figure>\n\n\n\n<p>If i change to Geo Chart with Markers, it finds the regions, and you can hover over them to get the data, but you can&#8217;t zoom in on the map to NZ only. <\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Step 2. Map of Regions<\/h4>\n\n\n\n<p>So this is why I was investigating polyline regions to colour in in the above section. The problem is that i&#8217;m now creating an HTML web page to display the information. So that is not in Google sheets, so may not be correct way to display for a GlideApp. Or is it? <\/p>\n\n\n\n<p>If i&#8217;m creating a HTML file I can just have a link that will pull up the map, and as GlideApps are just an app in a browser, so you can get a link to the map. <\/p>\n\n\n\n<p>So far, I&#8217;ve pulled the regional data into Sheets. The next is to have a colour range base on numbers , and a lookup to get the colour code. <\/p>\n\n\n\n<p>So I want a colour range. I made a list of numbers for the initial range (a bit low, but it&#8217;ll do for a start, and used conditional formatting on the range <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"740\" height=\"976\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_40_46-covid-importXML-Google-Sheets.jpg\" alt=\"\" class=\"wp-image-6057 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_40_46-covid-importXML-Google-Sheets.jpg 740w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_40_46-covid-importXML-Google-Sheets-227x300.jpg 227w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_40_46-covid-importXML-Google-Sheets-50x66.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_40_46-covid-importXML-Google-Sheets-38x50.jpg 38w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_40_46-covid-importXML-Google-Sheets-100x132.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_40_46-covid-importXML-Google-Sheets-76x100.jpg 76w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_40_46-covid-importXML-Google-Sheets-485x640.jpg 485w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_40_46-covid-importXML-Google-Sheets-640x844.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_40_46-covid-importXML-Google-Sheets-582x768.jpg 582w\" data-sizes=\"(max-width: 740px) 100vw, 740px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 740px; --smush-placeholder-aspect-ratio: 740\/976;\" \/><\/figure>\n\n\n\n<p>Now I need to use a colour picker to find out the colours I&#8217;ve chosen for the scale, I&#8217;m using a FireFox browser add in ColorZilla that identifies the colour and you can paste the data into a list.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"749\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_43_25-covid-importXML-Google-Sheets-1024x749.jpg\" alt=\"\" class=\"wp-image-6058 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_43_25-covid-importXML-Google-Sheets-1024x749.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_43_25-covid-importXML-Google-Sheets-300x219.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_43_25-covid-importXML-Google-Sheets-768x561.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_43_25-covid-importXML-Google-Sheets-50x37.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_43_25-covid-importXML-Google-Sheets-68x50.jpg 68w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_43_25-covid-importXML-Google-Sheets-100x73.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_43_25-covid-importXML-Google-Sheets-137x100.jpg 137w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_43_25-covid-importXML-Google-Sheets-876x640.jpg 876w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_43_25-covid-importXML-Google-Sheets-640x468.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_43_25-covid-importXML-Google-Sheets-1051x768.jpg 1051w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-24-16_43_25-covid-importXML-Google-Sheets.jpg 1394w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/749;\" \/><\/figure>\n\n\n\n<p>I then created a lookup to get specific colours associated with numbers, after first using  <strong>=value(IF(E6>=10,ROUNDDOWN(E6,-1),IF(5&lt;=E6,5,IF(1&lt;=E6,1)))) <\/strong> formula to get numbers in specific range, so 57 , above 50 but below 60 would be rounded down to 50, 2 to 4 would be rounded down to 1, etc etc. <\/p>\n\n\n\n<p>After doing this I could then use the colour coding with a lookup to choose correct colour for the region  <strong>=LOOKUP(F6,$K$6:$K$18,$M$6:$M$18) <\/strong> which works fine as long as there is data, but if there is no data, like in Gisborne or West Coast, I dealt with this in the concatenation process next.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"351\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_25_09-covid-importXML-Google-Sheets-1024x351.jpg\" alt=\"\" class=\"wp-image-6061 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_25_09-covid-importXML-Google-Sheets-1024x351.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_25_09-covid-importXML-Google-Sheets-300x103.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_25_09-covid-importXML-Google-Sheets-768x263.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_25_09-covid-importXML-Google-Sheets-50x17.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_25_09-covid-importXML-Google-Sheets-146x50.jpg 146w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_25_09-covid-importXML-Google-Sheets-100x34.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_25_09-covid-importXML-Google-Sheets-292x100.jpg 292w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_25_09-covid-importXML-Google-Sheets-640x219.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_25_09-covid-importXML-Google-Sheets.jpg 1510w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/351;\" \/><\/figure>\n\n\n\n<p> <\/p>\n\n\n\n<p>So on this new tab I set up the regions wth their specific paths, and they were not in the same order as on the previous page, so I used a lookup to get the correct colour , and if there was blank data for a region <\/p>\n\n\n\n<p>I used the IFERROR to give it a Grey colour associated with no number<\/p>\n\n\n\n<p><strong>=iferror(vlookup(A16,&#8217;New Zealand&#8217;!$C$6:$FD$19,5,FALSE),&#8221;#efefef&#8221;) <\/strong> <\/p>\n\n\n\n<p>So next I needed to do a concatenation of the html for each area of the map with a color code attached to it.  <\/p>\n\n\n\n<p><strong> =IFERROR(CONCATENATE($D$1,A9,$E$1,C9,$F$1,H9,$G$1),&#8221;&#8221;) <\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"318\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_22_07-covid-importXML-Google-Sheets-1024x318.jpg\" alt=\"\" class=\"wp-image-6060 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_22_07-covid-importXML-Google-Sheets-1024x318.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_22_07-covid-importXML-Google-Sheets-300x93.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_22_07-covid-importXML-Google-Sheets-768x238.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_22_07-covid-importXML-Google-Sheets-1536x476.jpg 1536w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_22_07-covid-importXML-Google-Sheets-50x16.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_22_07-covid-importXML-Google-Sheets-161x50.jpg 161w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_22_07-covid-importXML-Google-Sheets-100x31.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_22_07-covid-importXML-Google-Sheets-323x100.jpg 323w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_22_07-covid-importXML-Google-Sheets-640x198.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_22_07-covid-importXML-Google-Sheets.jpg 1777w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/318;\" \/><\/figure>\n\n\n\n<p>So for each region I concatenated data with the polyline path for a specific region and the html coding for the other parts for each regio, this I cut\/pasted into a notepad++ html file (with normal HTML page header etc) so I cxould run it as a file:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"468\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_22_42-C__Users_drake_Downloads_map-regions4.html-Notepad-1024x468.jpg\" alt=\"\" class=\"wp-image-6062 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_22_42-C__Users_drake_Downloads_map-regions4.html-Notepad-1024x468.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_22_42-C__Users_drake_Downloads_map-regions4.html-Notepad-300x137.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_22_42-C__Users_drake_Downloads_map-regions4.html-Notepad-768x351.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_22_42-C__Users_drake_Downloads_map-regions4.html-Notepad-1536x702.jpg 1536w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_22_42-C__Users_drake_Downloads_map-regions4.html-Notepad-50x23.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_22_42-C__Users_drake_Downloads_map-regions4.html-Notepad-109x50.jpg 109w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_22_42-C__Users_drake_Downloads_map-regions4.html-Notepad-100x46.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_22_42-C__Users_drake_Downloads_map-regions4.html-Notepad-219x100.jpg 219w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_22_42-C__Users_drake_Downloads_map-regions4.html-Notepad-1401x640.jpg 1401w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_22_42-C__Users_drake_Downloads_map-regions4.html-Notepad-640x292.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_22_42-C__Users_drake_Downloads_map-regions4.html-Notepad-1681x768.jpg 1681w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_22_42-C__Users_drake_Downloads_map-regions4.html-Notepad.jpg 1819w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/468;\" \/><\/figure>\n\n\n\n<p>And the resulting web page generated is as below:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"657\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_20_47-Mail-1024x657.jpg\" alt=\"\" class=\"wp-image-6059 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_20_47-Mail-1024x657.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_20_47-Mail-300x192.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_20_47-Mail-768x493.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_20_47-Mail-1536x985.jpg 1536w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_20_47-Mail-2048x1314.jpg 2048w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_20_47-Mail-50x32.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_20_47-Mail-78x50.jpg 78w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_20_47-Mail-100x64.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_20_47-Mail-156x100.jpg 156w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_20_47-Mail-998x640.jpg 998w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_20_47-Mail-640x411.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_20_47-Mail-1197x768.jpg 1197w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_20_47-Mail-1683x1080.jpg 1683w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_20_47-Mail-1920x1232.jpg 1920w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/657;\" \/><\/figure>\n\n\n\n<p>Which did not differentiate the different regions very clearly  if the colours were the same or similar. To manage this I gave a black border colour with  <strong>stroke=&#8221;black&#8221; <\/strong>. Also I changed the view area on screen to <strong> viewBox=&#8221;0 0 1050 1050&#8243;<\/strong> from  <strong>iewBox=&#8221;0 0 650 650&#8243;<\/strong>  so the whole map fitted on the screen<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"631\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_39_12-Mozilla-Firefox-1024x631.jpg\" alt=\"\" class=\"wp-image-6063 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_39_12-Mozilla-Firefox-1024x631.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_39_12-Mozilla-Firefox-300x185.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_39_12-Mozilla-Firefox-768x474.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_39_12-Mozilla-Firefox-1536x947.jpg 1536w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_39_12-Mozilla-Firefox-2048x1263.jpg 2048w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_39_12-Mozilla-Firefox-50x31.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_39_12-Mozilla-Firefox-81x50.jpg 81w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_39_12-Mozilla-Firefox-100x62.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_39_12-Mozilla-Firefox-162x100.jpg 162w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_39_12-Mozilla-Firefox-1038x640.jpg 1038w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_39_12-Mozilla-Firefox-640x395.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_39_12-Mozilla-Firefox-1245x768.jpg 1245w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_39_12-Mozilla-Firefox-1751x1080.jpg 1751w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-11_39_12-Mozilla-Firefox-1920x1184.jpg 1920w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/631;\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Legend on the Map-<span style=\"color:#cf2e2e\" class=\"color\">Stopped<\/span><\/h4>\n\n\n\n<p>I started to look at this then the data disappeard again due to web page update. It went from Xpath <strong> \/\/ul[17]\/li<\/strong> to  <strong>\/\/ul[28 ]\/li<\/strong> but I couldn&#8217;t get the data back. So I thought I&#8217;d loook at the source data on Ministry of Health site: <strong>https:\/\/www.health.govt.nz\/our-work\/diseases-and-conditions\/covid-19-novel-coronavirus\/covid-19-current-cases<\/strong><\/p>\n\n\n\n<p>This is in a different format but I can use importXML to grab it. The data needs a bit more manipulation though. <\/p>\n\n\n\n<p>I then thought I&#8217;d see if Knime would do some of this processing, but looking at examples it was not very elegant, so after updating KNIME <strong><span style=\"color:#cf2e2e\" class=\"color\">I decided I wouldn&#8217;t go down that path. <\/span><\/strong><\/p>\n\n\n\n<p>So, after using the different data source I have the initial map &amp; legend. I&#8217;ve used a container to split the screen into two  div&#8217;s wwith map one side and legend the other. Scales all a bit messy at the moment. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"501\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-19_08_16-Mozilla-Firefox-1024x501.jpg\" alt=\"\" class=\"wp-image-6064 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-19_08_16-Mozilla-Firefox-1024x501.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-19_08_16-Mozilla-Firefox-300x147.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-19_08_16-Mozilla-Firefox-768x376.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-19_08_16-Mozilla-Firefox-1536x751.jpg 1536w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-19_08_16-Mozilla-Firefox-2048x1002.jpg 2048w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-19_08_16-Mozilla-Firefox-50x24.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-19_08_16-Mozilla-Firefox-102x50.jpg 102w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-19_08_16-Mozilla-Firefox-100x49.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-19_08_16-Mozilla-Firefox-204x100.jpg 204w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-19_08_16-Mozilla-Firefox-1308x640.jpg 1308w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-19_08_16-Mozilla-Firefox-640x313.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-19_08_16-Mozilla-Firefox-1570x768.jpg 1570w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-19_08_16-Mozilla-Firefox-1920x939.jpg 1920w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/501;\" \/><\/figure>\n\n\n\n<p>So far I&#8217;ve just got the basic legensd, but colour grade from orange to red not that clear. I can change that later. <\/p>\n\n\n\n<p>The data I now have extracted is , Region and numbers by region, Gender, at this time almost 50\/50 and age groups. There is some other data re travel and infection vectors that I&#8217;m not looking at yet. I want to tidy up the data first and get the other info displayed before I look at that. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"352\" data-src=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-19_10_34-covid-importXML-Google-Sheets-1024x352.jpg\" alt=\"\" class=\"wp-image-6065 lazyload\" data-srcset=\"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-19_10_34-covid-importXML-Google-Sheets-1024x352.jpg 1024w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-19_10_34-covid-importXML-Google-Sheets-300x103.jpg 300w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-19_10_34-covid-importXML-Google-Sheets-768x264.jpg 768w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-19_10_34-covid-importXML-Google-Sheets-50x17.jpg 50w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-19_10_34-covid-importXML-Google-Sheets-146x50.jpg 146w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-19_10_34-covid-importXML-Google-Sheets-100x34.jpg 100w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-19_10_34-covid-importXML-Google-Sheets-291x100.jpg 291w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-19_10_34-covid-importXML-Google-Sheets-640x220.jpg 640w, https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-19_10_34-covid-importXML-Google-Sheets.jpg 1464w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/352;\" \/><\/figure>\n\n\n\n<p>I also want to look at population size re number of confirmed cases. I&#8217;ll need to web scrape that data from something like wiki, as that is not as dynamic I should be able to use Xpath more effectively to capture that data. <\/p>\n\n\n\n<p>So ends day 2 messing with this info. I still need to label the regions on the map. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;m thinking of trying to do an NZ map of regions where cases are. I&#8217;m using link to Wikipedia 2020 coronavirus pandemic in New Zealand page for data on region data. I have been looking for polylines for these regions and also centroids for region polylines. No luck so far with centroids but I got [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":6064,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[40,3,1,265,6,12,29],"tags":[],"class_list":["post-6052","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-analysis","category-data-extraction","category-general","category-google-docs","category-maps","category-visualisation","category-web"],"featured_image_src":"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-19_08_16-Mozilla-Firefox.jpg","featured_image_src_square":"https:\/\/max-drake.cc\/wp-content\/uploads\/2020\/03\/2020-03-25-19_08_16-Mozilla-Firefox.jpg","author_info":{"display_name":"Max Drake","author_link":"https:\/\/max-drake.cc\/?author=1"},"_links":{"self":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts\/6052","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6052"}],"version-history":[{"count":0,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/posts\/6052\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=\/wp\/v2\/media\/6064"}],"wp:attachment":[{"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6052"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6052"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/max-drake.cc\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6052"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}