I have a CSV of biweekly temperature values for the year 2011, at a 1000-m scale in part of the state of Iowa. The CSV contains ~95000 rows of temperature data, with the first 2 columns as the x and y points and the subsequent 27 columns are the 14-day intervals. I am trying to convert the CSV into a raster stack at 30-m resolution using interpolation, where each layer of the stack is a biweekly period (27 layers). The code I am using to convert from a CSV to raster stack also uses a reference raster, which is a raster layer of the correct extent and 30-m resolution.

This code has worked for me before for smaller CSV files.

preview of what the CSV looks like (the temperature values purposefully do not make sense here)

pts <- read.csv("bimonthly_1000m_temp.csv")

ref = raster("~/reference_raster.tif")

proj4string(pts)=CRS("+init=epsg:4326") # set it to lat-long
pts = spTransform(pts,crs(u))
gridded(pts) = TRUE
r = stack(pts)
projection(r) = crs(u)
r_crop <- crop(r,ref)
r_crop_resam = resample(r_crop, ref, method='bilinear', filename = "~/interpolated_raster.tif")

But, I get an error at gridded(pts) = TRUE:

suggested tolerance minimum: 0.111429 
Error in points2grid(points, tolerance, round) : 
  dimension 1 : coordinate intervals are not constant

Any suggestions? This answer here is in the vein of what I am looking for, though I am trying to interpolate and creating a raster stack.

  • 1
    if the points fall on a grid you should create the raster before transforming them (what is the crs(u)? Try rasterFromXYZ(pts) directly after read.csv (before and instead ofusing the sp coordinates/gridded stuff)
    – mdsumner
    Jul 8, 2020 at 23:06
  • Does "at a 1000-m scale" mean your points in the CSV are roughly 1000m apart? And you want to sample that up to a 30m resolution?
    – Spacedman
    Jul 9, 2020 at 7:34
  • Thanks @mdsumner. I tried rasterFromXYZ() but got Error in rasterFromXYZ(dt) : x cell sizes are not regular. So I think the problem must be with my pts (my CSV file itself), it seems like they do not fall on a grid.
    – rachell
    Jul 10, 2020 at 17:47
  • @Spacedman yes, exactly that.
    – rachell
    Jul 10, 2020 at 17:48
  • 1
    "if the points fall on a grid" - try plotting them, it's often fairly clear - use 'pch = "."' so it's fast to plot many points
    – mdsumner
    Jul 14, 2020 at 1:11


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.