\d "getfutureausclimate" View "public.getfutureausclimate" Column | Type | Modifiers --------------+------------------+----------- ClimateId | smallint | AusPosNumber | integer | iMonth | integer | Longitude | integer | Latitude | integer | Height | real | ClimateValue | smallint | ScenarioId | integer | iYear | smallint | LevelId | integer | futurevalue | double precision | CREATE OR REPLACE VIEW "public"."getfutureausclimate" ( "ClimateId", "AusPosNumber", "iMonth", "Longitude", "Latitude", "Height", "ClimateValue", "ScenarioId", "iYear", "LevelId", futurevalue) AS SELECT "ClimateVariables"."ClimateId", "Aus40_DEM"."AusPosNumber", "CurrentAusClimate"."iMonth", "Aus40_DEM"."Longitude", "Aus40_DEM"."Latitude", "Aus40_DEM"."Height", "CurrentAusClimate"."ClimateValue", "GetFutureClimateParameters"."ScenarioId", "GetFutureClimateParameters"."iYear", "GetFutureClimateParameters"."LevelId", ((("CurrentAusClimate"."ClimateValue")::double precision / "ClimateVariables"."ClimateDivisor") + ("ScenarioEmissionLevels"."TempChange" * "ClimateChangeModel40"."ChangePerDegree")) AS futurevalue FROM ((("CurrentAusClimate" JOIN "ClimateChangeModel40" ON (((("CurrentAusClimate"."ClimateId" = "ClimateChangeModel40"."ClimateId") AND ("CurrentAusClimate"."AusPosNum" = "ClimateChangeModel40"."AusPosNumber")) AND ("CurrentAusClimate"."iMonth" = "ClimateChangeModel40"."iMonth")))) JOIN ("ClimateVariables" JOIN ("ScenarioEmissionLevels" JOIN "GetFutureClimateParameters" ON (((("ScenarioEmissionLevels"."iYear" = "GetFutureClimateParameters"."iYear") AND ("ScenarioEmissionLevels"."LevelId" = "GetFutureClimateParameters"."LevelId")) AND ("ScenarioEmissionLevels"."ScenarioId" = "GetFutureClimateParameters"."ScenarioId")))) ON (("ClimateVariables"."ClimateId" = "GetFutureClimateParameters"."ClimateId"))) ON (("CurrentAusClimate"."ClimateId" = "ClimateVariables"."ClimateId"))) JOIN "Aus40_DEM" ON (("ClimateChangeModel40"."AusPosNumber" = "Aus40_DEM"."AusPosNumber"))) ORDER BY "Aus40_DEM"."AusPosNumber", "CurrentAusClimate"."iMonth";