OpenGeoDB to MySQL
Daten http://www.fa-technik.adfc.de/code/opengeodb/DE.tab Tabellenstrucktur
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
CREATE TABLE `source_geodb_de` ( `loc_id` int(11) NOT NULL, `ags` varchar(255) COLLATE latin1_german1_ci DEFAULT NULL, `ascii` varchar(255) COLLATE latin1_german1_ci DEFAULT NULL, `name` varchar(255) COLLATE latin1_german1_ci DEFAULT NULL, `lat` varchar(255) COLLATE latin1_german1_ci DEFAULT NULL, `lon` varchar(255) COLLATE latin1_german1_ci DEFAULT NULL, `amt` varchar(255) COLLATE latin1_german1_ci DEFAULT NULL, `plz` text COLLATE latin1_german1_ci, `vorwahl` varchar(255) COLLATE latin1_german1_ci DEFAULT NULL, `einwohner` int(20) DEFAULT NULL, `flaeche` float DEFAULT NULL, `kz` varchar(10) COLLATE latin1_german1_ci DEFAULT NULL, `typ` varchar(255) COLLATE latin1_german1_ci DEFAULT NULL, `level` int(11) DEFAULT NULL, `of` int(11) DEFAULT NULL, `invalid` int(11) DEFAULT NULL, PRIMARY KEY (`loc_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci; |
Import Der Import erfolgt mit pentaho.de
Weiterlesen