<div dir="ltr">SpatialLite is built into QGIS :) <div><br></div><div>I was going to write a query for you but seems I did it in the past :) <a href="http://gis.stackexchange.com/questions/44526/stintersects-update-field-to-give-me-count-of-points-in-polygon">http://gis.stackexchange.com/questions/44526/stintersects-update-field-to-give-me-count-of-points-in-polygon</a></div>
<div><br></div><div>Just change <span style="color:black;font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,serif;background-color:rgb(238,238,238);font-size:12px;line-height:18px">STContains to </span><span style="color:black;font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,serif;background-color:rgb(238,238,238);font-size:12px;line-height:18px">STIntersects</span></div>
<div><span style="color:black;font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,serif;background-color:rgb(238,238,238);font-size:12px;line-height:18px"><br>
</span></div><div><span style="color:black;font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,serif;background-color:rgb(238,238,238);font-size:12px;line-height:18px">- Nathan</span></div>
</div><div class="gmail_extra"><br><br><div class="gmail_quote">On Tue, Jul 30, 2013 at 10:01 PM, Steven Campbell <span dir="ltr"><<a href="mailto:s.campbell@poole.gov.uk" target="_blank">s.campbell@poole.gov.uk</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="EN-GB" link="blue" vlink="purple"><div><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#0070c0">Having no SpatialLite or PostGIS I will give it a try in SQLSpatial – I’ve dug out the OGC Methods and will see if one of those can help me!<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#0070c0"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#0070c0">Thanks<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#0070c0"><u></u> <u></u></span></p><div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Nathan Woodrow [mailto:<a href="mailto:madmanwoo@gmail.com" target="_blank">madmanwoo@gmail.com</a>] <br>
<b>Sent:</b> 30 July 2013 12:45</span></p><div><div class="h5"><br><b>To:</b> Steven Campbell<br><b>Cc:</b> qgis-user<br><b>Subject:</b> Re: [Qgis-user] Points on line query<u></u><u></u></div></div><p></p></div><div><div class="h5">
<p class="MsoNormal"><u></u> <u></u></p><div><p class="MsoNormal">If you can add them to something like SpatialIte it will be easier.<u></u><u></u></p><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">
- Nathan<u></u><u></u></p></div></div><div><p class="MsoNormal" style="margin-bottom:12.0pt"><u></u> <u></u></p><div><p class="MsoNormal">On Tue, Jul 30, 2013 at 9:44 PM, Steven Campbell <<a href="mailto:s.campbell@poole.gov.uk" target="_blank">s.campbell@poole.gov.uk</a>> wrote:<u></u><u></u></p>
<div><div><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#0070c0">I’ve just got two shapefiles in QGIS I’m afraid – nothing in a database, but I can add them to SQL....</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#0070c0"> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#0070c0">Steve</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#0070c0"> </span><u></u><u></u></p><div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Nathan Woodrow [mailto:<a href="mailto:madmanwoo@gmail.com" target="_blank">madmanwoo@gmail.com</a>] <br>
<b>Sent:</b> 30 July 2013 12:38<br><b>To:</b> Steven Campbell<br><b>Cc:</b> qgis-user<br><b>Subject:</b> Re: [Qgis-user] Points on line query</span><u></u><u></u></p></div><div><div><p class="MsoNormal"> <u></u><u></u></p>
<div><p class="MsoNormal">What type of dataset are you using. You can do this in Python in QGIS but a SQL query might be easier.<u></u><u></u></p><div><p class="MsoNormal"> <u></u><u></u></p></div><div><p class="MsoNormal">
- Nathan<u></u><u></u></p><div><div><p class="MsoNormal" style="margin-bottom:12.0pt"> <u></u><u></u></p><div><p class="MsoNormal">On Tue, Jul 30, 2013 at 9:34 PM, Steven Campbell <<a href="mailto:s.campbell@poole.gov.uk" target="_blank">s.campbell@poole.gov.uk</a>> wrote:<u></u><u></u></p>
<div><div><p class="MsoNormal"><span style="font-family:"Arial","sans-serif"">Hello</span><u></u><u></u></p><p class="MsoNormal"><span style="font-family:"Arial","sans-serif""> </span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"">Is there a way to calculate the total sum of points that intersect/overlap a particular line – so I can add a column to my line dataset that tells me x number of points intersect/overlap this particular line.</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif""> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-family:"Arial","sans-serif"">Thanks</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif""> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-family:"Arial","sans-serif"">Steve</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif""> </span><u></u><u></u></p><p class="MsoNormal"><span style="font-family:"Arial","sans-serif"">Steve Campbell</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"">GIS Manager</span><u></u><u></u></p><p class="MsoNormal"><span style="font-family:"Arial","sans-serif"">Corporate Strategy and Communications</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"">Borough of Poole | Civic Centre | Poole BH15 2RU</span><u></u><u></u></p><p class="MsoNormal"><span style="font-family:"Arial","sans-serif"">Tel: 01202 633 362</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-family:"Arial","sans-serif"">Email: <a href="mailto:s.campbell@poole.gov.uk" target="_blank">s.campbell@poole.gov.uk</a></span><u></u><u></u></p><p class="MsoNormal">
<span style="font-family:"Arial","sans-serif"">Website:<a href="http://www.boroughofpoole.com/" target="_blank">www.boroughofpoole.com</a></span><u></u><u></u></p><p class="MsoNormal"><b><i><span style="font-family:"Arial","sans-serif";color:#00b050">Think Green! Please Recycle</span></i></b><u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p></div></div><p class="MsoNormal" style="margin-bottom:12.0pt"><br>_______________________________________________<br>Qgis-user mailing list<br><a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><u></u><u></u></p></div><p class="MsoNormal"> <u></u><u></u></p></div></div></div></div></div>
</div></div></div></div><p class="MsoNormal"><u></u> <u></u></p></div></div></div></div></div></blockquote></div><br></div>