A district and county level agricultural travel ecological product value realization big data platform

Abstract

This invention discloses a big data platform for realizing the value of agricultural tourism ecological products at the district / county level. It adopts an MVVM architecture, with the backend developed based on .NET and the frontend using Vue, HTML5, CSS3, and integrated Echarts. The database uses PostgreSQL with PostGIS, relying on ArcGIS Server for GIS services and implementing map integration through the ArcGIS API for JavaScript. The platform incorporates core accounting models for GEP (Gross Ecological Product) total value, water conservation, and ecological vouchers, including agricultural tourism ecological product surveys, ecological product value calculation, automatic value calculation, ecological voucher agricultural tourism value conversion, database updates, and user management. The platform enables visualization of various agricultural tourism ecological data charts, display of resource survey map data, and GIS spatial statistics of value and functional quantities. It supports multi-scope calculations for administrative regions, scenic areas, and custom areas, and can perform comparisons of two phases of land use data and visualized calculations of ecological vouchers. It also features ecological data year management, editing and updating, and user hierarchical permission control functions. This platform improves the standardization and intelligence of agricultural tourism ecological value management at the district / county level.

Description

Technical Field

[0001] This invention belongs to the field of digital management of ecological resources and value accounting of ecological products, and in particular relates to a big data platform for realizing the value of agricultural and tourism ecological products at the district and county level. Background Technology

[0002] Ecological products are classified into three categories: material supply, cultural services, and ecological regulation. They have been widely used in government ecological decision-making, land spatial planning, land development assessment, and agricultural tourism industry operations. There is an urgent need to rely on digital and intelligent technologies to realize the quantification of the value of ecological products, spatial visualization, and market value transformation.

[0003] Currently, there are still significant technical shortcomings in the value accounting and information management of ecological and agricultural tourism sectors at the district and county levels: Traditional ecological product value accounting relies heavily on manual data collection and statistics, lacking GIS spatial overlay analysis and automatic accounting models, resulting in low accounting efficiency and large human errors; existing systems are mostly based on simple tables and reports, lacking the ability to visualize through maps and multi-dimensional charts, and cannot intuitively display the spatial distribution of ecological products, regional value differences, and land use structure; various ecological survey data, land use data, and cultural tourism resource data are stored in a scattered manner, with inconsistent definitions and delayed updates, lacking a unified spatial database and centralized operation and maintenance portal; at the same time, they generally lack functions for land use time series comparison, automatic ecological voucher accounting, and quantitative conversion of agricultural tourism value, making it difficult to translate ecological value into tradable and assessable quantitative indicators; in addition, most platforms do not have hierarchical permission and login control mechanisms, making data easily tampered with and leaked, and most adopt outdated monolithic architectures with poor scalability, making it difficult to adapt to the dynamic needs of district and county ecological management and agricultural tourism industry development. Clearly, existing manual accounting suffers from technical drawbacks such as inefficiency, large errors, insufficient spatial visualization capabilities, scattered data making operation and maintenance difficult, inability to quantify and realize ecological value, lack of security permissions, and weak architectural scalability. Summary of the Invention

[0004] The purpose of this invention is to provide a big data platform for realizing the value of agricultural tourism and ecological products at the district and county level, so as to solve the technical problems mentioned in the background.

[0005] To achieve the above objectives, the present invention provides the following technical solution: A big data platform for realizing the value of agricultural tourism and ecological products at the district and county level is proposed. The platform adopts an MVVM system architecture, with the backend developed on the .NET platform and the frontend using HTML5, CSS3, JavaScript, and Vue frameworks, integrating the Echarts visualization tool. The database uses PostgreSQL with PostGIS spatial extension, the GIS server is deployed on ArcGIS Server, and the frontend connects to GIS services through ArcGIS API for JavaScript. The platform has built-in accounting models, including the Gross Ecological Product (GEP) model: GEP = EPV + ERV + ECV, the Water Conservation Accounting Model: Qwr = Σ(Pi - Ri - ETI) × Ai, and the Ecological Voucher Accounting Model: ΔMt = ΣΔAi × ki. The platform includes six core functional modules: homepage module, agricultural tourism and ecological product survey module, agricultural tourism and ecological product value module, automatic value calculation module, ecological voucher / agricultural tourism value conversion calculation module, database update and user management module; The homepage module is used to convert the output, area, value, and spatial distribution data of agricultural and tourism material supply, cultural services, and regulatory services at the district and county levels into charts to visually display the total value of the city, the value distribution of administrative regions, and the trend of indicator proportions. The agricultural tourism ecological product survey module uses a combination of maps and charts to display survey information on agricultural tourism products categorized into material supply, cultural services, and ecological regulation services. It supports detailed queries by region, location, and scenic spot. The agricultural tourism ecological product value module enables GIS map visualization of ecological product value and function, bar chart statistics of value and function for each administrative region, and pie chart statistics of value and function for each type of land / scenic spot. The automatic value calculation module supports the selection of three calculation ranges: administrative region, scenic area, and custom agricultural tourism area. It enables the overlay and statistical analysis of ecological products and selected areas, automatic calculation of the value and function of agricultural tourism ecological products, and visualization of results in multiple forms. The ecological voucher / agricultural tourism value conversion accounting module supports uploading and comparing two phases of land use data. Based on land use changes and agricultural tourism project input-output data, it automatically completes ecological voucher accounting and spatial visualization of results. The database update and user management module includes a database update unit and a user management unit. The database update unit enables the selection, visualization, editing, addition, and batch clearing of year data for material categories, cultural services categories, citywide value, and adjustment service value. The user management unit enables the display, addition, editing, deletion, and hierarchical control of user information and login permissions.

