nouvelle_caledonie.sql

INSERT INTO commune(nom, insee, surf_ha)
VALUES
('Nouméa', 98818, 4570),
('Bélep', 98801, 6950),
('Boulouparis', 98802, 86560),
('Bourail', 98803, 79760),
('Canala', 98804, 43870),
('Dumbéa', 98805, 25460),
('Farino', 98806, 4800),
('Hienghène', 98807, 106880),
('Houaïlou', 98808, 94060),
('Île des Pins' ,98809,15230),
('Kaala-Gomen', 98810,71820),
('Koné', 98811, 37360),
('Kouaoua', 98833, 38300),
('Koumac', 98812, 55000),
('La Foa', 98813,46400),
('Lifou', 98814, 20710),
('Maré', 98815, 64170),
('Moindou', 98816, 32190),
('Mont-Dore', 98817,64300),
('Ouégoa', 98819, 65680),
('Ouvéa', 98820, 13210),
('Païta', 98821, 69970),
('Poindimié', 98822, 67310),
('Ponérihouen', 98823, 70730),
('Pouébo', 98824, 20280),
('Pouembout', 98825, 67430),
('Poum', 98826, 46940),
('Poya', 98827, 84580),
('Sarraméa', 98828, 10640),
('Thio', 98829, 99760),
('Touho', 98830, 28300),
('Voh', 98831, 80490),
('Yaté', 98832, 338406);

UPDATE commune SET aom_res_id = 216 WHERE insee in ('98805', '98817', '98818', '98821')