emoen

<?xml version="1.0" encoding="ISO-8859-1"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0
	http://maven.apache.org/maven-v4_0_0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>org.opengeo</groupId>
    <artifactId>mareano</artifactId>
    <packaging>war</packaging>

emoen

C:\prosjekt3\mareano_update\mareano>mvn clean install -Dmaven.test.skip
[INFO] Scanning for projects...
[INFO]
[INFO] ------------------------------------------------------------------------
[INFO] Building Mareano 2.3.1
[INFO] ------------------------------------------------------------------------
[WARNING] The artifact jstl:jstl:jar:1.1.2 has been relocated to javax.servlet:j
stl:jar:1.1.2
[INFO]
[INFO] --- maven-clean-plugin:2.4.1:clean (default-clean) @ mareano ---

emoen

<?xml version="1.0" encoding="UTF-8"?>
<project name="geoexplorer" default="help" basedir=".">

    <description>
        GeoExplorer Build File
    </description>

    <property name="war.src" location="target/${ant.project.name}-src"/>
    <property name="app.proxy.geoserver" value=""/>
    <property name="app.port" value="9080"/>

emoen

test:

buildjs:
    [mkdir] Created dir: C:\prosjekt3\mareano_update\New folder\mareano\build\ge
oexplorer2.4.3\WEB-INF\app\static\script
     [java] Can't find config file: folder\mareano\build/geoexplorer2.4.3/WEB-IN
F/app/static/script
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------

emoen

<?xml version="1.0" encoding="ISO-8859-1"?>
<StyledLayerDescriptor version="1.0.0"
	xmlns="http://www.opengis.net/sld" xmlns:ogc="http://www.opengis.net/ogc"
	xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://www.opengis.net/sld http://schemas.opengis.net/sld/1.0.0/StyledLayerDescriptor.xsd">
	<NamedLayer>
		<Name>postgis:areavalueNormar</Name>
		<UserStyle>
			<FeatureTypeStyle>
				<Rule>

emoen

<?xml version="1.0" encoding="UTF-8"?>
<StyledLayerDescriptor xmlns="http://www.opengis.net/sld" xmlns:ogc="http://www.opengis.net/ogc" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="1.0.0" xsi:schemaLocation="http://www.opengis.net/sld http://schemas.opengis.net/sld/1.0.0/StyledLayerDescriptor.xsd">
   <NamedLayer>
      <Name>postgis:areavalueNormar</Name>
      <UserStyle>
         <FeatureTypeStyle>
            <Rule>
               <Title>0 - Zero</Title>
               <ogc:Filter>
                  <ogc:And>

emoen

SELECT hid, id,value,gridname,periodname,depthlayername,parametername, 
    encode(ST_AsBinary(ST_Force_2D(geoshape)),'base64') as "geoshape"  
  FROM areavalue
  WHERE  gridname = 'NorMar' AND parametername = 'Test_febr2014' AND depthlayername = 'L10.0:20.0' AND 
    periodname =   'Q20001' AND value >= 0.0 AND value <= 19.0

emoen

SELECT hid,id,avg(value) OVER(PARTITION BY hid) as value,gridname,periodname,depthlayername,parametername,
    encode(ST_AsBinary(ST_Force_2D(geoshape)),'base64') as "geoshape" 
  FROM areavalue
  WHERE  gridname = 'NorMar' AND parametername = 'TrondTest_febr2014' AND depthlayername = 'L10.0:20.0' AND 
    (periodname = 'Q20001' OR periodname = 'Q20002') AND value >= 0.0 AND value <= 19.0

emoen

SELECT hid, id,value,gridname,periodname,depthlayername,parametername, 
    encode(ST_AsBinary(ST_Force_2D(geoshape)),'base64') as "geoshape"  
  FROM areavalue_new
  WHERE  gridname = 'NorMar' AND parametername = 'Test_febr2014' AND depthlayername = 'L10.0:20.0' AND 
    periodname = 'Q20001' AND value >= 0.0 AND value <= 19.0

emoen

CREATE OR REPLACE FUNCTION public.areavalue_with_avg_value(IN grid_id bigint, IN parameter_id bigint, IN depthlayernametext text, IN periodnametext text, IN value1 numeric, IN value2 numeric)
  RETURNS TABLE(hid bigint, id bigint, value double precision, gridname character varying, periodname character varying, depthlayername character varying, parametername character varying, geoshape geometry) AS
$BODY$	
    DECLARE
      sql text;
      depthlayernameIn text[];
      periodnameIn text[];
    BEGIN
     sql := $$select hid, id ,avg(value) OVER(PARTITION BY hid) as value,gridname,periodname,depthlayername,parametername, geoshape from areavalue WHERE  id_grid =   $$ || grid_id || $$ AND parameter_id =  $$ || parameter_id || $$ AND ($$;