-- --------------------------------------------------------
-- Server OS:                    debian-linux-gnu
-- HeidiSQL Version:             9.4.0.5125
-- --------------------------------------------------------


-- Dumping structure for table pdam_web.absen_petugas_pemasangan
CREATE TABLE IF NOT EXISTS `absen_petugas_pemasangan` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `no_daftarpb` varchar(20) NOT NULL,
  `kode_petugas` varchar(5) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table pdam_web.absen_petugas_pemasangan: ~7 rows (approximately)
DELETE FROM `absen_petugas_pemasangan`;
INSERT INTO `absen_petugas_pemasangan` (`id`, `no_daftarpb`, `kode_petugas`, `created_at`, `updated_at`) VALUES
	(1, 'B20180000001', 'B46', '2018-08-02 08:13:50', '2018-08-02 08:13:50'),
	(2, 'B20180000001', 'B47', '2018-08-02 08:13:50', '2018-08-02 08:13:50'),
	(33, 'T20180000017', 'B46', '2018-08-08 10:05:43', '2018-08-08 10:05:43'),
	(34, 'T20180000017', 'B47', '2018-08-08 10:05:43', '2018-08-08 10:05:43'),
	(35, 'T20180000002', '09', '2018-08-10 08:21:38', '2018-08-10 08:21:38'),
	(36, 'T20180000002', 'TN5', '2018-08-10 08:21:38', '2018-08-10 08:21:38'),
	(37, 'T20180000002', '33', '2018-08-10 08:21:38', '2018-08-10 08:21:38');

-- Dumping structure for table pdam_web.detail_material
CREATE TABLE IF NOT EXISTS `detail_material` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `no_material` varchar(50) DEFAULT NULL,
  `jenis_barang` varchar(50) DEFAULT NULL,
  `meter` varchar(50) DEFAULT NULL,
  `ukuran` varchar(50) DEFAULT NULL,
  `jumlah` double(5,3) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `no_daftarpb` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table pdam_web.detail_material: ~43 rows (approximately)
DELETE FROM `detail_material`;
INSERT INTO `detail_material` (`id`, `no_material`, `jenis_barang`, `meter`, `ukuran`, `jumlah`, `created_at`, `updated_at`, `no_daftarpb`) VALUES
	(1, 'TPB201800005', 'PIPA GALVANIS', '0', '0.75', 1.000, '2018-08-04 10:24:01', '2018-08-04 10:24:01', 'T20180000017'),
	(2, 'TPB201800005', 'PIPA GALVANIS', '0', '1 1/4', 1.000, '2018-08-04 10:24:01', '2018-08-04 10:24:01', 'T20180000017'),
	(3, 'TPB201800005', 'PIPA PE-S4-NOD25MM', '0', '0.75', 4.000, '2018-08-04 10:24:01', '2018-08-04 10:24:01', 'T20180000017'),
	(4, 'TPB201800005', 'AFTAP KRAN', '0', '1/2', 1.000, '2018-08-04 10:24:01', '2018-08-04 10:24:01', 'T20180000017'),
	(5, 'TPB201800005', 'ELBOW PE', '0', '3/4 (90)', 1.000, '2018-08-04 10:24:01', '2018-08-04 10:24:01', 'T20180000017'),
	(6, 'TPB201800005', 'DOUBLE NIPLE', '0', '3/4', 4.000, '2018-08-04 10:24:01', '2018-08-04 10:24:01', 'T20180000017'),
	(7, 'TPB201800005', 'ADAPTOR MALE', '0', '3/4', 1.000, '2018-08-04 10:24:01', '2018-08-04 10:24:01', 'T20180000017'),
	(8, 'TPB201800005', 'K N I E', '0', '3/4', 4.000, '2018-08-04 10:24:01', '2018-08-04 10:24:01', 'T20180000017'),
	(9, 'TPB201800005', 'KAS METER', '0', 'KECIL', 1.000, '2018-08-04 10:24:02', '2018-08-04 10:24:02', 'T20180000017'),
	(10, 'TPB201800005', 'K O P L I N G', '0', '1/2', 1.000, '2018-08-04 10:24:02', '2018-08-04 10:24:02', 'T20180000017'),
	(11, 'TPB201800005', 'KRAN LEID', '0', '1/2', 1.000, '2018-08-04 10:24:02', '2018-08-04 10:24:02', 'T20180000017'),
	(12, 'TPB201800005', 'KAWAT TEMBAGA', '0', '1 MM', 1.000, '2018-08-04 10:24:02', '2018-08-04 10:24:02', 'T20180000017'),
	(13, 'TPB201800005', 'P L U G E N', '0', '3/4', 1.000, '2018-08-04 10:24:02', '2018-08-04 10:24:02', 'T20180000017'),
	(14, 'TPB201800005', 'PAK KOPLING', '0', '1/2', 1.000, '2018-08-04 10:24:02', '2018-08-04 10:24:02', 'T20180000017'),
	(15, 'TPB201800005', 'PLAT P.A', '0', 'BARU', 1.000, '2018-08-04 10:24:02', '2018-08-04 10:24:02', 'T20180000017'),
	(16, 'TPB201800005', 'R. STUKKEN', '0', '3/4 X 1/2', 3.000, '2018-08-04 10:24:02', '2018-08-04 10:24:02', 'T20180000017'),
	(17, 'TPB201800005', 'STOP KRAN', '0', '3/4', 1.000, '2018-08-04 10:24:02', '2018-08-04 10:24:02', 'T20180000017'),
	(18, 'TPB201800005', 'SADLE KLEM G.I.', '0', '100 X 1', 1.000, '2018-08-04 10:24:03', '2018-08-04 10:24:03', 'T20180000017'),
	(19, 'TPB201800005', 'T. GELIJK', '0', '3/4', 1.000, '2018-08-04 10:24:03', '2018-08-04 10:24:03', 'T20180000017'),
	(20, 'TPB201800005', 'TIMAH PLOMBIR', '0', '-', 1.000, '2018-08-04 10:24:03', '2018-08-04 10:24:03', 'T20180000017'),
	(21, 'TPB201800005', 'VERLOOP RING', '0', '1 X 3/4', 1.000, '2018-08-04 10:24:03', '2018-08-04 10:24:03', 'T20180000017'),
	(22, 'TPB201800005', 'KENT', '1', '0.5', 1.000, '2018-08-04 10:24:03', '2018-08-04 10:24:03', 'T20180000017'),
	(23, 'TPB201800006', 'PIPA GALVANIS', '0', '0.75', 1.000, '2018-08-10 08:13:33', '2018-08-10 08:13:33', 'T20180000025'),
	(24, 'TPB201800006', 'PIPA GALVANIS', '0', '1 1/4', 1.000, '2018-08-10 08:13:34', '2018-08-10 08:13:34', 'T20180000025'),
	(25, 'TPB201800006', 'PIPA PE', '0', 'I/2', 5.000, '2018-08-10 08:13:34', '2018-08-10 08:13:34', 'T20180000025'),
	(26, 'TPB201800006', 'AFTAP KRAN', '0', '1/2', 1.000, '2018-08-10 08:13:34', '2018-08-10 08:13:34', 'T20180000025'),
	(27, 'TPB201800006', 'ELBOW P.E.', '0', '1/2', 1.000, '2018-08-10 08:13:34', '2018-08-10 08:13:34', 'T20180000025'),
	(28, 'TPB201800006', 'DOUBLE NIPLE', '0', '3/4', 4.000, '2018-08-10 08:13:34', '2018-08-10 08:13:34', 'T20180000025'),
	(29, 'TPB201800006', 'K N I E', '0', '3/4', 4.000, '2018-08-10 08:13:34', '2018-08-10 08:13:34', 'T20180000025'),
	(30, 'TPB201800006', 'KAS METER', '0', 'KECIL', 1.000, '2018-08-10 08:13:34', '2018-08-10 08:13:34', 'T20180000025'),
	(31, 'TPB201800006', 'K O P L I N G', '0', '1/2', 1.000, '2018-08-10 08:13:34', '2018-08-10 08:13:34', 'T20180000025'),
	(32, 'TPB201800006', 'KRAN LEID', '0', '1/2', 1.000, '2018-08-10 08:13:34', '2018-08-10 08:13:34', 'T20180000025'),
	(33, 'TPB201800006', 'KAWAT TEMBAGA', '0', '1 MM', 1.000, '2018-08-10 08:13:34', '2018-08-10 08:13:34', 'T20180000025'),
	(34, 'TPB201800006', 'P L U G E N', '0', '3/4', 1.000, '2018-08-10 08:13:34', '2018-08-10 08:13:34', 'T20180000025'),
	(35, 'TPB201800006', 'PAK KOPLING', '0', '1/2', 1.000, '2018-08-10 08:13:34', '2018-08-10 08:13:34', 'T20180000025'),
	(36, 'TPB201800006', 'PLAT P.A', '0', 'BARU', 1.000, '2018-08-10 08:13:34', '2018-08-10 08:13:34', 'T20180000025'),
	(37, 'TPB201800006', 'R. STUKKEN', '0', '3/4 X 1/2', 3.000, '2018-08-10 08:13:34', '2018-08-10 08:13:34', 'T20180000025'),
	(38, 'TPB201800006', 'STOP KRAN', '0', '3/4', 1.000, '2018-08-10 08:13:34', '2018-08-10 08:13:34', 'T20180000025'),
	(39, 'TPB201800006', 'SADLE KLEM G.I.', '0', '150 X 1', 1.000, '2018-08-10 08:13:34', '2018-08-10 08:13:34', 'T20180000025'),
	(40, 'TPB201800006', 'T. GELIJK', '0', '3/4', 1.000, '2018-08-10 08:13:34', '2018-08-10 08:13:34', 'T20180000025'),
	(41, 'TPB201800006', 'TIMAH PLOMBIR', '0', '-', 1.000, '2018-08-10 08:13:34', '2018-08-10 08:13:34', 'T20180000025'),
	(42, 'TPB201800006', 'VERLOOP RING', '0', '1 X 3/4', 1.000, '2018-08-10 08:13:34', '2018-08-10 08:13:34', 'T20180000025'),
	(43, 'TPB201800006', 'KENT', '1', '0.5', 1.000, '2018-08-10 08:13:34', '2018-08-10 08:13:34', 'T20180000025');

-- Dumping structure for table pdam_web.guna_persil
CREATE TABLE IF NOT EXISTS `guna_persil` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kode_tarif` char(5) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guna_persil` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jenis_persil` char(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `harga_bsi_fix` int(11) DEFAULT NULL,
  `kd_gunapersil` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pdam_web.guna_persil: ~61 rows (approximately)
DELETE FROM `guna_persil`;
INSERT INTO `guna_persil` (`id`, `kode_tarif`, `guna_persil`, `jenis_persil`, `harga_bsi_fix`, `kd_gunapersil`) VALUES
	(1, '1', 'RUMAH SUSUN SEWA', 'd', NULL, NULL),
	(2, '1', 'PENJUALAN UMUM                      ', 'c', NULL, NULL),
	(3, '1', 'SOSIAL UMUM', 'a', NULL, NULL),
	(4, '1', 'RUMAH IBADAH                                      ', 'b', 0, 13),
	(5, '1', 'MCK / WC UMUM', 'a', 0, 14),
	(6, '5', 'PELABUHAN UDARA                                   ', '', 50000000, 52),
	(7, '5', 'PELABUHAN LAUT                                    ', '', 50000000, 51),
	(8, '2A.1', 'SEKOLAH SWASTA AKREDITASI C', '', 0, 29),
	(9, '2A.1', 'PONDOK PESANTREN                   ', '', 0, 22),
	(10, '2A.1', 'YAYASAN SOSIAL                                    ', '', 0, 23),
	(11, '2A.1', 'SEKOLAH NEGERI                                    ', '', 0, 24),
	(12, '2A.1', 'PANTI ASUHAN / JOMPO', '', 0, 23),
	(13, '2A.1', 'PERKUMPULAN SOSIAL / LSM', '', NULL, NULL),
	(14, '2A.1', 'BALAI RT-RW', '', 0, 28),
	(15, '2B', 'KAMAR MANDI UMUM, PONTEN / WC UMUM', 'a', 500000, 88),
	(16, '2B', 'RUMAH SAKIT PEMERINTAH (NON KOMERSIAL)', '', 500000, 25),
	(17, '3B.1', 'RUMAH SAKIT PEMERINTAH (KOMERSIAL)', 'b', 1000000, 85),
	(18, '3B.1', 'USAHA KECIL (KHUSUS)', '', NULL, NULL),
	(19, '3B.1', 'USAHA KECIL', 'a', NULL, NULL),
	(20, '3B.1', 'USAHA SWASTA / LOSMEN', 'a', NULL, NULL),
	(21, '3B.1', 'TOKO (DIJALAN < 6,5M)', 'a', NULL, NULL),
	(22, '3B.1', 'KANTOR', 'a', NULL, NULL),
	(23, '3B.1', 'TOKO (DIJALAN >= 6,5M)', 'a', NULL, NULL),
	(24, '3B.2', 'INDUSTRI KECIL                                    ', '', NULL, NULL),
	(25, '3C.1', 'USAHA KECIL', 'a', NULL, NULL),
	(26, '3C.1', 'USAHA KECIL/ASRAMA', 'a', NULL, NULL),
	(27, '3C.1', 'YAYASAN KOMERSIAL', '', NULL, NULL),
	(29, '3C.1', 'SEKOLAH SWASTA', '', NULL, NULL),
	(30, '3C.1', 'PASAR PEMERINTAH                                  ', 'b', 500000, 33),
	(31, '3C.1', 'YAYASAN KOMERSIAL / SARANA OLAH RAGA', '', NULL, NULL),
	(32, '3C.2', 'RT 5', '', NULL, NULL),
	(33, '3C.2', 'PERUMAHAN RT 5', 'c', NULL, NULL),
	(34, '4B.1', 'KANTOR PARPOL', '', 500000, 77),
	(35, '4B.1', 'INSTANSI PEMERINTAH', '', 500000, 37),
	(36, '4B.1', 'KEDUTAAN / KONSULAT ASING                         ', '', NULL, NULL),
	(37, '4C', 'PERGURUAN TINGGI NEGERI AKREDITASI A DAN PERGURUAN TINGGI SWASTA YANG MEMILIKI PROGRAM PENDIDIKAN (JURUSAN) AKREDITASI A', 'a', NULL, NULL),
	(38, '4C', 'RUMAH SAKIT BESAR SWASTA', 'b', NULL, NULL),
	(39, '4C', 'INDUSTRI BESAR                                    ', '', NULL, NULL),
	(40, '4D', 'USAHA BESAR', 'e', NULL, NULL),
	(41, '4D', 'KANTOR SWASTA    ', 'a', NULL, NULL),
	(42, '4D', 'RUMAH MAKAN', 'b', NULL, NULL),
	(43, '4D', 'HOTEL BINTANG 2 KEBAWAH', 'c', NULL, NULL),
	(44, '4D', 'PASAR SWASTA', 'd', NULL, NULL),
	(45, '4D', 'HOTEL BINTANG 3 KEATAS', 'c', NULL, NULL),
	(46, '4D', 'KOMPLEK PERTOKOAN', 'a', NULL, NULL),
	(47, '4D', 'NIAGA', 'a', NULL, NULL),
	(48, '4D', 'TOKO/GUDANG', 'a', NULL, NULL),
	(49, '4D', 'SHOW ROOM MOBIL', 'a', NULL, NULL),
	(50, '4D', 'RUMAH SAKIT SWASTA', 'a', NULL, NULL),
	(51, '4D', 'APARTEMEN', 'c', NULL, NULL),
	(52, '4D', 'HOTEL', 'c', NULL, NULL),
	(53, '53a', 'PDAM SIDOARJO                                     ', '', NULL, NULL),
	(54, '53a1', 'PDAM SIDOARJO', '', NULL, NULL),
	(55, '53b', 'PDAM GRESIK                                       ', '', NULL, NULL),
	(56, '53c', 'PDAM PASURUAN                                     ', '', NULL, NULL),
	(57, '53e', 'RACI PASURUAN', '', NULL, NULL),
	(58, '53f', 'PDAM GRESIK - BANGKINGAN        ', '', NULL, NULL),
	(59, '53g', 'HARMONY PASURUAN', '', NULL, NULL),
	(60, '53h', 'RACI PASURUAN', '', NULL, NULL),
	(61, '53i', 'PAGAK BANGIL KAB. PASURUAN', '', NULL, NULL),
	(62, '53j', 'TNI-AL GERUNGAN PASURUAN', '', NULL, NULL);

-- Dumping structure for table pdam_web.harga_galian_rekondisi
CREATE TABLE IF NOT EXISTS `harga_galian_rekondisi` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kode_jenis_pekerjaan` char(20) NOT NULL DEFAULT '0',
  `jenis_pipa` char(15) NOT NULL DEFAULT '0',
  `letak_pipa` char(50) NOT NULL DEFAULT '0',
  `harga_galian` int(11) NOT NULL DEFAULT '0',
  `harga_rekondisi` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table pdam_web.harga_galian_rekondisi: ~243 rows (approximately)
