Difference between revisions of "User's guide to PlanWise"
Jump to navigation
Jump to search
Line 33: | Line 33: | ||
== Analyzing Results == | == Analyzing Results == | ||
The optimized plan can be wiewed in the map window, as diagrams and reports, or by running a script in the result database (i.e., right-clicking "My_Heureka_Results" (or corresponding), choosing "New Query", paste the script below and "Execute"). | The optimized plan can be wiewed in the map window, as diagrams and reports, or by running a script in the result database (i.e., right-clicking "My_Heureka_Results" (or corresponding), choosing "New Query", paste the script below and "Execute"). | ||
+ | |||
+ | <pre> | ||
+ | |||
+ | SELECT SIMULATION.SimNo, TREATMENTUNIT.Description, TREATMENTUNIT.Area AS AvdProdArea, | ||
+ | |||
+ | |||
+ | RESULT_FORESTDATA.MeanAgeTotal_Before AS Medelålder, RESULT_TREATMENTDATA.VolumeCutTotal AS VolAvv, | ||
+ | RESULT_VALUEDATA.Net AS Netto, OPTIMIZATIONRESULT.Proportion AS Andel, OPTIMIZATION.OptimizationNo | ||
+ | FROM RESULT INNER JOIN | ||
+ | TREATMENTUNIT ON RESULT.SimulationGuid = TREATMENTUNIT.SimulationGuid AND | ||
+ | RESULT.TreatmentUnitGUID = TREATMENTUNIT.TreatmentUnitGUID INNER JOIN | ||
+ | RESULT_FORESTDATA ON RESULT.ResultGuid = RESULT_FORESTDATA.ResultGuid INNER JOIN | ||
+ | SIMULATION ON RESULT.SimulationGuid = SIMULATION.SimulationGuid INNER JOIN | ||
+ | OPTIMIZATIONRESULT ON RESULT.TreatmentUnitGUID = OPTIMIZATIONRESULT.TreatmentUnitGuid AND | ||
+ | RESULT.AlternativeNo = OPTIMIZATIONRESULT.AlternativeNo AND RESULT.SimulationGuid = OPTIMIZATIONRESULT.SimulationGuid INNER JOIN | ||
+ | OPTIMIZATION ON OPTIMIZATIONRESULT.OptimizationGuid = OPTIMIZATION.OptimizationGuid AND | ||
+ | OPTIMIZATIONRESULT.SimulationGuid = OPTIMIZATION.SimulationGuid FULL OUTER JOIN | ||
+ | TREATMENTTYPE RIGHT OUTER JOIN | ||
+ | RESULT_VALUEDATA INNER JOIN | ||
+ | RESULT_TREATMENTDATA ON RESULT_VALUEDATA.ResultGuid = RESULT_TREATMENTDATA.ResultGuid AND | ||
+ | RESULT_VALUEDATA.RowNo = RESULT_TREATMENTDATA.RowNo ON TREATMENTTYPE.Code = RESULT_TREATMENTDATA.Treatment ON | ||
+ | RESULT.ResultGuid = RESULT_TREATMENTDATA.ResultGuid | ||
+ | WHERE (OPTIMIZATIONRESULT.Proportion > 0) AND (RESULT.Period <= 10) AND (OPTIMIZATION.OptimizationNo = 0) AND (SIMULATION.SimNo = 3) AND | ||
+ | (RESULT_TREATMENTDATA.Treatment > 0) | ||
+ | ORDER BY TREATMENTUNIT.Description, RESULT.AlternativeNo, RESULT.Period | ||
+ | |||
+ | </pre> | ||
== How Do I? == | == How Do I? == |