{"id":23,"date":"2017-11-24T15:06:05","date_gmt":"2017-11-24T22:06:05","guid":{"rendered":"https:\/\/blogs.ubc.ca\/quakeprep\/?page_id=23"},"modified":"2017-12-08T18:49:29","modified_gmt":"2017-12-09T01:49:29","slug":"methodology","status":"publish","type":"page","link":"https:\/\/blogs.ubc.ca\/quakeprep\/methodology\/","title":{"rendered":"Methodology"},"content":{"rendered":"<p><span style=\"text-decoration: underline;\"><strong>Simple overlay of layers<\/strong><\/span><\/p>\n<p>The first step in this process was to obtain the surficial geology polygon from the GSC depicted <strong>Figure 1<\/strong>. Next we clipped the city boundary to our geology polygon in order to focus on our area of study as demonstrated in <strong>Figure 2<\/strong>. Through the symbology option we were able to divide the categories into the three main groups of rocks found in the Lower Mainland. Through the usage of dark\/light green we were able to highlight the stable (ie: safe) areas and pink\/red unstable (ie: dangerous) areas, this is shown in <strong>Figure 3<\/strong>.<\/p>\n<figure id=\"attachment_84\" aria-describedby=\"caption-attachment-84\" style=\"width: 271px\" class=\"wp-caption alignleft\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-84 \" src=\"https:\/\/blogs.ubc.ca\/quakeprep\/files\/2017\/12\/Figure-1-300x142.png\" alt=\"\" width=\"271\" height=\"133\" \/><figcaption id=\"caption-attachment-84\" class=\"wp-caption-text\">Figure 1<\/figcaption><\/figure>\n<figure id=\"attachment_85\" aria-describedby=\"caption-attachment-85\" style=\"width: 187px\" class=\"wp-caption alignleft\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-85\" src=\"https:\/\/blogs.ubc.ca\/quakeprep\/files\/2017\/12\/Figure-2-300x250.png\" alt=\"\" width=\"187\" height=\"157\" srcset=\"https:\/\/blogs.ubc.ca\/quakeprep\/files\/2017\/12\/Figure-2-300x250.png 300w, https:\/\/blogs.ubc.ca\/quakeprep\/files\/2017\/12\/Figure-2-552x461.png 552w, https:\/\/blogs.ubc.ca\/quakeprep\/files\/2017\/12\/Figure-2.png 628w\" sizes=\"auto, (max-width: 187px) 100vw, 187px\" \/><figcaption id=\"caption-attachment-85\" class=\"wp-caption-text\">Figure 2<\/figcaption><\/figure>\n<figure id=\"attachment_86\" aria-describedby=\"caption-attachment-86\" style=\"width: 172px\" class=\"wp-caption alignleft\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-86\" src=\"https:\/\/blogs.ubc.ca\/quakeprep\/files\/2017\/12\/Figure-3-300x263.png\" alt=\"\" width=\"172\" height=\"152\" srcset=\"https:\/\/blogs.ubc.ca\/quakeprep\/files\/2017\/12\/Figure-3-300x263.png 300w, https:\/\/blogs.ubc.ca\/quakeprep\/files\/2017\/12\/Figure-3-552x485.png 552w, https:\/\/blogs.ubc.ca\/quakeprep\/files\/2017\/12\/Figure-3.png 656w\" sizes=\"auto, (max-width: 172px) 100vw, 172px\" \/><figcaption id=\"caption-attachment-86\" class=\"wp-caption-text\">Figure 3<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<div class=\"mceTemp\" style=\"text-align: center;\"><\/div>\n<figure id=\"attachment_87\" aria-describedby=\"caption-attachment-87\" style=\"width: 454px\" class=\"wp-caption alignright\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-87\" src=\"https:\/\/blogs.ubc.ca\/quakeprep\/files\/2017\/12\/Figure-4-300x272.png\" alt=\"GeologyMap_hubsdanger\" width=\"454\" height=\"412\" srcset=\"https:\/\/blogs.ubc.ca\/quakeprep\/files\/2017\/12\/Figure-4-300x272.png 300w, https:\/\/blogs.ubc.ca\/quakeprep\/files\/2017\/12\/Figure-4.png 478w\" sizes=\"auto, (max-width: 454px) 100vw, 454px\" \/><figcaption id=\"caption-attachment-87\" class=\"wp-caption-text\">Figure 4<\/figcaption><\/figure>\n<p>After creating our three preliminary maps, we added the safety hubs as point features. In order to make sure we included all of the safety hubs we checked the ones listed on the City of Vancouver website and then proceeded to manually add the ones that were missing. We then manually selected safety hubs which were lying directly on the unsafe areas as well as the ones in the near proximity of said area as depicted in\u00a0<strong>Figure 4.\u00a0<\/strong>The safety hubs in potential danger are represented as blue asterisks while the safety hubs in immediate danger are depicted as yellow\u00a0asterisks, the road network was included for reference. By analyzing the maps created, we are able to verify that there are in fact safety hubs that lie within and near zones of danger. After this initial study we can confidently ascertain that there are at some safety hubs that need to be relocated in order to ensure the safety of the community.<\/p>\n<p><a href=\"https:\/\/blogs.ubc.ca\/quakeprep\/files\/2017\/12\/GeologyMap_hubsdanger.pdf\">GeologyMap_hubsdanger<\/a>\u00a0&#8211;\u00a0<em>(<\/em><em>For a detailed, high definition image of Figure 4, please click on this hyperlink)<\/em><\/p>\n<p><span style=\"text-decoration: underline;\"><strong>Population Density<\/strong><\/span><\/p>\n<p>In order to take into consideration the population density we obtained the Dissemination Area (DA) and Census Tract (CT) data from Statistics Canada. By dissecting this data were able to look at how exactly the population is distributed in the city. Additionally, this allowed us to better understand which neighbourhoods need new safety hubs as well as to where we should suggest the relocation of already existing ones.\u00a0<strong>Figure 5\u00a0<\/strong>depicts the city of Vancouver arranged by DA&#8217;s while\u00a0<strong>Figure 6\u00a0<\/strong>divides them by CT&#8217;s.\u00a0 Under the option &#8216;Symbology&#8217; we chose &#8216;Quantities&#8217;\u00a0 and opted to show the &#8220;Population Values&#8221;, without normalization,<\/p>\n<p><a href=\"https:\/\/blogs.ubc.ca\/quakeprep\/files\/2017\/12\/CTpoprep.pdf\">CTpoprep<\/a> <a href=\"https:\/\/blogs.ubc.ca\/quakeprep\/files\/2017\/12\/DApoprep.pdf\">DApoprep<\/a>\u00a0&#8211;\u00a0<em>(<\/em><em>For a detailed, high definition image of Figure 5 &amp; 6, please click on this hyperlink)<\/em><\/p>\n<figure id=\"attachment_98\" aria-describedby=\"caption-attachment-98\" style=\"width: 313px\" class=\"wp-caption alignleft\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-98 \" src=\"https:\/\/blogs.ubc.ca\/quakeprep\/files\/2017\/12\/Figure-5-300x262.png\" alt=\"\" width=\"313\" height=\"275\" \/><figcaption id=\"caption-attachment-98\" class=\"wp-caption-text\">Figure 5<\/figcaption><\/figure>\n<figure id=\"attachment_99\" aria-describedby=\"caption-attachment-99\" style=\"width: 307px\" class=\"wp-caption alignleft\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-99 \" src=\"https:\/\/blogs.ubc.ca\/quakeprep\/files\/2017\/12\/Figure-6-300x259.png\" alt=\"\" width=\"307\" height=\"267\" \/><figcaption id=\"caption-attachment-99\" class=\"wp-caption-text\">Figure 6<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>we did this in order to show the truest numbers available to us. We then chose a graduated colour scheme so that we could show the distribution of the population. In the case of the DA map\u00a0<strong>Figure 5<\/strong>, we decided to use &#8220;Natural Breaks&#8221; because it appears to give a more realistic representation of the DA values. Additionally, DA&#8217;s are smaller in terms of area and population numbers when compared to CT&#8217;s, this explains why &#8220;Equal Breaks&#8221; have several empty classes. On the other hand, we were able to use &#8220;Equal Breaks&#8221; for our CT map due to the fact that they&#8217;re larger in area and population numbers. This way, we were able to break these numbers into five equal classes as seen in\u00a0<strong>Figure 6.<\/strong> Both of these figures also include schools as point features due to their proximity to already established safety hubs and more importantly for their seismically sound infrastructure, we feel that these facilities should be proposed as new safety hubs. By studying the population distribution of the city of Vancouver through both CT and DA data we can further verify that one hub per neighbourhood may not be enough to provide support for everyone in need if a large scale magnitude earthquake were to occur.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline;\"><strong>Network Analysis<\/strong><\/span><\/p>\n<p><strong>Map 1\u00a0<\/strong><\/p>\n<p>The next step we took was to create a network analysis in order to produce our first map.<\/p>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">In ArcCatalog, we first created a new feature dataset, then created a new network dataset, where we included the DMTI roads (this road data is the best to be using for network analysis). We then built the network we planned to use for this part of the project.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">In ArcMap, we opened the Network Analysis wizard in the Table of Contents, added the CT data polygon and converted it into a point feature, more specifically centroids for the analysis. A spatial join between the polygon and the centroid point features was made so that population values could be used in later analysis. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">We then loaded the community centres layer (existing safety hubs). The network analysis gives us the junctions of the roads and the road edges layers, which we then excluded from our analysis because we just needed the road network. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Next, we opened the network analyst to the network analyst wizard toolbox and selected \u201cLocation-Allocation\u201d tool. <\/span>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Input \u2018Safety Hubs\u2019 into \u2018Facilities\u2019<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Input \u2018CT Join\u2019 into \u2018Demand Points\u2019<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">In \u201cLocation-Allocation Properties\u201d \u2192 advanced settings <\/span>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Problem type: Maximize Attendance<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Facilities to choose: 27<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Impedance cutoff: 6500 (this was value was calculated by taking the lowest value of the \u2018green\u2019 CT legend values to the highest value of the \u2018brown\u2019 CT legend values to get a reasonable number. The city of Vancouver does not specify how many people each existing hub is supposed to be able to support in the event of a disaster). <\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Produce map as shown in the results.<\/span><\/li>\n<\/ol>\n<p>We then set forth to creating our second map.\u00a0<span style=\"font-weight: 400;\">This part of the analysis considers the worst-case scenario, where the 7 hubs in dangerous areas are identified and removed from the analysis. <\/span><\/p>\n<p><strong>Map 2\u00a0<\/strong><\/p>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Remove the disaster hubs that are in danger (these were outlined in Figure 1 showing the geology and the safety hubs of the city). <\/span>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Hubs in Danger (in yellow) include: False Creek, Killarney, Roundhouse, Trout Lake and Creekside. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Hubs in potential danger (in blue) include: Hastings and West Point Grey.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">These 7 hubs were removed by editing these features and deleting them from the data table, therefore excluding them from our analysis. <\/span><\/li>\n<\/ol>\n<\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Then, we reopened the \u201cLocation-Allocation Properties\u201d window, keeping our inputs the same, but changing the advanced settings to the following values:<\/span>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Input \u2018Safety Hubs\u2019 into \u2018Facilities\u2019<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Input \u2018CT Join\u2019 into \u2018Demand Points\u2019<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">In \u201cLocation-Allocation Properties\u201d \u2192 advanced settings <\/span>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Problem type: Maximize Attendance<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Facilities to choose: 20<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Impedance cutoff: 6500.<\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Re-run Network Analysis with the new 20 hubs instead of the original 27<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Produce map.<\/span><\/li>\n<\/ol>\n<p>Our final step was to create our third map in which we looked at schools as potential new locations because of the Seismic Upgrade Program they went through.<\/p>\n<p><strong>Map 3\u00a0<\/strong><\/p>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">A buffer of 750m was created around the Disaster Hubs to see which schools are closest to the already-existing hub. <\/span>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">We initially thought about considering the area of the school, attempting to find the biggest ones in terms of area to suggest those as hubs, but unfortunately our schools layer did not have this information, which explains why we considered the idea of having a buffer set up. <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Buffers (750 m) to the left, schools in the entire city to the right.<\/span><\/li>\n<\/ol>\n<\/li>\n<li><span style=\"font-weight: 400;\">We intersected the Schools with the buffers to determine which schools lie within those 750 m in the proximity of the Disaster Hubs.<\/span>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">This way we were able to select our potential locations for new hubs (once again, assuming that the current ones may not be enough to support the entire population of the neighborhoods and to compensate for the ones in close to\/in danger areas). <\/span><\/li>\n<\/ol>\n<\/li>\n<li><span style=\"font-weight: 400;\">We then added this layer onto the map where we set up the Network dataset.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">We then ran a repeat Network Analysis for the Disaster Hubs and Schools (which are our new potential locations) \u00a0with respect to the population in the centroids. <\/span>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u201cLocation-Allocation Properties\u201d window, keeping our inputs the same, but changing the advanced settings to the following values:<\/span>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Input \u2018Safety Hubs\u2019 into \u2018Facilities\u2019<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Input \u2018CT Join\u2019 into \u2018Demand Points\u2019<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">In \u201cLocation-Allocation Properties\u201d \u2192 advanced settings <\/span>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Problem type: Maximize Attendance<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Facilities to choose: 73 (because of addition of 53 schools within the buffers). <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Impedance cutoff: 6500.<\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n<li>Produce map<\/li>\n<\/ol>\n<figure id=\"attachment_124\" aria-describedby=\"caption-attachment-124\" style=\"width: 202px\" class=\"wp-caption alignleft\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-124 \" src=\"https:\/\/blogs.ubc.ca\/quakeprep\/files\/2017\/12\/Figure-7-300x246.png\" alt=\"\" width=\"202\" height=\"167\" srcset=\"https:\/\/blogs.ubc.ca\/quakeprep\/files\/2017\/12\/Figure-7-300x246.png 300w, https:\/\/blogs.ubc.ca\/quakeprep\/files\/2017\/12\/Figure-7-768x630.png 768w, https:\/\/blogs.ubc.ca\/quakeprep\/files\/2017\/12\/Figure-7-552x453.png 552w, https:\/\/blogs.ubc.ca\/quakeprep\/files\/2017\/12\/Figure-7.png 870w\" sizes=\"auto, (max-width: 202px) 100vw, 202px\" \/><figcaption id=\"caption-attachment-124\" class=\"wp-caption-text\">Figure 7<\/figcaption><\/figure>\n<figure id=\"attachment_125\" aria-describedby=\"caption-attachment-125\" style=\"width: 194px\" class=\"wp-caption alignleft\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-125 \" src=\"https:\/\/blogs.ubc.ca\/quakeprep\/files\/2017\/12\/Figure-8-300x256.png\" alt=\"\" width=\"194\" height=\"167\" \/><figcaption id=\"caption-attachment-125\" class=\"wp-caption-text\">Figure 8<\/figcaption><\/figure>\n<figure id=\"attachment_128\" aria-describedby=\"caption-attachment-128\" style=\"width: 198px\" class=\"wp-caption alignleft\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-128 \" src=\"https:\/\/blogs.ubc.ca\/quakeprep\/files\/2017\/12\/Figure-9-300x251.png\" alt=\"\" width=\"198\" height=\"167\" srcset=\"https:\/\/blogs.ubc.ca\/quakeprep\/files\/2017\/12\/Figure-9-300x251.png 300w, https:\/\/blogs.ubc.ca\/quakeprep\/files\/2017\/12\/Figure-9-768x643.png 768w, https:\/\/blogs.ubc.ca\/quakeprep\/files\/2017\/12\/Figure-9-552x462.png 552w, https:\/\/blogs.ubc.ca\/quakeprep\/files\/2017\/12\/Figure-9.png 898w\" sizes=\"auto, (max-width: 198px) 100vw, 198px\" \/><figcaption id=\"caption-attachment-128\" class=\"wp-caption-text\">Figure 9<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p class=\"post-excerpt\">Simple overlay of layers The first step in this process was to obtain the surficial geology polygon from the GSC&#8230;<\/p>\n","protected":false},"author":39295,"featured_media":0,"parent":0,"menu_order":3,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-23","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/blogs.ubc.ca\/quakeprep\/wp-json\/wp\/v2\/pages\/23","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.ubc.ca\/quakeprep\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blogs.ubc.ca\/quakeprep\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.ubc.ca\/quakeprep\/wp-json\/wp\/v2\/users\/39295"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.ubc.ca\/quakeprep\/wp-json\/wp\/v2\/comments?post=23"}],"version-history":[{"count":17,"href":"https:\/\/blogs.ubc.ca\/quakeprep\/wp-json\/wp\/v2\/pages\/23\/revisions"}],"predecessor-version":[{"id":168,"href":"https:\/\/blogs.ubc.ca\/quakeprep\/wp-json\/wp\/v2\/pages\/23\/revisions\/168"}],"wp:attachment":[{"href":"https:\/\/blogs.ubc.ca\/quakeprep\/wp-json\/wp\/v2\/media?parent=23"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}