Mike's client is happy with these results but also wants to know what types of providers are available within the network. Finding the Right Doctor To refine his analysis, Mike constructs a multipart query in which he divides up the providers by medical specialty. In each case, he still wants to know how many employees live within five miles of two providers. For the first query, however, he limits the search for providers to cardiologists. Structuring the query in this fashion will reveal how many health care providers are available to each employee as well as how many of each type are available.
Color coding the providers by specialty reveals a pattern in the map.
Out of 25 providers, only three are pediatricians. Two of the pediatricians are located several miles from the area around downtown Columbus, where the majority of the client's patients are clustered. Mike runs another query, this time to find out if there might be two pediatricians within 10 miles of each person. This query reveals that only 48 percent of the firm's employees will be able to choose from two pediatricians within 10 miles. Mike needs to add another pediatrician to his health care network for this area.