[0006] Furthermore, the platform deployment and operation environment includes both hardware and software environments. The software environment requires the configuration of the .NET development platform, ArcGIS Desktop 10.2, ArcGIS Server 10.2, PostgreSQL, PostGIS, and the Vue framework. The hardware environment includes the client and server: the client requires an Intel Core i5 or higher processor, 16GB of RAM, and 512GB or more of available hard disk space; the server requires a TS80X model, a Xeon E2224G quad-core 3.5GHz processor, and 32GB or more of RAM.

[0007] Furthermore, the PostgreSQL configuration for PostGIS spatial extensions loads dependent libraries such as libeay32.dll, libiconv-2.dll, and libpq.dll, as well as the st_geometry.dll file, to achieve ArcGIS and PostgreSQL spatial database adaptation, supporting spatial database creation, layer connection, and spatial data storage.

[0008] Furthermore, the agricultural tourism ecological product survey module includes four categories of data display for material supply: aquatic products, fruits, grains, and "two products and one standard" (referring to products with national standards and designated geographical indications). Each category includes a brief introduction, a map, and a bar chart visualizing the yield and area. The cultural service category includes cultural overview, scenic spot map annotations, and a single scenic spot's text and image carousel introduction. The regulation service category includes cross-sectional water quality label display, overview of seven types of ecological land use (cultivated land, orchard, forest land, wetland, etc.), soil attributes, slope, and multi-dimensional map visualization of land use rights and attributes. It also supports switching between the basic layers of the three zones and three lines, satellite imagery, and administrative boundaries.

[0009] Furthermore, the automatic value calculation module has options for selecting all / single product types and for selecting the function quantity / value quantity of the calculation type. It also has functions for clearing selections and recalculating. The calculation results are displayed through a combination of bar and line graphs and data tables, replacing manual segmented statistical calculations and eliminating human calculation errors.

[0010] Furthermore, the ecological voucher / agricultural tourism value conversion accounting module supports uploading land use vector files in .shp, .dbf, .prj, and .shx formats, completing the overlay comparison of base period and current period land use layers, automatically calculating the number of ecological vouchers based on the ecological land change area and conversion coefficient, and visually presenting it on the administrative division map.

[0011] Furthermore, the database update and user management modules require login authorization before operation, and the system presets an initial administrator account and password; the database update unit manages data by year, supports editing and modifying single data entries, and clearing data in batches by year; cultural data supports adding information on venues, scenic spots, cultural relics, and demonstration villages, as well as up to three associated images; the user management unit hides and displays user passwords, supports adding users, editing user information, and deleting users by administrative region and department, and secondary password verification ensures the validity of newly added user information.

[0012] In more detail, the overall workflow of the platform is as follows: The front-end Vue framework receives user operation instructions and passes them to the .NET back-end service; the .NET back-end calls ArcGIS Server to complete spatial overlay and range statistical analysis, and simultaneously retrieves agricultural tourism ecological survey, value accounting, land use, and user data from PostgreSQL and PostGIS databases; the back-end uses the built-in accounting model to calculate value, function quantity, and ecological vouchers, and then sends the results back to the front-end; the front-end uses ArcGIS API for JavaScript and Echarts to render the data into maps, bar charts, pie charts, and tables for visualization; after administrator privileges are verified upon login, the back-end performs database data addition, deletion, modification, and query operations for persistent storage, forming a closed loop of business data.

