<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:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@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:Georgia;
panose-1:2 4 5 2 5 4 5 2 3 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.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-IE" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Hi,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">My suggestion would be to use PostgreSQL and PostGIS to store the points. As for the reprojections, just use additional geometry Columns
for this, Create x and y columns (your_geom_coll_1 or 2 below) and use<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">SELECT AddGeometryColumn (<i>your_schema</i>,<i>your_database</i>,
<i>new_geom_coll_name</i>, EPSG:<i>Your_CRS</i>,'POINT',2);<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">UPDATE
<i>your_table</i> SET <i>geom_coll_name</i>=st_setsrid(st_makepoint(<i>your_geom_col_1</i>,<i>your_geom_coll_2</i>),your_CRS);<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Also, run indexing of your geometry columns.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">CREATE INDEX
<i>your_index_name</i> ON <i>your_table</i> USING GIST (your_geometry_column);<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">You can use Queries/filters within QGIS to help carry out your edits, even with PostGIS 6 million points is going to be a lot vector
data to render, so keep rendering to a minimum.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Just a suggestion, it would be how I would deal with this.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Regards,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Richard McDonnell<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:13.5pt;font-family:"Calibri",sans-serif;color:black">-- </span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p></o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="0" style="width:184.3pt">
<tbody>
<tr>
<td width="100%" style="width:100.0%;padding:0cm 0cm 4.5pt 0cm">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="left" width="0" style="width:190.4pt;margin-left:6.75pt;margin-right:6.75pt">
<tbody>
<tr style="height:42.45pt">
<td style="padding:0cm 0cm 0cm 0cm;height:42.45pt"></td>
<td valign="top" style="padding:0cm 0cm 0cm 7.5pt;height:42.45pt">
<p class="MsoNormal" style="margin-bottom:12.0pt"><b><span style="font-size:11.5pt;font-family:"Helvetica",sans-serif;color:#E03127">Richard McDonnell</span></b><span style="font-size:7.5pt;font-family:"Helvetica",sans-serif;color:#006C85"><br>
</span><b><span style="font-size:8.5pt;font-family:"Helvetica",sans-serif;color:#006C85">GIS Specialist</span></b><span style="font-size:8.5pt;font-family:"Helvetica",sans-serif;color:#006C85"> | FRM Data Management</span><span style="font-size:7.5pt;font-family:"Helvetica",sans-serif;color:#006C85"><br>
<b>MSc Geographic Information Systems</b><o:p></o:p></span></p>
</td>
<td style="padding:7.5pt 0cm 0cm 7.5pt;height:42.45pt"></td>
</tr>
</tbody>
</table>
<div class="MsoNormal" align="center" style="text-align:center"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">
<hr size="2" width="100%" align="center">
</span></div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="50%" valign="top" style="width:50.0%;padding:0cm 4.5pt 0cm 0cm">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="0" style="width:194.2pt">
<tbody>
<tr style="height:14.15pt">
<td style="padding:0cm 2.25pt 0cm 0cm;height:14.15pt"></td>
<td style="padding:0cm 0cm 0cm 0cm;height:14.15pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Helvetica",sans-serif;color:#006C85">Email: <a href="mailto:richard.mcdonnell@opw.ie"><span style="color:#006C85">richard.mcdonnell@opw.ie</span></a></span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Helvetica",sans-serif;color:#1F497D;display:none"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="0" style="width:164.8pt">
<tbody>
<tr style="height:14.65pt">
<td style="padding:0cm 2.25pt 0cm 0cm;height:14.65pt"></td>
<td style="padding:0cm 0cm 0cm 0cm;height:14.65pt">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Helvetica",sans-serif;color:#006C85">Phone: + 353 (0) 1 647 6543</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Helvetica",sans-serif;color:#1F497D;display:none"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="0" style="width:183.4pt">
<tbody>
<tr style="height:14.25pt">
<td style="padding:0cm 3.75pt 0cm 0cm;height:14.25pt"></td>
<td width="238" style="width:178.85pt;padding:0cm 0cm 0cm 0cm;height:14.25pt">
<p class="MsoNormal" style="margin-bottom:3.75pt"><span style="font-size:7.5pt;font-family:"Helvetica",sans-serif;color:#006C85">Mobile: +353 (0) 87 688 5964</span><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p></o:p></span></p>
</td>
<td width="50%" valign="top" style="width:50.0%;padding:4.5pt 0cm 0cm 1.5pt"></td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;display:none"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellpadding="0">
<tbody>
<tr>
<td style="padding:0cm 3.75pt 0cm 0cm"></td>
<td style="padding:0cm 3.75pt 0cm 0cm"></td>
<td style="padding:0cm 3.75pt 0cm 0cm"></td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif"> Qgis-user <qgis-user-bounces@lists.osgeo.org>
<b>On Behalf Of </b>Falk Huettmann<br>
<b>Sent:</b> 07 September 2019 09:24<br>
<b>To:</b> qgis-user <qgis-user@lists.osgeo.org><br>
<b>Subject:</b> [Qgis-user] FH 3 questions (million points, metadata, projection bug); thanks<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">Dear Colleagues,<o:p></o:p></p>
<div>
<p class="MsoNormal">a few questions if I may:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">-I am doing 3 million points, overlays, reprojections and table edits, <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> and an expensive GIS package failed on us 'esrliy' (I like this word, in case it actually is one).<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> So we ran it in QGIS and the entire project saved; hooray! THANKS!!!!<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Anyways, how about we want to run 6 million points in QGIS ?<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> How to do it best ? Any advise ?<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">-we find a consistent bug in QGIS when using Mercator projection and with a 180 degree meridian.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Chukotka peninsula data do not show up; perhaps you know of a cure ?<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> I am happy to send you the shapefiles and grids to look at.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">-I love MetaEdit; well, except, I cannot find it in the PlugIns and the<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> website seems to be not supported anymore.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <a href="http://gis-lab.info/qa/metatools-eng.html">http://gis-lab.info/qa/metatools-eng.html</a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Any hints for ISO compliant XML metadata editor with QGIS ? QGIS needs it.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Thanks so much again; very best<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Falk Huettmann<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"><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">On Mon, Aug 26, 2019 at 9:43 AM Falk Huettmann <<a href="mailto:fhuettmann@alaska.edu">fhuettmann@alaska.edu</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal">Dear Kind Colleagues,<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">thanks, I have a similar question, but with an opposite aim:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">We have two points, <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">and want to connect them,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">but then, NOT with the most direct and shortest path.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Rather, with the most meaningful and considerate one.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Like,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">length is not to be penalized but other factors, habitats available, amount of pixels<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">underneath etc.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Perhaps even showing different scenarios (aka, many paths lead to Rome...) ?<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">The path can consist of more than a line, an area connection let's say.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">So in other words: the optimization is NOT done by short distance.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Would you have any ideas and suggestions on that ?<br>
<br>
Thanks so much for any input<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> Falk Huettmann <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"><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"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">On Mon, Aug 26, 2019 at 2:07 AM Chintan Advani <<a href="mailto:chintanadvani@gmail.com" target="_blank">chintanadvani@gmail.com</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<p class="MsoNormal">Hi guys,<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I have a shape file with set of points on a road network. I am trying to find the shortest distance among these points using the shortest path tool. I have tried using the distance matrix tool in QGIS but it gives eucledian distance between
these points whereas I am looking the path distance (based on road network). Can someone please suggest some tool or technique that can help me solve this problem?<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><br clear="all">
<o:p></o:p></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Georgia",serif">Thanks and Regards,</span><span style="font-size:9.5pt"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Georgia",serif;color:black">__________________________________________</span><span style="font-size:9.5pt"><o:p></o:p></span></p>
</div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Georgia",serif;color:black">Advani Chintan Sanjeev</span><span style="font-size:9.5pt"><o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Georgia",serif;color:black"> Research Scholar,</span><span style="font-size:9.5pt"><br>
</span><span style="font-size:9.5pt;font-family:"Georgia",serif;color:black"> Civil Engineering and Build Environment,</span><span style="font-size:9.5pt"><br>
</span><span style="font-size:9.5pt;font-family:"Georgia",serif;color:black"> Queensland University of Technology, </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Georgia",serif;color:black"> Brisbane-</span><span style="font-size:9.5pt;font-family:"Courier New";color:black">4000, Australia.</span><o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal">_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br>
List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">
https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">
https://lists.osgeo.org/mailman/listinfo/qgis-user</a><o:p></o:p></p>
</blockquote>
</div>
</div>
</blockquote>
</div>
</div>
</div>
<br /><br />Email Disclaimer: <a href="http://www.opw.ie/en/disclaimer/">http://www.opw.ie/en/disclaimer/</a>
</body>
</html>