I am working in the UK and have a list of points in British National Grid (BNG) projection (GCS_OSGB_1936).
I need to accurately display the BNG points on top of a grid (shapefile) that is in LAEA, and number the grid cells that contain a point.
In ArcMap 10.4 I have set the data frame (Layers) to BNG and so I can correctly display my points (and OS basemaps). When I add the LAEA layers there is a Geographic Coordinate Systems Warning with the following info (that provides no other options in the dropdown boxes):
When I click 'close' the LAEA layers draw and look to be in vaguely the right location over the OS BNG data, but not exactly...
(The same happens in reverse if I set the data frame to LAEA and then try to add the BNG points)
If I try 'defining projection' of the BNG points and setting them to LAEA, then it ends up drawing them in the middle of Europe (definitely not correct!)
Can anyone suggest a way to ensure that my BNG points and LAEA grid are correctly aligned to one another?
Likewise if there is a way of converting the points directly from BNG to LAEA in Excel that would also be useful.