SECTOR L DATABASE 1. EXISTING DATABASE

The Study on Comprehensive Water Management of Musi River Basin in the Republic of Indonesia

Sector L Final Report

SECTOR L DATABASE 1.

EXISTING DATABASE

Through the investigation to the database system in South Sumatra Province, it was found that two GIS database system (Forestry Department and BAPPEDA GIS database) and one information network system (INFORKOM MIS) existed, and can be considered to provide GIS database to JICA study. 1.1

BAPPEDA GIS Database

BAPPEDA has used GIS for the spatial planning for a long time. The system software and hardware used in BAPPEDA GIS are PC ArcInfo 3.5, ArcView3.2, Windows98 and Windows NT platforms. However, the system is not running at present because the local GIS consultant company stopped the contract with BAPPEDA. Fortunately, some GIS data are kept back up in CD-ROM, and some data kept in paper format. Therefore, JICA study team could collect the following GIS data from BAPPEDA. 1.1.1 Land Use in 1980 The land use map (scale 1:500,000) in 1980 was collected from BAPPEDA map album. JICA study team converted this paper map to digital GIS data by digitization work, and the area of each land use type was summed up through GIS analysis. The land use map and related table are shown in Annex C4.1.1. It shows almost 19% of whole MUSI river basin (11,605 km2 of 59,354 km2) was covered by natural forest in 1980.

JICA

CTI Engineering International Co., Ltd. NIKKEN Consultants, Inc.

L-1



The specification of land use data was shown on Table L1.1.1. Table L1.1.1 The Data Specification of Land Use 1980 Land Use Type 1 2

Name in BAHASA Indonesia Kampung Perkebunan Rakyat

3

Tegalan

4 5 6 7 10 11 12 13 14 15

Sawah Kebun Campuran Perkebunan Besar HTI Hutan Lebat Belukar Belukar Rawa Rawa Alang-alang Sungai / Danau

Name in English Built-up Area People Plantation Area Dry Land Agriculture Rice Field Mixed Garden Big Plantation Area Forest Plantation Natural Forest Virgin Forest Virgin Forest Swamp Moorland River

Compare Code with Land Use 2000 1 2 3 4 5 6 7 10 1112 1112 13 14 15

1.1.2 Current Land Use The land use data (scale 1:50,000) in 2000 was also collected from BAPPEDA. It was made by BPN through a BAPPEDA project. All the data was separated to 150 map sheets by 1:50,000 index map. JICA study team fixed diversity errors from features and projection, appended all the data together and regenerated it to GIS database which can be analysis by GIS tool. Also, for comparing with land use in 1980, the land use types were also reclassified by JICA study team. Completed land use 2000 map and associated table of each land use type are shown in Annex C4.2.2 of Supporting Report Sector C. The data specification table is shown in Annex L1.1.1. 1.1.3 Current Land Use Planning Based on the law number 24, 1992 and province regulation number 5, 1994. The spatial plan of South SUMATERA Province was established in 1992 and then revised in 1999. The expired time of this plan is 15 years from 1999 to 2014. However, considering the current economic situation of Indonesia, this spatial plan can be fully considered to revise again without big update. Therefore, it is possible to use this spatial plan as in 2020. The data specification of land use planning is shown in Table L1.1.2.

L-2

JICA




Table L1.1.2 The Data Specification of Land Use Planning

1.2

Land Use Planning Code 1 2 3

Re-classed Code 1 2 3

Name in BAHASA Hutan Suaka Alam Hutan Lindung Hutan Produksi Terbatas

4

4

Hutan Produksi Tetap

5

5

6 7 8 9 10 Other

6 7 8 9 10 999

Hutan Produksi yang Dapat Dikonversikan Kawasan Perkebunan Kawasan Transmigrasi Kawasan Tanaman Pangan Pengembangan Irigasi Areal Penggunaan Lain Masih Tumpangsusun diantara 10 rencana di atas

Name in English Wildlife Preserve Forest Preserved Forest Limited Production Forest Remained Production Forest Conversion Production Forest Estate Area Transmigration Area Food Plantation Area Irrigation Development Other Use Area Not Yet Fixed Planning Area

Forest GIS Database

