Computerized database for optimal management of community irrigation systems in Thailand

Abstract Appropriate information is a pre-requisite for improving the management of irrigation systems. An effort was made to establish the information system required in management of an irrigation unit at the tertiary level (Ban-Rom Water Users' Association, Thailand). A computerized database was developed for use on a microcomputer using the combination of a commercial database management system and a linear programming optimizer. This information system was simple to operate through the use of menu-driven procedures. This database system can replace the previous manual system for data recording and retrieval of information related to the management of agricultural organizations and related irrigation aspects. The optimal solution for cropping pattern and water allocation obtained from the system can be used as a guideline in pre-season planning for irrigation delivery and crop selection.