Intelligent livestock positioning and drinking information acquisition system and method

Abstract

The invention relates to the technical field of livestock breeding, and discloses an intelligent livestock positioning and drinking information acquisition system and method, and the system comprises a monitoring terminal, relay node devices disposed in breeding houses, information acquisition devices disposed on fences, and electronic tags disposed on livestock bodies. The information acquisition device comprises a reader-writer, a controller and a communication module; identity numbers of livestock and numbers corresponding to breeding houses and fences are written into the electronic tags in advance. The information acquisition device obtains the identity number, the positioning information and the drinking information of the livestock by identifying the electronic tag on the livestock, and uploads the information to the monitoring terminal through the relay node device. Through cooperation of the electronic tag read-write technology and the remote communication technology, comprehensive monitoring of the identity number, the positioning information and the water drinking information of the livestock is achieved, the water drinking change of the livestock is reflected in real time, the intelligent management level is improved, and health management of the livestock is facilitated.

Description

Technical Field

[0001] The present invention relates to the technical field of animal husbandry, and in particular to an intelligent livestock positioning and drinking water information collection system and method. Background Art

[0002] In recent years, with the continuous increase in the scale and output value of China's animal husbandry industry, the breeding methods have been continuously promoted in the direction of scale, standardization and mechanization. The quality management and control of animals and the welfare breeding requirements have also been continuously improved. Precision feeding and smart breeding have become an inevitable trend in the breeding industry. Livestock positioning and drinking water information collection technology are very important for the modern breeding management of livestock. These technologies can not only provide key monitoring data, but also help to improve the health status and production efficiency of livestock.

[0003] At present, there are still some defects and problems in the intelligentization of livestock drinking water detection, which affect the breeding efficiency and livestock health monitoring. The following are some of the main defects and problems: 1. Data collection is not comprehensive. The existing drinking water detection system often only installs sensors at specific drinking water points and cannot cover the entire breeding area, resulting in incomplete data. Most systems only monitor the amount of drinking water, lack of comprehensive monitoring of multi-dimensional data such as drinking water frequency and time for livestock individuals; 2. Insufficient real-time performance, unable to realize remote online data collection and transmission, unable to timely feedback on livestock drinking water conditions, low data update frequency, unable to reflect livestock drinking water changes in real time; 3. Limited data analysis capabilities. Most existing systems can only provide simple single data analysis, lack of in-depth analysis and comprehensive monitoring functions, and cannot provide users with a good interactive experience. Therefore, it is urgent to further improve the intelligence level of livestock positioning, drinking water and other information detection systems. Summary of the invention

[0004] The purpose of the present invention is to provide an intelligent livestock positioning and drinking water information collection system and method. Through the cooperation of electronic tag reading and writing technology and remote communication technology, comprehensive monitoring of livestock identity numbers, positioning information and drinking water information can be achieved, and changes in livestock drinking water can be reflected in real time. The level of intelligent management is improved, and health management of livestock is facilitated, providing technical support for improving the quality of life of livestock and enhancing the growth and development level of livestock.

[0005] To achieve the above object, the present invention provides the following solutions:

[0006] An intelligent livestock positioning and drinking water information collection system, comprising: a monitoring terminal, a relay node device set in each breeding house, an information collection device set in each fence, and an electronic tag set on each livestock; wherein the breeding house is provided with a plurality of fences, and a plurality of livestock are kept in the fences;

[0007] The information collection device is arranged at the livestock drinking water device, and comprises a reader / writer for identifying the electronic tag, a controller connected to the reader / writer, and a communication module connected to the controller, wherein the controller is connected to the relay node device through the communication module; the relay node device is connected to the monitoring terminal through communication;

[0008] The electronic tag is pre-written with the livestock's identification number, the breeding house where it is located, and the number corresponding to the fence where it is located;

