-- --------------------------------------------------------
-- Server OS:                    Win32
-- HeidiSQL Version:             9.4.0.5125
-- --------------------------------------------------------



-- Dumping database structure for pdam_web
CREATE DATABASE IF NOT EXISTS `pdam_web` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `pdam_web`;

-- 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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

-- Dumping structure for table pdam_web.jenis_pekerjaan
CREATE TABLE IF NOT EXISTS `jenis_pekerjaan` (
  `id` int(10) unsigned 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,
  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`) VALUES
	(1, 'PVC OD - 110'),
	(2, 'PVC OD - 160'),
	(3, 'PVC OD - 225'),
	(4, 'PVC OD - 260'),
	(5, 'PVC OD - 315'),
	(6, 'PVC OD - 63'),
	(7, 'PVC OD - 90');

-- 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,
  `rumah_tangga` int(11) NOT NULL,
  `non_rumah` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pdam_web.jenis_tarif: ~26 rows (approximately)
DELETE FROM `jenis_tarif`;
INSERT INTO `jenis_tarif` (`id`, `kode_tarif`, `rumah_tangga`, `non_rumah`) VALUES
	(1, '1', 0, 1),
	(2, '2A.1', 0, 1),
	(3, '2A.2', 1, 0),
	(4, '2B', 0, 1),
	(5, '3A', 1, 0),
	(6, '3B.1', 0, 1),
	(7, '3B.2', 0, 1),
	(8, '3C.1', 0, 1),
	(9, '3C.2', 0, 1),
	(10, '4A', 1, 0),
	(11, '4B.1', 0, 1),
	(12, '4B.2', 1, 0),
	(13, '4C', 0, 1),
	(14, '4D', 0, 1),
	(15, '5', 0, 1),
	(16, '53A', 0, 1),
	(17, '53A.1', 0, 1),
	(18, '53B', 0, 1),
	(19, '53C', 0, 1),
	(20, '53D', 0, 1),
	(21, '53E', 0, 1),
	(22, '53F', 0, 1),
	(23, '53G', 0, 1),
	(24, '53H', 0, 1),
	(25, '53I', 0, 1),
	(26, '53J', 0, 1);

-- Dumping structure for table pdam_web.keckel
CREATE TABLE IF NOT EXISTS `keckel` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_kecamatan` int(11) DEFAULT NULL,
  `id_kelurahan` int(11) DEFAULT NULL,
  `nama_kecamatan` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nama_kelurahan` varchar(100) COLLATE utf8mb4_unicode_ci 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.keckel: ~178 rows (approximately)
DELETE FROM `keckel`;
INSERT INTO `keckel` (`id`, `id_kecamatan`, `id_kelurahan`, `nama_kecamatan`, `nama_kelurahan`, `created_at`, `updated_at`) VALUES
	(1, 21, 1, 'Suko Manunggal', 'Suko Manunggal', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(2, 21, 2, 'Suko Manunggal', 'Tanjungsari', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(3, 21, 5, 'Suko Manunggal', 'Simomulyo', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(4, 21, 3, 'Suko Manunggal', 'Sonokwijenan', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(5, 21, 4, 'Suko Manunggal', 'Putat Gede', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(6, 22, 1, 'Asem Rowo', 'Asem Rowo', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(7, 22, 2, 'Asem Rowo', 'Genting', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(8, 22, 3, 'Asem Rowo', 'Kalianak', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(9, 22, 4, 'Asem Rowo', 'Greges', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(10, 22, 5, 'Asem Rowo', 'Tambak Langon', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(11, 29, 7, 'Bulak', 'Kenjeran', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(12, 29, 6, 'Bulak', 'Kedung Cowek', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(13, 29, 9, 'Bulak', 'Koplek Kenjeran', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(14, 29, 2, 'Bulak', 'Bulak', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(15, 29, 8, 'Bulak', 'Sukolilo', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(16, 30, 6, 'Pakal', 'Benowo', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(17, 30, 7, 'Pakal', 'Sumberejo', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(18, 30, 4, 'Pakal', 'Babat Jerawat', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(19, 30, 5, 'Pakal', 'Pakal', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(20, 30, 8, 'Pakal', 'Tambakdono', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(21, 31, 9, 'Sambi Kerep', 'Sambi Kerep', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(22, 31, 6, 'Sambi Kerep', 'Lontar', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(23, 31, 2, 'Sambi Kerep', 'Beringin', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(24, 31, 8, 'Sambi Kerep', 'Made', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(25, 0, 0, 'Luar Kota', 'Luar Kota', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(26, 23, 1, 'Benowo', 'Kandangan', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(27, 23, 2, 'Benowo', 'Klakahrejo', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(28, 23, 4, 'Benowo', 'Babat Jerawat', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(29, 23, 5, 'Benowo', 'Pakal', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(30, 23, 6, 'Benowo', 'Benowo', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(31, 23, 7, 'Benowo', 'Sumberejo', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(32, 23, 8, 'Benowo', 'Tambakdono', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(33, 23, 9, 'Benowo', 'Tambak Osowilangun', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(34, 23, 10, 'Benowo', 'Romo Kalisari', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(35, 23, 3, 'Benowo', 'Sememi', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(36, 3, 1, 'Krembangan', 'Krembangan Selatan', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(37, 3, 2, 'Krembangan', 'Kemayoran', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(38, 3, 3, 'Krembangan', 'Perak Barat', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(39, 3, 4, 'Krembangan', 'Dupak', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(40, 3, 5, 'Krembangan', 'Morokrembangan', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(41, 1, 2, 'Pabean cantikan', 'Nyamplungan', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(42, 1, 1, 'Pabean cantikan', 'Bongkaran', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(43, 1, 3, 'Pabean cantikan', 'Krembangan Utara', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(44, 1, 4, 'Pabean cantikan', 'Perak Utara', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(45, 1, 5, 'Pabean cantikan', 'Perak Timur', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(46, 2, 1, 'Semampir', 'Ampel', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(47, 2, 2, 'Semampir', 'Pegirian', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(48, 2, 3, 'Semampir', 'Wonokusumo', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(49, 2, 4, 'Semampir', 'Ujung', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(50, 2, 5, 'Semampir', 'Sidotopo', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(51, 6, 1, 'Gubeng', 'Mojo', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(52, 6, 2, 'Gubeng', 'Airlangga', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(53, 6, 4, 'Gubeng', 'Gubeng', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(54, 6, 5, 'Gubeng', 'Barata Jaya', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(55, 6, 6, 'Gubeng', 'Pucang Sewu', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(56, 6, 3, 'Gubeng', 'Kertajaya', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(57, 4, 1, 'Kenjeran', 'Tanah Kalikedinding', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(58, 4, 2, 'Kenjeran', 'Bulak', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(59, 4, 3, 'Kenjeran', 'Sidotopo Wetan', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(60, 4, 4, 'Kenjeran', 'Bulak Banteng', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(61, 4, 5, 'Kenjeran', 'Tambak Wedi', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(62, 4, 6, 'Kenjeran', 'Kedung Cowek', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(63, 4, 7, 'Kenjeran', 'Kenjeran', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(64, 4, 8, 'Kenjeran', 'Sukolilo', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(65, 4, 9, 'Kenjeran', 'Komplek Kenjeran', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(66, 5, 1, 'Tambaksari', 'Gading', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(67, 5, 2, 'Tambaksari', 'Pacar Kembang', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(68, 5, 3, 'Tambaksari', 'Tambaksari', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(69, 5, 4, 'Tambaksari', 'Ploso', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(70, 5, 5, 'Tambaksari', 'Rangkah', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(71, 5, 6, 'Tambaksari', 'Pacar Keling', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(72, 7, 1, 'Rungkut', 'Kalirungkut', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(73, 7, 2, 'Rungkut', 'Rungkut Kidul', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(74, 7, 3, 'Rungkut', 'Kedung Baruk', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(75, 7, 4, 'Rungkut', 'Penjaringan Sari', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(76, 7, 5, 'Rungkut', 'Wonorejo', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(77, 7, 6, 'Rungkut', 'Medoan Ayu', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(78, 8, 1, 'Gunung Anyar', 'Gunung Anyar', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(79, 8, 2, 'Gunung Anyar', 'Rungkut Tengah', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(80, 8, 3, 'Gunung Anyar', 'Rungkut Menanggal', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(81, 8, 4, 'Gunung Anyar', 'Gunung Anyar Tambak', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(82, 9, 2, 'Tenggilis Mejoyo', 'Prapen', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(83, 9, 3, 'Tenggilis Mejoyo', 'Panjang Jiwo', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(84, 9, 4, 'Tenggilis Mejoyo', 'Kendang Sari', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(85, 9, 5, 'Tenggilis Mejoyo', 'Kutisari', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(86, 9, 1, 'Tenggilis Mejoyo', 'Tenggilis Mejoyo', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(87, 10, 3, 'Sukolilo', 'Klampis Ngasem', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(88, 10, 4, 'Sukolilo', 'Menur Pumpungan', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(89, 10, 5, 'Sukolilo', 'Nginden Jangkungan', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(90, 10, 1, 'Sukolilo', 'Keputih', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(91, 10, 2, 'Sukolilo', 'Gebang Putih', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(92, 10, 6, 'Sukolilo', 'Semolowaru', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(93, 10, 7, 'Sukolilo', 'Medokan Semampir', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(94, 11, 2, 'Mulyorejo', 'Manyar Sabrangan', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(95, 11, 3, 'Mulyorejo', 'Kejawan Putih Tambak', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(96, 11, 4, 'Mulyorejo', 'Kalisari', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(97, 11, 1, 'Mulyorejo', 'Mulyorejo', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(98, 11, 5, 'Mulyorejo', 'Dukuh Sutorejo', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(99, 11, 6, 'Mulyorejo', 'Kalijudan', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(100, 12, 1, 'Sawahan', 'Petemon', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(101, 12, 2, 'Sawahan', 'Sawahan', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(102, 12, 3, 'Sawahan', 'Banyu Urip', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(103, 12, 4, 'Sawahan', 'Putat Jaya', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(104, 12, 5, 'Sawahan', 'Kupang Krajan', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(105, 12, 6, 'Sawahan', 'Pakis', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(106, 13, 2, 'Wonokromo', 'Jagir', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(107, 13, 3, 'Wonokromo', 'Ngagel', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(108, 13, 4, 'Wonokromo', 'Ngagel Rejo', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(109, 13, 5, 'Wonokromo', 'Darmo', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(110, 13, 6, 'Wonokromo', 'Sawunggaling', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(111, 13, 1, 'Wonokromo', 'Wonokromo', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(112, 14, 1, 'Karangpilang', 'Karangpilang', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(113, 14, 2, 'Karangpilang', 'Kebraon', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(114, 14, 3, 'Karangpilang', 'Kedurus', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(115, 14, 4, 'Karangpilang', 'Waru Gunung', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(116, 15, 1, 'Dukuh Pakis', 'Dukuh Pakis', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(117, 15, 3, 'Dukuh Pakis', 'Gunung Sari', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(118, 15, 4, 'Dukuh Pakis', 'Pradah Kalikendal', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(119, 15, 2, 'Dukuh Pakis', 'Dukuh Kupang', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(120, 16, 1, 'Wiyung', 'Wiyung', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(121, 16, 2, 'Wiyung', 'Jajar Tunggal', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(122, 16, 3, 'Wiyung', 'Babatan', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(123, 16, 4, 'Wiyung', 'Balas Klumprik', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(124, 17, 1, 'Wonocolo', 'Sidoresmo', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(125, 17, 2, 'Wonocolo', 'Bendul Merisi', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(126, 17, 3, 'Wonocolo', 'Margorejo', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(127, 17, 4, 'Wonocolo', 'Jemur Wonosari', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(128, 17, 5, 'Wonocolo', 'Siwalankerto', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(129, 18, 2, 'Gayungan', 'Ketintang', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(130, 18, 3, 'Gayungan', 'Menanggal', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(131, 18, 4, 'Gayungan', 'Dukuh Menanggal', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(132, 18, 1, 'Gayungan', 'Gayungan', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(133, 19, 1, 'Jambangan', 'Jambangan', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(134, 19, 2, 'Jambangan', 'Karah', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(135, 19, 3, 'Jambangan', 'Kebonsari', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(136, 19, 4, 'Jambangan', 'Pagesangan', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(137, 20, 1, 'Tandes', 'Gedang Asin', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(138, 20, 2, 'Tandes', 'Tandes Lor', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(139, 20, 3, 'Tandes', 'Tubanan', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(140, 20, 4, 'Tandes', 'Gadel', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(141, 20, 5, 'Tandes', 'Tandes Kidul', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(142, 20, 6, 'Tandes', 'Karang Poh', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(143, 20, 7, 'Tandes', 'Balongsari', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(144, 20, 8, 'Tandes', 'Bibis', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(145, 20, 9, 'Tandes', 'Manukan Kulon', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(146, 20, 10, 'Tandes', 'Buntaran', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(147, 20, 11, 'Tandes', 'Manukan Wetan', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(148, 20, 12, 'Tandes', 'Banjar Sugihan', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(149, 24, 2, 'Lakarsantri', 'Beringin', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(150, 24, 3, 'Lakarsantri', 'Jeruk', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(151, 24, 4, 'Lakarsantri', 'Lakarsantri', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(152, 24, 6, 'Lakarsantri', 'Lontar', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(153, 24, 8, 'Lakarsantri', 'Made', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(154, 24, 10, 'Lakarsantri', 'Sumurwelut', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(155, 24, 1, 'Lakarsantri', 'Bangkingan', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(156, 24, 5, 'Lakarsantri', 'Lidah Kulon', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(157, 24, 7, 'Lakarsantri', 'Lidah Wetan', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(158, 24, 9, 'Lakarsantri', 'Sambikerep', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(159, 25, 2, 'Genteng', 'Genteng', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(160, 25, 4, 'Genteng', 'Ketabang', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(161, 25, 5, 'Genteng', 'Peneleh', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(162, 25, 1, 'Genteng', 'Embong Kaliasin', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(163, 25, 3, 'Genteng', 'Kapasari', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(164, 26, 1, 'Tegalsari', 'Dr.Sutomo', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(165, 26, 2, 'Tegalsari', 'Kedungdoro', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(166, 26, 3, 'Tegalsari', 'Keputran', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(167, 26, 4, 'Tegalsari', 'Tegalsari', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(168, 26, 5, 'Tegalsari', 'Wonorejo', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(169, 27, 1, 'Bubutan', 'Tembok Dukuh', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(170, 27, 2, 'Bubutan', 'Bubutan', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(171, 27, 3, 'Bubutan', 'Alun-alun Contong', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(172, 27, 4, 'Bubutan', 'Gundih', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(173, 27, 5, 'Bubutan', 'Jepara', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(174, 28, 1, 'Simokerto', 'Simokerto', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(175, 28, 2, 'Simokerto', 'Kapasan', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(176, 28, 3, 'Simokerto', 'Sidodadi', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(177, 28, 4, 'Simokerto', 'Simolawang', '2018-06-07 15:26:28', '2018-06-07 15:26:28'),
	(178, 28, 5, 'Simokerto', 'Tambakrejo', '2018-06-07 15:26:28', '2018-06-07 15:26:28');

-- 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(15) 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 J');

-- 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.pasang_baru_data
CREATE TABLE IF NOT EXISTS `pasang_baru_data` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `no_daftarpb` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kode_paket` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kode_petugas_survey` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kode_hasil_survey` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `no_mtr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kode_guna_persil` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kode_tarif` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `zona` bigint(20) DEFAULT NULL,
  `status_tanah` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ukuran_meter` decimal(8,2) DEFAULT NULL,
  `rp_retribusi` decimal(8,2) 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,
  `no_pa` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alamat_tekanan` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tekanan_air` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tgl_tekanan` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rp_bp` bigint(20) DEFAULT NULL,
  `rp_reg` bigint(20) DEFAULT NULL,
  `rp_bsi` bigint(20) DEFAULT NULL,
  `bln_terbit` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `angka_pasang` bigint(20) DEFAULT NULL,
  `nopel` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jenis_pelanggan` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kode_ptgdist` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kode_pengawas` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nip_petugas` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nip_pengawas` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kode_retribusi` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jenis_persil` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ppn` bigint(20) DEFAULT NULL,
  `lebar_jalan` bigint(20) DEFAULT NULL,
  `listrik` bigint(20) DEFAULT NULL,
  `njop` bigint(20) DEFAULT NULL,
  `luas_bangunan` bigint(20) DEFAULT NULL,
  `jenis_pipa` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jalur_pipa` bigint(20) DEFAULT NULL,
  `letak_pipa` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `uraian_pekerjaan` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tahun_pipa` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lebar_persil` bigint(20) DEFAULT NULL,
  `kode_merk` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pot_rp_bp` bigint(20) DEFAULT NULL,
  `pot_rp_bsi` 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` float(10,7) DEFAULT NULL,
  `longitude` float(10,7) DEFAULT NULL,
  `metode_upload` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pdam_web.pasang_baru_data: ~62 rows (approximately)
DELETE FROM `pasang_baru_data`;
INSERT INTO `pasang_baru_data` (`id`, `no_daftarpb`, `kode_paket`, `kode_petugas_survey`, `kode_hasil_survey`, `no_mtr`, `kode_guna_persil`, `kode_tarif`, `zona`, `status_tanah`, `ukuran_meter`, `rp_retribusi`, `nama`, `alamat_pemohon`, `jalan`, `gang`, `nomor`, `notamb`, `da`, `telepon`, `telepon2`, `luas_persil`, `surat_tanah`, `ktp_ksk`, `imb`, `pbb`, `retribusi`, `wilayah`, `kecamatan`, `kelurahan`, `no_bundel`, `no_pa`, `alamat_tekanan`, `tekanan_air`, `tgl_tekanan`, `rp_bp`, `rp_reg`, `rp_bsi`, `bln_terbit`, `angka_pasang`, `nopel`, `jenis_pelanggan`, `kode_ptgdist`, `kode_pengawas`, `nip_petugas`, `nip_pengawas`, `kode_retribusi`, `jenis_persil`, `ppn`, `lebar_jalan`, `listrik`, `njop`, `luas_bangunan`, `jenis_pipa`, `jalur_pipa`, `letak_pipa`, `uraian_pekerjaan`, `tahun_pipa`, `lebar_persil`, `kode_merk`, `pot_rp_bp`, `pot_rp_bsi`, `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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 98932812, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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', NULL, '207', NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, 90, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, '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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, 90, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, '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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, 90, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, '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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, 90, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, '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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, 90, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, '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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, 90, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, '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, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, 90, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, '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.2836161, 112.7514877, NULL),
	(60, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, 90, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, '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.2836161, 112.7514877, NULL),
	(61, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, 90, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, '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.2671790, 112.7940140, NULL),
	(62, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, 90, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, '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.2529688, 112.6473465, NULL),
	(63, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, 90, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, '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.2529688, 112.6473465, NULL),
	(64, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, 90, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, '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.2533917, 112.6503067, NULL),
	(65, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, 90, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, '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.2533917, 112.6503067, NULL),
	(66, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'tidak-bermasalah', NULL, NULL, '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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 900, 12312515, 100, NULL, NULL, NULL, NULL, NULL, 200, NULL, NULL, NULL, '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.2504449, 112.7688446, NULL),
	(67, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'tidak-bermasalah', NULL, NULL, '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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 900, 12312515, 100, NULL, NULL, NULL, NULL, NULL, 200, NULL, NULL, NULL, '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.2504449, 112.7688446, NULL),
	(68, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'tidak-bermasalah', NULL, NULL, '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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 900, 12312515, 100, NULL, NULL, NULL, NULL, NULL, 200, NULL, NULL, NULL, '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.2504449, 112.7688446, NULL),
	(69, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'tidak-bermasalah', NULL, NULL, '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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1300, 12312000, 100, NULL, NULL, NULL, NULL, NULL, 200, NULL, NULL, NULL, '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.2504449, 112.7688446, NULL),
	(70, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'tidak-bermasalah', NULL, NULL, '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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1300, 12312000, 100, NULL, NULL, NULL, NULL, NULL, 200, NULL, NULL, NULL, '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.2504449, 112.7688446, NULL),
	(71, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'tidak-bermasalah', NULL, NULL, 'Anton Nazarudin', 'Keputih', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, '21', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2200, 12312515, 100, NULL, NULL, NULL, NULL, NULL, 200, NULL, NULL, NULL, '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.2504449, 112.7688446, NULL),
	(72, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'tidak-bermasalah', NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', '082238457843', 150, NULL, NULL, NULL, NULL, NULL, NULL, '21', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 900, 12312000, 100, NULL, NULL, NULL, NULL, NULL, 200, NULL, NULL, NULL, '123049213245', NULL, '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-04 18:42:13', 300, 300, 200, 'T', NULL, NULL, -7.2504449, 112.7688446, NULL),
	(73, 'T20180000005', NULL, '223', NULL, NULL, NULL, NULL, NULL, 'bermasalah', NULL, NULL, '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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 900, 12312515, 100, NULL, NULL, NULL, NULL, NULL, 200, NULL, NULL, NULL, '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.2504449, 112.7688446, NULL),
	(74, 'T20180000006', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'bermasalah', NULL, NULL, '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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312515, 100, NULL, NULL, NULL, NULL, NULL, 200, NULL, NULL, NULL, '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.2504449, 112.7688446, NULL),
	(75, 'T20180000004', NULL, '208', NULL, NULL, NULL, NULL, NULL, 'bermasalah', NULL, NULL, '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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312515, 100, NULL, NULL, NULL, NULL, NULL, 200, NULL, NULL, NULL, '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.2504449, 112.7688446, 'online'),
	(76, 'T20180000003', NULL, '209', NULL, NULL, NULL, NULL, NULL, 'bermasalah', NULL, NULL, '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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 900, 12312515, 100, NULL, NULL, NULL, NULL, NULL, 200, NULL, NULL, NULL, '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.2485719, 112.6301422, 'loket'),
	(77, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 12312000, 90, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, '123049213245', 'SZ542', '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-06 05:05:41', 15, 9, 10, 'B', NULL, NULL, -7.2533917, 112.6503067, 'mobile'),
	(78, 'T20180000012', NULL, '242', NULL, NULL, NULL, NULL, NULL, 'bermasalah', NULL, NULL, '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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1300, 12312000, 100, NULL, NULL, NULL, NULL, NULL, 200, NULL, NULL, NULL, '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.2504449, 112.7688446, 'online'),
	(79, 'T20180000016', NULL, '210', NULL, NULL, NULL, NULL, NULL, 'tidak-bermasalah', NULL, NULL, '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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 900, 12312515, 100, NULL, NULL, NULL, NULL, NULL, 200, NULL, NULL, NULL, '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.2868853, 112.8036041, 'loket'),
	(80, 'T20180000017', NULL, '236', NULL, NULL, NULL, NULL, NULL, 'tidak-bermasalah', NULL, NULL, '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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 900, 12312000, 100, NULL, NULL, NULL, NULL, NULL, 20, NULL, NULL, NULL, '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.2508707, 112.7807083, 'online');

-- 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: ~47 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');

-- 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.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: ~17 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');

-- 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: ~44 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),
	(9, 2),
	(9, 3),
	(9, 4),
	(9, 7),
	(9, 8),
	(10, 1),
	(10, 2),
	(10, 3),
	(10, 4),
	(10, 7),
	(10, 8),
	(11, 1),
	(11, 2),
	(11, 3),
	(11, 4),
	(11, 7),
	(11, 8),
	(12, 1),
	(12, 2),
	(12, 3),
	(12, 4),
	(12, 7),
	(12, 8),
	(12, 9),
	(13, 1),
	(13, 4),
	(14, 1),
	(14, 6),
	(15, 1),
	(15, 5),
	(15, 6),
	(15, 9),
	(16, 1),
	(16, 5),
	(16, 6),
	(16, 9),
	(17, 1),
	(17, 5),
	(17, 6),
	(18, 1),
	(18, 3);

-- 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.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: ~8 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', 0, '2018-07-02 05:56:09', '2018-07-02 05:56:09'),
	(3, 'p2k', 'P2K', 'Petugas P2K', 0, '2018-07-02 05:56:44', '2018-07-02 05:56:44'),
	(4, 'vip_p2k', 'VIP P2K', 'Spv dan Manager P2K', 0, '2018-07-02 05:57:26', '2018-07-02 05:57:26'),
	(5, 'pjsr', 'PJSR', 'Petugas PJSR', 0, '2018-07-02 05:57:57', '2018-07-02 05:57:57'),
	(6, 'vip_pjsr', 'VIP PJSR', 'Spv dan Manager PJSR', 0, '2018-07-02 05:58:39', '2018-07-02 05:58:39'),
	(7, 'ptjsr', 'PTJSR', 'Petugas PTJSR', 0, '2018-07-02 05:59:10', '2018-07-02 05:59:10'),
	(8, 'vip_ptjsr', 'VIP PTJSR', 'Spv dan Manager PTJSR', 0, '2018-07-02 05:59:57', '2018-07-02 05:59:57'),
	(9, 'surveyor', 'Surveyor', 'Surveyor', 0, '2018-07-02 09:04:43', '2018-07-02 09:04:43');

-- 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: ~46 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'),
	(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'),
	(3, 129, 'App\\User'),
	(4, 129, 'App\\User'),
	(2, 132, 'App\\User');

-- 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,
  `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,
  `alamat_pemohon` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nomor_subzona` int(10) unsigned NOT NULL,
  `kode_petugas` varchar(3) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kelurahan` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kecamatan` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tanggal_survey` date DEFAULT NULL,
  `tanggal_pembuatan_rab` date DEFAULT NULL,
  `dengan_alamat` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alamat_tekanan` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tekanan_air` double(10,7) DEFAULT NULL,
  `tanggal_ukur_tekanan` date DEFAULT NULL,
  `luas_tanah` int(10) unsigned DEFAULT NULL,
  `lebar_persil` int(10) unsigned DEFAULT NULL,
  `hasil_survey` int(10) unsigned 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(10) unsigned 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,
  `is_pipa_pemkot` int(11) DEFAULT NULL,
  `tahun_pemasangan_pipa_tersier` int(10) unsigned DEFAULT NULL,
  `jumlah_jalur_pipa` int(10) unsigned DEFAULT NULL,
  `is_ada_rekondisi` 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(10) unsigned DEFAULT NULL,
  `is_p3sca` int(11) DEFAULT NULL,
  `is_prefinancing` int(11) DEFAULT NULL,
  `is_dana_ct` int(11) DEFAULT NULL,
  `is_bebas_bsi` int(11) DEFAULT NULL,
  `is_acc` int(11) NOT NULL DEFAULT '0',
  `is_rejected` int(11) NOT NULL DEFAULT '0',
  `total_biaya` int(10) unsigned DEFAULT NULL,
  `has_surveyed` int(11) NOT NULL 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: ~3 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`, `alamat_pemohon`, `nomor_subzona`, `kode_petugas`, `kelurahan`, `kecamatan`, `tanggal_survey`, `tanggal_pembuatan_rab`, `dengan_alamat`, `alamat_tekanan`, `tekanan_air`, `tanggal_ukur_tekanan`, `luas_tanah`, `lebar_persil`, `hasil_survey`, `is_bermasalah`, `keterangan_survey`, `paket_material`, `daya_listrik`, `njop`, `lebar_jalan`, `luas_bangunan`, `kode_tarif`, `kode_guna_persil`, `is_pipa_pemkot`, `tahun_pemasangan_pipa_tersier`, `jumlah_jalur_pipa`, `is_ada_rekondisi`, `kode_jenis_pipa`, `kode_letak_pipa`, `kode_jenis_pekerjaan`, `is_p3sca`, `is_prefinancing`, `is_dana_ct`, `is_bebas_bsi`, `is_acc`, `is_rejected`, `total_biaya`, `has_surveyed`, `created_at`, `updated_at`) VALUES
	(41, '78', '2018-07-06', 'dev-diganti', NULL, 'Keputih', 'Makam', '80', NULL, 'Jalan Kali Kepunton no.4', 219, '242', 'Airlangga', 'Asem Rowo', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1300, 12312000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, 0, '2018-07-06 08:34:14', '2018-07-08 03:45:37'),
	(42, '79', '2018-07-07', 'Joshua Kevin', NULL, 'Keputih', 'Makam', '80', NULL, 'Jalan Kali Kepunton no.4', 222, '210', 'Keputih', 'Sukolilo', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 900, 12312515, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, 0, '2018-07-07 18:13:39', '2018-07-08 03:45:37'),
	(43, '80', '2018-07-08', 'asdasd', NULL, 'Keputih', 'Makam', '18', NULL, 'Jalan Kali Kepunton no.4', 543, '242', 'Kalianak', 'Simokerto', '2018-07-08', '2018-07-08', NULL, 'sukomanunggal', 10.0120000, '2018-07-28', 450, 450, 97, 0, NULL, 'A', 900, 1234000000, 300, 300, '1', 2, 1, 50, 1, 1, 2, 2, 2, NULL, 1, 1, 1, 0, 0, NULL, 1, '2018-07-08 02:36:31', '2018-07-08 03:31:52');

-- 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);

