Method and device for designing cultural heritage landscape spatial database

Abstract

The invention belongs to the technical field of landscape data acquisition, and particularly relates to a cultural heritage landscape spatial database design device which comprises a ticket checking mechanism, a control mechanism, a cleaning mechanism and a recycling mechanism. The ticket checking mechanism comprises a channel rack, a channel plate and an induction panel, the channel plate is rotatably arranged on the side wall of the channel rack, and the induction panel is used for detecting bill information and controlling selection of the channel plate through the bill information; the control mechanism comprises an installation support and a magnetic plate, the magnetic plate is slidably installed on the outer wall of the channel rack, sliding of the magnetic plate is controlled through magnetic force, and the installation support is slidably connected with the channel rack through the magnetic plate. The cleaning mechanism comprises a cleaning scraping plate, a liquid spraying plate and a wiping roller; through cooperation of the above structure, the system adapts to real life, viruses at ticket checking positions after ticket checking in a two-dimensional code scanning mode are killed, and meanwhile, the virus and bacteria spreading risk caused by volatilization of a disinfectant can be effectively reduced.

Description

Technical Field

[0001] The invention belongs to the technical field of landscape data collection, and in particular to a design method and device for a cultural heritage landscape spatial database. Background Art

[0002] With the rapid development of tourism, the floating population has increased, the tourism load has increased, and it has had a certain impact on scenic area resources and environmental protection. Especially with the characteristics of open tourism, it is quite difficult to manage and control the total number of tourists, so it is necessary to design a landscape space database. In order to intuitively collect information on the number of tourists, the ticket inspection data is usually used to replace the tourist number data. At this time, it is necessary to use a ticket gate for ticket inspection.

[0003] For example, the Chinese patent with announcement number CN220438973U discloses a multi-channel ticket checking machine, which relates to the technical field of automatic ticket checking machines. The ticket checking machine includes a first gate, a second gate is symmetrically arranged on both sides of the first gate, a gate device is arranged between the first gate and the second gate, an emergency button is arranged at the other end of the upper surface of the first gate and the second gate, an indicator light is arranged at the front end of the first gate and the second gate, a glass baffle is arranged in the middle of the first gate and the second gate, a control center is arranged inside the second gate, an infrared sensor lamp is arranged on the side of the first gate and the second gate close to the gate device, a scanning device is connected to the fixing rod, a card reading device cooperating with the card slot is arranged inside the second gate, and a disinfection device is arranged at the lower end of the card reading device. In this technology, through the mutual cooperation between the first gate, the second gate, the connecting shaft, the connecting rod and the gate, the effect of allowing multiple groups of pedestrians to queue up and pass through the ticket checking machine at one time is achieved, and it is highly practical.

[0004] Although the above technology can disinfect the conveyor belt, with the development of society, mobile terminals are usually used to generate ticket QR codes, and the QR code information is collected by the gate to realize ticket checking. The information collected by the sensor after the ID card is transported through the conveyor belt is obviously not able to adapt to the information collection of mobile terminals. At the same time, after the conveyor belt is wiped with disinfectant cotton, disinfectant will remain on the outer wall of the conveyor belt. Since it takes time for the disinfectant to inactivate the virus, if the virus is not disinfected, it will evaporate into the nearby air with the disinfectant and be easily inhaled by tourists, thereby causing the risk of secondary infection.

[0005] To this end, the present invention provides a design method and device for a cultural heritage landscape spatial database. Summary of the invention

[0006] In order to make up for the deficiencies of the prior art, at least one technical problem raised in the background technology is solved.

[0007] The technical solution adopted by the present invention to solve the technical problem is: a design device for a cultural heritage landscape spatial database according to the present invention comprises a ticket checking mechanism, a control mechanism, a cleaning mechanism and a recycling mechanism;

[0008] The ticket checking mechanism includes a channel frame, a channel plate and a sensing panel. The channel plate is rotatably arranged on the side wall of the channel frame. The sensing panel is used to detect ticket information and control the channel plate selection through the ticket information.

[0009] The control mechanism includes a mounting bracket and a magnetic plate, the magnetic plate is slidably mounted on the outer wall of the channel frame, and the sliding of the magnetic plate is controlled by magnetic force, and the mounting bracket is slidably connected to the channel frame through the magnetic plate;

