Register Now

(All the Authors are requested please update your profile after sign-up)

Login

Lost Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Login

Register Now

Please register free on Ask Jugadu.com and Ask your question , We would be happy to answer

Automated Collection System Using Tablets and GIS

AUTOMATED COLLECTION SYSTEM USING TABLETS AND GIS

Dr. Zakaria Yehia Ahmed
GIS Consultant
GIS Instructor , Ain Shams University, Diploma of GIS
CEO-Global GeoBits
[email protected]
[email protected]
KEY WORDS: GPS – GIS – Tablet applications – Geo-location

 

ABSTRACT:

The possibility of retrieving the information and location from several users. The application has help screens, generate dynamic reports, validate data, Determine the track for collectors and display it on an electronic map. Display the places of traders on the electronic map, collect from the subscriptions and service charges from Chamber of commerce through the Tablet application. The data entry in the field using Tablet and automatically save the coordinates of the store and display the location on a map.
The general framework has been developed for the design of the system according to the rules and goals of Chambers of Commerce in Egypt to control the collectors and facilitate the collection process, decrease the errors and follow up the collections on a geographic map. Contributions are automatically calculated by the application. Using this application we can verify if the collector already went to the store or not and control them, also we can print a receipt on the site. The application can display the stores on Google maps. Three applications are built, application for the Tablet, electronic web site and GIS website. The application can be used on line and off line. We can use the online website or off line. It can also produce reports for the stores who paid on time or paid late and determine the collection rates or the collection percentage. The applications are developed using VS2013 and SQL 2008.

Background :

We have some problems during field survey and data collection. Coming back with incomplete data is one of the biggest hurdles to an efficient collection system. Improve efficiency by minimizing site revisits. Build application and improve interfaces with easy to use and efficient functions. Improve data collection and make it faster with fewer errors. Improve the collectors team quality and easy-to-use interface required less training. Building an application on tablet with easy-to-use interface with chick boxes and pull down menu. High accurate GPS and high speed data communication with the main database server.

Research Objectives:

The primary goal of this research is to study and design idea of building an integrated system helps collectors of any governmental authority (e.g. Chambers of Commerce) to perform their duties to the fullest and easier way, using a tablet with geographic information systems (GIS) and global positioning system (GPS) in achieving the objectives of the system, which can be summarized in the following:

 

Figure 1: Tablet Interface

Provides the ability to retrieve data entered by multiple users in one time and access it with high accuracy and safety of the data. Each user has username and password to login and retrieve only his data

• Verify the accuracy and authenticity of data (Validation) and not to repeat the achievement through application and apply specific logic required review and audit of all inputs during entry on the screen. The system screens include checklists, which simplifies data entry and reduces error probability.
• Provide all kinds of reports and Statistics traditional minimum system provides the possibility of keeping good display, and re-print, save, and a number of customary formulas
• The survey took the opinion of the dealers room for special services or services that aim their activities and help the room to make decisions and provide better services
• intermediate database work for traders of all areas within the province and the division of traders by their activities and contact details of activity include interaction and the extent of the trader’s activities in the Room
• is determined itinerary for collectors to arrange visits and is controlled in the arrangement of the room and through the system can display these visits places on the map. And it can follow the conductor’s commitment to a route and display it on the electronic map at the return of the conductor using a technique of GPS.

Figure 2: Display Locations using Google Maps

• (SQL is taking a backup copy of the database within the program) and placed on cylinders to keep the data or on another server in the event of any problems on your device databases to the possibility of retrieval.
• Traders are presented elsewhere on the electronic map to show the application of the room with the common name and registration number and Mmaysaad registry office in the creation of new investment opportunities and help in decision-making and provide better services process.
• fees and special services room subscriptions account
• The achievement subscriptions and fees for special services room through the application of the proceeds (Tablet) and is updated daily collection data base data room.
• The follow-up assessments of traders/collectors show with queries such as the number of beneficiaries of contributions owed them to participate ahead of a suitable period of time to develop a plan and determine the plan of Collectors line.
• The application is loaded on the Tablet and enter data into the site and coordinates loaded automatically.

Methodology and work plan :
This project has been implemented on a number of successive stages and can be summarized as follows :

 

The initial phase of the study and planning to build a program :
Identifying the needs of the user of basic data and calculate the value of arrears and special room subscriptions. We have to consider all the possibilities that may face the conductor. Based on that we developed a general outline of this system
The design of the system put in an open and scalable addition to any other requirements of the future such as changing the collection system and the value of the fine.
Design XML file Phase:
The design and construction of the XML file type contains the coordinates of the place, which was the collection of it and the basic data. We can add an image to the site and automatically stored on SQL and in which we can view the collection places on Google Earth map.

Programming phase and preparing applications :
We developed three applications (application on tablets – Chamber of Commerce Website – Chamber of Commerce GIS Website)
VS2013 has been used in the construction of the three applications and the use of SQL 2008 to store the database. The applications have been built on any tablet using windows 8

Design XML file Phase : 

The design and construction of the XML file type contains the coordinates of the place, which was the collection of it and the basic data. We can add an image to the site and automatically stored on SQL and in which we can view the collection places on Google Earth map.

