107 lines
4.1 KiB
SQL
107 lines
4.1 KiB
SQL
-- phpMyAdmin SQL Dump
|
|
-- version 5.2.3
|
|
-- https://www.phpmyadmin.net/
|
|
--
|
|
-- Host: localhost:3306
|
|
-- Generation Time: Jun 11, 2026 at 11:13 AM
|
|
-- Server version: 8.4.3
|
|
-- PHP Version: 8.3.30
|
|
|
|
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
|
|
START TRANSACTION;
|
|
SET time_zone = "+00:00";
|
|
|
|
|
|
/*!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 */;
|
|
/*!40101 SET NAMES utf8mb4 */;
|
|
|
|
--
|
|
-- Database: `03_webgisdb`
|
|
--
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Table structure for table `jalan`
|
|
--
|
|
|
|
CREATE TABLE `jalan` (
|
|
`id` int NOT NULL,
|
|
`nama_jalan` varchar(150) NOT NULL,
|
|
`status_jalan` enum('nasional','provinsi','kabupaten') NOT NULL,
|
|
`panjang_meter` double NOT NULL,
|
|
`geojson` longtext NOT NULL,
|
|
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
|
|
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
|
|
--
|
|
-- Dumping data for table `jalan`
|
|
--
|
|
|
|
INSERT INTO `jalan` (`id`, `nama_jalan`, `status_jalan`, `panjang_meter`, `geojson`, `created_at`, `updated_at`) VALUES
|
|
(1, 'Gg. Pak Cik', 'kabupaten', 169.77, '{\"type\":\"Feature\",\"properties\":{},\"geometry\":{\"type\":\"LineString\",\"coordinates\":[[109.34135,-0.055498],[109.342616,-0.056351]]}}', '2026-06-08 12:30:39', '2026-06-08 12:30:39'),
|
|
(2, 'Jl. Trans Kalimantan', 'nasional', 5544.23, '{\"type\":\"Feature\",\"properties\":{},\"geometry\":{\"type\":\"LineString\",\"coordinates\":[[109.374583,-0.069933],[109.375999,-0.068258],[109.379303,-0.064651],[109.380591,-0.063685],[109.381771,-0.062891],[109.383423,-0.061517],[109.385548,-0.059992],[109.386578,-0.059327],[109.387114,-0.059048],[109.387758,-0.058833],[109.38868,-0.058318],[109.389496,-0.058038],[109.390697,-0.05748],[109.391813,-0.056815],[109.393015,-0.056128],[109.394302,-0.055677],[109.39559,-0.055226],[109.396598,-0.054882],[109.397478,-0.054603],[109.398851,-0.054324],[109.401062,-0.053723],[109.401855,-0.053465],[109.402649,-0.052907],[109.403057,-0.052284],[109.403958,-0.049257],[109.405246,-0.044942],[109.406469,-0.041313],[109.406598,-0.04054],[109.406598,-0.039338],[109.406254,-0.038694],[109.406254,-0.038221],[109.406641,-0.038178],[109.406984,-0.038565]]}}', '2026-06-08 12:34:53', '2026-06-08 12:34:53');
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Table structure for table `parsil_tanah`
|
|
--
|
|
|
|
CREATE TABLE `parsil_tanah` (
|
|
`id` int NOT NULL,
|
|
`nama_parsil` varchar(150) NOT NULL,
|
|
`status_kepemilikan` enum('SHM','HGB','HGU','HP') NOT NULL,
|
|
`luas_meter` double NOT NULL,
|
|
`geojson` longtext NOT NULL,
|
|
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
|
|
`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
|
|
--
|
|
-- Dumping data for table `parsil_tanah`
|
|
--
|
|
|
|
INSERT INTO `parsil_tanah` (`id`, `nama_parsil`, `status_kepemilikan`, `luas_meter`, `geojson`, `created_at`, `updated_at`) VALUES
|
|
(1, 'kavling A1', 'HP', 1239.31, '{\"type\":\"Feature\",\"properties\":{},\"geometry\":{\"type\":\"Polygon\",\"coordinates\":[[[109.339339,-0.060625],[109.339548,-0.060442],[109.339803,-0.060689],[109.339575,-0.060877],[109.339339,-0.060625]]]}}', '2026-06-08 12:30:03', '2026-06-08 12:30:03');
|
|
|
|
--
|
|
-- Indexes for dumped tables
|
|
--
|
|
|
|
--
|
|
-- Indexes for table `jalan`
|
|
--
|
|
ALTER TABLE `jalan`
|
|
ADD PRIMARY KEY (`id`);
|
|
|
|
--
|
|
-- Indexes for table `parsil_tanah`
|
|
--
|
|
ALTER TABLE `parsil_tanah`
|
|
ADD PRIMARY KEY (`id`);
|
|
|
|
--
|
|
-- AUTO_INCREMENT for dumped tables
|
|
--
|
|
|
|
--
|
|
-- AUTO_INCREMENT for table `jalan`
|
|
--
|
|
ALTER TABLE `jalan`
|
|
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
|
|
|
|
--
|
|
-- AUTO_INCREMENT for table `parsil_tanah`
|
|
--
|
|
ALTER TABLE `parsil_tanah`
|
|
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
|
|
COMMIT;
|
|
|
|
/*!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 */;
|