Check Detection Sample Sector VegetationRemoval

If any of these four queries give any result set then you have to check all tables in that group, e.g. if vegetationremovalversion gives a result set then also:

• vegetationremoval
• vegetationremoval_has_cdfvalue
• vegetationremovalversion_has_cdfvalue

might have values. These values have to be added manually to the 6.0 database since the upgrade scripts do not handle them (2014-11-25/NAA).

SELECT COUNT(*) AS DetecInfo FROM detectionversion ;
SELECT COUNT(*) AS SampleInfo FROM sampleversion;
SELECT COUNT(*) AS SectorInfo FROM sectorversion ;
SELECT COUNT(*) AS VegInfo FROM vegetationremovalversion;