# HG changeset patch # User Ingo Weinzierl # Date 1331216469 0 # Node ID 631dabad9b48b71b6f54de183b51c5f6355d3e12 # Parent afebbe9c2fcecbac0403bf7b6e26369f189ad35b Modified the datacage structure of 'floodmaps'. flys-artifacts/trunk@4132 c6561f87-3c4e-4783-a992-168aeb5c3f6f diff -r afebbe9c2fce -r 631dabad9b48 flys-artifacts/ChangeLog --- a/flys-artifacts/ChangeLog Thu Mar 08 13:44:51 2012 +0000 +++ b/flys-artifacts/ChangeLog Thu Mar 08 14:21:09 2012 +0000 @@ -1,3 +1,7 @@ +2012-03-08 Ingo Weinzierl + + * doc/conf/meta-data.xml: Modified the datacage structure of 'floodmaps'. + 2012-03-08 Ingo Weinzierl * src/main/java/de/intevation/flys/artifacts/WMSFloodmapsArtifact.java: New. diff -r afebbe9c2fce -r 631dabad9b48 flys-artifacts/doc/conf/meta-data.xml --- a/flys-artifacts/doc/conf/meta-data.xml Thu Mar 08 13:44:51 2012 +0000 +++ b/flys-artifacts/doc/conf/meta-data.xml Thu Mar 08 14:21:09 2012 +0000 @@ -705,76 +705,84 @@ - - - SELECT count(*) as uesg_exist, name as name - FROM floodmaps - WHERE river_id = ${river_id} AND kind = 111 - GROUP BY name, kind - - - - - - - - - - - - - - SELECT count(*) as uesg_exist, name as name - FROM floodmaps - WHERE river_id = ${river_id} AND kind = 112 - GROUP BY name, kind - - - - - - - - - - - + + + + SELECT count(*) as uesg_exist, name as name + FROM floodmaps + WHERE river_id = ${river_id} AND kind = 111 + GROUP BY name, kind + + + + + + + + + + + + + + + + SELECT count(*) as uesg_exist, name as name + FROM floodmaps + WHERE river_id = ${river_id} AND kind = 112 + GROUP BY name, kind + + + + + + + + + + + + - - - SELECT count(*) as uesg_exist, name as name - FROM floodmaps - WHERE river_id = ${river_id} AND kind = 121 - GROUP BY name, kind - - - - - - - - - - - - - - SELECT count(*) as uesg_exist, name as name - FROM floodmaps - WHERE river_id = ${river_id} AND kind = 122 - GROUP BY name, kind - - - - - - - - - - - + + + + SELECT count(*) as uesg_exist, name as name + FROM floodmaps + WHERE river_id = ${river_id} AND kind = 121 + GROUP BY name, kind + + + + + + + + + + + + + + + + SELECT count(*) as uesg_exist, name as name + FROM floodmaps + WHERE river_id = ${river_id} AND kind = 122 + GROUP BY name, kind + + + + + + + + + + + +