@@ -1,192 +1,192 @@ |
-<<<<<<< local |
-annotation.processing.enabled=true |
-annotation.processing.enabled.in.editor=true |
-annotation.processing.processors.list= |
-annotation.processing.run.all.processors=true |
-annotation.processing.source.output=${build.generated.sources.dir}/ap-source-output |
-auxiliary.org-netbeans-modules-css-prep.less_2e_compiler_2e_options= |
-auxiliary.org-netbeans-modules-css-prep.less_2e_enabled=false |
-auxiliary.org-netbeans-modules-css-prep.less_2e_mappings=/less:/css |
-auxiliary.org-netbeans-modules-css-prep.sass_2e_compiler_2e_options= |
-auxiliary.org-netbeans-modules-css-prep.sass_2e_enabled=false |
-auxiliary.org-netbeans-modules-css-prep.sass_2e_mappings=/scss:/css |
-auxiliary.org-netbeans-modules-web-clientproject-api.js_2e_libs_2e_folder=js/libs |
-build.classes.dir=${build.web.dir}/WEB-INF/classes |
-build.classes.excludes=**/*.java,**/*.form |
-build.dir=build |
-build.generated.dir=${build.dir}/generated |
-build.generated.sources.dir=${build.dir}/generated-sources |
-build.test.classes.dir=${build.dir}/test/classes |
-build.test.results.dir=${build.dir}/test/results |
-build.web.dir=${build.dir}/web |
-build.web.excludes=${build.classes.excludes} |
-client.urlPart= |
-compile.jsps=false |
-conf.dir=${source.root}/conf |
-debug.classpath=${build.classes.dir}:${javac.classpath} |
-debug.test.classpath=\ |
- ${run.test.classpath} |
-display.browser=false |
-dist.dir=dist |
-dist.ear.war=${dist.dir}/${war.ear.name} |
-dist.javadoc.dir=${dist.dir}/javadoc |
-dist.war=${dist.dir}/${war.name} |
-endorsed.classpath=\ |
- ${libs.javaee-endorsed-api-6.0.classpath} |
-excludes= |
-includes=** |
-j2ee.compile.on.save=false |
-j2ee.copy.static.files.on.save=false |
-j2ee.deploy.on.save=false |
-j2ee.platform=1.6-web |
-j2ee.platform.classpath=${j2ee.server.home}/lib/annotations-api.jar:${j2ee.server.home}/lib/catalina-ant.jar:${j2ee.server.home}/lib/catalina-ha.jar:${j2ee.server.home}/lib/catalina-storeconfig.jar:${j2ee.server.home}/lib/catalina-tribes.jar:${j2ee.server.home}/lib/catalina.jar:${j2ee.server.home}/lib/ecj-4.4.jar:${j2ee.server.home}/lib/el-api.jar:${j2ee.server.home}/lib/jasper-el.jar:${j2ee.server.home}/lib/jasper.jar:${j2ee.server.home}/lib/jsp-api.jar:${j2ee.server.home}/lib/servlet-api.jar:${j2ee.server.home}/lib/tomcat-api.jar:${j2ee.server.home}/lib/tomcat-coyote.jar:${j2ee.server.home}/lib/tomcat-dbcp.jar:${j2ee.server.home}/lib/tomcat-i18n-es.jar:${j2ee.server.home}/lib/tomcat-i18n-fr.jar:${j2ee.server.home}/lib/tomcat-i18n-ja.jar:${j2ee.server.home}/lib/tomcat-jdbc.jar:${j2ee.server.home}/lib/tomcat-jni.jar:${j2ee.server.home}/lib/tomcat-spdy.jar:${j2ee.server.home}/lib/tomcat-util-scan.jar:${j2ee.server.home}/lib/tomcat-util.jar:${j2ee.server.home}/lib/tomcat-websocket.jar:${j2ee.server.home}/lib/websocket-api.jar |
-j2ee.server.type=Tomcat |
-jar.compress=false |
-javac.classpath=\ |
- ${libs.CSIP-Jersey-2.16.classpath}:\ |
- ${libs.PostgreSQLDriver.classpath}:\ |
- ${reference.csip-core-1.jar} |
-# Space-separated list of extra javac options |
-javac.compilerargs= |
-javac.debug=true |
-javac.deprecation=false |
-javac.processorpath=\ |
- ${javac.classpath} |
-javac.source=1.7 |
-javac.target=1.7 |
-javac.test.classpath=\ |
- ${javac.classpath}:\ |
- ${build.classes.dir}:\ |
- ${libs.junit_4.classpath} |
-javac.test.processorpath=\ |
- ${javac.test.classpath} |
-javadoc.additionalparam= |
-javadoc.author=false |
-javadoc.encoding=${source.encoding} |
-javadoc.noindex=false |
-javadoc.nonavbar=false |
-javadoc.notree=false |
-javadoc.preview=true |
-javadoc.private=false |
-javadoc.splitindex=true |
-javadoc.use=true |
-javadoc.version=false |
-javadoc.windowtitle= |
-lib.dir=${web.docbase.dir}/WEB-INF/lib |
-persistence.xml.dir=${conf.dir} |
-platform.active=JDK_1.7 |
-project.csip-core-1=../csip-core |
-reference.csip-core-1.jar=${project.csip-core-1}/dist/csip-core.jar |
-resource.dir=setup |
-rest.config.type=ide |
-run.test.classpath=\ |
- ${javac.test.classpath}:\ |
- ${build.test.classes.dir} |
-# Space-separated list of JVM arguments used when running a class with a main method or a unit test |
-# (you may also define separate properties like run-sys-prop.name=value instead of -Dname=value): |
-runmain.jvmargs= |
-source.encoding=UTF-8 |
-source.root=src |
-src.dir=${source.root}/java |
-test.src.dir=test |
-war.content.additional= |
-war.ear.name=${war.name} |
-war.name=csip-wqm.war |
-web.docbase.dir=web |
-webinf.dir=web/WEB-INF |
-======= |
-annotation.processing.enabled=true |
-annotation.processing.enabled.in.editor=true |
-annotation.processing.processors.list= |
-annotation.processing.run.all.processors=true |
-annotation.processing.source.output=${build.generated.sources.dir}/ap-source-output |
-auxiliary.org-netbeans-modules-css-prep.less_2e_compiler_2e_options= |
-auxiliary.org-netbeans-modules-css-prep.less_2e_enabled=false |
-auxiliary.org-netbeans-modules-css-prep.less_2e_mappings=/less:/css |
-auxiliary.org-netbeans-modules-css-prep.sass_2e_compiler_2e_options= |
-auxiliary.org-netbeans-modules-css-prep.sass_2e_enabled=false |
-auxiliary.org-netbeans-modules-css-prep.sass_2e_mappings=/scss:/css |
-auxiliary.org-netbeans-modules-web-clientproject-api.js_2e_libs_2e_folder=js/libs |
-build.classes.dir=${build.web.dir}/WEB-INF/classes |
-build.classes.excludes=**/*.java,**/*.form |
-build.dir=build |
-build.generated.dir=${build.dir}/generated |
-build.generated.sources.dir=${build.dir}/generated-sources |
-build.test.classes.dir=${build.dir}/test/classes |
-build.test.results.dir=${build.dir}/test/results |
-build.web.dir=${build.dir}/web |
-build.web.excludes=${build.classes.excludes} |
-client.urlPart= |
-compile.jsps=false |
-conf.dir=${source.root}/conf |
-debug.classpath=${build.classes.dir}:${javac.classpath} |
-debug.test.classpath=\ |
- ${run.test.classpath} |
-display.browser=false |
-dist.dir=dist |
-dist.ear.war=${dist.dir}/${war.ear.name} |
-dist.javadoc.dir=${dist.dir}/javadoc |
-dist.war=${dist.dir}/${war.name} |
-endorsed.classpath=\ |
- ${libs.javaee-endorsed-api-6.0.classpath} |
-excludes= |
-includes=** |
-j2ee.compile.on.save=false |
-j2ee.copy.static.files.on.save=false |
-j2ee.deploy.on.save=false |
-j2ee.platform=1.6-web |
-j2ee.platform.classpath=${j2ee.server.home}/lib/annotations-api.jar:${j2ee.server.home}/lib/catalina-ant.jar:${j2ee.server.home}/lib/catalina-ha.jar:${j2ee.server.home}/lib/catalina-storeconfig.jar:${j2ee.server.home}/lib/catalina-tribes.jar:${j2ee.server.home}/lib/catalina.jar:${j2ee.server.home}/lib/ecj-4.4.jar:${j2ee.server.home}/lib/el-api.jar:${j2ee.server.home}/lib/jasper-el.jar:${j2ee.server.home}/lib/jasper.jar:${j2ee.server.home}/lib/jsp-api.jar:${j2ee.server.home}/lib/servlet-api.jar:${j2ee.server.home}/lib/tomcat-api.jar:${j2ee.server.home}/lib/tomcat-coyote.jar:${j2ee.server.home}/lib/tomcat-dbcp.jar:${j2ee.server.home}/lib/tomcat-i18n-es.jar:${j2ee.server.home}/lib/tomcat-i18n-fr.jar:${j2ee.server.home}/lib/tomcat-i18n-ja.jar:${j2ee.server.home}/lib/tomcat-jdbc.jar:${j2ee.server.home}/lib/tomcat-jni.jar:${j2ee.server.home}/lib/tomcat-spdy.jar:${j2ee.server.home}/lib/tomcat-util-scan.jar:${j2ee.server.home}/lib/tomcat-util.jar:${j2ee.server.home}/lib/tomcat-websocket.jar:${j2ee.server.home}/lib/websocket-api.jar |
-j2ee.server.type=Tomcat |
-jar.compress=false |
-javac.classpath=\ |
- ${libs.PostgreSQLDriver.classpath}:\ |
- ${reference.csip-core-1.jar}:\ |
- ${libs.CSIP-Jersey-2.16.classpath} |
-# Space-separated list of extra javac options |
-javac.compilerargs= |
-javac.debug=true |
-javac.deprecation=false |
-javac.processorpath=\ |
- ${javac.classpath} |
-javac.source=1.7 |
-javac.target=1.7 |
-javac.test.classpath=\ |
- ${javac.classpath}:\ |
- ${build.classes.dir}:\ |
- ${libs.junit_4.classpath} |
-javac.test.processorpath=\ |
- ${javac.test.classpath} |
-javadoc.additionalparam= |
-javadoc.author=false |
-javadoc.encoding=${source.encoding} |
-javadoc.noindex=false |
-javadoc.nonavbar=false |
-javadoc.notree=false |
-javadoc.preview=true |
-javadoc.private=false |
-javadoc.splitindex=true |
-javadoc.use=true |
-javadoc.version=false |
-javadoc.windowtitle= |
-lib.dir=${web.docbase.dir}/WEB-INF/lib |
-persistence.xml.dir=${conf.dir} |
-platform.active=JDK_1.7 |
-project.csip-core=../csip-core |
-resource.dir=setup |
-rest.config.type=ide |
-run.test.classpath=\ |
- ${javac.test.classpath}:\ |
- ${build.test.classes.dir} |
-# Space-separated list of JVM arguments used when running a class with a main method or a unit test |
-# (you may also define separate properties like run-sys-prop.name=value instead of -Dname=value): |
-runmain.jvmargs= |
-source.encoding=UTF-8 |
-source.root=src |
-src.dir=${source.root}/java |
-test.src.dir=test |
-war.content.additional= |
-war.ear.name=${war.name} |
-war.name=csip-wqm.war |
-web.docbase.dir=web |
-webinf.dir=web/WEB-INF |
->>>>>>> other |
+<<<<<<< local |
+annotation.processing.enabled=true |
+annotation.processing.enabled.in.editor=true |
+annotation.processing.processors.list= |
+annotation.processing.run.all.processors=true |
+annotation.processing.source.output=${build.generated.sources.dir}/ap-source-output |
+auxiliary.org-netbeans-modules-css-prep.less_2e_compiler_2e_options= |
+auxiliary.org-netbeans-modules-css-prep.less_2e_enabled=false |
+auxiliary.org-netbeans-modules-css-prep.less_2e_mappings=/less:/css |
+auxiliary.org-netbeans-modules-css-prep.sass_2e_compiler_2e_options= |
+auxiliary.org-netbeans-modules-css-prep.sass_2e_enabled=false |
+auxiliary.org-netbeans-modules-css-prep.sass_2e_mappings=/scss:/css |
+auxiliary.org-netbeans-modules-web-clientproject-api.js_2e_libs_2e_folder=js/libs |
+build.classes.dir=${build.web.dir}/WEB-INF/classes |
+build.classes.excludes=**/*.java,**/*.form |
+build.dir=build |
+build.generated.dir=${build.dir}/generated |
+build.generated.sources.dir=${build.dir}/generated-sources |
+build.test.classes.dir=${build.dir}/test/classes |
+build.test.results.dir=${build.dir}/test/results |
+build.web.dir=${build.dir}/web |
+build.web.excludes=${build.classes.excludes} |
+client.urlPart= |
+compile.jsps=false |
+conf.dir=${source.root}/conf |
+debug.classpath=${build.classes.dir}:${javac.classpath} |
+debug.test.classpath=\ |
+ ${run.test.classpath} |
+display.browser=false |
+dist.dir=dist |
+dist.ear.war=${dist.dir}/${war.ear.name} |
+dist.javadoc.dir=${dist.dir}/javadoc |
+dist.war=${dist.dir}/${war.name} |
+endorsed.classpath=\ |
+ ${libs.javaee-endorsed-api-6.0.classpath} |
+excludes= |
+includes=** |
+j2ee.compile.on.save=false |
+j2ee.copy.static.files.on.save=false |
+j2ee.deploy.on.save=false |
+j2ee.platform=1.6-web |
+j2ee.platform.classpath=${j2ee.server.home}/lib/annotations-api.jar:${j2ee.server.home}/lib/catalina-ant.jar:${j2ee.server.home}/lib/catalina-ha.jar:${j2ee.server.home}/lib/catalina-tribes.jar:${j2ee.server.home}/lib/catalina.jar:${j2ee.server.home}/lib/ecj-4.2.2.jar:${j2ee.server.home}/lib/el-api.jar:${j2ee.server.home}/lib/jasper-el.jar:${j2ee.server.home}/lib/jasper.jar:${j2ee.server.home}/lib/jsp-api.jar:${j2ee.server.home}/lib/servlet-api.jar:${j2ee.server.home}/lib/tomcat-api.jar:${j2ee.server.home}/lib/tomcat-coyote.jar:${j2ee.server.home}/lib/tomcat-dbcp.jar:${j2ee.server.home}/lib/tomcat-i18n-es.jar:${j2ee.server.home}/lib/tomcat-i18n-fr.jar:${j2ee.server.home}/lib/tomcat-i18n-ja.jar:${j2ee.server.home}/lib/tomcat-jdbc.jar:${j2ee.server.home}/lib/tomcat-util.jar |
+j2ee.server.type=Tomcat |
+jar.compress=false |
+javac.classpath=\ |
+ ${libs.CSIP-Jersey-2.16.classpath}:\ |
+ ${libs.PostgreSQLDriver.classpath}:\ |
+ ${reference.csip-core-1.jar} |
+# Space-separated list of extra javac options |
+javac.compilerargs= |
+javac.debug=true |
+javac.deprecation=false |
+javac.processorpath=\ |
+ ${javac.classpath} |
+javac.source=1.7 |
+javac.target=1.7 |
+javac.test.classpath=\ |
+ ${javac.classpath}:\ |
+ ${build.classes.dir}:\ |
+ ${libs.junit_4.classpath} |
+javac.test.processorpath=\ |
+ ${javac.test.classpath} |
+javadoc.additionalparam= |
+javadoc.author=false |
+javadoc.encoding=${source.encoding} |
+javadoc.noindex=false |
+javadoc.nonavbar=false |
+javadoc.notree=false |
+javadoc.preview=true |
+javadoc.private=false |
+javadoc.splitindex=true |
+javadoc.use=true |
+javadoc.version=false |
+javadoc.windowtitle= |
+lib.dir=${web.docbase.dir}/WEB-INF/lib |
+persistence.xml.dir=${conf.dir} |
+platform.active=JDK_1.7 |
+project.csip-core-1=../csip-core |
+reference.csip-core-1.jar=${project.csip-core-1}/dist/csip-core.jar |
+resource.dir=setup |
+rest.config.type=ide |
+run.test.classpath=\ |
+ ${javac.test.classpath}:\ |
+ ${build.test.classes.dir} |
+# Space-separated list of JVM arguments used when running a class with a main method or a unit test |
+# (you may also define separate properties like run-sys-prop.name=value instead of -Dname=value): |
+runmain.jvmargs= |
+source.encoding=UTF-8 |
+source.root=src |
+src.dir=${source.root}/java |
+test.src.dir=test |
+war.content.additional= |
+war.ear.name=${war.name} |
+war.name=csip-wqm.war |
+web.docbase.dir=web |
+webinf.dir=web/WEB-INF |
+======= |
+annotation.processing.enabled=true |
+annotation.processing.enabled.in.editor=true |
+annotation.processing.processors.list= |
+annotation.processing.run.all.processors=true |
+annotation.processing.source.output=${build.generated.sources.dir}/ap-source-output |
+auxiliary.org-netbeans-modules-css-prep.less_2e_compiler_2e_options= |
+auxiliary.org-netbeans-modules-css-prep.less_2e_enabled=false |
+auxiliary.org-netbeans-modules-css-prep.less_2e_mappings=/less:/css |
+auxiliary.org-netbeans-modules-css-prep.sass_2e_compiler_2e_options= |
+auxiliary.org-netbeans-modules-css-prep.sass_2e_enabled=false |
+auxiliary.org-netbeans-modules-css-prep.sass_2e_mappings=/scss:/css |
+auxiliary.org-netbeans-modules-web-clientproject-api.js_2e_libs_2e_folder=js/libs |
+build.classes.dir=${build.web.dir}/WEB-INF/classes |
+build.classes.excludes=**/*.java,**/*.form |
+build.dir=build |
+build.generated.dir=${build.dir}/generated |
+build.generated.sources.dir=${build.dir}/generated-sources |
+build.test.classes.dir=${build.dir}/test/classes |
+build.test.results.dir=${build.dir}/test/results |
+build.web.dir=${build.dir}/web |
+build.web.excludes=${build.classes.excludes} |
+client.urlPart= |
+compile.jsps=false |
+conf.dir=${source.root}/conf |
+debug.classpath=${build.classes.dir}:${javac.classpath} |
+debug.test.classpath=\ |
+ ${run.test.classpath} |
+display.browser=false |
+dist.dir=dist |
+dist.ear.war=${dist.dir}/${war.ear.name} |
+dist.javadoc.dir=${dist.dir}/javadoc |
+dist.war=${dist.dir}/${war.name} |
+endorsed.classpath=\ |
+ ${libs.javaee-endorsed-api-6.0.classpath} |
+excludes= |
+includes=** |
+j2ee.compile.on.save=false |
+j2ee.copy.static.files.on.save=false |
+j2ee.deploy.on.save=false |
+j2ee.platform=1.6-web |
+j2ee.platform.classpath=${j2ee.server.home}/lib/annotations-api.jar:${j2ee.server.home}/lib/catalina-ant.jar:${j2ee.server.home}/lib/catalina-ha.jar:${j2ee.server.home}/lib/catalina-storeconfig.jar:${j2ee.server.home}/lib/catalina-tribes.jar:${j2ee.server.home}/lib/catalina.jar:${j2ee.server.home}/lib/ecj-4.4.jar:${j2ee.server.home}/lib/el-api.jar:${j2ee.server.home}/lib/jasper-el.jar:${j2ee.server.home}/lib/jasper.jar:${j2ee.server.home}/lib/jsp-api.jar:${j2ee.server.home}/lib/servlet-api.jar:${j2ee.server.home}/lib/tomcat-api.jar:${j2ee.server.home}/lib/tomcat-coyote.jar:${j2ee.server.home}/lib/tomcat-dbcp.jar:${j2ee.server.home}/lib/tomcat-i18n-es.jar:${j2ee.server.home}/lib/tomcat-i18n-fr.jar:${j2ee.server.home}/lib/tomcat-i18n-ja.jar:${j2ee.server.home}/lib/tomcat-jdbc.jar:${j2ee.server.home}/lib/tomcat-jni.jar:${j2ee.server.home}/lib/tomcat-spdy.jar:${j2ee.server.home}/lib/tomcat-util-scan.jar:${j2ee.server.home}/lib/tomcat-util.jar:${j2ee.server.home}/lib/tomcat-websocket.jar:${j2ee.server.home}/lib/websocket-api.jar |
+j2ee.server.type=Tomcat |
+jar.compress=false |
+javac.classpath=\ |
+ ${libs.PostgreSQLDriver.classpath}:\ |
+ ${reference.csip-core-1.jar}:\ |
+ ${libs.CSIP-Jersey-2.16.classpath} |
+# Space-separated list of extra javac options |
+javac.compilerargs= |
+javac.debug=true |
+javac.deprecation=false |
+javac.processorpath=\ |
+ ${javac.classpath} |
+javac.source=1.7 |
+javac.target=1.7 |
+javac.test.classpath=\ |
+ ${javac.classpath}:\ |
+ ${build.classes.dir}:\ |
+ ${libs.junit_4.classpath} |
+javac.test.processorpath=\ |
+ ${javac.test.classpath} |
+javadoc.additionalparam= |
+javadoc.author=false |
+javadoc.encoding=${source.encoding} |
+javadoc.noindex=false |
+javadoc.nonavbar=false |
+javadoc.notree=false |
+javadoc.preview=true |
+javadoc.private=false |
+javadoc.splitindex=true |
+javadoc.use=true |
+javadoc.version=false |
+javadoc.windowtitle= |
+lib.dir=${web.docbase.dir}/WEB-INF/lib |
+persistence.xml.dir=${conf.dir} |
+platform.active=JDK_1.7 |
+project.csip-core=../csip-core |
+resource.dir=setup |
+rest.config.type=ide |
+run.test.classpath=\ |
+ ${javac.test.classpath}:\ |
+ ${build.test.classes.dir} |
+# Space-separated list of JVM arguments used when running a class with a main method or a unit test |
+# (you may also define separate properties like run-sys-prop.name=value instead of -Dname=value): |
+runmain.jvmargs= |
+source.encoding=UTF-8 |
+source.root=src |
+src.dir=${source.root}/java |
+test.src.dir=test |
+war.content.additional= |
+war.ear.name=${war.name} |
+war.name=csip-wqm.war |
+web.docbase.dir=web |
+webinf.dir=web/WEB-INF |
+>>>>>>> other |
@@ -20,6 +20,7 @@ |
import java.util.Iterator; |
import java.util.Map; |
import java.util.Set; |
+import java.util.logging.Level; |
import javax.ws.rs.Path; |
import org.codehaus.jettison.json.JSONException; |
import org.codehaus.jettison.json.JSONObject; |
@@ -36,7 +37,7 @@ |
public class V1_0 extends ModelDataService { |
|
//mapunit/ssurgo polygon intersect URI |
- private final String SSURGO_INTERSECT_URI = "http://csip.engr.colostate.edu:8086/csip-erosion/d/soils/1.2"; |
+ private final String SSURGO_INTERSECT_URI = "http://csip.engr.colostate.edu:8090/csip-erosion/d/soils/1.2"; |
private final Double minimumPercentage = 0.05; |
|
//Request |
@@ -116,6 +117,7 @@ |
mapCount++; |
} |
query += ") AND ssurgo.component.comppct_r IS NOT NULL ORDER BY ssurgo.component.mukey, ssurgo.component.cokey, ssurgo.chorizon.chkey, ssurgo.chorizon.hzdept_r;"; |
+ LOG.log(Level.INFO, "WQM-02-polygon intersect query(118):" + query); |
resultSet = this.statement.executeQuery( query ); |
while( resultSet.next() ){ |
V1_0.Component tComponent; |
@@ -186,8 +188,11 @@ |
query = "With WT1 As (Select component.cokey, component.compname, component.comppct_r, MIN(cosoilmoist.soimoistdept_r) As wtbl_top_min, MAX(cosoilmoist.soimoistdepb_r) As wtbl_bot_max From ssurgo.component Inner Join ssurgo.comonth On component.cokey=comonth.cokey Inner Join ssurgo.cosoilmoist On comonth.comonthkey=cosoilmoist.comonthkey " |
+"Where " + lastQueryWhere + "and cosoilmoist.soimoiststat='Wet' Group By component.cokey, component.compname, component.comppct_r Order By component.cokey), WT2 As (Select WT1.cokey, WT1.compname, WT1.comppct_r, WT1.wtbl_top_min, WT1.wtbl_bot_max, MAX(cosoilmoist.soimoistdept_r) As nonwet_top_max From WT1 Left Outer Join ssurgo.comonth On WT1.cokey=comonth.cokey Left Outer Join ssurgo.cosoilmoist On comonth.comonthkey=cosoilmoist.comonthkey " |
+ "Where " + lastQueryWhere2 + " and (cosoilmoist.soimoiststat NOT IN ('Wet') OR cosoilmoist.soimoiststat IS NULL) Group By WT1.cokey, WT1.compname, WT1.comppct_r, WT1.wtbl_top_min, WT1.wtbl_bot_max) Select WT2.cokey, WT2.compname, WT2.comppct_r, WT2.wtbl_top_min, WT2.wtbl_bot_max, WT2.nonwet_top_max, case when (wtbl_bot_max < 183 or nonwet_top_max >= wtbl_bot_max) then 'Perched' else 'Apparent' end as wtkind from WT2"; |
+ |
+ LOG.log(Level.INFO, "WQM-02-polygon intersect query(189):" + query); |
resultSet = this.statement.executeQuery( query ); |
|
+ |
while ( resultSet.next() ){ |
String tCokey = resultSet.getString("cokey"); |
V1_0.Component tcomponent = this.componentMap.get(tCokey); |
@@ -283,6 +288,7 @@ |
public HashMap intersect(JSONObject aoaGeometry) { |
if ( this.aoa_mukeyList.isEmpty() ){ |
try{ |
+ LOG.log(Level.INFO, "polygon intersect URI:" + this.URI); |
JSONObject result; |
result = this.newClient.doPOST( this.URI, this.createRequest( aoaGeometry ) ); |
if (( null == result ) || ( result.length() <= 0 ) ){ |