<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>Good morning all,<br/>
<br/>
<br/>
I would need some advice to move forward.<br/>
I'm starting to use Rstudio to manipulate a climate data and intersect with a differents points on my map (table of 1000 points with 6 attributes).<br/>
Also, I have several raster. I have an ASCII file for each day of a year. For 30 years.<br/>
<br/>
<br/>
I tried to use the Stack function and then make the intersection with my 1000 points for one year :<br/>
<div>fs <- list.files(path="N:/Climate-10km/Max_T/1960",<br/>
pattern = "asc$", full.names = TRUE)</div>
<div>s <- raster::stack(fs)<br/>
</div>
<div>TMAX60 <- extract(s, DataPoints)</div>
<div> </div>
<div> </div>
<div> </div>
<div>I'm stuck just at this part ...<br/>
My intersection is good, but the order of appearance of my different columns corresponding to my 366 files (1 year) does not make any sense. They are out of order.<br/>
<br/>
My goal is to create a table with my 6 points attributes, and add a "Year" column and a "Days" column and finally a "Pixel values" column. For a year at first time and if possible doing this intersection for all my years.</div>
<div> </div>
<div>I had the idea to do this for each year and then join my different produced tables.</div>
<div>In the end, I would have a huge table, but one that will allow me to do my analysis. By calculating this, I will get:</div>
<div> </div>
<div><span lang="EN-CA" style="font-size:11.0pt"><span style="font-family:"Calibri",sans-serif"><span style="color:#1f497d">- 9 attributes (6 attributs points, Year, Day, TMax) and 10 980 000 lines (30 years (past) * 366 days * 1000 points).</span></span></span></div>
<div> </div>
<div>Does this seem like a good approach to you ?</div>
<div> </div>
<div>Do you have an idea that could allow me to do this task without going through multiple table operations with "Dplyr" ?<br/>
<br/>
Do you have any advice for a better approach I could take?<br/>
<br/>
Sorry if my English is not always appropriate. I'm not very used to talking in this language yet. I'm working on it. :) <br/>
<br/>
Thank you very much in advance to those who can help me.<br/>
<br/>
Have a good day.<br/>
<br/>
Gaëtan.</div>
</div></div></body></html>