Geodb hierarchies: Unterschied zwischen den Versionen
OpenGeoDB & GISWiki - Das freie Portal für Geoinformatik (GIS)
HeinzJ (Diskussion | Beiträge) (→Definition) |
HeinzJ (Diskussion | Beiträge) (→Definition) |
||
Zeile 451: | Zeile 451: | ||
</code> | </code> | ||
+ | |||
+ | ==Beispieldatensätze== | ||
+ | |||
+ | <table {{prettytable}}> | ||
+ | <tr> | ||
+ | <th>loc_id</th> | ||
+ | <th>level</th> | ||
+ | <th>id_lvl1</th> | ||
+ | <th>id_lvl2</th> | ||
+ | <th>id_lvl3</th> | ||
+ | <th>id_lvl4</th> | ||
+ | <th>id_lvl5</th> | ||
+ | <th>id_lvl6</th> | ||
+ | <th>id_lvl7</th> | ||
+ | <th>id_lvl8</th> | ||
+ | <th>id_lvl9</th> | ||
+ | <th>valid_since</th> | ||
+ | <th>date_type_since</th> | ||
+ | <th>valid_until</th> | ||
+ | <th>date_type_until</th> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>100 </td> | ||
+ | <td>1 </td> | ||
+ | <td>100 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>101 </td> | ||
+ | <td>1 </td> | ||
+ | <td>101 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>102 </td> | ||
+ | <td>1 </td> | ||
+ | <td>102 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>103 </td> | ||
+ | <td>1 </td> | ||
+ | <td>103 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>104 </td> | ||
+ | <td>1 </td> | ||
+ | <td>104 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>105 </td> | ||
+ | <td>2 </td> | ||
+ | <td>104 </td> | ||
+ | <td>105 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>106 </td> | ||
+ | <td>2 </td> | ||
+ | <td>104 </td> | ||
+ | <td>106 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>107 </td> | ||
+ | <td>2 </td> | ||
+ | <td>104 </td> | ||
+ | <td>107 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>108 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>105 </td> | ||
+ | <td>108 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>109 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>105 </td> | ||
+ | <td>109 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>110 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>105 </td> | ||
+ | <td>110 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>111 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>105 </td> | ||
+ | <td>111 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>112 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>105 </td> | ||
+ | <td>112 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>113 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>105 </td> | ||
+ | <td>113 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>114 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>105 </td> | ||
+ | <td>114 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>115 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>105 </td> | ||
+ | <td>115 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>117 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>105 </td> | ||
+ | <td>117 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>118 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>105 </td> | ||
+ | <td>118 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>119 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>105 </td> | ||
+ | <td>119 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>120 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>105 </td> | ||
+ | <td>120 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>121 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>105 </td> | ||
+ | <td>121 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>122 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>105 </td> | ||
+ | <td>122 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>123 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>105 </td> | ||
+ | <td>123 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>124 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>106 </td> | ||
+ | <td>124 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>125 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>106 </td> | ||
+ | <td>125 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>126 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>106 </td> | ||
+ | <td>126 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>127 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>106 </td> | ||
+ | <td>127 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>128 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>106 </td> | ||
+ | <td>128 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>129 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>106 </td> | ||
+ | <td>129 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>130 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>106 </td> | ||
+ | <td>130 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>131 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>106 </td> | ||
+ | <td>131 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>132 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>106 </td> | ||
+ | <td>132 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>133 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>107 </td> | ||
+ | <td>133 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>134 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>107 </td> | ||
+ | <td>134 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>135 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>107 </td> | ||
+ | <td>135 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>136 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>107 </td> | ||
+ | <td>136 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>137 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>107 </td> | ||
+ | <td>137 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>138 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>107 </td> | ||
+ | <td>138 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>139 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>107 </td> | ||
+ | <td>139 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>140 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>107 </td> | ||
+ | <td>140 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>141 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>107 </td> | ||
+ | <td>141 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>142 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>107 </td> | ||
+ | <td>142 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>143 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>107 </td> | ||
+ | <td>143 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>144 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>107 </td> | ||
+ | <td>144 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>145 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>107 </td> | ||
+ | <td>145 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>146 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>107 </td> | ||
+ | <td>146 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>147 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>107 </td> | ||
+ | <td>147 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>148 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>107 </td> | ||
+ | <td>148 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>149 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>107 </td> | ||
+ | <td>149 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>150 </td> | ||
+ | <td>3 </td> | ||
+ | <td>104 </td> | ||
+ | <td>107 </td> | ||
+ | <td>150 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300500000 </td> | ||
+ | </tr> | ||
+ | </table> |
Version vom 9. März 2007, 15:28 Uhr
Inhaltsverzeichnis
Fields
Indices
Name | Fields | Unique | Collation | Full Text |
---|---|---|---|---|
hierarchy_loc_id_idx | loc_id | Ascending | ||
hierarchy_level_idx | level | Ascending | ||
hierarchy_lvl1_idx | id_lvl1 | Ascending | ||
hierarchy_lvl2_idx | id_lvl2 | Ascending | ||
hierarchy_lvl3_idx | id_lvl3 | Ascending | ||
hierarchy_lvl4_idx | id_lvl4 | Ascending | ||
hierarchy_lvl5_idx | id_lvl5 | Ascending | ||
hierarchy_lvl6_idx | id_lvl6 | Ascending | ||
hierarchy_lvl7_idx | id_lvl7 | Ascending | ||
hierarchy_lvl8_idx | id_lvl8 | Ascending | ||
hierarchy_lvl9_idx | id_lvl9 | Ascending | ||
hierarchy_since_idx | valid_since | Ascending | ||
hierarchy_until_idx | valid_until | Ascending |
Foreign Keys
There are no foreign keys for table geodb_hierarchies
Triggers
There are no triggers for table geodb_hierarchies
Options
TransactSafe | TableType | Row Format | Check Sum | Delay Key Write | Pack Keys | Temporary | Min Rows | Max Rows | Union |
---|---|---|---|---|---|---|---|---|---|
InnoDB | Ascending | 0 | 0 |
Definition
CREATE TABLE `geodb_hierarchies` ( `loc_id` int(11) NOT NULL, `level` int(11) NOT NULL, `id_lvl1` int(11) NOT NULL, `id_lvl2` int(11) default NULL, `id_lvl3` int(11) default NULL, `id_lvl4` int(11) default NULL, `id_lvl5` int(11) default NULL, `id_lvl6` int(11) default NULL, `id_lvl7` int(11) default NULL, `id_lvl8` int(11) default NULL, `id_lvl9` int(11) default NULL, `valid_since` date default NULL, `date_type_since` int(11) default NULL, `valid_until` date NOT NULL, `date_type_until` int(11) NOT NULL, KEY `hierarchy_loc_id_idx` (`loc_id`), KEY `hierarchy_level_idx` (`level`), KEY `hierarchy_lvl1_idx` (`id_lvl1`), KEY `hierarchy_lvl2_idx` (`id_lvl2`), KEY `hierarchy_lvl3_idx` (`id_lvl3`), KEY `hierarchy_lvl4_idx` (`id_lvl4`), KEY `hierarchy_lvl5_idx` (`id_lvl5`), KEY `hierarchy_lvl6_idx` (`id_lvl6`), KEY `hierarchy_lvl7_idx` (`id_lvl7`), KEY `hierarchy_lvl8_idx` (`id_lvl8`), KEY `hierarchy_lvl9_idx` (`id_lvl9`), KEY `hierarchy_since_idx` (`valid_since`), KEY `hierarchy_until_idx` (`valid_until`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Beispieldatensätze
loc_id | level | id_lvl1 | id_lvl2 | id_lvl3 | id_lvl4 | id_lvl5 | id_lvl6 | id_lvl7 | id_lvl8 | id_lvl9 | valid_since | date_type_since | valid_until | date_type_until |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
100 | 1 | 100 | 3000-01-01 | 300500000 | ||||||||||
101 | 1 | 101 | 3000-01-01 | 300500000 | ||||||||||
102 | 1 | 102 | 3000-01-01 | 300500000 | ||||||||||
103 | 1 | 103 | 3000-01-01 | 300500000 | ||||||||||
104 | 1 | 104 | 3000-01-01 | 300500000 | ||||||||||
105 | 2 | 104 | 105 | 3000-01-01 | 300500000 | |||||||||
106 | 2 | 104 | 106 | 3000-01-01 | 300500000 | |||||||||
107 | 2 | 104 | 107 | 3000-01-01 | 300500000 | |||||||||
108 | 3 | 104 | 105 | 108 | 3000-01-01 | 300500000 | ||||||||
109 | 3 | 104 | 105 | 109 | 3000-01-01 | 300500000 | ||||||||
110 | 3 | 104 | 105 | 110 | 3000-01-01 | 300500000 | ||||||||
111 | 3 | 104 | 105 | 111 | 3000-01-01 | 300500000 | ||||||||
112 | 3 | 104 | 105 | 112 | 3000-01-01 | 300500000 | ||||||||
113 | 3 | 104 | 105 | 113 | 3000-01-01 | 300500000 | ||||||||
114 | 3 | 104 | 105 | 114 | 3000-01-01 | 300500000 | ||||||||
115 | 3 | 104 | 105 | 115 | 3000-01-01 | 300500000 | ||||||||
117 | 3 | 104 | 105 | 117 | 3000-01-01 | 300500000 | ||||||||
118 | 3 | 104 | 105 | 118 | 3000-01-01 | 300500000 | ||||||||
119 | 3 | 104 | 105 | 119 | 3000-01-01 | 300500000 | ||||||||
120 | 3 | 104 | 105 | 120 | 3000-01-01 | 300500000 | ||||||||
121 | 3 | 104 | 105 | 121 | 3000-01-01 | 300500000 | ||||||||
122 | 3 | 104 | 105 | 122 | 3000-01-01 | 300500000 | ||||||||
123 | 3 | 104 | 105 | 123 | 3000-01-01 | 300500000 | ||||||||
124 | 3 | 104 | 106 | 124 | 3000-01-01 | 300500000 | ||||||||
125 | 3 | 104 | 106 | 125 | 3000-01-01 | 300500000 | ||||||||
126 | 3 | 104 | 106 | 126 | 3000-01-01 | 300500000 | ||||||||
127 | 3 | 104 | 106 | 127 | 3000-01-01 | 300500000 | ||||||||
128 | 3 | 104 | 106 | 128 | 3000-01-01 | 300500000 | ||||||||
129 | 3 | 104 | 106 | 129 | 3000-01-01 | 300500000 | ||||||||
130 | 3 | 104 | 106 | 130 | 3000-01-01 | 300500000 | ||||||||
131 | 3 | 104 | 106 | 131 | 3000-01-01 | 300500000 | ||||||||
132 | 3 | 104 | 106 | 132 | 3000-01-01 | 300500000 | ||||||||
133 | 3 | 104 | 107 | 133 | 3000-01-01 | 300500000 | ||||||||
134 | 3 | 104 | 107 | 134 | 3000-01-01 | 300500000 | ||||||||
135 | 3 | 104 | 107 | 135 | 3000-01-01 | 300500000 | ||||||||
136 | 3 | 104 | 107 | 136 | 3000-01-01 | 300500000 | ||||||||
137 | 3 | 104 | 107 | 137 | 3000-01-01 | 300500000 | ||||||||
138 | 3 | 104 | 107 | 138 | 3000-01-01 | 300500000 | ||||||||
139 | 3 | 104 | 107 | 139 | 3000-01-01 | 300500000 | ||||||||
140 | 3 | 104 | 107 | 140 | 3000-01-01 | 300500000 | ||||||||
141 | 3 | 104 | 107 | 141 | 3000-01-01 | 300500000 | ||||||||
142 | 3 | 104 | 107 | 142 | 3000-01-01 | 300500000 | ||||||||
143 | 3 | 104 | 107 | 143 | 3000-01-01 | 300500000 | ||||||||
144 | 3 | 104 | 107 | 144 | 3000-01-01 | 300500000 | ||||||||
145 | 3 | 104 | 107 | 145 | 3000-01-01 | 300500000 | ||||||||
146 | 3 | 104 | 107 | 146 | 3000-01-01 | 300500000 | ||||||||
147 | 3 | 104 | 107 | 147 | 3000-01-01 | 300500000 | ||||||||
148 | 3 | 104 | 107 | 148 | 3000-01-01 | 300500000 | ||||||||
149 | 3 | 104 | 107 | 149 | 3000-01-01 | 300500000 | ||||||||
150 | 3 | 104 | 107 | 150 | 3000-01-01 | 300500000 |