# HG changeset patch # User Andre Heinecke # Date 1364394445 -3600 # Node ID ba1bf40a9787d1a79119c2e75df016e7302aba6f # Parent c8e74e5e828c50bff99f389508fd4fe6db63c76b Restructure datacage to have a route_data folder and add QPS in a more detailed manner in that folder diff -r c8e74e5e828c -r ba1bf40a9787 flys-artifacts/doc/conf/meta-data.xml --- a/flys-artifacts/doc/conf/meta-data.xml Wed Mar 27 15:26:28 2013 +0100 +++ b/flys-artifacts/doc/conf/meta-data.xml Wed Mar 27 15:27:25 2013 +0100 @@ -1150,18 +1150,49 @@ + Grab only the actual first - SELECT count(*) as km_exists - FROM cross_section_tracks WHERE river_id = ${river_id} + SELECT DISTINCT + cs.kind_id as kind_id, + ck.name as kind_name + FROM cross_section_tracks cs + JOIN cross_section_track_kinds ck on cs.kind_id = ck.id + WHERE river_id = ${river_id} + AND kind_id=1 - - - + + + + - - - - + + + + + + + Now the other tracks + + SELECT DISTINCT + cs.kind_id as kind_id, + ck.name as kind_name, + cs.name as layer_name + FROM cross_section_tracks cs + JOIN cross_section_track_kinds ck on cs.kind_id = ck.id + WHERE river_id = ${river_id} + AND kind_id=0 + + + + + + + + + + + + @@ -1517,7 +1548,6 @@ - @@ -1709,6 +1739,20 @@ + + + + + + + + + + + + + + @@ -1716,25 +1760,18 @@ - - - + + + + + + + + - - - - - - - - - - - -