Latest Contributions by NicolasBeerli

Hi Xander, I don't have experience with python. So it will take a bit to figure it out for me. But after all problems I had with the model builder I think it is anyway a must to know python. I let you know when I run in problem thanks. Many thanks, Nicolas ... View more

a pity this table looks exactly like what I want. here again the link this time with the table Dropbox - sample raster ... View more

Hi Xander, Here some of the (plain) rasters that I am working with (the body measurements I added later as join). https://www.dropbox.com/sh/awgeiugv9tp3e2t/AAD1Z7od31qNsXgQc_AKzylea?dl=0 Nicolas ... View more

Hey thanks for all the suggestions... I am going to try what works. I had also a new idea to solve the problem. The idea is to create a table like this: Each column represents one species and each row one cell (100 * 100 km). In each cell I going to write whether a species is present (1) or absent. If I am somehow able to create such a table it is pretty easy to calculate the median, the mean or add any other information to each cell (when I add a other column, row). To do that, I am going to create for each raster cell a point feature (which has the similar ID like rows in my table). What I was thinking is to have my species ranges all merged as polygon (without any measurements data in the attribute table). Somehow it should be possible to extract the present species into a point per raster? This table I could then import in R for further analysis. The Problem of course could be the size of this table (approximately 1000 columns * 7000 rows...) Somebody idea whether that works or not? ... View more

Thanks a lot for showing me this solution! What I was wondering 1. Do you think that the intersecting is also possible with 1000 polygons? 2. Is there a good way to convert the product polygon (out of your calculations) back into raster with keeping all the calculated mean values? Because what I finally want to do with this data is a analysis whether there is a correlation between bodysizes and latitude or not (and I also going to test my data against climate data etc). What I need to conduct this analysis is to have cells with a exact geographic position and the mean bodysize. Many thanks, nicolas ... View more

Hi, That sounds like a good way to handle this data. I`ve already done the first 2 steps you suggested and I`m going to try the others. It would be wonderful if you could have a quick look at it. Here is a sample: https://www.dropbox.com/sh/8mkvc3sbt33dtik/AACBOX6oqEHEYmWRD-wFhm80a?dl=0 P.S. You mentioned the "batch" function. Just discovered that as a good alternative to the "iterate," in the model builder- thanks! I like it because it goes a lot faster. But what I still struggle with, is that batch is the output name. Is there anything like %name% possible in batch? Best regards, Nicolas ... View more

The aim of this analysis is to have each cell show the mean wing length, body length  & thorax width of all species which occur in the pixel. So in the end, I hope to have three rasters which show me all of the three measurements, and therefore show me the spatial distribution of the average body size (either wing length, body length or thorax width). Yes I have 1000 rasters each with a attribute table like this: All rasters are classified as 1 (equal presence of the species). Each single cell of the rasters overlap exactly and have the same cell size. But the raster themselves have different extensions. One cell is 100 * 100 km. The study area is the whole "old world." (so theoretically there would be a maximal of 205 columns and 141 rows possible) Many thanks! ... View more

Yes, Cell Statistics would be the right tool if it only had a field where I could access the columns of the attribute table (as parameter). The values that I was going to use to calculate the mean are in the attribute table. ... View more