<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0cm;
font-size:10.0pt;
font-family:"Courier New";}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
mso-fareast-language:EN-US;}
span.EmailStyle23
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-GB" link="#0563C1" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">I tried something rather similar to what you suggest however it did not work for the whole area, it was not clear why but on further investigation some of the tiles were missing from the dataset itself on the data suppliers website. I
have asked them to both sort out the missing data and to provide a single file so that people do not have to waste long periods trying to put the little tiles together.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">They have been “looking into” the request for a few days, no results yet other than asking me to complete a feedback form about how helpful the were, will resist comment for the moment.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="mso-fareast-language:EN-GB">From:</span></b><span lang="EN-US" style="mso-fareast-language:EN-GB"> Andrew Harfoot <ajph@geodata.soton.ac.uk>
<br>
<b>Sent:</b> Thursday, October 6, 2022 12:56 PM<br>
<b>To:</b> qgis-user@lists.osgeo.org<br>
<b>Cc:</b> Michael.Dodd <michael.dodd@open.ac.uk><br>
<b>Subject:</b> Re: [Qgis-user] large DEM not loading tiles correctly<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="mso-element:para-border-div;border:solid black 1.0pt;padding:1.0pt 4.0pt 1.0pt 4.0pt;background:#FFFFCC">
<p style="background:#FFFFCC;border:none;padding:0cm"><span style="font-family:"Arial",sans-serif;color:black">CAUTION: This mail comes from outside the University. Please consider this before opening attachments, clicking links, or acting on the content.
</span><span style="font-family:"Arial",sans-serif"><o:p></o:p></span></p>
</div>
<div>
<div>
<p class="MsoNormal">Hi Michael,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Here are some instructions to do exactly what you are asking that I recently wrote for someone else (you are not alone!):<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<div>
<p class="MsoNormal">The ESRI ASCII grid format is supported by QGIS, and will load as a raster if you drag an .asc file over the map canvas. The further complication with the gridded dataset is that it is split into 10km tiles rather than being a single national
layer, so needs to be merged before moving on to the next steps. This is fairly straightforward using the following steps:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">1. Unzip the downloaded data. You'll notice that the 10km tile files are also zipped, and each placed in a 100km square folder: hp\hp40_OST50GRID_20220506.zip<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">2. Move the zip files out of their 100km square folders to make it easier to process them all at once. This can be done through File Explorer by searching in the folder below the 100km square folders for *.zip<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><img width="606" height="178" style="width:6.3125in;height:1.8541in" id="Picture_x0020_1" src="cid:image001.png@01D8D99D.F7056B50"><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">You should get 2858 results. Select all of these files using Ctrl + A and then drag them into the data folder - they will be moved out of their individual 100km square folders<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">3. Unzip all the zip files. I don't think that the built in Windows zip functionality can do this in one go though. I use the open source 7zip software which allows a bunch of zip files to be selected in File Explorer and then from the
right click menu, 'Extract Here' can be chosen. You should now see a .asc file in the folder for each 10km grid square, eg: HP40.asc. This is the grid data.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">4. Merge the 10km tiles together. This is done in QGIS using the Merge tool from the Processing toolbox (or Raster > Miscellaneous > Merge...). In the Input layers section, click the ellipsis button to open the file selector, and use the
'Add File(s)...' button to add the .asc files (if you sort by file type you can select them as a block).<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><img width="482" height="405" style="width:5.0208in;height:4.2222in" id="Picture_x0020_2" src="cid:image002.png@01D8D99D.F7056B50"><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Fill out the rest of the Merge tool dialog like this:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><img width="482" height="792" style="width:5.0208in;height:8.25in" id="Picture_x0020_3" src="cid:image003.png@01D8D99D.F7056B50"><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Clicking Run will start the process, which may take some time, but on completion you should have a single national terrain dataset!<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Cheers,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Andy<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">On 28/09/2022 12:32, Michael.Dodd via Qgis-user wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<div style="border:solid #8D3970 1.0pt;padding:9.0pt 9.0pt 9.0pt 9.0pt">
<p class="MsoNormal" style="line-height:16.5pt;background:#F7F9FA"><strong><span style="font-size:10.5pt;font-family:"Calibri",sans-serif;color:#8D3970;mso-fareast-language:EN-GB">CAUTION:</span></strong><span style="font-size:10.5pt;color:#8D3970;mso-fareast-language:EN-GB">
This e-mail originated outside the University of Southampton. <o:p></o:p></span></p>
</div>
</div>
<div>
<p class="MsoNormal">I am trying to put together the 50m uk DEM e.g. <a href="https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.data.gov.uk%2Fdataset%2F835cf20a-8feb-4394-8b30-dcfe840ac13d%2Fos-terrain-50-dtm&data=05%7C01%7Cmichael.dodd%40open.ac.uk%7Cd3cdaad156b04d271ce908daa791b766%7C0e2ed45596af4100bed3a8e5fd981685%7C0%7C0%7C638006541534876923%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=LBCYq1vE5A3cHIN%2Bw0WEOcTlN9aSsWwBP7%2FsnqYy6tw%3D&reserved=0">
https://www.data.gov.uk/dataset/835cf20a-8feb-4394-8b30-dcfe840ac13d/os-terrain-50-dtm</a> but it often does not work. The data are supplied as thousands of small tiles that takes ages to unpack and put into a folder to get into qgis, however when you try
to load the tiles some work and others don’t and even the ones that do work and display fine sometimes don’t merge to form large tiles and sometimes will form virtual rasters but not merged files. Basically it is a mess. I suspect others have done this successfully
so any suggestions?<o:p></o:p></p>
<p class="MsoNormal">It is particularly odd that some of the tiles will merge and others won’t and that some won’t display if you ask it to load hundreds at a time but if you just add them in a few at a time then they will load and display (in addition to the
hundreds already loaded). This suggests various bugs assuming the original data are not in a whole variety of slightly different formats (should all be .asc)<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<p class="MsoNormal"><span style="mso-fareast-language:EN-GB"><br>
<br>
<o:p></o:p></span></p>
<pre>_______________________________________________<o:p></o:p></pre>
<pre>Qgis-user mailing list<o:p></o:p></pre>
<pre><a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><o:p></o:p></pre>
<pre>List info: <a href="https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fqgis-user&data=05%7C01%7Cmichael.dodd%40open.ac.uk%7Cd3cdaad156b04d271ce908daa791b766%7C0e2ed45596af4100bed3a8e5fd981685%7C0%7C0%7C638006541534876923%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=dIWwMx2TvGdBfJC55beUSNB1Qw1l454XqnLr5ooq3ZE%3D&reserved=0">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><o:p></o:p></pre>
<pre>Unsubscribe: <a href="https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fqgis-user&data=05%7C01%7Cmichael.dodd%40open.ac.uk%7Cd3cdaad156b04d271ce908daa791b766%7C0e2ed45596af4100bed3a8e5fd981685%7C0%7C0%7C638006541534876923%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=dIWwMx2TvGdBfJC55beUSNB1Qw1l454XqnLr5ooq3ZE%3D&reserved=0">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><o:p></o:p></pre>
</blockquote>
<p><o:p> </o:p></p>
<pre>-- <o:p></o:p></pre>
<pre>Andy Harfoot<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>Skype: gdi_ajph<o:p></o:p></pre>
<pre>Teams: <a href="mailto:ajph@soton.ac.uk">ajph@soton.ac.uk</a><o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>GeoData Institute<o:p></o:p></pre>
<pre>University of Southampton<o:p></o:p></pre>
<pre>Southampton<o:p></o:p></pre>
<pre>SO17 1BJ<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre><a href="https://eur01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.geodata.soton.ac.uk%2F&data=05%7C01%7Cmichael.dodd%40open.ac.uk%7Cd3cdaad156b04d271ce908daa791b766%7C0e2ed45596af4100bed3a8e5fd981685%7C0%7C0%7C638006541534876923%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=3LsGH6T8i%2BYhAWqXh4n4yxYERkKRQqaFnMc6D2Xr7i8%3D&reserved=0">www.geodata.soton.ac.uk</a><o:p></o:p></pre>
</div>
</div>
</body>
</html>