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? == | ||