Home>PHP source code>Other categories
Download

REGION

CODE AND DATA OF ADMINISTRATION OF ADMINISTRATION OF GOVERNMENT AND ISLANDS OF INDONESIA ACCORDING TO KEPMEMMANGRI NO 100.1.1-6117 YEAR 2022 Using PHP+MYSQL+AJAX screenshot

Code and Data on Indonesian Government Region in the Database:

  • db/region.sql (the latest regional code data in accordance with the Ministry of Home Affairs No 100.1.1-6117 of 2022)
  • db/archive/region_2022.sql according to Permendagri No. 58 of 2021 (Revised by Kepmendagri No. 050-145 Year 2022)
  • db/archive/region_2020.sql according to Permendagri No. 72 of 2019 (Revised by Kepmendagri No.146.1-4717 of 2020)
  • DB/Archive/Region_2018.SQL according to Permendagri No 137 of 2017
  • DB/Archive/Region_2016.SQL according to Permendagri No. 56 of 2015
  • db/archive/region_level_1_2.sql according to the Ministry of Home Affairs No 100.1.1-6117 of 2022 for provincial and district/city data with coordinates, elevation, timezone, area, population and boundaries

Indonesian Island Code and Data in Database:

  • db/island
  • db/archive/island_2022.sql according to Permendagri No. 58 of 2021 (Revised by Kepmendagri No. 050-145 Year 2022)

Related links

  • Postcode Data vs. Indoensia Government Administration Region Code: https://github.com/cahyadsn/wilayah_kodepos
  • Code Reference Data and Data of Government Administration Region and Island of Indonesia: https://github.com/cahyadsn/wilayah_ref
  • Boundaries Data Based on Indonesian Government Administration Region Code: https://github.com/cahyadsn/wilayah_boundaries

Note:

Data not yet included data changes in the formation of new provinces

  • Law No. 29 of 2022 concerning the Formation of Southwest Papua Province (LN.2022/No.223, TLN No.6831, JDIH.Setneg.go.id: 15 p., 08 December 2022)

Data on the Change of Regional Code for the Establishment of Southwest Papua Province has not been updated data from the Ministry of Home Affairs

Data Kepandagri No 100.1.1-6117 Year 2022

Data Database and Code of Government Administration Areas in accordance with Kepandagri No 100.1.1-6117 of 2022 (region.sql)