It is a GIS group in forestry department to manage a GIS database, and provide GIS services to forest management group. Even the version of GIS database and system is a little old (PC ArcInfo 3.5 and Arcview3.2), the system is running smoothly and the forest GIS database is kept to be updated year by year. 1.2.1

GIS Capacity Building in Forest Department

The GIS capacity including man power, software, and hardware in Forest Department is shown in Table L1.2.1. Table L1.2.1 Quantities of GIS Engineers, GIS Software and Hardware Engineer GIS Operator Digitizer Operator Computer Operator Remote Sensing Operator Database Management Programmer

1.2.2

Quantities 3 1 5 2

Software Arcview 3.2 PC ArcInfo 3.5.1 ArcInfo 7.2.1 ER Mapper

Unit 3 1 1 1

Hardware Computer Digitizer Plotter Printer

4 1 1 2

1

Idrisi

1

Scanner

1

Laptop

1

1

Unit

GIS Data List in Forest Department

The data collected from forest department is shown in Table L1.2.2. The data specification is shown in Table L1.2.3 to Table L1.2.5.

JICA


L-3



Table L1.2.2 The Data List Collected from Forestry Department (1:250,000 Scale Data) Layer Name in BAHASA Indonesia Sungai Jalan Anotasi Kawasan Hutan Penutupan Lahan/Vegetasi HPH HTI Sungai Polygon Trans Batas Kabupaten Batas Kecamatan Batas Propinsi Kota/Desa/Pemukiman TGHK RTRWP

Layer Name in ENGLISH River Road Annotation Current forest in 2002 Land Cover/Vegetation 1998 Forest concession of Natural Forest, legal logging area Industry Forest Plantation Water body (stream) Transmigration Area Regional boundary District boundary Provincial boundary Town, village, living area Forest Land Use Planning in 1984 Forest Land Use Planning in 1994

Data Specification No Attribute No Attribute No Attribute Table L1.2.3 Table L1.2.4 Table L1.2.5 Code, Name No Attribute Code, Name of Location, Number Type of Border District Name No Attribute No Attribute Code and Name Code and Name

Table L1.2.3 The Data Specification of Current Forest (1:250,000 Scale Data) Forest Code 1001 1002 1003 1004 1005 1007 5001

Forest Name in BAHASA HL HSA HP HPT HPK APL DANAU

Forest Name in English Protection Forest Natural Protection Forest Production Forest Limited Production Forest Conversion Forest Other Land Lake

Table L1.2.4 The Data Specification of Current Land Cover (1:250,000 Scale Data) Code 100 200 400 5001

L-4

Name in BAHASA

Name in English Other Land Protection Forest Production Forest Lake

APL HAS and HL HP, HPT, HPK DANAU

JICA