DELETE FROM `harga_galian_rekondisi`;
INSERT INTO `harga_galian_rekondisi` (`id`, `kode_jenis_pekerjaan`, `jenis_pipa`, `letak_pipa`, `harga_galian`, `harga_rekondisi`, `created_at`, `updated_at`) VALUES
	(1, 'TYPE I (A)', 'PVC OD - 110', 'DI BAHU JALAN', 50260, 51696, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(2, 'TYPE I (A)', 'PVC OD - 110', 'DI PERKERASAN', 50260, 61359, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(3, 'TYPE I (A)', 'PVC OD - 160', 'DI BAHU JALAN', 60353, 58158, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(4, 'TYPE I (A)', 'PVC OD - 160', 'DI PERKERASAN', 60353, 69029, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(5, 'TYPE I (A)', 'PVC OD - 225', 'DI BAHU JALAN', 89814, 77543, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(6, 'TYPE I (A)', 'PVC OD - 225', 'DI PERKERASAN', 89814, 92038, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(7, 'TYPE I (A)', 'PVC OD - 260', 'DI BAHU JALAN', 109520, 90467, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(8, 'TYPE I (A)', 'PVC OD - 260', 'DI PERKERASAN', 109520, 107378, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(9, 'TYPE I (A)', 'PVC OD - 315', 'DI BAHU JALAN', 132809, 103391, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(10, 'TYPE I (A)', 'PVC OD - 315', 'DI PERKERASAN', 132809, 122718, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(11, 'TYPE I (A)', 'PVC OD - 63', 'DI BAHU JALAN', 50260, 51696, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(12, 'TYPE I (A)', 'PVC OD - 63', 'DI PERKERASAN', 50260, 61359, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(13, 'TYPE I (A)', 'PVC OD - 90', 'DI BAHU JALAN', 50260, 51696, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(14, 'TYPE I (A)', 'PVC OD - 90', 'DI PERKERASAN', 50260, 61359, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(15, 'TYPE I (B)', 'PVC OD - 110', 'DI BAHU JALAN', 50972, 51696, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(16, 'TYPE I (B)', 'PVC OD - 110', 'DI PERKERASAN', 50972, 69898, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(17, 'TYPE I (B)', 'PVC OD - 160', 'DI BAHU JALAN', 61153, 58158, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(18, 'TYPE I (B)', 'PVC OD - 160', 'DI PERKERASAN', 61153, 78635, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(19, 'TYPE I (B)', 'PVC OD - 225', 'DI BAHU JALAN', 90881, 77543, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(20, 'TYPE I (B)', 'PVC OD - 225', 'DI PERKERASAN', 90881, 104847, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(21, 'TYPE I (B)', 'PVC OD - 260', 'DI BAHU JALAN', 110765, 90467, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(22, 'TYPE I (B)', 'PVC OD - 260', 'DI PERKERASAN', 110765, 122321, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(23, 'TYPE I (B)', 'PVC OD - 315', 'DI BAHU JALAN', 134231, 103391, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(24, 'TYPE I (B)', 'PVC OD - 315', 'DI PERKERASAN', 134231, 139796, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(25, 'TYPE I (B)', 'PVC OD - 63', 'DI BAHU JALAN', 50972, 51696, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(26, 'TYPE I (B)', 'PVC OD - 63', 'DI PERKERASAN', 50972, 69898, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(27, 'TYPE I (B)', 'PVC OD - 90', 'DI BAHU JALAN', 50972, 51696, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(28, 'TYPE I (B)', 'PVC OD - 90', 'DI PERKERASAN', 50972, 69898, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(29, 'TYPE I (C)', 'PVC OD - 110', 'DI BAHU JALAN', 48833, 51696, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(30, 'TYPE I (C)', 'PVC OD - 110', 'DI PERKERASAN', 48833, 76506, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(31, 'TYPE I (C)', 'PVC OD - 160', 'DI BAHU JALAN', 58747, 58158, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(32, 'TYPE I (C)', 'PVC OD - 160', 'DI PERKERASAN', 58747, 86069, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(33, 'TYPE I (C)', 'PVC OD - 225', 'DI BAHU JALAN', 87674, 77543, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(34, 'TYPE I (C)', 'PVC OD - 225', 'DI PERKERASAN', 87674, 114758, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(35, 'TYPE I (C)', 'PVC OD - 260', 'DI BAHU JALAN', 107023, 90467, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(36, 'TYPE I (C)', 'PVC OD - 260', 'DI PERKERASAN', 107023, 133885, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(37, 'TYPE I (C)', 'PVC OD - 315', 'DI BAHU JALAN', 129955, 103391, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(38, 'TYPE I (C)', 'PVC OD - 315', 'DI PERKERASAN', 129955, 153011, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(39, 'TYPE I (C)', 'PVC OD - 63', 'DI BAHU JALAN', 48833, 51696, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(40, 'TYPE I (C)', 'PVC OD - 63', 'DI PERKERASAN', 48833, 76506, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(41, 'TYPE I (C)', 'PVC OD - 90', 'DI BAHU JALAN', 48833, 51696, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(42, 'TYPE I (C)', 'PVC OD - 90', 'DI PERKERASAN', 48833, 76506, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(43, 'TYPE II (A)', 'PVC OD - 110', 'DI BAHU JALAN', 54623, 64897, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(44, 'TYPE II (A)', 'PVC OD - 110', 'DI PERKERASAN', 57902, 184066, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(45, 'TYPE II (A)', 'PVC OD - 160', 'DI BAHU JALAN', 65261, 73009, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(46, 'TYPE II (A)', 'PVC OD - 160', 'DI PERKERASAN', 68949, 207074, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(47, 'TYPE II (A)', 'PVC OD - 225', 'DI BAHU JALAN', 96359, 97345, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(48, 'TYPE II (A)', 'PVC OD - 225', 'DI PERKERASAN', 101277, 276098, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(49, 'TYPE II (A)', 'PVC OD - 260', 'DI BAHU JALAN', 117156, 113569, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(50, 'TYPE II (A)', 'PVC OD - 260', 'DI PERKERASAN', 122893, 322115, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(51, 'TYPE II (A)', 'PVC OD - 315', 'DI BAHU JALAN', 145658, 129793, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(52, 'TYPE II (A)', 'PVC OD - 315', 'DI PERKERASAN', 148092, 368131, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(53, 'TYPE II (A)', 'PVC OD - 63', 'DI BAHU JALAN', 54623, 64897, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(54, 'TYPE II (A)', 'PVC OD - 63', 'DI PERKERASAN', 57902, 184066, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(55, 'TYPE II (A)', 'PVC OD - 90', 'DI BAHU JALAN', 54623, 64897, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(56, 'TYPE II (A)', 'PVC OD - 90', 'DI PERKERASAN', 57902, 184066, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(57, 'TYPE II (B)', 'PVC OD - 110', 'DI BAHU JALAN', 54623, 64897, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(58, 'TYPE II (B)', 'PVC OD - 110', 'DI PERKERASAN', 57902, 201871, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(59, 'TYPE II (B)', 'PVC OD - 160', 'DI BAHU JALAN', 65261, 73009, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(60, 'TYPE II (B)', 'PVC OD - 160', 'DI PERKERASAN', 68949, 227105, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(61, 'TYPE II (B)', 'PVC OD - 225', 'DI BAHU JALAN', 96359, 97345, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(62, 'TYPE II (B)', 'PVC OD - 225', 'DI PERKERASAN', 101277, 302807, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(63, 'TYPE II (B)', 'PVC OD - 260', 'DI BAHU JALAN', 117156, 113569, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(64, 'TYPE II (B)', 'PVC OD - 260', 'DI PERKERASAN', 122893, 353274, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(65, 'TYPE II (B)', 'PVC OD - 315', 'DI BAHU JALAN', 145658, 129793, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(66, 'TYPE II (B)', 'PVC OD - 315', 'DI PERKERASAN', 148092, 403742, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(67, 'TYPE II (B)', 'PVC OD - 63', 'DI BAHU JALAN', 54623, 64897, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(68, 'TYPE II (B)', 'PVC OD - 63', 'DI PERKERASAN', 57902, 201871, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(69, 'TYPE II (B)', 'PVC OD - 90', 'DI BAHU JALAN', 54623, 64897, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(70, 'TYPE II (B)', 'PVC OD - 90', 'DI PERKERASAN', 57902, 201871, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(71, 'TYPE II (C)', 'PVC OD - 110', 'DI BAHU JALAN', 55335, 64897, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(72, 'TYPE II (C)', 'PVC OD - 110', 'DI PERKERASAN', 55335, 83099, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(73, 'TYPE II (C)', 'PVC OD - 160', 'DI BAHU JALAN', 66062, 73009, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(74, 'TYPE II (C)', 'PVC OD - 160', 'DI PERKERASAN', 66062, 93487, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(75, 'TYPE II (C)', 'PVC OD - 225', 'DI BAHU JALAN', 97426, 97345, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(76, 'TYPE II (C)', 'PVC OD - 225', 'DI PERKERASAN', 97426, 124649, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(77, 'TYPE II (C)', 'PVC OD - 260', 'DI BAHU JALAN', 118401, 113569, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(78, 'TYPE II (C)', 'PVC OD - 260', 'DI PERKERASAN', 118401, 145423, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(79, 'TYPE II (C)', 'PVC OD - 315', 'DI BAHU JALAN', 142958, 129793, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(80, 'TYPE II (C)', 'PVC OD - 315', 'DI PERKERASAN', 142958, 166198, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(81, 'TYPE II (C)', 'PVC OD - 63', 'DI BAHU JALAN', 55335, 64897, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(82, 'TYPE II (C)', 'PVC OD - 63', 'DI PERKERASAN', 55335, 83099, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(83, 'TYPE II (C)', 'PVC OD - 90', 'DI BAHU JALAN', 55335, 64897, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(84, 'TYPE II (C)', 'PVC OD - 90', 'DI PERKERASAN', 55335, 83099, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(85, 'TYPE II (D)', 'PVC OD - 110', 'DI BAHU JALAN', 53196, 64897, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(86, 'TYPE II (D)', 'PVC OD - 110', 'DI PERKERASAN', 53196, 89707, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(87, 'TYPE II (D)', 'PVC OD - 160', 'DI BAHU JALAN', 63656, 73009, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(88, 'TYPE II (D)', 'PVC OD - 160', 'DI PERKERASAN', 63656, 100920, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(89, 'TYPE II (D)', 'PVC OD - 225', 'DI BAHU JALAN', 94219, 97345, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(90, 'TYPE II (D)', 'PVC OD - 225', 'DI PERKERASAN', 94219, 134560, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(91, 'TYPE II (D)', 'PVC OD - 260', 'DI BAHU JALAN', 114659, 113569, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(92, 'TYPE II (D)', 'PVC OD - 260', 'DI PERKERASAN', 114659, 156987, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(93, 'TYPE II (D)', 'PVC OD - 315', 'DI BAHU JALAN', 151616, 129793, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(94, 'TYPE II (D)', 'PVC OD - 315', 'DI PERKERASAN', 138681, 179413, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(95, 'TYPE II (D)', 'PVC OD - 63', 'DI BAHU JALAN', 53196, 64897, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(96, 'TYPE II (D)', 'PVC OD - 63', 'DI PERKERASAN', 53196, 89707, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(97, 'TYPE II (D)', 'PVC OD - 90', 'DI BAHU JALAN', 53196, 64897, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(98, 'TYPE II (D)', 'PVC OD - 90', 'DI PERKERASAN', 53196, 89707, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(99, 'TYPE III (A)', 'PVC OD - 110', 'DI BAHU JALAN', 58987, 77821, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(100, 'TYPE III (A)', 'PVC OD - 110', 'DI PERKERASAN', 62265, 253941, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(101, 'TYPE III (A)', 'PVC OD - 160', 'DI BAHU JALAN', 70170, 87548, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(102, 'TYPE III (A)', 'PVC OD - 160', 'DI PERKERASAN', 73858, 285683, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(103, 'TYPE III (A)', 'PVC OD - 225', 'DI BAHU JALAN', 102904, 116731, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(104, 'TYPE III (A)', 'PVC OD - 225', 'DI PERKERASAN', 107821, 380911, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(105, 'TYPE III (A)', 'PVC OD - 260', 'DI BAHU JALAN', 124792, 136186, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(106, 'TYPE III (A)', 'PVC OD - 260', 'DI PERKERASAN', 130529, 444396, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(107, 'TYPE III (A)', 'PVC OD - 315', 'DI BAHU JALAN', 150262, 155641, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(108, 'TYPE III (A)', 'PVC OD - 315', 'DI PERKERASAN', 156818, 507881, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(109, 'TYPE III (A)', 'PVC OD - 63', 'DI BAHU JALAN', 58987, 77821, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(110, 'TYPE III (A)', 'PVC OD - 63', 'DI PERKERASAN', 62265, 253941, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(111, 'TYPE III (A)', 'PVC OD - 90', 'DI BAHU JALAN', 58987, 77821, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(112, 'TYPE III (A)', 'PVC OD - 90', 'DI PERKERASAN', 62265, 253941, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(113, 'TYPE V (B)', 'PVC OD - 63', 'DI BAHU JALAN', 83252, 148051, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(114, 'TYPE V (B)', 'PVC OD - 63', 'DI PERKERASAN', 83252, 158631, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(115, 'TYPE V (B)', 'PVC OD - 90', 'DI BAHU JALAN', 83252, 148051, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(116, 'TYPE V (B)', 'PVC OD - 90', 'DI PERKERASAN', 83252, 158631, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(117, 'TYPE IV (A)', 'PVC OD - 110', 'DI BAHU JALAN', 77764, 108277, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(118, 'TYPE IV (A)', 'PVC OD - 160', 'DI BAHU JALAN', 90504, 119105, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(119, 'TYPE IV (A)', 'PVC OD - 225', 'DI BAHU JALAN', 107267, 129932, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(120, 'TYPE IV (A)', 'PVC OD - 260', 'DI BAHU JALAN', 129882, 151587, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(121, 'TYPE IV (A)', 'PVC OD - 315', 'DI BAHU JALAN', 156079, 173243, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(122, 'TYPE IV (A)', 'PVC OD - 63', 'DI BAHU JALAN', 77764, 108277, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(123, 'TYPE IV (A)', 'PVC OD - 90', 'DI BAHU JALAN', 77764, 108277, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(124, 'TYPE V (A)', 'PVC OD - 110', 'DI BAHU JALAN', 85036, 148051, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(125, 'TYPE V (A)', 'PVC OD - 160', 'DI BAHU JALAN', 98503, 162856, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(126, 'TYPE V (A)', 'PVC OD - 225', 'DI BAHU JALAN', 115993, 177661, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(127, 'TYPE V (A)', 'PVC OD - 260', 'DI BAHU JALAN', 140063, 207272, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(128, 'TYPE V (A)', 'PVC OD - 315', 'DI BAHU JALAN', 167714, 236882, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(129, 'TYPE V (A)', 'PVC OD - 63', 'DI BAHU JALAN', 85036, 148051, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(130, 'TYPE V (A)', 'PVC OD - 90', 'DI BAHU JALAN', 85036, 148051, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(131, 'TYPE IV (B)', 'PVC OD - 315', 'DI BAHU JALAN', 153225, 173243, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(132, 'TYPE IV (B)', 'PVC OD - 315', 'DI PERKERASAN', 153225, 214092, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(133, 'TYPE III (B)', 'PVC OD - 110', 'DI BAHU JALAN', 57560, 77821, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(134, 'TYPE III (B)', 'PVC OD - 110', 'DI PERKERASAN', 57560, 98801, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(135, 'TYPE III (B)', 'PVC OD - 160', 'DI BAHU JALAN', 68564, 87548, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(136, 'TYPE III (B)', 'PVC OD - 160', 'DI PERKERASAN', 68564, 111151, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(137, 'TYPE III (B)', 'PVC OD - 225', 'DI BAHU JALAN', 100763, 116731, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(138, 'TYPE III (B)', 'PVC OD - 225', 'DI PERKERASAN', 100763, 148201, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(139, 'TYPE III (B)', 'PVC OD - 260', 'DI BAHU JALAN', 122294, 136186, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(140, 'TYPE III (B)', 'PVC OD - 260', 'DI PERKERASAN', 122294, 172901, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(141, 'TYPE III (B)', 'PVC OD - 315', 'DI BAHU JALAN', 147407, 155641, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(142, 'TYPE III (B)', 'PVC OD - 315', 'DI PERKERASAN', 147407, 197601, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(143, 'TYPE III (B)', 'PVC OD - 63', 'DI BAHU JALAN', 57560, 77821, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(144, 'TYPE III (B)', 'PVC OD - 63', 'DI PERKERASAN', 57560, 98801, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(145, 'TYPE III (B)', 'PVC OD - 90', 'DI BAHU JALAN', 57560, 77821, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(146, 'TYPE III (B)', 'PVC OD - 90', 'DI PERKERASAN', 57560, 98801, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(147, 'TYPE IV (A)', 'PVC OD - 110', 'DI PERKERASAN', 81862, 354145, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(148, 'TYPE IV (A)', 'PVC OD - 160', 'DI PERKERASAN', 95012, 389559, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(149, 'TYPE IV (A)', 'PVC OD - 225', 'DI PERKERASAN', 112185, 424974, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(150, 'TYPE IV (A)', 'PVC OD - 260', 'DI PERKERASAN', 135619, 495802, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(151, 'TYPE IV (A)', 'PVC OD - 315', 'DI PERKERASAN', 162636, 566631, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(152, 'TYPE IV (A)', 'PVC OD - 63', 'DI PERKERASAN', 81862, 354145, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(153, 'TYPE IV (A)', 'PVC OD - 90', 'DI PERKERASAN', 81862, 354145, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(154, 'TYPE IV (B)', 'PVC OD - 110', 'DI BAHU JALAN', 75980, 108277, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(155, 'TYPE IV (B)', 'PVC OD - 110', 'DI PERKERASAN', 75980, 133808, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(156, 'TYPE IV (B)', 'PVC OD - 160', 'DI BAHU JALAN', 88542, 119105, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(157, 'TYPE IV (B)', 'PVC OD - 160', 'DI PERKERASAN', 88542, 147189, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(158, 'TYPE IV (B)', 'PVC OD - 225', 'DI BAHU JALAN', 105127, 129932, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(159, 'TYPE IV (B)', 'PVC OD - 225', 'DI PERKERASAN', 105127, 160569, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(160, 'TYPE IV (B)', 'PVC OD - 260', 'DI BAHU JALAN', 127385, 151587, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(161, 'TYPE IV (B)', 'PVC OD - 260', 'DI PERKERASAN', 127385, 187331, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(162, 'TYPE IV (B)', 'PVC OD - 63', 'DI BAHU JALAN', 75980, 108277, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(163, 'TYPE IV (B)', 'PVC OD - 63', 'DI PERKERASAN', 75980, 133808, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(164, 'TYPE IV (B)', 'PVC OD - 90', 'DI BAHU JALAN', 75980, 108277, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(165, 'TYPE IV (B)', 'PVC OD - 90', 'DI PERKERASAN', 75980, 133808, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(166, 'TYPE V (A)', 'PVC OD - 110', 'DI PERKERASAN', 89134, 374759, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(167, 'TYPE V (A)', 'PVC OD - 160', 'DI PERKERASAN', 103011, 412235, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(168, 'TYPE V (A)', 'PVC OD - 225', 'DI PERKERASAN', 120911, 449711, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(169, 'TYPE V (A)', 'PVC OD - 260', 'DI PERKERASAN', 145800, 524663, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(170, 'TYPE V (A)', 'PVC OD - 315', 'DI PERKERASAN', 174271, 599614, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(171, 'TYPE V (A)', 'PVC OD - 63', 'DI PERKERASAN', 89134, 374759, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(172, 'TYPE V (A)', 'PVC OD - 90', 'DI PERKERASAN', 89134, 374759, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(173, 'TYPE V (B)', 'PVC OD - 110', 'DI BAHU JALAN', 83252, 148051, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(174, 'TYPE V (B)', 'PVC OD - 110', 'DI PERKERASAN', 83252, 158631, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(175, 'TYPE V (B)', 'PVC OD - 160', 'DI BAHU JALAN', 96541, 162856, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(176, 'TYPE V (B)', 'PVC OD - 160', 'DI PERKERASAN', 96541, 175628, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(177, 'TYPE V (B)', 'PVC OD - 225', 'DI BAHU JALAN', 113853, 177661, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(178, 'TYPE V (B)', 'PVC OD - 225', 'DI PERKERASAN', 113853, 191594, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(179, 'TYPE V (B)', 'PVC OD - 260', 'DI BAHU JALAN', 137566, 207272, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(180, 'TYPE V (B)', 'PVC OD - 260', 'DI PERKERASAN', 137566, 223526, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(181, 'TYPE V (B)', 'PVC OD - 315', 'DI BAHU JALAN', 164860, 236882, '2018-07-16 14:01:45', '2018-07-16 14:01:45'),
	(182, 'TYPE V (B)', 'PVC OD - 315', 'DI PERKERASAN', 164860, 255459, '2018-07-16 14:01:45', '2018-07-16 14:01:45');

-- Dumping structure for table pdam_web.jenis_hasil_survey
CREATE TABLE IF NOT EXISTS `jenis_hasil_survey` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kode_hasil` char(5) COLLATE utf8mb4_unicode_ci NOT NULL,
  `keterangan` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_bermasalah` int(11) NOT NULL,
  `rab_jaringan` int(11) NOT NULL,
  `persen_bsi` float unsigned NOT NULL DEFAULT '0',
  `is_bebas_bsi` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pdam_web.jenis_hasil_survey: ~53 rows (approximately)
DELETE FROM `jenis_hasil_survey`;
INSERT INTO `jenis_hasil_survey` (`id`, `kode_hasil`, `keterangan`, `is_bermasalah`, `rab_jaringan`, `persen_bsi`, `is_bebas_bsi`) VALUES
	(1, '71', 'JARINGAN TEBAYAR BLM TERPASANG', 1, 0, 1, 0),
	(2, '96', 'SURAT KUASA BELUM TERLAMPIR', 1, 0, 1, 0),
	(3, '98', 'MEMPERBESAR METER', 0, 0, 0, 1),
	(4, '45', 'TUTUPAN < 5 TAHUN', 1, 0, 1, 0),
	(5, '97', 'TANDA TANGAN TIDAK SAMA', 1, 0, 1, 0),
	(6, '39', 'PEKERJAAN SUDAH TERLAKSANA', 1, 0, 0, 0),
	(7, '42', 'TIDAK MEMENUHI SYARAT OBA', 1, 0, 1, 0),
	(8, '44', 'TIDAK SESUAI KRITERIA GAKIN', 1, 0, 1, 0),
	(9, '38', 'SYARAT DAFTAR TIDAK LENGKAP', 1, 0, 1, 0),
	(10, '40', 'UNTUK DIDAFTARKAN KEMBALI', 1, 0, 0, 0),
	(11, '43', 'MENUNGGU DPH OBA', 1, 0, 0, 0),
	(12, '37', 'BEKAS PELANGGAN > 5 TH', 0, 0, 0, 0),
	(13, '36', 'PONDOK BENOWO INDAH / POTONGAN', 0, 0, 0, 0),
	(14, '0', 'ADA JARINGAN', 0, 0, 1, 0),
	(15, '1', 'TEKANAN DI BAWAH TANAH', 1, 0, 1, 0),
	(16, '2', 'NO RUMAH TIDAK TERTIB', 1, 0, 1, 0),
	(17, '3', 'BIAYA TINGGI', 1, 0, 1, 0),
	(18, '4', 'RUMAH KOSONG', 1, 0, 1, 0),
	(19, '5', 'ALAMAT TIDAK KETEMU', 1, 0, 1, 0),
	(20, '6', 'DOBEL BON', 1, 0, 1, 0),
	(21, '7', 'TIDAK ADA JARINGAN', 0, 1, 0, 0),
	(22, '9', 'METER DIMULUT GANG', 0, 0, 0, 0),
	(23, '10', 'BATAL ATAS PERMINTAAN CP', 1, 0, 1, 0),
	(24, '11', 'TANAH KOSONG', 1, 0, 1, 0),
	(25, '12', 'SUB ZONA MASIH TERTUTUP', 1, 0, 1, 0),
	(26, '13', 'PERTIMBANGAN SISTEM', 1, 0, 1, 0),
	(27, '14', 'PENYELIDIKAN PIPA', 1, 0, 1, 0),
	(28, '15', 'LUAS TANAH TIDAK SESUAI', 1, 0, 1, 0),
	(29, '16', 'DISARANKAN KOLEKTIF', 1, 0, 1, 0),
	(30, '17', 'ALAMAT TIDAK SESUAI', 1, 0, 1, 0),
	(31, '19', 'PIPA BELUM TERISI AIR', 1, 0, 1, 0),
	(32, '20', 'SURAT TANAH TIDAK SESUAI', 1, 0, 1, 0),
	(33, '21', 'SITE PLAN TIDAK SESUAI', 1, 0, 1, 0),
	(34, '22', 'PENGANTAR REAL ESTAT / WARGA', 1, 0, 1, 0),
	(35, '23', 'TUNGGU IJIN JASA MARGA', 1, 0, 1, 0),
	(36, '24', 'PANGGILAN SUDAH KE TU', 1, 0, 1, 0),
	(37, '25', 'DITANGGUHKAN SEBAB .........', 1, 0, 1, 0),
	(38, '26', 'IJIN DPUD KMS', 1, 0, 1, 0),
	(39, '27', 'IJIN PERUM PELABUHAN', 1, 0, 1, 0),
	(40, '28', 'TIDAK PASANG AIR', 1, 0, 1, 0),
	(41, '29', 'BELUM SERAHKAN PERNYATAAN ....', 1, 0, 1, 0),
	(42, '31', 'PERSIL UNTUK USAHA', 1, 0, 1, 0),
	(43, '32', 'IJIN DPU BINA MARGA', 1, 0, 1, 0),
	(44, '33', 'IJIN DARI PTKA', 1, 0, 1, 0),
	(45, '30', 'IJIN DINAS IRIGASI', 1, 0, 1, 0),
	(46, '8', 'TERCATAT SEBAGAI PELANGGAN', 1, 0, 1, 0),
	(47, '18', 'TIDAK ADA JARINGAN (MSLH)', 1, 0, 0, 0),
	(48, '00', 'REAL ESTAT', 0, 0, 0, 1),
	(49, '01', 'JARINGAN KOLEKTIF', 0, 0, 0, 0),
	(50, '99', 'PINDAH AMBORING', 0, 0, 0, 1),
	(51, '34', 'BEKAS PELANGGAN/TUTUPAN', 1, 0, 1, 0),
	(52, '35', 'NOMOR RUMAH DOBEL', 1, 0, 1, 0),
	(53, '41', 'DITANGGUHKAN BLM SERAH TERIMA', 1, 0, 0, 0);

-- Dumping structure for table pdam_web.jenis_pekerjaan
CREATE TABLE IF NOT EXISTS `jenis_pekerjaan` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jenis_pekerjaan` char(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `keterangan` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pdam_web.jenis_pekerjaan: ~13 rows (approximately)
DELETE FROM `jenis_pekerjaan`;
INSERT INTO `jenis_pekerjaan` (`id`, `jenis_pekerjaan`, `keterangan`) VALUES
	(1, 'TYPE I (A)', 'Jalan Kampung / Gang (tanah)'),
	(2, 'TYPE I (B)', 'Jalan Kampung Konstruksi Rabat'),
	(3, 'TYPE I (C)', 'Jalan Kampung Konstruksi Paving'),
	(4, 'TYPE II (A)', 'Jalan Perumahan Konstruksi Telford'),
	(5, 'TYPE II (B)', 'Jalan Perumahan Kontruksi CTB'),
	(6, 'TYPE II (C)', 'Jalan Perumahan Kontruksi Rabat'),
	(7, 'TYPE II (D)', 'Jalan Perumahan Kontruksi Paving'),
	(8, 'TYPE III (A)', 'Jalan Lokal Dalam Kota Kontruksi CTB'),
	(9, 'TYPE III (B)', 'Jalan Lokal Dalam Kota Kontruksi Paving'),
	(10, 'TYPE IV (A)', 'Jalan Kolektor Primer/Sekunder dengan Kontruksi CTB'),
	(11, 'TYPE IV (B)', 'Jalan Kolektor Primer/Sekunder dengan Kontruksi paving'),
	(12, 'TYPE V (A)', 'Jalan Arteri sekunder (protokol) dengan kontruksi CTB'),
	(13, 'TYPE V (B)', 'Jalan Arteri Sekunder (protokol) dengan kontruksi Paving');

-- Dumping structure for table pdam_web.jenis_pipa
CREATE TABLE IF NOT EXISTS `jenis_pipa` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pipa` char(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `satuan` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `volume` int(11) DEFAULT NULL,
  `harga` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pdam_web.jenis_pipa: ~7 rows (approximately)
DELETE FROM `jenis_pipa`;
INSERT INTO `jenis_pipa` (`id`, `pipa`, `satuan`, `volume`, `harga`) VALUES
	(1, 'PVC OD - 110', 'm', 1, 58890),
	(2, 'PVC OD - 160', 'm', 1, 128700),
	(3, 'PVC OD - 225', 'm', 1, 221600),
	(4, 'PVC OD - 260', 'm', 1, 300),
	(5, 'PVC OD - 315', 'm', 1, 689130),
	(6, 'PVC OD - 63', 'm', 1, 20750),
	(7, 'PVC OD - 90', 'm', 1, 39260);

-- Dumping structure for table pdam_web.jenis_tarif
CREATE TABLE IF NOT EXISTS `jenis_tarif` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kode_tarif` char(5) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jenis_tarif` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rumah_tangga` int(11) DEFAULT NULL,
  `non_rumah` int(11) DEFAULT NULL,
  `biaya_reg` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pdam_web.jenis_tarif: ~30 rows (approximately)
DELETE FROM `jenis_tarif`;
INSERT INTO `jenis_tarif` (`id`, `kode_tarif`, `jenis_tarif`, `rumah_tangga`, `non_rumah`, `biaya_reg`) VALUES
	(1, '1', 'KELOMPOK PELANGGAN I            ', 0, 1, 4400),
	(2, '5', 'KELOMPOK PELANGGAN XI           ', 0, 1, 4400),
	(20, '2A', 'RSS - SOSIAL KHUSUS             ', 0, 1, 4400),
	(21, '2A.1', 'KELOMPOK PELANGGAN II           ', 0, 1, 4400),
	(22, '2A.2', 'KELOMPOK PELANGGAN II           ', 1, 0, 4400),
	(23, '2B', 'KELOMPOK PELANGGAN III          ', 0, 1, 4400),
	(25, '3A', 'KELOMPOK PELANGGAN IV           ', 1, 0, 4400),
	(26, '3B', 'USAHA KECIL                     ', 0, 1, 26000),
	(27, '3B.1', 'KELOMPOK PELANGGAN V            ', 0, 1, 26000),
	(28, '3B.2', 'KELOMPOK PELANGGAN V            ', 0, 1, 26000),
	(29, '3C', 'KELOMPOK PELANGGAN VI           ', 0, 1, 26000),
	(30, '3C.1', 'KELOMPOK PELANGGAN VI           ', 0, 1, 26000),
	(31, '3C.2', 'KELOMPOK PELANGGAN VI           ', 1, 0, 26000),
	(32, '4A', 'KELOMPOK PELANGGAN VII          ', 1, 0, 4400),
	(33, '4B', 'RUMAH MEWAH                     ', 0, 1, 4400),
	(34, '4B.1', 'KELOMPOK PELANGGAN VIII         ', 0, 1, 4400),
	(35, '4B.2', 'KELOMPOK PELANGGAN VIII         ', 1, 0, 4400),
	(36, '4C', 'KELOMPOK PELANGGAN IX           ', 0, 1, 29000),
	(37, '4D', 'KELOMPOK PELANGGAN X            ', 0, 1, 29000),
	(38, '53a', 'PDAM SIDOARJO                   ', 0, 1, 0),
	(39, '53a1', 'PDAM SIDOARJO                   ', 0, 1, 0),
	(40, '53b', 'PDAM GRESIK                     ', 0, 1, 0),
	(41, '53c', 'PDAM PASURUAN                   ', 0, 1, 0),
	(42, '53d', 'HARMONY  PASURUAN               ', 0, 1, 0),
	(43, '53e', 'RACI PASURUAN                   ', 0, 1, 0),
	(44, '53f', 'PDAM SIDOARJO                   ', 0, 1, 0),
	(45, '53g', 'SOSIAL PASURUAN                 ', 0, 1, 0),
	(46, '53h', 'RACI PASURUAN                   ', 0, 1, 0),
	(47, '53i', 'PAGAK BANGIL KAB. PASURUAN      ', 0, 1, 0),
	(48, '53j', 'TNI-AL GERUNGAN PASURUAN        ', 0, 1, 4400);

-- Dumping structure for table pdam_web.letak_pipa
CREATE TABLE IF NOT EXISTS `letak_pipa` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `letak_pipa` char(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pdam_web.letak_pipa: ~2 rows (approximately)
DELETE FROM `letak_pipa`;
INSERT INTO `letak_pipa` (`id`, `letak_pipa`) VALUES
	(1, 'DI BAHU JALAN'),
	(2, 'DI PERKERASAN');

-- Dumping structure for table pdam_web.migrations
CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pdam_web.migrations: ~11 rows (approximately)
DELETE FROM `migrations`;
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(48, '2014_10_12_000000_create_users_table', 1),
	(49, '2014_10_12_100000_create_password_resets_table', 1),
	(50, '2018_03_19_223317_laratrust_setup_tables', 1),
	(51, '2018_03_20_184153_create_notifications_table', 1),
	(52, '2018_04_20_034527_create_pemasangan_baru_master_table', 1),
	(53, '2018_04_20_034533_create_pemasangan_baru_table', 1),
	(56, '2018_05_24_031927_create_table_zona_surveyor', 2),
	(57, '2018_05_24_062047_create_survey_perencanaans_table', 2),
	(58, '2018_06_06_082533_KecamatanKelurahan', 3),
	(60, '2018_06_07_060333_create_table_pendukung_survey', 4),
	(61, '2018_06_07_092654_create_table_guna_persil', 5);

-- Dumping structure for table pdam_web.notifications
CREATE TABLE IF NOT EXISTS `notifications` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notifiable_id` int(10) unsigned NOT NULL,
  `notifiable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `data` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `push_notification_result` text COLLATE utf8mb4_unicode_ci,
  `push_notification_sent_at` timestamp NULL DEFAULT NULL,
  `sms_notification_result` text COLLATE utf8mb4_unicode_ci,
  `sms_notification_sent_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notifications_notifiable_id_notifiable_type_index` (`notifiable_id`,`notifiable_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pdam_web.notifications: ~0 rows (approximately)
DELETE FROM `notifications`;

-- Dumping structure for table pdam_web.paket_material
CREATE TABLE IF NOT EXISTS `paket_material` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kode_paket` char(3) COLLATE utf8mb4_unicode_ci NOT NULL,
  `keterangan` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pdam_web.paket_material: ~5 rows (approximately)
DELETE FROM `paket_material`;
INSERT INTO `paket_material` (`id`, `kode_paket`, `keterangan`) VALUES
	(1, 'A', 'PAKET SR UMUM (100)'),
	(2, 'B0', 'PAKET SR RE (100)'),
	(3, 'B1', 'PAKET SR RE (150)'),
	(4, 'A1', 'PAKET SR UMUM (150)'),
	(5, 'XX', 'NON PAKET');

-- Dumping structure for table pdam_web.password_resets
CREATE TABLE IF NOT EXISTS `password_resets` (
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`),
  KEY `password_resets_token_index` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pdam_web.password_resets: ~0 rows (approximately)
DELETE FROM `password_resets`;

-- Dumping structure for table pdam_web.pemasangan
CREATE TABLE IF NOT EXISTS `pemasangan` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `no_daftarpb` varchar(50) DEFAULT NULL,
  `no_spk` varchar(15) DEFAULT NULL,
  `alamat_pemasangan` varchar(100) DEFAULT NULL,
  `status_pasang` char(1) DEFAULT NULL,
  `paket_material` char(2) DEFAULT NULL,
  `alasan_gagal` varchar(100) DEFAULT NULL,
  `file_foto_sebelum` varchar(191) DEFAULT NULL,
  `file_foto_proses` varchar(191) DEFAULT NULL,
  `file_foto_sesudah` varchar(191) DEFAULT NULL,
  `file_ttd` varchar(191) DEFAULT NULL,
  `latitude` double(11,8) DEFAULT NULL,
  `longitude` double(11,8) DEFAULT NULL,
  `no_meter` varchar(50) DEFAULT NULL,
  `tanggal_realisasi` date DEFAULT NULL,
  `ukuran_meter` double(6,3) DEFAULT NULL,
  `kode_merk` varchar(50) DEFAULT NULL,
  `is_checkin` int(11) NOT NULL DEFAULT '0',
  `is_checkout` int(11) NOT NULL DEFAULT '0',
  `acc_spv` int(11) DEFAULT '0',
  `acc_mng` int(11) DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table pdam_web.pemasangan: ~8 rows (approximately)
DELETE FROM `pemasangan`;
INSERT INTO `pemasangan` (`id`, `no_daftarpb`, `no_spk`, `alamat_pemasangan`, `status_pasang`, `paket_material`, `alasan_gagal`, `file_foto_sebelum`, `file_foto_proses`, `file_foto_sesudah`, `file_ttd`, `latitude`, `longitude`, `no_meter`, `tanggal_realisasi`, `ukuran_meter`, `kode_merk`, `is_checkin`, `is_checkout`, `acc_spv`, `acc_mng`, `created_at`, `updated_at`) VALUES
	(12, 'B20180000001', 'B20180800001', 'Jalan Keputih Gang Makam no 18', NULL, NULL, NULL, NULL, NULL, NULL, NULL, -7.25044500, 112.76884500, NULL, NULL, NULL, NULL, 0, 0, 0, 0, '2018-08-02 09:48:24', '2018-08-02 09:48:34'),
	(13, 'T20180000001', 'B20180800001', 'Jalan Keputih Gang Makam no 18', NULL, NULL, NULL, NULL, NULL, NULL, NULL, -7.25044500, 112.76884500, NULL, NULL, NULL, NULL, 0, 0, 0, 0, '2018-08-02 09:48:28', '2018-08-02 09:48:34'),
	(14, 'B20180000002', 'B20180800002', 'Jalan Keputih Gang Makam no 18', NULL, NULL, NULL, NULL, NULL, NULL, NULL, -7.25044500, 112.76884500, NULL, NULL, NULL, NULL, 0, 0, 0, 0, '2018-08-02 09:48:31', '2018-08-02 09:48:47'),
	(15, 'T20180000002', 'B20180800002', 'Jalan Keputih Gang Makam no 18', 'P', NULL, 'RUMAH KOSONG', 'img_file_foto_sebelum/T20180000002_20180810082138_img_file_foto_sebelum.jpg', 'img_file_foto_proses/T20180000002_20180810082138_img_file_foto_proses.jpg', 'img_file_foto_sesudah/T20180000002_20180810082138_img_file_foto_sesudah.jpg', 'img_file_ttd/T20180000002_20180810082138_img_file_ttd.jpg', -7.25044500, 112.76884500, '289292', NULL, 1.000, 'BOSCO', 1, 0, 0, 0, '2018-08-02 09:48:40', '2018-08-10 08:21:38'),
	(16, 'B20180000003', 'B20180800007', 'Jalan Keputih Gang Makam no 18', NULL, 'B0', NULL, NULL, NULL, NULL, NULL, -7.25044500, 112.76884500, NULL, NULL, NULL, NULL, 0, 0, 0, 0, '2018-08-02 09:48:44', '2018-08-04 10:22:25'),
	(18, 'T20180000017', 'T20180800006', 'Keputih Gang Makam 18', 'T', 'A', 'PIPA JARINGAN BELUM DISERAHKAN', 'img_file_foto_sebelum/T20180000017_20180808095008_img_file_foto_sebelum.jpg', 'img_file_foto_proses/T20180000017_20180808095008_img_file_foto_proses.jpg', 'img_file_foto_sesudah/T20180000017_20180808095008_img_file_foto_sesudah.jpg', 'img_file_ttd/T20180000017_20180808095008_img_file_ttd.jpg', -7.25044500, 112.76884500, 'sdfawe', NULL, 0.100, 'BOSCO', 1, 0, 0, 0, '2018-08-02 15:24:59', '2018-08-08 10:05:43'),
	(19, 'T20180000025', 'T20180800007', 'GUNUNG ANYAR ASRI Gang 1 1', NULL, 'B1', NULL, NULL, NULL, NULL, NULL, -7.33395505, 112.79746503, NULL, NULL, NULL, NULL, 0, 0, 0, 0, '2018-08-04 17:28:48', '2018-08-10 08:13:34'),
	(20, 'B20180000050', NULL, 'Keputih Gang Makam 18', NULL, 'A', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, '2018-08-10 06:27:42', '2018-08-10 06:27:42');

-- Dumping structure for table pdam_web.pemasangan_baru_master
CREATE TABLE IF NOT EXISTS `pemasangan_baru_master` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `fk_pasang_baru` bigint(20) NOT NULL,
  `kode_wilayah` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nomor_rencana_pj` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tanggal_daftar` datetime DEFAULT NULL,
  `tanggal_kirim_pg` datetime DEFAULT NULL,
  `tanggal_serah_bon` datetime DEFAULT NULL,
  `tanggal_survei` datetime DEFAULT NULL,
  `tanggal_rab` datetime DEFAULT NULL,
  `tanggal_terima_rab` datetime DEFAULT NULL,
  `tanggal_persetujuan_kasi` datetime DEFAULT NULL,
  `tanggal_persetujuan_kabag` datetime DEFAULT NULL,
  `tanggal_kirim_kas` datetime DEFAULT NULL,
  `tanggal_lunas` datetime DEFAULT NULL,
  `tanggal_kirim_dist` datetime DEFAULT NULL,
  `tanggal_kirim_gudang` datetime DEFAULT NULL,
  `tanggal_pasang` datetime DEFAULT NULL,
  `tanggal_kembali_pg` datetime DEFAULT NULL,
  `tanggal_terima_pg` datetime DEFAULT NULL,
  `tanggal_kirim_rekening` datetime DEFAULT NULL,
  `tanggal_bon_putih` datetime DEFAULT NULL,
  `tanggal_bon_kuning` datetime DEFAULT NULL,
  `tanggal_peremajaan` datetime DEFAULT NULL,
  `tanggal_batal` datetime DEFAULT NULL,
  `rab_jaringan` int(10) unsigned DEFAULT NULL,
  `flow_pb` int(10) unsigned DEFAULT NULL,
  `status_pb` int(10) unsigned DEFAULT NULL,
  `nomor_rab_nofaket` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tanggal_kirim_disttek` datetime DEFAULT NULL,
  `tanggal_terima_disttek` datetime DEFAULT NULL,
  `is_mikro` tinyint(1) DEFAULT NULL,
  `marketing` tinyint(1) DEFAULT NULL,
  `oba` tinyint(1) DEFAULT NULL,
  `mbr` tinyint(1) DEFAULT NULL,
  `is_p3sca` tinyint(1) DEFAULT NULL,
  `is_prefinancing` tinyint(1) DEFAULT NULL,
  `is_pipa_pemkot` tinyint(1) DEFAULT NULL,
  `is_ct` tinyint(1) DEFAULT NULL,
  `is_potensi_pb` tinyint(1) DEFAULT NULL,
  `is_gakin` tinyint(1) DEFAULT NULL,
  `tanggal_koreksi` datetime DEFAULT NULL,
  `jenis_pb` int(10) unsigned DEFAULT NULL,
  `tanggal_expired` datetime DEFAULT NULL,
  `is_exoba` tinyint(1) DEFAULT NULL,
  `is_autodebet` tinyint(1) DEFAULT NULL,
  `is_autodebet_bank` tinyint(1) DEFAULT NULL,
  `nomor_daftar_pb_online` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_pakuwonb` tinyint(1) DEFAULT NULL,
  `is_sms_sent` tinyint(1) DEFAULT NULL,
  `nomor_hp_pelanggan` varchar(13) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_ods` tinyint(1) DEFAULT NULL,
  `is_survey_sent` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pdam_web.pemasangan_baru_master: ~66 rows (approximately)
DELETE FROM `pemasangan_baru_master`;
INSERT INTO `pemasangan_baru_master` (`id`, `fk_pasang_baru`, `kode_wilayah`, `nomor_rencana_pj`, `tanggal_daftar`, `tanggal_kirim_pg`, `tanggal_serah_bon`, `tanggal_survei`, `tanggal_rab`, `tanggal_terima_rab`, `tanggal_persetujuan_kasi`, `tanggal_persetujuan_kabag`, `tanggal_kirim_kas`, `tanggal_lunas`, `tanggal_kirim_dist`, `tanggal_kirim_gudang`, `tanggal_pasang`, `tanggal_kembali_pg`, `tanggal_terima_pg`, `tanggal_kirim_rekening`, `tanggal_bon_putih`, `tanggal_bon_kuning`, `tanggal_peremajaan`, `tanggal_batal`, `rab_jaringan`, `flow_pb`, `status_pb`, `nomor_rab_nofaket`, `tanggal_kirim_disttek`, `tanggal_terima_disttek`, `is_mikro`, `marketing`, `oba`, `mbr`, `is_p3sca`, `is_prefinancing`, `is_pipa_pemkot`, `is_ct`, `is_potensi_pb`, `is_gakin`, `tanggal_koreksi`, `jenis_pb`, `tanggal_expired`, `is_exoba`, `is_autodebet`, `is_autodebet_bank`, `nomor_daftar_pb_online`, `is_pakuwonb`, `is_sms_sent`, `nomor_hp_pelanggan`, `is_ods`, `is_survey_sent`, `created_at`, `updated_at`) VALUES
	(1, 3, NULL, NULL, '2018-05-04 10:11:58', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-05-04 03:11:58', '2018-05-04 03:11:58'),
	(2, 4, NULL, NULL, '2018-05-28 11:26:29', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-05-28 04:26:29', '2018-05-28 04:26:29'),
	(3, 5, NULL, NULL, '2018-05-28 11:30:46', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-05-28 04:30:46', '2018-05-28 04:30:46'),
	(4, 6, NULL, NULL, '2018-05-28 11:31:53', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-05-28 04:31:53', '2018-05-28 04:31:53'),
	(5, 7, NULL, NULL, '2018-05-28 11:32:43', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-05-28 04:32:43', '2018-05-28 04:32:43'),
	(6, 8, NULL, NULL, '2018-05-28 11:39:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-05-28 04:39:31', '2018-05-28 04:39:31'),
	(7, 9, NULL, NULL, '2018-05-28 11:40:41', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-05-28 04:40:41', '2018-05-28 04:40:41'),
	(8, 10, NULL, NULL, '2018-05-28 11:40:55', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-05-28 04:40:55', '2018-05-28 04:40:55'),
	(9, 11, NULL, NULL, '2018-05-28 11:43:43', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-05-28 04:43:43', '2018-05-28 04:43:43'),
	(10, 12, NULL, NULL, '2018-05-28 11:50:48', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-05-28 04:50:48', '2018-05-28 04:50:48'),
	(11, 13, NULL, NULL, '2018-05-28 11:52:07', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-05-28 04:52:07', '2018-05-28 04:52:07'),
	(12, 14, NULL, NULL, '2018-05-28 11:55:52', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-05-28 04:55:52', '2018-05-28 04:55:52'),
	(13, 41, NULL, NULL, '2018-06-20 16:15:57', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-06-20 09:15:58', '2018-06-20 09:15:58'),
	(14, 42, NULL, NULL, '2018-06-24 22:52:07', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-06-24 15:52:16', '2018-06-24 15:52:16'),
	(15, 43, NULL, NULL, '2018-06-24 22:57:07', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-06-24 15:57:10', '2018-06-24 15:57:10'),
	(16, 44, NULL, NULL, '2018-06-24 22:59:03', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-06-24 15:59:04', '2018-06-24 15:59:04'),
	(17, 45, NULL, NULL, '2018-06-24 23:38:38', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-06-24 16:38:40', '2018-06-24 16:38:40'),
	(18, 46, NULL, NULL, '2018-06-28 11:06:28', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-06-28 04:06:28', '2018-06-28 04:06:28'),
	(19, 47, NULL, NULL, '2018-06-28 11:25:13', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-06-28 04:25:13', '2018-06-28 04:25:13'),
	(20, 48, NULL, NULL, '2018-06-28 11:27:47', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-06-28 04:27:47', '2018-06-28 04:27:47'),
	(21, 49, NULL, NULL, '2018-06-28 11:36:03', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-06-28 04:36:03', '2018-06-28 04:36:03'),
	(22, 50, NULL, NULL, '2018-06-28 11:41:22', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-06-28 04:41:22', '2018-06-28 04:41:22'),
	(23, 51, NULL, NULL, '2018-06-28 11:44:01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-06-28 04:44:01', '2018-06-28 04:44:01'),
	(24, 52, NULL, NULL, '2018-06-28 13:10:27', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-06-28 06:10:27', '2018-06-28 06:10:27'),
	(25, 53, NULL, NULL, '2018-06-28 13:33:19', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-06-28 06:33:19', '2018-06-28 06:33:19'),
	(26, 54, NULL, NULL, '2018-06-28 13:34:19', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-06-28 06:34:19', '2018-06-28 06:34:19'),
	(27, 55, NULL, NULL, '2018-07-02 10:16:22', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-02 03:16:22', '2018-07-02 03:16:22'),
	(28, 56, NULL, NULL, '2018-07-02 10:18:34', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-02 03:18:34', '2018-07-02 03:18:34'),
	(29, 57, NULL, NULL, '2018-07-02 10:55:50', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-02 03:55:50', '2018-07-02 03:55:50'),
	(30, 58, NULL, NULL, '2018-07-02 11:06:20', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-02 04:06:20', '2018-07-02 04:06:20'),
	(31, 59, NULL, NULL, '2018-07-02 11:17:33', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-02 04:17:33', '2018-07-02 04:17:33'),
	(32, 60, NULL, NULL, '2018-07-02 11:20:20', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-02 04:20:20', '2018-07-02 04:20:20'),
	(33, 61, NULL, NULL, '2018-07-02 11:21:20', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-02 04:21:20', '2018-07-02 04:21:20'),
	(34, 62, NULL, NULL, '2018-07-02 11:23:09', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-02 04:23:10', '2018-07-02 04:23:10'),
	(35, 63, NULL, NULL, '2018-07-02 11:24:15', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-02 04:24:16', '2018-07-02 04:24:16'),
	(36, 64, NULL, NULL, '2018-07-02 11:28:56', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-02 04:28:56', '2018-07-02 04:28:56'),
	(37, 65, NULL, NULL, '2018-07-02 13:03:37', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-02 06:03:37', '2018-07-02 06:03:37'),
	(38, 66, NULL, NULL, '2018-07-05 01:29:54', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-04 18:29:54', '2018-07-04 18:29:54'),
	(39, 67, NULL, NULL, '2018-07-05 01:32:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-04 18:32:31', '2018-07-04 18:32:31'),
	(40, 68, NULL, NULL, '2018-07-05 01:35:30', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-04 18:35:30', '2018-07-04 18:35:30'),
	(41, 69, NULL, NULL, '2018-07-05 01:36:34', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-04 18:36:34', '2018-07-04 18:36:34'),
	(42, 70, NULL, NULL, '2018-07-05 01:37:09', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-04 18:37:09', '2018-07-04 18:37:09'),
	(43, 71, NULL, NULL, '2018-07-05 01:38:57', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-04 18:38:57', '2018-07-04 18:38:57'),
	(44, 72, NULL, NULL, '2018-07-05 01:42:13', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-04 18:42:13', '2018-07-04 18:42:13'),
	(45, 73, NULL, NULL, '2018-07-05 01:53:44', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-04 18:53:45', '2018-07-04 18:53:45'),
	(46, 74, NULL, NULL, '2018-07-05 01:55:17', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-04 18:55:17', '2018-07-04 18:55:17'),
	(47, 75, NULL, NULL, '2018-07-05 01:56:03', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-04 18:56:03', '2018-07-04 18:56:03'),
	(48, 76, NULL, NULL, '2018-07-05 01:59:30', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-04 18:59:30', '2018-07-04 18:59:30'),
	(49, 74, NULL, NULL, '2018-07-06 00:07:11', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-05 17:07:11', '2018-07-05 17:07:11'),
	(50, 73, NULL, NULL, '2018-07-06 00:08:16', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-05 17:08:16', '2018-07-05 17:08:16'),
	(51, 77, NULL, NULL, '2018-07-06 12:05:41', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-06 05:05:41', '2018-07-06 05:05:41'),
	(52, 78, NULL, NULL, '2018-07-06 15:00:22', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-06 08:00:22', '2018-07-06 08:00:22'),
	(53, 78, NULL, NULL, '2018-07-06 15:01:49', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-06 08:01:49', '2018-07-06 08:01:49'),
	(54, 79, NULL, NULL, '2018-07-08 01:10:20', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-07 18:10:20', '2018-07-07 18:10:20'),
	(55, 79, NULL, NULL, '2018-07-08 01:11:13', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-07 18:11:13', '2018-07-07 18:11:13'),
	(56, 80, NULL, NULL, '2018-07-08 09:30:53', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-08 02:30:54', '2018-07-08 02:30:54'),
	(57, 80, NULL, NULL, '2018-07-08 09:35:49', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-08 02:35:49', '2018-07-08 02:35:49'),
	(58, 81, NULL, NULL, '2018-07-11 00:18:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-10 17:18:31', '2018-07-10 17:18:31'),
	(59, 81, NULL, NULL, '2018-07-24 00:33:49', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-24 00:33:49', '2018-07-24 00:33:49'),
	(60, 77, NULL, NULL, '2018-07-25 10:58:29', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-25 10:58:29', '2018-07-25 10:58:29'),
	(61, 77, NULL, NULL, '2018-07-25 11:05:08', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-25 11:05:08', '2018-07-25 11:05:08'),
	(62, 72, NULL, NULL, '2018-07-27 06:12:05', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-27 06:12:05', '2018-07-27 06:12:05'),
	(63, 82, NULL, NULL, '2018-08-04 10:55:25', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-08-04 14:55:25', '2018-08-04 14:55:25'),
	(64, 82, NULL, NULL, '2018-08-04 16:24:32', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-08-04 16:24:32', '2018-08-04 16:24:32'),
	(65, 83, NULL, NULL, '2018-08-10 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-08-10 07:28:22', '2018-08-10 07:28:22'),
	(66, 83, NULL, NULL, '2018-08-10 07:51:17', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-08-10 07:51:17', '2018-08-10 07:51:17');

-- Dumping structure for table pdam_web.pembagian_zona_surveyor
CREATE TABLE IF NOT EXISTS `pembagian_zona_surveyor` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kd_ptgsurvey` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL,
  `no_subzona` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `pembagian_zona_surveyor_kd_ptgsurvey_index` (`kd_ptgsurvey`),
  KEY `pembagian_zona_surveyor_no_subzona_index` (`no_subzona`),
  CONSTRAINT `pembagian_zona_surveyor_kd_ptgsurvey_foreign` FOREIGN KEY (`kd_ptgsurvey`) REFERENCES `surveyor` (`kd_ptgsurvey`) ON UPDATE CASCADE,
  CONSTRAINT `pembagian_zona_surveyor_no_subzona_foreign` FOREIGN KEY (`no_subzona`) REFERENCES `zona` (`no_subzona`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pdam_web.pembagian_zona_surveyor: ~0 rows (approximately)
DELETE FROM `pembagian_zona_surveyor`;

-- Dumping structure for table pdam_web.pendaftaran
CREATE TABLE IF NOT EXISTS `pendaftaran` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `no_daftarpb` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kode_petugas_survey` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status_tanah` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nama` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alamat_pemohon` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jalan` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gang` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nomor` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notamb` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `da` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `telepon` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `telepon2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `luas_persil` bigint(20) DEFAULT NULL,
  `surat_tanah` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ktp_ksk` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `imb` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pbb` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `retribusi` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wilayah` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kecamatan` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kelurahan` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `no_bundel` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jenis_pelanggan` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jenis_persil` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lebar_jalan` bigint(20) DEFAULT NULL,
  `listrik` bigint(20) DEFAULT NULL,
  `njop` bigint(20) DEFAULT NULL,
  `luas_bangunan` bigint(20) DEFAULT NULL,
  `lebar_persil` bigint(20) DEFAULT NULL,
  `npwp` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subzona` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_surat_tanah` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_ktp` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_ksk` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_rek_listrik` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_pbb` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_surat_pernyataan` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `panjang_persil` bigint(20) DEFAULT NULL,
  `lebar_bangunan` bigint(20) DEFAULT NULL,
  `panjang_bangunan` bigint(20) DEFAULT NULL,
  `kode_wilayah` char(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tambahan_alamat` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `keterangan_alamat` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `latitude` double(11,8) DEFAULT NULL,
  `longitude` double(11,8) DEFAULT NULL,
  `metode_upload` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

-- Dumping data for table pdam_web.pendaftaran: ~56 rows (approximately)
DELETE FROM `pendaftaran`;
INSERT INTO `pendaftaran` (`id`, `no_daftarpb`, `kode_petugas_survey`, `status_tanah`, `nama`, `alamat_pemohon`, `jalan`, `gang`, `nomor`, `notamb`, `da`, `telepon`, `telepon2`, `luas_persil`, `surat_tanah`, `ktp_ksk`, `imb`, `pbb`, `retribusi`, `wilayah`, `kecamatan`, `kelurahan`, `no_bundel`, `jenis_pelanggan`, `jenis_persil`, `lebar_jalan`, `listrik`, `njop`, `luas_bangunan`, `lebar_persil`, `npwp`, `subzona`, `user_id`, `file_surat_tanah`, `file_ktp`, `file_ksk`, `file_rek_listrik`, `file_pbb`, `file_surat_pernyataan`, `created_at`, `updated_at`, `panjang_persil`, `lebar_bangunan`, `panjang_bangunan`, `kode_wilayah`, `tambahan_alamat`, `keterangan_alamat`, `latitude`, `longitude`, `metode_upload`) VALUES
	(3, NULL, NULL, NULL, 'andi muzaki', 'rungkut (aaa depan)', 'arif', '8p', '777', NULL, NULL, '9821393821', '981273012', 25, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 98932812, NULL, NULL, '971291231', NULL, NULL, 'img_surat_tanah/andi muzaki_20180504031158img_surat_tanah.jpeg', 'img_ktp/andi muzaki_20180504031158img_ktp.jpeg', 'img_ksk/andi muzaki_20180504031158img_ksk.jpeg', 'img_rek_listrik/andi muzaki_20180504031158img_rek_listrik.jpeg', 'img_pbb/andi muzaki_20180504031158img_pbb.jpeg', 'img_surat_pernyataan/andi muzaki_20180504031158img_surat_pernyataan.jpeg', '2018-05-04 03:11:58', '2018-05-04 03:11:58', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(12, NULL, NULL, NULL, 'Anton Nazarudin', 'Keputih (0 0)', 'Keputih', 'Makam', '18', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312515, NULL, NULL, '123049213245', NULL, NULL, 'img_surat_tanah/Anton Nazarudin_20180528045048img_surat_tanah.jpg', 'img_ktp/Anton Nazarudin_20180528045048img_ktp.jpg', 'img_ksk/Anton Nazarudin_20180528045048img_ksk.jpg', 'img_rek_listrik/Anton Nazarudin_20180528045048img_rek_listrik.jpg', 'img_pbb/Anton Nazarudin_20180528045048img_pbb.jpg', 'img_surat_pernyataan/Anton Nazarudin_20180528045048img_surat_pernyataan.jpg', '2018-05-28 04:50:48', '2018-05-28 04:50:48', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(13, NULL, NULL, NULL, 'Anton Nazarudin', 'Keputih (0 0)', 'Keputih', 'Makam', '18', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312515, NULL, NULL, '123049213245', NULL, NULL, 'img_surat_tanah/Anton Nazarudin_20180528045207img_surat_tanah.jpg', 'img_ktp/Anton Nazarudin_20180528045207img_ktp.jpg', 'img_ksk/Anton Nazarudin_20180528045207img_ksk.jpg', 'img_rek_listrik/Anton Nazarudin_20180528045207img_rek_listrik.jpg', 'img_pbb/Anton Nazarudin_20180528045207img_pbb.jpg', 'img_surat_pernyataan/Anton Nazarudin_20180528045207img_surat_pernyataan.jpg', '2018-05-28 04:52:07', '2018-05-28 04:52:07', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(14, NULL, NULL, NULL, 'Anton Nazarudin', 'Keputih (0 0)', 'Keputih', 'Makam', '18', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312515, NULL, NULL, '123049213245', NULL, NULL, 'img_surat_tanah/Anton Nazarudin_20180528045552img_surat_tanah.jpg', 'img_ktp/Anton Nazarudin_20180528045552img_ktp.jpg', 'img_ksk/Anton Nazarudin_20180528045552img_ksk.jpg', 'img_rek_listrik/Anton Nazarudin_20180528045552img_rek_listrik.jpg', 'img_pbb/Anton Nazarudin_20180528045552img_pbb.jpg', 'img_surat_pernyataan/Anton Nazarudin_20180528045552img_surat_pernyataan.jpg', '2018-05-28 04:55:52', '2018-05-28 04:55:52', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(15, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312000, NULL, NULL, '294212043845', NULL, NULL, 'img_surat_tanah/Jonathan Rachmadi_20180611102359img_surat_tanah.jpg', 'img_ktp/Jonathan Rachmadi_20180611102359img_ktp.jpg', 'img_ksk/Jonathan Rachmadi_20180611102359img_ksk.jpg', 'img_rek_listrik/Jonathan Rachmadi_20180611102359img_rek_listrik.jpg', 'img_pbb/Jonathan Rachmadi_20180611102359img_pbb.jpg', 'img_surat_pernyataan/Jonathan Rachmadi_20180611102359img_surat_pernyataan.jpg', '2018-06-11 10:23:59', '2018-06-11 10:23:59', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(16, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312000, NULL, NULL, '294212043845', NULL, NULL, 'img_surat_tanah/Jonathan Rachmadi_20180611102645img_surat_tanah.jpg', 'img_ktp/Jonathan Rachmadi_20180611102645img_ktp.jpg', 'img_ksk/Jonathan Rachmadi_20180611102645img_ksk.jpg', 'img_rek_listrik/Jonathan Rachmadi_20180611102645img_rek_listrik.jpg', 'img_pbb/Jonathan Rachmadi_20180611102645img_pbb.jpg', 'img_surat_pernyataan/Jonathan Rachmadi_20180611102645img_surat_pernyataan.jpg', '2018-06-11 10:26:45', '2018-06-11 10:26:45', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(17, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312000, NULL, NULL, '294212043845', NULL, NULL, 'img_surat_tanah/Jonathan Rachmadi_20180611102806img_surat_tanah.jpg', 'img_ktp/Jonathan Rachmadi_20180611102806img_ktp.jpg', 'img_ksk/Jonathan Rachmadi_20180611102806img_ksk.jpg', 'img_rek_listrik/Jonathan Rachmadi_20180611102806img_rek_listrik.jpg', 'img_pbb/Jonathan Rachmadi_20180611102806img_pbb.jpg', 'img_surat_pernyataan/Jonathan Rachmadi_20180611102806img_surat_pernyataan.jpg', '2018-06-11 10:28:06', '2018-06-11 10:28:06', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(18, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, '294212043845', NULL, NULL, 'img_surat_tanah/Jonathan Rachmadi_20180611124006img_surat_tanah.jpg', 'img_ktp/Jonathan Rachmadi_20180611124006img_ktp.jpg', 'img_ksk/Jonathan Rachmadi_20180611124006img_ksk.jpg', 'img_rek_listrik/Jonathan Rachmadi_20180611124006img_rek_listrik.jpg', 'img_pbb/Jonathan Rachmadi_20180611124006img_pbb.jpg', 'img_surat_pernyataan/Jonathan Rachmadi_20180611124006img_surat_pernyataan.jpg', '2018-06-11 12:40:06', '2018-06-11 12:40:06', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(19, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, '294212043845', NULL, NULL, 'img_surat_tanah/Jonathan Rachmadi_20180611124928img_surat_tanah.jpg', 'img_ktp/Jonathan Rachmadi_20180611124928img_ktp.jpg', 'img_ksk/Jonathan Rachmadi_20180611124928img_ksk.jpg', 'img_rek_listrik/Jonathan Rachmadi_20180611124928img_rek_listrik.jpg', 'img_pbb/Jonathan Rachmadi_20180611124928img_pbb.jpg', 'img_surat_pernyataan/Jonathan Rachmadi_20180611124928img_surat_pernyataan.jpg', '2018-06-11 12:49:28', '2018-06-11 12:49:28', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(20, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, '123049213245', NULL, NULL, 'img_surat_tanah/Jonathan Rachmadi_20180611130141img_surat_tanah.jpg', 'img_ktp/Jonathan Rachmadi_20180611130141img_ktp.jpg', 'img_ksk/Jonathan Rachmadi_20180611130141img_ksk.jpg', 'img_rek_listrik/Jonathan Rachmadi_20180611130141img_rek_listrik.jpg', 'img_pbb/Jonathan Rachmadi_20180611130141img_pbb.jpg', 'img_surat_pernyataan/Jonathan Rachmadi_20180611130141img_surat_pernyataan.jpg', '2018-06-11 13:01:41', '2018-06-11 13:01:41', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(21, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, '123049213245', NULL, NULL, 'img_surat_tanah/Jonathan Rachmadi_20180611130211img_surat_tanah.jpg', 'img_ktp/Jonathan Rachmadi_20180611130211img_ktp.jpg', 'img_ksk/Jonathan Rachmadi_20180611130211img_ksk.jpg', 'img_rek_listrik/Jonathan Rachmadi_20180611130211img_rek_listrik.jpg', 'img_pbb/Jonathan Rachmadi_20180611130211img_pbb.jpg', 'img_surat_pernyataan/Jonathan Rachmadi_20180611130211img_surat_pernyataan.jpg', '2018-06-11 13:02:11', '2018-06-11 13:02:11', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(22, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, '123049213245', NULL, NULL, 'img_surat_tanah/Jonathan Rachmadi_20180611130230img_surat_tanah.jpg', 'img_ktp/Jonathan Rachmadi_20180611130230img_ktp.jpg', 'img_ksk/Jonathan Rachmadi_20180611130230img_ksk.jpg', 'img_rek_listrik/Jonathan Rachmadi_20180611130230img_rek_listrik.jpg', 'img_pbb/Jonathan Rachmadi_20180611130230img_pbb.jpg', 'img_surat_pernyataan/Jonathan Rachmadi_20180611130230img_surat_pernyataan.jpg', '2018-06-11 13:02:30', '2018-06-11 13:02:30', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(23, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, '123049213245', NULL, NULL, 'img_surat_tanah/Jonathan Rachmadi_20180611130312img_surat_tanah.jpg', 'img_ktp/Jonathan Rachmadi_20180611130312img_ktp.jpg', 'img_ksk/Jonathan Rachmadi_20180611130312img_ksk.jpg', 'img_rek_listrik/Jonathan Rachmadi_20180611130312img_rek_listrik.jpg', 'img_pbb/Jonathan Rachmadi_20180611130312img_pbb.jpg', 'img_surat_pernyataan/Jonathan Rachmadi_20180611130312img_surat_pernyataan.jpg', '2018-06-11 13:03:12', '2018-06-11 13:03:12', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(24, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, NULL, NULL, '294212043845', NULL, NULL, 'img_surat_tanah/Jonathan Rachmadi_20180612093236img_surat_tanah.jpg', 'img_ktp/Jonathan Rachmadi_20180612093236img_ktp.jpg', 'img_ksk/Jonathan Rachmadi_20180612093236img_ksk.jpg', 'img_rek_listrik/Jonathan Rachmadi_20180612093236img_rek_listrik.jpg', 'img_pbb/Jonathan Rachmadi_20180612093236img_pbb.jpg', 'img_surat_pernyataan/Jonathan Rachmadi_20180612093236img_surat_pernyataan.jpg', '2018-06-12 09:32:36', '2018-06-12 09:32:36', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(25, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, NULL, NULL, '294212043845', NULL, NULL, 'img_surat_tanah/Jonathan Rachmadi_20180612093320img_surat_tanah.jpg', 'img_ktp/Jonathan Rachmadi_20180612093320img_ktp.jpg', 'img_ksk/Jonathan Rachmadi_20180612093320img_ksk.jpg', 'img_rek_listrik/Jonathan Rachmadi_20180612093320img_rek_listrik.jpg', 'img_pbb/Jonathan Rachmadi_20180612093320img_pbb.jpg', 'img_surat_pernyataan/Jonathan Rachmadi_20180612093320img_surat_pernyataan.jpg', '2018-06-12 09:33:20', '2018-06-12 09:33:20', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(26, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, NULL, NULL, '294212043845', NULL, NULL, 'img_surat_tanah/Jonathan Rachmadi_20180612093440img_surat_tanah.jpg', 'img_ktp/Jonathan Rachmadi_20180612093440img_ktp.jpg', 'img_ksk/Jonathan Rachmadi_20180612093440img_ksk.jpg', 'img_rek_listrik/Jonathan Rachmadi_20180612093440img_rek_listrik.jpg', 'img_pbb/Jonathan Rachmadi_20180612093440img_pbb.jpg', 'img_surat_pernyataan/Jonathan Rachmadi_20180612093440img_surat_pernyataan.jpg', '2018-06-12 09:34:40', '2018-06-12 09:34:40', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(27, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, NULL, NULL, '294212043845', NULL, NULL, 'img_surat_tanah/Jonathan Rachmadi_20180612093508img_surat_tanah.jpg', 'img_ktp/Jonathan Rachmadi_20180612093508img_ktp.jpg', 'img_ksk/Jonathan Rachmadi_20180612093508img_ksk.jpg', 'img_rek_listrik/Jonathan Rachmadi_20180612093508img_rek_listrik.jpg', 'img_pbb/Jonathan Rachmadi_20180612093508img_pbb.jpg', 'img_surat_pernyataan/Jonathan Rachmadi_20180612093508img_surat_pernyataan.jpg', '2018-06-12 09:35:08', '2018-06-12 09:35:08', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(28, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, NULL, NULL, '294212043845', NULL, NULL, 'img_surat_tanah/Jonathan Rachmadi_20180612093543img_surat_tanah.jpg', 'img_ktp/Jonathan Rachmadi_20180612093543img_ktp.jpg', 'img_ksk/Jonathan Rachmadi_20180612093543img_ksk.jpg', 'img_rek_listrik/Jonathan Rachmadi_20180612093543img_rek_listrik.jpg', 'img_pbb/Jonathan Rachmadi_20180612093543img_pbb.jpg', 'img_surat_pernyataan/Jonathan Rachmadi_20180612093543img_surat_pernyataan.jpg', '2018-06-12 09:35:43', '2018-06-12 09:35:43', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(29, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, NULL, NULL, '294212043845', NULL, NULL, 'img_surat_tanah/Jonathan Rachmadi_20180612093659img_surat_tanah.jpg', 'img_ktp/Jonathan Rachmadi_20180612093659img_ktp.jpg', 'img_ksk/Jonathan Rachmadi_20180612093659img_ksk.jpg', 'img_rek_listrik/Jonathan Rachmadi_20180612093659img_rek_listrik.jpg', 'img_pbb/Jonathan Rachmadi_20180612093659img_pbb.jpg', 'img_surat_pernyataan/Jonathan Rachmadi_20180612093659img_surat_pernyataan.jpg', '2018-06-12 09:36:59', '2018-06-12 09:36:59', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(30, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312515, NULL, NULL, '123049213245', NULL, NULL, 'img_surat_tanah/Jonathan Rachmadi_20180612094129img_surat_tanah.jpg', 'img_ktp/Jonathan Rachmadi_20180612094129img_ktp.jpg', 'img_ksk/Jonathan Rachmadi_20180612094129img_ksk.jpg', 'img_rek_listrik/Jonathan Rachmadi_20180612094129img_rek_listrik.jpg', 'img_pbb/Jonathan Rachmadi_20180612094129img_pbb.jpg', 'img_surat_pernyataan/Jonathan Rachmadi_20180612094129img_surat_pernyataan.jpg', '2018-06-12 09:41:29', '2018-06-12 09:41:29', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(31, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312515, NULL, NULL, '123049213245', NULL, NULL, 'img_surat_tanah/Jonathan Rachmadi_20180612094332img_surat_tanah.jpg', 'img_ktp/Jonathan Rachmadi_20180612094332img_ktp.jpg', 'img_ksk/Jonathan Rachmadi_20180612094332img_ksk.jpg', 'img_rek_listrik/Jonathan Rachmadi_20180612094332img_rek_listrik.jpg', 'img_pbb/Jonathan Rachmadi_20180612094332img_pbb.jpg', 'img_surat_pernyataan/Jonathan Rachmadi_20180612094332img_surat_pernyataan.jpg', '2018-06-12 09:43:32', '2018-06-12 09:43:32', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(32, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, '123049213245', NULL, NULL, 'img_surat_tanah/Jonathan Rachmadi_20180620091033img_surat_tanah.jpg', 'img_ktp/Jonathan Rachmadi_20180620091033img_ktp.jpg', 'img_ksk/Jonathan Rachmadi_20180620091033img_ksk.jpg', 'img_rek_listrik/Jonathan Rachmadi_20180620091033img_rek_listrik.jpg', 'img_pbb/Jonathan Rachmadi_20180620091033img_pbb.jpg', 'img_surat_pernyataan/Jonathan Rachmadi_20180620091033img_surat_pernyataan.jpg', '2018-06-20 09:10:33', '2018-06-20 09:10:33', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(33, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, '123049213245', NULL, NULL, 'img_surat_tanah/Jonathan Rachmadi_20180620091236img_surat_tanah.jpg', 'img_ktp/Jonathan Rachmadi_20180620091236img_ktp.jpg', 'img_ksk/Jonathan Rachmadi_20180620091236img_ksk.jpg', 'img_rek_listrik/Jonathan Rachmadi_20180620091236img_rek_listrik.jpg', 'img_pbb/Jonathan Rachmadi_20180620091236img_pbb.jpg', 'img_surat_pernyataan/Jonathan Rachmadi_20180620091236img_surat_pernyataan.jpg', '2018-06-20 09:12:36', '2018-06-20 09:12:36', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(34, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, '123049213245', NULL, NULL, 'img_surat_tanah/Jonathan Rachmadi_20180620091259img_surat_tanah.jpg', 'img_ktp/Jonathan Rachmadi_20180620091259img_ktp.jpg', 'img_ksk/Jonathan Rachmadi_20180620091259img_ksk.jpg', 'img_rek_listrik/Jonathan Rachmadi_20180620091259img_rek_listrik.jpg', 'img_pbb/Jonathan Rachmadi_20180620091259img_pbb.jpg', 'img_surat_pernyataan/Jonathan Rachmadi_20180620091259img_surat_pernyataan.jpg', '2018-06-20 09:12:59', '2018-06-20 09:12:59', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(35, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, '123049213245', NULL, NULL, 'img_surat_tanah/Jonathan Rachmadi_20180620091316img_surat_tanah.jpg', 'img_ktp/Jonathan Rachmadi_20180620091316img_ktp.jpg', 'img_ksk/Jonathan Rachmadi_20180620091316img_ksk.jpg', 'img_rek_listrik/Jonathan Rachmadi_20180620091316img_rek_listrik.jpg', 'img_pbb/Jonathan Rachmadi_20180620091316img_pbb.jpg', 'img_surat_pernyataan/Jonathan Rachmadi_20180620091316img_surat_pernyataan.jpg', '2018-06-20 09:13:16', '2018-06-20 09:13:16', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(36, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, '123049213245', NULL, NULL, 'img_surat_tanah/Jonathan Rachmadi_20180620091345img_surat_tanah.jpg', 'img_ktp/Jonathan Rachmadi_20180620091345img_ktp.jpg', 'img_ksk/Jonathan Rachmadi_20180620091345img_ksk.jpg', 'img_rek_listrik/Jonathan Rachmadi_20180620091345img_rek_listrik.jpg', 'img_pbb/Jonathan Rachmadi_20180620091345img_pbb.jpg', 'img_surat_pernyataan/Jonathan Rachmadi_20180620091345img_surat_pernyataan.jpg', '2018-06-20 09:13:45', '2018-06-20 09:13:45', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(37, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, '123049213245', NULL, NULL, 'img_surat_tanah/Jonathan Rachmadi_20180620091444img_surat_tanah.jpg', 'img_ktp/Jonathan Rachmadi_20180620091444img_ktp.jpg', 'img_ksk/Jonathan Rachmadi_20180620091444img_ksk.jpg', 'img_rek_listrik/Jonathan Rachmadi_20180620091444img_rek_listrik.jpg', 'img_pbb/Jonathan Rachmadi_20180620091444img_pbb.jpg', 'img_surat_pernyataan/Jonathan Rachmadi_20180620091444img_surat_pernyataan.jpg', '2018-06-20 09:14:44', '2018-06-20 09:14:44', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(38, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, '123049213245', NULL, NULL, 'img_surat_tanah/Jonathan Rachmadi_20180620091510img_surat_tanah.jpg', 'img_ktp/Jonathan Rachmadi_20180620091510img_ktp.jpg', 'img_ksk/Jonathan Rachmadi_20180620091510img_ksk.jpg', 'img_rek_listrik/Jonathan Rachmadi_20180620091510img_rek_listrik.jpg', 'img_pbb/Jonathan Rachmadi_20180620091510img_pbb.jpg', 'img_surat_pernyataan/Jonathan Rachmadi_20180620091510img_surat_pernyataan.jpg', '2018-06-20 09:15:10', '2018-06-20 09:15:10', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(39, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, '123049213245', NULL, NULL, 'img_surat_tanah/Jonathan Rachmadi_20180620091526img_surat_tanah.jpg', 'img_ktp/Jonathan Rachmadi_20180620091526img_ktp.jpg', 'img_ksk/Jonathan Rachmadi_20180620091526img_ksk.jpg', 'img_rek_listrik/Jonathan Rachmadi_20180620091526img_rek_listrik.jpg', 'img_pbb/Jonathan Rachmadi_20180620091526img_pbb.jpg', 'img_surat_pernyataan/Jonathan Rachmadi_20180620091526img_surat_pernyataan.jpg', '2018-06-20 09:15:26', '2018-06-20 09:15:26', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(40, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, '123049213245', NULL, NULL, 'img_surat_tanah/Jonathan Rachmadi_20180620091539img_surat_tanah.jpg', 'img_ktp/Jonathan Rachmadi_20180620091539img_ktp.jpg', 'img_ksk/Jonathan Rachmadi_20180620091539img_ksk.jpg', 'img_rek_listrik/Jonathan Rachmadi_20180620091539img_rek_listrik.jpg', 'img_pbb/Jonathan Rachmadi_20180620091539img_pbb.jpg', 'img_surat_pernyataan/Jonathan Rachmadi_20180620091539img_surat_pernyataan.jpg', '2018-06-20 09:15:39', '2018-06-20 09:15:39', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(41, NULL, NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, '123049213245', NULL, NULL, 'img_surat_tanah/Jonathan Rachmadi_20180620091557img_surat_tanah.jpg', 'img_ktp/Jonathan Rachmadi_20180620091557img_ktp.jpg', 'img_ksk/Jonathan Rachmadi_20180620091557img_ksk.jpg', 'img_rek_listrik/Jonathan Rachmadi_20180620091557img_rek_listrik.jpg', 'img_pbb/Jonathan Rachmadi_20180620091557img_pbb.jpg', 'img_surat_pernyataan/Jonathan Rachmadi_20180620091557img_surat_pernyataan.jpg', '2018-06-20 09:15:57', '2018-06-20 09:15:57', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(42, 'T20180000007', NULL, NULL, 'Anton Nazarudin', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, NULL, NULL, '123049213245', NULL, NULL, 'img_surat_tanah/Anton Nazarudin_20180624155207img_surat_tanah.jpg', 'img_ktp/Anton Nazarudin_20180624155207img_ktp.jpg', 'img_ksk/Anton Nazarudin_20180624155207img_ksk.jpg', 'img_rek_listrik/Anton Nazarudin_20180624155207img_rek_listrik.jpg', 'img_pbb/Anton Nazarudin_20180624155207img_pbb.jpg', 'img_surat_pernyataan/Anton Nazarudin_20180624155207img_surat_pernyataan.jpg', '2018-06-24 15:52:07', '2018-06-24 15:52:16', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(43, 'T20180000001', NULL, NULL, 'Anton Nazarudin', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, NULL, NULL, '123049213245', NULL, NULL, 'img_surat_tanah/Anton Nazarudin_20180624155707img_surat_tanah.jpg', 'img_ktp/Anton Nazarudin_20180624155707img_ktp.jpg', 'img_ksk/Anton Nazarudin_20180624155707img_ksk.jpg', 'img_rek_listrik/Anton Nazarudin_20180624155707img_rek_listrik.jpg', 'img_pbb/Anton Nazarudin_20180624155707img_pbb.jpg', 'img_surat_pernyataan/Anton Nazarudin_20180624155707img_surat_pernyataan.jpg', '2018-06-24 15:57:07', '2018-06-24 15:57:10', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(44, 'T20180000002', '207', NULL, 'Anton Nazarudin', 'Jalan Kali Kepunton no.4 (0 00)', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, NULL, NULL, '123049213245', NULL, NULL, 'img_surat_tanah/Anton Nazarudin_20180624155903img_surat_tanah.jpg', 'img_ktp/Anton Nazarudin_20180624155903img_ktp.jpg', 'img_ksk/Anton Nazarudin_20180624155903img_ksk.jpg', 'img_rek_listrik/Anton Nazarudin_20180624155903img_rek_listrik.jpg', 'img_pbb/Anton Nazarudin_20180624155903img_pbb.jpg', 'img_surat_pernyataan/Anton Nazarudin_20180624155903img_surat_pernyataan.jpg', '2018-06-24 15:59:03', '2018-06-24 15:59:04', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(51, NULL, NULL, NULL, 'Anton Nazarudin', 'Jalan Kali Kepunton no.4 (0 00) ( )', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, '22', '1', NULL, NULL, NULL, NULL, 0, 12312000, 90, 10, '123049213245', 'SZ505', '5', NULL, 'img_ktp/Anton Nazarudin_20180628044401img_ktp.jpeg', 'img_ksk/Anton Nazarudin_20180628044401img_ksk.jpeg', 'img_rek_listrik/Anton Nazarudin_20180628044401img_rek_listrik.jpeg', 'img_pbb/Anton Nazarudin_20180628044401img_pbb.jpeg', 'img_surat_pernyataan/Anton Nazarudin_20180628044401img_surat_pernyataan.jpeg', '2018-06-28 04:44:01', '2018-06-28 04:44:01', 15, 9, 10, 'B', NULL, NULL, NULL, NULL, NULL),
	(54, NULL, NULL, NULL, 'Troy Wahana', 'Jl Bhaskara Utara B-12 ( )', 'Bhaskara Utara', NULL, '12', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, '22', '1', NULL, NULL, NULL, NULL, 0, 12312000, 90, 10, '123049213245', 'SZ217', '4', NULL, 'img_ktp/Troy Wahana_20180628063419img_ktp.jpg', 'img_ksk/Troy Wahana_20180628063419img_ksk.jpg', 'img_rek_listrik/Troy Wahana_20180628063419img_rek_listrik.png', 'img_pbb/Troy Wahana_20180628063419img_pbb.png', 'img_surat_pernyataan/Troy Wahana_20180628063419img_surat_pernyataan.png', '2018-06-28 06:34:19', '2018-06-28 06:34:19', 15, 9, 10, 'B', NULL, NULL, NULL, NULL, NULL),
	(55, NULL, NULL, NULL, 'Chusnul Chotimah', 'Jl Pandugo PV 16 ( )', 'Pandugo', NULL, 'PV 16', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, '22', '1', NULL, NULL, NULL, NULL, 0, 12312000, 90, 10, '123049213245', 'SZ217', '5', NULL, 'img_ktp/Chusnul Chotimah_20180702031622img_ktp.jpg', 'img_ksk/Chusnul Chotimah_20180702031622img_ksk.jpg', 'img_rek_listrik/Chusnul Chotimah_20180702031622img_rek_listrik.png', 'img_pbb/Chusnul Chotimah_20180702031622img_pbb.png', 'img_surat_pernyataan/Chusnul Chotimah_20180702031622img_surat_pernyataan.png', '2018-07-02 03:16:22', '2018-07-02 03:16:22', 15, 9, 10, 'B', NULL, NULL, NULL, NULL, NULL),
	(56, NULL, NULL, NULL, 'Chusnul Chotimah', 'Jl Pandugo PV 16 ( )', 'Pandugo', NULL, 'PV 16', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, '22', '1', NULL, NULL, NULL, NULL, 0, 12312000, 90, 10, '123049213245', 'SZ114', '5', NULL, 'img_ktp/Chusnul Chotimah_20180702031834img_ktp.jpg', 'img_ksk/Chusnul Chotimah_20180702031834img_ksk.jpg', 'img_rek_listrik/Chusnul Chotimah_20180702031834img_rek_listrik.png', 'img_pbb/Chusnul Chotimah_20180702031834img_pbb.png', 'img_surat_pernyataan/Chusnul Chotimah_20180702031834img_surat_pernyataan.png', '2018-07-02 03:18:34', '2018-07-02 03:18:34', 15, 9, 10, 'B', NULL, NULL, NULL, NULL, NULL),
	(57, NULL, NULL, NULL, 'Chusnul Chotimah', 'Jl Pandugo PV 16', 'Arif Rahman Hakim', 'Makam', '59', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, '22', '1', NULL, NULL, NULL, NULL, 0, 12312000, 90, 10, '123049213245', 'SZ225', '5', NULL, 'img_ktp/Chusnul Chotimah_20180702035549img_ktp.jpg', 'img_ksk/Chusnul Chotimah_20180702035549img_ksk.jpg', 'img_rek_listrik/Chusnul Chotimah_20180702035549img_rek_listrik.png', 'img_pbb/Chusnul Chotimah_20180702035549img_pbb.png', 'img_surat_pernyataan/Chusnul Chotimah_20180702035549img_surat_pernyataan.png', '2018-07-02 03:55:50', '2018-07-02 03:55:50', 15, 9, 10, 'B', NULL, NULL, NULL, NULL, NULL),
	(58, NULL, NULL, NULL, 'Chusnul Chotimah', 'Jl Pandugo PV 16', 'Arif Rahman Hakim', 'Makam', '59', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, '22', '1', NULL, NULL, NULL, NULL, 0, 12312000, 90, 10, '123049213245', 'SZ225', '5', NULL, 'img_ktp/Chusnul Chotimah_20180702040620img_ktp.jpg', 'img_ksk/Chusnul Chotimah_20180702040620img_ksk.jpg', 'img_rek_listrik/Chusnul Chotimah_20180702040620img_rek_listrik.png', 'img_pbb/Chusnul Chotimah_20180702040620img_pbb.png', 'img_surat_pernyataan/Chusnul Chotimah_20180702040620img_surat_pernyataan.png', '2018-07-02 04:06:20', '2018-07-02 04:06:20', 15, 9, 10, 'B', NULL, NULL, NULL, NULL, NULL),
	(59, NULL, NULL, NULL, 'Chusnul Chotimah', 'Jl Pandugo PV 16', 'Arif Rahman Hakim', 'Makam', '59', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, '2', '1', NULL, NULL, NULL, NULL, 0, 12312000, 90, 10, '123049213245', 'SZ205', '5', NULL, 'img_ktp/Chusnul Chotimah_20180702041733img_ktp.jpg', 'img_ksk/Chusnul Chotimah_20180702041733img_ksk.jpg', 'img_rek_listrik/Chusnul Chotimah_20180702041733img_rek_listrik.png', 'img_pbb/Chusnul Chotimah_20180702041733img_pbb.png', 'img_surat_pernyataan/Chusnul Chotimah_20180702041733img_surat_pernyataan.png', '2018-07-02 04:17:33', '2018-07-02 04:17:33', 15, 9, 10, 'B', NULL, NULL, -7.28361607, 112.75148773, NULL),
	(60, NULL, NULL, NULL, 'Chusnul Chotimah', 'Jl Pandugo PV 16', 'Arif Rahman Hakim', 'Makam', '59', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, '2', '1', NULL, NULL, NULL, NULL, 0, 12312000, 90, 10, '123049213245', 'SZ205', '5', NULL, 'img_ktp/Chusnul Chotimah_20180702042020img_ktp.jpg', 'img_ksk/Chusnul Chotimah_20180702042020img_ksk.jpg', 'img_rek_listrik/Chusnul Chotimah_20180702042020img_rek_listrik.png', 'img_pbb/Chusnul Chotimah_20180702042020img_pbb.png', 'img_surat_pernyataan/Chusnul Chotimah_20180702042020img_surat_pernyataan.png', '2018-07-02 04:20:20', '2018-07-02 04:20:20', 15, 9, 10, 'T', NULL, NULL, -7.28361607, 112.75148773, NULL),
	(61, NULL, NULL, NULL, 'Chusnul Chotimah', 'Jl Pandugo PV 16', 'Arif Rahman Hakim', 'Makam', '59', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, '2', '1', NULL, NULL, NULL, NULL, 0, 12312000, 90, 10, '123049213245', 'SZ216', '5', NULL, 'img_ktp/Chusnul Chotimah_20180702042120img_ktp.jpg', 'img_ksk/Chusnul Chotimah_20180702042120img_ksk.jpg', 'img_rek_listrik/Chusnul Chotimah_20180702042120img_rek_listrik.png', 'img_pbb/Chusnul Chotimah_20180702042120img_pbb.png', 'img_surat_pernyataan/Chusnul Chotimah_20180702042120img_surat_pernyataan.png', '2018-07-02 04:21:20', '2018-07-02 04:21:20', 15, 9, 10, 'T', NULL, NULL, -7.26717901, 112.79401398, NULL),
	(62, NULL, NULL, NULL, 'Chusnul Chotimah', 'Jl Pandugo PV 16', 'Arif Rahman Hakim', 'Makam', '59', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, '2', '1', NULL, NULL, NULL, NULL, 0, 12312000, 90, 10, '123049213245', 'SZ542', '5', NULL, 'img_ktp/Chusnul Chotimah_20180702042309img_ktp.jpg', 'img_ksk/Chusnul Chotimah_20180702042309img_ksk.jpg', 'img_rek_listrik/Chusnul Chotimah_20180702042309img_rek_listrik.png', 'img_pbb/Chusnul Chotimah_20180702042309img_pbb.png', 'img_surat_pernyataan/Chusnul Chotimah_20180702042309img_surat_pernyataan.png', '2018-07-02 04:23:09', '2018-07-02 04:23:09', 15, 9, 10, 'B', NULL, NULL, -7.25296879, 112.64734650, NULL),
	(63, NULL, NULL, NULL, 'Chusnul Chotimah', 'Jl Pandugo PV 16', 'Arif Rahman Hakim', 'Makam', '59', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, '2', '1', NULL, NULL, NULL, NULL, 0, 12312000, 90, 10, '123049213245', 'SZ542', '5', NULL, 'img_ktp/Chusnul Chotimah_20180702042415img_ktp.jpg', 'img_ksk/Chusnul Chotimah_20180702042415img_ksk.jpg', 'img_rek_listrik/Chusnul Chotimah_20180702042415img_rek_listrik.png', 'img_pbb/Chusnul Chotimah_20180702042415img_pbb.png', 'img_surat_pernyataan/Chusnul Chotimah_20180702042415img_surat_pernyataan.png', '2018-07-02 04:24:15', '2018-07-02 04:24:15', 15, 9, 10, 'B', NULL, NULL, -7.25296879, 112.64734650, NULL),
	(64, NULL, NULL, NULL, 'Chusnul Chotimah', 'Jl Pandugo PV 16', 'Arif Rahman Hakim', 'Makam', '59', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, '22', '1', NULL, NULL, NULL, NULL, 0, 12312000, 90, 10, '123049213245', 'SZ542', '5', NULL, 'img_ktp/Chusnul Chotimah_20180702042856img_ktp.jpg', 'img_ksk/Chusnul Chotimah_20180702042856img_ksk.jpg', 'img_rek_listrik/Chusnul Chotimah_20180702042856img_rek_listrik.png', 'img_pbb/Chusnul Chotimah_20180702042856img_pbb.png', 'img_surat_pernyataan/Chusnul Chotimah_20180702042856img_surat_pernyataan.png', '2018-07-02 04:28:56', '2018-07-02 04:28:56', 15, 9, 10, 'B', NULL, NULL, -7.25339174, 112.65030670, NULL),
	(65, NULL, NULL, NULL, 'Chusnul Chotimah', 'Jl Pandugo PV 16', 'Arif Rahman Hakim', 'Makam', '59', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, '22', '1', NULL, NULL, NULL, NULL, 0, 12312000, 90, 10, '123049213245', 'SZ542', '5', NULL, 'img_ktp/Chusnul Chotimah_20180702060337img_ktp.jpg', 'img_ksk/Chusnul Chotimah_20180702060337img_ksk.jpg', 'img_rek_listrik/Chusnul Chotimah_20180702060337img_rek_listrik.png', 'img_pbb/Chusnul Chotimah_20180702060337img_pbb.png', 'img_surat_pernyataan/Chusnul Chotimah_20180702060337img_surat_pernyataan.png', '2018-07-02 06:03:37', '2018-07-02 06:03:37', 15, 9, 10, 'B', NULL, NULL, -7.25339174, 112.65030670, NULL),
	(66, NULL, NULL, 'tidak-bermasalah', 'Joshua Kevin', 'Jalan Kali Kepunton no.4', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', NULL, 150, NULL, NULL, NULL, NULL, NULL, NULL, '10', '1', NULL, NULL, NULL, NULL, 900, 12312515, 100, 200, '123049213245', NULL, '1', NULL, 'img_ktp/Joshua Kevin_20180704182954img_ktp.jpg', 'img_ksk/Joshua Kevin_20180704182954img_ksk.jpg', 'img_rek_listrik/Joshua Kevin_20180704182954img_rek_listrik.jpg', 'img_pbb/Joshua Kevin_20180704182954img_pbb.jpg', 'img_surat_pernyataan/Joshua Kevin_20180704182954img_surat_pernyataan.jpg', '2018-07-04 18:29:54', '2018-07-04 18:29:54', 300, 300, 200, 'T', NULL, NULL, -7.25044489, 112.76884460, NULL),
	(67, NULL, NULL, 'tidak-bermasalah', 'Joshua Kevin', 'Jalan Kali Kepunton no.4', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', NULL, 150, NULL, NULL, NULL, NULL, NULL, NULL, '10', '1', NULL, NULL, NULL, NULL, 900, 12312515, 100, 200, '123049213245', NULL, '1', NULL, 'img_ktp/Joshua Kevin_20180704183231img_ktp.jpg', 'img_ksk/Joshua Kevin_20180704183231img_ksk.jpg', 'img_rek_listrik/Joshua Kevin_20180704183231img_rek_listrik.jpg', 'img_pbb/Joshua Kevin_20180704183231img_pbb.jpg', 'img_surat_pernyataan/Joshua Kevin_20180704183231img_surat_pernyataan.jpg', '2018-07-04 18:32:31', '2018-07-04 18:32:31', 300, 300, 200, 'T', NULL, NULL, -7.25044489, 112.76884460, NULL),
	(68, NULL, NULL, 'tidak-bermasalah', 'Joshua Kevin', 'Jalan Kali Kepunton no.4', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', NULL, 150, NULL, NULL, NULL, NULL, NULL, NULL, '10', '1', NULL, NULL, NULL, NULL, 900, 12312515, 100, 200, '123049213245', NULL, '1', NULL, 'img_ktp/Joshua Kevin_20180704183530img_ktp.jpg', 'img_ksk/Joshua Kevin_20180704183530img_ksk.jpg', 'img_rek_listrik/Joshua Kevin_20180704183530img_rek_listrik.jpg', 'img_pbb/Joshua Kevin_20180704183530img_pbb.jpg', 'img_surat_pernyataan/Joshua Kevin_20180704183530img_surat_pernyataan.jpg', '2018-07-04 18:35:30', '2018-07-04 18:35:30', 300, 300, 200, 'T', NULL, NULL, -7.25044489, 112.76884460, NULL),
	(69, NULL, NULL, 'tidak-bermasalah', 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', NULL, 150, NULL, NULL, NULL, NULL, NULL, NULL, '21', '1', NULL, NULL, NULL, NULL, 1300, 12312000, 100, 200, '123049213245', NULL, '1', NULL, 'img_ktp/Jonathan Rachmadi_20180704183634img_ktp.jpg', 'img_ksk/Jonathan Rachmadi_20180704183634img_ksk.jpg', 'img_rek_listrik/Jonathan Rachmadi_20180704183634img_rek_listrik.jpg', 'img_pbb/Jonathan Rachmadi_20180704183634img_pbb.jpg', 'img_surat_pernyataan/Jonathan Rachmadi_20180704183634img_surat_pernyataan.jpg', '2018-07-04 18:36:34', '2018-07-04 18:36:34', 300, 300, 200, 'T', NULL, NULL, -7.25044489, 112.76884460, NULL),
	(70, NULL, NULL, 'tidak-bermasalah', 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', NULL, 150, NULL, NULL, NULL, NULL, NULL, NULL, '21', '1', NULL, NULL, NULL, NULL, 1300, 12312000, 100, 200, '123049213245', NULL, '1', NULL, 'img_ktp/Jonathan Rachmadi_20180704183709img_ktp.jpg', 'img_ksk/Jonathan Rachmadi_20180704183709img_ksk.jpg', 'img_rek_listrik/Jonathan Rachmadi_20180704183709img_rek_listrik.jpg', 'img_pbb/Jonathan Rachmadi_20180704183709img_pbb.jpg', 'img_surat_pernyataan/Jonathan Rachmadi_20180704183709img_surat_pernyataan.jpg', '2018-07-04 18:37:09', '2018-07-04 18:37:09', 300, 300, 200, 'T', NULL, NULL, -7.25044489, 112.76884460, NULL),
	(71, NULL, NULL, 'tidak-bermasalah', 'Anton Nazarudin', 'Keputih', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, '21', '1', NULL, NULL, NULL, NULL, 2200, 12312515, 100, 200, '123049213245', NULL, '1', NULL, 'img_ktp/Anton Nazarudin_20180704183857img_ktp.jpg', 'img_ksk/Anton Nazarudin_20180704183857img_ksk.jpg', 'img_rek_listrik/Anton Nazarudin_20180704183857img_rek_listrik.jpg', 'img_pbb/Anton Nazarudin_20180704183857img_pbb.jpg', 'img_surat_pernyataan/Anton Nazarudin_20180704183857img_surat_pernyataan.jpg', '2018-07-04 18:38:57', '2018-07-04 18:38:57', 300, 300, 200, 'T', NULL, NULL, -7.25044489, 112.76884460, NULL),
	(72, 'T20180000024', '221', 'bermasalah', 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 900, 12312000, 100, 200, '123049213245', '219', '1', NULL, 'img_ktp/Jonathan Rachmadi_20180704184213img_ktp.jpg', 'img_ksk/Jonathan Rachmadi_20180704184213img_ksk.jpg', 'img_rek_listrik/Jonathan Rachmadi_20180704184213img_rek_listrik.jpg', 'img_pbb/Jonathan Rachmadi_20180704184213img_pbb.jpg', 'img_surat_pernyataan/Jonathan Rachmadi_20180704184213img_surat_pernyataan.jpg', '2018-07-04 18:42:13', '2018-07-27 06:12:05', 300, 300, 200, 'T', NULL, NULL, -7.25044489, 112.76884460, NULL),
	(73, 'T20180000005', '223', 'bermasalah', 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4', 'Keputih', '80', NULL, NULL, NULL, '08985365597', NULL, 150, NULL, NULL, NULL, NULL, NULL, NULL, '21', '1', NULL, NULL, NULL, NULL, 900, 12312515, 100, 200, '123049213245', NULL, '4', NULL, 'img_ktp/Jonathan Rachmadi_20180704185345img_ktp.jpg', 'img_ksk/Jonathan Rachmadi_20180704185344img_ksk.jpg', 'img_rek_listrik/Jonathan Rachmadi_20180704185345img_rek_listrik.jpg', 'img_pbb/Jonathan Rachmadi_20180704185345img_pbb.jpg', 'img_surat_pernyataan/Jonathan Rachmadi_20180704185345img_surat_pernyataan.jpg', '2018-07-04 18:53:45', '2018-07-05 17:08:16', 300, 300, 200, 'T', NULL, NULL, -7.25044489, 112.76884460, NULL),
	(74, 'T20180000006', NULL, 'bermasalah', 'Joshua Kevin', 'Jalan Kali Kepunton no.4', 'Keputih', '80', NULL, NULL, NULL, '08985365597', NULL, 150, NULL, NULL, NULL, NULL, NULL, NULL, '21', '1', NULL, NULL, NULL, NULL, 0, 12312515, 100, 200, '123049213245', NULL, '4', NULL, 'img_ktp/Joshua Kevin_20180704185517img_ktp.jpg', 'img_ksk/Joshua Kevin_20180704185517img_ksk.jpg', 'img_rek_listrik/Joshua Kevin_20180704185517img_rek_listrik.jpg', 'img_pbb/Joshua Kevin_20180704185517img_pbb.jpg', 'img_surat_pernyataan/Joshua Kevin_20180704185517img_surat_pernyataan.jpg', '2018-07-04 18:55:17', '2018-07-05 17:07:11', 300, 300, 200, 'T', NULL, NULL, -7.25044489, 112.76884460, NULL),
	(75, 'T20180000004', '208', 'bermasalah', 'Joshua Kevin', 'Jalan Kali Kepunton no.4', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', NULL, 150, NULL, NULL, NULL, NULL, NULL, NULL, '21', '1', NULL, NULL, NULL, NULL, 0, 12312515, 100, 200, '123049213245', NULL, '4', NULL, 'img_ktp/Joshua Kevin_20180704185603img_ktp.jpg', 'img_ksk/Joshua Kevin_20180704185603img_ksk.jpg', 'img_rek_listrik/Joshua Kevin_20180704185603img_rek_listrik.jpg', 'img_pbb/Joshua Kevin_20180704185603img_pbb.jpg', 'img_surat_pernyataan/Joshua Kevin_20180704185603img_surat_pernyataan.jpg', '2018-07-04 18:56:03', '2018-07-04 18:56:03', 300, 300, 200, 'T', NULL, NULL, -7.25044489, 112.76884460, 'online'),
	(76, 'T20180000003', '209', 'bermasalah', 'Joshua Kevin', 'Jalan Kali Kepunton no.4', 'Keputih', '100', NULL, NULL, NULL, '08985365597', '080000', 150, NULL, NULL, NULL, NULL, NULL, NULL, '21', '1', NULL, NULL, NULL, NULL, 900, 12312515, 100, 200, '123049213245', NULL, '129', NULL, 'img_ktp/Jonathan Rachmadi_20180704185930img_ktp.jpg', 'img_ksk/Jonathan Rachmadi_20180704185930img_ksk.jpg', 'img_rek_listrik/Jonathan Rachmadi_20180704185930img_rek_listrik.jpg', 'img_pbb/Jonathan Rachmadi_20180704185930img_pbb.jpg', 'img_surat_pernyataan/Jonathan Rachmadi_20180704185930img_surat_pernyataan.jpg', '2018-07-04 18:59:30', '2018-07-05 03:56:06', 300, 300, 200, 'B', NULL, NULL, -7.24857187, 112.63014221, 'loket'),
	(77, 'B20180000051', '214', 'tidak-bermasalah', 'Chusnul Chotimah', 'Jl Pandugo PV 16', 'Arif Rahman Hakim', 'Makam', '59', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, 'Pabean cantikan', 'Airlangga', NULL, NULL, NULL, NULL, 0, 12312000, 90, 10, '123049213245', '542', '4', NULL, 'img_ktp/Chusnul Chotimah_20180706050541img_ktp.jpg', 'img_ksk/Chusnul Chotimah_20180706050541img_ksk.jpg', 'img_rek_listrik/Chusnul Chotimah_20180706050541img_rek_listrik.jpg', 'img_pbb/Chusnul Chotimah_20180706050541img_pbb.jpg', 'img_surat_pernyataan/Chusnul Chotimah_20180706050541img_surat_pernyataan.jpg', '2018-07-06 05:05:41', '2018-07-26 08:37:53', 15, 9, 10, 'B', NULL, NULL, -7.25339174, 112.65030670, 'mobile'),
	(78, 'T20180000012', '242', 'bermasalah', 'dev-diganti', 'Jalan Kali Kepunton no.4', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, 'Asem Rowo', 'Airlangga', NULL, NULL, NULL, NULL, 1300, 12312000, 100, 200, '123049213245', 'SZ219', '4', NULL, 'img_ktp/dev_20180706080022img_ktp.jpg', 'img_ksk/dev_20180706080022img_ksk.jpg', 'img_rek_listrik/dev_20180706080022img_rek_listrik.jpg', 'img_pbb/dev_20180706080022img_pbb.jpg', 'img_surat_pernyataan/dev_20180706080022img_surat_pernyataan.jpg', '2018-07-06 08:00:22', '2018-07-06 08:01:48', 300, 300, 200, 'T', NULL, NULL, -7.25044489, 112.76884460, 'online'),
	(79, 'T20180000016', '210', 'tidak-bermasalah', 'Joshua Kevin', 'Jalan Kali Kepunton no.4', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', NULL, 150, NULL, NULL, NULL, NULL, NULL, NULL, 'Sukolilo', 'Keputih', NULL, NULL, NULL, NULL, 900, 12312515, 100, 200, '123049213245', 'SZ222', '1', NULL, 'img_ktp/Joshua Kevin_20180707181020img_ktp.PNG', 'img_ksk/Joshua Kevin_20180707181020img_ksk.PNG', 'img_rek_listrik/Joshua Kevin_20180707181020img_rek_listrik.PNG', 'img_pbb/Joshua Kevin_20180707181020img_pbb.PNG', 'img_surat_pernyataan/Joshua Kevin_20180707181020img_surat_pernyataan.PNG', '2018-07-07 18:10:20', '2018-07-07 18:11:13', 300, 300, 200, 'T', NULL, 'depan gang', -7.28688526, 112.80360413, 'loket'),
	(80, 'T20180000017', '236', 'tidak-bermasalah', 'asdasd', 'Jalan Kali Kepunton no.4', 'Keputih', 'Perintis', '3A', NULL, NULL, '08985365597', '1100', 150, NULL, NULL, NULL, NULL, NULL, NULL, 'Sukolilo', 'Kalijudan', NULL, NULL, NULL, NULL, 900, 12312000, 100, 20, '123049213245', '219', '132', NULL, 'img_ktp/asdasd_20180708023053img_ktp.jpg', 'img_ksk/asdasd_20180708023053img_ksk.jpg', 'img_rek_listrik/asdasd_20180708023053img_rek_listrik.jpg', 'img_pbb/asdasd_20180708023053img_pbb.jpg', 'img_surat_pernyataan/asdasd_20180708023053img_surat_pernyataan.jpg', '2018-07-08 02:30:54', '2018-07-08 02:35:49', 10, 124, 200, 'T', '2', NULL, -7.25087070, 112.78070831, 'online'),
	(81, 'B20180000050', '242', 'tidak-bermasalah', 'Arif Rahman', 'Jl Pandugo PV 16', 'Arif Rahman Hakim', 'Makam', '59', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, 'Genteng', 'Babatan', NULL, NULL, NULL, NULL, 900, 12312000, 90, 10, '123049213245', '534', '4', NULL, 'img_ktp/Arif Rahman_20180710171831img_ktp.PNG', 'img_ksk/Arif Rahman_20180710171831img_ksk.PNG', 'img_rek_listrik/Arif Rahman_20180710171831img_rek_listrik.PNG', 'img_pbb/Arif Rahman_20180710171831img_pbb.PNG', 'img_surat_pernyataan/Arif Rahman_20180710171831img_surat_pernyataan.PNG', '2018-07-10 17:18:31', '2018-07-25 11:34:15', 15, 9, 10, 'B', NULL, NULL, -7.27561426, 112.64163971, 'mobile'),
	(82, 'T20180000025', '242', NULL, 'Muhammad Farzan Ar Rayyan', 'Jl Gunung Anyar 23', 'Gunung Anyar', '1', '23', NULL, NULL, '081233103652', '081233103652', 200, NULL, NULL, NULL, NULL, NULL, NULL, 'Gunung Anyar', 'Gunung Anyar', NULL, NULL, NULL, NULL, 2200, 500000, 200, 20, '12938239829', '117', '129', NULL, 'img_ktp/Muhammad Farzan Ar Rayyan_20180804145525img_ktp.png', 'img_ksk/Muhammad Farzan Ar Rayyan_20180804145525img_ksk.png', 'img_rek_listrik/Muhammad Farzan Ar Rayyan_20180804145525img_rek_listrik.jpg', 'img_pbb/Muhammad Farzan Ar Rayyan_20180804145525img_pbb.jpg', 'img_surat_pernyataan/Muhammad Farzan Ar Rayyan_20180804145525img_surat_pernyataan.jpg', '2018-08-04 14:55:25', '2018-08-04 16:24:32', 10, 20, 10, 'T', '24', 'Ke arah masjid sebelahnya', -7.33413412, 112.79759828, 'Loket'),
	(83, 'T20180000026', '242', 'pribadi', 'Amier', 'penjaringan asri pe 16', 'Penjaringan Asri', 'Makam', '80', NULL, NULL, '08985365597', '080000', 21, NULL, NULL, NULL, NULL, NULL, NULL, 'Sukolilo', 'Keputih', NULL, NULL, NULL, NULL, 900, 300000000, 10, 7, '0123456678', '228', '153', NULL, 'img_ktp/Amier_20180810072822img_ktp.PNG', 'img_ksk/Amier_20180810072822img_ksk.PNG', 'img_rek_listrik/Amier_20180810072822img_rek_listrik.PNG', 'img_pbb/Amier_20180810072822img_pbb.PNG', 'img_surat_pernyataan/Amier_20180810072822img_surat_pernyataan.PNG', '2018-08-10 07:28:22', '2018-08-10 07:51:17', 3, 5, 2, 'T', '0', 'depan gang', -7.24622681, 112.77348978, 'Website');

-- Dumping structure for table pdam_web.permissions
CREATE TABLE IF NOT EXISTS `permissions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `built_in` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_unique` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pdam_web.permissions: ~24 rows (approximately)
DELETE FROM `permissions`;
INSERT INTO `permissions` (`id`, `name`, `display_name`, `description`, `built_in`, `created_at`, `updated_at`) VALUES
	(1, 'create-role', 'Create Role', 'Create Role', 1, '2018-06-06 10:24:35', '2018-06-06 10:24:35'),
	(2, 'read-role', 'Read Role', 'Read Role', 1, '2018-06-06 10:24:36', '2018-06-06 10:24:36'),
	(3, 'update-role', 'Update Role', 'Update Role', 1, '2018-06-06 10:24:36', '2018-06-06 10:24:36'),
	(4, 'delete-role', 'Delete Role', 'Delete Role', 1, '2018-06-06 10:24:36', '2018-06-06 10:24:36'),
	(5, 'read-permission', 'Read Permission', 'Read Permission', 1, '2018-06-06 10:24:36', '2018-06-06 10:24:36'),
	(6, 'update-permission', 'Update Permission', 'Update Permission', 1, '2018-06-06 10:24:36', '2018-06-06 10:24:36'),
	(7, 'delete-permission', 'Delete Permission', 'Delete Permission', 1, '2018-06-06 10:24:36', '2018-07-02 05:29:53'),
	(8, 'create-permission', 'Create Permission', 'Create permission', 1, '2018-06-06 10:24:36', '2018-06-06 10:24:36'),
	(9, 'create-pemasangan-baru', 'Membuat Data Pemasangan Baru', 'Membuat data pemasangan baru', 1, '2018-06-06 10:24:36', '2018-06-06 10:24:36'),
	(10, 'delete-pemasangan-baru', 'Menghapus Data Pemasangan Baru', 'Menghapus data Pemasangan Baru', 1, '2018-06-06 10:24:36', '2018-06-06 10:24:36'),
	(11, 'lihat-pemasangan-baru', 'Melihat Data Pemasangan Baru', 'Melihat data pemasangan baru', 1, '2018-07-02 10:24:36', '2018-07-02 10:24:36'),
	(12, 'update-pemasangan-baru', 'Mengubah Data Pemasangan Baru', 'Mengubah data pemasangan baru', 1, '2018-07-02 10:24:36', '2018-07-02 10:24:36'),
	(13, 'approve-pemasangan-baru', 'Menyetujui Pemasangan Baru', 'Menyetujui Pemasangan Baru', 1, '2018-07-02 10:24:36', '2018-07-02 10:24:36'),
	(14, 'approve-rab', 'Menyetujui RAB', 'Menyetujui RAB', 1, '2018-07-02 10:24:36', '2018-07-02 10:24:36'),
	(15, 'lihat-survey', 'Melihat Data Survei', 'Melihat Data Survei', 1, '2018-07-02 15:26:26', '2018-07-02 15:26:28'),
	(16, 'lihat-rab', 'Melihat Data RAB', 'Melihat Data RAB', 1, '2018-07-02 15:26:27', '2018-07-02 15:26:29'),
	(17, 'update-survey', 'Mengubah Data Survei', 'Mengubah Data Survei', 1, '2018-07-02 15:43:21', '2018-07-02 15:43:21'),
	(18, 'lihat-semua-pb', 'Melihat Semua Data PB', 'Melihat Semua Data Pemasangan Baru yang masuk', 1, '2018-07-03 13:33:35', '2018-07-03 13:33:35'),
	(19, 'assign-petugas-pemasangan', 'Membuat SPK', 'Membuat dan menentukan petugas pemasangan', 1, '2018-07-20 10:11:14', '2018-07-20 10:11:15'),
	(20, 'lihat-form-pemasangan', 'Melihat Form Pemasangan', 'Melihat Form Pemasangan', 1, '2018-07-20 10:15:04', '2018-07-20 10:15:04'),
	(21, 'edit-form-pemasangan', 'Mengedit Form Pemasangan', 'Mengedit Fom Pemasangan', 1, '2018-07-20 10:15:06', '2018-07-20 10:15:06'),
	(22, 'lihat-spk-pemasangan', 'Melihat Daftar SPK', 'Melihat Daftar SPK', 1, '2018-07-20 10:15:07', '2018-07-20 10:15:07'),
	(23, 'acc-form-pemasangan', 'Menandatangan Form Pemasangan', 'Menandatangan Form Pemasangan', 1, '2018-07-20 10:59:48', '2018-07-20 10:59:48'),
	(24, 'manage-pin', 'Manajemen Pin', 'Memperoleh dan mengganti pin', 1, '2018-07-23 13:38:04', '2018-07-23 13:38:04');

-- Dumping structure for table pdam_web.permission_role
CREATE TABLE IF NOT EXISTS `permission_role` (
  `permission_id` int(10) unsigned NOT NULL,
  `role_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `permission_role_role_id_foreign` (`role_id`),
  CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pdam_web.permission_role: ~59 rows (approximately)
DELETE FROM `permission_role`;
INSERT INTO `permission_role` (`permission_id`, `role_id`) VALUES
	(1, 1),
	(2, 1),
	(3, 1),
	(4, 1),
	(5, 1),
	(6, 1),
	(7, 1),
	(8, 1),
	(9, 1),
	(10, 1),
	(11, 1),
	(12, 1),
	(13, 1),
	(14, 1),
	(15, 1),
	(16, 1),
	(17, 1),
	(18, 1),
	(19, 1),
	(20, 1),
	(21, 1),
	(22, 1),
	(23, 1),
	(9, 2),
	(10, 2),
	(11, 2),
	(12, 2),
	(9, 3),
	(10, 3),
	(11, 3),
	(12, 3),
	(13, 3),
	(18, 3),
	(14, 5),
	(15, 5),
	(16, 5),
	(17, 5),
	(24, 5),
	(14, 6),
	(15, 6),
	(16, 6),
	(17, 6),
	(24, 6),
	(19, 7),
	(20, 7),
	(21, 7),
	(22, 7),
	(23, 7),
	(24, 7),
	(12, 9),
	(15, 9),
	(16, 9),
	(20, 10),
	(21, 10),
	(22, 10),
	(19, 11),
	(20, 11),
	(23, 11),
	(24, 11);

-- Dumping structure for table pdam_web.permission_user
CREATE TABLE IF NOT EXISTS `permission_user` (
  `permission_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `user_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`user_id`,`permission_id`,`user_type`),
  KEY `permission_user_permission_id_foreign` (`permission_id`),
  CONSTRAINT `permission_user_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pdam_web.permission_user: ~0 rows (approximately)
DELETE FROM `permission_user`;

-- Dumping structure for table pdam_web.petugas_pemasangan
CREATE TABLE IF NOT EXISTS `petugas_pemasangan` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kode_petugas` char(5) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `kode_pengawas` char(5) DEFAULT NULL,
  `nip` char(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table pdam_web.petugas_pemasangan: ~3 rows (approximately)
DELETE FROM `petugas_pemasangan`;
INSERT INTO `petugas_pemasangan` (`id`, `kode_petugas`, `user_id`, `kode_pengawas`, `nip`, `created_at`, `updated_at`) VALUES
	(6, 'B47', 143, NULL, '1.06.01455', '2018-08-01 09:19:35', '2018-08-01 09:25:56'),
	(7, 'B45', 144, NULL, '1.06.01455', '2018-08-01 09:25:09', '2018-08-01 09:25:31'),
	(8, NULL, 145, 'B02', '1.82.00471', '2018-08-02 20:26:31', '2018-08-02 20:26:31');

-- Dumping structure for table pdam_web.roles
CREATE TABLE IF NOT EXISTS `roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `built_in` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_unique` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pdam_web.roles: ~9 rows (approximately)
DELETE FROM `roles`;
INSERT INTO `roles` (`id`, `name`, `display_name`, `description`, `built_in`, `created_at`, `updated_at`) VALUES
	(1, 'super-admin', 'Super Admin', 'Super Admin', 1, '2018-06-06 10:24:36', '2018-06-06 10:24:36'),
	(2, 'pengguna', 'Pengguna', 'End-user, pengguna yang mendaftar via web', 1, '2018-07-02 05:56:09', '2018-07-02 05:56:09'),
	(3, 'p2k', 'P2K', 'Petugas P2K', 1, '2018-07-02 05:56:44', '2018-07-02 05:56:44'),
	(5, 'spv-pjsr', 'SPV PJSR', 'Kasie Divisi PJSR', 1, '2018-07-02 05:57:57', '2018-07-24 09:00:37'),
	(6, 'manager-pjsr', 'Manager PJSR', 'Manager PJSR', 1, '2018-07-02 05:58:39', '2018-07-24 12:57:55'),
	(7, 'spv-ptjsr', 'Pengawas - PTJSR', 'Petugas Pengawas PTJSR, Di bawah Manager', 1, '2018-07-02 05:59:10', '2018-07-25 05:48:26'),
	(9, 'surveyor', 'Surveyor', 'Surveyor', 1, '2018-07-02 09:04:43', '2018-07-02 09:04:43'),
	(10, 'pegawai-ptjsr', 'Petugas Pemasangan', 'petugas pemasangan ptjsr', 1, '2018-07-20 03:08:01', '2018-07-25 05:41:20'),
	(11, 'manager-ptjsr', 'Manager PTJSR', 'Admin Ptjsr', 1, '2018-07-20 03:16:18', '2018-07-25 05:46:03');

-- Dumping structure for table pdam_web.role_user
CREATE TABLE IF NOT EXISTS `role_user` (
  `role_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `user_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`user_id`,`role_id`,`user_type`),
  KEY `role_user_role_id_foreign` (`role_id`),
  CONSTRAINT `role_user_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pdam_web.role_user: ~67 rows (approximately)
DELETE FROM `role_user`;
INSERT INTO `role_user` (`role_id`, `user_id`, `user_type`) VALUES
	(1, 1, 'App\\User'),
	(2, 2, 'App\\User'),
	(2, 3, 'App\\User'),
	(2, 4, 'App\\User'),
	(2, 132, 'App\\User'),
	(2, 133, 'App\\User'),
	(2, 146, 'App\\User'),
	(2, 147, 'App\\User'),
	(2, 148, 'App\\User'),
	(2, 149, 'App\\User'),
	(2, 150, 'App\\User'),
	(2, 151, 'App\\User'),
	(2, 152, 'App\\User'),
	(2, 153, 'App\\User'),
	(2, 154, 'App\\User'),
	(3, 129, 'App\\User'),
	(5, 143, 'App\\User'),
	(6, 1, 'App\\User'),
	(6, 147, 'App\\User'),
	(7, 145, 'App\\User'),
	(9, 5, 'App\\User'),
	(9, 89, 'App\\User'),
	(9, 90, 'App\\User'),
	(9, 91, 'App\\User'),
	(9, 92, 'App\\User'),
	(9, 93, 'App\\User'),
	(9, 94, 'App\\User'),
	(9, 95, 'App\\User'),
	(9, 96, 'App\\User'),
	(9, 97, 'App\\User'),
	(9, 98, 'App\\User'),
	(9, 99, 'App\\User'),
	(9, 100, 'App\\User'),
	(9, 101, 'App\\User'),
	(9, 102, 'App\\User'),
	(9, 103, 'App\\User'),
	(9, 104, 'App\\User'),
	(9, 105, 'App\\User'),
	(9, 106, 'App\\User'),
	(9, 107, 'App\\User'),
	(9, 108, 'App\\User'),
	(9, 109, 'App\\User'),
	(9, 110, 'App\\User'),
	(9, 111, 'App\\User'),
	(9, 112, 'App\\User'),
	(9, 113, 'App\\User'),
	(9, 114, 'App\\User'),
	(9, 115, 'App\\User'),
	(9, 116, 'App\\User'),
	(9, 117, 'App\\User'),
	(9, 118, 'App\\User'),
	(9, 119, 'App\\User'),
	(9, 120, 'App\\User'),
	(9, 121, 'App\\User'),
	(9, 122, 'App\\User'),
	(9, 123, 'App\\User'),
	(9, 124, 'App\\User'),
	(9, 125, 'App\\User'),
	(9, 126, 'App\\User'),
	(9, 127, 'App\\User'),
	(9, 128, 'App\\User'),
	(10, 4, 'App\\User'),
	(10, 134, 'App\\User'),
	(10, 143, 'App\\User'),
	(10, 144, 'App\\User'),
	(11, 1, 'App\\User'),
	(11, 146, 'App\\User');

-- Dumping structure for table pdam_web.spk_pemasangan
CREATE TABLE IF NOT EXISTS `spk_pemasangan` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `no_spk` varchar(50) DEFAULT NULL,
  `no_material` varchar(50) DEFAULT NULL,
  `kode_petugas` varchar(50) DEFAULT NULL,
  `kode_pengawas` varchar(50) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table pdam_web.spk_pemasangan: ~16 rows (approximately)
DELETE FROM `spk_pemasangan`;
INSERT INTO `spk_pemasangan` (`id`, `no_spk`, `no_material`, `kode_petugas`, `kode_pengawas`, `created_at`, `updated_at`) VALUES
	(7, 'B20180800001', NULL, 'B45', NULL, '2018-08-02 09:48:34', '2018-08-02 09:48:34'),
	(8, 'B20180800002', NULL, 'B45', NULL, '2018-08-02 09:48:46', '2018-08-02 09:48:46'),
	(16, 'B20180800003', NULL, 'B47', 'B02', '2018-08-04 07:46:51', '2018-08-04 07:46:51'),
	(17, 'B20180800003', NULL, 'B47', 'B02', '2018-08-04 07:47:50', '2018-08-04 07:47:50'),
	(20, 'B20180800003', 'BPB201800001', 'B45', 'B02', '2018-08-04 07:52:29', '2018-08-04 07:52:29'),
	(21, 'T20180800001', 'TPB201800001', 'B47', 'B02', '2018-08-04 07:56:25', '2018-08-04 07:56:25'),
	(22, 'T20180800002', 'TPB201800001', 'B47', 'B02', '2018-08-04 07:56:59', '2018-08-04 07:56:59'),
	(23, 'T20180800003', 'TPB201800002', 'B47', 'B02', '2018-08-04 08:02:32', '2018-08-04 08:02:32'),
	(24, 'B20180800004', 'BPB201800002', 'B45', 'B02', '2018-08-04 10:19:40', '2018-08-04 10:19:40'),
	(25, 'B20180800005', 'BPB201800003', 'B45', 'B02', '2018-08-04 10:21:22', '2018-08-04 10:21:22'),
	(26, 'B20180800006', 'BPB201800004', 'B45', 'B02', '2018-08-04 10:21:40', '2018-08-04 10:21:40'),
	(27, 'B20180800007', 'BPB201800005', 'B45', 'B02', '2018-08-04 10:22:23', '2018-08-04 10:22:23'),
	(28, 'T20180800004', 'TPB201800003', 'B45', 'B02', '2018-08-04 10:23:22', '2018-08-04 10:23:22'),
	(29, 'T20180800005', 'TPB201800004', 'B45', 'B02', '2018-08-04 10:23:41', '2018-08-04 10:23:41'),
	(30, 'T20180800006', 'TPB201800005', 'B45', 'B02', '2018-08-04 10:24:00', '2018-08-04 10:24:00'),
	(31, 'T20180800007', 'TPB201800006', 'B47', 'B02', '2018-08-10 08:13:33', '2018-08-10 08:13:33');

-- Dumping structure for table pdam_web.surveyor
CREATE TABLE IF NOT EXISTS `surveyor` (
  `kd_ptgsurvey` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(10) unsigned NOT NULL DEFAULT '5',
  `nip` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `firebase_token` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  UNIQUE KEY `surveyor_kd_ptgsurvey_unique` (`kd_ptgsurvey`),
  UNIQUE KEY `surveyor_nip_unique` (`nip`),
  KEY `surveyor_user_id_index` (`user_id`),
  KEY `surveyor_firebase_token_index` (`firebase_token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pdam_web.surveyor: ~40 rows (approximately)
DELETE FROM `surveyor`;
INSERT INTO `surveyor` (`kd_ptgsurvey`, `user_id`, `nip`, `firebase_token`) VALUES
	('201', 89, '1.83.00561          ', '1'),
	('203', 90, '1.82.00388          ', '1'),
	('207', 91, '1.84.00620          ', '1'),
	('208', 92, '1.88.00726          ', '1'),
	('209', 93, '510 112 663         ', '1'),
	('210', 94, '1.06.01425          ', '1'),
	('211', 95, '1.06.01430          ', '1'),
	('213', 96, '1.85.00629          ', '1'),
	('214', 97, '1.79.00186          ', '1'),
	('215', 98, '1.76.00066          ', '1'),
	('218', 99, '1.83.00563          ', '1'),
	('220', 100, '510 094 780         ', '1'),
	('221', 101, '1.91.00790          ', '1'),
	('222', 102, '1.88.00837          ', '1'),
	('223', 103, '1.06.01379          ', '1'),
	('224', 104, '1.87.00664          ', '1'),
	('228', 105, '1.06.01353          ', '1'),
	('229', 106, '1.82.00379          ', '1'),
	('230', 107, '1.06.01402          ', '1'),
	('231', 108, '1.06.01397          ', '1'),
	('232', 109, '1.06.01443          ', '1'),
	('233', 110, '1.06.01423          ', '1'),
	('234', 111, '1.06.01421          ', '1'),
	('235', 112, '1.06.01449          ', '1'),
	('236', 113, '1.06.01409          ', '1'),
	('237', 114, '1.06.01349          ', '1'),
	('238', 115, '1.06.01355          ', '1'),
	('239', 116, '1.06.01429          ', '1'),
	('240', 117, '1.06.01444          ', '1'),
	('241', 118, '1.14.01622          ', '1'),
	('242', 119, '1.14.01636          ', '1'),
	('243', 120, 'T. 01779            ', '1'),
	('244', 121, '1.17.01737          ', '1'),
	('245', 122, 'T. 01664            ', '1'),
	('246', 123, '1.17.01666          ', '1'),
	('247', 124, '1.17.01675          ', '1'),
	('248', 125, 'T. 01733            ', '1'),
	('249', 126, 'T. 01814            ', '1'),
	('250', 128, 'T. 01710            ', '1'),
	('251', 129, '1.17.01697          ', '1');

-- Dumping structure for table pdam_web.survey_perencanaan
CREATE TABLE IF NOT EXISTS `survey_perencanaan` (
  `id_survey` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `no_pendaftaran` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tanggal_daftar` date DEFAULT NULL,
  `nama_pemohon` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jenis_pb` int(10) unsigned DEFAULT NULL COMMENT '0 =rumah tangga 1= non rumah tangga',
  `persil_jalan` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `persil_gang` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `persil_nomor` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `persil_tambahan` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `persil_keterangan` text COLLATE utf8mb4_unicode_ci,
  `alamat_pemohon` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nomor_subzona` int(10) unsigned NOT NULL DEFAULT '0',
  `kode_petugas` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `kelurahan` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kecamatan` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `latitude` double(11,8) DEFAULT NULL,
  `longitude` double(11,8) DEFAULT NULL,
  `tanggal_survey` date DEFAULT NULL,
  `tanggal_pembuatan_rab` date DEFAULT NULL,
  `luas_tanah` int(10) unsigned DEFAULT NULL,
  `lebar_persil` int(10) unsigned DEFAULT NULL,
  `hasil_survey` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_bermasalah` int(10) unsigned DEFAULT NULL,
  `keterangan_survey` text COLLATE utf8mb4_unicode_ci,
  `paket_material` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `daya_listrik` int(11) DEFAULT NULL,
  `njop` bigint(20) unsigned DEFAULT NULL,
  `lebar_jalan` int(10) unsigned DEFAULT NULL,
  `luas_bangunan` int(10) unsigned DEFAULT NULL,
  `kode_tarif` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kode_guna_persil` int(10) unsigned DEFAULT NULL,
  `tahun_pemasangan_pipa_tersier` int(10) unsigned DEFAULT NULL,
  `status_pipa` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '''pemkot'',''p3sca'',''pdam''',
  `jumlah_jalur_pipa` int(10) unsigned DEFAULT NULL,
  `kode_jenis_pipa` int(10) unsigned DEFAULT NULL,
  `kode_letak_pipa` int(10) unsigned DEFAULT NULL,
  `kode_jenis_pekerjaan` int(11) DEFAULT NULL,
  `is_prefinancing` int(11) DEFAULT NULL,
  `has_surveyed` int(10) unsigned DEFAULT NULL,
  `is_acc` int(11) NOT NULL DEFAULT '0',
  `is_rejected` int(11) NOT NULL DEFAULT '0',
  `bea_pasang` int(11) NOT NULL DEFAULT '0',
  `bea_bsi` int(11) NOT NULL DEFAULT '0',
  `bea_registrasi` int(11) NOT NULL DEFAULT '0',
  `total_biaya` int(10) unsigned DEFAULT '0',
  `file_foto_rumah` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_foto_rumah2` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_denah_rumah` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_acc_spv` int(11) DEFAULT '0',
  `is_acc_mng` int(11) DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_survey`),
  KEY `survey_perencanaan_nomor_subzona_index` (`nomor_subzona`),
  KEY `survey_perencanaan_kode_petugas_index` (`kode_petugas`),
  CONSTRAINT `survey_perencanaan_nomor_subzona_foreign` FOREIGN KEY (`nomor_subzona`) REFERENCES `zona` (`no_subzona`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pdam_web.survey_perencanaan: ~8 rows (approximately)
DELETE FROM `survey_perencanaan`;
INSERT INTO `survey_perencanaan` (`id_survey`, `no_pendaftaran`, `tanggal_daftar`, `nama_pemohon`, `jenis_pb`, `persil_jalan`, `persil_gang`, `persil_nomor`, `persil_tambahan`, `persil_keterangan`, `alamat_pemohon`, `nomor_subzona`, `kode_petugas`, `kelurahan`, `kecamatan`, `latitude`, `longitude`, `tanggal_survey`, `tanggal_pembuatan_rab`, `luas_tanah`, `lebar_persil`, `hasil_survey`, `is_bermasalah`, `keterangan_survey`, `paket_material`, `daya_listrik`, `njop`, `lebar_jalan`, `luas_bangunan`, `kode_tarif`, `kode_guna_persil`, `tahun_pemasangan_pipa_tersier`, `status_pipa`, `jumlah_jalur_pipa`, `kode_jenis_pipa`, `kode_letak_pipa`, `kode_jenis_pekerjaan`, `is_prefinancing`, `has_surveyed`, `is_acc`, `is_rejected`, `bea_pasang`, `bea_bsi`, `bea_registrasi`, `total_biaya`, `file_foto_rumah`, `file_foto_rumah2`, `file_denah_rumah`, `is_acc_spv`, `is_acc_mng`, `created_at`, `updated_at`) VALUES
	(41, '78', '2018-07-06', 'dev-diganti', 0, 'PACAR KEMBANG BARU', 'Makam', '80', NULL, 'sisp', 'Jalan Kali Kepunton no.4', 219, '242', 'Airlangga', 'Asem Rowo', -7.25082332, 112.76894208, '2018-08-09', NULL, 200, 355, '22', NULL, NULL, 'B1', 2200, 600000000, 363, 200, '4A', NULL, 2010, 'Pemkot', 2, 2, 1, 1, NULL, 1, 0, 0, 0, 0, 0, NULL, 'img_file_foto_rumah/dev-diganti_20180809161629_img_file_foto_rumah.jpg', 'img_file_foto_rumah2/dev-diganti_20180809161629_img_file_foto_rumah2.jpg', 'img_file_denah_rumah/dev-diganti_20180809161629_img_file_denah_rumah.jpg', 0, 0, '2018-07-06 08:34:14', '2018-08-09 16:16:32'),
	(42, '79', '2018-07-07', 'Joshua Kevin', 1, 'Keputih', 'Makam', '80', NULL, NULL, 'Jalan Kali Kepunton no.4', 222, '210', 'Keputih', 'Sukolilo', -7.28688526, 112.80360413, NULL, NULL, 150, 200, NULL, NULL, NULL, NULL, 900, 12312515, NULL, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, 0, 0, '2018-07-07 18:13:39', '2018-08-10 09:53:52'),
	(43, '80', '2018-07-08', 'asdasd', 0, 'Keputih', 'Makam', '18', NULL, NULL, 'Jalan Kali Kepunton no.4', 543, '242', 'Keputih', 'Sukolilo', -7.25044500, 112.76884500, '2018-07-26', '2018-07-25', 450, 450, '97', 0, NULL, 'A', 2200, 200000000, 6, 190, '4B.2', 2, 50, 'pdam', 1, 2, 2, 3, 1, 1, 1, 0, 1570000, 0, 4400, 1731840, 'img_file_foto_rumah/asdasd_20180718100931_img_file_foto_rumah.jpg', 'img_file_foto_rumah2/asdasd_20180718100931_img_file_foto_rumah2.jpg', 'img_file_denah_rumah/asdasd_20180718100931_img_file_denah_rumah.jpg', 1, 1, '2018-07-08 02:36:31', '2018-07-26 10:11:28'),
	(44, '81', '2018-07-10', 'Arif Rahman', 0, 'Keputih', 'Makam', '18', NULL, NULL, 'Jl Pandugo PV 16', 534, '242', 'Keputih', 'Sukolilo', NULL, NULL, '2018-07-28', '2018-07-27', 450, 450, '97', NULL, NULL, 'A', 2200, 200000000, 6, 190, '4B.2', 2, 50, 'pdam', 1, 2, 2, 3, NULL, 1, 1, 0, 1570000, 0, 4400, 1731840, NULL, NULL, NULL, 1, 1, '2018-07-24 06:52:48', '2018-08-10 06:26:48'),
	(45, '77', '2018-07-06', 'Chusnul Chotimah', NULL, 'Arif Rahman Hakim', 'Makam', '59', NULL, NULL, 'Jl Pandugo PV 16', 542, '214', 'Airlangga', 'Pabean cantikan', -7.25339174, 112.65030670, NULL, NULL, 150, 10, NULL, NULL, NULL, NULL, 0, 12312000, NULL, 90, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, 0, 0, '2018-07-25 11:05:28', '2018-08-10 09:53:52'),
	(46, '72', '2018-07-04', 'Jonathan Rachmadi', NULL, 'Keputih', 'Makam', '80', NULL, NULL, 'Jalan Kali Kepunton no.4', 219, '221', NULL, NULL, -7.25044489, 112.76884460, NULL, NULL, 150, 200, NULL, NULL, NULL, NULL, 900, 12312000, NULL, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, 0, 0, '2018-07-27 06:52:36', '2018-08-10 09:53:52'),
	(47, '82', '2018-08-04', 'Muhammad Farzan Ar Rayyan', 0, 'GUNUNG ANYAR ASRI', '1', '1', '1', 'ga ada', 'Jl Gunung Anyar 23', 117, '242', 'Gunung Anyar', 'Gunung Anyar', -7.33395505, 112.79746503, '2018-08-04', '2018-08-04', 200, 10, '6', NULL, NULL, 'B1', 2200, 650000000, 20, 200, '4B.2', NULL, 2012, 'PDAM', 1, 4, 1, 7, NULL, 1, 1, 0, 1570000, 0, 4400, 1731840, 'img_file_foto_rumah/Muhammad Farzan Ar Rayyan_20180804163341_img_file_foto_rumah.jpg', 'img_file_foto_rumah2/Muhammad Farzan Ar Rayyan_20180804163341_img_file_foto_rumah2.jpg', 'img_file_denah_rumah/Muhammad Farzan Ar Rayyan_20180804163341_img_file_denah_rumah.jpg', 1, 1, '2018-08-04 16:24:51', '2018-08-04 17:00:52'),
	(48, '83', '2018-08-10', 'Amier', 0, 'LAGUNA KEPUTIH', 'Makam', '80', '0', 'depan gang', 'penjaringan asri pe 16', 228, '242', 'Keputih', 'Sukolilo', -7.24622681, 112.77348978, '2018-08-10', NULL, 25, 25, '13', NULL, NULL, 'B0', 900, 6788999999, 25, 25, '4B.2', NULL, 2019, 'PDAM', 2, 4, 2, 5, NULL, 1, 0, 0, 0, 0, 0, 0, 'img_file_foto_rumah/Amier_20180810075701_img_file_foto_rumah.jpg', 'img_file_foto_rumah2/Amier_20180810075701_img_file_foto_rumah2.jpg', 'img_file_denah_rumah/Amier_20180810075701_img_file_denah_rumah.jpg', 0, 0, '2018-08-10 07:51:41', '2018-08-10 07:57:06');

-- Dumping structure for table pdam_web.users
CREATE TABLE IF NOT EXISTS `users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `full_name` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_number` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pin` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `photo` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `built_in` tinyint(1) NOT NULL DEFAULT '0',
  `nip` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `latitude` double(10,7) DEFAULT NULL,
  `longitude` double(10,7) DEFAULT NULL,
  `firebase_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_username_unique` (`username`),
  UNIQUE KEY `users_email_unique` (`email`),
  UNIQUE KEY `users_phone_number_unique` (`phone_number`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pdam_web.users: ~61 rows (approximately)
DELETE FROM `users`;
INSERT INTO `users` (`id`, `username`, `full_name`, `email`, `address`, `phone_number`, `password`, `pin`, `photo`, `active`, `built_in`, `nip`, `latitude`, `longitude`, `firebase_token`, `remember_token`, `created_at`, `updated_at`) VALUES
	(1, 'admin', 'Administrator', 'admin@artcak.com', NULL, '0817777', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', '$2y$10$fZlIIBjZvWa/Dx9wUAJNz.M2Y6U2wvFv3gwWjsKsBrvnBZXQfLKD6', NULL, 1, 1, '1.98.01241', NULL, NULL, NULL, 'SXRPDDYuXk8oPhggi4KLnT8DC1Y3KV4axF5ph15QmnP9VTqNIFu3igb6240b', '2018-06-06 10:24:38', '2018-06-06 10:24:38'),
	(2, 'ownser', 'Owner', 'owner@artcak.com', NULL, '0818888', '$2y$10$mG/PA7w6R1Ipd0ug0cQM1OcgzYLaHsUCIEuHCZumEFCS5I.vWHyPC', NULL, NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, '2018-06-06 10:24:39', '2018-06-06 10:24:39'),
	(3, 'contributor1', 'Contributor 1', 'contributor1@artcak.com', NULL, '0815555', '$2y$10$XAwR3jgFL0.swWgGqjjAqO.P9fD9gl6uaV/kbitDnhfXihFOg56g.', NULL, NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, '2018-06-06 10:24:39', '2018-06-06 10:24:39'),
	(4, 'user', 'user', 'user@artcak.com', NULL, '0816666', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 1, 1, '1.06.01455', NULL, NULL, NULL, 'StvWgxLDcJrnLgoukXHaiEpYZevPftPwT00y0fQ7X2zNeD8fDiH60WVwRTbn', '2018-06-07 03:50:46', '2018-08-01 08:47:20'),
	(89, 'perencanaan_201', 'Mellany Junono                ', 'surveyor201@pdam.go.id', NULL, '0811201', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, '1.83.00561          ', NULL, NULL, NULL, NULL, '2018-07-04 07:46:59', '2018-07-04 07:46:59'),
	(90, 'perencanaan_203', 'S u k a m t o                 ', 'surveyor203@pdam.go.id', NULL, '0811203', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, '1.82.00388          ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:00', '2018-07-04 07:47:00'),
	(91, 'perencanaan_207', 'S y a m s u r i               ', 'surveyor207@pdam.go.id', NULL, '0811207', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, '1.84.00620          ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:00', '2018-07-04 07:47:00'),
	(92, 'perencanaan_208', 'U s n a d i                   ', 'surveyor208@pdam.go.id', NULL, '0811208', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, '1.88.00726          ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:00', '2018-07-04 07:47:00'),
	(93, 'perencanaan_209', 'Oni Sahroni                   ', 'surveyor209@pdam.go.id', NULL, '0811209', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, '510 112 663         ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:01', '2018-07-04 07:47:01'),
	(94, 'perencanaan_210', 'Khamim Sulton H.              ', 'surveyor210@pdam.go.id', NULL, '0811210', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, '1.06.01425          ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:01', '2018-07-04 07:47:01'),
	(95, 'perencanaan_211', 'M. Irfan Fahlefi              ', 'surveyor211@pdam.go.id', NULL, '0811211', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, '1.06.01430          ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:02', '2018-07-04 07:47:02'),
	(96, 'perencanaan_213', 'Sumilan BE                    ', 'surveyor213@pdam.go.id', NULL, '0811213', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, '1.85.00629          ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:02', '2018-07-04 07:47:02'),
	(97, 'perencanaan_214', 'Edy Priyono                   ', 'surveyor214@pdam.go.id', NULL, '0811214', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, '1.79.00186          ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:02', '2018-07-04 07:47:02'),
	(98, 'perencanaan_215', 'Moch. Farchan                 ', 'surveyor215@pdam.go.id', NULL, '0811215', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, '1.76.00066          ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:02', '2018-07-04 07:47:02'),
	(99, 'perencanaan_218', 'S u g i a n t o               ', 'surveyor218@pdam.go.id', NULL, '0811218', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, '1.83.00563          ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:03', '2018-07-04 07:47:03'),
	(100, 'perencanaan_220', 'Budi Waluyo                   ', 'surveyor220@pdam.go.id', NULL, '0811220', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, '510094780         ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:03', '2018-07-04 07:47:03'),
	(101, 'perencanaan_221', 'S u s a n t o  BA.E.          ', 'surveyor221@pdam.go.id', NULL, '0811221', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, '1.91.00790          ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:04', '2018-07-04 07:47:04'),
	(102, 'perencanaan_222', 'Rachmad Bahagia               ', 'surveyor222@pdam.go.id', NULL, '0811222', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, '1.88.00837          ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:04', '2018-07-04 07:47:04'),
	(103, 'perencanaan_223', 'Trisna Hadi                   ', 'surveyor223@pdam.go.id', NULL, '0811223', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, '1.06.01379          ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:04', '2018-07-04 07:47:04'),
	(104, 'perencanaan_224', 'K a r m u d j i               ', 'surveyor224@pdam.go.id', NULL, '0811224', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, '1.87.00664          ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:05', '2018-07-04 07:47:05'),
	(105, 'perencanaan_228', 'Imansyah N.                   ', 'surveyor228@pdam.go.id', NULL, '0811228', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, '1.06.01353          ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:05', '2018-07-04 07:47:05'),
	(106, 'perencanaan_229', 'S u d i o n o                 ', 'surveyor229@pdam.go.id', NULL, '0811229', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, '1.82.00379          ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:05', '2018-07-04 07:47:05'),
	(107, 'perencanaan_230', 'Andi Eko Purwono              ', 'surveyor230@pdam.go.id', NULL, '0811230', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, '1.06.01402          ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:06', '2018-07-04 07:47:06'),
	(108, 'perencanaan_231', 'Agus Martono                  ', 'surveyor231@pdam.go.id', NULL, '0811231', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, '1.06.01397          ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:06', '2018-07-04 07:47:06'),
	(109, 'perencanaan_232', 'Teguh Susijono                ', 'surveyor232@pdam.go.id', NULL, '0811232', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, '1.06.01443          ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:06', '2018-07-04 07:47:06'),
	(110, 'perencanaan_233', 'Irwan Hermana U.              ', 'surveyor233@pdam.go.id', NULL, '0811233', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, '1.06.01423          ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:07', '2018-07-04 07:47:07'),
	(111, 'perencanaan_234', 'Forneo  H.S.                  ', 'surveyor234@pdam.go.id', NULL, '0811234', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, '1.06.01421          ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:07', '2018-07-04 07:47:07'),
	(112, 'perencanaan_235', 'Zupri                         ', 'surveyor235@pdam.go.id', NULL, '0811235', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, '1.06.01449          ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:07', '2018-07-04 07:47:07'),
	(113, 'perencanaan_236', 'Bambang Tri W.                ', 'surveyor236@pdam.go.id', NULL, '0811236', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, '1.06.01409          ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:08', '2018-07-04 07:47:08'),
	(114, 'perencanaan_237', 'Eko Saputra                   ', 'surveyor237@pdam.go.id', NULL, '0811237', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, '1.06.01349          ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:08', '2018-07-04 07:47:08'),
	(115, 'perencanaan_238', 'Irawan Sudarsono              ', 'surveyor238@pdam.go.id', NULL, '0811238', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, '1.06.01355          ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:09', '2018-07-04 07:47:09'),
	(116, 'perencanaan_239', 'Kuswara                       ', 'surveyor239@pdam.go.id', NULL, '0811239', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, '1.06.01429          ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:09', '2018-07-04 07:47:09'),
	(117, 'perencanaan_240', 'Teguh Wiyono                  ', 'surveyor240@pdam.go.id', NULL, '0811240', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, '1.06.01444          ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:10', '2018-07-04 07:47:10'),
	(118, 'perencanaan_241', 'M. ABDUS SOMAD MUSLIM, AMD    ', 'surveyor241@pdam.go.id', NULL, '0811241', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, '1.14.01622          ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:10', '2018-07-04 07:47:10'),
	(119, 'perencanaan_242', 'AGUS HARYADI                  ', 'surveyor242@pdam.go.id', NULL, '0811242', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, '1.14.01636          ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:11', '2018-07-04 07:47:11'),
	(120, 'perencanaan_243', 'Joko Indah Permadi            ', 'surveyor243@pdam.go.id', NULL, '0811243', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, 'T. 01779            ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:11', '2018-07-04 07:47:11'),
	(121, 'perencanaan_244', 'Deny Eka Pratama              ', 'surveyor244@pdam.go.id', NULL, '0811244', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, '1.17.01737          ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:11', '2018-07-04 07:47:11'),
	(122, 'perencanaan_245', 'Angga Christian Hananta       ', 'surveyor245@pdam.go.id', NULL, '0811245', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, 'T. 01664            ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:12', '2018-07-04 07:47:12'),
	(123, 'perencanaan_246', 'Deni Kurniawati               ', 'surveyor246@pdam.go.id', NULL, '0811246', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, '1.17.01666          ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:12', '2018-07-04 07:47:12'),
	(124, 'perencanaan_247', 'Surios Ramisda                ', 'surveyor247@pdam.go.id', NULL, '0811247', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, '1.17.01675          ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:12', '2018-07-04 07:47:12'),
	(125, 'perencanaan_248', 'Danny Erwanto                 ', 'surveyor248@pdam.go.id', NULL, '0811248', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, 'T. 01733            ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:12', '2018-07-04 07:47:12'),
	(126, 'perencanaan_249', 'Nur Cholis Ikhsan             ', 'surveyor249@pdam.go.id', NULL, '0811249', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, 'T. 01814            ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:13', '2018-07-04 07:47:13'),
	(127, 'perencanaan_250', 'Ahmad Rais Setyo Laksono      ', 'surveyor250@pdam.go.id', NULL, '0811250', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, 'T. 01710            ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:13', '2018-07-04 07:47:13'),
	(128, 'perencanaan_251', 'Achmad Hardianas              ', 'surveyor251@pdam.go.id', NULL, '0811251', '$2y$12$ecn2GdHoiMCP8DdxKT4H1OSZRuoC431uqOblexR7NGqT05XWVqQUO', NULL, NULL, 0, 0, '1.17.01697          ', NULL, NULL, NULL, NULL, '2018-07-04 07:47:13', '2018-07-04 07:47:13'),
	(129, 'jonop2k', 'Jono Darmawan', 'jono.darmawan@gmail.com', 'Keputih', '08985365597', '$2y$10$FyL0ZveUEr5IbFUIpVO0gedu.7jrEV8q7H6N.hzVHUGhOvSKtBZlS', NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, '7kjoeWGP9vAcvGiGwK2MeqrKMpHiJ1HbQvDsvAm0lzwVabSdSmIKeBZzHR3C', '2018-07-04 18:57:11', '2018-07-04 18:57:11'),
	(130, 'Joshua Kevin', 'Joshua Kevin', 'jokevin.rachmadi@gmail.com', NULL, '089669100555', '$2y$10$nJtPgNO4GA8zy9GjKpx7GekwgZeYT2St2N4VL.HBWI9NPujsE5Jhi', NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, 'VhbS8LgQ0Hr3qCUuB8luuSd0JcVXNCOmV2vZ5WS5MqFshQ5YA1TCpviBQ8Cx', '2018-07-05 08:44:17', '2018-07-05 08:44:17'),
	(132, 'asdfasdfas', 'asdfasdfas', 'asdfasasdf@gmail.com', NULL, '01234321', '$2y$10$apLZbFgiEYbeyV8E5o6K6OislvJIuLqNSGfuHxK7pXi6eUHQP6/Sm', NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, '2018-07-08 02:28:25', '2018-07-08 02:28:25'),
	(133, 'enrico', 'enrico Jonathan', 'enrihartono@gmail.com', NULL, '09291120', '$2y$10$p5fD0ZTxHAXoe42fNGBYSOlRf.oAEIFYpYz2dJgz0usyA2fvEBGAy', NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, '2018-07-09 10:00:56', '2018-07-09 10:00:56'),
	(134, '1123098800', 'Hartono Hamka', 'hartono.hamka@pdam-sby.go.id', 'pendjaringan', '0818800', '$2y$10$7BFHgpT9ihf7AhTMh05Jg.isp9UMjGDSTAaBoC9EBT8WqtTftmQfK', NULL, NULL, 1, 0, '1123098800', NULL, NULL, NULL, NULL, '2018-07-20 03:19:02', '2018-07-20 03:19:02'),
	(143, '19801279', 'Joshua Kevin', 'pegawai19801279@pdam-sby.go.id', NULL, '081119801279', '$2y$10$x9khW8nQBUEho2KTY5rhSugJ..rjSfmARAuv43jia22OA4BncqshO', '$2y$10$fZlIIBjZvWa/Dx9wUAJNz.M2Y6U2wvFv3gwWjsKsBrvnBZXQfLKD6', NULL, 1, 0, '1.06.01455', NULL, NULL, NULL, '6jgkObDrMKLaNiWRaEDeI3C0P8irIWTHFT5swrQxcClqETvbvuhcmcuvKmQg', '2018-07-24 11:17:24', '2018-08-10 06:20:17'),
	(144, 'pemasangan1', 'Satuan Tugas Pemasangan', 'satgas.pemasangan@pdam-sby.go.id', 'satuan', '08123456', '$2y$10$3/wJ8qTryc0ocIPlOWuDuO5Be3R1zxaKdtQVhuY39iRMM.kt/Y4E.', NULL, NULL, 1, 0, '1.06.01455', NULL, NULL, NULL, 'rixJ6pc8McBvVDwHTJ0mm4PeHG8wV6mzQkL3DWZRbnSgZV9I3NMMMNoWhgV4', '2018-08-01 08:44:55', '2018-08-01 08:46:37'),
	(145, 'pemasangan2', 'Satuan Pengawas Pemasangan', 'pengawas.pemasangan@pdam-sby.go.id', 'satuan', '0888888', '$2y$10$bUgSL6AVlZnxhRXbZEf8luNWV68Ktf.2hHaI5DCYhIrF1qSzSU0ty', NULL, NULL, 1, 0, '1.82.00471', NULL, NULL, NULL, 'EZf1AhZOvTtQBrrfQJzVbiCk2EPup7O549r2zHS22txc6siNmqa38fq0DXYY', '2018-08-02 20:22:48', '2018-08-02 20:27:18'),
	(146, 'manajer1', 'manajer ptjsr', 'manajer@pdam-sby.go.id', 'pendjaringan', '08188001', '$2y$10$AjMe34RL2eP/MXQuG43xYeoBS96czOQxfjqe8QfXB9z42vAJ0RV9y', NULL, NULL, 1, 0, '1.06.01455', NULL, NULL, NULL, 'YFe40XOS6VFojyBPIGCFh7LAYhhldcSn5dIkHfzM2V7AZbhECd0gC1RmwzgT', '2018-08-04 12:24:09', '2018-08-04 12:27:11'),
	(147, 'manajer2', 'manajer pjsr', 'manajer2@pdam-sby.go.id', 'pendjaringan', '08188002', '$2y$10$kkrI8WSh2DxlXzB/ZDu9I.EPmiw/b7ofPes/IVpWznxu7DS6TZaBO', '$2y$10$fZlIIBjZvWa/Dx9wUAJNz.M2Y6U2wvFv3gwWjsKsBrvnBZXQfLKD6', NULL, 1, 0, '1.82.00471', NULL, NULL, NULL, 'eckbCmnidtNaFqsXdENXKnpM0R79klw6mwPWGVLC2r3LcCBVTNaKqoiKk86b', '2018-08-04 12:25:28', '2018-08-04 17:00:09'),
	(148, 'spvptjsr', 'SPV PTJSR', 'spv.ptjsr@pdam.sby.go.id', 'satuan', '08188003', '$2y$10$ckHxDJi5NZUKNCNrXBErnuGLpXcR4975ZNzRnd8KJHYrr0Hq1jPEG', NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, 'BJQ0GKcYiVOLrweWWLTLAdYsddULuHlCJxC2wcurB3XNnamboE4VN8UBCRPL', '2018-08-04 13:05:34', '2018-08-04 13:05:34'),
	(149, 'masyarakat', 'Iqbal Kurniawan', 'sembarang@gmail.com', NULL, '081233103652', '$2y$10$Cg04Zxsq314TjxmUojTS7O12Q9EdnS0mUn.yg2Hu3slzj4Lgguevu', NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, '5UTX1IFSoicMcjp0vxfvfjze7oRp9yALo99vQpDzmvI73X1inzhaMxV6ddFp', '2018-08-08 03:29:48', '2018-08-08 03:29:48'),
	(150, 'eeee', 'eeee e eeeeee', 'e@eco.com', NULL, '08828183', '$2y$10$89RK5xLd8jz4PKYssM1WOOL3nMNF2vhotOsuvPbJOG8/qWUv2UhwG', NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, '2018-08-09 17:22:23', '2018-08-09 17:22:23'),
	(151, 'radhit', 'Riska Adhita', 'risk.adhita@gmail.com', NULL, '081357391436', '$2y$10$AQa7oyPl2BDCyccQboXKZecC4dZhueoNclb4aDzdbutI8tHIECj4q', NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, '2018-08-09 19:31:09', '2018-08-09 19:31:09'),
	(152, 'painkiller', 'rafid zaidan', 'calderagriyadisain@gmail.com', NULL, '081259695371', '$2y$10$0G6U.y7E5hZtXhzkQboFhOlWUVN/Fb5UMCFA7/cnS7yZy0mR4nXqu', NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, '2018-08-10 02:16:04', '2018-08-10 02:16:04'),
	(153, 'amir', 'Amier', 'amier@pdam-sby.go.id', NULL, '08111119', '$2y$10$wM3s4NDzFaNDYu2B5bRfbOG1/wgLIuuk902R1mvKw.kpVbMaR3DJ.', NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, 'RVJ2QarYD2dMktlGZNz7WAJ5WCnOMhjRZb5yXDZEpW2bck9lZd0sAMGQbEsv', '2018-08-10 07:23:10', '2018-08-10 07:23:10'),
	(154, 'm.amir', 'Nasrul Amir', 'nasrul.amir@pdam-sby.go.id', NULL, '085100553023', '$2y$10$fS2hyG18.Xehs3QZ0PP0c.bZ/TpxdSjl2JbelZgNuV5/osyvDYjB.', NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, '2018-08-10 07:31:19', '2018-08-10 07:31:19');

-- Dumping structure for table pdam_web.zona
CREATE TABLE IF NOT EXISTS `zona` (
  `id_subzona` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `no_subzona` int(10) unsigned NOT NULL,
  `nama_subzona` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode_zona` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode_ply` int(10) unsigned NOT NULL,
  `nama_ply` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode_szp` int(10) unsigned NOT NULL,
  `nama_szp` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tekanan` double(8,2) NOT NULL,
  UNIQUE KEY `zona_id_subzona_unique` (`id_subzona`),
  UNIQUE KEY `zona_no_subzona_unique` (`no_subzona`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pdam_web.zona: ~148 rows (approximately)
DELETE FROM `zona`;
INSERT INTO `zona` (`id_subzona`, `no_subzona`, `nama_subzona`, `kode_zona`, `kode_ply`, `nama_ply`, `kode_szp`, `nama_szp`, `tekanan`) VALUES
	('SZ000', 0, 'SUBZONA 0', 'Z0', 8, 'Sumber Air Luar Kota', 2, 'Wonocolo', 0.00),
	('SZ101', 101, 'SUBZONA 101', 'Z1', 1, 'Ngagel I', 5, 'Wonokitri', 0.00),
	('SZ102', 102, 'SUBZONA 102', 'Z1', 8, 'Sumber Air Luar Kota', 6, 'Booster Pump SIER', 0.00),
	('SZ103', 103, 'SUBZONA 103', 'Z1', 1, 'Ngagel I', 1, '-', 0.00),
	('SZ104', 104, 'SUBZONA 104', 'Z1', 1, 'Ngagel I', 1, '-', 0.00),
	('SZ105', 105, 'SUBZONA 105', 'Z1', 7, 'Ngagel I + Ngagel II', 1, '-', 0.00),
	('SZ106', 106, 'SUBZONA 106', 'Z1', 7, 'Ngagel I + Ngagel II', 1, '-', 0.00),
	('SZ107', 107, 'SUBZONA 107', 'Z1', 1, 'Ngagel I', 1, '-', 0.00),
	('SZ108', 108, 'SUBZONA 108', 'Z1', 1, 'Ngagel I', 2, 'Wonocolo', 0.00),
	('SZ109', 109, 'SUBZONA 109', 'Z1', 8, 'Sumber Air Luar Kota', 2, 'Wonocolo', 0.00),
	('SZ110', 110, 'SUBZONA 110', 'Z1', 8, 'Sumber Air Luar Kota', 1, '-', 0.00),
	('SZ111', 111, 'SUBZONA 111', 'Z1', 7, 'Ngagel I + Ngagel II', 2, 'Wonocolo', 0.00),
	('SZ112', 112, 'SUBZONA 112', 'Z1', 7, 'Ngagel I + Ngagel II', 2, 'Wonocolo', 0.00),
	('SZ113', 113, 'SUBZONA 113', 'Z1', 7, 'Ngagel I + Ngagel II', 2, 'Wonocolo', 0.00),
	('SZ114', 114, 'SUBZONA 114', 'Z1', 7, 'Ngagel I + Ngagel II', 2, 'Wonocolo', 0.00),
	('SZ115', 115, 'SUBZONA 115', 'Z1', 7, 'Ngagel I + Ngagel II', 2, 'Wonocolo', 0.00),
	('SZ116', 116, 'SUBZONA 116', 'Z1', 7, 'Ngagel I + Ngagel II', 2, 'Wonocolo', 0.00),
	('SZ117', 117, 'SUBZONA 117', 'Z1', 7, 'Ngagel I + Ngagel II', 2, 'Wonocolo', 0.00),
	('SZ118', 118, 'SUBZONA 118', 'Z1', 7, 'Ngagel I + Ngagel II', 2, 'Wonocolo', 0.00),
	('SZ119', 119, 'SUBZONA 119', 'Z1', 7, 'Ngagel I + Ngagel II', 1, '-', 0.00),
	('SZ120', 120, 'SUBZONA 120', 'Z1', 1, 'Ngagel I', 1, '-', 0.00),
	('SZ201', 201, 'SUBZONA 201', 'Z2', 1, 'Ngagel I', 1, '-', 0.00),
	('SZ202', 202, 'SUBZONA 202', 'Z2', 1, 'Ngagel I', 1, '-', 0.00),
	('SZ203', 203, 'SUBZONA 203', 'Z2', 1, 'Ngagel I', 1, '-', 0.00),
	('SZ204', 204, 'SUBZONA 204', 'Z2', 3, 'Ngagel III', 1, '-', 0.00),
	('SZ205', 205, 'SUBZONA 205', 'Z2', 1, 'Ngagel I', 1, '-', 30.00),
	('SZ206', 206, 'SUBZONA 206', 'Z2', 1, 'Ngagel I', 1, '-', 0.00),
	('SZ207', 207, 'SUBZONA 207', 'Z2', 3, 'Ngagel III', 1, '-', 0.00),
	('SZ208', 208, 'SUBZONA 208', 'Z2', 1, 'Ngagel I', 1, '-', 0.00),
	('SZ209', 209, 'SUBZONA 209', 'Z2', 3, 'Ngagel III', 1, '-', 0.00),
	('SZ210', 210, 'SUBZONA 210', 'Z2', 3, 'Ngagel III', 2, 'Wonocolo', 0.00),
	('SZ211', 211, 'SUBZONA 211', 'Z2', 3, 'Ngagel III', 2, 'Wonocolo', 0.00),
	('SZ212', 212, 'SUBZONA 212', 'Z2', 3, 'Ngagel III', 2, 'Wonocolo', 0.00),
	('SZ213', 213, 'SUBZONA 213', 'Z2', 3, 'Ngagel III', 2, 'Wonocolo', 0.00),
	('SZ214', 214, 'SUBZONA 214', 'Z2', 3, 'Ngagel III', 2, 'Wonocolo', 0.00),
	('SZ215', 215, 'SUBZONA 215', 'Z2', 3, 'Ngagel III', 2, 'Wonocolo', 0.00),
	('SZ216', 216, 'SUBZONA 216', 'Z2', 3, 'Ngagel III', 2, 'Wonocolo', 0.00),
	('SZ217', 217, 'SUBZONA 217', 'Z2', 3, 'Ngagel III', 2, 'Wonocolo', 0.00),
	('SZ218', 218, 'SUBZONA 218', 'Z2', 3, 'Ngagel III', 2, 'Wonocolo', 0.00),
	('SZ219', 219, 'SUBZONA 219', 'Z2', 3, 'Ngagel III', 2, 'Wonocolo', 0.00),
	('SZ220', 220, 'SUBZONA 220', 'Z2', 3, 'Ngagel III', 3, 'Putat Gede', 0.00),
	('SZ221', 221, 'SUBZONA 221', 'Z2', 3, 'Ngagel III', 2, 'Wonocolo', 0.00),
	('SZ222', 222, 'SUBZONA 222', 'Z2', 3, 'Ngagel III', 2, 'Wonocolo', 0.00),
	('SZ223', 223, 'SUBZONA 223', 'Z2', 9, '-', 1, '-', 0.00),
	('SZ224', 224, 'SUBZONA 224', 'Z2', 1, 'Ngagel I', 1, '-', 0.00),
	('SZ225', 225, 'SUBZONA 225', 'Z2', 3, 'Ngagel III', 2, 'Wonocolo', 0.00),
	('SZ226', 226, 'SUBZONA 226', 'Z2', 3, 'Ngagel III', 3, 'Putat Gede', 0.00),
	('SZ227', 227, 'SUBZONA 227', 'Z2', 3, 'Ngagel III', 1, '-', 0.00),
	('SZ228', 228, 'SUBZONA 228', 'Z2', 3, 'Ngagel III', 3, 'Putat Gede', 0.00),
	('SZ301', 301, 'SUBZONA 301', 'Z3', 1, 'Ngagel I', 1, '-', 0.00),
	('SZ302', 302, 'SUBZONA 302', 'Z3', 2, 'Ngagel II', 1, '-', 0.00),
	('SZ303', 303, 'SUBZONA 303', 'Z3', 1, 'Ngagel I', 3, 'Putat Gede', 0.00),
	('SZ304', 304, 'SUBZONA 304', 'Z3', 2, 'Ngagel II', 1, '-', 0.00),
	('SZ305', 305, 'SUBZONA 305', 'Z3', 2, 'Ngagel II', 1, '-', 0.00),
	('SZ306', 306, 'SUBZONA 306', 'Z3', 2, 'Ngagel II', 1, '-', 0.00),
	('SZ307', 307, 'SUBZONA 307', 'Z3', 6, 'KarangPilang+Ngagel', 3, 'Putat Gede', 0.00),
	('SZ308', 308, 'SUBZONA 308', 'Z3', 6, 'KarangPilang+Ngagel', 3, 'Putat Gede', 0.00),
	('SZ309', 309, 'SUBZONA 309', 'Z3', 5, 'Karang Pilang II', 3, 'Putat Gede', 0.00),
	('SZ310', 310, 'SUBZONA 310', 'Z3', 6, 'KarangPilang+Ngagel', 3, 'Putat Gede', 0.00),
	('SZ311', 311, 'SUBZONA 311', 'Z3', 6, 'KarangPilang+Ngagel', 3, 'Putat Gede', 0.00),
	('SZ312', 312, 'SUBZONA 312', 'Z3', 6, 'KarangPilang+Ngagel', 3, 'Putat Gede', 0.00),
	('SZ313', 313, 'SUBZONA 313', 'Z3', 5, 'Karang Pilang II', 3, 'Putat Gede', 0.00),
	('SZ314', 314, 'SUBZONA 314', 'Z3', 6, 'KarangPilang+Ngagel', 3, 'Putat Gede', 0.00),
	('SZ315', 315, 'SUBZONA 315', 'Z3', 6, 'KarangPilang+Ngagel', 3, 'Putat Gede', 0.00),
	('SZ316', 316, 'SUBZONA 316', 'Z3', 6, 'KarangPilang+Ngagel', 3, 'Putat Gede', 0.00),
	('SZ401', 401, 'SUBZONA 401', 'Z4', 2, 'Ngagel II', 1, '-', 0.00),
	('SZ402', 402, 'SUBZONA 402', 'Z4', 2, 'Ngagel II', 1, '-', 0.00),
	('SZ403', 403, 'SUBZONA 403', 'Z4', 4, 'Karang Pilang I', 1, '-', 0.00),
	('SZ404', 404, 'SUBZONA 404', 'Z4', 2, 'Ngagel II', 1, '-', 0.00),
	('SZ405', 405, 'SUBZONA 405', 'Z4', 2, 'Ngagel II', 1, '-', 0.00),
	('SZ406', 406, 'SUBZONA 406', 'Z4', 1, 'Ngagel I', 1, '-', 0.00),
	('SZ407', 407, 'SUBZONA 407', 'Z4', 2, 'Ngagel II', 1, '-', 0.00),
	('SZ408', 408, 'SUBZONA 408', 'Z4', 4, 'Karang Pilang I', 1, '-', 0.00),
	('SZ409', 409, 'SUBZONA 409', 'Z4', 4, 'Karang Pilang I', 1, '-', 0.00),
	('SZ410', 410, 'SUBZONA 410', 'Z4', 1, 'Ngagel I', 1, '-', 0.00),
	('SZ411', 411, 'SUBZONA 411', 'Z4', 5, 'Karang Pilang II', 1, '-', 0.00),
	('SZ412', 412, 'SUBZONA 412', 'Z4', 4, 'Karang Pilang I', 1, '-', 0.00),
	('SZ413', 413, 'SUBZONA 413', 'Z4', 1, 'Ngagel I', 1, '-', 0.00),
	('SZ414', 414, 'SUBZONA 414', 'Z4', 5, 'Karang Pilang II', 3, 'Putat Gede', 0.00),
	('SZ415', 415, 'SUBZONA 415', 'Z4', 5, 'Karang Pilang II', 3, 'Putat Gede', 0.00),
	('SZ416', 416, 'SUBZONA 416', 'Z4', 2, 'Ngagel II', 1, '-', 0.00),
	('SZ417', 417, 'SUBZONA 417', 'Z4', 5, 'Karang Pilang II', 3, 'Putat Gede', 0.00),
	('SZ418', 418, 'SUBZONA 418', 'Z4', 2, 'Ngagel II', 1, '-', 0.00),
	('SZ419', 419, 'SUBZONA 419', 'Z4', 5, 'Karang Pilang II', 3, 'Putat Gede', 0.00),
	('SZ420', 420, 'SUBZONA 420', 'Z4', 5, 'Karang Pilang II', 1, '-', 0.00),
	('SZ421', 421, 'SUBZONA 421', 'Z4', 5, 'Karang Pilang II', 1, '-', 0.00),
	('SZ422', 422, 'SUBZONA 422', 'Z4', 5, 'Karang Pilang II', 1, '-', 0.00),
	('SZ423', 423, 'SUBZONA 423', 'Z4', 5, 'Karang Pilang II', 1, '-', 0.00),
	('SZ424', 424, 'SUBZONA 424', 'Z4', 5, 'Karang Pilang II', 1, '-', 0.00),
	('SZ425', 425, 'SUBZONA 425', 'Z4', 5, 'Karang Pilang II', 1, '-', 0.00),
	('SZ426', 426, 'SUBZONA 426', 'Z4', 9, '-', 3, 'Putat Gede', 0.00),
	('SZ427', 427, 'SUBZONA 427', 'Z4', 5, 'Karang Pilang II', 1, '-', 0.00),
	('SZ428', 428, 'SUBZONA 428', 'Z4', 5, 'Karang Pilang II', 1, '-', 0.00),
	('SZ429', 429, 'SUBZONA 429', 'Z4', 9, '-', 1, '-', 0.00),
	('SZ430', 430, 'SUBZONA 430', 'Z4', 5, 'Karang Pilang II', 1, '-', 0.00),
	('SZ431', 431, 'SUBZONA 431', 'Z4', 5, 'Karang Pilang II', 1, '-', 0.00),
	('SZ432', 432, 'SUBZONA 432', 'Z4', 9, '-', 1, '-', 0.00),
	('SZ433', 433, 'SUBZONA 433', 'Z4', 9, '-', 1, '-', 0.00),
	('SZ434', 434, 'SUBZONA 434', 'Z4', 5, 'Karang Pilang II', 3, 'Putat Gede', 0.00),
	('SZ435', 435, 'SUBZONA 435', 'Z4', 5, 'Karang Pilang II', 3, 'Putat Gede', 0.00),
	('SZ436', 436, 'SUBZONA 436', 'Z4', 5, 'Karang Pilang II', 3, 'Putat Gede', 0.00),
	('SZ501', 501, 'SUBZONA 501', 'Z5', 1, 'Ngagel I', 1, '-', 0.00),
	('SZ502', 502, 'SUBZONA 502', 'Z5', 1, 'Ngagel I', 1, '-', 0.00),
	('SZ503', 503, 'SUBZONA 503', 'Z5', 1, 'Ngagel I', 1, '-', 0.00),
	('SZ504', 504, 'SUBZONA 504', 'Z5', 4, 'Karang Pilang I', 1, '-', 0.00),
	('SZ505', 505, 'SUBZONA 505', 'Z5', 4, 'Karang Pilang I', 1, '-', 0.00),
	('SZ506', 506, 'SUBZONA 506', 'Z5', 4, 'Karang Pilang I', 1, '-', 0.00),
	('SZ507', 507, 'SUBZONA 507', 'Z5', 4, 'Karang Pilang I', 1, '-', 0.00),
	('SZ508', 508, 'SUBZONA 508', 'Z5', 4, 'Karang Pilang I', 1, '-', 0.00),
	('SZ509', 509, 'SUBZONA 509', 'Z5', 4, 'Karang Pilang I', 3, 'Putat Gede', 0.00),
	('SZ510', 510, 'SUBZONA 510', 'Z5', 1, 'Ngagel I', 1, '-', 0.00),
	('SZ511', 511, 'SUBZONA 511', 'Z5', 4, 'Karang Pilang I', 1, '-', 0.00),
	('SZ512', 512, 'SUBZONA 512', 'Z5', 4, 'Karang Pilang I', 1, '-', 0.00),
	('SZ513', 513, 'SUBZONA 513', 'Z5', 4, 'Karang Pilang I', 1, '-', 0.00),
	('SZ514', 514, 'SUBZONA 514', 'Z5', 5, 'Karang Pilang II', 1, '-', 0.00),
	('SZ515', 515, 'SUBZONA 515', 'Z5', 5, 'Karang Pilang II', 1, '-', 0.00),
	('SZ516', 516, 'SUBZONA 516', 'Z5', 5, 'Karang Pilang II', 4, 'Pradah', 0.00),
	('SZ517', 517, 'SUBZONA 517', 'Z5', 5, 'Karang Pilang II', 1, '-', 0.00),
	('SZ518', 518, 'SUBZONA 518', 'Z5', 5, 'Karang Pilang II', 1, '-', 0.00),
	('SZ519', 519, 'SUBZONA 519', 'Z5', 5, 'Karang Pilang II', 1, '-', 0.00),
	('SZ520', 520, 'SUBZONA 520', 'Z5', 5, 'Karang Pilang II', 1, '-', 0.00),
	('SZ521', 521, 'SUBZONA 521', 'Z5', 5, 'Karang Pilang II', 1, '-', 0.00),
	('SZ522', 522, 'SUBZONA 522', 'Z5', 5, 'Karang Pilang II', 1, '-', 0.00),
	('SZ523', 523, 'SUBZONA 523', 'Z5', 5, 'Karang Pilang II', 1, '-', 0.00),
	('SZ524', 524, 'SUBZONA 524', 'Z5', 5, 'Karang Pilang II', 1, '-', 0.00),
	('SZ525', 525, 'SUBZONA 525', 'Z5', 5, 'Karang Pilang II', 3, 'Putat Gede', 0.00),
	('SZ526', 526, 'SUBZONA 526', 'Z5', 5, 'Karang Pilang II', 3, 'Putat Gede', 0.00),
	('SZ527', 527, 'SUBZONA 527', 'Z5', 5, 'Karang Pilang II', 1, '-', 0.00),
	('SZ528', 528, 'SUBZONA 528', 'Z5', 5, 'Karang Pilang II', 1, '-', 0.00),
	('SZ529', 529, 'SUBZONA 529', 'Z5', 5, 'Karang Pilang II', 1, '-', 0.00),
	('SZ530', 530, 'SUBZONA 530', 'Z5', 5, 'Karang Pilang II', 1, '-', 0.00),
	('SZ531', 531, 'SUBZONA 531', 'Z5', 5, 'Karang Pilang II', 1, '-', 0.00),
	('SZ532', 532, 'SUBZONA 532', 'Z5', 5, 'Karang Pilang II', 1, '-', 0.00),
	('SZ533', 533, 'SUBZONA 533', 'Z5', 5, 'Karang Pilang II', 1, '-', 0.00),
	('SZ534', 534, 'SUBZONA 534', 'Z5', 5, 'Karang Pilang II', 1, '-', 0.00),
	('SZ535', 535, 'SUBZONA 535', 'Z5', 5, 'Karang Pilang II', 1, '-', 0.00),
	('SZ536', 536, 'SUBZONA 536', 'Z5', 5, 'Karang Pilang II', 1, '-', 0.00),
	('SZ537', 537, 'SUBZONA 537', 'Z5', 5, 'Karang Pilang II', 4, 'Pradah', 0.00),
	('SZ538', 538, 'SUBZONA 538', 'Z5', 5, 'Karang Pilang II', 1, '-', 0.00),
	('SZ539', 539, 'SUBZONA 539', 'Z5', 9, '-', 1, '-', 0.00),
	('SZ540', 540, 'SUBZONA 540', 'Z5', 4, 'Karang Pilang I', 4, 'Pradah', 0.00),
	('SZ541', 541, 'SUBZONA 541', 'Z5', 5, 'Karang Pilang II', 4, 'Pradah', 0.00),
	('SZ542', 542, 'SUBZONA 542', 'Z5', 5, 'Karang Pilang II', 3, 'Putat Gede', 0.00),
	('SZ543', 543, 'SUBZONA 543', 'Z5', 5, 'Karang Pilang II', 3, 'Putat Gede', 0.00),
	('SZ544', 544, 'SUBZONA 544', 'Z5', 5, 'Karang Pilang II', 1, '-', 0.00),
	('SZ545', 545, 'SUBZONA 545', 'Z5', 4, 'Karang Pilang I', 1, '-', 0.00),
	('SZ546', 546, 'SUBZONA 546', 'Z5', 9, '-', 1, '-', 0.00),
	('SZ547', 547, 'SUBZONA 547', 'Z5', 4, 'Karang Pilang I', 1, '-', 0.00);