[0013] The beneficial effects of this invention are as follows: Compared with the prior art, the big data platform for realizing the value of county-level agricultural tourism and ecological products has the following advantages: 1) By adopting an MVVM front-end and back-end separation architecture on the platform, and using mature technology stacks such as .NET, Vue, PostgreSQL+PostGIS, and ArcGIS Server, and incorporating three core accounting models for GEP total value, water conservation, and ecological vouchers, while configuring six complete functional modules, the platform is designed holistically from all dimensions, including underlying architecture, spatial data support, intelligent accounting, and business functions. On the one hand, it enables the linked display of text, images, and maps of the full-category survey information of agricultural tourism ecological products at the district and county level; on the other hand, it completes the spatial visualization of value and function, automatic accounting in multiple regions, time-series calculation of ecological vouchers, and integrated management and control of all ecological data and user permissions. This overcomes the problems of traditional system architecture being messy, lacking a unified accounting model, and fragmented functions, and realizes a full-process digital closed loop for ecological products from data collection, value accounting, spatial display to value transformation and data operation and maintenance, significantly improving the overall, standardized, and intelligent level of value management of ecological products at the district and county level. 2) By clearly defining the software and hardware deployment and operation environment that the platform is compatible with, and limiting the necessary software components and client and server hardware configuration standards, a clear and unified configuration basis can be provided for the platform's deployment and on-site installation and debugging. This avoids problems such as platform lag, spatial analysis calculation timeouts, and abnormal data loading caused by software and hardware version incompatibility and insufficient hardware performance, ensuring the long-term stable operation of the platform and adapting to the normalized use needs of county-level government affairs and agricultural tourism businesses, while reducing deployment, adaptation, and subsequent operation and maintenance costs. 3) By completing the loading of PostGIS spatial extensions, adapting ArcGIS dependent dynamic libraries, and configuring spatial database connections, deep compatibility and interoperability between ArcGIS services and PostgreSQL spatial databases are achieved. This enables stable storage, retrieval, and analysis of vector spatial data and ecological attribute data, supports spatial database creation, layer mounting, and spatial overlay operations, and solves the shortcomings of traditional relational databases in storing and analyzing geospatial information, difficulties in GIS and database integration, and low efficiency in spatial data reading and writing. This provides solid underlying spatial data support for platform map visualization, spatial overlay statistics, and value spatial accounting. Attached Figure Description

[0014] Figure 1 A flowchart illustrating the process of a big data platform for realizing the value of county-level agricultural tourism and ecological products, provided in an embodiment of the present invention. Detailed Implementation

[0015] The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0016] Please see Figure 1 As shown, this invention provides a big data platform for realizing the value of agricultural tourism ecological products at the district and county level. The platform adopts an MVVM system architecture, with the backend developed based on the .NET platform and the frontend using HTML5, CSS3, JavaScript, and Vue frameworks, integrating the Echarts visualization tool. The database uses PostgreSQL with PostGIS spatial extension, the GIS server is deployed with ArcGIS Server, and the frontend connects to GIS services through ArcGIS API for JavaScript. The platform has built-in accounting models, including the Gross Ecological Product (GEP) model: GEP=EPV+ERV+ECV, the Water Conservation Accounting Model: Qwr=Σ(Pi-Ri-ETi)×Ai, and the Ecological Voucher Accounting Model: ΔMt=ΣΔAi×ki; The platform includes six core functional modules: homepage module, agricultural tourism and ecological product survey module, agricultural tourism and ecological product value module, automatic value calculation module, ecological voucher / agricultural tourism value conversion calculation module, database update and user management module; The homepage module is used to convert the output, area, value, and spatial distribution data of agricultural and tourism material supply, cultural services, and regulatory services at the district and county levels into charts, visually displaying the total value of the city, the value distribution of administrative districts, and the trend of indicator proportions. The agricultural tourism ecological product survey module uses a combination of maps and charts to display survey information on agricultural tourism products categorized into material supply, cultural services, and ecological regulation services. It supports detailed queries by region, location, and scenic spot. The agricultural tourism ecological product value module enables GIS map visualization of ecological product value and function, bar chart statistics of value and function for each administrative region, and pie chart statistics of value and function for each type of region / scenic spot. The automatic value calculation module supports the selection of three calculation ranges: administrative region, scenic area, and custom agricultural tourism area. It enables the overlay and statistical analysis of ecological products and selected areas, automatic calculation of the value and function of agricultural tourism ecological products, and visualization of results in multiple forms. The Eco Voucher / Agritourism Value Conversion Calculation Module supports uploading and comparing two phases of land use data. Based on land use changes and input-output data of agritourism projects, it automatically completes the calculation of eco vouchers and spatial visualization of the results. The database update and user management module includes a database update unit and a user management unit. The database update unit enables year selection, visualization, editing, addition, and batch clearing of data for material categories, cultural services categories, citywide value, and adjustment service value. The user management unit enables user information display, addition, editing, deletion, and hierarchical control of login permissions. Specifically, the Gross Ecological Product (GEP) model is: GEP = EPV + ERV + ECV, where GEP represents the total value of ecological products, EPV represents the value of material supply, ERV represents the value of regulatory services, and ECV represents the value of cultural services. That is, GEP = value of material supply + value of regulatory services + value of cultural services.

