That is something I did not know!
Thanks for the SQL I will give it a try Thanks again Steve From: Nathan Woodrow [mailto:madman...@gmail.com] Sent: 30 July 2013 13:07 To: Steven Campbell Cc: qgis-user Subject: Re: [Qgis-user] Points on line query SpatialLite is built into QGIS :) I was going to write a query for you but seems I did it in the past :) http://gis.stackexchange.com/questions/44526/stintersects-update-field-t o-give-me-count-of-points-in-polygon Just change STContains to STIntersects - Nathan On Tue, Jul 30, 2013 at 10:01 PM, Steven Campbell <s.campb...@poole.gov.uk> wrote: 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! Thanks From: Nathan Woodrow [mailto:madman...@gmail.com] Sent: 30 July 2013 12:45 To: Steven Campbell Cc: qgis-user Subject: Re: [Qgis-user] Points on line query If you can add them to something like SpatialIte it will be easier. - Nathan On Tue, Jul 30, 2013 at 9:44 PM, Steven Campbell <s.campb...@poole.gov.uk> wrote: I've just got two shapefiles in QGIS I'm afraid - nothing in a database, but I can add them to SQL.... Steve From: Nathan Woodrow [mailto:madman...@gmail.com] Sent: 30 July 2013 12:38 To: Steven Campbell Cc: qgis-user Subject: Re: [Qgis-user] Points on line query What type of dataset are you using. You can do this in Python in QGIS but a SQL query might be easier. - Nathan On Tue, Jul 30, 2013 at 9:34 PM, Steven Campbell <s.campb...@poole.gov.uk> wrote: Hello 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. Thanks Steve Steve Campbell GIS Manager Corporate Strategy and Communications Borough of Poole | Civic Centre | Poole BH15 2RU Tel: 01202 633 362 Email: s.campb...@poole.gov.uk Website:www.boroughofpoole.com <http://www.boroughofpoole.com/> Think Green! Please Recycle _______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user