Changeset 27
- Timestamp:
- 02/28/13 14:38:27 (11 years ago)
- Location:
- trunk
- Files:
-
- 2 edited
-
models/swisstopo/user_content.txt (modified) (2 diffs)
-
tutorial/model_tutorial.tex (modified) (6 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/models/swisstopo/user_content.txt
r26 r27 221 221 166 Hsur301003 2 50 rivière Fluss 0 222 222 167 Hsur3 0 50 Border of Surface_Water_PLG Border of Surface_Water_PLG 0 223 168 Vlit402006 0 29 brèche Brekzie 224 169 Vlit402007 0 29 poudingue Konglomerat 225 170 Vlit402009 0 29 grès, indifférencié Sandstein, undifferenziert 226 171 Vlit402018 0 29 grès à galets Geröll führender Sandstein 227 172 Vlit402021 0 29 grès à nummulites Nummulitensandstein 228 173 Vlit402022 0 29 grès coquillier Muschelsandstein 229 174 Vlit402026 0 29 argilite Tonstein 230 175 Vlit402027 0 29 marne Mergelstein 231 176 Vlit402034 0 29 calcaire, indifférencié Kalkstein, undifferenziert 232 177 Vlit402035 0 29 calcaire siliceux Kieselkalk 233 178 Vlit402041 0 29 calcaire bréchique Kalkbrekzie 234 179 Vlit402043 0 29 calcaire à nummulites Nummulitenkalk 235 180 Vlit402047 0 29 calcaire d'eau douce Süsswasserkalk 236 181 Vlit402049 0 29 dolomie Dolomit 237 182 Vlit402052 0 29 radiolarite Radiolarit 238 183 Vlit402056 0 29 charbon, indifférencié Kohle, undifferenziert 239 184 Vlit402059 0 29 anthracite Anthrazit 240 185 Vlit402061 0 29 oolite ferrugineuse Eisenoolith 241 186 Vlit402063 0 29 roche phosphatée, indifférenciée phosphoritreiches Gestein, undifferenziert 242 187 Vlit402071 0 29 anhydrite Anhydrit 243 188 Vlit402072 0 29 gypse Gips 244 189 Vlit402073 0 29 sel Steinsalz 245 190 Vlit402094 0 29 calcrète Krustenkalk 246 191 Vlit403026 0 29 roche filonienne, indifférenciée Ganggestein, undifferenziert 247 192 Vlit403027 0 29 microgranite Mikrogranit 248 193 Vlit403029 0 29 pegmatite Pegmatit 249 194 Vlit403030 0 29 aplite Aplit 250 195 Vlit403033 0 29 lamprophyre Lamprophyr 251 196 Vlit403039 0 29 roche effusive, indifférenciée Ergussgestein, undifferenziert 252 197 Vlit403041 0 29 rhyolite Rhyolith 253 198 Vlit403053 0 29 roche pyroclastique, indifférenciée pyroklastisches Gestein, undifferenziert 254 199 Vlit403060 0 29 roche volcano-sédimentaire, indifférenciée Tuffit, undifferenziert 255 200 Vlit403066 0 29 bentonite Bentonit 256 201 Vlit404005 0 29 kakirite, indifférenciée Kakirit, undifferenziert 257 202 Vlit404010 0 29 cataclasite, indifférenciée Kataklasit, undifferenziert 258 203 Vlit404018 0 29 mylonite, indifférenciée Mylonit, undifferenziert 259 204 Vlit404023 0 29 phyllonite Phyllonit 260 205 Vlit404025 0 29 pseudotachylite Pseudotachylit 261 206 Vlit404056 0 29 roche à calcsilicates Kalksilikatfels 262 207 Vlit404057 0 29 marbre Marmor 263 208 Vlit404062 0 29 amphibolite Amphibolit 264 209 Vlit404067 0 29 hornfels Hornfels 265 210 Vlit404070 0 29 skarn Skarn 266 211 Vlit404071 0 29 greisen Greisen 223 168 Vlit402006 0 29 brèche Brekzie 0 224 169 Vlit402007 0 29 poudingue Konglomerat 0 225 170 Vlit402009 0 29 grès, indifférencié Sandstein, undifferenziert 0 226 171 Vlit402018 0 29 grès à galets Geröll führender Sandstein 0 227 172 Vlit402021 0 29 grès à nummulites Nummulitensandstein 0 228 173 Vlit402022 0 29 grès coquillier Muschelsandstein 0 229 174 Vlit402026 0 29 argilite Tonstein 0 230 175 Vlit402027 0 29 marne Mergelstein 0 231 176 Vlit402034 0 29 calcaire, indifférencié Kalkstein, undifferenziert 0 232 177 Vlit402035 0 29 calcaire siliceux Kieselkalk 0 233 178 Vlit402041 0 29 calcaire bréchique Kalkbrekzie 0 234 179 Vlit402043 0 29 calcaire à nummulites Nummulitenkalk 0 235 180 Vlit402047 0 29 calcaire d'eau douce Süsswasserkalk 0 236 181 Vlit402056 0 29 charbon, indifférencié Kohle, undifferenziert 0 237 182 Vlit402059 0 29 anthracite Anthrazit 0 238 183 Vlit402061 0 29 oolite ferrugineuse Eisenoolith 0 239 184 Vlit402063 0 29 roche phosphatée, indifférenciée phosphoritreiches Gestein, undifferenziert 0 240 185 Vlit402094 0 29 calcrète Krustenkalk 0 241 186 Vlit403053 0 29 roche pyroclastique, indifférenciée pyroklastisches Gestein, undifferenziert 0 242 187 Vlit403060 0 29 roche volcano-sédimentaire, indifférenciée Tuffit, undifferenziert 0 243 188 Vlit403066 0 29 bentonite Bentonit 0 267 244 268 245 attributs … … 379 356 16 3 Main_Com 110 Rbed311003 roche sédimentaire indifférenciée Sedimentgestein undifferenziert 380 357 16 3 Main_Com 111 Rbed311004 argillite Tonstein 381 16 3 Main_Com 112 Rbed3110 22marne Mergelstein358 16 3 Main_Com 112 Rbed311010 marne Mergelstein 382 359 16 3 Main_Com 113 Rbed311005 roche calcaire Kalkstein 383 360 16 3 Main_Com 114 Rbed311006 roche dolomitique Dolomitstein -
trunk/tutorial/model_tutorial.tex
r21 r27 36 36 37 37 \begin{figure} [htbp] 38 39 40 41 38 \centering 39 \includegraphics[width=1\textwidth]{img/workflow.pdf} 40 \caption{Conceptual workflow} 41 \label{fig:conceptual-workflow} 42 42 \end{figure} 43 43 … … 45 45 46 46 \section{Data needed} 47 In order work, TmDmCreator needs the following files:47 For proper operation, TmDmCreator requires the following files: 48 48 %\begin{itemize} 49 49 \begin{description*} 50 50 \item[base\_structure.sql]\hfill \\ contains the necessary SQL code base for all ToolMap projects. This file should normally not be edited by users 51 51 \item[user\_structure.sql]\hfill \\ contains the SQL structure describing the layers attributes … … 74 74 75 75 \begin{figure} [hbp] 76 77 78 79 76 \centering 77 \includegraphics[width=.6\textwidth]{img/layers.png} 78 \caption{List of layers as shown in user\_content.txt} 79 \label{fig:layers} 80 80 \end{figure} 81 81 … … 97 97 98 98 \begin{figure} [hbp] 99 100 101 102 99 \centering 100 \includegraphics[height=.9\textheight]{img/objects.png} 101 \caption{Objects structure as described in user\_content.txt} 102 \label{fig:objects} 103 103 \end{figure} 104 104 … … 111 111 -- layer_at1 -- 112 112 CREATE TABLE `layer_at1` ( 113 114 115 116 113 `OBJECT_ID` int(10) unsigned NOT NULL, 114 -- add user attributes here -- 115 PRIMARY KEY (`OBJECT_ID`), 116 KEY `LAYER_ATX_FKIndex1` (`OBJECT_ID`) 117 117 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 118 118 \end{lstlisting} 119 119 This code is the basic template for creating an attribute table. The number after layer\_at (see line 2) indicates the layer index and refers to the LAYER\_INDEX column in user\_content.txt. In our example layer\_at1 describe the attributes for the layer Boreholes\_PT. User attributes can then be added on line 4 of this template. 120 120 Below are described the five attributes that can be used in a ToolMap data model as well as the corresponding SQL code 121 122 121 123 \subsubsection {Enumeration} 122 124 \label{sec:enumeration} 123 \crealplisting{SQL} 124 \begin{lstlisting} 125 `D_C_UNDERG` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 126 \end{lstlisting} 127 If you add such fields, then you must also fill the list of supported values (see section~\ref{sec:attribute-values}). 128 \subsubsection {Text} 129 \begin{lstlisting} 130 `DESCRIPT` varchar(255) DEFAULT NULL, 131 \end{lstlisting} 132 The number next to the keyword varchar indicates the maximum text length. 133 \subsubsection {Integer} 134 \begin{lstlisting} 135 `NUM_REF` int(11) DEFAULT NULL, 136 \end{lstlisting} 137 There is no special option for integer fields 138 \subsubsection {Float} 125 \crealplisting{SQL} 126 \begin{lstlisting} 127 `D_C_UNDERG` int(11) DEFAULT NULL COMMENT 'ENUMERATION', 128 \end{lstlisting} 129 If you add such fields, then you must also fill the list of supported values (see section~\ref{sec:attribute-values}). 130 \subsubsection {Text} 131 \begin{lstlisting} 132 `DESCRIPT` varchar(255) DEFAULT NULL, 133 \end{lstlisting} 134 The number next to the keyword varchar indicates the maximum text length. 135 \subsubsection {Integer} 136 \begin{lstlisting} 137 `NUM_REF` int(11) DEFAULT NULL, 138 \end{lstlisting} 139 There is no special option for integer fields 139 140 140 \begin{lstlisting}141 `TEMP` decimal(5,2) DEFAULT NULL,142 \end{lstlisting}143 The two digits next to the keyword decimal indicate the field precision and scale. In this example, 5 is the precision and 2 is the scale. The precision represents the number of significant digits that are stored for values, and the scale represents the number of digits that can be stored following the decimal point. In this case, values that can be stored range from -999.99 to 999.99.144 \subsubsection {Date}145 141 146 \begin{lstlisting} 147 `REF_DATE` date DEFAULT NULL, 148 \end{lstlisting} 149 There is no special option for date fields 142 \subsubsection {Float} 143 144 \begin{lstlisting} 145 `TEMP` decimal(5,2) DEFAULT NULL, 146 \end{lstlisting} 147 The two digits next to the keyword decimal indicate the field precision and scale. In this example, 5 is the precision and 2 is the scale. The precision represents the number of significant digits that are stored for values, and the scale represents the number of digits that can be stored following the decimal point. In this case, values that can be stored range from -999.99 to 999.99. 148 \subsubsection {Date} 149 150 \begin{lstlisting} 151 `REF_DATE` date DEFAULT NULL, 152 \end{lstlisting} 153 There is no special option for date fields 150 154 151 155 … … 165 169 166 170 \begin{figure} [htbp] 167 168 169 170 171 \centering 172 \includegraphics[width=.9\textwidth]{img/attributs.png} 173 \caption{Attributes section structure} 174 \label{fig:attributs} 171 175 \end{figure} 172 176
Note: See TracChangeset
for help on using the changeset viewer.
