query('TRUNCATE TABLE jalan'); $jalan1 = '[{"lat":-0.0528,"lng":109.3409},{"lat":-0.0556,"lng":109.3432},{"lat":-0.0601,"lng":109.3463}]'; $jalan2 = '[{"lat":-0.0343,"lng":109.3431},{"lat":-0.0308,"lng":109.3411}]'; $sqlJalan = "INSERT INTO jalan (nama_jalan, status_jalan, panjang_m, koordinat) VALUES ('Jl. Jenderal Ahmad Yani', 'Nasional', 1200, '$jalan1'), ('Jl. Gajah Mada', 'Provinsi', 800, '$jalan2')"; $conn->query($sqlJalan); // Seed Parsil / Bangunan $conn->query('TRUNCATE TABLE parsil'); $parsil1 = '[{"lat":-0.0520,"lng":109.3400},{"lat":-0.0520,"lng":109.3415},{"lat":-0.0535,"lng":109.3415},{"lat":-0.0535,"lng":109.3400}]'; $parsil2 = '[{"lat":-0.0468,"lng":109.3361},{"lat":-0.0468,"lng":109.3385},{"lat":-0.0487,"lng":109.3385},{"lat":-0.0487,"lng":109.3361}]'; $sqlParsil = "INSERT INTO parsil (nama_pemilik, status_hak, koordinat) VALUES ('Kompleks Kantor Gubernur Kalbar', 'HP', '$parsil1'), ('Area Masjid Raya Mujahidin', 'SHM', '$parsil2')"; $conn->query($sqlParsil); echo "Berhasil insert data jalan dan parsil (bangunan)."; ?>