{"id":6067,"date":"2020-03-25T12:56:58","date_gmt":"2020-03-25T12:56:58","guid":{"rendered":"https:\/\/max-drake.cc\/?p=6067"},"modified":"2020-03-25T14:13:35","modified_gmt":"2020-03-25T14:13:35","slug":"covid-by-region-nz-map-representation-part-2","status":"publish","type":"post","link":"https:\/\/max-drake.cc\/?p=6067","title":{"rendered":"Covid by region NZ -map representation- Part 2"},"content":{"rendered":"\n

At the end of the fist part I’d got some data to play with from a couple of sources, cleaned it up, got some data to make paths to create a map and coloured map in by region based on covid cases. This was done using Excel, Notepad++ and displayed in browser. I was just starting to look at labels\/legends for the map. <\/p>\n\n\n\n

Using Datawrapper<\/h4>\n\n\n\n

I have played with online maps before, but they were pretty limited as far as NZ went, like Google Charts ap only showing Oceania, not NZ. I decided to have another look at Datwrapper as I hadn’t played with it for a couple of years and it may have updated. It has, there is a NZ regional map, so I’d thought I’d play with that to see if I could progress with the data more readily. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

I chose a symbol map type (will definitely have to play with the locator map, that looks cool)<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Then after selecting NZ regional map I was asked for data. Since it is symbol I need a point to locate the data. So I went into…<\/p>\n\n\n\n

Google Earth for points within boundaries<\/h4>\n\n\n\n
\"\"<\/figure>\n\n\n\n

In Google Earth I turned on borders and turned off roads, then put a placemark in the different regions with a title . I made a new folder to store all the placemarks in. I wanted to get that data to use in sheets, a Lat\/Long & Title. I knew I could go into individual placemarks and cut\/paste data but I was sure there is an easier way to export multiple points from Google Earth. <\/p>\n\n\n\n

You can select afolder and exported to a KMZ file. Unfortunately that is compiled, so I needed a mthod to extract the data from KMZ to another format. I forund this web page Google Earth placemarks to Excel<\/a><\/strong>. That converted the KMZ file to a CSV file that I could open in Sheets or notepad. This process is good, because if I need to move one pin because it is not in a good position its easy to do and easy to update. Here is the list of pin locations. At least this is a start. I had issues trying to find centroids of regions but this is far better as you can adjust as you need for aesthetic presentation purposes<\/p>\n\n\n\n

“Name”,”Description”,”Latitude”,”Longitude”
Northland,,-35.55752897288653,173.9706962308053
Auckland,,-36.88446458503898,174.7593660699155
Waikato,,-38.08646123851568,175.5620179677784
Bay of Plenty,,-38.01950908158162,176.6506252739918
Gisborne,,-38.31711552776068,177.9513173813045
Hawke’s Bay,,-39.42865541307646,176.6869152144428
Manawat\u016b-Whanganui,,-39.73098865419606,175.4555173139747
Wellington,,-41.07259426632601,175.4323683274915
Marlborough,,-41.60629728142014,173.5788158683521
Tasman,,-41.29151546136643,172.6057092903673
West Coast,,-42.51012415627857,171.3135886923324
Caterbury,,-43.71336357885355,171.3277839139198
Otago,,-45.16479441088008,169.6551727387001
Southland,,-45.92322551656932,168.1062023275522<\/p>\n\n\n\n

Back to Datawrapper<\/h4>\n\n\n\n

I tested the above lat\/Longs and they come out fine. Here is the link: <\/p>\n\n\n\n

HOVER OVER SYMBOLS ON MAP TO GET METADATA<\/span><\/strong>, ZOOM IN AS REQUIRED<\/span><\/strong><\/p>\n\n\n\n