[0009] The information collection device obtains the livestock's identity number, positioning information and drinking water information by identifying the electronic tags on the livestock, and uploads them to the monitoring terminal through the relay node device. The positioning information includes the numbers corresponding to the livestock's breeding house and the fence where the livestock is located, and the drinking water information includes the number of times the livestock drinks water and the time of drinking.

[0010] Furthermore, the electronic tag is an RFID tag, and the reader / writer is an RFID reader / writer.

[0011] Furthermore, the reader / writer is connected to a read / write antenna, and the read / write antenna is used to identify the electronic tag.

[0012] Furthermore, the outer cover of the information collection device is provided with a protective structure for preventing livestock from damaging the information collection device.

[0013] Furthermore, a plurality of the information collection devices are communicatively connected to a relay node device, a plurality of the relay node devices are communicatively connected to a network switch, the network switch is communicatively connected to the monitoring terminal, and the monitoring terminal is an industrial computer.

[0014] Furthermore, the information collection device and the relay node device, and the relay node device and the industrial computer are connected via Ethernet communication based on the TCP / IP protocol, the information collection device serves as a TCP client, and the industrial computer serves as a TCP server.

[0015] Furthermore, the industrial computer is equipped with Kingview 7.5 monitoring platform and MySQL database.

[0016] The present invention also provides an intelligent livestock positioning and drinking water information collection method, which is applied to the above-mentioned intelligent livestock positioning and drinking water information collection system, and comprises the following steps:

[0017] The reader / writer reads the electronic tag on the livestock drinking water at the livestock drinking water device, obtains the information carried by the electronic tag, including the livestock's identity number and location information, and uploads it to the monitoring terminal. The monitoring terminal inserts the received livestock's identity number, breeding house number, fence number, date, and time into the data summary table of the MySQL database;

[0018] The management platform of the monitoring terminal establishes a connection to the MySQL database based on the database host address, database user name, database password, and database name to be connected;

[0019] By executing SQL statements, the data table is filtered, and the information carried by the most recently obtained electronic tags is inserted into a table named after the breeding house number according to the breeding house where it is located;

[0020] The table corresponding to each breeding house is selected in turn, and the fences are inserted into the table named with the same fence number. During the insertion process, it is determined whether the livestock is drinking water for the first time;

[0021] If yes, the first drinking date and first drinking time shall be the date and time of the most recently obtained information;

[0022] If not, find the first appearance date, time and the last appearance date, time of the electronic tag within the most recently set time period, take the last appearance date, time as the latest drinking date and the latest drinking time, and determine the number of days in the column based on the number of days from the last appearance date minus the first appearance date, and determine the drinking time based on the length of time from the last appearance time minus the first appearance time;

[0023] The number of drinking times is accumulated on a daily basis, and each time the livestock drinks water, the number of drinking times per day is increased by 1.

[0024] Furthermore, the KingView 7.5 monitoring platform carried by the monitoring terminal provides a user interaction interface, and the user interaction interface enters the collection interface of different houses according to the breeding house number, and then divides the table according to the fence number, and the information collected from the electronic tag corresponding to each fence is inserted into the corresponding table;

[0025] The collection interface of each breeding house has a button to switch to the corresponding sub-column interface. In each sub-column interface, you can query all electronic tag information, query electronic tag information by condition, or query the information of a single electronic tag;

[0026] The user interaction interface summarizes and displays the livestock's identity number, breeding house number, pen number, first drinking water date, first drinking water time, latest drinking water date, latest drinking water time, number of days in the pen, number of drinking times per day, and drinking time per day. The breeding house number, pen number, and number of days in the pen are used for livestock positioning analysis, and the latest drinking water date and time, number of drinking times per day, and drinking time per day are used for livestock heat stress response and health status analysis.

[0027] According to the specific embodiments provided by the present invention, the intelligent livestock positioning and drinking water information collection system and method provided by the present invention disclose the following technical effects:

