Development of a geographic information system for monitoring work with customers for the supply, maintenance and automation of elevator equipment for LLC «Expert-Agro»
https://doi.org/10.20914/2310-1202-2023-2-17-22
Abstract
As part of the production practice in LLC «Expert-Agro» developed a geographic information system (GIS) for the supply and maintenance of the produced elevator equipment. In the MS Access system, a database of customers has been formed that contains the names of enterprises, addresses and coordinates of their location, contact information, information on orders (purchase, delivery and installation of equipment, maintenance of existing equipment, repair work, etc.). At the same time, a message is automatically generated when the day of completion of the order approaches, which allows you to control the efficiency of working with customers and, if necessary, extend the lead time of the order. In the MS Visual Studio integrated environment, using the gmap.Net library, geolocation was implemented to display customers on the map, which makes it possible to assess the geography of LLC «Expert-Agro» and plan further expansion of interaction. Controlling the location of customers also provides a solution to logistical problems for the supply of equipment. The system additionally provides for the selection of process parameters sensors, actuators, control controllers with input / output modules and other devices for automating the supplied equipment. At present, the GIS database is being filled with information on manufactured equipment and devices that are used in standard automation projects.
About the Authors
M. V. Alekseev
Voronezh State University of Engineering Technologies
Cand. Sci. (Engin.), associate professor, automated control systems for processes and productions department, Revolution Av., 19, Voronezh, 394036, Russia
V. S. Kudryashov
Voronezh State University of Engineering Technologies
Dr. Sci. (Engin.), professor, automated control systems for processes and productions department, Revolution Av., 19, Voronezh, 394036, Russia
A. V. Ivanov
Voronezh State University of Engineering Technologies
Cand. Sci. (Engin.), associate professor, automated control systems for processes and productions department, Revolution Av., 19, Voronezh, 394036, Russia
I. A. Kozenko
Voronezh State University of Engineering Technologies
Cand. Sci. (Engin.), associate professor, automated control systems for processes and productions department, Revolution Av., 19, Voronezh, 394036, Russia
M. O. Ovsenev
Voronezh State University of Engineering Technologies
master student, automated control systems for processes and productions department, Revolution Av., 19, Voronezh, 394036, Russia
References
1. Expert-Agro LLC: about the company. Available at: http://www.expert-agro.ru (in Russian).
2. Kornev A.S., Orobinsky V.I., Sundeev A.A. Influence of operating modes of the sieve mill of a grain cleaning machine on separation efficiency. Bulletin of the Voronezh State Agrarian University. 2013. no. 3. pp. 72-74. (in Russian).
3. Khaidarova Z.R., Salieva O.K. Remote control of grain temperature in elevator silos. Youth and systemic modernization of the country. 2018. pp. 187-189. (in Russian).
4. Ylä-Soini A. Automation of a grain dryer. 2015. (in Russian).
5. Baskakov I.V., Karpenko R.N., Orobinsky V.I. Grain cleaning machines and elevator equipment manufactured by Voronezhselmash LLC. 2018. (in Russian).
6. Alekseev M.V., Ovsenev M.O. Geoinformation system for working with customers for the supply and maintenance of agricultural equipment. Innovative technologies in the food industry: science, education and production. Voronezh, VGUIT, 2023. pp. 334–336. (in Russian).
7. Bakarevich Yu.B., Pushkina N.V. Self-instruction manual MS Office Access 2016. St. Petersburg, BHV-Petersburg, 2017. 480 p. (in Russian).
8. Sharpe J. Microsoft Visual C#. Detailed guide. 8th ed. St. Petersburg, Peter, 2017. 848 p. (in Russian).
9. Alekseev M.V., Kozenko I.A., Ovsenev M.O. Development of a geographic information system for the supply of elevator equipment. Materials of the LXI reporting scientific conference of teachers and researchers of VSUIT for 2022. At 3 hours. Part 2. Voronezh, VGUIT, 2023. pp. 49. (in Russian).
10. Skvortsov V.A. Organization and planning of production. 2013. (in Russian).
11. JSC "EXIS". Available at: http://www.eksis.ru/catalog (in Russian).
12. Grain Automation LLC. Available at: http://www.grainautomation.ru/catalog (in Russian).
13. Costa C., Antonucci F., Pallottino F., Aguzzi J. et al. A review on agri-food supply chain traceability by means of RFID technology. Food and bioprocess technology. 2013. vol. 6. pp. 353-366.
14. Rotz S., Duncan E., Small M., Botschner J. et al. The politics of digital agricultural technologies: a preliminary review. Sociologia ruralis. 2019. vol. 59. no. 2. pp. 203-229. doi: 10.1111/soru.12233
15. Liu X., Wang X., Wright G., Cheng J. C. et al. A state-of-the-art review on the integration of Building Information Modeling (BIM) and Geographic Information System (GIS). ISPRS International Journal of Geo-Information. 2017. vol. 6. no. 2. pp. 53. doi: 10.3390/ijgi6020053
16. Burrough P.A., McDonnell R.A., Lloyd C.D. Principles of geographical information systems. Oxford University Press, 2015.
17. Nurdin N., Pettalongi S.S., Mangasing M. Implementation of Geographic Information System Base On Google Maps API to Determine Bidikmisi Scholarship Recipient Distribution in Central Sulawesi Indonesia. Journal of Humanities and Social Sciences Studies. 2021. vol. 3. no. 12. pp. 38-53.
18. Erfani S.M.H., Danesh S., Karrabi S.M., Shad, R. A novel approach to find and optimize bin locations and collection routes using a geographic information system. Waste Management & Research. 2017. vol. 35. no. 7. pp. 776-785. doi: 10.1177/0734242X17706753
19. Fang S., Da Xu L., Zhu Y., Ahati J. et al. An integrated system for regional environmental monitoring and management based on internet of things. IEEE Transactions on Industrial Informatics. 2014. vol. 10. no. 2. pp. 1596-1605. doi: 10.1109/TII.2014.2302638
20. Shelestov A.Y., Kravchenko A.N., Skakun S.V., Voloshin S.V. et al. Geospatial information system for agricultural monitoring. Cybernetics and Systems Analysis. 2013. vol. 49. pp. 124-132.
Review
For citations:
Alekseev M.V., Kudryashov V.S., Ivanov A.V., Kozenko I.A., Ovsenev M.O. Development of a geographic information system for monitoring work with customers for the supply, maintenance and automation of elevator equipment for LLC «Expert-Agro». Proceedings of the Voronezh State University of Engineering Technologies. 2023;85(2):17-22. (In Russ.) https://doi.org/10.20914/2310-1202-2023-2-17-22
Views:
230
Email this article 
Post a Comment 
