I have a CSV file with various data in 1 degree wide by 0.5 degree high rectangles, for which I have the N,S,E,W, & centroid lat/longs, i.e. every bit of spatial data required. I'm trying to convert this into a polygon grid, so that I can display the associated data in the variety of ways that raster doesn't do nearly as well (for ref: I have successfully converted to raster using this method (point > shape > raster)).
Other Q&As recommend points2one plugin, however this results in a big mess of triangles; in addition, no matter how I import the csv, qgis will only display one point per cell, either the centroid (manually selecting centroid lat/long) or the NE corner (default, qgis picks up the NORTH & EAST field names).
I've just successfully done this using WKT, creating a formula in excel to generate the polygons from the NESW coordinates, which seems like the best way so far.
My question is: is there a better way of doing this natively in QGis? It feels like the software has all the info available to be able to do this with one or two clicks - am I just missing it?
Thanks!
p.s. if anyone reads this & is in the same boat, my formula was: ="POLYGON (("&E2&" "&D2&", "&E2&" "&F2&", "&G2&" "&F2&", "&G2&" "&D2&", "&E2&" "&D2&"))" with S/W/N/E in columns D/E/F/G respectively, and the formula in H. Remember to copy * paste back over the output as values before you save.