International Journal of u- and e- Service, Science and Technology Vol.9, No. 3 (2016), pp.1-8 http://dx.doi.org/10.14257/ijunesst.2016.9.3.01
Logistics Management System Design Based on GIS Qiuyan Wang College of Economics, Harbin University of Science and Technology, Harbin, China 1
[email protected] Abstract In order to solve such problems as large workload and poor safe reliability of manual piecework during short-distance logistics transportation, GIS information acquisition technology, wireless communication data transmission technology and two-dimension code technology are adopted to design STM32 based Logistics Management & distribution data teletransmission management system in order to acquire real-time cargo data during the logistics distribution process; meanwhile, these data are transmitted to Logistics Management System through GPRS wireless network, thus to realize the centralized management of real-time cargo transportation information. Keywords: Logistics Management System; GPRS wireless communication; GIS
1. Introduction In recent years, along with the prosperous development of logistics industry, the quantity of logistically transported cargos is gradually increased and the economic losses caused by improper Logistics Management are also increased year by year [1]. In order to reduce losses, various large companies at home and abroad have respectively designed their own logistics inquiry systems, but manual mode is stilled adopted in the logistics industry for Logistics Management and accordingly economic losses are frequently caused by human factors. Such modes as manual sorting and manual piecework adopted for traditional Logistics Management have such obvious defects as many subjective factors, information delay, real-time cargo transportation state monitoring failure [2]. At present, with the features of permanent online performance, cheap charge, easy networking, high transmission rate, etc., GPS has been widely applied for vehicle monitoring and is especially applicable to sudden and frequent flow data transmission [3], and the theoretical peak value of data transmission rate supported thereby can reach 171.2kb/s, so GPRS network is adopted as the information transmission tool for this system. Meanwhile, in order to more visually monitor the logistics information of the cargos and record the cargo distribution routes during the logistics transportation process, GIS (Geographic Information System or Geo-Information system) is also adopted for this system. Specifically, GIS also called “Geographic Information System” or “Resource and Environment Information System” is a particularly important spatial information system, namely a technical system able to collect, store, manage, calculate, analyze, display and describe relevant spatial geographic distribution data under the support of computer software and hardware system[4-9]. In this article, GIS technology and two-dimension code automatic identification technology are applied to the Logistics Management System, wherein the handheld terminal equipment is adopted to monitor cargo loading, handover and delivery, and the two-dimension code identification technology is adopted to uniquely identify cargo information and accordingly realize the digital management during the logistics process. The features of Logistics Management have determined the large quantity of vehicle terminals, the dispersed locations and the great data acquisition difficulty. In this article,
ISSN: 2005-4246 IJUNESST Copyright ⓒ 2016 SERSC
International Journal of u- and e- Service, Science and Technology Vol.9, No. 3 (2016)
STM32 based SCM location information acquisition, data teletransmission and GIS based Logistics Management platform are combined to design system software and hardware and analyze system architecture, and such combination is a beneficial try for current logistics real-time inquiry and management technologies.
2. General Design of System Logistics teletransmission management system is composed of vehicle-mounted GSM module, database service module and Logistics Management platform, wherein the vehicle-mounted GSM module is mainly responsible for basic cargo unit management, real-time distribution data communication, response to control instructions of Logistics Management platform, etc.; the database service module is mainly responsible for storing logistics information and cargo information; the Logistics Management platform is mainly responsible for monitoring, displaying and analyzing logistics process management information and real-time cargo information. The general design of the system is as shown in Figure 1. Module of data storage QR code scanning terminal
MSP430
Logistics Management Data transfer
Data receiver
vehicle-mounted GSM module Internet
Internet
Module of data storage QR code scanning terminal
MSP430
Data transfer
Database stores
GIS data browsing
Control command send
vehicle-mounted GSM module
Figure 1. General Design Drawing of GIS Logistics Management System As one part of the vehicle-mounted system, the basic Logistics Management unit aims at managing cargo data and transmitting cargo information during cargo transportation process through the combination of embedded GIS technology and two-dimension code automatic identification technology, and is mainly composed of following four modules: data acquisition module (namely two-dimension code scanning circuit), data storage module, communication module and power supply.
3. Hardware Circuit Design of Vehicle-Mounted GSM Module The hardware circuit of vehicle-mounted GSM module is mainly divided into following six modules: master controller system module, two-dimension code data acquisition module, RAM data storage, display module, GIS communication module and power supply module. The general design block diagram of the system is as shown in Figure 2.
2
Copyright ⓒ 2016 SERSC
International Journal of u- and e- Service, Science and Technology Vol.9, No. 3 (2016)
System Clk
JTAG
Reset
Wireless communication module
Storage module
Keyboard
MSP430F149 QR code module
RS232 Display module
BMS
Battery
Figure 2. Hardware Circuit Design Drawing of Vehicle-Mounted GSM Module 3.1. Minimum System Design of Master Controller MSP430F149 ultra-low power consumption chip manufactured by TI Corporation is selected as the main control chip in this article. In order to realize cargo information acquisition function, the portable design and 18650 type secondary battery as the power supply are adopted. Specifically, MSP430F149 is started from built-in SRAM, I2C bus operates EEPROM, and the operating voltage is 3.3V; meanwhile, RS232 and the two-dimension code scanning circuit are adopted to display such information as time, date, longitude, latitude and speed on LCD. Therein, EEPROM 24C512 chip compatible with I 2 C interface is adopted for geographic information storage. The data received and extracted at each time is compressed and then stored, and the data at most for one day can be stored. Additionally, due to extremely large compression ratio, only 6.5bytes are equivalently used for the geographic information. The specific circuit design is as shown in Figure 3.
Figure 3. MCU Minimum System Diagram
Copyright ⓒ 2016 SERSC
3
International Journal of u- and e- Service, Science and Technology Vol.9, No. 3 (2016)
3.2. Communication Module Design
1
N
C
SIM_VDD
2
2 3
D
G
N
D
N VPP
2
7 8 F
p
2 VSIM
6.8K
2
C44
R32
SimCardx8
2
2
R28
SimCardx8
SIM_PRESENCE
SIMPRE
SIM_DATA
SIMDATA
R25
2
6
G
5
2
2
R23
4
SIM_CLK
SIMCLK
SIM_RST
SIMRST
0.1uF
R21
2
1
C35
VSIM
The communication module is composed of two parts: SIM cassette circuit, standard module interface and module power supply control circuit designed on terminal main board; standard DTU module (GPRS module or CDMA module). In this article, SIM900A provided by SIMCOM Company is adopted to realize GPRS communication. The specific circuit design is as shown in Figure 4 and Figure 5. Specifically, MSP430F149 receives the geographic information data transmitted from GIS communication module, then extracts and compresses the useful information of the data, then displays such information as longitude, latitude, time and speed, and finally stores the geographic information. The specific communication functions are as follows: (1)GPRS data teletransmission: the transmitted information includes: longitude, latitude, time and speed. The compressed data are transmitted every second to realize strong timeliness. (2) GPS positioning: the data are updated every second and output by asynchronous serial port and the extracted information includes longitude, latitude, time, data, speed, etc.
T
A
B
2 5
1 N GPIO10/KBC0
N
VBAT
VBAT N
N
N
N
N
N
0 D
D
D
D
D
D
D
D
GPIO9/KBC1
9
4 GPIO8/KBC2
4
8 7 6 D
5 4
N
D
N
G
3
3 2 1 0 9 7 6
3
5 PWM1
PWM2
3
SDA
3
SCL
8
3
GPIO1/KBR4
4
GPIO2/KBR3
4
GPIO3/KBR2
D D
4
GPIO4/KB
D
4
GPIO5/KBR0
S
4 D
N
G
S
4
G
4
GPIO6/KBC4
D
4
GPIO7/KBC3
4
I 5
C 6 7
T 8
T
R 9
X 0 1 2 3 4 5 6
1
SIM_PRESENCE
SIM_RST
SIM_CLK
SIM_DATA
SIM_VDD
G
3 4 SIMPRE
SIMRST
3
3
D
3
3
2
3 1
0
9
2 SIMCLK
VSIM DBG_RXD
t
e
k
c
t
J
DBG_TXD
2
J
3 o
S
e
k
c
o
S
SIMDATA
2 8
2
2
2 7
6
5
2 4
2 3
2
2
C
SIM900
N
DBG_RXD
DBG_TXD
VRTC
A
LINEIN_L
D
LINEIN_R
SPK_N
SPK_P
MIC_N
MIC_P
2
1
2 1
0
9
8
1
4
D
R13
N
G
MMBT3904
4.7K
NRESET
R12
G
NRESET 7
1
N_RESET
VDD_EXT
1
DISP_CS
1
DISP_D/C
1
DISP_DATA
1
DISP_CLK
1
R
1
T R
0
0
X
R
0
0
3 3
1
D
X
R
1
D
X
T
R10
N
K
7
4
K
7
C
8
R
DSR
MMBT3904
D
R
0
0
3
7
R
9
R
4.7K
R
RING
1
Q
2
Q
6 PWRKEY
R
DIR
NETLIGHT
3
R
0
0
4
3
R
T
D
R
PWRKEY_OUT
STATUS
D
RF_ANT
5
GPIO11 2
GPIO12
PWRKEY
N
VBAT
5
G
2
5
5
5
5
3
5
G
4
5
6
7
5
6
6
5
8
G
9
0
1
G
G
G
6 2
6
G
3
6
G
4
6
6
6
5
6
7 1
PWR_KEY
G
8
6
U
RF_ANT
R
1
0
0
3
R
STATUS
V
Figure 4. SIM Card Circuit Diagram
Figure 5. SIM900A Module Circuit Diagram 3.3. Two-Dimension Scanning Module
4
Copyright ⓒ 2016 SERSC
International Journal of u- and e- Service, Science and Technology Vol.9, No. 3 (2016)
In the design, the minimum unit for logistics transportation, namely individual vehicle, is taken as the basic unit. Two-dimension code management is adopted for the cargos in each basic unit, and the commercial two-dimension code long-distance scanner of Argox AS-8250 is adopted in this article to scan the cargos, wherein this scanner communicates with MSP430 SCM through RS232 serial communication, and the specific circuit diagram is as shown in Figure 1. Specifically, pins TXD0 and TXD1 communicate with Argox AS-8250 serial port to acquire cargo data information, and the acquired information is stored in the memorizer of the vehicle mounted system. 3.4. Power Supply Module Due to the requirements of the large quantity of power supply modules and the high precision of power voltage and current for the system, multiple power supplies are adopted in this article. Specifically, VBAT power supply scope is 3.2～4.8V and the voltage is 4.0V in normal condition. Under some circumstances, the peak current for the radio frequency data to transmit time slot pulse can reach 2A, which will inevitably cause voltage drop, so the power supply with the current above 2A i s needed. Additionally, voltage stabilization module AAT3221 can provide 3.3V voltage to MSP430F149.
4. Design of GIS Logistics System Management Platform 4.1. Design of Management Platform Framework The modeling theory of 2D-GIS technology is taken as the basis to acquire such real-time information as the longitude and latitude information and the cargo management information from the vehicle-mounted GSM module so as to establish the logistics system management platform, as shown in Figure 1. 2D-GIS logistics system management platform is composed of three mutually independent subsystems: SQL Server based logistics information database, ArcSDE server system and Web application system. SQL Server based logistics information database is mainly used to store and manage mass logistics information data and cargo distribution data. Therefore, high performance commercial server is adopted to establish SQL Server database system in order to separate data and business logics and accordingly improve system stability and maintainability. ArcSDE application server system is mainly responsible for responding to the data storage and inquiry requirements from the client, searching, accessing and forwarding mass data in the database. Meanwhile, this system is directly conn ected to the background SQL database so as to automatically allocate and calculate tasks according to CPU utilization and network occupation of present client and server, thus to significantly reduce the dependence of the whole system on the data server and effectively improve the performance of the whole system as well as provide more effective technical support to the client application system. Client application system employs C# and ASP.net technologies to complete the coordinated management and interaction between the Logistics Management personnel and the cargo transportation personnel and respond to inquiry and analysis requests.
Copyright ⓒ 2016 SERSC
5
International Journal of u- and e- Service, Science and Technology Vol.9, No. 3 (2016)
4.2. GIS Technology Based Logistics Management Process Vehicle-mounted GSM module and Logistics Management platform are combined to realize the digital and real-time logistics process management. The software subsystem of the whole management system is as shown in Figure 6.
Map query
Warehouse management
Transportation management
Data query
Statistical analysis
Logistics management platform
Web Server
Application server
On-board equipment
On-board equipment
On-board equipment
Logistics information
Logistics information
Logistics information
Figure 6. Software Block Diagram of Management System In the whole Logistics Management System, Web based client can design the operable and browsable interactive interface for each operator according to different authorities of the clients and the management personnel. Except the functional module, the interactive module is the most important submodule of the management system.
5. Conclusion A GIS technology based Logistics Management platform mainly composed of vehicle-mounted GSM module and Logistics Management System platform is designed in this article. Specifically, this system is used to digitally manage cargo logistics process according to the handheld terminal modules, inquire and mange cargo information in a real-time manner during the transportation process. During the whole logistics transportation process, two-dimension code is regarded as the unique cargo identification. Relevant test has proven that such system has good effect and can realize the dual-identification of freight note number and cargo number, thus to reduce Logistics Management error and improve Logistics Management efficiency.
References [1] [2]
6
X. Xukan, “GIS Based Logistics Distribution System Integration and Application”, China Management Informationization, no. 1, (2006), pp. 22-23. L. Shizhou, “Urban Public Transportation System Based B2C E-commerce Logistics Distribution Solution”, Logistics Science and Technology, vol. 2, no. 10, (2003), pp. 35-38.
Copyright ⓒ 2016 SERSC
International Journal of u- and e- Service, Science and Technology Vol.9, No. 3 (2016)
[3]
[4] [5] [6] [7]
[8] [9]
M. Shihong, W. Shaorong and Liu Pei, “The Design and Implementation of the gps based real-time Monitoring System for the States of Power Network”, Automation of Electric Power Systems, vol. 24, no. 12, (2000), pp. 14. [EB/OL].http://blog.ccidriet.com/blog-htm-itemid-814860-do-showone-type-blog.html. X. Shengli, W. Shiqing and B. Zhanke, “Design of Logistics Information System Architecture Based on GIS[J]. Computer Engineering and Design”, vol. 31, no. 6, (2010), pp. 1259-1263. C. Junjie and C. Canzhang, “Web GIS and its Implementation Methods”, Journal of Taiyuan University of Technology, no. 4, (2000), pp. 394-397. D. Guang and Z. Yu, “Three-dimension GIS Technology-based Design for Analysis and Demonstration Platform of Earthquake Monitoring System”, Journal of Changchun University, no. 6, (2012), pp. 660665. G. Zhou, Z. Tan and Minyi Cen, “Customizing Visualization in Three-Dimensional Urban GIS via WebBased Interaction”, Journal of Urban Planning and Development, vol. 132, no. 2, (2006), pp. 97-103. K. Kandela, F. Huettmannb and M. Krishna Suwala, “Rapid Multi-nation Distribution Assessment of a Charismatic Conservation Species using open Access Ensemble Model GIS Predictions”, Red panda (Ailurus fulgens) in the Hindu-Kush Himalaya region[J], Biological Conservation, vol. 181, (2015), pp. 150-161.
Copyright ⓒ 2016 SERSC
7
International Journal of u- and e- Service, Science and Technology Vol.9, No. 3 (2016)
8
Copyright ⓒ 2016 SERSC
