Mercurial > dive4elements > river

annotate flys-backend/doc/documentation/de/overview.tex @ 3672:1cb3b9708d99

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Describe unpack process and schema creation. flys-backend/trunk@5303 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Ingo Weinzierl <ingo.weinzierl@intevation.de>
date Thu, 30 Aug 2012 07:57:32 +0000
parents 2a3bc47d1ba9
children 6185c15efccf
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
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
17 werden, auf ein SuSE-Linux-Enterprise-Server Version 11.
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
18
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
19 \subsection{Vorbereitungen}
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
20
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
21 \subsubsection{Entpacken des Datenimporters}
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
22
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
23 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
24 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
25 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
26 Zielsystem selbst heruntergeladen haben, sind ggf. weitere Werkzeuge notwendig.
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
27 Im Fall, dass das Sie von einem Window System auf das Zielsystem zugreifen
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
28 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
29
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
30 \begin{itemize}
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
31 \item WinSCP \\
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
32 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
33 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
34 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
35 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
36 \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
37
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
38 \item Putty \\
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
39 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
40 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
41 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
42 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
43 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
44 {http://www.putty.org/}.
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
45 \end{itemize}
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
46
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
47 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
48 der Software selbst notwendig sind!
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
49
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 \subsubsection{Vorbereiten der Datenbank}
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
52
3672
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
53 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
54 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
55
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
56 \begin{lstlisting}
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
57 cd ~
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
58 tar xvfz flys-importer.tar.gz
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
59 cd flys-importer
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
60 \end{lstlisting}
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
61
3661
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
62 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
63 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
64 diese Datenbank eingespielt werden:
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
65
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
66 \begin{enumerate}
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
67 \item oracle.sql \\
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
68 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
69 Daten.
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
70
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
71 \item oracle-minfo.sql \\
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
72 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
73 Daten.
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
74
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
75 \item oracle-spatial.sql \\
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
76 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
77 Daten.
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
78
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
79 \item oracle-spatial\_idx.sql \\
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
80 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
81 hinzugef�gt.
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
82
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
83 \item import-dems.sql \\
3672
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
84 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
85 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
86 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
87 Pfade absolut anzugeben.
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
88
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
89 \end{enumerate}
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
90
3672
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
91 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
92 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
93 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
94 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
95
3661
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
96 \begin{lstlisting}
3672
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
97 sqlplus benutzername/passwort @schema/oracle.sql
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
98 sqlplus benutzername/passwort @schema/oracle-minfo.sql
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
99 sqlplus benutzername/passwort @schema/oracle-spatial.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_idx.sql
1cb3b9708d99 Describe unpack process and schema creation.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 3668
diff changeset
101 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
102 \end{lstlisting}
3ea5e835ecce Initial checkin of documentation of importer and shape importer.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
103
http://dive4elements.wald.intevation.org