id_prov Name Kab city Kec Ex village island status
11 Aceh* 18 5 290 0 6500* 363 Done
12 North Sumatra 25 8 455 693 5417 229 Done
13 West Sumatra* 12 7 179 230 1035* 219* Done
14 Riau 10 2 172 271 1591 144 Done
15 Jambi* 9 2 144 171* 1414* 14 Done
16 South Sumatra* 13 4 241 403* 2855* 24 Done
17 Bengkulu 9 1 129 172 1341 9 Done
18 Lampung* 13 2 229 205 2446* 172 Done
19 Bangka Belitung Islands 6 1 47 84 309 507 Done
21 Riau islands* 5 2 80* 144* 275 2028* Done
31 DKI Jakarta 1 5 44 267 0 113 Done
32 West Java* 18 9 627 646* 5311* 30 Done
33 Central Java* 29 6 576 753 7810* 71 Done
34 In Yogyakarta 4 1 78 46 392 33 Done
35 East Java* 29 9 666 773* 7721* 512* Done
36 Banten 4 4 155 314 1238 81 Done
51 Bali 8 1 57 80 636 34 Done
52 West Nusa Tenggara* 8 2 117 145 1021* 403 Done
53 East Nusa Tenggara* 21 1 315 305* 3137* 609* Done
61 West Kalimantan* 12 2 174 99 2046* 251* Done
62 Central Kalimantan* 13 1 136 139 1432 71* Done
63 South Kalimantan* 11 2 156 144 1872* 165* Done
64 East Kalimantan* 7 3 105 197 841 243 Done
65 North Kalimantan 4 1 55 35 447 196 Done
71 North Sulawesi* 11 4 171 332 1507 353* Done
72 Central Sulawesi 12 1 175 175 1842 1572 Done
73 South Sulawesi* 21 3 313* 793 2266* 370* Done
74 Southeast Sulawesi* 15 2 221* 379* 1908 590 Done
75 Gorontalo 5 1 77 72 657 127 Done
76 West Sulawesi 6 0 69 73 575 69 Done
81 Maluku* 9 2 118 35 1200* 1388* Done
82 North Maluku* 8 2 118 118 1067* 901* Done
91 Papua* 8* 1 105* 51* 948* 527* Done
92 West Papua 12 1 218 95 1742 4520* Done
93+ South Papua+ 4+ 0 82+ 13+ 677+ 7+ Done
94+ Central Papua+ 8+ 0 131+ 36+ 1172+ 50+ Done
95+ Papua Mountains+ 8+ 0 252+ 10+ 2617+ 0 Done
TOTAL* 416 98 7277* 8498* 75265* 17001* Done

)* Data underwent changes from the previous data (Kepandagri Data No. 050-145 Year 2022)

)+ New Data from Kepmendagri No. 100.1.1-6117 Year 2022

) ** The number of islands including 6 large islands (Sumatra, Java, Kalimantan, Sulawesi, Timor and Papua

The demo link can be seen here https://wilayah.cahyadsn.com/v2.6

Reference

  • Reference Document: https://github.com/cahyadsn/wilayah_ref
  • Decree of the Minister of Home Affairs Number 100.1.1-6117 of 2022 concerning the Provision and Updating of Code, Data on Government Administration Areas, and Island (Stipulated on November 9, 2022) *
  • Law No. 14 of 2022 concerning Formation of South Papua Province (LN.2022/No.157, TLN No.6803, JDIH.Setneg.go.id: 15 p., July 25, 2022)
  • Law No. 15 of 2022 concerning the Formation of Central Papua Province (LN.2022/No.158, TLN No.6804, JDIH.Setneg.go.id: 14 p., July 25, 2022)
  • Law No. 16 of 2022 concerning the Establishment of Papua Mountain Province (LN.2022/No.159, TLN No.6805, JDIH.Setneg.go.id: 14 p., July 25, 2022)
  • Decree of the Minister of Home Affairs Number 050-145 of 2022 concerning Code, Data on Government Administration Areas, and Island in 2021 (Kepmendagri No. 050-145 of 2022, https://www.kemendagri.go.id/ansip/detail/10857/keputusi-menteri-megeri-negeri-nomor-050145-tahun-2022-about-Pembaya-Code-Data-Idministration-Administration-Government-Dan-Pulau-Tahun-2021 (set on February 14 2022)
  • Regulation of the Minister of Home Affairs of the Republic of Indonesia Number 58 Year 2021 concerning Code, Data on Government Administration Areas, and Island https://paralegal.id/perangan/perturan-meateri-in-negeri-nomorine-58-year-2021/ (Permendagri No.58 2021, Set on December 13, 2021, State Gazette of 2021 Number 1391)
  • Determination of names, code and number of villages throughout Indonesia in 2020 (Kepmendagri No. 146.1-4717-2020) http://binapemdes.kemendagri.go.id/Produkhukum/detil/keputikan-menteri-the-numor-1461-4717-2020 (stipulated on December 21, 2020)
  • Code and Data of Government Administration Area (Permendagri No.72-2019) https://www.kemendagri.go.id/page/read/48/peteri-menteri-dalam-negeri-no72-tahun-2019 (State Gazette of the Republic of Indonesia Year 2019 Number 1327, set on October 8, 2019)
  • Code and Data of Government Administration Area (Permendagri No.137-2017) http://www.kemendagri.go.id/Produk-hukum/2018/01/18/kode-dan-data-data-data-dministration-dministration- government-year-2017 (State Gazette of the Republic of Indonesia Number 1955, set on December 27, 2017)
  • Code and Data of Government Administration Area (Permendagri No.56-2015) www.kemendagri.go.id/pages/data-wilayah (State Gazette of the Republic of Indonesia 2015 Number 1045, Set on June 29, 2015)

To do

  • Update Main Web Demo With Data Based on Kepandagri No 100.1.1.6117 Year 2022 (Dev)
  • Update to play web demo with openstreemap + leafletjs (dev)
  • Add API to regional code data to https://api.cahyadsn.com/ (dev)
  • Demo to v3.0 (on progress) web update
    • Displays Postcode data
    • Displays regional code data in the sidebar

Change log

  • Demo to v2.6 web update with data based on Kepandagri No 100.1.1.6117 Year 2022 (Done 2024-05-15)
    • Data levels 1 and 2 based on Kepandagri No. 100.1.1.6117 Year 2022
  • Update Data Region_level_1_2.SQL Based on Kepmendagri No 100.1.1.6117 Year 2022 (Done 2024-04-30)
  • Verify Data Change and Improvement (Done)
  • Update Regional Code Data Based on Kepandagri No 100.1.1.6117 Year 2022 (Done)
  • Update Island Code Data Based on Kepandagri No 100.1.1.6117 Year 2022 (Done)
  • Move the previous regional and island code database to the DB/Archive (Done) folder
  • Demo Web Update to v2.5.1 (Done)
    • encrypted polygon data
  • Update web demo to v2.4 (Done)
  • Update and additional data on the number of population and area of ​​the data area level 1 and 2 (Done)
  • Update Data Based on Permendagri No.58 Year 2021 & Kepmendagri No. 050-145 Year 2022 (Done)
  • Update Data Based on Kepmendagri No.146.1-4717 of 2020 (Done)
  • Demo to v2.3 (Done) web update
  • Data Update on Web Demo (Done)
  • Addition of data elevation data on level 1 and 2 regions (Done)
  • Update Data Changes in Sub -District Name, Kelurahan/Village (Done)
  • Data updates on the Demo V2 web (level 1 and 2) (Done)
  • Update Boundaries Data Data Region_level_1_2.SQL (Done)
  • Update Latitude/Longitude Data Data Data_level_1_2.SQL (Done)
  • Add the wilayal_level_1_2.sql database (provincial and district/city level data with coordinates, timezone and boundaries) (Done)
  • Update data to regional code and data based on Permendagri No. 72 of 2019 SMP with Kelurahan/Village level (DONE)
  • Update data to regional code and data based on Permendagri No. 137 of 2017 junior high school/village level (Done)
  • On Progress, Convert Data from PDF-> XLSX (Done), XLSX-> CSV (Done), CSV-> SQL (Done), Import SQL to DB (Done), Validation of Data in DB with Source (Done)

Information

  • Polygon data obtained from the BIG (Geospatial Information Agency) website at https://tanahair.indonesia.go.id
  • Latitude/Longitude Data from Google Maps

Donation

  • for donations via transfer
    • Indonesian Islamic Bank (BSI) 821-342-5550
    • Bank Sinarmas (153) 005 462 4719
    • Bank BCA Digital (BLU) (501) 000 576 776 186
  • For donations via paypal [https://paypal.me/cahyadwiana]
Expand
Additional Information
Related Applications
Recommended for You
Related Information All