<p dir="ltr">Hi,<br>
The easy way out is to do a cross tabulation in excel or libre office calc and to then link both data bases together based on the point id. I think there may also be a cross tabulation plugin in QGIS??? I would need to look on a computer to make sure.</p>
<p dir="ltr">Nicolas Cadieux M.Sc.<br>
Les Entreprises Archéotec inc. <br>
8548, rue Saint-Denis Montréal H2P 2H2<br>
Téléphone: 514.381.5112 Fax: 514.381.4995<br>
www.archeotec.ca</p>
<div class="gmail_quote">On Sep 29, 2015 21:47, "Johanna Botman-2 [via OSGeo.org] " <<a href="/user/SendEmail.jtp?type=node&node=5226930&i=0" target="_top" rel="nofollow" link="external">[hidden email]</a>> wrote:<br type='attribution'><blockquote style='border-left:2px solid #CCCCCC;padding:0 1em' class="quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<p><font size="2" face="sans-serif">Hi,</font><br />
<br />
<font size="2" face="sans-serif">I'm having trouble working out what should be a simple problem.</font><br />
<br />
<font size="2" face="sans-serif">I have data that lists all the traffic accidents in our local area. Each accident has a unique ID, but there can be many accidents at the one location.</font><br />
<br />
<font size="2" face="sans-serif">I want to show the accumulated accident numbers using a graduated symbol size based on the count of accidents at that one spot. Underdark's excellent blog post describes how to use the new features in QGIS 2.10 - using a range from a single attribute. What I want QGIS to do is to add up the incidents for a specific location.</font><br />
<br />
<font size="2" face="sans-serif">My brain hurts and I can't think how to do this. Can someone help?</font><br />
<br />
<font size="2" face="sans-serif">_______________<br />
Johanna Botman<br />
GIS / Assets Officer</font>
</p><p><font size="2" face="Arial"></font> </p>
<p><font size="2" face="Arial"> </font></p>
<p>
</p><hr />
This e-mail, together with any attachments, is for the exclusive and
confidential use of the addressee(s). Confidentiality is not waived if you are
not the intended recipient. Any other distribution, use of, or reproduction
without prior written consent is strictly prohibited.
<p></p>
<p><font size="2" face="Arial">Views expressed in this e-mail are those of the
individual, except where specifically stated otherwise. If this e-mail has been
sent to you in error, please delete the e-mail completely and immediately from
your system. Although reasonable precautions are taken, Griffith City Council
does not warrant or guarantee this message to be free of errors, interference,
viruses or similar malicious code and does not accept liability for any
consequences to the recipient opening or using this email or
attachments.</font></p>
<p><font face="Arial"><font size="2">This email was scanned and cleared by
MailMarshal, Sophos & Kaspersky AV<br />
</font></font></p><hr />
<p></p>
<br />_______________________________________________
<br />Qgis-user mailing list
<br /><a href="/user/SendEmail.jtp?type=node&node=5226929&i=0">[hidden email]</a>
<br /><a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_top" rel="nofollow" link="external">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
<br />
<br />
<hr noshade="noshade" size="1" />
<div style="color:#444;font:12px 'tahoma' , 'geneva' , 'helvetica' , 'arial' , sans-serif">
<div style="font-weight:bold">If you reply to this email, your message will be added to the discussion below:</div>
<a href="http://osgeo-org.1560.x6.nabble.com/Counting-instances-of-points-and-representing-totals-tp5226929.html" target="_top" rel="nofollow" link="external">http://osgeo-org.1560.x6.nabble.com/Counting-instances-of-points-and-representing-totals-tp5226929.html</a>
</div>
<div style="color:#666;font:11px 'tahoma' , 'geneva' , 'helvetica' , 'arial' , sans-serif;margin-top:0.4em;line-height:1.5em">
To start a new topic under Quantum GIS - User, email ml-node+s1560n4125267h38@n6.nabble.com <br />
To unsubscribe from Quantum GIS - User, <a href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4125267&code=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYXw0MTI1MjY3fDYzNDQ4MjQxNg==">click here</a>.<br />
<a href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml" style="font:9px serif">NAML</a>
</div></blockquote></div>
<br/><hr align="left" width="300" />
View this message in context: <a href="http://osgeo-org.1560.x6.nabble.com/Counting-instances-of-points-and-representing-totals-tp5226929p5226930.html">Re: Counting instances of points and representing totals</a><br/>
Sent from the <a href="http://osgeo-org.1560.x6.nabble.com/Quantum-GIS-User-f4125267.html">Quantum GIS - User mailing list archive</a> at Nabble.com.<br/>