-
Notifications
You must be signed in to change notification settings - Fork 3
Geodb_coordinates
==Fields== <table {{prettytable}}>
<tr> <th><b>PK</b></th> <th><b>Name</b></th> <th><b>Data type</b></th> <th><b>Size</b></th> <th><b>Precision</b></th> <th><b>Values</b></th> <th><b>Default</b></th> <th><b>Auto Increment</b></th> <th><b>Binary</b></th> <th><b>Not null</b></th> <th><b>Unsigned</b></th> <th><b>Zero Fill</b></th> <th><b>Unique</b></th> </tr>
<tr> <td align="center"></td> <td>loc_id</td> <td>INTEGER</td> <td>11</td> <td>0</td> <td></td> <td></td> <td align="center"></td> <td align="center"></td> <td align="center">Image:Yes.gif</td> <td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>
<tr> <td align="center"></td> <td>lon</td> <td>DOUBLE</td> <td>0</td> <td>0</td> <td></td> <td></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>
<tr> <td align="center"></td> <td>lat</td> <td>DOUBLE</td> <td>0</td> <td>0</td> <td></td> <td></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>
<tr> <td align="center"></td> <td>coord_type</td> <td>INTEGER</td> <td>11</td> <td>0</td> <td></td> <td></td> <td align="center"></td> <td align="center"></td> <td align="center">Image:Yes.gif</td> <td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>
<tr> <td align="center"></td> <td>coord_subtype</td> <td>INTEGER</td> <td>11</td> <td>0</td> <td></td> <td></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>
<tr> <td align="center"></td> <td>valid_since</td> <td>DATE</td> <td>0</td> <td>0</td> <td></td> <td></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>
<tr> <td align="center"></td> <td>date_type_since</td> <td>INTEGER</td> <td>11</td> <td>0</td> <td></td> <td></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>
<tr> <td align="center"></td> <td>valid_until</td> <td>DATE</td> <td>0</td> <td>0</td> <td></td> <td></td> <td align="center"></td> <td align="center"></td> <td align="center">Image:Yes.gif</td> <td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>
<tr> <td align="center"></td> <td>date_type_until</td> <td>INTEGER</td> <td>11</td> <td>0</td> <td></td> <td></td> <td align="center"></td> <td align="center"></td> <td align="center">Image:Yes.gif</td> <td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>
</table>
==Indices== <table {{prettytable}}>
<tr> <th><b>Name</b></th> <th><b>Fields</b></th> <th><b>Unique</b></th> <th><b>Collation</b></th> <th><b>Full Text</b></th> </tr>
<tr> <td>coord_loc_id_idx</td> <td>loc_id</td> <td align="center"></td> <td>Ascending</td> <td align="center"></td> </tr>
<tr> <td>coord_lon_idx</td> <td>lon</td> <td align="center"></td> <td>Ascending</td> <td align="center"></td> </tr>
<tr> <td>coord_lat_idx</td> <td>lat</td> <td align="center"></td> <td>Ascending</td> <td align="center"></td> </tr>
<tr> <td>coord_type_idx</td> <td>coord_type</td> <td align="center"></td> <td>Ascending</td> <td align="center"></td> </tr>
<tr> <td>coord_stype_idx</td> <td>coord_subtype</td> <td align="center"></td> <td>Ascending</td> <td align="center"></td> </tr>
<tr> <td>coord_since_idx</td> <td>valid_since</td> <td align="center"></td> <td>Ascending</td> <td align="center"></td> </tr>
<tr> <td>coord_until_idx</td> <td>valid_until</td> <td align="center"></td> <td>Ascending</td> <td align="center"></td> </tr>
</table>
==Foreign Keys== There are no foreign keys for table geodb_coordinates
==Triggers== There are no triggers for table geodb_coordinates
==Options== <table {{prettytable}}>
<tr> <th><b>TransactSafe</b></th> <th><b>TableType</b></th> <th><b>Row Format</b></th> <th><b>Check Sum</b></th> <th><b>Delay Key Write</b></th> <th><b>Pack Keys</b></th> <th><b>Temporary</b></th> <th><b>Min Rows</b></th> <th><b>Max Rows</b></th> <th><b>Union</b></th> </tr>
<tr> <td align="center">Image:Yes.gif</td> <td>InnoDB</td> <td>Ascending</td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td>0</td> <td>0</td> <td></td> </tr>
</table>
==Definition==
<source lang="mysql">
CREATE TABLE geodb_coordinates (
loc_id int(11) NOT NULL,
lon double default NULL,
lat double default NULL,
coord_type int(11) NOT NULL,
coord_subtype 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 coord_loc_id_idx (loc_id),
KEY coord_lon_idx (lon),
KEY coord_lat_idx (lat),
KEY coord_type_idx (coord_type),
KEY coord_stype_idx (coord_subtype),
KEY coord_since_idx (valid_since),
KEY coord_until_idx (valid_until)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
</source>
==Beispieldatensätze== <table {{prettytable}}> <tr> <th>loc_id</th> <th>lon</th> <th>lat</th> <th>coord_type</th> <th>coord_subtype</th> <th>valid_since</th> <th>date_type_since</th> <th>valid_until</th> <th>date_type_until</th> </tr> <tr> <td>13350 </td> <td>8,85 </td> <td>47,8511 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13351 </td> <td>6,6 </td> <td>49,7833 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13352 </td> <td>6,1 </td> <td>50,7667 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13353 </td> <td>10,1 </td> <td>48,8333 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13354 </td> <td>8,06667 </td> <td>50,25 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13355 </td> <td>9,43333 </td> <td>54,0667 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13356 </td> <td>10,6167 </td> <td>51,9167 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13357 </td> <td>11,2833 </td> <td>51,6167 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13358 </td> <td>10,9667 </td> <td>49,25 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13359 </td> <td>11,85 </td> <td>48,8167 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13360 </td> <td>7,1 </td> <td>49,65 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13361 </td> <td>10,8833 </td> <td>49,15 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13362 </td> <td>9,29278 </td> <td>49,0711 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13363 </td> <td>11,7167 </td> <td>51,0833 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13364 </td> <td>10,7667 </td> <td>51,25 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13365 </td> <td>12,7167 </td> <td>51,9 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13366 </td> <td>10 </td> <td>48,8833 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13367 </td> <td>8,7875 </td> <td>49,5367 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13368 </td> <td>10,3667 </td> <td>49,7667 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13369 </td> <td>7,65 </td> <td>49,75 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13370 </td> <td>9,71667 </td> <td>47,6333 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13371 </td> <td>8,06667 </td> <td>48,6333 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13372 </td> <td>10,6 </td> <td>52,0667 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13373 </td> <td>9,01667 </td> <td>53,0333 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13374 </td> <td>12,9333 </td> <td>48,9667 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13375 </td> <td>9,9 </td> <td>48,2667 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13376 </td> <td>7,06667 </td> <td>50,3667 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13377 </td> <td>7,08333 </td> <td>49,6167 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13378 </td> <td>9,96667 </td> <td>54,3167 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13379 </td> <td>9,03333 </td> <td>54,7833 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13380 </td> <td>11,4333 </td> <td>52,2167 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13381 </td> <td>12,3667 </td> <td>53,45 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13382 </td> <td>9,6 </td> <td>48,7667 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13383 </td> <td>9,75 </td> <td>51,5833 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13384 </td> <td>10,05 </td> <td>52,55 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13385 </td> <td>10,0167 </td> <td>48,95 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13386 </td> <td>11,2167 </td> <td>48,8333 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13387 </td> <td>10,9 </td> <td>49,7167 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13388 </td> <td>9,39333 </td> <td>49,4036 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13389 </td> <td>11,1167 </td> <td>48,1833 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13390 </td> <td>10,1667 </td> <td>49,4333 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13391 </td> <td>10,7167 </td> <td>48,4167 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13392 </td> <td>11,1333 </td> <td>48,35 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13393 </td> <td>6,93333 </td> <td>50,3833 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13394 </td> <td>7,65 </td> <td>49,6667 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13395 </td> <td>10,45 </td> <td>52,3833 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13396 </td> <td>10,45 </td> <td>53,2833 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13397 </td> <td>9,93333 </td> <td>52 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13398 </td> <td>11,6833 </td> <td>51,7667 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> <tr> <td>13399 </td> <td>11 </td> <td>52,0333 </td> <td>200100000 </td> <td> </td> <td> </td> <td> </td> <td>3000-01-01 </td> <td>300500000 </td> </tr> </table>