[0017] Specifically, the water conservation accounting model is: Qwr=Σ(Pi-Ri-ETi)×Ai, where Pi represents rainfall, Ri represents surface runoff, ETi represents evapotranspiration, and Ai represents the area of ​​each ecosystem within the region. That is, the water conservation capacity = the sum of the areas of each ecosystem within the region (rainfall - surface runoff - evapotranspiration) × area.

[0018] Specifically, the ecological voucher accounting model is: ΔMt=ΣΔAi×ki, where ΔMt represents the number of newly added ecological vouchers, ΔAi represents the area of ​​change of various types of ecological land, and ki represents the corresponding standard conversion factor. That is, the number of newly added ecological vouchers = the sum of the area of ​​change of various types of ecological land × the corresponding standard conversion factor.

[0019] It is evident that by adopting an MVVM front-end and back-end separation architecture on the platform, coupled with mature technology stacks such as .NET, Vue, PostgreSQL+PostGIS, and ArcGIS Server, and incorporating three core accounting models—GEP total value, water conservation, and ecological vouchers—along with six complete functional modules, the platform is designed holistically from all dimensions, including underlying architecture, spatial data support, intelligent accounting, and business functions. On the one hand, it enables the linked display of text, images, and maps of the full-category survey information of agricultural tourism ecological products at the district and county levels; on the other hand, it achieves spatial visualization of value and function quantities, automatic accounting in multiple regions, time-series calculation of ecological vouchers, and integrated management and control of all ecological data and user permissions. This overcomes the problems of traditional system architecture being chaotic, lacking a unified accounting model, and fragmented functions, realizing a full-process digital closed loop for ecological products from data collection, value accounting, spatial display to value transformation and data operation and maintenance, significantly improving the overall, standardized, and intelligent level of value management of ecological products at the district and county levels.

[0020] As one implementation method, the platform deployment and operation environment includes hardware and software environments; the software environment needs to be configured with the .NET development platform, ArcGIS Desktop 10.2, ArcGIS Server 10.2, PostgreSQL, PostGIS, and the Vue framework; the hardware environment includes clients and servers: the client is an Intel Core i5 or higher processor, 16GB of memory, and 512GB or more of available hard disk space; the server is a TS80X model, a Xeon E2224G quad-core 3.5GHz processor, and 32GB or more of memory.

[0021] It is evident that by clearly defining the software and hardware deployment and operation environment compatible with the platform, and specifying the necessary software components and client and server hardware configuration standards, a clear and unified configuration basis can be provided for the platform's deployment, on-site installation and debugging. This avoids problems such as platform lag, spatial analysis calculation timeouts, and abnormal data loading caused by software and hardware version incompatibility or insufficient hardware performance. It ensures the long-term stable operation of the platform and adapts to the routine use needs of county-level government affairs and agricultural tourism businesses, while reducing deployment, adaptation and subsequent operation and maintenance costs.

[0022] As one implementation method, PostgreSQL is configured with PostGIS spatial extensions. By loading dependent libraries such as libeay32.dll, libiconv-2.dll, and libpq.dll, as well as the st_geometry.dll file, ArcGIS and PostgreSQL spatial databases are adapted to support spatial database creation, layer connection, and spatial data storage.

[0023] As can be seen, by completing the loading of PostGIS spatial extensions, adapting ArcGIS dependent dynamic libraries, and configuring spatial database integration, deep compatibility and interoperability between ArcGIS services and PostgreSQL spatial databases are achieved. This enables stable storage, retrieval, and analysis of vector spatial data and ecological attribute data, supports spatial database creation, layer mounting, and spatial overlay operations, and solves the shortcomings of traditional relational databases in storing and analyzing geospatial information, difficulties in GIS and database integration, and low efficiency in spatial data reading and writing. It provides solid underlying spatial data support for platform map visualization, spatial overlay statistics, and value spatial accounting.

