src/java/rhem/utils/DBQueries.java
| @@ -13,7 +13,7 @@ |
| */ |
| public class DBQueries { |
| |
| - public static String RHEM01Query01(String soilTexture) { |
| + public static String RunRHEMQuery01(String soilTexture) { |
| String query = "SELECT clay_diameter, silt_diameter, " |
| + "small_aggregates_diameter, large_aggregates_diameter, " |
| + "sand_diameter, clay_specific_gravity, " |
| @@ -140,4 +140,12 @@ |
| + "WHERE obsolete = 'false';"; |
| return query; |
| } |
| + |
| + public static String RHEM01Query02(String climateStationId) { |
| + String query = "SELECT avg_yearly_precip_mm " |
| + + "FROM rhem.d_rhem_climate_stations_avg_300yr_est_rain " |
| + + "WHERE station_id = '" + climateStationId + "';"; |
| + return query; |
| + } |
| + |
| } |