Mercurial > dive4elements > gnv-client
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 941:7a8f9eb9fb04 | 942:c53a39cb7809 |
|---|---|
| 452 M.FEATUREID = 100011 AND | 452 M.FEATUREID = 100011 AND |
| 453 M.FEATUREID = 100011 AND | 453 M.FEATUREID = 100011 AND |
| 454 P.PARAMETERID IN (2) | 454 P.PARAMETERID IN (2) |
| 455 ORDER BY m.ZLOCATION DESC | 455 ORDER BY m.ZLOCATION DESC |
| 456 \end{lstlisting} | 456 \end{lstlisting} |
| 457 | |
| 458 The queries which are shown above are configurable. | |
| 459 You can do this in the file {\tt queries.properties } which will | |
| 460 be explained in the next paragraph. | |
| 461 | |
| 462 \paragraph{Query-configuration (queries.properties)} | |
| 463 | |
| 464 This file contains key-value-pairs to define SQL-statements. | |
| 465 All queries will be handle using the prepared-statement-syntax using "?" | |
| 466 to define a place where an dynamic value should be placed into the statement. | |
| 467 | |
| 468 There is one special implementation to support spatial access to the | |
| 469 {\tt ArcSDE}, because the {\tt ArcSDE} does not support the access to | |
| 470 spatial objects using the definition of the Simple Feature Specification for | |
| 471 SQL of the OGC. | |
| 472 | |
| 473 It was necessary to implement this mechanism to realize the access to spatial- | |
| 474 objects. | |
| 475 | |
| 476 All queries which contains the following literals will be handle separate | |
| 477 using the {\tt ArcSDE-API}. | |
| 478 | |
| 479 \begin{itemize} | |
| 480 \item {\tt ST\_ASTEXT(SHAPE)}: Will return the geometry as an WellKnowText (WKT) | |
| 481 \item {\tt ST\_ASTEXT(RASTER)}: Will return the raster in an readable way. | |
| 482 \item {\tt INTERSECTS(SHAPE,"?")}: Will only return the elements which geometry | |
| 483 intersects the given geometry ("?" will be | |
| 484 replace with an WKT) | |
| 485 \end{itemize} | |
| 457 | 486 |
| 458 | 487 |
| 459 \paragraph{Transitions} | 488 \paragraph{Transitions} |
| 460 | 489 |
| 461 To move between two states it is necessary to configure dependencies between | 490 To move between two states it is necessary to configure dependencies between |