[0024] As one implementation method, the agricultural tourism ecological product survey module includes four categories of data display for material supply: aquatic products, fruits, grains, and "two products and one standard" (referring to products with high quality and standardized products and geographical indications). Each category includes a brief introduction, a map, and a bar chart visualizing the yield and area. The cultural service category includes cultural overview, scenic spot map markings, and a single scenic spot text and image carousel introduction. The regulation service category includes cross-sectional water quality label display, overview of seven types of ecological land use (arable land, orchard, forest land, wetland, etc.), soil attributes, slope, and property rights attributes in a multi-dimensional map visualization, and supports switching between the three zones and three lines, satellite imagery, and administrative boundary basic layers.

[0025] It is evident that by subdividing the data display logic into three categories—material supply, cultural services, and regulatory services—the agricultural tourism ecological product survey module enables multi-dimensional visualization of production area, detailed display of cultural and tourism attractions through image and text rotation, and free switching between various ecological land attributes and basic layers. This allows for a hierarchical, categorized, combined image and text, and map-linked intuitive presentation of the county-level agricultural tourism ecological resources. This facilitates managers in quickly querying survey details by category, administrative region, and land type, while also supporting the assessment of the current status of ecological resources, agricultural tourism industry planning, and refined management of land space. Even non-professionals can quickly understand the spatial distribution and endowment characteristics of ecological resources.

[0026] As one implementation method, the automatic value calculation module has the option to select all or one product type and the option to select the function quantity or value quantity of the calculation type. It also has the function of clearing the selection and recalculating. The calculation results are displayed in conjunction with the bar and line graphs and the data table, which replaces manual segmented statistical calculation and eliminates human calculation errors.

[0027] It is evident that by setting up multi-dimensional filtering, accounting type selection, clearing and recalculation, and graphic and table-linked result display mechanisms in the automatic value accounting module, the system supports flexible delineation of accounting scope by administrative region and custom area, replacing the traditional manual segmentation and calculation mode. Relying on the system's spatial overlay and automatic model calculation capabilities, it effectively avoids human errors such as omissions in manual statistics, calculation errors, and inconsistent standards, significantly improving the calculation efficiency, accuracy, and intuitiveness of ecological product value and functional quantity accounting, and meeting the needs of districts and counties for routine batch GEP accounting and special area assessment.

[0028] As one implementation method, the ecological voucher / agricultural tourism value conversion accounting module supports uploading land use vector files in .shp, .dbf, .prj, and .shx formats, completes the overlay comparison of base period and current period land use layers, automatically calculates the number of ecological vouchers based on the ecological land change area and conversion coefficient, and visualizes it on the administrative division map.

[0029] It is evident that by uploading files in a standard land use vector format compatible with the standard, the system automatically overlays and compares the base period and current land use layers, and automatically calculates ecological vouchers based on the land use change area and conversion factor, with map visualization. This solves the pain points of traditional ecological voucher calculation, which relies on manual comparison of maps and manual conversion, and the inability to spatially implement the results. It can accurately quantify the changes in ecological value brought about by changes in land use structure, making the ecological voucher calculation results quantifiable, graphical, and traceable, providing standardized and visualized quantitative basis for ecological rights trading, ecological compensation, and value assessment of agricultural and tourism development projects.

[0030] As one implementation method, the database update and user management modules require login authorization before operation. The system has a preset initial administrator account and password. The database update unit manages data by year, supports editing and modifying single data entries, and clearing data in batches by year. Cultural data supports adding information on venues, scenic spots, cultural relics, and demonstration villages, as well as up to three related images. The user management unit hides and displays user passwords, supports adding users, editing user information, and deleting users by administrative region and department. Password verification is used twice to ensure the validity of newly added user information.

[0031] It is evident that by setting up a login authorization access mechanism, data management capabilities by year, functions for adding, editing, and adding images to cultural data, as well as encrypted display of user information and a mechanism for adding, editing, deleting, and verifying passwords, the system effectively controls backend data operation permissions. Only authorized administrators are permitted to perform data maintenance and user management, preventing core ecosystem data from being arbitrarily tampered with, accidentally deleted, or having sensitive information leaked. On the other hand, it ensures that ecosystem data from previous years is traceable, can be cleared, and can be iteratively updated, cultural and tourism resource information can be dynamically supplemented and improved, and user accounts are hierarchically controllable. This balances system data security, business timeliness, and management convenience, and complies with the security control standards for government platforms.

