Geographic Information Services (GIS)

1. Geographic Information Services (GIS) Advanced Mapping and Data Mining Brian Webster Consulting Wirelessmapping.com

2. What is GIS? • Geographic Information Systems • Visual presentation of data • Uses maps to “SEE” your data and any trends • Complex analysis of data • Creates answers and business intelligence • Properly used, it gives a competitive advantage

3. What can GIS do for me? • Objectively displays data • Shows trends or clusters (or lack of) • Compares new and old data • Studies proprietary data against public information like census statistics • Gives you more information to make business decisions

4. What will it tell me? • Sales by location and amount • Where your customers come from • Who your best customers are • Why some locations perform better • If advertising is being targeted in the areas your customers are located

5. What will it tell me (continued) • If you have overlapping service areas • The average distance your customers travel to buy • The most profitable customers and if you target advertising to them

6. This type of information can be gathered quickly and cost effectively.GIS should be called a “Business Intel System”

7. Show me more!

8. Simple plot of customer addresses These images illustrate the concept of mapping your customer addresses to look at any trends. This data is easily overlaid on a street map. Each dot is an address record.

9. Customer Mapping Tools • Mapping data can help you assign workloads or territories • Territories can be assigned by density or physical area • Existing databases can have this information added without manual input

10. Example Territory Map In conjunction with this type of map a corresponding spreadsheet or database can be created that would assign any address to the proper territory, eliminating manual data entry to existing systems.

11. Targeted Marketing • With commercial mailing lists you can use selected records based on your needs. If you open a new store you can market to the addresses in the list that pertain to that location only • Helps maximize your advertising dollars • Examine the circulation or coverage area of your media outlets to chose the most effective advertiser for your needs

12. Example Newspaper Circulation Areas

13. Radio Station Coverage Areas

14. GIS and Wireless Internet Systems

15. Uses • GIS can display detailed road information with specific transmitter coverage area • For multi transmitter networks GIS can create maps showing the best serving site • Address data can be compared to the coverage area to identify who can be served • The best tower to serve the customer and the expected signal level is recorded • The number of potential customers in each tower service area can be calculated to plan for proper network loading

16. Network Coverage Map This map shows the coverage area and signal levels for a 15 site network

17. Best Serving Site Map This map shows the service area of each tower in the network.

18. What other things can GIS do?

19. Identify exactly who is served by name and address • Pre-Qualify customers for service by street address while they are on the phone! • Eliminate truck rolls to check for service availability • Tabulate total served households and population count • As new sites are added, data can be easily re-examined

20. Map of Served Addresses The same 15 site network map with business data overlaid. A corresponding spreadsheet shows which tower serves which address. Site and network capacity is planned using this information.

21. Residential Served Addresses This is the same system with residential data displayed. A spreadsheet is created to show which homes are served and by which tower. This data is used with business data to determine overall network capacity needs.

22. Demographic Studies The yellow areas represent the census blocks covered by a 4 site wireless network.

23. Household Density Each census block is shaded by number of households, the darker the color the more units in the area. This total network serves 34,753 households with a population of 97,660.

24. Other Uses • Examine tower databases for new transmitter locations • Intelligently investigate new sites for financial viability before construction • Identify key demographic elements of your served markets • Compare your coverage area to your advertising distribution areas

25. GIS and Due Diligence

26. Business Acquisitions • GIS is a valuable tool for investigating the value of a company for purchase or acquisition • GIS shows business data trends that may not be obvious • GIS allows business decisions to be made based hard facts rather than intuition • GIS allows you to uncover a “diamond in the rough” or to expose an overvalued entity

27. Uncover market information about the company that may have gone unnoticed • Do this quickly and cost effectively • Use as tool to determine the best purchase price • Determine how to best integrate the new company with your existing operations • Identify and eliminate overlapping services or territories

28. GIS can speed the due diligence process considerably

29. The bottom line is GIS can be applied to make actionable financial decisions

30. Contact Information Wirelessmapping.com Brian Webster Consulting214 Eggleston Hill RoadCooperstown, NY 13326 (360) 242-1363 Voice(208) 692-1898 Faxinfo@wirelessmapping.com