[0010] The cleaning mechanism includes a cleaning scraper, a liquid spraying plate and a wiping roller, which are all arranged on the side wall of the mounting bracket. After the liquid spraying plate sprays the disinfectant, the disinfectant is scraped off by the cleaning scraper and then wiped by the wiping roller;

[0011] The recovery mechanism absorbs the residual disinfectant by generating negative pressure at the bottom of the wiping roller, while controlling the wiping roller to fit the surface of the sensing panel.

[0012] Preferably, the recovery mechanism includes a control pump, a recovery tube and a support cylinder;

[0013] The support cylinder is elastically mounted on the side wall of the mounting bracket, the wiping roller is fixedly mounted on the outer wall of the support cylinder, and the inner cavity of the support cylinder is communicated with the input end of the control pump through a recovery pipe.

[0014] Preferably, the recovery mechanism also includes a connecting frame and a connecting tube, the connecting tube is fixedly mounted on the inner wall of the connecting frame, the connecting frame is slidably connected to the mounting bracket, and the bottom is fixedly connected to the side wall of the support tube, one end of the recovery tube passes through the mounting bracket, the bottom of the connecting tube is sleeved on the outer wall of the recovery tube, and the connecting tube is elastically connected to the connecting frame, and the top of the connecting tube is connected to the side wall of the support tube through a conduit.

[0015] Preferably, an installation box is fixedly installed on the outer wall of the channel rack, a partition plate is fixedly installed on the inner wall of the installation box, the control pump is fixedly installed on the upper end surface of the partition plate, and a shielding cover is fixedly installed on the outer wall of the channel rack;

[0016] An elastic ring is fixedly installed on the outer wall of the recovery pipe, the inner wall of the elastic ring is inclined, and the outer wall of the elastic ring is slidably fitted with the inner wall of the connecting tube;

[0017] A support ring is fixedly mounted on the inner wall of the connecting tube, and the bottom of the support ring is connected to the outer wall of the mounting bracket through an elastic member.

[0018] Preferably, the inner cavity of the installation box is divided into two upper and lower chambers by a partition plate, and the chamber at the bottom of the installation box is used to store the disinfectant;

[0019] An atomizing pump is fixedly installed on the outer wall of the partition plate, the input end of the atomizing pump is used to absorb the disinfectant, and the output end of the atomizing pump is connected to the inner cavity of the liquid spraying plate through a conduit;

[0020] A control motor is fixedly installed on the inner wall of the channel frame, a control screw is fixedly installed on the output shaft of the control motor, and a transmission plate that attracts the magnetic plate is installed on the outer wall of the control screw through internal and external threads.

[0021] Preferably, a disinfection chamber is fixedly mounted on the upper end surface of the partition plate, and an outer wall of the disinfection chamber is provided with a liquid inlet pipe and an exhaust pipe communicating with the inner cavity of the disinfection chamber;

[0022] One end of the recovery pipe away from the connecting tube is connected to the liquid inlet pipe, and the input end of the control pump is connected to the exhaust pipe through a conduit;

[0023] A material guide plate is fixedly installed on the inner wall of the disinfection chamber. The material guide plate is tilted and located below the liquid inlet pipe. The material guide plate is made of transparent material. The bottom of the material guide plate and the inner wall of the disinfection chamber are both provided with disinfection light sources.

[0024] Preferably, a mounting cylinder is fixedly mounted on the inner wall of the disinfection chamber, a turbine blade is rotatably mounted on the inner wall of the mounting cylinder, and the inner cavity of the mounting cylinder is connected to the inner cavity of the disinfection chamber;

[0025] A transmission shaft is fixedly installed at the center position of the axial end of the turbine blade, and a stirring blade is fixedly installed on the outer wall of the transmission shaft.

[0026] A method for designing a cultural heritage landscape spatial database, the method adopts the above-mentioned cultural heritage landscape spatial database design device, and comprises the following steps:

[0027] A1. Determine the purpose, functional requirements and user requirements of the database, and identify the landscape elements and spatial data types that need to be stored;

[0028] A2. Create a conceptual model to define the attributes and relationships of landscape objects;

[0029] A3. The number of tourists in the scenic spot is counted through the ticket information detected by the sensor panel.