Table L1.2.5 The Data Specification of Forest Logging (1:250,000 Scale Data) Company Logging Number Code Logging Company Name 0 0 KOPERASI WANAKARYA LESTARI (ex 0 0 PT. INHUTANI V EKS WH 3 0 PT. INHUTANI EKS WH 0 0 PT. INHUTANI EKS 0 0 PT. INHUTANI EKS KMPI SM 4 0 PT. INHUTANI EKS SYLVA 0 0 PT. INHUTANI V 6 0 PT. INHUTANI V 0 0 PT. INHUTANI V 0 0 PT. INHUTANI V (Eks SST) 27 0 PT. INHUTANI V EKS KMPI 27 0 PT. INHUTANI V EKS RJB 28 110702400 PT. INHUTANI V EKS SBJ 30 110701600 PT. INHUTANI V EKSTUAHMEGOW 10 110701600 PT. INHUTANI V EKSTUAHMEGOW 11 110700600 PT. KMPI (DH: BUMI RAYA) 12 0 PT. PPUJ 0 11070 PT. SRIBUNIAN 13 0 PT. WAI HIJAU HUTANI 14 110700202 PT.DAYA PENCA 35 110701101 PT.EKS PENCADANGAN SST 37 110701200 PT.FAMILI JAYA 20 110701300 PT.FATMA BERSAUDARA 15 110701801 PT.INHUTANI EKS PWL 15 110701101 PT.INHUTANI V EKS KMPI 39 110701802 PT.INHUTANI V EKS PWL 0 110702300 PT.SBA WOOD INDUSTRIES 0 110700703 PT.SENTOSA JAYA 0 110700702 PT.SENTOSA JAYA 0 110700701 PT.SENTOSA JAYA 0 110700704 PT.SENTOSA JAYA 18 110702100 PT.SINAR BELANTI JAYA LTD 0 110700400 PT.SRIBUNIAN TRADING CO

1.3

Logging Status No Status No Status No Status No Status No Status No Status No Status No Status No Status No Status No Status No Status Expire Expire Expire Expire No Status No Status No Status Expire Active Active Expire Expire Active Expire Active Active Active Active Active Expire Active

Management Information System (MIS)

By the investigation to Information and Communication Department (KANTOR INFORKOM) of South Sumatra Province, it was found that a network information system is establishing. The system name is Regional Management Information System (MIS). Currently, the central system has already established in KANTOR INFORKOM and linked to Internet. As the same time, a government website has also been set up for introducing profile of the province, major production, tourism and etc. Along with the construction plan, a government Intranet will be established in the future. The system configuration was shown in Annex L1.2.1. In the future, all state government offices will be linked by this Intranet. Then, the GIS database established in JICA study can be shared with other government agencies through this network system.

JICA


L-5


2.


MUSI RIVER BASIN GIS DATABASE ESTABLISHMENT

According with above data collection, the GIS database specification is designed as follows. 2.1

Specification of 1:250,000 GIS Database

The 1:250,000 scale GIS data was collected from Forest Department and BAPPEDA and designed into GIS database as follows. The Table L2.1.1 shows the specification of 1:250,000 scale GIS Database. Table L2.1.1 The Specification of 1:250,000 GIS Database Coverage

Feature Entities Index50k Polygon Index250k Polygon Admin Admin-Line Admin-Poly Admin District

Road Waterbody River Villages Catchment

Admin Region Road-Line River-Poly River-Line Living AreaBasin-Poly

Description

Attributers

1:50,000 Map Index 1:250,000 Map Index International, Province, Region and District

Map No. Map No. Board Type

Feature Class Poly Poly Arc

Poly Code, Name, Population, Region Household in 1990 and Code, Name Region Arc Type Poly Arc Poly Basin Code, Basin Name Poly

District Information Region Information River, Stream and Island

Sub-Basin Information

Annotation Text-Annotation Important Position Name

Level No., Symbol No.

Landuse80 Land-Poly

Type, Name

Annotatio n Poly

Type, Name

Poly

Type, Name Type, Name Type, Name Type, Name Type, Name

Poly Poly Poly Poly Poly

Landuse00 Land-Poly Luplan00 F_Luplan0 F_cover00 F_plantatio F_logging

2.2

Land-Poly Land-Poly Land-Poly Land-Poly Land-Poly

Land Use Information in 1980 Land Use Information in 2000 Current Special Planning Current Forest Planning Current Forest Land Use Forest Plantation Area Regal Forest Logging Area

Specification of 1: 50,000 GIS Database

For 1:50,000 Topographic Data, JICA Study Team purchased the data from BAKOSURTANAL. Totally 150 sheets covered whole South Sumatra Province. The data contents are shown in Table L2.2.1. The data specification of 1:50,000 GIS database are shown in Table L2.2.2.

L-6

JICA




Table L2.2.1 The Layer List of 1: 50,000 GIS Database NO TEMA

ENGLISH

TYPE

KODE NLP

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

Building Utility Built-up Area Living Area Communication Communication Communication Control Point Elevation Point Contour Administrative Administrative Coast Line Hydrology Hydrology Closed Area Important Point

Point Line Polygon Polygon Point Line Polygon Point Point Line Line Polygon Line Line Polygon Polygon Point

B U D S Z K F E T C X A L H P G N

Bangunan Utilitas Bangunan Gedung Pemukiman Komunikasi Komunikasi Komunikasi Titik Kontrol Kontur Titik Kontur Administrasi Adminstrasi Garis Pantai Hidrologi Hidrologi Penutupan Lahan Toponimi

NAME OF COVERAG B1209213 U1209213 D1209213 S1209213 Z1209213 K1209213 F1209213 E1209213 1209-213 T1209213 C1209213 X1209213 A1209213 L1209213 H1209213 P1209213 G1209213 N1209213

Table L2.2.2 The Specification of 1: 50,000 GIS Database NO 1

TEMA/LAYER Struktur/Bangunan Penting/Umum unsure titik (B) Gedung/bangunan/rumah terpencar Stasiun Jembatan jalan Jembatan kereta api Jembatan titian Kantor polisi Masjid Gereja Kelenteng Pura Kantor pemerintah (walikota, kabupaten, kecamatan, desa) Komersial dan industri (pasar, bank, toko, restoran, koperasi)

ENGLISH Structure/Important Building/general, point element (B) Building/house Station Bridge of road Bridge of railway Temporary bridge Police Office Mosque Church Chinese temple Temple Government office

Commercial and industry ( market, bank, shop, restaurant, cooperation ) Sosial dan kesehatan (rumah sakit, Social and healthy ( hospital, post puskesmas, kantor pos, kantor telepon) office. telephone office ) Pendidikan (umum, agama, militer) Education Rekreasi (monumen, museum, cinema) Recreation Pembuangan amunisi Daerah terlarang Restricted area (Continuing)

JICA


CODE NO

111000 244000 241100 241200 241300 111110 112110 112120 112140 112130 113000 114000

115000 116000 117000 118100 118200

L-7



Table L2.2.2 The Specification of 1: 50,000 GIS Database (Continued) NO 1

2

3

4

TEMA/LAYER Struktur/Bangunan Penting/Umum unsure titik (B) (Continued) Daerah latihan Menara Tambang Sumur bahan bakar PLTA PLTU PLTD PLTG Tangki air Tangki bahan bakar Sumber gas alam Sumber air panas Bendungan Lampu navigasi laut Lampu navigasi udara Makam Islam Makam Kristen Makam Umum Makam Hindu Makam Budha Makam Pahlawan Utiliti – linier (U) Kawat listrik tegangan tinggi Kabel darat Kabel laut Kawat telepon/telegram Pipa bahan baker Pipa gas Bangunan Gedung (D)

Area Pemukiman/Bangunan – area (S) Daerah Pemukiman dalam batas-batas ibukota negara Daerah Pemukiman dalam batas-batas ibukota propinsi Daerah Pemukiman dalam batas-batas ibukota kabupaten Pemukiman lain 5 Unsur Komunikasi titik (Z) Tempat berlabuh Larangan berlabuh (Continuing)

L-8

ENGLISH Structure/Important Building/general, point element (B) Military area Monument Mining Recreation Hydro electric power Vapour electric power Diesel electric power Gas electric power Water tank Fuel tank Natural gas resources Hot water resources Dam Sea navigation lamp Air navigation lamp Moslem cemetery Christian cemetery Public cemetery Hindu cemetery Buddhist cemetery Hero cemetery Utility-linear (U) High voltage electricity line Line cable Sea cable Telephone line Fuel pipeline Gas pipeline Built-up Area (D)

CODE NO

118300 124100 123100 232000 123500 123600 123700 123800 124200 124300 123300 123400 650000 124400 124500 112210 112220 112200 112230 112240 112250 710000 711000 712000 720000 730000 740000 Sesuai dengan nilai ketinggian titik

Settlement/Building – area (S) Settlement zone in state border level Settlement zone in province border level Settlement zone in district border level Others settlement

121100

Harbour Restricted harbour

221100 211200

JICA

121200 121300 121500





TEMA/LAYER Unsur Komunikasi Linier ( K ) Jalan Arteri satu jalur Jalan Arteri dua jalur Jalan Kolektor Jalan yang sedang dibangun Jalan Setapak Jalan lain Jalan kereta api tunggal Jalan lori Jalan local Sistem pemisahan lalu lintas Batas sector Unsur Komunikasi areal (F)

ENGLISH

CODE NO 221110 221120 221200 221400 221600 221500 222200 222300 221300 241000 242000

Lapangan terbang internasional Lapangan terbang domestik Lapangan terbang perintis Lapangan terbang militer Dermaga Laut

One Way Arterian Road Two Way Arterian Road Colector road Under construction road Foot path Others road Single railway Small railway Local road Traffic separate system Border of sector Element of Communication area (F) International Airport Domestic Airport Pioneer Airport Military Airport Port

8

Titik Tinggi (E)

Spot height (E)

Sesuai dengan nilai ketinggian titik

9

Unsur titik kontrol (T) Titik tinggi Titik Triangulasi primer Titik triangulasi sekunder Titik triangulasi tersier Titik triangulasi kuarter Titik Astronomi Titik Doppler Garis Kontur ( C )

Spot height point Primary triangulation point Secondary triangulation point Tertiary triangulation point Quartery triangulation point Astronomical point Doppler point Contour line (C)

421000 422100 422200 422300 422400 423000 424000 Sesuai dengan nilai kontur

7

10

11 Administrasi (X) (Continuing)

JICA


231000 232000 233000 234000 249000

Administrative (X)

L-9




TEMA/LAYER Administrasi – Linier (A) Batas negara Batas negara (tidak terlihat) Garis cakupan 12 mil Batas propinsi Batas propinsi (tidak terlihat) Batas kabupaten/kodya Batas kabupaten/kodya (tidak telihat) Batas kecamatan Batas kecamatan (tidak telihat) Batas desa Batas desa (tidak telihat) 13 Garis Pantai – areal (L) Garis pantai 14 Hidrologi – linier (H) Sungai Sungai musiman Terusan/saluran air 15 Hydrology – area (P) Danau Sungai luas/lebar Sungai luas musiman Rawa Empang Tambak Penggaraman 16 Penutupan Lahan 17 Toponimi ( N ) Nama-nama unsur perairan laut Samudera Laut Teluk Selat Lainnya Nama-nama unsure perairan darat Sungai danau Nama-nama unsure rupabumi Pegunungan, gunung, pulau, bukit, tanjung, kepulauan, lembah Lainnya Nama-nama unsure pemukiman Ibukota negara Ibukota propinsi Ibukota kabupaten Ibukota kecamatan Lainnya Nama-nama Zona Administrasi (Continuing)

L - 10

ENGLISH Administrative – Linear (A) State boundaries State boundaries 12 miles boundaries Province boundaries Province boundaries Residence boundaries Residence boundaries District boundaries District boundaries Village boundaries Village boundaries Coast Line- area (L) Coast Line Hydrology – linear (H) River Season River Cannals Hidrologi – aereal (P) Lake Big River Season big river Swamp Pond Embankment Salt land Closed Area Toponimy (N) Name of sea element Ocean Sea Bay Srait Others

CODE NO 510000 510001 511000 520000 520001 530000 530001 540000 540001 550000 540001 631100 610000 613000 611100 620000 610100 613010 634100 634200 634300 634400

911000 911200 911300 91400 911500

River and lake

912000

Mountain, island etc

921000

Others Name of settlement element State capital Province capital Residence capital District capital Others Name of administrative zone

922000

JICA

931000 932000 933000 934000 935000





2.3

TEMA/LAYER Toponimi ( N ) (Continued) Propinsi Kabupaten/kodya Kecamatan Lainnya Nama unsur lain

ENGLISH Toponimy (N) Province Residence District Others Name of others element

CODE NO 942000 943000 944000 945000 951000

The Coordinate System of GIS Database

The coordinate system used in GIS database was designed as UTM (BESSEL spheroid, and DJAKARTA datum) that was shown in Table L2.3.1. It is the same coordinate system that used in the 1:50,000 scale topographic map. The merits of the UTM coordinate system are as follow. (1)

One UTM zone 48 (extended from East Longitude 102 to 108 degrees) can cover whole South Sumatra Province that extended from East Longitude 102 to 105 degrees.

(2)

The unit of UTM coordinate system is meter, so it is easy counted by any GIS analysis.

(3)

It is easy to overlay with other GIS data sources because it is the standard coordinate system used in BAKOSURTANAL. Table L2.3.1 The Coordinate System of GIS Database

JICA

Co-ordinate System

UTM 48 Zone

Map Projection

Transverse Mercator

Ellipsoid (Spheroid)

BESSEL

Datum

BAT (DJAKARTA)

Units

Meter


L - 11


2.4


Image of GIS Database Structure

The files and folders construction of GIS database was designed as Figure L2.4.1.

GIS Database MUSIDB

250k 50k

Index250k

admin

101211

Admin

101212

Road

River

Utility

Other sheets

Other data

Index50k

Contour Control Point Coast ClosedLand Others

Figure L2.4.1 Image of GIS Database Construction

L - 12

JICA


SECTOR L DATABASE 1. EXISTING DATABASE

Recommend Documents