<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<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;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@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="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">I am trying to copy points with their attributes from one layer to another (actually one geopackage file to another), the select is quick, couple of mins, bearing in mind there are 800,000 points but when pasting into the new empty geopackage
file it is extremely slow. Less than 10% of the points need to be pasted but it was taking 40mins before I stopped it and I had no idea how much longer it would take. There was a hint that it may have done about 30,000 in 40mins.<o:p></o:p></p>
<p class="MsoNormal">Is there another way to do this, I have also tried switching the selection and deleting the other 90% but this too is very slow and don’t see the end.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-GB"><img width="76" height="70" style="width:.7916in;height:.7291in" id="x_Picture_x0020_1" src="cid:image001.png@01D88FBF.49746540"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;mso-fareast-language:EN-GB"><img width="183" height="8" style="width:1.9027in;height:.0833in" id="x_Picture_x0020_20" src="cid:image002.png@01D88FBF.49746540"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;mso-fareast-language:EN-GB">Dr Michael Dodd</span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#1E4B9B;mso-fareast-language:EN-GB"> (iSpot Curator)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#1E4B9B;mso-fareast-language:EN-GB">Faculty of Science Technology, Engineering and Mathematics (STEM),
</span><span style="mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#1E4B9B;mso-fareast-language:EN-GB">The Open University, Walton Hall, Milton Keynes, MK7 6AA<br>
</span><b><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#1D4B9B;mso-fareast-language:EN-GB">+44 (0) 1908 652501</span></b><b><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#1E4B9B;mso-fareast-language:EN-GB"> |
</span></b><b><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#2F5496;mso-fareast-language:EN-GB"><a href="mailto:Michael.Dodd@open.ac.uk"><span style="color:#0563C1">Michael.Dodd@open.ac.uk</span></a></span></b><b><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#1E4B9B;mso-fareast-language:EN-GB">
| <u>www.</u></span></b><b><u><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#1D4B9B;mso-fareast-language:EN-GB"><a href="http://www.open.ac.uk/"><span style="color:#1D4B9B">open.ac.uk</span></a></span></u></b><span style="mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#00B050;mso-fareast-language:EN-GB">Research groups:</span></b><span style="mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#1E4B9B;mso-fareast-language:EN-GB">Citizen Science and AI:
<a href="https://citsci.kmi.open.ac.uk/"><span style="color:blue">https://citsci.kmi.open.ac.uk/</span></a>
</span><span style="mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#1E4B9B;mso-fareast-language:EN-GB">Environment, Earth & Ecosystem Sciences:
<a href="https://www.open.ac.uk/stem/environment-earth-ecosystem-sciences/research/ecosystems">
<span style="color:blue">https://www.open.ac.uk/stem/environment-earth-ecosystem-sciences/research/ecosystems</span></a>
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;color:#2F5496;mso-fareast-language:EN-GB">Floodplain meadows partnership</span><span style="mso-fareast-language:EN-GB">
</span><span style="font-size:9.0pt;color:blue;mso-fareast-language:EN-GB"><a href="https://www.floodplainmeadows.org.uk/"><span style="color:blue">https://www.floodplainmeadows.org.uk/</span></a></span><span style="mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#1E4B9B;mso-fareast-language:EN-GB"> </span></b><span style="mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#00B050;mso-fareast-language:EN-GB">Selected examples of public engagement / citizen science / teaching activity / projects:</span></b><span style="mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#002060;mso-fareast-language:EN-GB">Article:</span></b><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#00B050;mso-fareast-language:EN-GB">
</span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#002060;mso-fareast-language:EN-GB">iSpot’s 12<sup>
</sup>years old! Find out what we are doing to celebrate here:</span><b><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#00B050;mso-fareast-language:EN-GB">
</span></b><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#00B050;mso-fareast-language:EN-GB"><a href="https://www.open.edu/openlearn/nature-environment/creative-climate/ispot-your-place-share-nature"><span style="color:blue">https://www.open.edu/openlearn/nature-environment/creative-climate/ispot-your-place-share-nature</span></a>
</span><span style="mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#002060;mso-fareast-language:EN-GB">Free Course:
</span></b><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#002060;mso-fareast-language:EN-GB">Citizen Science and Global Biodiversity:</span><span style="mso-fareast-language:EN-GB">
</span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#00B050;mso-fareast-language:EN-GB"><a href="https://www.open.edu/openlearn/science-maths-technology/citizen-science-and-global-biodiversity/content-section-overview?active-tab=description-tab"><span style="color:blue">https://www.open.edu/openlearn/science-maths-technology/citizen-science-and-global-biodiversity/content-section-overview?active-tab=description-tab</span></a>
</span><span style="mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#1E4B9B;mso-fareast-language:EN-GB"> </span></b><span style="mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#00B050;mso-fareast-language:EN-GB">Project Websites:</span></b><span style="mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#1E4B9B;mso-fareast-language:EN-GB">iSpot -
</span></b><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#002060;mso-fareast-language:EN-GB">your place to share nature</span><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#1E4B9B;mso-fareast-language:EN-GB">:
<u><a href="http://www.ispotnature.org/"><span style="color:#0563C1">www.ispotnature.org</span></a>
</u> </span><span style="mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#1E4B9B;mso-fareast-language:EN-GB">Treezilla –
</span></b><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#1E4B9B;mso-fareast-language:EN-GB">the Monster Map of trees:
<u><a href="http://www.treezilla.org/"><span style="color:#0563C1">www.treezilla.org</span></a></u></span><span style="mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#1E4B9B;mso-fareast-language:EN-GB"> </span><span style="mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#1E4B9B;mso-fareast-language:EN-GB">Cos4Cloud – Co-designed Citizen Observatories Services for the European Open Science Cloud):
</span></b><u><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:blue;mso-fareast-language:EN-GB"><a href="http://www.cos4cloud-eosc.eu/"><span style="color:blue">www.cos4cloud-eosc.eu/</span></a></span></u><span style="mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#1E4B9B;mso-fareast-language:EN-GB">DECIDE – Delivering Enhanced Biodiversity Information with Adaptive Citizen Science and Intelligent Digital Engagements:
<a href="http://www.ceh.ac.uk/our-science/projects/decide"><span style="color:blue">www.ceh.ac.uk/our-science/projects/decide</span></a>
</span></b><span style="mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#1E4B9B;mso-fareast-language:EN-GB">X:Pollination – cross pollinating ideas, methods and technologies for pollinator citizen science:
<a href="https://xpollination.org/about/"><span style="color:blue">https://xpollination.org/about/</span></a>
</span></b><span style="mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>