[0032] As one implementation method, the overall workflow of the platform is as follows: The front-end Vue framework receives user operation instructions and passes them to the .NET back-end service; the .NET back-end calls ArcGIS Server to complete spatial overlay and range statistical analysis, and simultaneously retrieves agricultural tourism ecological survey, value accounting, land use, and user data from PostgreSQL and PostGIS databases; the back-end calculates value, function, and ecological vouchers based on the built-in accounting model and then sends the results back to the front-end; the front-end uses ArcGIS API for JavaScript and Echarts to render the data into maps, bar charts, pie charts, and tables for visualization; after administrator privileges are verified upon login, the back-end performs database data addition, deletion, modification, and query operations for persistent storage, forming a closed loop of business data.

[0033] It is evident that by defining standardized interaction processes and data flow logic between the front-end, back-end, GIS services, and spatial database, a complete business loop is clearly defined, encompassing instruction transmission, spatial analysis, model calculation, result feedback, visualization rendering, and persistent database storage. This enables interoperability, clear division of labor, and collaborative linkage among various technical components, ensuring rapid response to user operation instructions, smooth spatial analysis calculations, and real-time feedback of accounting results. Simultaneously, the standardized data writing logic for permission operations ensures a clear overall platform operation logic, low coupling, and strong scalability, facilitating the addition of ecological accounting models, expansion of agricultural tourism business scenarios, and integration with third-party business systems.

[0034] It should be noted that the Vue framework directly connects to the map and spatial analysis services published by ArcGIS Server through the ArcGIS API for JavaScript interface library. Within Vue components, it loads spatial layers of agricultural tourism and ecological products, performs regional overlay analysis, range statistics, and spatial positioning operations. Vue passes the calculation area and query range defined by the front-end user to ArcGIS Server, which completes the spatial calculations and returns the results. Vue then integrates the spatial results with chart data for display, achieving interactive visualization of map and business data. Vue sends data query, add, edit, and delete requests to the .NET backend. The .NET backend connects to the PostgreSQL+PostGIS database to execute corresponding SQL and spatial data operations, reading or writing agricultural tourism and ecological product survey data, value accounting data, land use data, user information data, etc., and returns the operation results to the Vue frontend. After receiving the data, the Vue framework uses the ECharts chart component and page rendering mechanism to convert structured and spatial data into charts, tables, maps, and other visualization formats for intuitive data display. The framework handles interface rendering, user interaction, data display, and event-driven operations; the .NET backend handles business logic, access control, and service scheduling; ArcGIS Server provides spatial data and spatial analysis support; and PostgreSQL+PostGIS provides persistent data storage. The four components are seamlessly integrated through standardized interfaces and data formats.

[0035] Compared with existing technologies, this platform has the following advantages: 1) The value accounting of agricultural tourism is efficient and accurate. The platform relies on the automatic value accounting module, combined with the spatial analysis capabilities of ArcGIS and the data support of the PostgreSQL database. It can complete the overlay and value calculation of the spatial data of agricultural tourism ecological products by administrative region, scenic spot or custom agricultural tourism area with one click. It replaces the traditional manual statistics and segmented calculation method, effectively reduces human error and greatly improves the efficiency of agricultural tourism value accounting. 2) The agricultural tourism data is presented in an intuitive and easy-to-understand manner. The platform adopts a visualization method that links front-end maps with multiple types of charts. Through the homepage module, agricultural tourism ecological product value module, etc., the total value, distribution, and proportion of scenic spots / land types of agricultural tourism products are presented in the form of maps, bar charts, and pie charts. Even non-professional agricultural tourism managers can quickly interpret the information behind the data, providing clear support for agricultural tourism planning and decision-making. 3) The agricultural tourism data management is standardized and can be dynamically updated. The platform stores all agricultural tourism ecological data in a unified PostgreSQL+PostGIS spatial database. Through the database update module, it is easy to edit, add and delete data such as agricultural tourism material categories, cultural tourism service categories and adjustment service value, ensuring that agricultural tourism data is consistent and timely, avoiding the problems of traditional agricultural tourism data being scattered and difficult to summarize. 4) The platform has enabled the quantifiable realization of the ecological value of agriculture and tourism. The platform’s ecological voucher / agricultural tourism value conversion accounting module supports the uploading and comparison of land use data and agricultural tourism development project data from two phases. It can automatically calculate ecological vouchers or agricultural tourism value conversion indicators based on land use changes and the input and output of cultural tourism projects, transforming the abstract value of agricultural tourism ecological products into tradable and assessable quantitative evidence, and providing a feasible path for the market-oriented operation of agricultural tourism projects. 5) The system has strong security and manageability. The platform implements hierarchical control of user permissions through the user management module. Only authorized users can perform data editing and user management operations, which effectively avoids the risk of accidental modification and leakage of sensitive agricultural and tourism data and meets the security requirements of government and agricultural and tourism enterprise systems. 6) The system architecture is stable and highly adaptable. The platform adopts a front-end and back-end separated MVVM architecture, using .NET as the back-end service framework, and paired with ArcGIS Server and Vue front-end framework. It can adapt to the scale of ecosystem product data and hardware environment, and runs stably and reliably. At the same time, it also provides space for the subsequent expansion of new agricultural tourism projects and accounting models.

