<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 11.00.10570.1001"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=359171618-21052021><FONT color=#000080
size=2 face=Arial>Hi Michael,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=359171618-21052021><FONT color=#000080
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=359171618-21052021><FONT color=#000080
size=2 face=Arial>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 color=#000080
size=2 face=Arial>and could work the point layer directly...</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=359171618-21052021><FONT color=#000080
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=359171618-21052021><FONT color=#000080
size=2 face=Arial>But to your question: </FONT></SPAN><SPAN
class=359171618-21052021><FONT color=#000080 size=2 face=Arial>a simple csv file
to load into QGIS could look like this:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=359171618-21052021><FONT color=#000080
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=359171618-21052021><FONT color=#000080
size=2 face=Arial>id,x_coordinate,y_coordinate,cat species</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=359171618-21052021><FONT color=#000080
size=2 face=Arial>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><FONT color=#000080 size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=359171618-21052021><FONT color=#000080 size=2 face=Arial>To
load use the import csv button. see e.g. here <A
href="https://www.qgistutorials.com/en/docs/3/importing_spreadsheets_csv.html">https://www.qgistutorials.com/en/docs/3/importing_spreadsheets_csv.html</A></FONT></SPAN></DIV>
<DIV><SPAN class=359171618-21052021><FONT color=#000080 size=2
face=Arial></FONT> </DIV>
<DIV dir=ltr align=left><SPAN class=359171618-21052021></SPAN><FONT
color=#000080 size=2 face=Arial>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><FONT color=#000080 size=2
face=Arial></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#000080 size=2 face=Arial>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 color=#000080 size=2 face=Arial><SPAN
class=359171618-21052021></SPAN></FONT> </DIV>
<DIV><FONT color=#000080 size=2 face=Arial><SPAN class=359171618-21052021>camera
locations table</SPAN></FONT></DIV>
<DIV><FONT color=#000080 size=2 face=Arial><SPAN class=359171618-21052021>
<DIV dir=ltr align=left><SPAN class=359171618-21052021><FONT color=#000080
size=2 face=Arial>camera_id,x_coordinate,y_coordinate</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=359171618-21052021><FONT color=#000080
size=2
face=Arial>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 color=#000080 size=2
face=Arial>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 color=#000080 size=2
face=Arial>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 color=#000080 size=2 face=Arial><SPAN
class=359171618-21052021></SPAN></FONT> </DIV>
<DIV><FONT color=#000080 size=2 face=Arial><SPAN class=359171618-21052021>and
then join a second csv (or excel spread sheet) to the camera_id
field</SPAN></FONT></DIV>
<DIV><FONT color=#000080 size=2 face=Arial><SPAN class=359171618-21052021>see
tutorial here <A
href="http://www.qgistutorials.com/en/docs/performing_table_joins.html">http://www.qgistutorials.com/en/docs/performing_table_joins.html</A></SPAN></FONT></DIV>
<DIV><FONT color=#000080 size=2 face=Arial><SPAN class=359171618-21052021>or
simpler explanation here <A
href="https://guides.library.duke.edu/QGIS/Joins">https://guides.library.duke.edu/QGIS/Joins</A></SPAN></FONT></DIV>
<DIV><FONT color=#000080 size=2 face=Arial><SPAN
class=359171618-21052021></SPAN></FONT> </DIV>
<DIV><FONT color=#000080 size=2 face=Arial><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 color=#000080 size=2 face=Arial><SPAN
class=359171618-21052021></SPAN></FONT> </DIV>
<DIV><FONT color=#000080 size=2 face=Arial><SPAN class=359171618-21052021>Let me
know that makes sense and help you out</SPAN></FONT></DIV>
<DIV><FONT color=#000080 size=2 face=Arial><SPAN
class=359171618-21052021></SPAN></FONT> </DIV>
<DIV><FONT color=#000080 size=2 face=Arial><SPAN
class=359171618-21052021>Cheers</SPAN></FONT></DIV>
<DIV><FONT color=#000080 size=2 face=Arial><SPAN
class=359171618-21052021>Karsten</SPAN></DIV>
<DIV dir=ltr align=left><BR></DIV></FONT></SPAN><BR>
<DIV lang=en-us class=OutlookMessageHeader dir=ltr align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> Qgis-us-user
[mailto:qgis-us-user-bounces@lists.osgeo.org] <B>On Behalf Of </B>Michael
Hundt<BR><B>Sent:</B> Friday, May 21, 2021 10:56<BR><B>To:</B>
qgis-us-user@lists.osgeo.org<BR><B>Subject:</B> [Qgis-us-user] Heat
Maps<BR></FONT><BR></DIV>
<DIV></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></BODY></HTML>