Programming phase and preparing applications :
We developed three applications (application on tablets – Chamber of Commerce Website – Chamber of Commerce GIS Website)
VS2013 has been used in the construction of the three applications and the use of SQL 2008 to store the database. The applications have been built on any tablet using windows 8

Hardware required :
The existence of special server for the applications
Publishing the websites using Static IP address and an Internet connection with high speed. Many tablet devices are available with an Internet connection and built in GPS.

Diagram of the system :
It consists of a website , the application of the Tablet , intermediate data base and basic data of the room. The data is stored from the website and the application of the tablet on the intermediate database. After reviewing data from the administrator, it is stored in a basic room database
Schematic drawing special staff using the system :
The employee collects annual subscription fees from the merchant. Then the employee in charge of updating the merchant data or the exclusion of his work
Used Data:
We use Google maps in background and display all collectors visits and places of customers in the foreground.
Hardware required :
The existence of special server for the applications
Publishing the websites using Static IP address and an Internet connection with high speed

Figure 4: Diagram of the System

Many tablet devices are available with an Internet connection and built in GPS.
Diagram of the system
It consists of a website , the application of the Tablet , intermediate data base and basic data of the room. The data is stored from the website and the application of the tablet on the intermediate database. After reviewing data from the administrator, it is stored in a basic room database
Schematic drawing special staff using the system
The employee collects annual subscription fees from the merchant. Then the employee in charge of updating the merchant data or the exclusion of his work

Figure 4: Schematic drawing special staff using the system

Used Data:
We use Google maps in background and display all collectors visits and places of customers in the foreground.

Figure 5: Locations of Collectors

Developing of the program:
Login screen system:
Screen access to the system for users who were they constructed by the system administrator. Identify sections that will show him in accordance with the authority to set for it:

Home screen system
Home screen that appears after a user entered the user name and password.

Main data screen:
Data entry and save a new subscriber within the database screen
Query screen and modify data:
The query about a particular dealer data by writing a record number of trade appears all of its data with the ability to modify this data and save the updating in the database

Collection and supply room subscriptions screen:
A screen to calculate a particular dealer fees by entering the dealer number or registration number

Report on dealer:
To issue a joint report on the data by entering the registration number and registry office

Collection room subscriptions Report:
It produces a report on the collection of the contributions of the private room and the history of a particular Collector.

Entering the collector data – Tablet application:
Collectors are the introduction of visits by identifying Proceeds name and date of the visit and enter the registration number are automatically retrieve the coordinates. Then we added the visit and inquire about Total Hits
Entering the visits data (collector name – visit date – register number), then adding additional data and detect the coordinates automatically.

Analysis of results
After analyzing the results, the following remarks could be made:
– The collecting data became faster and easy
– The accurate data saved in the database server, only the administrator can update the data.
– Multiple images can be taken and saved
– The coordinates can be saved automatically
– We can trace the route of the collector online automatically if we want
– Ability to make analysis and reports as the end user need.
– A lot of data are collected in short time.
– Much money are collected from the customers
– Reduce the customers who do not need to pay.
CONCLUSION
The possibility of retrieving the information and location from several users. The application has help screens, generate dynamic reports, validate data, Determine the track for collectors and display it on an electronic map. Display the places of traders on the electronic map, collect from the subscriptions and service charges from Chamber of commerce through the Tablet application. The data entry in the field using Tablet and automatically save the coordinates of the store and display the location on a map.We
developed three applications (application on tablets – Chamber of Commerce Website – Chamber of Commerce GIS Website). VS2013 has been used in the construction of the three applications and the use of SQL 2008 to store the database. The applications have been built on any tablet using windows 8.
RECOMMENDATIONS
– We need more accurate GPS built in tablets
– We need high speed internet access
– We need stable and wide range for internet access
– We need cheap and high speed tablets
LIST OF REFERENCES
1.
AUTOMATED DATA COLLECTION AND MANAGEMENT SYSTEMS, http://www.brc-equals3.com/services/automated-data-collection-management-systems/
2.
“Building a Public Works Information System – Esri” , http://www.esri.com/library/whitepapers/pdfs/building-public-works.pdf
3.
El-Manadilii.,.Y.S (2000) “TOWARDS THE ESTABLISHMENT OF AN AUTOMATIC SYSTEM FOR GIS DATABASE GENERALIZATION”, Paper, Civil Engineering, Cairo University
4.
Extending Enterprise GIS into the field with Mobile GIS technology, a white paper , January 2014
5.
GIS Solutions for Surveying , ESRI
6.
“GIS goes where you go” , http://learn.arcgis.com/en/arcgis-book/chapter8/
7.
https://www.specteo.com/2015/03/5-tips-for-improving-gis-field-data-collection/
8.
“List of GIS applications for Android Tablets”, http://gis.stackexchange.com/questions/12452/list-of-gis-applications-for-android-tablets
9.
Peterson, J. A., Kim, C. H. and Yoo, J. Y. (2002) Lessons from the Application of GIS for local Government, Journal of the Korean Association of Geographic Information System, 5(3): 107-117
10.
Remote Data Collection: 10 of the Best Apps for Gathering Data in the Field, MATTHEW GUAY
11.
What is Collector for ArcGIS?, Jeff Shaner

 

About Zakaria YehiaLearner

Leave a reply