[0030] The following steps are also included:

[0031] A4. Combine the tourist quantity data with spatial data and landscape elements to generate a model;

[0032] A5. Define table structure, fields, indexes and relationships to ensure data storage integrity and query efficiency;

[0033] A6. Integrate existing spatial data and attribute data, and design data input and update processes.

[0034] It also includes the following steps:

[0035] A7. Create databases, write queries and manage programs, and optimize performance to meet actual needs;

[0036] A8. Perform database testing to ensure normal functionality, and regularly maintain and update data to maintain the validity and accuracy of the database.

[0037] The beneficial effects of the present invention are as follows:

[0038] 1. The present invention sets a mounting bracket, and sets a cleaning scraper, a liquid spraying plate and a wiping roller on the side wall of the mounting bracket. After the liquid spraying plate sprays the disinfectant, the disinfectant is scraped off by the cleaning scraper, and then wiped by the wiping roller, so as to adapt to the real life, and use the QR code scanning method to disinfect viruses at the ticket checking position after ticket checking, and reduce the risk of cross-contact infection. The disinfectant residual on the sensing panel contains unextinguished viruses and bacteria. In order to reduce the risk of virus and bacteria transmission caused by the volatilization of the disinfectant, the disinfectant residual on the sensing panel and the disinfectant absorbed by the wiping roller are absorbed by negative pressure, which can effectively reduce the risk of virus and bacteria transmission caused by the volatilization of the disinfectant. At the same time, the negative pressure can improve the drying efficiency of the wiping roller, which is convenient for wiping again;

[0039] 2. The present invention provides a connecting frame and a connecting tube, the connecting tube is fixedly installed on the inner wall of the connecting frame, the connecting frame is slidably connected to the mounting bracket, and the bottom is fixedly connected to the side wall of the supporting tube, the sliding connecting frame drives the supporting tube to slide synchronously, one end of the recovery pipe passes through the mounting bracket, the bottom of the connecting tube is sleeved on the outer wall of the recovery pipe, and the connecting tube is elastically connected to the connecting frame. When the recovery pipe is connected to the negative pressure chamber, the internal air pressure at the connection position of the connecting tube and the recovery pipe is reduced, thereby controlling the connecting tube to slide downward, and controlling the connecting frame and the supporting tube to slide synchronously, thereby realizing that after the negative pressure is turned on, the wiping roller is controlled to fit with the sensing panel, thereby realizing automatic fitting of the wiping roller with the sensing panel and ensuring the wiping quality. BRIEF DESCRIPTION OF THE DRAWINGS

[0040] The present invention will be further described below in conjunction with the accompanying drawings.

[0041] Figure 1 It is a schematic diagram of the overall structure of the present invention;

[0042] Figure 2 It is a schematic diagram of the installation of the sensor panel in the present invention;

[0043] Figure 3 It is a schematic diagram of the installation of the mounting bracket in the present invention;

[0044] Figure 4 It is a schematic diagram of the installation of the magnetic plate in the present invention;

[0045] Figure 5 It is a schematic diagram of the installation of the wiping roller in the present invention;

[0046] Figure 6 It is a schematic diagram of the installation of the connecting frame in the present invention;

[0047] Figure 7 yes Figure 6 A partial enlarged view of the middle part;

[0048] Figure 8 It is a schematic diagram of the installation of the control pump in the present invention;

[0049] Fig. 9 It is a schematic diagram of the installation of the guide plate in the present invention;

[0050] Fig.10 It is a structural schematic diagram of the material guide plate in the present invention;

[0051] Fig.11 It is a schematic diagram of the installation of the turbine blades in the present invention;

[0052] Fig.12 It is a flow chart of the design method in the present invention.

[0053] In the figure: 1. channel rack; 2. induction panel; 3. shielding cover; 4. installation box; 5. channel plate; 6. installation bracket; 7. spray plate; 8. transmission shaft; 9. cleaning scraper; 10. control screw; 11. transmission plate; 12. control motor; 13. magnetic plate; 14. wiping roller; 15. connecting frame; 16. support cylinder; 17. recovery pipe; 18. support ring; 19. connecting cylinder; 20. elastic ring; 21. liquid inlet pipe; 22. disinfection chamber; 23. control pump; 24. stirring blade; 25. partition plate; 26. atomizing pump; 27. guide plate; 28. disinfection light source; 29. ​​exhaust pipe; 30. turbine blade; 31. installation cylinder. DETAILED DESCRIPTION