[0028] 1. Precise management: Each livestock is equipped with an electronic tag to uniquely identify its identity. When the livestock drinks water, the reader reads the identity information of its electronic tag. Non-contact identification is convenient and fast, and not easy to damage. Through electronic tag (RFID) technology, the identity of each livestock can be accurately identified to achieve refined management;

[0029] 2. Real-time monitoring: Through the remote communication cooperation of information collection devices and monitoring terminals, the drinking water information of livestock is collected and displayed in real time, helping breeders to find abnormalities in time. By real-time monitoring of livestock drinking behavior, potential health problems can be discovered in time and preventive measures can be taken;

[0030] 3. Data storage: All data can be stored in the MySQL database of the monitoring terminal, which is convenient for long-term storage, query and analysis, and provides a data basis for breeding management analysis;

[0031] 4. Multi-dimensional monitoring: Based on the electronic tag, the livestock's identity number, location information and drinking water information are obtained, and the livestock's identity number, breeding house number, fence number, first drinking water date, first drinking water time, latest drinking water date, latest drinking water time, number of days in the pen, number of drinking water times per day, and drinking water duration per day are displayed, realizing multi-dimensional monitoring of livestock breeding information and improving the comprehensiveness of monitoring data;

[0032] 5. User-friendly: The KingView 7.5 monitoring platform of the monitoring terminal provides an intuitive user interface for easy operation and management;

[0033] 6. Reduce time and labor costs: Through automated data collection and storage, as well as convenient data analysis software, the time and human resources required for monitoring can be significantly reduced, thereby improving monitoring efficiency.

[0034] In summary, the present invention innovatively optimizes the livestock drinking water information collection technology, provides a more efficient, comprehensive and convenient solution for animal husbandry, and is expected to improve the efficiency of animal husbandry and animal welfare. BRIEF DESCRIPTION OF THE DRAWINGS

[0035] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative labor.

[0036] Figure 1 This is a structural block diagram of an intelligent livestock positioning and drinking water information collection system according to an embodiment of the present invention;

[0037] Figure 2 This is a network structure diagram of the intelligent livestock positioning and drinking water information collection system according to an embodiment of the present invention;

[0038] Figure 3 This is a flow chart of an intelligent livestock positioning and drinking water information collection method according to an embodiment of the present invention;

[0039] Figure 4 The display interface of House A in Example 1 of the present invention;

[0040] Figure 5 The display interface of Embodiment B of the present invention;

[0041] Figure 6 A table schematic diagram of a column interface according to an embodiment of the present invention. DETAILED DESCRIPTION

[0042] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0043] The purpose of the present invention is to provide an intelligent livestock positioning and drinking water information collection system and method. Through the cooperation of electronic tag reading and writing technology and remote communication technology, comprehensive monitoring of livestock identity numbers, positioning information and drinking water information can be achieved, and changes in livestock drinking water can be reflected in real time. The level of intelligent management is improved, and health management of livestock is facilitated, providing technical support for improving the quality of life of livestock and enhancing the growth and development level of livestock.

[0044] In order to make the above-mentioned objects, features and advantages of the present invention more obvious and easy to understand, the present invention is further described in detail below with reference to the accompanying drawings and specific embodiments.

[0045] On the one hand, if Figure 1 and Figure 2As shown, the intelligent livestock positioning and drinking water information collection system provided by the present invention includes: a monitoring terminal, a relay node device set in each breeding house, an information collection device set in each fence, and an electronic tag set on each livestock (for example, an ear tag worn on the ear of the livestock); wherein a plurality of fences are set in the breeding house, and a plurality of livestock are kept in the fences;

[0046] The information collection device is arranged at a livestock drinking water device (e.g., a drinking trough), and comprises a reader / writer for identifying the electronic tag, a controller connected to the reader / writer, and a communication module connected to the controller, wherein the controller is connected to the relay node device through the communication module; the relay node device is connected to the monitoring terminal through communication;

[0047] The electronic tag is pre-written with information such as the livestock's identity number, the breeding house where it is located, and the number of the fence where it is located;

