Geodb coordinates: Unterschied zwischen den Versionen

OpenGeoDB & GISWiki - Das freie Portal für Geoinformatik (GIS)
Wechseln zu: Navigation, Suche
 
(Beispieldatensätze)
 
(3 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt)
Zeile 274: Zeile 274:
 
==Definition==
 
==Definition==
  
<code sql>
+
<source lang="mysql">
   CREATE</b> TABLE `geodb_coordinates` (
+
   CREATE TABLE `geodb_coordinates` (
   `loc_id` <b>int</b>(11) <b>NOT</b> NULL,
+
   `loc_id` int(11) NOT NULL,
   `lon` <b>double</b> default NULL,
+
   `lon` double default NULL,
   `lat` <b>double</b> default NULL,
+
   `lat` double default NULL,
   `coord_type` <b>int</b>(11) <b>NOT</b> NULL,
+
   `coord_type` int(11) NOT NULL,
   `coord_subtype` <b>int</b>(11) <b>default</b> NULL,
+
   `coord_subtype` int(11) default NULL,
   `valid_since` <b>date</b> default NULL,
+
   `valid_since` date default NULL,
   `date_type_since` <b>int</b>(11) <b>default</b> NULL,
+
   `date_type_since` int(11) default NULL,
   `valid_until` <b>date</b> NOT NULL,
+
   `valid_until` date NOT NULL,
   `date_type_until` <b>int</b>(11) <b>NOT</b> NULL,
+
   `date_type_until` int(11) NOT NULL,
   <b>KEY</b> `coord_loc_id_idx` (`loc_id`),
+
   KEY `coord_loc_id_idx` (`loc_id`),
   <b>KEY</b> `coord_lon_idx` (`lon`),
+
   KEY `coord_lon_idx` (`lon`),
   <b>KEY</b> `coord_lat_idx` (`lat`),
+
   KEY `coord_lat_idx` (`lat`),
   <b>KEY</b> `coord_type_idx` (`coord_type`),
+
   KEY `coord_type_idx` (`coord_type`),
   <b>KEY</b> `coord_stype_idx` (`coord_subtype`),
+
   KEY `coord_stype_idx` (`coord_subtype`),
   <b>KEY</b> `coord_since_idx` (`valid_since`),
+
   KEY `coord_since_idx` (`valid_since`),
   <b>KEY</b> `coord_until_idx` (`valid_until`)
+
   KEY `coord_until_idx` (`valid_until`)
) <b>ENGINE</b>=<b>InnoDB</b> DEFAULT CHARSET=utf8;
+
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
</code>
+
</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&nbsp;</td>
 +
    <td>8,85&nbsp;</td>
 +
    <td>47,8511&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13351&nbsp;</td>
 +
    <td>6,6&nbsp;</td>
 +
    <td>49,7833&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13352&nbsp;</td>
 +
    <td>6,1&nbsp;</td>
 +
    <td>50,7667&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13353&nbsp;</td>
 +
    <td>10,1&nbsp;</td>
 +
    <td>48,8333&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13354&nbsp;</td>
 +
    <td>8,06667&nbsp;</td>
 +
    <td>50,25&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13355&nbsp;</td>
 +
    <td>9,43333&nbsp;</td>
 +
    <td>54,0667&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13356&nbsp;</td>
 +
    <td>10,6167&nbsp;</td>
 +
    <td>51,9167&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13357&nbsp;</td>
 +
    <td>11,2833&nbsp;</td>
 +
    <td>51,6167&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13358&nbsp;</td>
 +
    <td>10,9667&nbsp;</td>
 +
    <td>49,25&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13359&nbsp;</td>
 +
    <td>11,85&nbsp;</td>
 +
    <td>48,8167&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13360&nbsp;</td>
 +
    <td>7,1&nbsp;</td>
 +
    <td>49,65&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13361&nbsp;</td>
 +
    <td>10,8833&nbsp;</td>
 +
    <td>49,15&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13362&nbsp;</td>
 +
    <td>9,29278&nbsp;</td>
 +
    <td>49,0711&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13363&nbsp;</td>
 +
    <td>11,7167&nbsp;</td>
 +
    <td>51,0833&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13364&nbsp;</td>
 +
    <td>10,7667&nbsp;</td>
 +
    <td>51,25&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13365&nbsp;</td>
 +
    <td>12,7167&nbsp;</td>
 +
    <td>51,9&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13366&nbsp;</td>
 +
    <td>10&nbsp;</td>
 +
    <td>48,8833&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13367&nbsp;</td>
 +
    <td>8,7875&nbsp;</td>
 +
    <td>49,5367&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13368&nbsp;</td>
 +
    <td>10,3667&nbsp;</td>
 +
    <td>49,7667&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13369&nbsp;</td>
 +
    <td>7,65&nbsp;</td>
 +
    <td>49,75&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13370&nbsp;</td>
 +
    <td>9,71667&nbsp;</td>
 +
    <td>47,6333&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13371&nbsp;</td>
 +
    <td>8,06667&nbsp;</td>
 +
    <td>48,6333&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13372&nbsp;</td>
 +
    <td>10,6&nbsp;</td>
 +
    <td>52,0667&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13373&nbsp;</td>
 +
    <td>9,01667&nbsp;</td>
 +
    <td>53,0333&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13374&nbsp;</td>
 +
    <td>12,9333&nbsp;</td>
 +
    <td>48,9667&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13375&nbsp;</td>
 +
    <td>9,9&nbsp;</td>
 +
    <td>48,2667&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13376&nbsp;</td>
 +
    <td>7,06667&nbsp;</td>
 +
    <td>50,3667&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13377&nbsp;</td>
 +
    <td>7,08333&nbsp;</td>
 +
    <td>49,6167&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13378&nbsp;</td>
 +
    <td>9,96667&nbsp;</td>
 +
    <td>54,3167&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13379&nbsp;</td>
 +
    <td>9,03333&nbsp;</td>
 +
    <td>54,7833&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13380&nbsp;</td>
 +
    <td>11,4333&nbsp;</td>
 +
    <td>52,2167&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13381&nbsp;</td>
 +
    <td>12,3667&nbsp;</td>
 +
    <td>53,45&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13382&nbsp;</td>
 +
    <td>9,6&nbsp;</td>
 +
    <td>48,7667&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13383&nbsp;</td>
 +
    <td>9,75&nbsp;</td>
 +
    <td>51,5833&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13384&nbsp;</td>
 +
    <td>10,05&nbsp;</td>
 +
    <td>52,55&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13385&nbsp;</td>
 +
    <td>10,0167&nbsp;</td>
 +
    <td>48,95&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13386&nbsp;</td>
 +
    <td>11,2167&nbsp;</td>
 +
    <td>48,8333&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13387&nbsp;</td>
 +
    <td>10,9&nbsp;</td>
 +
    <td>49,7167&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13388&nbsp;</td>
 +
    <td>9,39333&nbsp;</td>
 +
    <td>49,4036&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13389&nbsp;</td>
 +
    <td>11,1167&nbsp;</td>
 +
    <td>48,1833&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13390&nbsp;</td>
 +
    <td>10,1667&nbsp;</td>
 +
    <td>49,4333&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13391&nbsp;</td>
 +
    <td>10,7167&nbsp;</td>
 +
    <td>48,4167&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13392&nbsp;</td>
 +
    <td>11,1333&nbsp;</td>
 +
    <td>48,35&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13393&nbsp;</td>
 +
    <td>6,93333&nbsp;</td>
 +
    <td>50,3833&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13394&nbsp;</td>
 +
    <td>7,65&nbsp;</td>
 +
    <td>49,6667&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13395&nbsp;</td>
 +
    <td>10,45&nbsp;</td>
 +
    <td>52,3833&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13396&nbsp;</td>
 +
    <td>10,45&nbsp;</td>
 +
    <td>53,2833&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13397&nbsp;</td>
 +
    <td>9,93333&nbsp;</td>
 +
    <td>52&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13398&nbsp;</td>
 +
    <td>11,6833&nbsp;</td>
 +
    <td>51,7667&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13399&nbsp;</td>
 +
    <td>11&nbsp;</td>
 +
    <td>52,0333&nbsp;</td>
 +
    <td>200100000&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300500000&nbsp;</td>
 +
  </tr>
 +
</table>
 +
 
 +
[[Kategorie:Datenbank]]

Aktuelle Version vom 28. März 2008, 22:10 Uhr

Fields

PK Name Data type Size Precision Values Default Auto Increment Binary Not null Unsigned Zero Fill Unique
loc_id INTEGER 11 0 Yes.gif
lon DOUBLE 0 0
lat DOUBLE 0 0
coord_type INTEGER 11 0 Yes.gif
coord_subtype INTEGER 11 0
valid_since DATE 0 0
date_type_since INTEGER 11 0
valid_until DATE 0 0 Yes.gif
date_type_until INTEGER 11 0 Yes.gif


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
Yes.gif 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