--- a/gnv-artifacts/doc/conf/queries.properties	Thu Nov 05 14:45:54 2009 +0000
+++ b/gnv-artifacts/doc/conf/queries.properties	Thu Nov 05 15:16:51 2009 +0000
@@ -226,6 +226,20 @@
     WHERE SOURCEID IN (?) \
     order by m.NAME
     
+verticalprofile_mesh_with_area = SELECT M.OBJECTID KEY, \
+         M.NAME VALUE \
+     FROM MEDIAN.MESHPOINT, \
+          MEDIAN.MESH M \
+     WHERE M.SOURCEID IN (?) AND \
+           M.MESHID = MEDIAN.MESHPOINT.MESHID AND \
+           INTERSECTS(SHAPE, \
+                      (SELECT st_astext(SHAPE) \
+                       FROM MEDIAN.FEATUREAREA \
+                       WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \
+                              FEATURECODE = ? )\
+                      ) \
+     order by M.NAME
+    
 verticalprofile_mesh_point = SELECT FEATUREID, \
         ST_ASTEXT(SHAPE) \
     FROM MEDIAN.MESHPOINT \
@@ -639,4 +653,22 @@
           M.OBJECTID = ? AND \
           MEDIAN.MESHFACE.KPOSITION = ? \
     order by MEDIAN.MESHFACE.JPOSITION , \
-             MEDIAN.MESHFACE.IPOSITION
\ No newline at end of file
+             MEDIAN.MESHFACE.IPOSITION
+             
+             
+area_filter = SELECT DISTINCT \
+       FEATUREID KEY ,\
+       DESCRIPTION VALUE \
+    FROM MEDIAN.FEATUREAREA \
+    WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \
+          FEATUREID > 0 \
+    ORDER BY FEATUREID
+    
+subarea_filter = SELECT \
+       FEATURECODE KEY, \
+       NAME VALUE \
+    FROM MEDIAN.FEATUREAREA \
+    WHERE (FEATURETYPE = 7 OR FEATURETYPE = 8) AND \
+          FEATUREID = ? \
+    ORDER BY NAME
+    
\ No newline at end of file