[0048] The information collection device obtains the livestock's identity number, positioning information and drinking water information by identifying the electronic tags on the livestock, and uploads them to the monitoring terminal through the relay node device. The positioning information includes the numbers corresponding to the livestock's breeding house and the fence where the livestock is located, and the drinking water information includes the number of times the livestock drinks water and the time of drinking.

[0049] For example, the electronic tag is an RFID tag, and the reader is an RFID reader. In the embodiment of the present invention, the identity of the livestock is registered through the RFID tag, and then the RFID reader is used to read the calibrated livestock identity, so that the livestock can be managed in an informationized manner. The reader is connected to a read / write antenna, and the read / write antenna is used to identify the electronic tag.

[0050] For example, the outer cover of the information collection device is provided with a protective structure to prevent livestock from damaging the information collection device. For example, the read / write antenna fixed to the drinking water place is arranged behind the PVC baffle of the drinking water place, which can play the role of waterproof protection of the read / write antenna and prevent livestock from biting.

[0051] In addition, the information collection device may also be provided with a temperature and humidity sensor, which is electrically connected to the controller and is used to monitor the temperature, humidity and other information of the livestock's environment.

[0052] like Figure 2 As shown, multiple information collection devices are connected to a relay node device, multiple relay node devices are connected to a network switch, the network switch is connected to the monitoring terminal, and the monitoring terminal is an industrial computer. A relay node device is a device that acts as a signal repeater in a communication link, and is used to extend the communication distance, improve signal quality, and increase network capacity.

[0053] Specifically, the information collection device and the relay node device, and the relay node device and the industrial computer are connected by Ethernet communication based on the TCP / IP protocol, the information collection device acts as a TCP client, and the industrial computer acts as a TCP server. The IP addresses of all information collection devices and the industrial computer IP address are set in the same network segment (that is, the IP address is set to 192.168.3.x, for example, the x value of the information collection device in the breeding house A is 1-32, the x value of the information collection device in the breeding house B is 45-77, and the x value of the industrial computer is 3).

[0054] The present invention also performs network parameter configuration of the information collection device, network parameter configuration of the industrial computer Ethernet, and parameter configuration of the serial port server. The network parameter configuration of the information collection device includes: the service type is set to TCP client, the DHCP mode of the static IP, the device IP address is set to 192.168.3.x, the device port number is set to 49152, the subnet mask is set to 255.255.255.0, the default gateway is 192.168.3.1, the server IP address is set to 192.168.3.3, and the server port number is set to 15312.

[0055] The network parameter configuration of the industrial computer Ethernet includes: the IP address is set to 192.168.3.3, the subnet mask is 255.255.255.0, the gateway is set to 192.168.3.1, and the preferred DNS is 114.114.114.114.

[0056] For example, the communication data frame encapsulation format in the embodiment of the present invention is: 0D XX EE00 xxxx xx xxxxxxxx+CRC-16 (all bytes are in hexadecimal), for example, the data frame is OD 01EE00 C131230508000001+CRC-16, which expresses: 0D is the data length: 01 is the device number (wherein 01-23 is the device number of house A, and 24-50 is the device number of house B); EE00 is fixed data: C131230508000001 is the livestock electronic tag number, the first digit is A or C (C represents core, A represents ordinary), 131 represents the region, 23 represents the year, 0508 represents the date of birth, and 000001 represents the number (core C: 000001-002000; ordinary A: 002001-004001).

[0057] Specifically, the industrial computer is equipped with KingView 7.5 monitoring platform and MySQL database. The system obtains the livestock electronic tag identity, drinking time, drinking frequency and other information through the RFID reader installed at the drinking place, and transmits it to the industrial computer. The KingView 7.5 monitoring platform accurately locates the livestock and displays the drinking water information, and inserts it into the MySQL database. Finally, the livestock accurate positioning and livestock drinking water information are displayed on the user interaction interface.

