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


-- Dumping structure for table pdam_master.kas_pb
CREATE TABLE IF NOT EXISTS `kas_pb` (
  `NO_BAYARPB` char(12) DEFAULT NULL,
  `NO_DAFTARPB` char(12) DEFAULT NULL,
  `TGL_BON` datetime DEFAULT NULL,
  `RP_BAYAR` bigint(20) DEFAULT NULL,
  `RP_SISA` bigint(20) DEFAULT NULL,
  `PEMBAYARAN_KE` bigint(20) DEFAULT NULL,
  `KETERANGAN` bigint(20) DEFAULT NULL,
  `POSTING` bigint(20) DEFAULT NULL,
  `NO_RENCANAPJ` int(11) DEFAULT NULL,
  `TAHUN_BUKU` int(11) DEFAULT NULL,
  `BULAN_BUKU` int(11) DEFAULT NULL,
  `NO_JURNAL` bigint(20) DEFAULT NULL,
  `MANUAL` int(11) DEFAULT NULL,
  `KETERANGAN1` bigint(20) DEFAULT NULL,
  `NAMA` bigint(20) DEFAULT NULL,
  `ALAMAT` bigint(20) DEFAULT NULL,
  `ISTAXABLE` int(11) DEFAULT NULL,
  `TAX_VAL` bigint(20) DEFAULT NULL,
  `ISPRINT` bigint(20) DEFAULT NULL,
  `PPH` bigint(20) DEFAULT NULL,
  `PPN` bigint(20) DEFAULT NULL,
  `KD_LOKET` varchar(2) DEFAULT NULL,
  `NO_FAKTUR` char(20) DEFAULT NULL,
  `BATAL` bigint(20) DEFAULT NULL,
  `TGL_BATAL` bigint(20) DEFAULT NULL,
  `KASIR` char(5) DEFAULT NULL,
  `IS_BANK` int(11) DEFAULT NULL,
  `KASIR_UPDATE` bigint(20) DEFAULT NULL,
  `KASIR_BATAL` bigint(20) DEFAULT NULL,
  `RP_MATERAI` bigint(20) DEFAULT NULL,
  `TGL_UPDATE` bigint(20) DEFAULT NULL,
  `JAMBAYAR` int(11) DEFAULT NULL,
  `TGLBAYAR` datetime DEFAULT NULL,
  `TIPE_PEMBAYARAN` varchar(50) DEFAULT NULL,
  `KODE_EDC` int(11) DEFAULT NULL,
  `NO_KARTU` bigint(20) DEFAULT NULL,
  `NILAI_BAYAR` bigint(20) DEFAULT NULL,
  `KETERANGAN2` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

-- Dumping structure for table pdam_master.keckel
CREATE TABLE IF NOT EXISTS `keckel` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `KODE_KECAMATAN` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `KODE_KELURAHAN` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `KECAMATAN` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `KELURAHAN` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

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

-- Dumping structure for table pdam_master.pb
CREATE TABLE IF NOT EXISTS `pb` (
  `NO_DAFTARPB` char(12) COLLATE utf8mb4_unicode_ci NOT NULL,
  `KODE_WILAYAH` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `NO_RENCANAPJ` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `TGL_DAFTARPB` datetime DEFAULT NULL,
  `TGL_KIRIMPG` datetime DEFAULT NULL,
  `TGL_SERAHBON` datetime DEFAULT NULL,
  `TGL_SRV` datetime DEFAULT NULL,
  `TGL_RAB` datetime DEFAULT NULL,
  `TGL_TERIMARAB` datetime DEFAULT NULL,
  `TGL_KASI` datetime DEFAULT NULL,
  `TGL_KABAG` datetime DEFAULT NULL,
  `TGL_KIRIMKAS` datetime DEFAULT NULL,
  `TGL_LUNAS` datetime DEFAULT NULL,
  `TGL_KIRIMDIST` datetime DEFAULT NULL,
  `TGL_KIRIMGUDANG` datetime DEFAULT NULL,
  `TGL_PASANG` datetime DEFAULT NULL,
  `TGL_KEMBALIPG` datetime DEFAULT NULL,
  `TGL_TERIMAPG` datetime DEFAULT NULL,
  `TGL_KIRIMREKENING` datetime DEFAULT NULL,
  `TGL_BONPUTIH` datetime DEFAULT NULL,
  `TGL_BONKUNING` datetime DEFAULT NULL,
  `TGL_PEREMAJAAN` datetime DEFAULT NULL,
  `TGL_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,
  `NO_RABNONPAKET` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `TGL_KIRIMDISSTEK` datetime DEFAULT NULL,
  `TGL_TERIMADISSTEK` 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_PIPAPEMKOT` tinyint(1) DEFAULT NULL,
  `IS_CT` tinyint(1) DEFAULT NULL,
  `IS_POTENSIPB` tinyint(1) DEFAULT NULL,
  `IS_GAKIN` tinyint(1) DEFAULT NULL,
  `TGL_KOREKSI` datetime DEFAULT NULL,
  `JENIS_PB` int(10) unsigned DEFAULT NULL,
  `TGL_EXPIRED` datetime DEFAULT NULL,
  `IS_EXOBA` tinyint(1) DEFAULT NULL,
  `IS_AUTODEBET` tinyint(1) DEFAULT NULL,
  `AUTODEBETBANK` tinyint(1) DEFAULT NULL,
  `NO_DAFTARPBOL` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `IS_PAKUWONB` tinyint(1) DEFAULT NULL,
  `SENTSMS` tinyint(1) DEFAULT NULL,
  `SENTSMSNOPELANGGAN` varchar(13) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `IS_ODS` tinyint(1) DEFAULT NULL,
  `IS_SENTSURVEY` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`NO_DAFTARPB`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

-- Dumping data for table pdam_master.pb: ~0 rows (approximately)
DELETE FROM `pb`;
INSERT INTO `pb` (`NO_DAFTARPB`, `KODE_WILAYAH`, `NO_RENCANAPJ`, `TGL_DAFTARPB`, `TGL_KIRIMPG`, `TGL_SERAHBON`, `TGL_SRV`, `TGL_RAB`, `TGL_TERIMARAB`, `TGL_KASI`, `TGL_KABAG`, `TGL_KIRIMKAS`, `TGL_LUNAS`, `TGL_KIRIMDIST`, `TGL_KIRIMGUDANG`, `TGL_PASANG`, `TGL_KEMBALIPG`, `TGL_TERIMAPG`, `TGL_KIRIMREKENING`, `TGL_BONPUTIH`, `TGL_BONKUNING`, `TGL_PEREMAJAAN`, `TGL_BATAL`, `RAB_JARINGAN`, `FLOW_PB`, `STATUS_PB`, `NO_RABNONPAKET`, `TGL_KIRIMDISSTEK`, `TGL_TERIMADISSTEK`, `IS_MIKRO`, `MARKETING`, `OBA`, `MBR`, `IS_P3SCA`, `IS_PREFINANCING`, `IS_PIPAPEMKOT`, `IS_CT`, `IS_POTENSIPB`, `IS_GAKIN`, `TGL_KOREKSI`, `JENIS_PB`, `TGL_EXPIRED`, `IS_EXOBA`, `IS_AUTODEBET`, `AUTODEBETBANK`, `NO_DAFTARPBOL`, `IS_PAKUWONB`, `SENTSMS`, `SENTSMSNOPELANGGAN`, `IS_ODS`, `IS_SENTSURVEY`) VALUES
	('T20180000017', NULL, NULL, NULL, NULL, NULL, NULL, '2018-07-25 10:51:29', '2018-07-25 10:51: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);

-- Dumping structure for table pdam_master.pb_bayar
CREATE TABLE IF NOT EXISTS `pb_bayar` (
  `NO_DAFTARPB` char(12) DEFAULT NULL,
  `RP_BP` bigint(20) DEFAULT NULL,
  `RP_REG` bigint(20) DEFAULT NULL,
  `RP_BSI` bigint(20) DEFAULT NULL,
  `RP_UANGMUKA` bigint(20) DEFAULT NULL,
  `RP_DICICIL` bigint(20) DEFAULT NULL,
  `KALI_CICIL` int(11) DEFAULT NULL,
  `TGL_CICIL` int(11) DEFAULT NULL,
  `RP_TOTALBAYAR` bigint(20) DEFAULT NULL,
  `PEMBAYARAN_KE` varchar(50) DEFAULT NULL,
  `RP_PEMASANGAN` bigint(20) DEFAULT NULL,
  `PPN` bigint(20) DEFAULT NULL,
  `IS_CICILAN` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

-- Dumping structure for table pdam_master.pb_data
CREATE TABLE IF NOT EXISTS `pb_data` (
  `NO_DAFTARPB` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `KD_PAKET` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `KD_PTGSURVEY` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `KD_HSLSURVEY` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `NO_MTR` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `KD_GUNAPERSIL` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `KD_TARIF` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ZONA` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `STATUS_TANAH` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `UKURAN_MTR` 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,
  `LUAS_TANAH` 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,
  `BLNTERBIT` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ANGKA_PASANG` bigint(20) DEFAULT NULL,
  `NOPEL` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `JNS_PELANGGAN` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `KD_PTGDIST` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `KD_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,
  `KD_RETRIBUSI` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `JNS_PERSIL` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `PPN` bigint(20) DEFAULT NULL,
  `LEBARJALAN` bigint(20) DEFAULT NULL,
  `LISTRIK` bigint(20) DEFAULT NULL,
  `NJOP` bigint(20) DEFAULT NULL,
  `LUAS` bigint(20) DEFAULT NULL,
  `NO_DAFTAR` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `LUAS_BANGUN` bigint(20) DEFAULT NULL,
  `JALUR_PIPA` bigint(20) DEFAULT NULL,
  `JENIS_PIPA` varchar(191) COLLATE utf8mb4_unicode_ci 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,
  `KD_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,
  `USER_ID` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `longitude` float(10,7) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table pdam_master.pb_data: ~63 rows (approximately)
DELETE FROM `pb_data`;
INSERT INTO `pb_data` (`NO_DAFTARPB`, `KD_PAKET`, `KD_PTGSURVEY`, `KD_HSLSURVEY`, `NO_MTR`, `KD_GUNAPERSIL`, `KD_TARIF`, `ZONA`, `STATUS_TANAH`, `UKURAN_MTR`, `RP_RETRIBUSI`, `NAMA`, `ALAMAT_PEMOHON`, `JALAN`, `GANG`, `NOMOR`, `NOTAMB`, `DA`, `TELEPON`, `LUAS_TANAH`, `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`, `BLNTERBIT`, `ANGKA_PASANG`, `NOPEL`, `JNS_PELANGGAN`, `KD_PTGDIST`, `KD_PENGAWAS`, `NIP_PETUGAS`, `NIP_PENGAWAS`, `KD_RETRIBUSI`, `JNS_PERSIL`, `PPN`, `LEBARJALAN`, `LISTRIK`, `NJOP`, `LUAS`, `NO_DAFTAR`, `LUAS_BANGUN`, `JALUR_PIPA`, `JENIS_PIPA`, `LETAK_PIPA`, `URAIAN_PEKERJAAN`, `TAHUN_PIPA`, `LEBAR_PERSIL`, `KD_MERK`, `POT_RP_BP`, `POT_RP_BSI`, `NPWP`, `USER_ID`, `longitude`) VALUES
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'andi muzaki', 'rungkut (aaa depan)', 'arif', '8p', '777', NULL, NULL, '9821393821', 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, NULL, NULL, '971291231', NULL, NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Anton Nazarudin', 'Keputih (0 0)', 'Keputih', 'Makam', '18', NULL, NULL, '08985365597', 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, NULL, NULL, '123049213245', NULL, NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Anton Nazarudin', 'Keputih (0 0)', 'Keputih', 'Makam', '18', NULL, NULL, '08985365597', 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, NULL, NULL, '123049213245', NULL, NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Anton Nazarudin', 'Keputih (0 0)', 'Keputih', 'Makam', '18', NULL, NULL, '08985365597', 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, NULL, NULL, '123049213245', NULL, NULL),
	(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', 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, NULL, NULL, '294212043845', NULL, NULL),
	(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', 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, NULL, NULL, '294212043845', NULL, NULL),
	(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', 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, NULL, NULL, '294212043845', NULL, NULL),
	(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', 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, NULL, NULL, '294212043845', NULL, NULL),
	(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', 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, NULL, NULL, '294212043845', NULL, NULL),
	(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', 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, NULL, NULL, '123049213245', NULL, NULL),
	(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', 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, NULL, NULL, '123049213245', NULL, NULL),
	(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', 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, NULL, NULL, '123049213245', NULL, NULL),
	(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', 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, NULL, NULL, '123049213245', NULL, NULL),
	(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', 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, NULL, NULL, '294212043845', NULL, NULL),
	(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', 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, NULL, NULL, '294212043845', NULL, NULL),
	(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', 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, NULL, NULL, '294212043845', NULL, NULL),
	(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', 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, NULL, NULL, '294212043845', NULL, NULL),
	(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', 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, NULL, NULL, '294212043845', NULL, NULL),
	(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', 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, NULL, NULL, '294212043845', NULL, NULL),
	(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', 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, NULL, NULL, '123049213245', NULL, NULL),
	(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', 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, NULL, NULL, '123049213245', NULL, NULL),
	(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', 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, NULL, NULL, '123049213245', NULL, NULL),
	(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', 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, NULL, NULL, '123049213245', NULL, NULL),
	(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', 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, NULL, NULL, '123049213245', NULL, NULL),
	(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', 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, NULL, NULL, '123049213245', NULL, NULL),
	(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', 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, NULL, NULL, '123049213245', NULL, NULL),
	(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', 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, NULL, NULL, '123049213245', NULL, NULL),
	(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', 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, NULL, NULL, '123049213245', NULL, NULL),
	(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', 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, NULL, NULL, '123049213245', NULL, NULL),
	(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', 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, NULL, NULL, '123049213245', NULL, NULL),
	(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', 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, NULL, NULL, '123049213245', NULL, NULL),
	('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', 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, NULL, NULL, '123049213245', NULL, NULL),
	('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', 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, NULL, NULL, '123049213245', NULL, NULL),
	('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', 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, NULL, NULL, '123049213245', NULL, NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SZ505', NULL, NULL, NULL, 'Anton Nazarudin', 'Jalan Kali Kepunton no.4 (0 00) ( )', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 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, NULL, NULL, 10, NULL, NULL, NULL, '123049213245', '5', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SZ217', NULL, NULL, NULL, 'Troy Wahana', 'Jl Bhaskara Utara B-12 ( )', 'Bhaskara Utara', NULL, '12', NULL, NULL, '08985365597', 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, NULL, NULL, 10, NULL, NULL, NULL, '123049213245', '4', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SZ217', NULL, NULL, NULL, 'Chusnul Chotimah', 'Jl Pandugo PV 16 ( )', 'Pandugo', NULL, 'PV 16', NULL, NULL, '08985365597', 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, NULL, NULL, 10, NULL, NULL, NULL, '123049213245', '5', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SZ114', NULL, NULL, NULL, 'Chusnul Chotimah', 'Jl Pandugo PV 16 ( )', 'Pandugo', NULL, 'PV 16', NULL, NULL, '08985365597', 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, NULL, NULL, 10, NULL, NULL, NULL, '123049213245', '5', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SZ225', NULL, NULL, NULL, 'Chusnul Chotimah', 'Jl Pandugo PV 16', 'Arif Rahman Hakim', 'Makam', '59', NULL, NULL, '08985365597', 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, NULL, NULL, 10, NULL, NULL, NULL, '123049213245', '5', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SZ225', NULL, NULL, NULL, 'Chusnul Chotimah', 'Jl Pandugo PV 16', 'Arif Rahman Hakim', 'Makam', '59', NULL, NULL, '08985365597', 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, NULL, NULL, 10, NULL, NULL, NULL, '123049213245', '5', NULL),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SZ205', NULL, NULL, NULL, 'Chusnul Chotimah', 'Jl Pandugo PV 16', 'Arif Rahman Hakim', 'Makam', '59', NULL, NULL, '08985365597', 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, NULL, NULL, 10, NULL, NULL, NULL, '123049213245', '5', 112.7514877),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SZ205', NULL, NULL, NULL, 'Chusnul Chotimah', 'Jl Pandugo PV 16', 'Arif Rahman Hakim', 'Makam', '59', NULL, NULL, '08985365597', 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, NULL, NULL, 10, NULL, NULL, NULL, '123049213245', '5', 112.7514877),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SZ216', NULL, NULL, NULL, 'Chusnul Chotimah', 'Jl Pandugo PV 16', 'Arif Rahman Hakim', 'Makam', '59', NULL, NULL, '08985365597', 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, NULL, NULL, 10, NULL, NULL, NULL, '123049213245', '5', 112.7940140),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SZ542', NULL, NULL, NULL, 'Chusnul Chotimah', 'Jl Pandugo PV 16', 'Arif Rahman Hakim', 'Makam', '59', NULL, NULL, '08985365597', 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, NULL, NULL, 10, NULL, NULL, NULL, '123049213245', '5', 112.6473465),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SZ542', NULL, NULL, NULL, 'Chusnul Chotimah', 'Jl Pandugo PV 16', 'Arif Rahman Hakim', 'Makam', '59', NULL, NULL, '08985365597', 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, NULL, NULL, 10, NULL, NULL, NULL, '123049213245', '5', 112.6473465),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SZ542', NULL, NULL, NULL, 'Chusnul Chotimah', 'Jl Pandugo PV 16', 'Arif Rahman Hakim', 'Makam', '59', NULL, NULL, '08985365597', 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, NULL, NULL, 10, NULL, NULL, NULL, '123049213245', '5', 112.6503067),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SZ542', NULL, NULL, NULL, 'Chusnul Chotimah', 'Jl Pandugo PV 16', 'Arif Rahman Hakim', 'Makam', '59', NULL, NULL, '08985365597', 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, NULL, NULL, 10, NULL, NULL, NULL, '123049213245', '5', 112.6503067),
	(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', 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, NULL, NULL, 200, NULL, NULL, NULL, '123049213245', '1', 112.7688446),
	(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', 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, NULL, NULL, 200, NULL, NULL, NULL, '123049213245', '1', 112.7688446),
	(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', 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, NULL, NULL, 200, NULL, NULL, NULL, '123049213245', '1', 112.7688446),
	(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', 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, NULL, NULL, 200, NULL, NULL, NULL, '123049213245', '1', 112.7688446),
	(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', 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, NULL, NULL, 200, NULL, NULL, NULL, '123049213245', '1', 112.7688446),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'tidak-bermasalah', NULL, NULL, 'Anton Nazarudin', 'Keputih', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 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, NULL, NULL, 200, NULL, NULL, NULL, '123049213245', '1', 112.7688446),
	(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', 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, NULL, NULL, 200, NULL, NULL, NULL, '123049213245', '1', 112.7688446),
	('T20180000005', NULL, '223', NULL, NULL, NULL, NULL, NULL, 'bermasalah', NULL, NULL, 'Jonathan Rachmadi', 'Jalan Kali Kepunton no.4', 'Keputih', '80', NULL, NULL, NULL, '08985365597', 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, NULL, NULL, 200, NULL, NULL, NULL, '123049213245', '4', 112.7688446),
	('T20180000006', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'bermasalah', NULL, NULL, 'Joshua Kevin', 'Jalan Kali Kepunton no.4', 'Keputih', '80', NULL, NULL, NULL, '08985365597', 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, NULL, NULL, 200, NULL, NULL, NULL, '123049213245', '4', 112.7688446),
	('T20180000004', NULL, '208', NULL, NULL, NULL, NULL, NULL, 'bermasalah', NULL, NULL, 'Joshua Kevin', 'Jalan Kali Kepunton no.4', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 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, NULL, NULL, 200, NULL, NULL, NULL, '123049213245', '4', 112.7688446),
	('T20180000003', NULL, '209', NULL, NULL, NULL, NULL, NULL, 'bermasalah', NULL, NULL, 'Joshua Kevin', 'Jalan Kali Kepunton no.4', 'Keputih', '100', NULL, NULL, NULL, '08985365597', 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, NULL, NULL, 200, NULL, NULL, NULL, '123049213245', '129', 112.6301422),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SZ542', NULL, NULL, NULL, 'Chusnul Chotimah', 'Jl Pandugo PV 16', 'Arif Rahman Hakim', 'Makam', '59', NULL, NULL, '08985365597', 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, NULL, NULL, 10, NULL, NULL, NULL, '123049213245', '4', 112.6503067),
	('T20180000012', NULL, '242', NULL, NULL, NULL, NULL, 'SZ219', 'bermasalah', NULL, NULL, 'dev-diganti', 'Jalan Kali Kepunton no.4', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 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, NULL, NULL, 200, NULL, NULL, NULL, '123049213245', '4', 112.7688446),
	('T20180000016', NULL, '210', NULL, NULL, NULL, NULL, 'SZ222', 'tidak-bermasalah', NULL, NULL, 'Joshua Kevin', 'Jalan Kali Kepunton no.4', 'Keputih', 'Makam', '80', NULL, NULL, '08985365597', 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, NULL, NULL, 200, NULL, NULL, NULL, '123049213245', '1', 112.8036041),
	('T20180000017', NULL, '236', NULL, NULL, NULL, NULL, '219', 'tidak-bermasalah', NULL, NULL, 'asdasd', 'Jalan Kali Kepunton no.4', 'Keputih', 'Perintis', '3A', NULL, NULL, '08985365597', 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, NULL, NULL, 20, NULL, NULL, NULL, '123049213245', '132', 112.7807083),
	(NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'SZ534', NULL, NULL, NULL, 'Arif Rahman', 'Jl Pandugo PV 16', 'Arif Rahman Hakim', 'Makam', '59', NULL, NULL, '08985365597', 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, 900, 12312000, 90, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, '123049213245', '4', 112.6416397);

