Hi,<div> (I seem to have lost the list).</div><div> </div><div>Yep, I'm on the weekly build from last week.</div><div><br></div><div>Unfortunately it seems I've managed to break "Join attributes by Location" too. It gets to 15% and then sits there for ages using 100% of a Core and reading from my HDD at 300MB a second. The shapefiles are 400kb and 5MB (though that one has 300MB of attributes). This happens repeatedly. Another ticket. :-)</div>
<div><br></div><div>Also - surely "sum" is different from "count"? That's why I didn't use that in the first place. Well, I did try "mean", but it broke with a Python error about data-types (makes sense I guess).</div>
<div><br></div><div>Jonathan</div><div><br></div><div><br></div><div><br></div><div><br><div class="gmail_quote">On 8 August 2013 15:27, Illya Santos <span dir="ltr"><<a href="mailto:illya.sparkes.santos@gmail.com" target="_blank">illya.sparkes.santos@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Jonathan, <div><br></div><div>Are you on a 1.8+ versoin of QGIS? I am assuming so.....</div><div><div><br>
</div><div>My apologies, 'Spatial join tool' = 'join attributes by location' if you tick the 'sum' option you will get a join count column for each record in the resultant shapefile and should be able to do what you need to do, i.e get a total for all the joins. </div>
<div><br></div><div><br></div></div></div><div class="gmail_extra"><br><br><div class="gmail_quote"><div><div class="h5">On 8 August 2013 15:07, Jonathan Moules <span dir="ltr"><<a href="mailto:jonathanmoules@warwickshire.gov.uk" target="_blank">jonathanmoules@warwickshire.gov.uk</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5">Hi Illya,<div><div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<span style="font-family:arial,helvetica,sans-serif">Counting the number of joins can be done with the 'Spatial join' tool select 'Count' parameter and you will get a column that you can add up and find the total number of joins performed in the operation. </span></blockquote>
</div>
Which is the "Spatial Join" tool? It sounds like exactly what I want.</div><div>If you mean the "join attributes by location", it doesn't have a count parameter, though it does have mean/min/max etc.</div>
<div>
<div><br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><span style="font-family:arial,helvetica,sans-serif">If you want to know the number of features check out the 'Spatial Query' tool it will give you the total number of features (layerA > LayerB) for a range of set overlay operations. You can also save the results out easily. The interface is very intuitive. </span></blockquote>
</div><div>This is only able to get the broader overview of comparing the entire datasets against each other rather than individual features compared against their counterparts in the other dataset. Useful, just not for this scenario.</div>
<div>Also I am now finding it prone to crashing when one of the datasets is SpatiaLite; I'll report that imminently.</div><div><div><br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<span style="font-family:arial,helvetica,sans-serif">I see from another thread you have a grasp of SQL, your query is also easily is achieved in SQLite or PostGIS. </span></blockquote></div><div>Ah, I'm afraid you give me too much credit; I've not played with the spatial capabilities of any of these. It's on my todo list, but for now I'm trying to stick to QGIS</div>
<div>
<div><br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><font face="arial, helvetica, sans-serif" style="color:rgb(34,34,34);font-size:13px">From the ArcGIS 10 manual "</font><span style="line-height:17.90625px;color:rgb(34,34,34);font-size:13px;font-family:arial,sans-serif"><font face="arial, helvetica, sans-serif">If a join feature has a spatial relationship with multiple target features, then it is counted as many times as it is matched against the target feature. For example, if a point is WITHIN three polygons, then the point is counted three times, once for each polygon." </font></span></blockquote>
<div><br></div></div><div>In this situation that's exactly what I want. :-)</div><div><br></div><div>Thanks,</div><div>Jonathan<div><div><br><br><div class="gmail_quote">On 8 August 2013 14:32, Illya Santos <span dir="ltr"><<a href="mailto:illya.sparkes.santos@gmail.com" target="_blank">illya.sparkes.santos@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><font face="arial, helvetica, sans-serif">Jonathan, </font><div><font face="arial, helvetica, sans-serif"><br>
</font></div><div><font face="arial, helvetica, sans-serif">Counting the number of joins can be done with the 'Spatial join' tool select 'Count' parameter and you will get a column that you can add up and find the total number of joins performed in the operation. <br>
</font><div><font face="arial, helvetica, sans-serif"><br>
</font></div><div><font face="arial, helvetica, sans-serif">If you want to know the number of features check out the 'Spatial Query' tool it will give you the total number of features (layerA > LayerB) for a range of set overlay operations. You can also save the results out easily. The interface is very intuitive. </font></div>
<div><font face="arial, helvetica, sans-serif"><br></font></div><div><font face="arial, helvetica, sans-serif">I see from another thread you have a grasp of SQL, your query is also easily is achieved in SQLite or PostGIS. </font></div>
<div><font face="arial, helvetica, sans-serif"><br>
</font></div><div><div><font face="arial, helvetica, sans-serif">N.B My understanding is that "spatial joins" will overcount, as it were, and should not be used to determine the number of polygons in layer A intersecting with layer B. </font></div>
<div><font face="arial, helvetica, sans-serif"><br></font></div><div><font face="arial, helvetica, sans-serif">From the ArcGIS 10 manual "</font><span style="line-height:17.90625px;font-size:13px"><font face="arial, helvetica, sans-serif">If a join feature has a spatial relationship with multiple target features, then it is counted as many times as it is matched against the target feature. For example, if a point is WITHIN three polygons, then the point is counted three times, once for each polygon." </font></span></div>
<div> </div></div><div></div><div><br></div><div></div></div><div class="gmail_extra"><br clear="all"><div><br></div>
</div></div>
</blockquote></div><br></div></div></div></div></div><div><div>
<br><div class="im">
<span style="color:rgb(34,34,34);font-family:arial,sans-serif">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.</span></div>
</div><span class="HOEnZb"><font color="#888888">
</font></span></div></blockquote></div><span class="HOEnZb"><font color="#888888"><br><br clear="all"><div><br></div>-- <br>Email - <a href="mailto:Illya.sparkes.santos@gmail.com" target="_blank">Illya.sparkes.santos@gmail.com</a><br>
Skype - illyadavid<br>Mob - 07872908958<br>
</font></span></div>
</blockquote></div><br></div>
<br>
<span style="color:rgb(34,34,34);font-family:arial,sans-serif;background-color:rgb(255,255,255)">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.</span>