Nachmal die Zusammenfassung der Lösung:
- Japanische Bundesländern in die “oxstates” eintragen
sql dafür (CE 4.4.8):
INSERT INTO oxstates
(OXID
, OXCOUNTRYID
, OXTITLE
, OXISOALPHA2
, OXTITLE_1
, OXTITLE_2
, OXTITLE_3
) VALUES
(‘JP-23’, ‘8f241f11095c11d43.73419747’, ‘Aichi’, ‘JP’, ‘Aichi’, ‘’, ‘’),
(‘JP-05’, ‘8f241f11095c11d43.73419747’, ‘Akita’, ‘JP’, ‘Akita’, ‘’, ‘’),
(‘JP-02’, ‘8f241f11095c11d43.73419747’, ‘Aomori’, ‘JP’, ‘Aomori’, ‘’, ‘’),
(‘JP-12’, ‘8f241f11095c11d43.73419747’, ‘Chiba’, ‘JP’, ‘Chiba’, ‘’, ‘’),
(‘JP-38’, ‘8f241f11095c11d43.73419747’, ‘Ehime’, ‘JP’, ‘Ehime’, ‘’, ‘’),
(‘JP-18’, ‘8f241f11095c11d43.73419747’, ‘Fukui’, ‘JP’, ‘Fukui’, ‘’, ‘’),
(‘JP-40’, ‘8f241f11095c11d43.73419747’, ‘Fukuoka’, ‘JP’, ‘Fukuoka’, ‘’, ‘’),
(‘JP-07’, ‘8f241f11095c11d43.73419747’, ‘Fukushima’, ‘JP’, ‘Fukushima’, ‘’, ‘’),
(‘JP-21’, ‘8f241f11095c11d43.73419747’, ‘Gifu’, ‘JP’, ‘Gifu’, ‘’, ‘’),
(‘JP-10’, ‘8f241f11095c11d43.73419747’, ‘Gunma’, ‘JP’, ‘Gunma’, ‘’, ‘’),
(‘JP-34’, ‘8f241f11095c11d43.73419747’, ‘Hiroshima’, ‘JP’, ‘Hiroshima’, ‘’, ‘’),
(‘JP-01’, ‘8f241f11095c11d43.73419747’, ‘Hokkaidō’, ‘JP’, ‘Hokkaidō’, ‘’, ‘’),
(‘JP-28’, ‘8f241f11095c11d43.73419747’, ‘Hyōgo’, ‘JP’, ‘Hyōgo’, ‘’, ‘’),
(‘JP-08’, ‘8f241f11095c11d43.73419747’, ‘Ibaraki’, ‘JP’, ‘Ibaraki’, ‘’, ‘’),
(‘JP-17’, ‘8f241f11095c11d43.73419747’, ‘Ishikawa’, ‘JP’, ‘Ishikawa’, ‘’, ‘’),
(‘JP-03’, ‘8f241f11095c11d43.73419747’, ‘Iwate’, ‘JP’, ‘Iwate’, ‘’, ‘’),
(‘JP-37’, ‘8f241f11095c11d43.73419747’, ‘Kagawa’, ‘JP’, ‘Kagawa’, ‘’, ‘’),
(‘JP-46’, ‘8f241f11095c11d43.73419747’, ‘Kagoshima’, ‘JP’, ‘Kagoshima’, ‘’, ‘’),
(‘JP-14’, ‘8f241f11095c11d43.73419747’, ‘Kanagawa’, ‘JP’, ‘Kanagawa’, ‘’, ‘’),
(‘JP-39’, ‘8f241f11095c11d43.73419747’, ‘Kōchi’, ‘JP’, ‘Kōchi’, ‘’, ‘’),
(‘JP-43’, ‘8f241f11095c11d43.73419747’, ‘Kumamoto’, ‘JP’, ‘Kumamoto’, ‘’, ‘’),
(‘JP-26’, ‘8f241f11095c11d43.73419747’, ‘Kyōto’, ‘JP’, ‘Kyōto’, ‘’, ‘’),
(‘JP-24’, ‘8f241f11095c11d43.73419747’, ‘Mie’, ‘JP’, ‘Mie’, ‘’, ‘’),
(‘JP-04’, ‘8f241f11095c11d43.73419747’, ‘Miyagi’, ‘JP’, ‘Miyagi’, ‘’, ‘’),
(‘JP-45’, ‘8f241f11095c11d43.73419747’, ‘Miyazaki’, ‘JP’, ‘Miyazaki’, ‘’, ‘’),
(‘JP-20’, ‘8f241f11095c11d43.73419747’, ‘Nagano’, ‘JP’, ‘Nagano’, ‘’, ‘’),
(‘JP-42’, ‘8f241f11095c11d43.73419747’, ‘Nagasaki’, ‘JP’, ‘Nagasaki’, ‘’, ‘’),
(‘JP-29’, ‘8f241f11095c11d43.73419747’, ‘Nara’, ‘JP’, ‘Nara’, ‘’, ‘’),
(‘JP-15’, ‘8f241f11095c11d43.73419747’, ‘Niigata’, ‘JP’, ‘Niigata’, ‘’, ‘’),
(‘JP-44’, ‘8f241f11095c11d43.73419747’, ‘Ōita’, ‘JP’, ‘Ōita’, ‘’, ‘’),
(‘JP-33’, ‘8f241f11095c11d43.73419747’, ‘Okayama’, ‘JP’, ‘Okayama’, ‘’, ‘’),
(‘JP-47’, ‘8f241f11095c11d43.73419747’, ‘Okinawa’, ‘JP’, ‘Okinawa’, ‘’, ‘’),
(‘JP-27’, ‘8f241f11095c11d43.73419747’, ‘Ōsaka’, ‘JP’, ‘Ōsaka’, ‘’, ‘’),
(‘JP-41’, ‘8f241f11095c11d43.73419747’, ‘Saga’, ‘JP’, ‘Saga’, ‘’, ‘’),
(‘JP-11’, ‘8f241f11095c11d43.73419747’, ‘Saitama’, ‘JP’, ‘Saitama’, ‘’, ‘’),
(‘JP-25’, ‘8f241f11095c11d43.73419747’, ‘Shiga’, ‘JP’, ‘Shiga’, ‘’, ‘’),
(‘JP-32’, ‘8f241f11095c11d43.73419747’, ‘Shimane’, ‘JP’, ‘Shimane’, ‘’, ‘’),
(‘JP-22’, ‘8f241f11095c11d43.73419747’, ‘Shizuoka’, ‘JP’, ‘Shizuoka’, ‘’, ‘’),
(‘JP-09’, ‘8f241f11095c11d43.73419747’, ‘Tochigi’, ‘JP’, ‘Tochigi’, ‘’, ‘’),
(‘JP-36’, ‘8f241f11095c11d43.73419747’, ‘Tokushima’, ‘JP’, ‘Tokushima’, ‘’, ‘’),
(‘JP-13’, ‘8f241f11095c11d43.73419747’, ‘Tokio’, ‘JP’, ‘Tokio’, ‘’, ‘’),
(‘JP-31’, ‘8f241f11095c11d43.73419747’, ‘Tottori’, ‘JP’, ‘Tottori’, ‘’, ‘’),
(‘JP-16’, ‘8f241f11095c11d43.73419747’, ‘Toyama’, ‘JP’, ‘Toyama’, ‘’, ‘’),
(‘JP-30’, ‘8f241f11095c11d43.73419747’, ‘Wakayama’, ‘JP’, ‘Wakayama’, ‘’, ‘’),
(‘JP-06’, ‘8f241f11095c11d43.73419747’, ‘Yamagata’, ‘JP’, ‘Yamagata’, ‘’, ‘’),
(‘JP-35’, ‘8f241f11095c11d43.73419747’, ‘Yamaguchi’, ‘JP’, ‘Yamaguchi’, ‘’, ‘’),
(‘JP-19’, ‘8f241f11095c11d43.73419747’, ‘Yamanashi’, ‘JP’, ‘Yamanashi’, ‘’, ‘’);