<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
Karsten,<br>
<br>
Great explanation. Guess it just goes to show; with GIS, there's
usually more than one way to "skin a cat".<br>
<br>
😂<br>
<br>
<br>
<div class="moz-signature">Michael Williams</div>
<div class="moz-cite-prefix">On 5/21/2021 1:44 PM, karsten wrote:<br>
</div>
<blockquote type="cite"
cite="mid:406AB27104544960B6680D51228D17B6@terragispc">
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
<meta name="GENERATOR" content="MSHTML 11.00.10570.1001">
<div dir="ltr" align="left"><span class="359171618-21052021"><font
size="2" face="Arial" color="#000080">Hi Michael,</font></span></div>
<div dir="ltr" align="left"><span class="359171618-21052021"></span> </div>
<div dir="ltr" align="left"><span class="359171618-21052021"><font
size="2" face="Arial" color="#000080">you could convert the
raster data to point vector layers (not sure how big your
data is and why you don't have have camera location as
vector ...).</font></span></div>
<div dir="ltr" align="left"><span class="359171618-21052021"><font
size="2" face="Arial" color="#000080">and could work the
point layer directly...</font></span></div>
<div dir="ltr" align="left"><span class="359171618-21052021"></span> </div>
<div dir="ltr" align="left"><span class="359171618-21052021"><font
size="2" face="Arial" color="#000080">But to your question:
</font></span><span class="359171618-21052021"><font size="2"
face="Arial" color="#000080">a simple csv file to load into
QGIS could look like this:</font></span></div>
<div dir="ltr" align="left"><span class="359171618-21052021"></span> </div>
<div dir="ltr" align="left"><span class="359171618-21052021"><font
size="2" face="Arial" color="#000080">id,x_coordinate,y_coordinate,cat
species</font></span></div>
<div dir="ltr" align="left"><span class="359171618-21052021"><font
size="2" face="Arial" color="#000080">101,-34.636854,48.468562
,cat1<br>
102,-122.350595,45.581067,cat2<br>
103,-122.448685,45.582003,cat3<br>
104,-122.320488,45.583881,cat2</font></span></div>
<div><span class="359171618-21052021"></span> </div>
<div><span class="359171618-21052021"><font size="2" face="Arial"
color="#000080">To load use the import csv button. see e.g.
here <a
href="https://www.qgistutorials.com/en/docs/3/importing_spreadsheets_csv.html"
moz-do-not-send="true">https://www.qgistutorials.com/en/docs/3/importing_spreadsheets_csv.html</a></font></span></div>
<div><span class="359171618-21052021"> </span></div>
<div dir="ltr" align="left"><span class="359171618-21052021"></span><font
size="2" face="Arial" color="#000080">N<span
class="359171618-21052021">ote that the process would then
create one point for each cat sighting at each camera (so
that would duplicate points if there was more then one
sighting at a location/ camera).</span></font></div>
<div dir="ltr" align="left"><span class="359171618-21052021"></span><span
class="359171618-21052021"></span> </div>
<div dir="ltr" align="left"><font size="2" face="Arial"
color="#000080">A<span class="359171618-21052021"> way to
avoid that would be to load a csv file of all camera
location e.g. like this</span></font></div>
<div><font size="2" face="Arial" color="#000080"><span
class="359171618-21052021"></span></font> </div>
<div><font size="2" face="Arial" color="#000080"><span
class="359171618-21052021">camera locations table</span></font></div>
<div><font size="2" face="Arial" color="#000080"><span
class="359171618-21052021">
<div dir="ltr" align="left"><span class="359171618-21052021"><font
size="2" face="Arial" color="#000080">camera_id,x_coordinate,y_coordinate</font></span></div>
<div dir="ltr" align="left"><span class="359171618-21052021"><font
size="2" face="Arial" color="#000080">1,-34.636854,48.468562<br>
2,-122.350595,45.581067<br>
3,-122.448685,45.582003<br>
4,-122.320488,45.583881</font></span></div>
<div dir="ltr" align="left"><span class="359171618-21052021"></span> </div>
<div dir="ltr" align="left"><span class="359171618-21052021">and
a </span><span class="359171618-21052021">cat sightings
table</span></div>
<div dir="ltr" align="left"><span class="359171618-21052021"><span
class="359171618-21052021"><font size="2" face="Arial"
color="#000080">sighting_id,camera_idx_coordinate,y_coordinate,cat
species</font></span></span></div>
<div dir="ltr" align="left"><span class="359171618-21052021"><span
class="359171618-21052021"><font size="2" face="Arial"
color="#000080">101,1,-34.636854,48.468562 ,cat1<br>
102,1,-122.350595,45.581067,cat2<br>
103,2,-122.448685,45.582003,cat3<br>
104,3,-122.320488,45.583881,cat2</font></span></span></div>
<div dir="ltr" align="left"><span class="359171618-21052021"></span> </div>
</span></font></div>
<div><font size="2" face="Arial" color="#000080"><span
class="359171618-21052021"></span></font> </div>
<div><font size="2" face="Arial" color="#000080"><span
class="359171618-21052021">and then join a second csv (or
excel spread sheet) to the camera_id field</span></font></div>
<div><font size="2" face="Arial" color="#000080"><span
class="359171618-21052021">see tutorial here <a
href="http://www.qgistutorials.com/en/docs/performing_table_joins.html"
moz-do-not-send="true">http://www.qgistutorials.com/en/docs/performing_table_joins.html</a></span></font></div>
<div><font size="2" face="Arial" color="#000080"><span
class="359171618-21052021">or simpler explanation here <a
href="https://guides.library.duke.edu/QGIS/Joins"
moz-do-not-send="true">https://guides.library.duke.edu/QGIS/Joins</a></span></font></div>
<div><font size="2" face="Arial" color="#000080"><span
class="359171618-21052021"></span></font> </div>
<div><font size="2" face="Arial" color="#000080"><span
class="359171618-21052021">You could then also generate a
number of sightings to each camera location to create a heat
map...</span></font></div>
<div><font size="2" face="Arial" color="#000080"><span
class="359171618-21052021"></span></font> </div>
<div><font size="2" face="Arial" color="#000080"><span
class="359171618-21052021">Let me know that makes sense and
help you out</span></font></div>
<div><font size="2" face="Arial" color="#000080"><span
class="359171618-21052021"></span></font> </div>
<div><font size="2" face="Arial" color="#000080"><span
class="359171618-21052021">Cheers</span></font></div>
<div><font size="2" face="Arial" color="#000080"><span
class="359171618-21052021">Karsten</span></font></div>
<font size="2" face="Arial" color="#000080">
<div dir="ltr" align="left"><br>
</div>
</font><br>
<div class="OutlookMessageHeader" dir="ltr" lang="en-us"
align="left">
<hr tabindex="-1">
<font size="2" face="Tahoma"><b>From:</b> Qgis-us-user
[<a class="moz-txt-link-freetext" href="mailto:qgis-us-user-bounces@lists.osgeo.org">mailto:qgis-us-user-bounces@lists.osgeo.org</a>] <b>On Behalf Of
</b>Michael Hundt<br>
<b>Sent:</b> Friday, May 21, 2021 10:56<br>
<b>To:</b> <a class="moz-txt-link-abbreviated" href="mailto:qgis-us-user@lists.osgeo.org">qgis-us-user@lists.osgeo.org</a><br>
<b>Subject:</b> [Qgis-us-user] Heat Maps<br>
</font><br>
</div>
<div class="yahoo-style-wrap" style="FONT-SIZE: 13px; FONT-FAMILY:
Helvetica Neue, Helvetica, Arial, sans-serif">
<div dir="ltr" data-setdir="false">Hello,</div>
<div dir="ltr" data-setdir="false"><br>
</div>
<div dir="ltr" data-setdir="false">I am trying to create a heat
map indicating how many cats we have detected at specific
locations on our game cameras.</div>
<div dir="ltr" data-setdir="false"><br>
</div>
<div dir="ltr" data-setdir="false">The 10 cameras have detected
from one cat to as many as 28 cats.</div>
<div dir="ltr" data-setdir="false"><br>
</div>
<div dir="ltr" data-setdir="false">How do I format this
information in a CSV file? Or is another way to display and
manipulate the heat map.</div>
<div dir="ltr" data-setdir="false"><br>
</div>
<div dir="ltr" data-setdir="false">Currently, I have a Google
map of the camera grid on one layer, and on a 2nd layer
indicated the GPS location of each camera.</div>
<div dir="ltr" data-setdir="false"><br>
</div>
<div dir="ltr" data-setdir="false">DO you need more information
to help you help me?</div>
<div dir="ltr" data-setdir="false"><br>
</div>
<div dir="ltr" data-setdir="false">Best Regards</div>
<div dir="ltr" data-setdir="false">Mike</div>
<div dir="ltr" data-setdir="false"><br>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Qgis-us-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-us-user@lists.osgeo.org">Qgis-us-user@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-us-user">https://lists.osgeo.org/mailman/listinfo/qgis-us-user</a>
</pre>
</blockquote>
<br>
</body>
</html>