[0036] The county-level agricultural tourism ecological product value realization big data platform described in this application operates as follows: Users first operate through the front-end interface, such as selecting the accounting area (administrative region / scenic area / agricultural tourism zone), viewing agricultural tourism ecological product survey information, or initiating value accounting requests. These instructions are transmitted to the .NET back-end service via the front-end framework. The back-end service, based on user instructions, requests GIS spatial analysis and map service support from ArcGIS Server, and simultaneously retrieves stored agricultural tourism ecological survey data, value data, land use data, and cultural tourism project data from the PostgreSQL+PostGIS database. After ArcGIS Server completes operations such as spatial overlay of agricultural tourism zones and statistical analysis of scenic area scope, it returns the analysis results to the back-end service. The back-end service, combining the data in the database, calculates the value, functional quantity, or ecological voucher / agricultural tourism value conversion of agricultural tourism products, and then feeds the calculation results back to the front-end. The front-end, through the Vue framework and ArcGIS API... For JavaScript and ECharts tools, the results are presented to users in the form of maps, bar charts, pie charts, tables, etc. For administrators' database updates or user management operations, the system will first verify the permissions. After the verification is successful, the backend service will synchronize the relevant operation instructions to the PostgreSQL database to complete the persistent storage of data or update of user information, realizing the data flow and business closed loop of the entire platform.

[0037] Although embodiments of the invention have been shown and described, it will be understood by those skilled in the art that various changes, modifications, substitutions and alterations can be made to these embodiments without departing from the principles and spirit of the invention, the scope of which is defined by the appended claims and their equivalents.

Claims

1. A big data platform for realizing the value of agricultural tourism and ecological products at the district / county level, characterized in that, The big data platform for realizing the value of agricultural tourism and ecological products at the district and county levels adopts an MVVM system architecture. The backend is developed based on the .NET platform, and the frontend uses HTML5, CSS3, JavaScript, and Vue frameworks, integrating the Echarts visualization tool. The database uses PostgreSQL with PostGIS spatial extensions, the GIS server is deployed with ArcGIS Server, and the frontend connects to GIS services through ArcGIS API for JavaScript. The platform has built-in accounting models, including the Gross Ecological Product (GEP) model: GEP = EPV + ERV + ECV, the Water Conservation Accounting Model: Qwr = Σ(Pi - Ri - ETI) × Ai, and the Ecological Voucher Accounting Model: ΔMt = ΣΔAi × ki. The platform includes six core functional modules: homepage module, agricultural tourism and ecological product survey module, agricultural tourism and ecological product value module, automatic value calculation module, ecological voucher / agricultural tourism value conversion calculation module, database update and user management module; The homepage module is used to convert the output, area, value, and spatial distribution data of agricultural and tourism material supply, cultural services, and regulatory services at the district and county levels into charts to visually display the total value of the city, the value distribution of administrative regions, and the trend of indicator proportions. The agricultural tourism ecological product survey module uses a combination of maps and charts to display survey information on agricultural tourism products categorized into material supply, cultural services, and ecological regulation services. It supports detailed queries by region, location, and scenic spot. The agricultural tourism ecological product value module enables GIS map visualization of ecological product value and function, bar chart statistics of value and function for each administrative region, and pie chart statistics of value and function for each type of land / scenic spot. The automatic value calculation module supports the selection of three calculation ranges: administrative region, scenic area, and custom agricultural tourism area. It enables the overlay and statistical analysis of ecological products and selected areas, automatic calculation of the value and function of agricultural tourism ecological products, and visualization of results in multiple forms. The ecological voucher / agricultural tourism value conversion accounting module supports uploading and comparing two phases of land use data. Based on land use changes and agricultural tourism project input-output data, it automatically completes ecological voucher accounting and spatial visualization of results. The database update and user management module includes a database update unit and a user management unit. The database update unit enables the selection, visualization, editing, addition, and batch clearing of year data for material categories, cultural services categories, citywide value, and adjustment service value. The user management unit enables the display, addition, editing, deletion, and hierarchical control of user information and login permissions.

