How do I create a 4 x 4 grid over the orange grid like the pink(ish) one?
The pink grid are geometries that have already been provided and are wonderful. I'm attempting to create something similar over the other orange grids.
I could do this manually, but it would take a long time.
My first attempt was a fishnet function using Creating regular polygon grid in PostGIS?. The result is the purple in the bottom right of the picture. I could fiddle with the function for a while to get the grid to be rectangular instead of square but the orange grid varies slightly in places and is completely not perfect in others. I do not want an overlapping smaller grid.
So my next idea is to take the 'perfect' geometries and a align it with the bottom left of the orange grid and 'squish' it into the orange grid area.
I don't know if this is A) possible or B) the best way to go about solving my problem.