diff doc/config-manual/model_of_transitions.tex @ 942:c53a39cb7809

Moved section Query-configuration to Section Model of Transitions. doc/trunk@1085 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Mon, 10 May 2010 13:07:04 +0000
parents 7a8f9eb9fb04
children 8e02d5f567df
line wrap: on
line diff
--- a/doc/config-manual/model_of_transitions.tex	Mon May 10 12:53:17 2010 +0000
+++ b/doc/config-manual/model_of_transitions.tex	Mon May 10 13:07:04 2010 +0000
@@ -455,6 +455,35 @@
 ORDER BY m.ZLOCATION DESC
 \end{lstlisting}
 
+The queries which are shown above are configurable.
+You can do this in the file {\tt queries.properties } which will
+be explained in the next paragraph.
+
+\paragraph{Query-configuration (queries.properties)}
+
+This file contains key-value-pairs to define SQL-statements.
+All queries will be handle using the prepared-statement-syntax using "?"
+to define a place where an dynamic value should be placed into the statement.
+ 
+There is one special implementation to support spatial access to the 
+{\tt ArcSDE}, because the {\tt ArcSDE} does not support the access to 
+spatial objects using the definition of the Simple Feature Specification for 
+SQL of the OGC.
+
+It was necessary to implement this mechanism to realize the access to spatial-
+objects.
+
+All queries which contains the following literals will be handle separate
+using the {\tt ArcSDE-API}.
+
+\begin{itemize}
+    \item {\tt ST\_ASTEXT(SHAPE)}: Will return the geometry as an WellKnowText (WKT)
+    \item {\tt ST\_ASTEXT(RASTER)}: Will return the raster in an readable way.
+    \item {\tt INTERSECTS(SHAPE,"?")}: Will only return the elements which geometry
+                                 intersects the given geometry ("?" will be
+                                 replace with an WKT)
+\end{itemize}
+
 
 \paragraph{Transitions}
 

http://dive4elements.wald.intevation.org