{"id":2523,"date":"2020-05-07T16:17:14","date_gmt":"2020-05-07T04:17:14","guid":{"rendered":"http:\/\/blogs.lincoln.ac.nz\/gis\/?p=2523"},"modified":"2020-05-07T16:17:14","modified_gmt":"2020-05-07T04:17:14","slug":"turning-the-tables-on-tourism","status":"publish","type":"post","link":"https:\/\/blogs.lincoln.ac.nz\/gis\/turning-the-tables-on-tourism\/","title":{"rendered":"Turning the Tables on Tourism"},"content":{"rendered":"<p><em>This post covers how a map of tourist spending for 2019 was done.\u00a0 Table joins were a\u00a0critical part of this.\u00a0 We also look at the mapping process and, more specifically, how to add pie charts to your map.<\/em><\/p>\n<p>Tourism,\u00a0as<a href=\"https:\/\/www.tourismnewzealand.com\/about\/about-the-tourism-industry\/\" target=\"_blank\" rel=\"noopener noreferrer\"> the most significant industry in terms of\u00a0foreign exchange earnings<\/a>, is one of the major sectors of the New Zealand economy. Lincoln has a good history of contributing positively to the cause.\u00a0 Part of that means that every year, we develop maps that aim to show the impact of international and domestic tourism in relation to regional GDP and how they change over time\u00a0 In this post, we&#8217;ll cover the process from go to whoa of how those maps come about.\u00a0 But first here\u00a0an example.<\/p>\n<p>Here&#8217;s the map from 2017 to give you a sense of what the maps do &#8211; we normally do the whole country but that year we only mapped the South Island:<\/p>\n<p><a href=\"https:\/\/d-blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/2017TourismGDPMapUpdate.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2525\" src=\"https:\/\/d-blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/2017TourismGDPMapUpdate.jpg\" alt=\"\" width=\"1654\" height=\"2338\" srcset=\"https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/2017TourismGDPMapUpdate.jpg 1654w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/2017TourismGDPMapUpdate-212x300.jpg 212w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/2017TourismGDPMapUpdate-724x1024.jpg 724w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/2017TourismGDPMapUpdate-768x1086.jpg 768w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/2017TourismGDPMapUpdate-1087x1536.jpg 1087w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/2017TourismGDPMapUpdate-1449x2048.jpg 1449w\" sizes=\"auto, (max-width: 1654px) 100vw, 1654px\" \/><\/a><\/p>\n<p>Two primary things we&#8217;re trying to show in this map:<\/p>\n<ul>\n<li>The % of regional GDP that tourism contributes<\/li>\n<li>The split between domestic and international spending as a proportion and the relative size of the spend by region<\/li>\n<\/ul>\n<p>The first is shown by the graded colours of the regions and the second is shown by the pie charts, which are scaled in size by the magnitude of the tourism spend in that region.\u00a0 While it&#8217;s difficult to judge exactly what the total spend is, the size of the pie charts helps to communicate a sense of the relative differences (i.e. compare Canterbury with the West Coast).\u00a0 So hopefully that all makes sense (if it doesn&#8217;t, I haven&#8217;t done my job&#8230;)<\/p>\n<p>What I&#8217;d like to do now is go though how we got to this final stage for data up to March 2019.<\/p>\n<p>As a usual starting point for this mapping, David Simmons sent me some spreadsheets which he had gotten from MBIE and Stats NZ.\u00a0 Here&#8217;s the spreadsheet that gives usthe data on gross domestic product by region:<\/p>\n<p><a href=\"https:\/\/d-blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/GDPSpreadsheet.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2528\" src=\"https:\/\/d-blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/GDPSpreadsheet.jpg\" alt=\"\" width=\"792\" height=\"978\" srcset=\"https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/GDPSpreadsheet.jpg 792w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/GDPSpreadsheet-243x300.jpg 243w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/GDPSpreadsheet-768x948.jpg 768w\" sizes=\"auto, (max-width: 792px) 100vw, 792px\" \/><\/a><\/p>\n<p>The second spreadsheet from MBIE breaks the tourism spend down by regions as well:<\/p>\n<p><a href=\"https:\/\/d-blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/SpendSpreadsheet.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2529\" src=\"https:\/\/d-blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/SpendSpreadsheet.jpg\" alt=\"\" width=\"1035\" height=\"893\" srcset=\"https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/SpendSpreadsheet.jpg 1035w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/SpendSpreadsheet-300x259.jpg 300w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/SpendSpreadsheet-1024x884.jpg 1024w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/SpendSpreadsheet-768x663.jpg 768w\" sizes=\"auto, (max-width: 1035px) 100vw, 1035px\" \/><\/a>Great!\u00a0 I&#8217;ve got some data to work with now.\u00a0 But, how am I going to map this?\u00a0 What make these data spatial?\u00a0 How do I take a spreadsheet and map it?\u00a0 This brings us to, arguably, one of GIS&#8217;s more powerful tools &#8211; <a href=\"http:\/\/blogs.lincoln.ac.nz\/gis\/2013\/03\/10\/mapping-the-census\/\" target=\"_blank\" rel=\"noopener noreferrer\">table joins<\/a>.\u00a0 There are stacks of data out there in spreadsheets that can enrich spatial analysis, so long as we can link them to spatial data layers.\u00a0 In both these cases, the spatial information is in there as the region name.\u00a0 It&#8217;s not coordinates but the names relate to areas we all know and love.\u00a0 That should get us thinking about existing data that relates, like a layer of the regions:<\/p>\n<p><a href=\"https:\/\/d-blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Regions.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2530\" src=\"https:\/\/d-blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Regions.jpg\" alt=\"\" width=\"1477\" height=\"797\" srcset=\"https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Regions.jpg 1477w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Regions-300x162.jpg 300w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Regions-1024x553.jpg 1024w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Regions-768x414.jpg 768w\" sizes=\"auto, (max-width: 1477px) 100vw, 1477px\" \/><\/a>For the lastest version of these data, I went to the <a href=\"http:\/\/data.linz.govt.nz\" target=\"_blank\" rel=\"noopener noreferrer\">LINZ Data Service<\/a> and downloaded a copy.\u00a0 The key thing is that I&#8217;ve got an attribute that also has the region name so I should be able to link the spreadsheet to the layer.<\/p>\n<p>BUT &#8211; notice a slight difference: the spreadsheets list the region name but without &#8220;Region&#8221;, as the spatial layer does &#8211; minor inconvenience but not unsurmountable.<\/p>\n<p>ANTOHER BUT: on close inspection there is another issue &#8211; the GDP data combine Nelson and Tasman while the other data don&#8217;t.\u00a0 I&#8217;ve got no basis for knowing how to split up the two regions GDP values so I&#8217;ve got to combine the tourism spend amounts for these two regions and combine the two polygons on the map (the Merge tool in the ArcGIS Pro editing tab worked for this &#8211;\u00a0 I just had to select both and find the Merge tool in the window of often used tools:<\/p>\n<p><a href=\"https:\/\/d-blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Merge.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2531\" src=\"https:\/\/d-blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Merge.jpg\" alt=\"\" width=\"1044\" height=\"915\" srcset=\"https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Merge.jpg 1044w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Merge-300x263.jpg 300w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Merge-1024x897.jpg 1024w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Merge-768x673.jpg 768w\" sizes=\"auto, (max-width: 1044px) 100vw, 1044px\" \/><\/a>Next, I can think about joining the spreadsheets to my regions layer so I can get the values into the table for mapping.\u00a0 Table joins work off the idea that if there is a &#8220;common key&#8221; between two tables, they can be joined based on those values.\u00a0 This means there has to be a one-to-one match between the keys &#8211; case and text are important &#8211; they have to match.\u00a0 I&#8217;ve already mentioned the issue with the region names, but there are a few other formatting issues I need to sort out first.<\/p>\n<p>As they are, I could add the two spreadsheets to my map but they won&#8217;t play nicely with my layer just yet.\u00a0 The tables must be arranged in a few specific ways:<\/p>\n<ul>\n<li>The first row of any table must be the names of attributes<\/li>\n<li>Attribute names must have no spaces, start with a number, or have any special symbols<\/li>\n<li>No special formatting (e.g. cell colours, formulae, borders, etc)<\/li>\n<\/ul>\n<p>So I&#8217;ve set up a new sheet that will combine all the data into one, simplified table:<\/p>\n<p><a href=\"https:\/\/d-blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/MappingTable.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2532\" src=\"https:\/\/d-blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/MappingTable.jpg\" alt=\"\" width=\"1440\" height=\"641\" srcset=\"https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/MappingTable.jpg 1440w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/MappingTable-300x134.jpg 300w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/MappingTable-1024x456.jpg 1024w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/MappingTable-768x342.jpg 768w\" sizes=\"auto, (max-width: 1440px) 100vw, 1440px\" \/><\/a>I&#8217;ve just been copying and pasting here &#8211; the region names are there twice to allow me to make sure I&#8217;ve got the right data in the right place.\u00a0 The first three columns came straight out of my spatial layer&#8217;s attribute table so I know that they&#8217;ll match nicely.\u00a0 I&#8217;ve got my domestic and international spends, the total (so that I can scale the size of the circle), the total GDP and a value for the % of GDP for the tourism spend.\u00a0 Now I&#8217;ll do the join back in Pro.<\/p>\n<p>First, I&#8217;ll add the sheet to the map as a standalone table just like any other data using Add Data:<\/p>\n<p><a href=\"https:\/\/d-blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Table.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2533\" src=\"https:\/\/d-blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Table.jpg\" alt=\"\" width=\"472\" height=\"441\" srcset=\"https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Table.jpg 472w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Table-300x280.jpg 300w\" sizes=\"auto, (max-width: 472px) 100vw, 472px\" \/><\/a><\/p>\n<p>To do the join, I right-click on the layer name and go to Joins and Relates &gt; Add Join.\u00a0 This opens a new tool pane:<\/p>\n<p><a href=\"https:\/\/d-blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/JoinTool.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2534\" src=\"https:\/\/d-blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/JoinTool.jpg\" alt=\"\" width=\"436\" height=\"474\" srcset=\"https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/JoinTool.jpg 436w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/JoinTool-276x300.jpg 276w\" sizes=\"auto, (max-width: 436px) 100vw, 436px\" \/><\/a><\/p>\n<p>It picks up the spreadsheet table that&#8217;s on the map (truth be told, I don&#8217;t need to add it to the map &#8211; I can find it using the folder button).\u00a0 The Input Join Field is the attribute that has the common key with the Join Table.\u00a0 I could have used any one of three attributes but here I chose REGC2018_V field with has a unique number for each region.\u00a0 Why?\u00a0 That one&#8217;s less reliant on any text values Imay have worked with &#8211; it&#8217;s just a bit more reliable and less prone to any errors on my part.\u00a0 Clicking Run then joins up the spreadsheet table to the spatial layer&#8217;s table:<\/p>\n<p><a href=\"https:\/\/d-blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Joined.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2535\" src=\"https:\/\/d-blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Joined.jpg\" alt=\"\" width=\"1786\" height=\"607\" srcset=\"https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Joined.jpg 1786w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Joined-300x102.jpg 300w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Joined-1024x348.jpg 1024w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Joined-768x261.jpg 768w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Joined-1536x522.jpg 1536w\" sizes=\"auto, (max-width: 1786px) 100vw, 1786px\" \/><\/a>The four fields with blue headers are from my spatial layer &#8211; all the others are from the spreadsheet table.<\/p>\n<p>Almost done with this &#8211; but I need to recognise that this join is somewhat temporary.\u00a0 To make it permanent, I can just make of copy of this layer and they will be joined in perpetuity (right-click layer name &gt; Data &gt; Export Features).\u00a0 This now gives me a full-blooded layer to work with for mapping.<\/p>\n<p>As noted earlier, I want to show both % of GDP spend by region and also the breakdown of intentional and domestic tourists&#8217; spend, scale by the total magnitude of that spend.\u00a0\u00a0I&#8217;ll do that first<\/p>\n<p>For the %GDP spend, we used classes and colours that we&#8217;ve used in previous years &#8211; five classes (0 &#8211; 5, 5 &#8211; 10, 10 &#8211; 15, 15 &#8211; 20, &gt; 20) with specific colours &#8211; that makes it easier to compare maps from different years.\u00a0 These get set in the Symbology pane:<\/p>\n<p><a href=\"https:\/\/d-blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/GDPSymbols.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2536\" src=\"https:\/\/d-blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/GDPSymbols.jpg\" alt=\"\" width=\"1916\" height=\"784\" srcset=\"https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/GDPSymbols.jpg 1916w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/GDPSymbols-300x123.jpg 300w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/GDPSymbols-1024x419.jpg 1024w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/GDPSymbols-768x314.jpg 768w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/GDPSymbols-1536x629.jpg 1536w\" sizes=\"auto, (max-width: 1916px) 100vw, 1916px\" \/><\/a><\/p>\n<p>Next up is the pie charts &#8211; I&#8217;ve added a copy of the Regions layer to do this (I need one layer for each of the symbologies).\u00a0 To get a pie chart for this layer, I set the\u00a0Primary Symbology\u00a0to &#8220;Charts&#8221; and the Chart Type to &#8220;Pie&#8221; in the symbology pane:<\/p>\n<p><a href=\"https:\/\/d-blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Pie1.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2538\" src=\"https:\/\/d-blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Pie1.jpg\" alt=\"\" width=\"1438\" height=\"787\" srcset=\"https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Pie1.jpg 1438w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Pie1-300x164.jpg 300w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Pie1-1024x560.jpg 1024w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Pie1-768x420.jpg 768w\" sizes=\"auto, (max-width: 1438px) 100vw, 1438px\" \/><\/a>I&#8217;m not particularly happy with the haphazard look of the pie charts and they&#8217;re all the same size so two more tweaks are needed.\u00a0 First, in the Appearance section, set the Size Type to &#8220;Field&#8221; and the Field to &#8220;TotalSpend&#8221; (the total tourism spend in my attribute table &#8211; now pie chart size varies with the magnitude of the spend:<\/p>\n<p><a href=\"https:\/\/d-blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Pie2.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2539\" src=\"https:\/\/d-blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Pie2.jpg\" alt=\"\" width=\"1906\" height=\"744\" srcset=\"https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Pie2.jpg 1906w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Pie2-300x117.jpg 300w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Pie2-1024x400.jpg 1024w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Pie2-768x300.jpg 768w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Pie2-1536x600.jpg 1536w\" sizes=\"auto, (max-width: 1906px) 100vw, 1906px\" \/><\/a><\/p>\n<p>Notice how I&#8217;ve also got a new legend item that helps us interpret what the size means.<\/p>\n<p>Another tweak &#8211; in the Display Options, set the Orientation to &#8220;Clockwise&#8221; and then they all line up a bit more consistently to my liking:<\/p>\n<p><a href=\"https:\/\/d-blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Pie3.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2540\" src=\"https:\/\/d-blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Pie3.jpg\" alt=\"\" width=\"1439\" height=\"784\" srcset=\"https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Pie3.jpg 1439w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Pie3-300x163.jpg 300w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Pie3-1024x558.jpg 1024w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Pie3-768x418.jpg 768w\" sizes=\"auto, (max-width: 1439px) 100vw, 1439px\" \/><\/a>We&#8217;re almost done &#8211; and definitely done with the hardest bits of this map.\u00a0 After some more finalising (well, more like a few hours &#8211; it&#8217;s amazing how much time you spend getting maps to look &#8220;just right&#8221;) &#8211; this involved a lot of back and forth with David on how we wanted things to look.\u00a0 Here&#8217;s the finished product:<\/p>\n<p><a href=\"https:\/\/d-blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Final.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2541\" src=\"https:\/\/d-blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Final.jpg\" alt=\"\" width=\"670\" height=\"864\" srcset=\"https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Final.jpg 670w, https:\/\/blogs.lincoln.ac.nz\/gis\/wp-content\/uploads\/sites\/3\/2020\/05\/Final-233x300.jpg 233w\" sizes=\"auto, (max-width: 670px) 100vw, 670px\" \/><\/a><\/p>\n<p>You&#8217;ll notice that it looks a wee bit different from what we looked at earlier &#8211; when switching back and forth between a Map and a Layout, the sizes can change so there&#8217;s a lot of back-and-forth adjusting.\u00a0 This map debuted in one of David&#8217;s thought pieces that went to ministers and organisations like MBIE, DOC and Tourism NZ amongst others.\u00a0 I hope it helped.\u00a0 Hard to know what it will look like next year&#8230;<\/p>\n<p>So hopefully in this piece you&#8217;ve gotten to see how useful information hidden away in Excel spreadsheets can, under the right conditions, make their way onto maps for more visual presentations. It&#8217;s like setting free the spreadsheets&#8230;\u00a0 Table joins are a very powerful way of enriching mapping layers, one of <strong>the<\/strong> most useful techniques I know of.\u00a0 ( Another example\u00a0<a href=\"http:\/\/blogs.lincoln.ac.nz\/gis\/2018\/05\/25\/a-humble-table-join-saves-the-day\/\">here<\/a>)<\/p>\n<p>You&#8217;ve also gotten a peak behind a map making process that aimed to best present these data.\u00a0 I would say that we spent somewhere between four and five hours getting this together, helped by the fact that this was the fourth time we have taken these annual data and mapped them this way.<\/p>\n<p>Hope that was enlightening.<\/p>\n<p>C (with special thanks to David)    \t<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This post covers how a map of tourist spending for 2019 was done.\u00a0 Table joins were a\u00a0critical part of this.\u00a0 We also look at the mapping process and, more specifically, how to add pie charts to your map. Tourism,\u00a0as the most significant industry in terms of\u00a0foreign exchange earnings, is one of the major sectors of [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2523","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/blogs.lincoln.ac.nz\/gis\/wp-json\/wp\/v2\/posts\/2523","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.lincoln.ac.nz\/gis\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.lincoln.ac.nz\/gis\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.lincoln.ac.nz\/gis\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.lincoln.ac.nz\/gis\/wp-json\/wp\/v2\/comments?post=2523"}],"version-history":[{"count":0,"href":"https:\/\/blogs.lincoln.ac.nz\/gis\/wp-json\/wp\/v2\/posts\/2523\/revisions"}],"wp:attachment":[{"href":"https:\/\/blogs.lincoln.ac.nz\/gis\/wp-json\/wp\/v2\/media?parent=2523"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.lincoln.ac.nz\/gis\/wp-json\/wp\/v2\/categories?post=2523"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.lincoln.ac.nz\/gis\/wp-json\/wp\/v2\/tags?post=2523"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}