I am trying to get oblique tiles into a mosaic dataset. The tiling scheme works perfectly well for vertical and north imagery (using google tiling scheme) through the GDAL driver, however I am struggling to get 45 degree tiles in.
The tiles are indexed very similarly to google tiles (starting at top left) as per example below (East orientation):
The crux of the problem is the CRS as defined by the GDAL XML. This is what it looks like for vertical imagery:
<GDAL_WMS>
<Service name="TMS">
<ServerUrl>http://example.com?x=${x}&y=${y}&z=${z}</ServerUrl>
</Service>
<DataWindow>
<UpperLeftX>12523442.7125</UpperLeftX>
<UpperLeftY>-1878516.40687</UpperLeftY>
<LowerRightX>13149614.8481</LowerRightX>
<LowerRightY>-2504688.5425</LowerRightY>
<TileLevel>21</TileLevel>
<SizeX>8388608</SizeX>
<SizeY>8388608</SizeY>
<TileX>1703936</TileX>
<TileY>1146880</TileY>
<YOrigin>top</YOrigin>
</DataWindow>
<Projection>PROJCS["WGS_1984_Web_Mercator_Auxiliary_Sphere",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433],AXIS["Lat",SOUTH],AXIS["Long",EAST]],PROJECTION["Mercator_Auxiliary_Sphere"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",0.0],PARAMETER["Auxiliary_Sphere_Type",0.0],UNIT["Meter",1.0],AUTHORITY["EPSG",3857]]</Projection>
<BlockSizeX>256</BlockSizeX>
<BlockSizeY>256</BlockSizeY>
<BandsCount>3</BandsCount>
<UnsafeSSL>true</UnsafeSSL>
<MaxConnections>10</MaxConnections>
</GDAL_WMS>
My theory is that I need to rotate the coordinate system so that, in the example of East orientation, Y axis gots towards East, and X axis goes towards South. After trying a few things I could not get it to work. The best candidate was an affine transform as described here https://gis.stackexchange.com/a/159134/52713, however that just resulted in an invalid dataset (using identity transform or no-op transform), showing up in ArcMap like so:

