text: /*
  SQLyog Enterprise v12.5.1 (64 bit)
  MySQL - 10.4.11-MariaDB : Database - db_pemetaan_jalan_rusak
  *********************************************************************
  */
  
  /*!40101 SET NAMES utf8 */;
  
  /*!40101 SET SQL_MODE=''*/;
  
  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  CREATE DATABASE /*!32312 IF NOT EXISTS*/`db_pemetaan_jalan_rusak` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
  
  USE `db_pemetaan_jalan_rusak`;
  
  /*Table structure for table `tb_broken_road` */
  
  DROP TABLE IF EXISTS `tb_broken_road`;
  
  CREATE TABLE `tb_broken_road` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `id_user` int(11) DEFAULT NULL,
    `address` varchar(255) DEFAULT NULL,
    `picture` varchar(255) DEFAULT NULL,
    `status` enum('0','1','2') DEFAULT NULL,
    `description` text DEFAULT NULL,
    `jalan` varchar(100) DEFAULT NULL,
    `kecamatan` varchar(100) DEFAULT NULL,
    `kota` varchar(100) DEFAULT NULL,
    `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY (`id`),
    KEY `id_user` (`id_user`),
    CONSTRAINT `tb_broken_road_ibfk_1` FOREIGN KEY (`id_user`) REFERENCES `users` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb4;
  
  /*Data for the table `tb_broken_road` */
  
  insert  into `tb_broken_road`(`id`,`id_user`,`address`,`picture`,`status`,`description`,`jalan`,`kecamatan`,`kota`,`created_at`,`updated_at`) values 
  (13,2,'Jl. Tukad Musi VI, Denpasar Selatan, Dauh Puri Klod, Kec. Denpasar Bar., Kota Denpasar, Bali 80234','1TukadMusiVI.jpg','0','Jalan rusak, berlubang, dan retak.','Jalan Tukad Musi VI','Kecamatan Denpasar Selatan','Kota Denpasar','2020-04-04 08:07:46','0000-00-00 00:00:00'),
  (14,2,'Jl. Tukad Musi IV, Panjer, Kec. Denpasar Sel., Kota Denpasar, Bali 80234','2TukadMusiIV.jpg','0','Jalan banyak yang retak','Jalan Tukad Musi VI','Kecamatan Denpasar Selatan','Kota Denpasar','2020-04-04 08:07:46','0000-00-00 00:00:00'),
  (15,2,'Jl. Tukad Musi V, Panjer, Kec. Denpasar Sel., Kota Denpasar, Bali 80234','3TukadMusiV.jpg','0','Jalan banyak lubangnya','Jalan Tukad Musi V','Kecamatan Denpasar Selatan','Kota Denpasar','2020-04-04 08:07:46','0000-00-00 00:00:00'),
  (16,2,'Jl. Tukad Batanghari II, Panjer, Kec. Denpasar Sel., Kota Denpasar, Bali 80234','4TukadBatanghariII.jpg','0','Jalan berlubang dan retak','Jalan Tukad Batanghari II','Kecamatan Denpasar Selatan','Kota Denpasar','2020-04-04 08:07:46','0000-00-00 00:00:00'),
  (17,2,'Jl. Tukad Batanghari VI, Panjer, Kec. Denpasar Sel., Kota Denpasar, Bali 80234','5TukadBatanghariII.jpg','0','Jalan rusak parah','Jalan Tukad Batanghari VI','Kecamatan Denpasar Selatan','Kota Denpasar','2020-04-04 08:07:46','0000-00-00 00:00:00'),
  (18,2,'Jl. Tukad Batang Hari Gg. XVII, Panjer, Kec. Denpasar Sel., Kota Denpasar, Bali 80225','6TukadBatanghariGgXVII.jpg','0','Jalan retak-retak','Jalan Tukad Batang Hari Gang XVII','Kecamatan Denpasar Selatan','Kota Denpasar','2020-04-04 08:07:46','0000-00-00 00:00:00'),
  (19,2,'Jl. Tukad Pancoran II, Panjer, Kec. Denpasar Sel., Kota Denpasar, Bali 80225','7TukadPancoranII.jpg','0','Jalan retak dan berlubang','Jalan Tukad Pancoran II','Kecamatan Denpasar Selatan','Kota Denpasar','2020-04-04 08:07:46','0000-00-00 00:00:00'),
  (20,2,'Jl. Tukad Banyu Poh, Panjer, Kec. Denpasar Sel., Kota Denpasar, Bali 80113','8TukadBanyuPoh.jpg','0','Jalan banyak lubang','Jalan Tukad Banyu Poh','Kecamatan Denpasar Selatan','Kota Denpasar','2020-04-04 08:07:46','0000-00-00 00:00:00'),
  (21,2,'Jl. Paku Sari, Sesetan, Kec. Denpasar Sel., Kota Denpasar, Bali 80225','9PakuSari.jpg','0','Jalan rusak, retak, dan berlubang\r\n','Jalan Paku Sari','Kecamatan Denpasar Selatan','Kota Denpasar','2020-04-04 08:07:46','0000-00-00 00:00:00'),
  (22,2,'Jl. Pendidikan I, Sidakarya, Kec. Denpasar Sel., Kota Denpasar, Bali','10PendidikanI.jpg','0','Jalan ini banyak lubangnya','Jalan Pendidikan I','Kecamatan Denpasar Selatan','Kota Denpasar','2020-04-04 08:07:46','0000-00-00 00:00:00'),
  (23,2,'Jl. Kerta Dalem Sari IV No.1, Sidakarya, Kec. Denpasar Sel., Kota Denpasar, Bali','11KertaDalemSariIV.jpg','0','Jalan retak dan berlubang','Jalan Kerta Dalem Sari IV','Kecamatan Denpasar Selatan','Kota Denpasar','2020-04-04 08:07:46','0000-00-00 00:00:00'),
  (24,2,'Jl. Tukad Badung XX, Renon, Kec. Denpasar Sel., Kota Denpasar, Bali 80226','12TukadBadungXX.jpg','0','Jalan rusak berlubang','Jalan Tukad Badung XX','Kecamatan Denpasar Selatan','Kota Denpasar','2020-04-04 08:07:46','0000-00-00 00:00:00'),
  (25,2,'Jl. Tukad Badung XX E, Sidakarya, Kec. Denpasar Sel., Kota Denpasar, Bali 80224','13TukadBadungXXE.jpg','0','Jalannya banyak lubangnya','Jalan Tukad Badung XX E','Kecamatan Denpasar Selatan','Kota Denpasar','2020-04-04 08:07:46','0000-00-00 00:00:00'),
  (26,2,'Jl. Tukad Petanu Gg. Walet No.1, Panjer, Kec. Denpasar Sel., Kota Denpasar, Bali 80224','14Walet.jpg','0','Jalan rusak parah','Jalan Tukad Petanu Gg. Walet','Kecamatan Denpasar Selatan','Kota Denpasar','2020-04-04 08:07:46','0000-00-00 00:00:00'),
  (27,2,'Jl. Tukad Petanu Gg. IV, Panjer, Kec. Denpasar Sel., Kota Denpasar, Bali 80225','15TukadPetanuGgIV.jpg','0','Jalan retak dan berlubang','Jalan Tukad Petanu','Kecamatan Denpasar Selatan','Kota Denpasar','2020-04-04 08:07:46','0000-00-00 00:00:00'),
  (28,2,'Jl. Tukad Pancoran Gg. XII 2, Panjer, Kec. Denpasar Sel., Kota Denpasar, Bali 80225','16TukadPancoran.jpg','2','Jalan retak-retak','Jalan Tukad Pancoran XII','Kecamatan Denpasar Selatan','Kota Denpasar','2020-04-04 08:07:46','0000-00-00 00:00:00'),
  (29,2,'Jl. Tukad Gangga I No.1 Dangin Puri Klod Kec. Denpasar Tim. Kota Denpasar Bali 80234','17TukadGangga.jpg','0','Jalan rusak dan retak-retak','Jalan Tukad Gangga I','Kecamatan Denpasar Selatan','Kota Denpasar','2020-04-04 08:07:46','0000-00-00 00:00:00'),
  (30,2,'Jl. Tukad Jinah Panjer Kec. Denpasar Selatan. Kota Denpasar Bali 80234','18TukadJinah.jpg','0','Jalan rusak, retak, dan berlubang','Jalan Tukad Jinah','Kecamatan Denpasar Selatan','Kota Denpasar','2020-04-04 08:07:46','0000-00-00 00:00:00'),
  (31,2,'Jl. Dewi Madri X 3, Sumerta Kelod, Kec. Denpasar Tim., Kota Denpasar, Bali 80239\r\n','19DewiMadri.jpg','0','Jalannya banyak lubangnya','Jalan Dewi Madri X','Kecamatan Denpasar Timur','Kota Denpasar','2020-03-22 18:44:29','0000-00-00 00:00:00'),
  (32,2,'Jl. Terompong No. 27, Sumerta Kelod, Denpasar Timur, Panjer, Kec. Denpasar Sel., Kota Denpasar, 80239\r\n','20Terompong.jpg','0','Jalan banyak retaknya','Jalan Terompong','Kecamatan Denpasar Timur','Kota Denpasar','2020-03-22 18:42:36','0000-00-00 00:00:00'),
  (33,2,'Jl. Tukad Mas No. 13d Dangin Puri Klod Kec. Denpasar Tim. Kota Denpasar Bali 80234\r\n','21TukadMas.jpg','2','Jalan retak dan berlubang','Jalan Tukad Mas','	Kecamatan Denpasar Timur','Kota Denpasar','2020-03-22 18:44:08','2020-03-16 18:04:54'),
  (34,2,'Jl. Nuansa Udayana Bar. Jimbaran, Kec. Kuta Sel., Kabupaten Badung,Bali 80361 ','22nuansabarat.jpg','0','Jalan rusak banyak lubang','Jalan Nuansa Udayana Barat','Kecamatan Kuta Selatan','Kabupaten Badung','2020-04-04 08:07:46','0000-00-00 00:00:00'),
  (35,2,'Jl. Nuansa Barat IV , Jimbaran, Kuta, Jimbaran, Kec. Kuta Sel., Kabupaten Badung, Bali 80361','23nuansabarativ.jpg','0','Jalan rusak banyak retakan dan lubang','Jalan Nuansa Barat IV','Kecamatan Kuta Selatan','Kabupaten Badung','2020-04-04 08:07:46','0000-00-00 00:00:00'),
  (36,2,'Jl. Nuansa Utama XXXII No.19\r\n, Jimbaran, Kec. Kuta Sel., Kabupaten Badung,Bali 80361 ','24nuansautamaxxxii.jpg','0','Jalan rusak dan berlubang','Jl. Nuansa Utama XXXII','Kecamatan Kuta Selatan','Kabupaten Badung','2020-04-04 08:07:46','0000-00-00 00:00:00'),
  (37,2,'Jl. Nuansa Utama Selatan II\r\n, Jimbaran, Kec. Kuta Sel. Kabupaten Badung,Bali 80361 ','25nuansautamaselatanii.jpg','0','Jalannya banyak lubangnya','Jl. Nuansa Utama Selatan II','Kecamatan Kuta Selatan','Kabupaten Badung','2020-04-04 08:07:46','0000-00-00 00:00:00'),
  (38,2,'Jl. Nuansa Utama Selatan VII, Jimbaran, Kec. Kuta Sel. Kabupaten Badung,Bali 80361','26nuansautamaselatanvii.jpg','0','Jalan berlubang dan retak-retak','Jalan Nuansa Utama Selatan VII','Kecamatan Kuta Selatan','Kabupaten Badung','2020-04-04 08:07:46','0000-00-00 00:00:00'),
  (39,2,'Jl. Nuansa Utama VII, Jimbaran, Kec. Kuta Sel. Kabupaten Badung,Bali 80361','27nuansautamavii.jpg','0','Jalan retak dan rusak parah','Nuansa Utama VI','Kecamatan Kuta Selatan','Kabupaten Badung','2020-04-04 08:07:46','0000-00-00 00:00:00'),
  (40,2,'Jl. Nuansa Utama Selatan XXIII, Jimbaran, Kec. Kuta Sel. Kabupaten Badung,Bali 80361','28nuansautamaselatanxxiii.jpg','0','Jalannya banyak lubangnya','Jalan Nuansa Utama Selatan XXIII','Kecamatan Kuta Selatan','Kabupaten Badung','2020-04-04 08:07:46','0000-00-00 00:00:00'),
  (41,2,'Jl. Nuansa Utama Selatan XVII, Jimbaran, Kec. Kuta Sel. Kabupaten Badung,Bali 80361','29nuansautamaselatanxvii.jpg','0','Jalan retak-retak','Jalan Nuansa Utama Selatan XVII','Kecamatan Kuta Selatan','Kabupaten Badung','2020-04-04 08:07:46','0000-00-00 00:00:00'),
  (44,2,'Jl. Sedap Malam No.12, Sanur Kaja, Kec. Denpasar Sel., Kota Denpasar, Bali 80237, Indonesia','29nuansautamaselatanxvii.jpg','1','Jalan banyak lubang','Jalan Sedap Malam','Kecamatan Denpasar Timur','Kota Denpasar','2020-03-22 18:15:32','2020-03-22 18:15:32'),
  (45,2,'Jl. Pulau Seribu Dauh Peken Kec. Tabanan,Kota Tabanan , Bali 82114','1pulauseributabanan.jpg','0','Jalan Berlubang dan retak-retak','Jalan Pulau Menjangan','Kecamatan Tabanan','Kota Tabanan','2020-04-04 08:07:46','0000-00-00 00:00:00'),
  (46,2,'Jl. Pulau Buton Dauh Peken, Kec. Tabanan, Kota Tabanan, Bali','2pulaubutontabanan.jpg','0','jalannya rusak banyak lubangnya','Jalan Pulau Buton','Kecamatan Tabanan','Kota Tabanan','2020-04-04 08:07:46','0000-00-00 00:00:00'),
  (47,2,'Jl. Pulau Batam 14 Dauh Peken, Kec Tabanan,Kota Tabanan, Bali 82114','3pulaubatam14tabanan.jpg','0','jalannya berlubang','Jalan Pulau Batam','Kec. Tabanan','Kota Tabanan','2020-04-04 08:07:46','0000-00-00 00:00:00'),
  (48,2,'Jl. Pulau Nias 17-19 Dauh Peken,Kec. tabanan, Kota Tabanan, Bali , 82113','4pulaunias1719tabanan.jpg','0','jalannya retak dan berlubang','Jalan Pulau Nias 17','Kecamatan Tabanan','Kota Tabanan','2020-04-04 08:07:46','0000-00-00 00:00:00'),
  (49,2,'Jl. Pulau Nias 37-39 Dauh Peken, Kec. tabanan, Kota Tabanan, Bali , 82113','5pulaunias3739tabanan.jpg','0','jalannya retak dan berlubang','Jalan Pulau Nias 37','Kecamatan Tabanan','Kota Tabanan','2020-04-04 08:07:46','0000-00-00 00:00:00'),
  (50,2,'Jl. Dr Ir Soekarno Dauh Peken, Kec. tabanan, Kota Tabanan, Bali , 82113','6irsoekarnotabanan.jpg','0','jalannya retak dan berlubang','Jalan Dr Ir Soekarno','Kecamatan Tabanan','Kota Tabanan','2020-04-04 08:07:46','0000-00-00 00:00:00'),
  (51,2,'Jl. Sekar Tunjung, Dauh Peken, Kec. tabanan, Kota Tabanan, Bali , 82113','7sekartunjungtabanan.jpg','0','jalannya retak dan berlubang','Jalan Sekar Tunjung','Kecamatan Tabanan','Kota Tabanan','2020-04-04 08:07:46','0000-00-00 00:00:00'),
  (52,2,'Jl. Pd. Indah no 2 Dauh peken, Kec. tabanan, Kota Tabanan, Bali , 82121','8pdindah2tabanan.jpg','0','jalannya retak dan berlubang','Jalan Pd Indah 2','Kecamatan Tabanan','Kota Tabanan','2020-04-04 08:07:46','0000-00-00 00:00:00'),
  (53,2,'Jl. Pd. Indah no 20 Dauh peken, Kec. tabanan, Kota Tabanan, Bali , 82121','9pdindah20tabanan.jpg','0','jalannya rusak berlubang','Jalan Pd Indah 20','Kecamatan Tabanan','Kota Tabanan','2020-04-04 08:07:46','0000-00-00 00:00:00'),
  (54,2,'Jl. By Pass Kediri 88 Banjar Anyar, Kec. tabanan, Kota Tabanan, Bali , 82121','10bypasskediritabanan.jpg','1','Jalannya rusak dan berlubang','Jalan By Pass Kediri 88','Kecamatan Tabanan','Kota Tabanan','2020-04-06 10:07:58','2020-04-06 02:07:58');
  
  /*Table structure for table `tb_detail_coordinate` */
  
  DROP TABLE IF EXISTS `tb_detail_coordinate`;
  
  CREATE TABLE `tb_detail_coordinate` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `id_road` int(11) DEFAULT NULL,
    `latitude` double DEFAULT NULL,
    `longitude` double DEFAULT NULL,
    `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY (`id`),
    KEY `id_road` (`id_road`),
    CONSTRAINT `tb_detail_coordinate_ibfk_1` FOREIGN KEY (`id_road`) REFERENCES `tb_broken_road` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8mb4;
  
  /*Data for the table `tb_detail_coordinate` */
  
  insert  into `tb_detail_coordinate`(`id`,`id_road`,`latitude`,`longitude`,`created_at`,`updated_at`) values 
  (13,13,-8.676927,115.229648,'2020-03-16 23:31:03','0000-00-00 00:00:00'),
  (14,14,-8.676935,115.22871,'2020-03-16 23:31:28','0000-00-00 00:00:00'),
  (16,15,-8.676467,115.228917,'2020-03-17 00:52:28','0000-00-00 00:00:00'),
  (17,16,-8.678407,115.229223,'2020-03-17 00:52:40','0000-00-00 00:00:00'),
  (18,17,-8.680123,115.230248,'2020-03-17 00:53:14','0000-00-00 00:00:00'),
  (19,18,-8.687967,115.230457,'2020-03-17 00:53:28','0000-00-00 00:00:00'),
  (20,18,-8.688074,115.230979,'2020-03-17 00:53:40','0000-00-00 00:00:00'),
  (21,19,-8.687888,115.229844,'2020-03-17 00:53:52','0000-00-00 00:00:00'),
  (22,19,-8.688415,115.229868,'2020-03-17 00:54:06','0000-00-00 00:00:00'),
  (23,20,-8.680704,115.219726,'2020-03-17 00:54:14','0000-00-00 00:00:00'),
  (24,21,-8.690072,115.220214,'2020-03-17 00:55:15','0000-00-00 00:00:00'),
  (25,22,-8.70254,115.228713,'2020-03-17 00:56:18','0000-00-00 00:00:00'),
  (26,23,-8.697879,115.233623,'2020-03-17 00:56:33','0000-00-00 00:00:00'),
  (27,24,-8.693554,115.236654,'2020-03-17 00:57:39','0000-00-00 00:00:00'),
  (28,25,-8.694416,115.236022,'2020-03-17 00:57:41','0000-00-00 00:00:00'),
  (29,26,-8.694067,115.232593,'2020-03-17 00:58:03','0000-00-00 00:00:00'),
  (30,27,-8.693946,115.229441,'2020-03-17 00:58:17','0000-00-00 00:00:00'),
  (31,28,-8.692924,115.229607,'2020-03-17 00:58:34','0000-00-00 00:00:00'),
  (32,28,-8.692969,115.229864,'2020-03-17 00:58:48','0000-00-00 00:00:00'),
  (33,30,-8.675248,115.22513,'2020-03-17 00:59:42','0000-00-00 00:00:00'),
  (34,31,-8.663654,115.238495,'2020-03-17 01:00:17','0000-00-00 00:00:00'),
  (35,32,-8.659429,115.241832,'2020-03-17 01:00:19','0000-00-00 00:00:00'),
  (36,33,-8.67356,115.225325,'2020-03-17 01:00:35','0000-00-00 00:00:00'),
  (37,34,-8.797316,115.182045,'2020-03-17 02:10:24','0000-00-00 00:00:00'),
  (38,35,-8.800203,115.183203,'2020-03-17 02:11:19','0000-00-00 00:00:00'),
  (39,36,-8.800822,115.184517,'2020-03-17 02:12:10','0000-00-00 00:00:00'),
  (40,37,-8.801511,115.184445,'2020-03-17 02:21:35','0000-00-00 00:00:00'),
  (41,38,-8.801967,115.185049,'2020-03-17 02:14:40','0000-00-00 00:00:00'),
  (42,39,-8.798267,115.187201,'2020-03-17 02:17:58','0000-00-00 00:00:00'),
  (43,40,-8.803948,115.184881,'2020-03-17 02:18:41','0000-00-00 00:00:00'),
  (44,41,-8.80335,115.185249,'2020-03-17 02:19:26','0000-00-00 00:00:00'),
  (48,45,-8.5359566,115.1172992,'2020-03-22 10:07:04','0000-00-00 00:00:00'),
  (49,46,-8.5368306,115.1159846,'2020-03-22 11:07:56','0000-00-00 00:00:00'),
  (50,47,-8.5364606,115.1152105,'2020-03-22 12:09:13','0000-00-00 00:00:00'),
  (51,48,-8.538011,115.1144024,'2020-03-22 13:09:38','0000-00-00 00:00:00'),
  (52,49,-8.5404741,115.112483,'2020-03-21 10:10:10','0000-00-00 00:00:00'),
  (53,50,-8.5434183,115.1137892,'2020-03-19 10:10:40','0000-00-00 00:00:00'),
  (54,51,-8.5473973,115.1176798,'2020-03-18 10:11:08','0000-00-00 00:00:00'),
  (55,52,-8.5492571,115.1225161,'2020-03-17 10:11:33','0000-00-00 00:00:00'),
  (56,53,-8.5472508,115.1223612,'2020-03-20 11:12:14','0000-00-00 00:00:00'),
  (57,54,-8.5522114,115.1347809,'2020-03-23 10:12:36','0000-00-00 00:00:00');
  
  /*Table structure for table `tb_detail_digitasi` */
  
  DROP TABLE IF EXISTS `tb_detail_digitasi`;
  
  CREATE TABLE `tb_detail_digitasi` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `id_digitasi` int(11) DEFAULT NULL,
    `latitude` double DEFAULT NULL,
    `longitude` double DEFAULT NULL,
    `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=491 DEFAULT CHARSET=utf8mb4;
  
  /*Data for the table `tb_detail_digitasi` */
  
  insert  into `tb_detail_digitasi`(`id`,`id_digitasi`,`latitude`,`longitude`,`created_at`,`updated_at`) values 
  (94,9,-8.675572958952825,115.22827118425154,'2020-03-22 12:29:54','2020-03-22 12:29:54'),
  (95,9,-8.675631292387015,115.2300843575456,'2020-03-22 12:29:54','2020-03-22 12:29:54'),
  (96,9,-8.675574284712797,115.22897258190893,'2020-03-22 12:29:54','2020-03-22 12:29:54'),
  (97,9,-8.674967714614256,115.22898196964049,'2020-03-22 12:29:54','2020-03-22 12:29:54'),
  (98,9,-8.676605700031109,115.22894067834694,'2020-03-22 12:29:54','2020-03-22 12:29:54'),
  (99,10,-8.676985340981219,115.22819038600976,'2020-03-22 12:45:33','2020-03-22 12:45:33'),
  (100,10,-8.676908447184278,115.23006256790215,'2020-03-22 12:45:33','2020-03-22 12:45:33'),
  (101,11,-8.676279994775282,115.23009400230835,'2020-03-22 13:01:35','2020-03-22 13:01:35'),
  (102,11,-8.676294578107221,115.22898222667168,'2020-03-22 13:01:35','2020-03-22 13:01:35'),
  (103,12,-8.678295629674087,115.2301067561951,'2020-03-22 13:02:40','2020-03-22 13:02:40'),
  (104,12,-8.678311538678035,115.22791002205838,'2020-03-22 13:02:40','2020-03-22 13:02:40'),
  (117,14,-8.687969908845208,115.23026955126748,'2020-03-22 13:06:43','2020-03-22 13:06:43'),
  (118,14,-8.687863851536562,115.22989135979638,'2020-03-22 13:06:43','2020-03-22 13:06:43'),
  (119,14,-8.687789611402662,115.22970360516534,'2020-03-22 13:06:43','2020-03-22 13:06:43'),
  (120,14,-8.687688856911695,115.22936832903848,'2020-03-22 13:06:43','2020-03-22 13:06:43'),
  (121,14,-8.68762787391718,115.22918593882547,'2020-03-22 13:06:43','2020-03-22 13:06:43'),
  (122,14,-8.687542288566123,115.2288230925972,'2020-03-22 13:06:43','2020-03-22 13:06:43'),
  (123,14,-8.68738855983842,115.22848250724049,'2020-03-22 13:06:43','2020-03-22 13:06:43'),
  (124,14,-8.687322273921254,115.22825988389225,'2020-03-22 13:06:43','2020-03-22 13:06:43'),
  (125,14,-8.687204159337565,115.22789363528165,'2020-03-22 13:06:43','2020-03-22 13:06:43'),
  (126,14,-8.687222719401396,115.22797946597012,'2020-03-22 13:06:43','2020-03-22 13:06:43'),
  (127,15,-8.683627995826795,115.22017979764937,'2020-03-22 13:09:18','2020-03-22 13:09:18'),
  (128,15,-8.6835736408306,115.22002825284002,'2020-03-22 13:09:18','2020-03-22 13:09:18'),
  (129,15,-8.683466256546692,115.21998936080931,'2020-03-22 13:09:18','2020-03-22 13:09:18'),
  (130,15,-8.683229338336684,115.21995717430113,'2020-03-22 13:09:18','2020-03-22 13:09:18'),
  (131,15,-8.682778044756981,115.21992096447943,'2020-03-22 13:09:18','2020-03-22 13:09:18'),
  (132,15,-8.682487603953614,115.21991425895689,'2020-03-22 13:09:18','2020-03-22 13:09:18'),
  (133,15,-8.68220469281849,115.21990755343435,'2020-03-22 13:09:18','2020-03-22 13:09:18'),
  (134,15,-8.68195598616832,115.21989789260009,'2020-03-22 13:09:18','2020-03-22 13:09:18'),
  (135,15,-8.681711143367348,115.21992372670587,'2020-03-22 13:09:18','2020-03-22 13:09:18'),
  (136,15,-8.681456631828665,115.21995460276034,'2020-03-22 13:09:18','2020-03-22 13:09:18'),
  (137,15,-8.681225300834116,115.21988519525807,'2020-03-22 13:09:18','2020-03-22 13:09:18'),
  (138,15,-8.680847781161937,115.21981713926732,'2020-03-22 13:09:18','2020-03-22 13:09:18'),
  (139,15,-8.680728317578383,115.21978666627615,'2020-03-22 13:09:18','2020-03-22 13:09:18'),
  (140,15,-8.680631538417142,115.21972095215528,'2020-03-22 13:09:18','2020-03-22 13:09:18'),
  (141,15,-8.680382083674404,115.21970644925763,'2020-03-22 13:09:18','2020-03-22 13:09:18'),
  (142,15,-8.680169681970986,115.21967954654498,'2020-03-22 13:09:18','2020-03-22 13:09:18'),
  (143,15,-8.679893927172303,115.21970636863513,'2020-03-22 13:09:18','2020-03-22 13:09:18'),
  (144,15,-8.679671122864042,115.219707703069,'2020-03-22 13:09:18','2020-03-22 13:09:18'),
  (145,15,-8.67955976022565,115.21965405888871,'2020-03-22 13:09:18','2020-03-22 13:09:18'),
  (146,15,-8.679488169940669,115.21941266007737,'2020-03-22 13:09:18','2020-03-22 13:09:18'),
  (147,15,-8.679376506120198,115.2189617443467,'2020-03-22 13:09:18','2020-03-22 13:09:18'),
  (148,15,-8.679188887224585,115.21827756789008,'2020-03-22 13:09:18','2020-03-22 13:09:18'),
  (149,15,-8.678831062756137,115.21679890977158,'2020-03-22 13:09:18','2020-03-22 13:09:18'),
  (150,15,-8.678844320240565,115.2169088803412,'2020-03-22 13:09:18','2020-03-22 13:09:18'),
  (151,15,-8.678862838915022,115.21695121895145,'2020-03-22 13:09:18','2020-03-22 13:09:18'),
  (152,15,-8.678892005377673,115.21707191835712,'2020-03-22 13:09:18','2020-03-22 13:09:18'),
  (153,16,-8.6948422813899,115.2201378786678,'2020-03-22 13:10:43','2020-03-22 13:10:43'),
  (154,16,-8.694312004269522,115.2201191032047,'2020-03-22 13:10:43','2020-03-22 13:10:43'),
  (155,16,-8.693837470249743,115.22010953739898,'2020-03-22 13:10:43','2020-03-22 13:10:43'),
  (156,16,-8.693340851470653,115.22009939189103,'2020-03-22 13:10:43','2020-03-22 13:10:43'),
  (157,16,-8.692810827108918,115.2200414959758,'2020-03-22 13:10:43','2020-03-22 13:10:43'),
  (158,16,-8.692136860968219,115.22004686039384,'2020-03-22 13:10:43','2020-03-22 13:10:43'),
  (159,16,-8.691988501864358,115.2200414959758,'2020-03-22 13:10:43','2020-03-22 13:10:43'),
  (160,16,-8.691821463380299,115.22006831806596,'2020-03-22 13:10:43','2020-03-22 13:10:43'),
  (161,16,-8.691533214346714,115.22005451379927,'2020-03-22 13:10:43','2020-03-22 13:10:43'),
  (162,16,-8.69124729427838,115.21996600090178,'2020-03-22 13:10:43','2020-03-22 13:10:43'),
  (163,16,-8.69058709281571,115.2198801702133,'2020-03-22 13:10:43','2020-03-22 13:10:43'),
  (164,16,-8.690246558981519,115.2198801702133,'2020-03-22 13:10:43','2020-03-22 13:10:43'),
  (165,17,-8.702115339552403,115.22895199059828,'2020-03-22 13:11:58','2020-03-22 13:11:58'),
  (166,17,-8.702181622852377,115.22881385683401,'2020-03-22 13:11:58','2020-03-22 13:11:58'),
  (167,17,-8.702339377059113,115.22866365312917,'2020-03-22 13:11:58','2020-03-22 13:11:58'),
  (168,17,-8.702633447031308,115.2287368404134,'2020-03-22 13:11:58','2020-03-22 13:11:58'),
  (169,17,-8.702862245494561,115.22775576916628,'2020-03-22 13:11:58','2020-03-22 13:11:58'),
  (170,17,-8.702569021686573,115.2276828064716,'2020-03-22 13:11:58','2020-03-22 13:11:58'),
  (171,17,-8.702349572974885,115.22865252856427,'2020-03-22 13:11:58','2020-03-22 13:11:58'),
  (172,18,-8.698394199695112,115.23272400306053,'2020-03-22 13:14:14','2020-03-22 13:14:14'),
  (173,18,-8.698204627508378,115.23273204968757,'2020-03-22 13:14:14','2020-03-22 13:14:14'),
  (174,18,-8.6978521818611,115.23268407272126,'2020-03-22 13:14:14','2020-03-22 13:14:14'),
  (175,18,-8.697568988001686,115.23236855606038,'2020-03-22 13:14:14','2020-03-22 13:14:14'),
  (176,18,-8.697114041752508,115.23238130263222,'2020-03-22 13:14:14','2020-03-22 13:14:14'),
  (177,18,-8.69681895807782,115.23239363042904,'2020-03-22 13:14:14','2020-03-22 13:14:14'),
  (178,18,-8.69656568851897,115.23240244421434,'2020-03-22 13:14:14','2020-03-22 13:14:14'),
  (179,18,-8.696488798736755,115.23229649695826,'2020-03-22 13:14:14','2020-03-22 13:14:14'),
  (180,18,-8.696539878137596,115.23194409543389,'2020-03-22 13:14:14','2020-03-22 13:14:14'),
  (181,18,-8.69656904322528,115.23161820703858,'2020-03-22 13:14:14','2020-03-22 13:14:14'),
  (182,18,-8.696597326903259,115.2310844908379,'2020-03-22 13:14:14','2020-03-22 13:14:14'),
  (183,18,-8.69659704113457,115.23080010018911,'2020-03-22 13:14:14','2020-03-22 13:14:14'),
  (184,18,-8.69656257330601,115.2307062228736,'2020-03-22 13:14:14','2020-03-22 13:14:14'),
  (185,18,-8.696477729406789,115.23066867194738,'2020-03-22 13:14:14','2020-03-22 13:14:14'),
  (186,18,-8.696095476940151,115.2306713541564,'2020-03-22 13:14:14','2020-03-22 13:14:14'),
  (187,18,-8.695916248238351,115.23067857500956,'2020-03-22 13:14:14','2020-03-22 13:14:14'),
  (188,18,-8.696134963065633,115.23066248175547,'2020-03-22 13:14:14','2020-03-22 13:14:14'),
  (189,19,-8.694464271697292,115.23427630704249,'2020-03-22 13:15:47','2020-03-22 13:15:47'),
  (190,19,-8.69437412454883,115.23457939666118,'2020-03-22 13:15:47','2020-03-22 13:15:47'),
  (191,19,-8.694283977378674,115.23468668502177,'2020-03-22 13:15:47','2020-03-22 13:15:47'),
  (192,19,-8.694217692680894,115.23576493304576,'2020-03-22 13:15:47','2020-03-22 13:15:47'),
  (193,19,-8.69413635224138,115.23674986518265,'2020-03-22 13:15:47','2020-03-22 13:15:47'),
  (194,19,-8.694121538213288,115.23808620017674,'2020-03-22 13:15:47','2020-03-22 13:15:47'),
  (195,19,-8.694113584046717,115.23670754474308,'2020-03-22 13:15:47','2020-03-22 13:15:47'),
  (196,19,-8.693272310786583,115.236690583902,'2020-03-22 13:15:47','2020-03-22 13:15:47'),
  (197,19,-8.692638308838925,115.23668703443516,'2020-03-22 13:15:47','2020-03-22 13:15:47'),
  (198,19,-8.692385683529288,115.23667898780812,'2020-03-22 13:15:47','2020-03-22 13:15:47'),
  (249,32,-8.694129592020875,115.23259763558197,'2020-03-22 18:36:55','2020-03-22 18:36:55'),
  (250,32,-8.693963880186171,115.23258824785042,'2020-03-22 18:36:55','2020-03-22 18:36:55'),
  (251,32,-8.693775631453024,115.23257617790985,'2020-03-22 18:36:56','2020-03-22 18:36:56'),
  (252,32,-8.693608276343943,115.23256609632996,'2020-03-22 18:36:56','2020-03-22 18:36:56'),
  (253,32,-8.693502220630624,115.23253927423981,'2020-03-22 18:36:57','2020-03-22 18:36:57'),
  (262,34,-8.65964025792909,115.23954422862779,'2020-03-22 18:40:38','2020-03-22 18:40:38'),
  (263,34,-8.659629651399548,115.23989291579973,'2020-03-22 18:40:38','2020-03-22 18:40:38'),
  (264,34,-8.659571315481793,115.24030597598802,'2020-03-22 18:40:39','2020-03-22 18:40:39'),
  (265,34,-8.659550102418539,115.24065734536897,'2020-03-22 18:40:39','2020-03-22 18:40:39'),
  (266,34,-8.65953419262033,115.24113746078264,'2020-03-22 18:40:40','2020-03-22 18:40:40'),
  (267,34,-8.65949972138854,115.24156661422502,'2020-03-22 18:40:41','2020-03-22 18:40:41'),
  (268,34,-8.659468752206683,115.24193321663454,'2020-03-22 18:40:41','2020-03-22 18:40:41'),
  (269,34,-8.659421022799688,115.24230336147859,'2020-03-22 18:40:42','2020-03-22 18:40:42'),
  (270,35,-8.673613184018542,115.22440707347182,'2020-03-22 18:42:01','2020-03-22 18:42:01'),
  (271,35,-8.673615835552326,115.22482281586913,'2020-03-22 18:42:01','2020-03-22 18:42:01'),
  (272,35,-8.673652957023135,115.22527342698363,'2020-03-22 18:42:02','2020-03-22 18:42:02'),
  (273,35,-8.673660911623536,115.22587155959395,'2020-03-22 18:42:03','2020-03-22 18:42:03'),
  (274,35,-8.673660911623536,115.22630339524535,'2020-03-22 18:42:03','2020-03-22 18:42:03'),
  (275,36,-8.66456297324526,115.23852922831117,'2020-03-22 18:43:47','2020-03-22 18:43:47'),
  (276,36,-8.664263342592793,115.2385345927292,'2020-03-22 18:43:47','2020-03-22 18:43:47'),
  (277,36,-8.663929240875744,115.23850240622102,'2020-03-22 18:43:48','2020-03-22 18:43:48'),
  (278,36,-8.663862950817217,115.23797132883607,'2020-03-22 18:43:48','2020-03-22 18:43:48'),
  (279,36,-8.66385234440678,115.23725249682008,'2020-03-22 18:43:49','2020-03-22 18:43:49'),
  (280,36,-8.66383908639329,115.2367160550171,'2020-03-22 18:43:49','2020-03-22 18:43:49'),
  (281,37,-8.677123816562204,115.22492667605742,'2020-03-22 18:45:08','2020-03-22 18:45:08'),
  (282,37,-8.676853362547822,115.22489717175826,'2020-03-22 18:45:09','2020-03-22 18:45:09'),
  (283,37,-8.67659086287695,115.22491594722136,'2020-03-22 18:45:10','2020-03-22 18:45:10'),
  (284,37,-8.676336317566284,115.22495349814757,'2020-03-22 18:45:10','2020-03-22 18:45:10'),
  (285,37,-8.676333666051734,115.22503396441802,'2020-03-22 18:45:11','2020-03-22 18:45:11'),
  (286,37,-8.675851540583842,115.2250526984531,'2020-03-22 18:45:11','2020-03-22 18:45:11'),
  (287,37,-8.675377941833215,115.22511707146946,'2020-03-22 18:45:12','2020-03-22 18:45:12'),
  (288,37,-8.675126047223422,115.22514121135059,'2020-03-22 18:45:12','2020-03-22 18:45:12'),
  (289,38,-8.673672044755987,115.22642834040606,'2020-03-22 18:46:14','2020-03-22 18:46:14'),
  (290,38,-8.673687953955833,115.22695405337298,'2020-03-22 18:46:15','2020-03-22 18:46:15'),
  (291,38,-8.673701211621855,115.22773725840533,'2020-03-22 18:46:16','2020-03-22 18:46:16'),
  (292,38,-8.673709166221236,115.22815377644902,'2020-03-22 18:46:16','2020-03-22 18:46:16'),
  (293,39,-8.6929045018612,115.22950627902907,'2020-03-22 18:48:11','2020-03-22 18:48:11'),
  (294,39,-8.693055631484667,115.23007490734022,'2020-03-22 18:48:11','2020-03-22 18:48:11'),
  (295,39,-8.693166990115584,115.23064085344237,'2020-03-22 18:48:12','2020-03-22 18:48:12'),
  (296,39,-8.693222669418631,115.23096271852415,'2020-03-22 18:48:13','2020-03-22 18:48:13'),
  (297,40,-8.67556809938315,115.22826550786513,'2020-03-22 18:50:37','2020-03-22 18:50:37'),
  (298,40,-8.675594614581993,115.22999821488875,'2020-03-22 18:50:37','2020-03-22 18:50:37'),
  (299,40,-8.675607872180702,115.23010818545836,'2020-03-22 18:50:38','2020-03-22 18:50:38'),
  (300,41,-8.680144023792309,115.23028559795453,'2020-03-22 18:55:26','2020-03-22 18:55:26'),
  (301,41,-8.680149326767578,115.23000396600797,'2020-03-22 18:55:27','2020-03-22 18:55:27'),
  (302,41,-8.680144023792309,115.22977866045072,'2020-03-22 18:55:27','2020-03-22 18:55:27'),
  (303,41,-8.68014667527995,115.229649914418,'2020-03-22 18:55:28','2020-03-22 18:55:28'),
  (304,42,-8.687979370817466,115.23039379741441,'2020-03-22 18:56:34','2020-03-22 18:56:34'),
  (305,42,-8.688058913777253,115.23076394225846,'2020-03-22 18:56:35','2020-03-22 18:56:35'),
  (306,42,-8.68812254813295,115.23115018035661,'2020-03-22 18:56:35','2020-03-22 18:56:35'),
  (307,42,-8.688217999646229,115.23171612645875,'2020-03-22 18:56:36','2020-03-22 18:56:36'),
  (308,42,-8.688215348215634,115.23220965291749,'2020-03-22 18:56:36','2020-03-22 18:56:36'),
  (309,43,-8.694263431824679,115.23601781903534,'2020-03-22 18:58:35','2020-03-22 18:58:35'),
  (310,43,-8.69454978160002,115.23604464112549,'2020-03-22 18:58:36','2020-03-22 18:58:36'),
  (311,43,-8.694986728362684,115.23608701865047,'2020-03-22 18:58:36','2020-03-22 18:58:36'),
  (312,43,-8.695390676593185,115.23612456957667,'2020-03-22 18:58:37','2020-03-22 18:58:37'),
  (313,43,-8.69579779477763,115.23616748492091,'2020-03-22 18:58:38','2020-03-22 18:58:38'),
  (314,44,-8.797427932962606,115.18169536587773,'2020-03-22 19:00:17','2020-03-22 19:00:17'),
  (315,44,-8.797327208116227,115.18206014630375,'2020-03-22 19:00:18','2020-03-22 19:00:18'),
  (316,44,-8.797157566207757,115.18259658810673,'2020-03-22 19:00:19','2020-03-22 19:00:19'),
  (317,44,-8.797088649160242,115.18312230107365,'2020-03-22 19:00:19','2020-03-22 19:00:19'),
  (318,44,-8.797136360963744,115.18332614895878,'2020-03-22 19:00:20','2020-03-22 19:00:20'),
  (319,44,-8.79700912947409,115.18344953057347,'2020-03-22 19:00:20','2020-03-22 19:00:20'),
  (320,44,-8.796892500570161,115.18362655636845,'2020-03-22 19:00:21','2020-03-22 19:00:21'),
  (321,44,-8.796706954510938,115.18387868401585,'2020-03-22 19:00:22','2020-03-22 19:00:22'),
  (322,44,-8.79648164845686,115.18406375643788,'2020-03-22 19:00:23','2020-03-22 19:00:23'),
  (323,44,-8.795952153470273,115.18430199464585,'2020-03-22 19:00:23','2020-03-22 19:00:23'),
  (324,44,-8.795469732297713,115.18448706706788,'2020-03-22 19:00:24','2020-03-22 19:00:24'),
  (325,44,-8.794918484798727,115.18448620539473,'2020-03-22 19:00:24','2020-03-22 19:00:24'),
  (338,46,-8.799374151362374,115.18142381401974,'2020-03-22 19:01:55','2020-03-22 19:01:55'),
  (339,46,-8.799588853104101,115.18179127665478,'2020-03-22 19:01:55','2020-03-22 19:01:55'),
  (340,46,-8.799665721598634,115.18209436627346,'2020-03-22 19:01:56','2020-03-22 19:01:56'),
  (341,46,-8.799808855994211,115.18233844729382,'2020-03-22 19:01:57','2020-03-22 19:01:57'),
  (342,46,-8.800034160023229,115.18276491852718,'2020-03-22 19:01:57','2020-03-22 19:01:57'),
  (343,46,-8.800283319613277,115.18327722044903,'2020-03-22 19:01:58','2020-03-22 19:01:58'),
  (344,46,-8.800479466406587,115.1836688229652,'2020-03-22 19:01:59','2020-03-22 19:01:59'),
  (349,48,-8.800879866925357,115.18491023809813,'2020-03-22 19:04:01','2020-03-22 19:04:01'),
  (350,48,-8.800818902458591,115.18449717790983,'2020-03-22 19:04:02','2020-03-22 19:04:02'),
  (351,48,-8.800689021604581,115.18409752876661,'2020-03-22 19:04:02','2020-03-22 19:04:02'),
  (352,48,-8.80055118881171,115.18374615938566,'2020-03-22 19:04:03','2020-03-22 19:04:03'),
  (353,49,-8.801338996435643,115.18399839702124,'2020-03-22 19:04:50','2020-03-22 19:04:50'),
  (354,49,-8.801431768315929,115.18422906699652,'2020-03-22 19:04:51','2020-03-22 19:04:51'),
  (355,49,-8.801585504523471,115.18466090264792,'2020-03-22 19:04:51','2020-03-22 19:04:51'),
  (356,50,-8.801868574092607,115.18470353902299,'2020-03-22 19:07:58','2020-03-22 19:07:58'),
  (357,50,-8.80196929770311,115.18504149735887,'2020-03-22 19:07:59','2020-03-22 19:07:59'),
  (358,50,-8.80216809422234,115.18557793916185,'2020-03-22 19:07:59','2020-03-22 19:07:59'),
  (359,50,-8.802258215275852,115.18586493552644,'2020-03-22 19:08:00','2020-03-22 19:08:00'),
  (360,51,-8.79789532606816,115.18616461541006,'2020-03-22 19:08:47','2020-03-22 19:08:47'),
  (361,51,-8.79801725595474,115.18651598479101,'2020-03-22 19:08:48','2020-03-22 19:08:48'),
  (362,51,-8.79825316366478,115.18716507937262,'2020-03-22 19:08:48','2020-03-22 19:08:48'),
  (363,51,-8.798337984377705,115.18741988922903,'2020-03-22 19:08:49','2020-03-22 19:08:49'),
  (364,52,-8.803668609683605,115.18405836975558,'2020-03-22 19:09:46','2020-03-22 19:09:46'),
  (365,52,-8.80377993523622,115.18437218821032,'2020-03-22 19:09:46','2020-03-22 19:09:46'),
  (366,52,-8.803946923502313,115.18490058338625,'2020-03-22 19:09:47','2020-03-22 19:09:47'),
  (367,52,-8.80408475503025,115.18521171963198,'2020-03-22 19:09:47','2020-03-22 19:09:47'),
  (368,53,-8.803004013358018,115.18427891176056,'2020-03-22 19:10:39','2020-03-22 19:10:39'),
  (369,53,-8.803141845237244,115.18466246764969,'2020-03-22 19:10:40','2020-03-22 19:10:40'),
  (370,53,-8.803332689292935,115.1851881806166,'2020-03-22 19:10:41','2020-03-22 19:10:41'),
  (371,53,-8.803433412504864,115.18546981256317,'2020-03-22 19:10:41','2020-03-22 19:10:41'),
  (372,54,-8.535919461623568,115.11696287598153,'2020-03-23 02:52:03','2020-03-23 02:52:03'),
  (373,54,-8.535977816579502,115.11727937664529,'2020-03-23 02:52:04','2020-03-23 02:52:04'),
  (374,54,-8.536094526464625,115.11754223312875,'2020-03-23 02:52:05','2020-03-23 02:52:05'),
  (375,54,-8.536243066266813,115.11762806381722,'2020-03-23 02:52:06','2020-03-23 02:52:06'),
  (376,54,-8.536434045927539,115.11765488590737,'2020-03-23 02:52:07','2020-03-23 02:52:07'),
  (382,56,-8.535919461623568,115.11696287598153,'2020-03-23 02:52:16','2020-03-23 02:52:16'),
  (383,56,-8.535977816579502,115.11727937664529,'2020-03-23 02:52:17','2020-03-23 02:52:17'),
  (384,56,-8.536094526464625,115.11754223312875,'2020-03-23 02:52:18','2020-03-23 02:52:18'),
  (385,56,-8.536243066266813,115.11762806381722,'2020-03-23 02:52:18','2020-03-23 02:52:18'),
  (386,56,-8.536434045927539,115.11765488590737,'2020-03-23 02:52:19','2020-03-23 02:52:19'),
  (387,57,-8.535919461623568,115.11696287598153,'2020-03-23 02:52:22','2020-03-23 02:52:22'),
  (388,57,-8.535977816579502,115.11727937664529,'2020-03-23 02:52:23','2020-03-23 02:52:23'),
  (389,57,-8.536094526464625,115.11754223312875,'2020-03-23 02:52:23','2020-03-23 02:52:23'),
  (390,57,-8.536243066266813,115.11762806381722,'2020-03-23 02:52:24','2020-03-23 02:52:24'),
  (391,57,-8.536434045927539,115.11765488590737,'2020-03-23 02:52:25','2020-03-23 02:52:25'),
  (392,58,-8.535919461623568,115.11696287598153,'2020-03-23 02:52:28','2020-03-23 02:52:28'),
  (393,58,-8.535977816579502,115.11727937664529,'2020-03-23 02:52:29','2020-03-23 02:52:29'),
  (394,58,-8.536094526464625,115.11754223312875,'2020-03-23 02:52:30','2020-03-23 02:52:30'),
  (395,58,-8.536243066266813,115.11762806381722,'2020-03-23 02:52:31','2020-03-23 02:52:31'),
  (396,58,-8.536434045927539,115.11765488590737,'2020-03-23 02:52:31','2020-03-23 02:52:31'),
  (397,59,-8.535919461623568,115.11696287598153,'2020-03-23 02:52:36','2020-03-23 02:52:36'),
  (398,59,-8.535977816579502,115.11727937664529,'2020-03-23 02:52:36','2020-03-23 02:52:36'),
  (399,59,-8.536094526464625,115.11754223312875,'2020-03-23 02:52:37','2020-03-23 02:52:37'),
  (400,59,-8.536243066266813,115.11762806381722,'2020-03-23 02:52:38','2020-03-23 02:52:38'),
  (401,59,-8.536434045927539,115.11765488590737,'2020-03-23 02:52:38','2020-03-23 02:52:38'),
  (402,60,-8.535919461623568,115.11696287598153,'2020-03-23 02:52:42','2020-03-23 02:52:42'),
  (403,60,-8.535977816579502,115.11727937664529,'2020-03-23 02:52:43','2020-03-23 02:52:43'),
  (404,60,-8.536094526464625,115.11754223312875,'2020-03-23 02:52:43','2020-03-23 02:52:43'),
  (405,60,-8.536243066266813,115.11762806381722,'2020-03-23 02:52:44','2020-03-23 02:52:44'),
  (406,60,-8.536434045927539,115.11765488590737,'2020-03-23 02:52:45','2020-03-23 02:52:45'),
  (407,61,-8.535919461623568,115.11696287598153,'2020-03-23 02:52:53','2020-03-23 02:52:53'),
  (408,61,-8.535977816579502,115.11727937664529,'2020-03-23 02:52:54','2020-03-23 02:52:54'),
  (409,61,-8.536094526464625,115.11754223312875,'2020-03-23 02:52:54','2020-03-23 02:52:54'),
  (410,61,-8.536243066266813,115.11762806381722,'2020-03-23 02:52:56','2020-03-23 02:52:56'),
  (411,61,-8.536434045927539,115.11765488590737,'2020-03-23 02:52:56','2020-03-23 02:52:56'),
  (412,62,-8.535919461623568,115.11696287598153,'2020-03-23 02:53:07','2020-03-23 02:53:07'),
  (413,62,-8.535977816579502,115.11727937664529,'2020-03-23 02:53:07','2020-03-23 02:53:07'),
  (414,62,-8.536094526464625,115.11754223312875,'2020-03-23 02:53:08','2020-03-23 02:53:08'),
  (415,62,-8.536243066266813,115.11762806381722,'2020-03-23 02:53:09','2020-03-23 02:53:09'),
  (416,62,-8.536434045927539,115.11765488590737,'2020-03-23 02:53:10','2020-03-23 02:53:10'),
  (417,63,-8.535919461623568,115.11696287598153,'2020-03-23 02:53:19','2020-03-23 02:53:19'),
  (418,63,-8.535977816579502,115.11727937664529,'2020-03-23 02:53:20','2020-03-23 02:53:20'),
  (419,63,-8.536094526464625,115.11754223312875,'2020-03-23 02:53:20','2020-03-23 02:53:20'),
  (420,63,-8.536243066266813,115.11762806381722,'2020-03-23 02:53:21','2020-03-23 02:53:21'),
  (421,63,-8.536434045927539,115.11765488590737,'2020-03-23 02:53:22','2020-03-23 02:53:22'),
  (422,64,-8.536733469893926,115.11598730813638,'2020-03-23 03:03:11','2020-03-23 03:03:11'),
  (423,64,-8.537369224445161,115.1160520068387,'2020-03-23 03:03:12','2020-03-23 03:03:12'),
  (424,64,-8.53806931837224,115.1160707823018,'2020-03-23 03:03:12','2020-03-23 03:03:12'),
  (425,64,-8.538262949601101,115.11606810009279,'2020-03-23 03:03:14','2020-03-23 03:03:14'),
  (426,64,-8.538711218781332,115.1157274595479,'2020-03-23 03:03:14','2020-03-23 03:03:14'),
  (427,65,-8.536520069389013,115.1151659875126,'2020-03-23 03:07:20','2020-03-23 03:07:20'),
  (428,65,-8.536462466049104,115.11519926506199,'2020-03-23 03:07:20','2020-03-23 03:07:20'),
  (429,65,-8.536462466049104,115.11524352151073,'2020-03-23 03:07:21','2020-03-23 03:07:21'),
  (430,66,-8.537498117180917,115.11472903861365,'2020-03-23 03:09:14','2020-03-23 03:09:14'),
  (431,66,-8.538437096505197,115.11419259681067,'2020-03-23 03:09:15','2020-03-23 03:09:15'),
  (432,66,-8.539305627772466,115.11385769518844,'2020-03-23 03:09:15','2020-03-23 03:09:15'),
  (433,66,-8.539831768651212,115.11368066939346,'2020-03-23 03:09:16','2020-03-23 03:09:16'),
  (434,66,-8.54009171072159,115.11357338103286,'2020-03-23 03:09:16','2020-03-23 03:09:16'),
  (435,67,-8.540481722006456,115.11251047753312,'2020-03-23 03:10:55','2020-03-23 03:10:55'),
  (436,67,-8.540709834056479,115.11254802845933,'2020-03-23 03:10:55','2020-03-23 03:10:55'),
  (437,67,-8.540810627709565,115.11262313031175,'2020-03-23 03:10:56','2020-03-23 03:10:56'),
  (438,68,-8.541929195835502,115.1131167655792,'2020-03-23 03:12:45','2020-03-23 03:12:45'),
  (439,68,-8.543785910815439,115.11396434362791,'2020-03-23 03:12:46','2020-03-23 03:12:46'),
  (440,68,-8.545197008154872,115.11472609098814,'2020-03-23 03:12:46','2020-03-23 03:12:46'),
  (441,69,-8.547052000768893,115.11783663341443,'2020-03-23 03:15:17','2020-03-23 03:15:17'),
  (442,69,-8.54770449572626,115.1175254971687,'2020-03-23 03:15:17','2020-03-23 03:15:17'),
  (443,69,-8.548001566231159,115.11727873393933,'2020-03-23 03:15:18','2020-03-23 03:15:18'),
  (444,69,-8.548187235179167,115.11719826766888,'2020-03-23 03:15:18','2020-03-23 03:15:18'),
  (445,69,-8.548293331680274,115.11698905536572,'2020-03-23 03:15:19','2020-03-23 03:15:19'),
  (446,69,-8.548346379919751,115.11657599517743,'2020-03-23 03:15:20','2020-03-23 03:15:20'),
  (447,69,-8.548685888477614,115.11609319755475,'2020-03-23 03:15:20','2020-03-23 03:15:20'),
  (448,70,-8.54942103913898,115.12238865046425,'2020-03-23 03:16:43','2020-03-23 03:16:43'),
  (449,70,-8.548545744711294,115.12268369345588,'2020-03-23 03:16:43','2020-03-23 03:16:43'),
  (450,70,-8.548089529849092,115.12286071925087,'2020-03-23 03:16:44','2020-03-23 03:16:44'),
  (451,70,-8.547686362772222,115.12280171065254,'2020-03-23 03:16:44','2020-03-23 03:16:44'),
  (452,70,-8.547206472106968,115.12293878371075,'2020-03-23 03:16:45','2020-03-23 03:16:45'),
  (453,70,-8.546946534885674,115.12306752974347,'2020-03-23 03:16:46','2020-03-23 03:16:46'),
  (454,71,-8.54733730459197,115.12250992348062,'2020-03-23 03:17:44','2020-03-23 03:17:44'),
  (455,71,-8.547072062618623,115.12175354053842,'2020-03-23 03:17:44','2020-03-23 03:17:44'),
  (456,71,-8.546859868907069,115.12122246315347,'2020-03-23 03:17:45','2020-03-23 03:17:45'),
  (457,71,-8.54671663808501,115.12078258087503,'2020-03-23 03:17:45','2020-03-23 03:17:45'),
  (458,72,-8.55268540584446,115.13419462543939,'2020-03-23 03:19:47','2020-03-23 03:19:47'),
  (459,72,-8.552372424688429,115.13433410030817,'2020-03-23 03:19:47','2020-03-23 03:19:47'),
  (460,72,-8.552144319616135,115.13445211750482,'2020-03-23 03:19:48','2020-03-23 03:19:48'),
  (461,72,-8.552234500707554,115.13480080467676,'2020-03-23 03:19:49','2020-03-23 03:19:49'),
  (462,72,-8.55231937700939,115.13509048325037,'2020-03-23 03:19:49','2020-03-23 03:19:49'),
  (463,72,-8.552568701036673,115.13575567108606,'2020-03-23 03:19:50','2020-03-23 03:19:50'),
  (464,72,-8.551985176461564,115.13594879013513,'2020-03-23 03:19:50','2020-03-23 03:19:50'),
  (465,72,-8.551249821911885,115.13618445844943,'2020-03-23 03:19:51','2020-03-23 03:19:51'),
  (466,72,-8.552929657808763,115.13565600763401,'2020-03-23 03:19:52','2020-03-23 03:19:52'),
  (467,72,-8.55364579970544,115.13543606649479,'2020-03-23 03:19:52','2020-03-23 03:19:52'),
  (468,72,-8.553735980441438,115.13536096464237,'2020-03-23 03:19:53','2020-03-23 03:19:53'),
  (469,72,-8.553582142702474,115.13472259889683,'2020-03-23 03:19:53','2020-03-23 03:19:53'),
  (470,72,-8.553025143472766,115.1348620737656,'2020-03-23 03:19:54','2020-03-23 03:19:54'),
  (471,72,-8.5523991814618,115.13503909956059,'2020-03-23 03:19:55','2020-03-23 03:19:55'),
  (480,75,-8.650775522305329,115.2370099360193,'2020-04-04 09:05:34','2020-04-04 09:05:34'),
  (481,75,-8.6506111171921,115.23746591155184,'2020-04-04 09:05:34','2020-04-04 09:05:34'),
  (482,75,-8.650505049339024,115.23776095454348,'2020-04-04 09:05:34','2020-04-04 09:05:34'),
  (483,75,-8.650425498429607,115.2380720907892,'2020-04-04 09:05:34','2020-04-04 09:05:34'),
  (484,75,-8.650372464480679,115.23829203192842,'2020-04-04 09:05:34','2020-04-04 09:05:34'),
  (485,75,-8.650330037316142,115.23845296446932,'2020-04-04 09:05:34','2020-04-04 09:05:34'),
  (486,75,-8.650245182972741,115.23878019396913,'2020-04-04 09:05:34','2020-04-04 09:05:34'),
  (487,75,-8.650144418415117,115.2391342455591,'2020-04-04 09:05:34','2020-04-04 09:05:34'),
  (488,75,-8.65007547422859,115.23942392413271,'2020-04-04 09:05:34','2020-04-04 09:05:34'),
  (489,75,-8.649990619827827,115.2397833401407,'2020-04-04 09:05:34','2020-04-04 09:05:34'),
  (490,75,-8.649926979014714,115.24007838313234,'2020-04-04 09:05:34','2020-04-04 09:05:34');
  
  /*Table structure for table `tb_digitasi_jalan` */
  
  DROP TABLE IF EXISTS `tb_digitasi_jalan`;
  
  CREATE TABLE `tb_digitasi_jalan` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `id_admin` int(11) DEFAULT NULL,
    `nama` varchar(255) DEFAULT NULL,
    `kecamatan` varchar(255) DEFAULT NULL,
    `kota` varchar(255) DEFAULT NULL,
    `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8mb4;
  
  /*Data for the table `tb_digitasi_jalan` */
  
  insert  into `tb_digitasi_jalan`(`id`,`id_admin`,`nama`,`kecamatan`,`kota`,`created_at`,`updated_at`) values 
  (10,1,'Jalan Tukad Musi VI','Kecamatan Denpasar Barat','Kota Denpasar','2020-03-22 19:57:10','2020-03-22 12:45:33'),
  (11,1,'Jalan Tukad Musi V','Kecamatan Denpasar Selatan','Kota Denpasar','2020-03-22 19:57:10','2020-03-22 13:01:35'),
  (12,1,'Jalan Tukad Batanghari II','Kecamatan Denpasar Selatan','Kota Denpasar','2020-03-22 19:57:10','2020-03-22 13:02:40'),
  (14,1,'Jalan Tukad Pancoran II','Kecamatan Denpasar Selatan','Kota Denpasar','2020-03-22 19:57:10','2020-03-22 13:06:43'),
  (15,1,'Jalan Tukad Banyu Poh','Kecamatan Denpasar Barat','Kota Denpasar','2020-03-22 19:57:10','2020-03-22 13:09:18'),
  (16,1,'Jalan Paku Sari','Kecamatan Denpasar Selatan','Kota Denpasar','2020-03-22 19:57:10','2020-03-22 13:10:43'),
  (17,1,'Jalan Pendidikan I','Kecamatan Denpasar Selatan','Kota Denpasar','2020-03-22 19:57:10','2020-03-22 13:11:58'),
  (18,1,'Jalan Kerta Dalem Sari IV','Kecamatan Denpasar Selatan','Kota Denpasar','2020-03-22 19:57:10','2020-03-22 13:14:14'),
  (19,1,'Jalan Tukad Badung XX','Kecamatan Denpasar Selatan','Kota Denpasar','2020-03-22 19:57:10','2020-03-22 13:15:47'),
  (32,1,'Jalan Tukad Petanu Gg. Walet','Kecamatan Denpasar Selatan','Kota Denpasar','2020-03-22 19:57:10','2020-03-22 18:36:52'),
  (34,1,'Jalan Terompong','Kecamatan Denpasar Timur','Kota Denpasar','2020-03-22 19:57:10','2020-03-22 18:40:35'),
  (35,1,'Jalan Tukad Mas','Kecamatan Denpasar Timur','Kota Denpasar','2020-03-22 19:57:10','2020-03-22 18:41:58'),
  (36,1,'Jalan Dewi Madri X','Kecamatan Denpasar Timur','Kota Denpasar','2020-03-22 19:57:10','2020-03-22 18:43:44'),
  (37,1,'Jalan Tukad Jinah','Kecamatan Denpasar Selatan','Kota Denpasar','2020-03-22 19:57:10','2020-03-22 18:45:06'),
  (38,1,'Jalan Tukad Gangga I','Kecamatan Denpasar Selatan','Kota Denpasar','2020-03-22 19:57:10','2020-03-22 18:46:11'),
  (39,1,'Jalan Tukad Pancoran XII','Kecamatan Denpasar Selatan','Kota Denpasar','2020-03-22 19:57:10','2020-03-22 18:48:07'),
  (40,1,'Jalan Tukad Musi IV','Kecamatan Denpasar Selatan','Kota Denpasar','2020-03-22 19:57:10','2020-03-22 18:50:34'),
  (41,1,'Jalan Tukad Batanghari VI','Kecamatan Denpasar Selatan','Kota Denpasar','2020-03-22 19:57:10','2020-03-22 18:55:24'),
  (42,1,'Jalan Tukad Batang Hari Gang XVII','Kecamatan Denpasar Selatan','Kota Denpasar','2020-03-22 19:57:10','2020-03-22 18:56:31'),
  (43,1,'Jalan Tukad Badung XX E','Kecamatan Denpasar Selatan','Kota Denpasar','2020-03-22 19:57:10','2020-03-22 18:58:32'),
  (44,1,'Jalan Nuansa Udayana Barat','Kecamatan Kuta Selatan','Kabupaten Badung','2020-03-22 19:57:10','2020-03-22 19:00:14'),
  (46,1,'Jalan Nuansa Barat IV','Kecamatan Kuta Selatan','Kabupaten Badung','2020-03-22 19:57:10','2020-03-22 19:01:52'),
  (48,1,'Jl. Nuansa Utama XXXII','Kecamatan Kuta Selatan','Kabupaten Badung','2020-03-22 19:57:10','2020-03-22 19:03:58'),
  (49,1,'Jl. Nuansa Utama Selatan II','Kecamatan Kuta Selatan','Kabupaten Badung','2020-03-22 19:57:10','2020-03-22 19:04:48'),
  (50,1,'Jalan Nuansa Utama Selatan VII','Kecamatan Kuta Selatan','Kabupaten Badung','2020-03-22 19:57:10','2020-03-22 19:07:56'),
  (51,1,'Nuansa Utama VI','Kecamatan Kuta Selatan','Kabupaten Badung','2020-03-22 19:57:10','2020-03-22 19:08:43'),
  (52,1,'Jalan Nuansa Utama Selatan XXIII','Kecamatan Kuta Selatan','Kabupaten Badung','2020-03-22 19:57:10','2020-03-22 19:09:43'),
  (53,1,'Jalan Nuansa Utama Selatan XVII','Kecamatan Kuta Selatan','Kabupaten Badung','2020-03-22 19:57:10','2020-03-22 19:10:37'),
  (54,1,'Jalan Pulau Menjangan','Kecamatan Tabanan','Kabupaten Tabanan','2020-03-23 03:00:48','2020-03-23 02:51:59'),
  (64,1,'Jalan Pulau Buton','Kabupaten Tabanan','Kabupaten Tabanan','2020-03-23 03:07:49','2020-03-23 03:03:08'),
  (65,1,'Jalan Pulau Batam','Kecamatan Tabanan','Kabupaten Tabanan','2020-03-23 03:08:06','2020-03-23 03:07:16'),
  (66,1,'Jalan Pulau Nias 17','Kecamatan Tabanan','Kabupaten Tabanan','2020-03-23 03:09:48','2020-03-23 03:09:10'),
  (67,1,'Jalan Pulau Nias 37','Kecamatan Tabanan','Kabupaten Tabanan','2020-03-23 03:11:30','2020-03-23 03:10:52'),
  (68,1,'Jalan Dr Ir Soekarno','Kecamatan Tabanan','Kabupaten Tabanan','2020-03-23 03:13:09','2020-03-23 03:12:42'),
  (69,1,'Jalan Sekar Tunjung','Kecamatan Tabanan','Kabupaten Tabanan','2020-03-23 03:15:48','2020-03-23 03:15:14'),
  (70,1,'Jalan Pd Indah 2','Kecamatan Tabanan','Kabupaten Tabanan','2020-03-23 03:17:04','2020-03-23 03:16:39'),
  (71,1,'Jalan Pd Indah 20','Kecamatan Tabanan','Kabupaten Tabanan','2020-03-23 03:18:07','2020-03-23 03:17:40'),
  (72,1,'Jalan By Pass Kediri 88','Kecamatan Kediri','Kabupaten Tabanan','2020-03-23 03:20:17','2020-03-23 03:19:44'),
  (75,NULL,'Jalan Kembang Matahari','Kecamatan Denpasar Timur','Kota Denpasar','2020-04-04 09:05:34','2020-04-04 09:05:34');
  
  /*Table structure for table `users` */
  
  DROP TABLE IF EXISTS `users`;
  
  CREATE TABLE `users` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(255) DEFAULT NULL,
    `username` varchar(255) DEFAULT NULL,
    `email` varchar(255) DEFAULT NULL,
    `password` varchar(255) DEFAULT NULL,
    `user_role` enum('admin','user') DEFAULT NULL,
    `status` enum('0','1') DEFAULT NULL,
    `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;
  
  /*Data for the table `users` */
  
  insert  into `users`(`id`,`name`,`username`,`email`,`password`,`user_role`,`status`,`created_at`,`updated_at`) values 
  (1,'widiana',NULL,'widiana@me.com','$2y$10$Av.ql.Wj7g9AaMfQMb551.Q155VZvxr99VNujxHxE6DXJpYt78A1S','admin','0','2020-03-21 15:38:21','2020-03-21 07:38:21'),
  (2,'user',NULL,'user@me.com','$2y$10$55dEpf3iNgbgYkYYp3nz2utEr1dHAMp/dvqKRKoT10Mqno3s/6cGS','user','0','2020-03-16 07:40:12','2020-03-16 07:40:12'),
  (3,'Gaskan',NULL,'juliartarya06@gmail.com','$2y$10$XyUTqRDa18fbZc4eJdQ5K.4Fg4puI0vpa2NnMN8sQF9pyIJobZRGm','user','0','2020-03-23 02:20:03','2020-03-23 02:20:03');
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  