I am setting up a forest inventory database that aims to store information about forest plot data from various countries. The current project is in Mozambique, others are in Laos, etc.
Each project provides their forest data in different coordinate systems. Other than that the plot data (fields) is identical (nearly), so it makes sense to store it all in one table.
I have come across the problem today where I want to view multiple project data in Mozambique. The CRS from one project is supplied in WGS84, the other UTM 36S. The geometry table has set the CRS for plots to WGS84, so when I load in QGIS I can't see the plots in UTM.
What is best practice?
- To choose a single CRS (WGS84) for all plot data?
- To store plot data from different countries in different tables?
- Or depending on which record I am viewing QGIS can dynamically use the relevant projection?