[0054] In order to make the technical means, creative features, objectives and effects achieved by the present invention easy to understand, the present invention is further explained below in conjunction with specific implementation methods.

[0055] Embodiment 1: Figures 1 to 10 As shown, a design device for a cultural heritage landscape spatial database according to an embodiment of the present invention includes a ticket checking mechanism, a control mechanism, a cleaning mechanism and a recycling mechanism.

[0056] The ticket checking mechanism comprises a channel frame 1, a channel plate 5 and a sensing panel 2. The channel plate 5 is rotatably arranged on the side wall of the channel frame 1. The channel frame 1 and the channel plate 5 form a complete gate, and the channel plate 5 controls the entry and exit of tourists.

[0057] The sensing panel 2 is used to detect ticket information and control the selection of the channel board 5 through the ticket information. In this embodiment, the sensing panel 2 uses a QR code scanning camera. After purchasing a ticket, a QR code is generated on the smart mobile terminal. When tourists enter the scenic spot, they first need to pass through the channel rack 1. At this time, after the mobile terminal is close to the sensing panel 2, the QR code is scanned and identified, and the channel board 5 is controlled to rotate, so that tourists can pass through.

[0058] In this embodiment, the method of controlling the gate to open and realize automatic ticket checking by scanning the scenic area ticket barcode and the mobile terminal QR code is a common technical means in the prior art, that is, well known to those skilled in the art, and will not be elaborated here.

[0059] The control mechanism includes a mounting bracket 6 and a magnetic plate 13. The magnetic plate 13 is slidably installed on the outer wall of the channel rack 1, and the sliding of the magnetic plate 13 is controlled by magnetic force. The magnetic plate 13 moves inside the channel rack 1 through the magnetic component, so that the movement of the magnetic plate 13 is controlled by magnetic force. The mounting bracket 6 is slidably connected to the channel rack 1 through the magnetic plate 13. The magnetic plate 13 is a T-shaped structure and is slidably connected to the upper end of the channel rack 1. The sliding magnetic plate 13 drives the mounting bracket 6 to slide.

[0060] During actual use, the channel rack 1 is set outdoors, and the movement of the magnetic plate 13 is controlled by magnetic force without contact, so as to maintain the complete sealing of the top of the channel rack 1 and prevent rainwater from penetrating.

[0061] The cleaning mechanism includes a cleaning scraper 9, a liquid spray plate 7 and a wiping roller 14, which are all arranged on the side wall of the mounting bracket 6, wherein the cleaning scraper 9 is made of elastic rubber material, and its bottom is fitted with the outer shell of the sensing panel 2 above the channel frame 1, an atomizing nozzle is arranged at the bottom of the liquid spray plate 7, and the liquid spray plate 7 is a hollow structure, and the wiping roller 14 is an elastic water-absorbent non-woven fabric.

[0062] After the liquid spray plate 7 sprays the disinfectant, the disinfectant is scraped off by the cleaning scraper 9 and then wiped by the wiping roller 14. After the liquid spray plate 7 sprays the disinfectant, the viruses and bacteria in the frequent contact areas of the sensing panel 2 are disinfected. The water stains on the outer wall of the sensing panel 2 are preliminarily scraped off by the cleaning scraper 9, and then wiped dry by the wiping roller 14. This is suitable for the virus disinfection at the ticket checking position after ticket checking using the QR code scanning method in real life, reducing the risk of cross-contact infection.

[0063] After the disinfectant kills the virus, the disinfectant remaining on the sensing panel 2 contains unkilled viruses and bacteria. In order to reduce the risk of virus and bacteria transmission caused by the volatilization of the disinfectant, the recovery mechanism generates negative pressure at the bottom of the wiping roller 14 to absorb the residual disinfectant. The negative pressure absorbs the residual disinfectant on the sensing panel 2 and the disinfectant absorbed by the wiping roller 14, which can effectively reduce the risk of virus and bacteria transmission caused by the volatilization of the disinfectant. At the same time, the negative pressure can improve the drying efficiency of the wiping roller 14, making it easier to wipe again.

