Geodb coordinates: Unterschied zwischen den Versionen
OpenGeoDB & GISWiki - Das freie Portal für Geoinformatik (GIS)
HeinzJ (Diskussion | Beiträge) (→Definition) |
HeinzJ (Diskussion | Beiträge) (→Beispieldatensätze) |
||
(Eine dazwischenliegende Version desselben Benutzers wird nicht angezeigt) | |||
Zeile 274: | Zeile 274: | ||
==Definition== | ==Definition== | ||
− | < | + | <source lang="mysql"> |
CREATE TABLE `geodb_coordinates` ( | CREATE TABLE `geodb_coordinates` ( | ||
`loc_id` int(11) NOT NULL, | `loc_id` int(11) NOT NULL, | ||
Zeile 293: | Zeile 293: | ||
KEY `coord_until_idx` (`valid_until`) | KEY `coord_until_idx` (`valid_until`) | ||
) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
− | </ | + | </source> |
==Beispieldatensätze== | ==Beispieldatensätze== | ||
Zeile 859: | Zeile 859: | ||
</tr> | </tr> | ||
</table> | </table> | ||
+ | |||
+ | [[Kategorie:Datenbank]] |
Aktuelle Version vom 28. März 2008, 23:10 Uhr
Inhaltsverzeichnis
Fields
Indices
Name | Fields | Unique | Collation | Full Text |
---|---|---|---|---|
coord_loc_id_idx | loc_id | Ascending | ||
coord_lon_idx | lon | Ascending | ||
coord_lat_idx | lat | Ascending | ||
coord_type_idx | coord_type | Ascending | ||
coord_stype_idx | coord_subtype | Ascending | ||
coord_since_idx | valid_since | Ascending | ||
coord_until_idx | valid_until | Ascending |
Foreign Keys
There are no foreign keys for table geodb_coordinates
Triggers
There are no triggers for table geodb_coordinates
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_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;
Beispieldatensätze
loc_id | lon | lat | coord_type | coord_subtype | valid_since | date_type_since | valid_until | date_type_until |
---|---|---|---|---|---|---|---|---|
13350 | 8,85 | 47,8511 | 200100000 | 3000-01-01 | 300500000 | |||
13351 | 6,6 | 49,7833 | 200100000 | 3000-01-01 | 300500000 | |||
13352 | 6,1 | 50,7667 | 200100000 | 3000-01-01 | 300500000 | |||
13353 | 10,1 | 48,8333 | 200100000 | 3000-01-01 | 300500000 | |||
13354 | 8,06667 | 50,25 | 200100000 | 3000-01-01 | 300500000 | |||
13355 | 9,43333 | 54,0667 | 200100000 | 3000-01-01 | 300500000 | |||
13356 | 10,6167 | 51,9167 | 200100000 | 3000-01-01 | 300500000 | |||
13357 | 11,2833 | 51,6167 | 200100000 | 3000-01-01 | 300500000 | |||
13358 | 10,9667 | 49,25 | 200100000 | 3000-01-01 | 300500000 | |||
13359 | 11,85 | 48,8167 | 200100000 | 3000-01-01 | 300500000 | |||
13360 | 7,1 | 49,65 | 200100000 | 3000-01-01 | 300500000 | |||
13361 | 10,8833 | 49,15 | 200100000 | 3000-01-01 | 300500000 | |||
13362 | 9,29278 | 49,0711 | 200100000 | 3000-01-01 | 300500000 | |||
13363 | 11,7167 | 51,0833 | 200100000 | 3000-01-01 | 300500000 | |||
13364 | 10,7667 | 51,25 | 200100000 | 3000-01-01 | 300500000 | |||
13365 | 12,7167 | 51,9 | 200100000 | 3000-01-01 | 300500000 | |||
13366 | 10 | 48,8833 | 200100000 | 3000-01-01 | 300500000 | |||
13367 | 8,7875 | 49,5367 | 200100000 | 3000-01-01 | 300500000 | |||
13368 | 10,3667 | 49,7667 | 200100000 | 3000-01-01 | 300500000 | |||
13369 | 7,65 | 49,75 | 200100000 | 3000-01-01 | 300500000 | |||
13370 | 9,71667 | 47,6333 | 200100000 | 3000-01-01 | 300500000 | |||
13371 | 8,06667 | 48,6333 | 200100000 | 3000-01-01 | 300500000 | |||
13372 | 10,6 | 52,0667 | 200100000 | 3000-01-01 | 300500000 | |||
13373 | 9,01667 | 53,0333 | 200100000 | 3000-01-01 | 300500000 | |||
13374 | 12,9333 | 48,9667 | 200100000 | 3000-01-01 | 300500000 | |||
13375 | 9,9 | 48,2667 | 200100000 | 3000-01-01 | 300500000 | |||
13376 | 7,06667 | 50,3667 | 200100000 | 3000-01-01 | 300500000 | |||
13377 | 7,08333 | 49,6167 | 200100000 | 3000-01-01 | 300500000 | |||
13378 | 9,96667 | 54,3167 | 200100000 | 3000-01-01 | 300500000 | |||
13379 | 9,03333 | 54,7833 | 200100000 | 3000-01-01 | 300500000 | |||
13380 | 11,4333 | 52,2167 | 200100000 | 3000-01-01 | 300500000 | |||
13381 | 12,3667 | 53,45 | 200100000 | 3000-01-01 | 300500000 | |||
13382 | 9,6 | 48,7667 | 200100000 | 3000-01-01 | 300500000 | |||
13383 | 9,75 | 51,5833 | 200100000 | 3000-01-01 | 300500000 | |||
13384 | 10,05 | 52,55 | 200100000 | 3000-01-01 | 300500000 | |||
13385 | 10,0167 | 48,95 | 200100000 | 3000-01-01 | 300500000 | |||
13386 | 11,2167 | 48,8333 | 200100000 | 3000-01-01 | 300500000 | |||
13387 | 10,9 | 49,7167 | 200100000 | 3000-01-01 | 300500000 | |||
13388 | 9,39333 | 49,4036 | 200100000 | 3000-01-01 | 300500000 | |||
13389 | 11,1167 | 48,1833 | 200100000 | 3000-01-01 | 300500000 | |||
13390 | 10,1667 | 49,4333 | 200100000 | 3000-01-01 | 300500000 | |||
13391 | 10,7167 | 48,4167 | 200100000 | 3000-01-01 | 300500000 | |||
13392 | 11,1333 | 48,35 | 200100000 | 3000-01-01 | 300500000 | |||
13393 | 6,93333 | 50,3833 | 200100000 | 3000-01-01 | 300500000 | |||
13394 | 7,65 | 49,6667 | 200100000 | 3000-01-01 | 300500000 | |||
13395 | 10,45 | 52,3833 | 200100000 | 3000-01-01 | 300500000 | |||
13396 | 10,45 | 53,2833 | 200100000 | 3000-01-01 | 300500000 | |||
13397 | 9,93333 | 52 | 200100000 | 3000-01-01 | 300500000 | |||
13398 | 11,6833 | 51,7667 | 200100000 | 3000-01-01 | 300500000 | |||
13399 | 11 | 52,0333 | 200100000 | 3000-01-01 | 300500000 |