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-to-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**** > > *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