[0058] On the other hand, Figure 3 As shown, the present invention also provides an intelligent livestock positioning and drinking water information collection method, which is applied to the above-mentioned intelligent livestock positioning and drinking water information collection system, and includes the following steps:

[0059] The reader / writer reads the electronic tag on the livestock drinking water at the livestock drinking water device, obtains the information carried by the electronic tag, including the livestock's identity number and location information, and uploads it to the monitoring terminal. The monitoring terminal inserts the received livestock's identity number, breeding house number, fence number, date, and time into the data summary table of the MySQL database;

[0060] The management platform of the monitoring terminal (for example, KingView 7.5 monitoring platform) establishes a connection to the MySQL database based on the database host address, database user name, database password, and database name to be connected;

[0061] By executing SQL statements, the data table is filtered, and the information carried by the most recently obtained electronic tags is inserted into a table named after the breeding house number according to the breeding house where it is located;

[0062] The table corresponding to each breeding house is selected in turn, and the fences are inserted into the table named with the same fence number. During the insertion process, it is determined whether the livestock is drinking water for the first time (for example, based on the collection record of the livestock's identity number, it is determined whether the livestock appears at the drinking place for the first time);

[0063] If yes, the first drinking date and first drinking time shall be the date and time of the most recently obtained information;

[0064] If not, find the first appearance date, time and the last appearance date, time of the electronic tag within the most recently set time period (e.g., 5 days, 15 days, or a month, etc.), take the last appearance date, time as the latest drinking date and the latest drinking time, and determine the number of days in the column based on the number of days from the last appearance date minus the first appearance date, and determine the drinking time based on the length of time from the last appearance time minus the first appearance time;

[0065] The number of drinking times is accumulated on a daily basis, and each time the livestock drinks water, the number of drinking times per day is increased by 1.

[0066] After the above steps, the management platform processes the database information to obtain information such as the livestock breeding house, the fence, the first drinking water date, the first drinking water time, the latest drinking water date, the latest drinking water time, the number of days in the pen, the number of times the livestock drink water per day, and the duration of drinking water per day.

[0067] Figure 4-Figure 6 This is the display interface on the industrial computer in the embodiment of the present invention; the present invention takes two breeding houses, A and B, as examples. Figure 4 This is the interface diagram of the breeding house A. Figure 5 This is the interface diagram of breeding house B. Figure 6 This is the interface diagram of fence 8AW_6 column.

[0068] The KingView 7.5 monitoring platform carried by the monitoring terminal provides a user interaction interface. The user interaction interface enters the collection interface of different houses according to the breeding house number, and then enters the table according to the fence number. The information collected from the electronic tag corresponding to each fence is inserted into the corresponding table. Press the button to enter the user interaction interface of the electronic tag collection system. The collection interface of each breeding house has a button to switch to the corresponding column interface. In each column interface, all electronic tag information is queried, electronic tag information is queried conditionally, or a single electronic tag information is queried; the user interaction interface summarizes and displays the livestock's identity number, the breeding house number, the fence number, the first drinking water date, the first drinking water time, the latest drinking water date, the latest drinking water time, the number of days in the pen, the number of drinking water per day, and the length of drinking water per day. The data information of the breeding house number, the fence number, and the number of days in the pen is used for livestock positioning analysis, providing data support for accurate livestock positioning, and the latest drinking water date and time, the number of drinking water per day, and the length of drinking water per day are used for livestock heat stress reaction and health status analysis, providing data support for livestock heat stress reaction and health status.

[0069] In the embodiment of the present invention, sheep are taken as an example. The information collected by the information collection device of each sheep house is gathered to the network switch through the network cable, and the network switch transmits the data to the industrial computer. The serial port server software on the industrial computer communicates with the KingView 7.5 monitoring platform, and sends the collected electronic tag information to the KingView 7.5 monitoring platform in the form of a data frame. For example, the data frame encapsulation format is: 0D XX EE00 xxxx xx xx xxxxxx+CRC-16 (all bytes are in hexadecimal), for example, the data frame is OD 01EE00 C131230508000001+CRC-16. Among them, 01 is the number of the information collection device (where 01-23 is the number of the information collection device in the A house, and 24-50 is the number of the information collection device in the B house), and an information collection device is installed in each fence, so that the fence number where the sheep is located is distinguished by the number of different information collection devices; C131230508000001 is the electronic tag of the sheep.

[0070] At the same time, in order to facilitate the query of information of a single sheep, it is also necessary to establish a digital dictionary such as shed number, date, time, query shed number, query pen number, query electronic tag number, query date, and query time.

[0071] The digital dictionary established by the intelligent livestock positioning and drinking water information collection method for sheep identification is shown in Table 1 below.

[0072] Table 1

[0073]

[0074] The present invention solves the problem of livestock positioning and drinking water collection information. Specifically, it includes the following major improvements:

[0075] Monitoring and data analysis design: By installing monitoring software and data analysis software on the industrial computer, the collected data can be detected, displayed, stored and analyzed in real time. It can also run without connecting to the network, providing more convenience and meeting the needs of different users.

[0076] Design of the information collection device: Place a code scanning device at the drinking water point. By obtaining different electronic tags when the livestock drink water, the information such as the livestock's house, pen, first drinking date, first drinking time, latest drinking date, latest drinking time, number of days in the pen, number of drinking times, and drinking duration can be recorded. Not only can the livestock's location be accurately located, but also information such as the livestock's drinking time and frequency can be obtained, and different data can be classified and analyzed. This system will provide data support for optimizing the drinking water management of captive livestock.

[0077] In summary, the intelligent livestock positioning and drinking water information collection system and method provided by the present invention has the following technical advantages:

[0078] 1. More comprehensive data collection: Traditional methods usually only measure livestock drinking water information, while the present invention can not only locate the location of livestock, but also obtain information such as livestock drinking time and frequency, providing more comprehensive data and better reflecting the environmental conditions in the breeding house;

[0079] 2. Reduce time and labor costs: Through automated data collection and storage, as well as convenient data analysis software, the time and human resources required for monitoring can be significantly reduced, thus improving monitoring efficiency;

[0080] 3. Stability of control: The core controller of the control hardware uses RFID electronic tag collection technology and monitoring software Kingview 7.5SP5, which uses stable hardware and software to make its collected data safer and more reliable, increasing the stability of the device's performance.

[0081] This invention innovatively optimizes the livestock drinking water information collection technology, providing a more efficient, comprehensive and convenient solution for animal husbandry, and is expected to improve the efficiency of animal husbandry and animal welfare.

[0082] The principles and implementation methods of the present invention are described in this article using specific examples. The description of the above embodiments is only used to help understand the method and core idea of ​​the present invention. At the same time, for those skilled in the art, according to the idea of ​​the present invention, there will be changes in the specific implementation methods and application scope. In summary, the content of this specification should not be understood as limiting the present invention.

Claims

1. An intelligent livestock positioning and drinking water information collection system, characterized in that: include: Monitoring terminal, relay node devices set in each breeding house, information collection devices set in each fence, and electronic tags set on each livestock; wherein a plurality of fences are set in the breeding house, and a plurality of livestock are kept in the fences; The information collection device is arranged at the livestock drinking water device, and comprises a reader / writer for identifying the electronic tag, a controller connected to the reader / writer, and a communication module connected to the controller, wherein the controller is connected to the relay node device through the communication module; the relay node device is connected to the monitoring terminal through communication; The electronic tag is pre-written with the livestock's identification number, the breeding house where it is located, and the number corresponding to the fence where it is located; The information collection device obtains the livestock's identity number, positioning information and drinking water information by identifying the electronic tags on the livestock, and uploads them to the monitoring terminal through the relay node device. The positioning information includes the numbers corresponding to the livestock's breeding house and the fence where the livestock is located, and the drinking water information includes the number of times the livestock drinks water and the time of drinking.

2. The intelligent livestock positioning and drinking water information collection system according to claim 1 is characterized in that: The electronic tag is an RFID tag, and the reader is an RFID reader.

3. The intelligent livestock positioning and drinking water information collection system according to claim 1 is characterized in that: The reader / writer is connected to a read / write antenna, and the read / write antenna is used to identify the electronic tag.

4. The intelligent livestock positioning and drinking water information collection system according to claim 1 is characterized in that: The outer cover of the information collection device is provided with a protective structure for preventing livestock from damaging the information collection device.

5. The intelligent livestock positioning and drinking water information collection system according to claim 1 is characterized in that: A plurality of the information collection devices are communicatively connected to a relay node device, a plurality of the relay node devices are communicatively connected to a network switch, the network switch is communicatively connected to the monitoring terminal, and the monitoring terminal adopts an industrial computer.

6. The intelligent livestock positioning and drinking water information collection system according to claim 5 is characterized in that: The information collection device and the relay node device, as well as the relay node device and the industrial computer are connected via Ethernet communication based on the TCP / IP protocol. The information collection device serves as a TCP client, and the industrial computer serves as a TCP server.

7. The intelligent livestock positioning and drinking water information collection system according to claim 5 is characterized in that: The industrial computer is equipped with KingView 7.5 monitoring platform and MySQL database.

8. An intelligent livestock positioning and drinking water information collection method, applied to the intelligent livestock positioning and drinking water information collection system according to any one of claims 1 to 7, characterized in that: The following steps are involved: The reader / writer reads the electronic tag on the livestock drinking water at the livestock drinking water device, obtains the information carried by the electronic tag, including the livestock's identity number and location information, and uploads it to the monitoring terminal. The monitoring terminal inserts the received livestock's identity number, breeding house number, fence number, date, and time into the data summary table of the MySQL database; The management platform of the monitoring terminal establishes a connection to the MySQL database based on the database host address, database user name, database password, and database name to be connected; By executing SQL statements, the data table is filtered, and the information carried by the most recently obtained electronic tags is inserted into a table named after the breeding house number according to the breeding house where it is located; The table corresponding to each breeding house is selected in turn, and the fences are inserted into the table named by the fence number. During the insertion process, it is determined whether the livestock is drinking water for the first time; If yes, the first drinking date and first drinking time shall be the date and time of the most recently obtained information; If not, find the first appearance date, time and the last appearance date, time of the electronic tag within the most recently set time period, take the last appearance date, time as the latest drinking date and the latest drinking time, and determine the number of days in the column based on the number of days from the last appearance date minus the first appearance date, and determine the drinking time based on the length of time from the last appearance time minus the first appearance time; The number of drinking times is accumulated on a daily basis, and each time the livestock drinks water, the number of drinking times per day is increased by 1.

9. The intelligent livestock positioning and drinking water information collection method according to claim 8, characterized in that: The KingView 7.5 monitoring platform carried by the monitoring terminal provides a user interaction interface. The user interaction interface enters the collection interface of different houses according to the breeding house number, and then divides the table according to the fence number. The information collected from the electronic tag corresponding to each fence is inserted into the corresponding table; The collection interface of each breeding house has a button to switch to the corresponding sub-column interface. In each sub-column interface, you can query all electronic tag information, query electronic tag information by condition, or query the information of a single electronic tag; The user interaction interface summarizes and displays the livestock's identity number, breeding house number, pen number, first drinking water date, first drinking water time, latest drinking water date, latest drinking water time, number of days in the pen, number of drinking times per day, and drinking time per day. The breeding house number, pen number, and number of days in the pen are used for livestock positioning analysis, and the latest drinking water date and time, number of drinking times per day, and drinking time per day are used for livestock heat stress response and health status analysis.

Images