2. The big data platform for realizing the value of county-level agricultural tourism and ecological products according to claim 1, characterized in that, The platform deployment and operation environment includes hardware and software environments. The software environment requires the configuration of the .NET development platform, ArcGIS Desktop 10.2, ArcGIS Server 10.2, PostgreSQL, PostGIS, and the Vue framework. The hardware environment includes the client and server: the client requires an Intel Core i5 or higher processor, 16GB of RAM, and 512GB or more of available hard disk space; the server requires a TS80X model, a Xeon E2224G quad-core 3.5GHz processor, and 32GB or more of RAM.

3. The big data platform for realizing the value of county-level agricultural tourism and ecological products according to claim 1, characterized in that, The PostgreSQL configuration for PostGIS spatial extensions loads dependent libraries such as libeay32.dll, libiconv-2.dll, and libpq.dll, as well as the st_geometry.dll file, to adapt ArcGIS and PostgreSQL spatial databases, supporting spatial database creation, layer connection, and spatial data storage.

4. The big data platform for realizing the value of county-level agricultural tourism and ecological products according to claim 1, characterized in that, The agricultural tourism ecological product survey module includes four categories of data display: material supply, aquatic products, fruits, grains, and "two products and one standard" (referring to products with high quality and standardized products and geographical indications). Each category includes a brief introduction, a map, and a bar chart visualizing the yield and area. The cultural service category includes cultural overview, scenic spot map annotations, and a single scenic spot text and image carousel introduction. The regulation service category includes cross-sectional water quality label display, overview of seven types of ecological land use (arable land, orchard, forest land, wetland, etc.), soil attributes, slope, and multi-dimensional map visualization of land use rights and attributes. It also supports switching between the three zones and three lines, satellite imagery, and administrative boundary basic layers.

5. The big data platform for realizing the value of county-level agricultural tourism and ecological products according to claim 1, characterized in that, The automatic value calculation module has options for selecting all / single product types and for selecting the function quantity / value quantity of the calculation type. It also has functions for clearing selections and recalculating. The calculation results are displayed in conjunction with bar and line graphs and data tables, replacing manual segmented statistical calculations and eliminating human calculation errors.

6. The big data platform for realizing the value of county-level agricultural tourism and ecological products according to claim 1, characterized in that, The ecological voucher / agricultural tourism value conversion accounting module supports uploading land use vector files in .shp, .dbf, .prj, and .shx formats, completes the overlay comparison of base period and current period land use layers, automatically calculates the number of ecological vouchers based on the ecological land change area and conversion coefficient, and visualizes it on the administrative division map.

7. The big data platform for realizing the value of county-level agricultural tourism and ecological products according to claim 1, characterized in that, The database update and user management modules require login authorization before operation. The system has a preset initial administrator account and password. The database update unit manages data by year, supports editing and modifying single data entries, and clearing data in batches by year. Cultural data supports adding information on venues, scenic spots, cultural relics, and demonstration villages, as well as up to three related images. The user management unit hides and displays user passwords, and supports adding, editing, and deleting users by administrative region and department. Password double verification ensures the validity of newly added user information.

8. The big data platform for realizing the value of county-level agricultural tourism and ecological products according to claim 1, characterized in that, The overall workflow of the platform is as follows: the front-end Vue framework receives user operation commands and passes them to the .NET back-end service; The .NET backend calls ArcGIS Server to complete spatial overlay and range statistical analysis, while retrieving agricultural tourism ecological survey, value accounting, land use and user data from PostgreSQL and PostGIS databases; the backend uses the built-in accounting model to calculate value, function and ecological vouchers and then sends them back to the frontend. The front end uses ArcGIS API for JavaScript and Echarts to render maps, bar charts, pie charts, and tables for visualization; after administrators are logged in and verified, the back end performs database data creation, deletion, modification, and querying for persistent storage, forming a closed loop of business data.

Images