The integration of non-spatial to spatial database

Pengintegrasian non-spatial to spatial database

Ramai orang kalau boleh, ingin melihat maklumat non-spatialnya dipaparkan secara spatial. Ini adalah kerana kajian neurologi mendapati manusia tidak memikir dengan huruf tetapi dengan grafik. Apabila bila kita ingin mengintegrasikan pangkalan data non-spatial kepada spatial tentu la kedua-kedua pangkalan data perlu sediakan dulu. Disini kami berjaya mengexperimentkan gabungan  data spatial dan data non-spatial berdasarkan format spreadsheet menggunakan LibreOffice Calc (Ubuntu) dan akan digabungkan dengan data attribute table spatial. Apa yang dibuat adalah menentukan ID yang sama bagi memudahkan pengintegrasian data. Seterusnya, menggunakan Data Management Tool iaitu "Join Attribute" untuk mencantumkan kedua-dua pangkalan data dan hasilnya adalah seperti diatas. Simple, successful..and free!

The integration of non-spatial to spatial database

Many people, if possible, would like to have their non-spatial database viewed spatially. This is because neurology studies found that humans do not think with words but with graphics. When we want to integrate non-spatial database to spatial, of course both database must first be prepared.  Here we successfully experimented the merging of spatial and non-spatial data based on a spreadsheet format using LibreOffice Calc (Ubuntu) and merge it with the spatial data's attribute table. What was needed was to fix the same ID to help make possible data integration. This followed with the Data Management Tool called "Join Attribute" to join both database and the result is as follows. Simple, successful ... and free!