Mercurial > dive4elements > gnv-client
comparison gnv-artifacts/doc/conf/queries.properties @ 1091:fb2d07f7a5ae
Added configuration and sql statements for a new product named 'Achsenparalleler Vertikalschnitt.
gnv-artifacts/trunk@1205 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Sat, 12 Jun 2010 13:06:40 +0000 |
| parents | 9bb1979aabbe |
| children | e38f93d64253 |
comparison
equal
deleted
inserted
replaced
| 1090:51f3edc9d743 | 1091:fb2d07f7a5ae |
|---|---|
| 1794 order by msv.TIMEVALUE, \ | 1794 order by msv.TIMEVALUE, \ |
| 1795 MEDIAN.MESHPOINT.JPOSITION, \ | 1795 MEDIAN.MESHPOINT.JPOSITION, \ |
| 1796 MEDIAN.MESHPOINT.IPOSITION, \ | 1796 MEDIAN.MESHPOINT.IPOSITION, \ |
| 1797 MEDIAN.MESHPOINT.KPOSITION, \ | 1797 MEDIAN.MESHPOINT.KPOSITION, \ |
| 1798 msv.PARAMETERID | 1798 msv.PARAMETERID |
| 1799 | 1799 |
| 1800 ############################################## | |
| 1801 #### Special case of VerticalCrossSection #### | |
| 1802 ############################################## | |
| 1803 verticalcrosssection_mesh_parallel_linestring = SELECT ST_ASTEXT(SHAPE), \ | |
| 1804 IPOSITION, \ | |
| 1805 JPOSITION \ | |
| 1806 from MEDIAN.MESHLAYER ml, \ | |
| 1807 MEDIAN.MESHPOINT, \ | |
| 1808 MEDIAN.MESH m, \ | |
| 1809 MEDIAN.MESHSCALARVALUE msv \ | |
| 1810 where msv.FEATUREID = MEDIAN.MESHPOINT.FEATUREID AND \ | |
| 1811 ml.KPOSITION = MEDIAN.MESHPOINT.KPOSITION and \ | |
| 1812 ml.MESHID = MEDIAN.MESHPOINT.MESHID and \ | |
| 1813 m.MESHID = MEDIAN.MESHPOINT.MESHID AND \ | |
| 1814 m.PARTIDMIN <= msv.PARTID AND \ | |
| 1815 m.PARTIDMAX >= msv.PARTID AND \ | |
| 1816 msv.PARAMETERID in (?) AND \ | |
| 1817 msv.TIMEVALUE in (?) AND \ | |
| 1818 m.OBJECTID = ? AND \ | |
| 1819 MEDIAN.MESHPOINT.FEATUREID in \ | |
| 1820 ( select FEATUREID \ | |
| 1821 from MEDIAN.MESHPOINT mp, \ | |
| 1822 MEDIAN.MESH m \ | |
| 1823 where m.OBJECTID = ? AND \ | |
| 1824 mp.MESHID = m.MESHID AND \ | |
| 1825 KPOSITION in ( 1 ) and \ | |
| 1826 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \ | |
| 1827 order by MEDIAN.MESHPOINT.JPOSITION, \ | |
| 1828 MEDIAN.MESHPOINT.IPOSITION | |
| 1829 | |
| 1800 ############################################# | 1830 ############################################# |
| 1801 ############################################# | 1831 ############################################# |
| 1802 ########## Horizontalschnitt MESH ########### | 1832 ########## Horizontalschnitt MESH ########### |
| 1803 ############################################# | 1833 ############################################# |
| 1804 ############################################# | 1834 ############################################# |