[0064] The recovery mechanism controls the wiping roller 14 to fit the surface of the sensing panel 2 , so that after the negative pressure chamber is connected, the wiping roller 14 is controlled to fit the surface of the sensing panel 2 , thereby improving the cleaning efficiency.

[0065] The recovery mechanism includes a control pump 23, a recovery tube 17 and a support tube 16. The control pump 23 is a common negative pressure pump for generating negative pressure.

[0066] The support tube 16 is elastically mounted on the side wall of the mounting bracket 6 , the wiping roller 14 is fixedly mounted on the outer wall of the support tube 16 , and the sliding mounting bracket 6 controls the movement of the support tube 16 .

[0067] The inner cavity of the support tube 16 is connected to the input end of the control pump 23 through the recovery tube 17. A through hole is provided at the bottom of the support tube 16. The control pump 23 generates negative pressure, thereby facilitating the absorption of residual disinfectant on the surface of the sensing panel 2 and the disinfectant absorbed by the wiping roller 14.

[0068] The recovery mechanism also includes a connecting frame 15 and a connecting tube 19. The connecting tube 19 is fixedly installed on the inner wall of the connecting frame 15. The connecting frame 15 is slidably connected to the mounting bracket 6, and the bottom is fixedly connected to the side wall of the supporting tube 16. The sliding connecting frame 15 drives the supporting tube 16 to slide synchronously. When wiping, the sliding connecting frame 15 controls the wiping roller 14 and the outer wall of the sensing panel 2 to fit together. When the mounting bracket 6 slides, the outer wall of the sensing panel 2 is wiped.

[0069] One end of the recovery tube 17 passes through the mounting bracket 6, the bottom of the connecting tube 19 is sleeved on the outer wall of the recovery tube 17, and the connecting tube 19 is elastically connected to the connecting frame 15. The elastic force exerted on the connecting tube 19 pushes the connecting tube 19 to have a tendency to move away from the mounting bracket 6 in real time, thereby making the wiping roller 14 have a tendency to move away from the sensing panel 2.

[0070] The top of the connecting tube 19 is connected to the side wall of the supporting tube 16 through a conduit. When the recovery tube 17 is connected to the negative pressure chamber, the internal air pressure at the connection position between the connecting tube 19 and the recovery tube 17 is reduced, thereby controlling the connecting tube 19 to slide downward, and controlling the connecting frame 15 and the supporting tube 16 to slide synchronously, thereby achieving the control of the wiping roller 14 to fit the sensing panel 2 after the negative pressure is turned on.

[0071] An installation box 4 is fixedly installed on the outer wall of the channel frame 1 , a partition plate 25 is fixedly installed on the inner wall of the installation box 4 , and the control pump 23 is fixedly installed on the upper end surface of the partition plate 25 , and the partition plate 25 provides installation and support for the control pump 23 .

[0072] A shielding cover 3 is fixedly mounted on the outer wall of the channel rack 1. The shielding cover 3 is used to shield the mounting bracket 6 from direct sunlight when it is not sterilized.

[0073] An elastic ring 20 is fixedly installed on the outer wall of the recovery tube 17. The elastic ring 20 is made of common rubber material. The inner wall of the elastic ring 20 is tilted, and the outer wall of the elastic ring 20 slides and fits with the inner wall of the connecting tube 19, thereby realizing a sealed connection between the recovery tube 17 and the connecting tube 19. After the negative pressure chamber is connected, it is convenient for the connecting tube 19 to slide, and the inner wall of the elastic ring 20 is tilted, so that the recovered disinfectant can enter the interior of the recovery tube 17 from the connecting tube 19.

[0074] A support ring 18 is fixedly installed on the inner wall of the connecting tube 19, and the bottom of the support ring 18 is connected to the outer wall of the mounting bracket 6 through an elastic member. The elastic member is a common spring, one end of the spring is fixed to the bottom of the support ring 18, and the other end of the spring is fixed to the outer wall of the mounting bracket 6, thereby pushing the connecting tube 19 to have a tendency to slide upward in real time.

[0075] The inner cavity of the installation box 4 is divided into two upper and lower chambers by a partition plate 25. The chamber at the bottom of the installation box 4 is used to store disinfectant, thereby providing disinfectant during the disinfection and sterilization process.

