120 lines
16 KiB
SQL
120 lines
16 KiB
SQL
-- MySQL dump 10.13 Distrib 8.0.30, for Win64 (x86_64)
|
|
--
|
|
-- Host: localhost Database: webgis_sig
|
|
-- ------------------------------------------------------
|
|
-- Server version 8.0.30
|
|
|
|
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
|
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
|
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
|
/*!50503 SET NAMES utf8mb4 */;
|
|
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
|
/*!40103 SET TIME_ZONE='+00:00' */;
|
|
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
|
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
|
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
|
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
|
|
|
--
|
|
-- Table structure for table `data_jalan`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `data_jalan`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `data_jalan` (
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
`nama_jalan` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Nama ruas jalan',
|
|
`status_jalan` enum('Jalan Nasional','Jalan Provinsi','Jalan Kabupaten') COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Status / klasifikasi jalan',
|
|
`panjang_m` decimal(12,2) DEFAULT '0.00' COMMENT 'Panjang jalan dalam meter (dihitung otomatis oleh LeafletJS)',
|
|
`geojson` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Geometri LineString dalam format GeoJSON',
|
|
`keterangan` text COLLATE utf8mb4_unicode_ci COMMENT 'Keterangan tambahan',
|
|
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
|
|
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `data_jalan`
|
|
--
|
|
|
|
LOCK TABLES `data_jalan` WRITE;
|
|
/*!40000 ALTER TABLE `data_jalan` DISABLE KEYS */;
|
|
INSERT INTO `data_jalan` VALUES (1,'Jl. Sudirman','Jalan Nasional',1250.50,'{\"type\":\"LineString\",\"coordinates\":[[106.8272,-6.2088],[106.8290,-6.2075],[106.8310,-6.2060],[106.8330,-6.2045]]}','Jalan protokol pusat kota','2026-06-08 08:59:28','2026-06-08 08:59:28'),(2,'Jl. Gatot Subroto','Jalan Provinsi',980.00,'{\"type\":\"LineString\",\"coordinates\":[[106.8200,-6.2100],[106.8220,-6.2095],[106.8240,-6.2090],[106.8260,-6.2085]]}','Penghubung antar kecamatan','2026-06-08 08:59:28','2026-06-08 08:59:28'),(3,'Jl. Pramuka','Jalan Kabupaten',620.75,'{\"type\":\"LineString\",\"coordinates\":[[106.8150,-6.2180],[106.8160,-6.2170],[106.8175,-6.2160],[106.8185,-6.2150]]}','Jalan lingkungan kabupaten','2026-06-08 08:59:28','2026-06-08 08:59:28');
|
|
/*!40000 ALTER TABLE `data_jalan` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `data_parsil`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `data_parsil`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `data_parsil` (
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
`nama_parsil` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Nama / nomor parsil',
|
|
`status_hak` enum('Sertifikat Hak Milik','Sertifikat Hak Guna Bangunan','Sertifikat Hak Guna Usaha','Sertifikat Hak Pakai') COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Status kepemilikan / hak atas tanah',
|
|
`luas_m2` decimal(15,2) DEFAULT '0.00' COMMENT 'Luas tanah dalam meter persegi (dihitung otomatis oleh LeafletJS)',
|
|
`geojson` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Geometri Polygon dalam format GeoJSON',
|
|
`pemilik` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Nama pemilik (opsional)',
|
|
`keterangan` text COLLATE utf8mb4_unicode_ci COMMENT 'Keterangan tambahan',
|
|
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
|
|
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `data_parsil`
|
|
--
|
|
|
|
LOCK TABLES `data_parsil` WRITE;
|
|
/*!40000 ALTER TABLE `data_parsil` DISABLE KEYS */;
|
|
INSERT INTO `data_parsil` VALUES (1,'Parsil A-001','Sertifikat Hak Milik',1200.00,'{\"type\":\"Polygon\",\"coordinates\":[[[106.8200,-6.2000],[106.8210,-6.2000],[106.8210,-6.2010],[106.8200,-6.2010],[106.8200,-6.2000]]]}','Budi Santoso','Tanah kavling perumahan','2026-06-08 08:59:28','2026-06-08 08:59:28'),(2,'Parsil B-002','Sertifikat Hak Guna Bangunan',850.50,'{\"type\":\"Polygon\",\"coordinates\":[[[106.8220,-6.2000],[106.8230,-6.2000],[106.8230,-6.2008],[106.8220,-6.2008],[106.8220,-6.2000]]]}','PT. Maju Bersama','Kavling komersial','2026-06-08 08:59:28','2026-06-08 08:59:28'),(3,'Parsil C-003','Sertifikat Hak Guna Usaha',2500.00,'{\"type\":\"Polygon\",\"coordinates\":[[[106.8240,-6.1990],[106.8260,-6.1990],[106.8260,-6.2010],[106.8240,-6.2010],[106.8240,-6.1990]]]}','CV. Tani Makmur','Lahan pertanian/perkebunan','2026-06-08 08:59:28','2026-06-08 08:59:28'),(4,'Parsil D-004','Sertifikat Hak Pakai',4000.00,'{\"type\":\"Polygon\",\"coordinates\":[[[106.8270,-6.1985],[106.8295,-6.1985],[106.8295,-6.2005],[106.8270,-6.2005],[106.8270,-6.1985]]]}','Pemerintah Kota','Lahan fasilitas umum','2026-06-08 08:59:28','2026-06-08 08:59:28');
|
|
/*!40000 ALTER TABLE `data_parsil` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `data_spbu`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `data_spbu`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `data_spbu` (
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
`nama_spbu` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Nama SPBU / nama cabang',
|
|
`telepon` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Nomor telepon SPBU',
|
|
`buka_24jam` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1 = buka 24 jam (marker hijau), 0 = tidak (marker merah)',
|
|
`lat` decimal(10,7) NOT NULL COMMENT 'Latitude titik SPBU',
|
|
`lng` decimal(10,7) NOT NULL COMMENT 'Longitude titik SPBU',
|
|
`geojson` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Geometri Point dalam format GeoJSON',
|
|
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
|
|
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `data_spbu`
|
|
--
|
|
|
|
LOCK TABLES `data_spbu` WRITE;
|
|
/*!40000 ALTER TABLE `data_spbu` DISABLE KEYS */;
|
|
INSERT INTO `data_spbu` VALUES (1,'SPBU Jl. Ahmad Yani','0561-123456',1,-0.0200000,109.3300000,'{\"type\":\"Point\",\"coordinates\":[109.3300,-0.0200]}','2026-06-08 08:59:28','2026-06-08 08:59:28'),(2,'SPBU Jl. Gajah Mada','0561-654321',0,-0.0350000,109.3200000,'{\"type\":\"Point\",\"coordinates\":[109.3200,-0.0350]}','2026-06-08 08:59:28','2026-06-08 08:59:28'),(3,'SPBU Jl. Tanjungpura','0561-789012',1,-0.0100000,109.3450000,'{\"type\":\"Point\",\"coordinates\":[109.3450,-0.0100]}','2026-06-08 08:59:28','2026-06-08 08:59:28'),(4,'SPBU Jl. Sutan Syahrir','0561-345678',0,-0.0480000,109.3380000,'{\"type\":\"Point\",\"coordinates\":[109.3380,-0.0480]}','2026-06-08 08:59:28','2026-06-08 08:59:28');
|
|
/*!40000 ALTER TABLE `data_spbu` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
|
|
|
|
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
|
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
|
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
|
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
|
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
|
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
|
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
|
|
|
-- Dump completed on 2026-06-09 20:36:15
|