Mercurial > dive4elements > river

annotate flys-backend/doc/documentation/de/overview.tex @ 4732:7fdddc6ba296

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Initial version of support files for TIMParser, comments and TODOs by Felix Wolfsteller, Code by Sascha Teichmann.
author Sascha Teichmann <sascha.teichmann@intevation.de>
date Fri, 28 Dec 2012 15:01:12 +0100
parents 16498764fca5
children d55ba61e9970 a56efdfcab17
rev   line source
3661
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
1 \section{�bersicht}
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
2
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
3 Diese Dokumentation beschreibt die von Intevation entwickelten Werkzeuge zum
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
4 Importieren der hydrologischen, morphologischen und geod�tischen Daten der BfG.
3668
2a3bc47d1ba9 Mention the structure of a river directory and describe the morphological file import in the german documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3667
diff changeset
5 Die im folgenden\\ beschriebenen Werkzeuge zum Importieren der fachlichen und
3661
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
6 geod�tischen Daten sind speziell auf das Verzeichnissystem der BfG ausgerichtet.
3668
2a3bc47d1ba9 Mention the structure of a river directory and describe the morphological file import in the german documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3667
diff changeset
7 Dabei wird angenommen, dass sich das Verzeichnis eines Gew�ssers auf oberster
2a3bc47d1ba9 Mention the structure of a river directory and describe the morphological file import in the german documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3667
diff changeset
8 Ebene in drei Unterverzeichnisse aufgliedert:
2a3bc47d1ba9 Mention the structure of a river directory and describe the morphological file import in the german documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3667
diff changeset
9
2a3bc47d1ba9 Mention the structure of a river directory and describe the morphological file import in the german documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3667
diff changeset
10 \begin{itemize}
2a3bc47d1ba9 Mention the structure of a river directory and describe the morphological file import in the german documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3667
diff changeset
11 \item Geodaesie
2a3bc47d1ba9 Mention the structure of a river directory and describe the morphological file import in the german documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3667
diff changeset
12 \item Hydrologie
2a3bc47d1ba9 Mention the structure of a river directory and describe the morphological file import in the german documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3667
diff changeset
13 \item Morphologie
2a3bc47d1ba9 Mention the structure of a river directory and describe the morphological file import in the german documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3667
diff changeset
14 \end{itemize}
2a3bc47d1ba9 Mention the structure of a river directory and describe the morphological file import in the german documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3667
diff changeset
15
3661
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
16 Desweiteren beziehen sich die Befehle, die auf der Kommandozeile abgesetzt
3678
6185c15efccf Added hint for root permission in documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3672
diff changeset
17 werden, auf ein SuSE-Linux-Enterprise-Server Version 11. Bitte beachten Sie
6185c15efccf Added hint for root permission in documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3672
diff changeset
18 auch, dass einige der Befehle \textit{root}-Rechte ben�tigen.
3661
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
19
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
20 \subsection{Vorbereitungen}
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
21
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
22 \subsubsection{Entpacken des Datenimporters}
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
23
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
24 Damit die Software performant und korrekt ausgef�hrt werden kann, ist es
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
25 erforderlich, dass sie auf dem selben System installiert und ausgef�hrt wird,
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
26 wie auch die Datenbank installiert ist. Sollten Sie das Paket nicht auf dem
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
27 Zielsystem selbst heruntergeladen haben, sind ggf. weitere Werkzeuge notwendig.
3682
16498764fca5 Fixed typo.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3678
diff changeset
28 Im Fall, dass das Sie von einem Windows System auf das Zielsystem zugreifen
3661
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
29 wollen, k�nnen Sie beispielsweise folgende Werkzeuge verwenden:
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
30
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
31 \begin{itemize}
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
32 \item WinSCP \\
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
33 WinSCP ist ein Open Source Werkzeug zum Transferieren von Dateien zwischen zwei
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
34 Systemen. Um das heruntergeladene Paket auf das Zielsystem zu transferieren,
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
35 k�nnen Sie WinSCP benutzen. F�r weitere Informationen und den Gebrauch von
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
36 WinSCP lesen Sie bitte unter folgender Adresse nach:
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
37 \href{http://winscp.net/}{http://winscp.net/}.
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
38
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
39 \item Putty \\
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
40 Putty ist ein Open Source Werkzeug, mit dem Sie sich von einem Windows System
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
41 per SSH auf das Zielsystem verbinden k�nnen. Anschlie�end k�nnen Sie �ber die
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
42 Kommandozeile auf dem Zielsystem die Befehle, die in diesem Dokument beschrieben
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
43 sind, ausf�hren. F�r weitere Informationen zu Putty und dessen Gebrauch lesen
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
44 Sie bitte unter folgender Adresse nach: \href{http://www.putty.org/}
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
45 {http://www.putty.org/}.
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
46 \end{itemize}
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
47
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
48 Bitte beachten Sie, dass diese Werkzeuge nicht zur Installtion und zum Betrieb
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
49 der Software selbst notwendig sind!
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
50
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
51
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
52 \subsubsection{Vorbereiten der Datenbank}
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
53
3672
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
54 Nachdem Sie das Paket nun in das Heimatverzeichnis des Nutzers auf das
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
55 Zielsystem kopiert haben, entpacken Sie es mit folgenden Befehlen:
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
56
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
57 \begin{lstlisting}
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
58 cd ~
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
59 tar xvfz flys-importer.tar.gz
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
60 cd flys-importer
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
61 \end{lstlisting}
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
62
3661
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
63 Bevor die Importer verwendet werden k�nnen, ist es notwendig, dass eine leere
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
64 Oracle Datenbank vorhanden ist. Anschlie�end m�ssen folgende SQL Skripte in
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
65 diese Datenbank eingespielt werden:
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
66
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
67 \begin{enumerate}
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
68 \item oracle.sql \\
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
69 In diesem SQL Skript befindet sich das Schema zum Speichern der hydrologischen
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
70 Daten.
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
71
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
72 \item oracle-minfo.sql \\
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
73 In diesem SQL Skript befindet sich das Schema zum Speichern der morphologischen
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
74 Daten.
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
75
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
76 \item oracle-spatial.sql \\
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
77 In diesem SQL Skript befindet sich das Schema zum Speichern der geod�tischen
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
78 Daten.
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
79
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
80 \item oracle-spatial\_idx.sql \\
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
81 Mittels diesem SQL Skript werden die Indizes zum geod�tischen Datenbankschema\\
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
82 hinzugef�gt.
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
83
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
84 \item import-dems.sql \\
3672
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
85 In diesem Skript sind Befehle zum Einf�gen der digitalen Gel�ndemodelle
3661
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
86 enthalten. Die Dateipfade in diesem Skript sind so anzupassen, dass sie auf die
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
87 entsprechenden Gel�ndemodelle im Dateisystem verweisen. Es ist notwendig die
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
88 Pfade absolut anzugeben.
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
89
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
90 \end{enumerate}
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
91
3672
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
92 Zum Einspielen dieser Schemata setzen Sie folgende Befehle auf der Kommandozeile
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
93 ab. Beachten Sie, dass $sqlplus$ im Pfad liegen muss, und der Linux-Nutzer
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
94 dies Kommando ausf�hren k�nnen muss. Au�erdem sind $benutzername$ und $passwort$
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
95 entsprechend Ihres Datenbank-Zugangs anzupassen.
3667
9b08db037ee5 Fixes and structural changes in the german documentation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3661
diff changeset
96
3661
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
97 \begin{lstlisting}
3672
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
98 sqlplus benutzername/passwort @schema/oracle.sql
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
99 sqlplus benutzername/passwort @schema/oracle-minfo.sql
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
100 sqlplus benutzername/passwort @schema/oracle-spatial.sql
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
101 sqlplus benutzername/passwort @schema/oracle-spatial_idx.sql
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
102 sqlplus benutzername/passwort @schema/import-dems.sql
3661
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
103 \end{lstlisting}
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
104
http://dive4elements.wald.intevation.org