[Qgis-user] Points on line query

[Nathan Woodrow]

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.campbell at 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:madmanwoo at 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.campbell at 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:madmanwoo at 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.campbell at 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.campbell at poole.gov.uk****
>
> Website:www.boroughofpoole.com****
>
> *Think Green! Please Recycle*****
>
>  ****
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user****
>
>  ****
>
> ** **
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20130730/e801f621/attachment.html>