[Qgis-user] Spatial Join

[Jonathan Moules]

Thanks for the replies.
  Doing the analysis in a database isn't something I considered before; for
one thing all our data is in Oracle.

However, as a more generic comment, my issue with doing it in the DB is
that it requires using bespoke SQL - I'm a fan of GUI's for one-off tasks
as they're much easier to learn, more intuitive, and faster. It also allows
for a more integrated workflow if everything is done in a single
application.

But for a repeating task, SQL would be an excellent idea and I'll certainly
bear it in mind for the future.

So I am happy that using 'sum' to produce a count column then adding that
> up will give you the answer you are looking for.

In that case maybe it should be renamed to "count" as it certainly doesn't
seem to be "sum"ing. But I can't actually see the output to form an opinion
because it always crashes for me.

Kind Regards,
Jonathan


On 9 August 2013 08:14, Goyo <goyodiaz at gmail.com> wrote:

> 2013/8/8 Jonathan Moules <jonathanmoules at warwickshire.gov.uk>:
>
> > Also - surely "sum" is different from "count"? That's why I didn't use
> that
> > in the first place.
>
> I think the count field is automatically added to te resulting table.
>
> I also agree with Spencer in that most of the time I find using a db
> and SQL more convenient for spatial analysis --besides a more
> organized way to store my data. Using spatialite with QGIS is really
> esay and you can import/export data from/to most common formats.
>
> Regards
>
> Goyo
>

-- 
This transmission is intended for the named addressee(s) only and may 
contain sensitive or protectively marked material up to RESTRICTED and 
should be handled accordingly. Unless you are the named addressee (or 
authorised to receive it for the addressee) you may not copy or use it, or 
disclose it to anyone else. If you have received this transmission in error 
please notify the sender immediately. All email traffic sent to or from us, 
including without limitation all GCSX traffic, may be subject to recording 
and/or monitoring in accordance with relevant legislation.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20130809/df2c76a2/attachment.html>