We’ll end this chapter with one final (and fun) geospatial application, in which you will construct a Microsoft Bing Maps mash-up. The term “mash-up” is used to describe a unified presentation combining one set of data with another. For this mash-up, you will create a web application that layers customer coordinates over Bing Maps imagery to show the location of customers in the database as pushpin icons on a map.
Start with a new database. Create the Customer table with a geography column to hold customer locations and populate it with some sample data, as shown in Example 9-31.
Example 9-31. Creating the Customer table and populating it with geographical data.
USE master GO IF EXISTS(SELECT name FROM sys.databases ...