edwin/database-kodepos-seluruh-indonesia

Stars
104
Rank 330,604 (Top 7 %)
Language
Created over 9 years ago
Updated almost 3 years ago

edwin/database-kodepos-seluruh-indonesia

edwin

There are no reviews yet. Be the first to send feedback to the community and the maintainers!

SQL Dump untuk data kodepos seluruh Indonesia (MySQL)

Indonesian Postal Code Database

Tools

DB - MySql

Query

SELECT
	kelurahan,
	kecamatan,
	kabupaten,
	provinsi
FROM
	tbl_kodepos
WHERE
	kodepos = ?

History

Aug 2015 - List of postalcodes are provided from PT Pos Indonesia (http://www.posindonesia.co.id/), with 81.248 kodepos data. File name = tbl_kodepos.sql

Dec 2021 - Grabbing kodepos data from BPS website (https://sig.bps.go.id/bridging-kode/index), resulting in 69.498 kodepos data. File name = tbl_kodepos_bps.sql

Q&A

Q : Why number of kodepos data from PT Pos and BPS is different?

A : I dont know.

Q : Which data is the correct one?

A : I also dont know.

Q : Why some kelurahan can have more than one kodepos in BPS data?

A : I dont know why.

Disclaimer

This data is provided "as is" without any guarantee whatsoever. 
Feel free to fork, tinker, add, remove, change, or do whatever you want to it.

java-keycloak-integration

A simple integration example between Java apps and Keycloak, thru REST API

spring-3-keycloak

Spring Boot 3, Spring Security, and Keycloak integration

GISService

GIS Service to fetch Indonesian's Province, Regency and Sub-District list

database-wilayah-kemendagri

Database kode dan nama kewilayah untuk Kemendagri update 2021

keycloak-password-encryptor

an SPI or plugin to do a simple password encryption-decryption for Keycloak or Red Hat Single Sign-On (RHSSO)

keycloak-backchannel-logout

Keycloak Backchannel Logout Integration with Spring Boot and Spring Security

xadatasource-demo

A simple JavaEE demo displaying ability to do a 2 phase commit using Bitronix Transaction Manager - SpringMVC - Hibernate

spring-boot-and-wkhtmltopdf

a sample spring boot, wkhtmltopdf, and ubi8 container to generate a PDF report.

SpringMyBatisIntegration

Spring MVC and MyBatis Database Transaction Example

sonarqube-on-openshift-4

An Openshift Template to deploy Sonarqube to Openshift 4

bps-data-scrapper

A Java app for scrapping various data from BPS website (https://sig.bps.go.id/)

quarkus-calculator

a calculator app, created with quarkus, mysql, and html + js. Displaying a CRUD functionalities on quarkus.

quarkus-hello-world

A simple hello-world rest API involving MySQL database connection for CRUD purpose

hello-world-java-docker

A simple containerized "hello world app" with spring boot

java-app-and-tekton-pipeline-sample

A Java app (Spring Boot) build and deployment to Openshift by using Tekton Pipeline

infrastructure-as-a-code-using-kustomize

managing the structure of multi environment namespaces by using kustomize

spring-boot-jpa-jasypt

a simple database encryption on spring boot, jpa and jasypt

spring-boot-and-infinispan-http-session

Spring Boot, Spring Security, and Infinispan integration for HTTP Session

dynamic-spring-boot-configuration-on-openshift-4

Using Spring Boot and Spring Cloud to reload application's configuration from OpenShift ConfigMap

spring-boot-kafka-hello-world

a simple hellow world app for integrating between kafka and spring boot

spring-boot-jpa-aspectj-encryption

Encrypt database fields on Spring Boot and JPA using AspectJ

spring-boot-3-and-resilience4j

A Simple demo on how to integrate Spring Boot 3 and Resilience4j

containerized-hello-world-python

deploying a containerized python app, with Flask framework and Dockerfile into Openshift 4

php-hello-world-openshift

Hello World on PHP, for testing Openshift new-app deployment

containerized-hello-world-php

Create a very simple PHP app, containerized it, and deploy it into Openshift 4

anime-work-item-handler

A very simple RHPAM WorkItemHandler for handling a rest api call

quarkus-with-spring-api-example

A simple Quarkus with Spring Boot API syntax

jvm16-pentaho

MovieFolderIconify

Create A Costumized Icon on your Movie Folder

CachingWithSpringMVC

Belajar Caching dengan SpringMVC 4

hello-world-flask

Deploying a Flask app to OpenShift by using s2i build

ose-jenkins-agent-maven-helm

Jenkins agent image, for build and deploy Java apps using Helm

spring-boot-display-image

simple display image app using spring boot

sequential-unit-testing

How to create a sequential unit testing by using JUnit 5

pizza-store

a pizza store app for Domain Driven Design exercise

fuse-http-timer

a fuse project for doing a background http echo rest api request

JWP02

HTTP Request using JSP and Servlet

spring-boot-jks

A sample Spring Boot app with SSL from a JKS file. We can later put JKS file and JKS password in OpenShift 4 secret.

rhpam-loan-validation-sample-with-dmn

A simple example on how to integrate DMN with Workflow on RHPAM

quarkus-flyway

A Quarkus app, for simulating a multi-tenancies application with database integration

quarkus-camel-3

Sample Quarkus and Camel 3

frontend-for-approval-rhpam

A Frontend written in Golang for showing how approval is being done on RHPAM

amq-message-interceptor

A simple java class to intercept and read JMS messages on Red Hat AMQ

insta-on

a java web app for displaying Instagram follows/follower list, built with Quarkus

quarkus-artemis

sample code for connecting quarkus to Red Hat AMQ Broker using Artemis, everything is on OCP 4

golang-rest-hello-world

a simple golang multi-stage build on top of OCP 4

spring-infinispan-rest-api

Connecting Spring Boot with Infinispan and a Database (MySql or Oracle), and call it from Rest API

prometheus-and-grafana-openshift4-template-yml

YML file for Prometheus and Grafana installation

hello-world-snowdrop

A sample hello-world app using Snowdrop (snowdrop.dev), a cloud native Spring Boot application

red-hat-ecommerce

a simple ecommerce application for microservice example

IndonesianNIKCheck

A simple Java crawler to check your NIK based on KPU's Data.

test-java-calling-insecure-rest-api

spring-boot-keycloak-x509

Spring Boot, Spring Security, Keycloak, and X509 Authentication

spring-security-3-sample

Spring Boot 3, Spring Security, and Spring JPA Integration

quarkus-graceful-shutdown

Simulating a graceful shutdown using Quarkus