[attachment=2438]


MAPPING SOLUTIONS
Submitted by: Ajesh V.A Linish V.S Tomy Paul Deepak K.K
1 .ABSTRACT
Input data: Latitude and longitude of a place retrieved from the GPS machine and the local name of that place during the survey
Note: Our project concerns only within Kerala limits so the data entered must be within Kerala limit
JJsers can input the data in two modes:
1. Data input through excel sheet
2. Through text box
Data input through excel sheet
In this mode the data is first entered into Excel sheet in a standard format. It is accessed by importing it from the file menu via a file open dialogue box. Standard format:
¢ Column A: Place name
¢ Column B: Latitude
¢ Column C: Longitude
The first row must be in the g/ven format:
Place Name
Lat
Long
Data input through text box
Users can input values by clicking the "User Data" button
SYSTEM REQUIREMENTS
i
2. SOFTWARE AND HARDWARE REQUIREMENTS
¢ Programming language: Visual Basic 8.0
¢ Back end used :Microsoft Office Excel 11
SYSTEM CONFIGURATION
Processor: Intel Pentium 4 or equivalent
Ram: Minimum 256 MB DDR
Space required: 30 MB of available hard disk space
OS: Windows® 2000 Professional SP 4 or above
Framework: .NET Framework 2.0
3. ANALYSIS
3.1 Present System
Today most of the cellular telecom operators are doing vast surveys to find a proper place to install the 3TS (Base Transceiver Subsystem).They use a GPS (Global Positioning System) system to get the latitude and longitude of the proposed location. For further clarification they use a software tool to plot the exact location in the map. Presently that tool is very expensive.
The main objective of the telecom operators is to find out any obstructions such as tall buildings, mountains, and water source which affect the radiation power which in turns affect the total coverage area of that BTS. They use different types of map for completing this task, such as contour maps etc.
Most of the telecom operators need distance between two BTS system, angle between the same, to install the antennas enabling optimum coverage and also to install microwave page link between two BTS. For such an installation LOS (Line Of Sight) between the two BTS must be ensured. Plotting the corresponding location in a contour map they can check if there is any obstacle between those places.
3.2 Proposed System
Since the maps are highly confidential and expensive we are provided with only a base map of KERALA with district boundaries only. With the help of our software we can plot as many places required and calculate distance in kilometers between any two points and can also calculate the angle between two places in degrees.
Technical Terms:
¢ GIS (Geographic Information System): Geographic Information System. An organized collection of computer hardware and software designed to efficiently create, manipulate, analyze, and display all types of geographically or spatially referenced data. A GIS allows complex spatial operations that are very difficult to do otherwise.
¢ Degrees: Degrees (longitude and latitude) are coordinates used to represent locations on the surface of the earth. Longitude, or x-coordinate, represents a location's east-west position, where any location west of the prime meridian has a negative x value. Latitude, or y-coordinate, represents a location's north-south position, where any location south of the equator has a negative y value.
¢ Decimal Degree :Many paper maps express coordinates in terms of degrees, minutes, seconds (for example, 40 degrees, 30 minutes, 10 seconds). Mapping Solution, however, expresses coordinates in terms of decimal degrees (for example, 72.558 degrees).Thirty minutes represents half a degree, and 30 seconds represents half a minute. Thus, the longitude: 40 degrees, 30 seconds, would be expressed in Mapping Solution as 40.5 degrees.
¢ Latitude: Used to describe the North-South position of a point as measured usually in degrees or decimal degrees above or below the equator. Latitude lines are the horizontal lines one map that increase from 0 degrees at the Equator to 90 degrees
at both the North(+90.0 degrees) and South (-90.0 degrees) poles.
Longitude: Used to describe the East-West position of a point. The position is reported as the number of degrees east (to -180.0 degrees) or west (to +180.0 degrees) of the prime meridian (0 degrees). Represented by vertical lines running from the North to South poles. Lines of longitude are farthest apart at the Equator and intersect at both poles, and therefore, are not parallel.
3.3 Objectives
The primary objective of the system is to develop software which can plot the places in KERALA corresponding to the latitude and longitude of those places.
3.4 Future of the System
Tomorrow will be the days of GPS application every where
¢ Information transmitted from a GPS module installed with modern vehicles can be used to trace the vehicle reducing the possibilities to steal the vehicle. Since we get the exact position and distance between a reference point we can easily restore the vehicle from the hands of intruders.
¢ A specialized traffic system can be implemented by regularly monitoring the traffic of a big junction. For this a GPS module must be installed on every vehicle. This technique will reduce the overall accident rate.
¢ The system can be used in call centers through which a customer can enquire about the route to a particular place.
FORMS
4. FORMS
1. Starting form of the project. A spectacular splash screen is also included
2. File browsing window. Only EXCEL files can be browsed by clicking the "Browse" button and when "OK" Button is clicked this form will terminate
3. Work area of the project which consists of a map of kerala with district boundaries. Alt the input data is plotted as red squares with given place name besides those square in red color
4. Distance calculation form. On clicking the "Distance" button this forms appear in the top right corner by marking two points in the map and by pressing the calculate button, the air distance between those places will be displayed
S Happing solution 1.0 - [Plot]
> 9° Sf«pn IP* tWp
Uliludo 9.5888219380 Longitude 76.516140313
In
Lolilodo 9.3468309982 Longitude 75.893624750
CALCULATE
5. Angle calculation form On clicking the "Angle" button this forms appear in the top right corner by marking two points in the map and by pressing the calculate button, angle between those places will be displayed
6. Zooming tool zooms the current work area.
7. Grid View when this tool is clicked grid lines representing latitude and longitude is drawn.
lM. Mapping solution 1.0 - [Plot]
He Graph loots Hefe
Ldtiude 8 2938 To 128044 longitude 74 8885 To 77 3861
| ZOOMING + - UP A DOWN LEFT -4 RKHT RESTORE SovelmeQeAs
I PIOT PIOT WITH NAME || USER DATA GET DATA FROM MAP DISTANCE ANGLE
8. User Data & Get Data from Map
When clicked on the "User Data" we can give the latitude and longitude of the location along with the name to plot the location. When clicked on the "Get Data from Map" we get the latitude and longitude of that location from the map.
r Mopping solution 1.0 [Plot]
Ffe r»wh loots M*
aiCK THE HOUSE OVER THE MAP LATITUDE 10.5093450611265 LONGITUDE 76.2461335633391 SavoImageAs
[ckkhora to bfl9n|^„¢
NAME USER DATA GET DATA FROM HAP DISTANCE ANGLE LATITUDE 10.1598
LONGITUDE 76.461
9. File Save as form is used to save the current work area as an image file. Users can save the image file in formats like *.bmp, *.jpg, *.tiff etc
- a
SavBJn
. J MyRecent Docunentt
i Mapprig, Solution _/test
-£] Copy of Man Points
* Icon \1 Main Ports -*i]Mainpcrts2
Qvhvghl
Mi» Documents My Computet
|J Fie name: [
My Wei work Save *i lypa
j ZOOMING + - UP A DOWN T LEFT j RIWT RESTORE Save Imago As
i PLOT PLOT WITH NAME USER DATA ST DATA PROM MAP DISTANCE ANQ£
CONCLUSION
Sree Narayana Gurukulam Computer Science & Engg. Department
College of Engg, Kadayirippu. 23 2006, 6th Semester
5. CONCLUSION
We are indeed happy to declare that our objectives are almost realized through our software. Even though there are certain limitations for the project, they can be easily cleared, if time permits.
We plan to do presentation of the project before a telecom operator. Their views will also be taken onto account. Any further features they required will also be added in out project.
We have tried to cover all the angles in our project up to our
knowledge. We are constantly trying to make improvements to our project. By adding all the details requested by the clients and the improvements that our guides and well wishers suggested, we hope that our project will be a successful one.
Sree Narayana Gurukulam College of Engg. Kadayirippu.
Computer Science & Engg. Department 2006, 6th Semester
REFERENCE
6.REFERENCE
Microsoft Developers Network library 2005 Professional VB.Net 2003 - : Bill Evjen
Rama Ramachandran (wiley publishing)
Sree Narayana Gurukulam College of Engg. Kadayirippu.
Computer Science & Engg. Department 2006, 6th Semester