[0076] An atomizing pump 26 is fixedly installed on the outer wall of the partition plate 25. The input end of the atomizing pump 26 is used to absorb the disinfectant. The output end of the atomizing pump 26 is connected to the inner cavity of the spray plate 7 through a conduit. After the atomizing pump 26 absorbs the disinfectant, it is atomized by the atomizing pump 26 and sprayed out by the spray plate 7 to realize the spraying of the disinfectant. When the mounting bracket 6 slides, the atomized disinfectant agent is sprayed along the outer wall of the sensing panel 2.

[0077] A control motor 12 is fixedly mounted on the inner wall of the channel frame 1, and a control screw 10 is fixedly mounted on the output shaft of the control motor 12. The control motor 12 is used to control the rotation of the screw 10, and the control screw 10 is connected to the channel frame 1 through the cooperation of the bearing and the bearing seat.

[0078] The outer wall of the control screw 10 is equipped with a transmission plate 11 that attracts the magnetic plate 13 through internal and external threads. The transmission plate 11 is a common magnet and attracts the magnetic plate 13. The control screw 10 is rotated to control the transmission plate 11 to slide. The transmission plate 11 controls the sliding of the magnetic plate 13 through magnetic force, thereby driving the mounting bracket 6 to slide.

[0079] A disinfection chamber 22 is fixedly mounted on the upper end surface of the partition plate 25. The outer wall of the disinfection chamber 22 is provided with a liquid inlet pipe 21 and an exhaust pipe 29 which are connected to the inner cavity of the disinfection chamber 22. The recovered disinfectant is stored inside the disinfection chamber 22. The exhaust pipe 29 is used to discharge the gas inside the disinfection chamber 22 to maintain the air pressure balance inside the disinfection chamber 22 when recovering the disinfectant.

[0080] One end of the recovery pipe 17 away from the connecting tube 19 is connected to the liquid inlet pipe 21, and the input end of the control pump 23 is connected to the exhaust pipe 29 through a conduit. When the control pump 23 is working, a negative pressure is generated in the inner cavity of the recovery pipe 17, and the recovered disinfectant inside the liquid inlet pipe 21 enters the inner cavity of the disinfection chamber 22 through the liquid inlet pipe 21.

[0081] A guide plate 27 is fixedly mounted on the inner wall of the disinfection chamber 22 . The guide plate 27 is tilted and located below the liquid inlet pipe 21 . The recovered disinfectant flows along the outer wall of the guide plate 27 to the interior of the disinfection chamber 22 .

[0082] The guide plate 27 is made of transparent material. The bottom of the guide plate 27 and the inner wall of the disinfection chamber 22 are both provided with a disinfection light source 28. The disinfection light source 28 is a common ultraviolet light source, which is used to disinfect viruses and bacteria remaining in the disinfectant.

[0083] Embodiment 2: Fig.11 As shown in Comparative Example 1, another embodiment of the present invention is:

[0084] The inner wall of the disinfection chamber 22 is fixedly mounted with a mounting cylinder 31 , and the inner inner wall of the mounting cylinder 31 is rotatably mounted with a turbine blade 30 , which is connected to the mounting cylinder 31 via a sealed bearing.

[0085] The inner cavity of the mounting cylinder 31 is communicated with the inner cavity of the disinfection chamber 22, and one end of the exhaust pipe 29 is fixedly connected to the outer wall of the mounting cylinder 31. When the exhaust pipe 29 is exhausted, the rotation of the turbine blade 30 is controlled by the airflow.

[0086] A transmission shaft 8 is fixedly installed at the center position of the axial end of the turbine blade 30, and a stirring blade 24 is fixedly installed on the outer wall of the transmission shaft 8. The turbine blade 30 controls the rotation of the stirring blade 24 through the transmission shaft 8, thereby stirring the recovered disinfectant to improve the efficiency of ultraviolet disinfection.

[0087] like Fig.12 As shown, a method for designing a cultural heritage landscape spatial database, the method adopts the above-mentioned cultural heritage landscape spatial database design device, and includes the following steps:

[0088] A1. Determine the purpose, functional requirements and user requirements of the database, and identify the landscape elements and spatial data types that need to be stored;

