LINKING EARTH OBSERVATION DATA AND SPATIAL DATABASE FOR MONITORING AND ESTIMATING SUGARCANE YIELD

摘要

The Philippine Sugarcane Regulatory Administration (SRA) is mandated to promote the growth and development of the sugar industry in the country. One of its objectives is to develop a geospatial information database covering the entire areas of operation. A spatial decision support system for the organization is necessary to address environmental and economic considerations for sugarcane yield estimation and sugar price regulation. Diverse environmental, spatial, temporal and social factors results in varying data types, I/O and information extraction and thus limits the possibility being able to query large database of related data where decision can be based. This research proposed a Unified Modelling Language (UML) design to aid the organization in data creation, input and update. This research used PostgreSQL as the Object Relational Database Management System with PostGIS extension to handle spatial objects. The organization responded very well to this simple yet powerful object relational and spatial database structure and has helped them retrieve and query vital information necessary for everyday decision making.