# HG changeset patch # User Ingo Weinzierl # Date 1326277036 0 # Node ID bf598599782a6ea301bda6615b648234fe41803a # Parent 8cb679d4ec490f4822f1b27abe39513b82e6da76 Made old calculation results available for floodmaps. flys-artifacts/trunk@3644 c6561f87-3c4e-4783-a992-168aeb5c3f6f diff -r 8cb679d4ec49 -r bf598599782a flys-artifacts/ChangeLog --- a/flys-artifacts/ChangeLog Tue Jan 10 11:50:01 2012 +0000 +++ b/flys-artifacts/ChangeLog Wed Jan 11 10:17:16 2012 +0000 @@ -1,3 +1,8 @@ +2012-01-11 Ingo Weinzierl + + * doc/conf/meta-data.xml: Added the definition of old calculation results + for floodmaps. + 2012-01-10 Ingo Weinzierl * src/main/java/de/intevation/flys/artifacts/model/WMSLayerFacet.java: Added diff -r 8cb679d4ec49 -r bf598599782a flys-artifacts/doc/conf/meta-data.xml --- a/flys-artifacts/doc/conf/meta-data.xml Tue Jan 10 11:50:01 2012 +0000 +++ b/flys-artifacts/doc/conf/meta-data.xml Wed Jan 11 10:17:16 2012 +0000 @@ -874,6 +874,44 @@ + + SHOW FLOODMAPS + + + + + + + + SELECT m.id AS a_id, m.state AS a_state, m.gid AS a_gid, m.creation AS a_creation + FROM master_artifacts m + WHERE m.collection_id = ${collection_id} AND m.gid <> CAST(${artifact-id} AS uuid) + AND EXISTS ( + SELECT id FROM artifact_data ad WHERE ad.artifact_id = m.id AND k = 'river' AND v = ${river}) + + + + + SELECT a.gid as aid, f.id AS fid, f.name AS facet_name, f.num AS facet_num, f.description as facet_description + FROM outs as o, facets as f, artifacts as a + WHERE f.name = 'floodmap.wsplgen' and f.out_id = o.id and o.artifact_id = ${a_id} and a.id = ${a_id} + + + + + + + + + + + + + + + + +