[0089] A2. Create a conceptual model to define the attributes and relationships of landscape objects;

[0090] A3. Count the number of tourists in the scenic spot through the ticket information detected by the sensing panel 2.

[0091] The following steps are also included:

[0092] A4. Combine the tourist quantity data with spatial data and landscape elements to generate a model;

[0093] A5. Define table structure, fields, indexes and relationships to ensure data storage integrity and query efficiency;

[0094] A6. Integrate existing spatial data and attribute data, and design data input and update processes.

[0095] It also includes the following steps:

[0096] A7. Create databases, write queries and manage programs, and optimize performance to meet actual needs;

[0097] A8. Perform database testing to ensure normal functionality, and regularly maintain and update data to maintain the validity and accuracy of the database.

[0098] The above-mentioned front, back, left, right, top and bottom are all based on the figures in the specification. Figure 1 As a benchmark, according to the person's observation perspective, the side of the device facing the observer is defined as the front, the left side of the observer is defined as the left, and so on.

[0099] In the description of the present invention, it should be understood that the terms "center", "longitudinal", "lateral", "front", "back", "left", "right", "vertical", "horizontal", "top", "bottom", "inside", "outside" and the like indicate orientations or positional relationships based on the orientations or positional relationships shown in the accompanying drawings, and are only for the convenience of describing the present invention and simplifying the description, rather than indicating or implying that the device or element referred to must have a specific orientation, be constructed and operated in a specific orientation, and therefore should not be understood as limiting the scope of protection of the present invention.

[0100] The above shows and describes the basic principles, main features and advantages of the present invention. It should be understood by those skilled in the art that the present invention is not limited to the above embodiments. The above embodiments and descriptions are only for explaining the principles of the present invention. Without departing from the spirit and scope of the present invention, the present invention may have various changes and improvements, which fall within the scope of the present invention. The scope of protection of the present invention is defined by the attached claims and their equivalents.

Claims

1. A design device for a cultural heritage landscape spatial database, Features: Including ticket checking agency, control agency, cleaning agency and recycling agency; The ticket checking mechanism comprises a channel frame (1), a channel plate (5) and a sensing panel (2); the channel plate (5) is rotatably arranged on a side wall of the channel frame (1); the sensing panel (2) is used to detect ticket information and control the selection of the channel plate (5) according to the ticket information; The control mechanism comprises a mounting bracket (6) and a magnetic plate (13), wherein the magnetic plate (13) is slidably mounted on the outer wall of the channel frame (1), and the sliding of the magnetic plate (13) is controlled by magnetic force, and the mounting bracket (6) is slidably connected to the channel frame (1) via the magnetic plate (13); The cleaning mechanism comprises a cleaning scraper (9), a liquid spraying plate (7) and a wiping roller (14), wherein the cleaning scraper (9), the liquid spraying plate (7) and the wiping roller (14) are all arranged on the side wall of the mounting bracket (6), and the liquid spraying plate (7) sprays the disinfectant, then scrapes the disinfectant off through the cleaning scraper (9), and then wipes it through the wiping roller (14); The recovery mechanism absorbs residual disinfectant by generating negative pressure at the bottom of the wiping roller (14), while controlling the wiping roller (14) to fit the surface of the sensing panel (2).

2. A design device for a cultural heritage landscape spatial database according to claim 1, Features: The recovery mechanism comprises a control pump (23), a recovery pipe (17) and a support cylinder (16); The support tube (16) is elastically mounted on the side wall of the mounting bracket (6), the wiping roller (14) is fixedly mounted on the outer wall of the support tube (16), and the inner cavity of the support tube (16) is connected to the input end of the control pump (23) through the recovery pipe (17).

3. The design device for a cultural heritage landscape spatial database according to claim 2, Features: The recovery mechanism further comprises a connecting frame (15) and a connecting tube (19); the connecting tube (19) is fixedly mounted on the inner wall of the connecting frame (15); the connecting frame (15) is slidably connected to the mounting bracket (6), and the bottom is fixedly connected to the side wall of the support tube (16); one end of the recovery tube (17) passes through the mounting bracket (6); the bottom of the connecting tube (19) is sleeved on the outer wall of the recovery tube (17), and the connecting tube (19) is elastically connected to the connecting frame (15); the top of the connecting tube (19) is connected to the side wall of the support tube (16) through a conduit.

