Displaying differences for changeset
 
display as  

src/java/m/wqm/wqsr/V1_0.java

@@ -99,7 +99,8 @@
           aoaSensitiveArea=0.0;
           aoaCriticalArea=0.0;
         //Query to select the area,rating and treatment level which given coordinates intersects wqsr_area geometry
-          ResultSet results=stmt.executeQuery("select shape_area,wqs_rating,wqs_treatment_level from wqm_huc12.wqsr_area WHERE ST_Intersects(ST_PolygonFromText('POLYGON(("+list.get(i).getCoordinates()+"))'),geom)");
+//          ResultSet results=stmt.executeQuery("select shape_area,wqs_rating,wqs_treatment_level from wqm_huc12.wqsr_area WHERE ST_Intersects(ST_PolygonFromText('POLYGON(("+list.get(i).getCoordinates()+"))'),geom)");
+            ResultSet results=stmt.executeQuery("select shape_area,wqs_rating,wqs_treatment_level from wqm_huc12.wqsr_area WHERE ST_Intersects('POLYGON(("+list.get(i).getCoordinates()+"))'::geography::geometry, geom)");
           while(results.next())
       { 
         String wqsRating=results.getString("wqs_rating");