4. The design device for a cultural heritage landscape spatial database according to claim 3, Features: The outer wall of the channel frame (1) is fixedly mounted with a mounting box (4), the inner wall of the mounting box (4) is fixedly mounted with a partition plate (25), the control pump (23) is fixedly mounted on the upper end surface of the partition plate (25), and the outer wall of the channel frame (1) is fixedly mounted with a shielding cover (3); An elastic ring (20) is fixedly mounted on the outer wall of the recovery pipe (17), the inner wall of the elastic ring (20) is inclined, and the outer wall of the elastic ring (20) is slidably fitted with the inner wall of the connecting tube (19); A support ring (18) is fixedly mounted on the inner wall of the connecting tube (19), and the bottom of the support ring (18) is connected to the outer wall of the mounting bracket (6) via an elastic member.

5. The design device for a cultural heritage landscape spatial database according to claim 4, Features: The inner cavity of the installation box (4) is divided into two upper and lower chambers by the partition plate (25), and the chamber at the bottom of the installation box (4) is used to store disinfectant; An atomizing pump (26) is fixedly mounted on the outer wall of the partition plate (25), the input end of the atomizing pump (26) is used to absorb disinfectant, and the output end of the atomizing pump (26) is connected to the inner cavity of the liquid spraying plate (7) through a conduit; A control motor (12) is fixedly mounted on the inner wall of the channel frame (1), a control screw (10) is fixedly mounted on the output shaft of the control motor (12), and a transmission plate (11) that attracts the magnetic plate (13) is mounted on the outer wall of the control screw (10) through internal and external threads.

6. The design device for a cultural heritage landscape spatial database according to claim 5, Features: A disinfection chamber (22) is fixedly mounted on the upper end surface of the partition plate (25), and an outer wall of the disinfection chamber (22) is provided with a liquid inlet pipe (21) and an exhaust pipe (29) which are in communication with the inner cavity of the disinfection chamber (22); One end of the recovery pipe (17) away from the connecting tube (19) is connected to the liquid inlet pipe (21), and the input end of the control pump (23) is connected to the exhaust pipe (29) through a conduit; A material guide plate (27) is fixedly mounted on the inner wall of the disinfection chamber (22); the material guide plate (27) is tilted and located below the liquid inlet pipe (21); the material guide plate (27) is made of a transparent material; and a disinfection light source (28) is disposed at the bottom of the material guide plate (27) and the inner wall of the disinfection chamber (22).

7. The device for designing a cultural heritage landscape spatial database according to claim 6, Features: A mounting cylinder (31) is fixedly mounted on the inner wall of the disinfection chamber (22), a turbine blade (30) is rotatably mounted on the inner wall of the mounting cylinder (31), and the inner cavity of the mounting cylinder (31) is communicated with the inner cavity of the disinfection chamber (22), and one end of the exhaust pipe (29) is fixedly connected to the outer wall of the mounting cylinder (31); A transmission shaft (8) is fixedly mounted at the center position of the axial end of the turbine blade (30), and a stirring blade (24) is fixedly mounted on the outer wall of the transmission shaft (8).

8. A method for designing a cultural heritage landscape spatial database, the method using the cultural heritage landscape spatial database design device according to claim 7, Features: The following steps are involved: A1. Determine the purpose, functional requirements and user requirements of the database, and identify the landscape elements and spatial data types that need to be stored; A2. Create a conceptual model to define the attributes and relationships of landscape objects; A3. Count the number of tourists in the scenic spot through the ticket information detected by the sensing panel (2).

9. The method for designing a cultural heritage landscape spatial database according to claim 8, Features: The following steps are also included: A4. Combine the tourist quantity data with spatial data and landscape elements to generate a model; A5. Define table structure, fields, indexes and relationships to ensure data storage integrity and query efficiency; A6. Integrate existing spatial data and attribute data, and design data input and update processes.

10. The method for designing a cultural heritage landscape spatial database according to claim 9, Features: It also includes the following steps: A7. Create databases, write queries and manage programs, and optimize performance to meet actual needs; A8. Perform database testing to ensure normal functionality, and regularly maintain and update data to maintain the validity and accuracy of the database.

Images