GEOCode an Address

Bing Control to Convert a Text Address into a Location

Add a Service Reference

From Visual Studio service reference point to http://dev.virtualearth.net/webservices/v1/geocodeservice/geocodeservice.svc/mex for the dev environment. There are staging and production links so you appropriate ones for your application.

Staging:

http://staging.dev.virtualearth.net/webservices/v1/geocodeservice/geocodeservice.svc

Production:

http://dev.virtualearth.net/webservices/v1/geocodeservice/geocodeservice.svc

http://msdn.microsoft.com/en-us/library/dd221354.aspx

GEOCode ServiceReference

Found it, Lost it, Found it

Just when I became well versed in mapping with the bing map control and the ability to plot locations from SQL,  the come out wit an improved version that is totally different. 

My old code still works just fine when referencing the v6.2 library. 

Control on a diet.

To accommodate Mobile computing the control was slimmed down to its core.  As the developer needed other functionality they could add modules as needed to fulfill tasks.

Here is an article on importing GEORss feeds.

GEORSss and Bing Map v7

What’s new in Bing Map 7

Here is Keith Kinnan’s list of updates

What is new

Add Map and Points to Windows Phone 7

Here are the steps to add a map and point on the map.

1) Add a reference to Microsoft.Phone.Controls.Maps

2) Drag a ‘Map’ Windows Phone Control to the Page xaml.

3) Register on Bing Maps Portal and obtain an ID or Key.  Without this the map will display not register message.

4) Add the key obtained above to the xaml code.  Modify the xaml created by dragging the control and dropping it on the page.

    <Microsoft_Phone_Controls_Maps:Map    Name="map1" VerticalAlignment="Top" >     
            <Microsoft_Phone_Controls_Maps:Map.CredentialsProvider>
                <Microsoft_Phone_Controls_Maps:ApplicationIdCredentialsProvider ApplicationId="your key here" />
            </Microsoft_Phone_Controls_Maps:Map.CredentialsProvider>
    </Microsoft_Phone_Controls_Maps:Map>

 

5) Go to  the code behind

6) Add a using statement to reference the map control

using Microsoft.Phone.Controls.Maps;
using Microsoft.Phone.Controls.Maps.Platform;

7)  Add an instance variable for the page

MapLayer PinLayer1;

8) Create a pin and location

Pushpin MyPin = new Pushpin();
MyPin.Location = new Location();

9)  Set the Lat and Lon for the location.

MyPin.Location.Latitude = 27.96206353406851;
MyPin.Location.Longitude = -82.44960308074951;

10) Add a label to the Pin

MyPin.Content = "KForce";

11) Create a Map Layer

PinLayer1 = new MapLayer();

12) Add  Pin to Layer

PinLayer1.Children.Add(MyPin);

13) Add Layer to map

map1.Children.Add(PinLayer1);

14)  Center and Zoom on the location

map1.Center = MyPin.Location;
map1.ZoomLevel = 9;

Happy Coding

SQL Saturday 49 Orlando

There were great attendees to the SQL Saturday presentation “Spatial Queries in SQL 2008”

First, here are the slide,database , SQL, and ASP.Net code in one zip file.

Download from SQLSaturday website

Here are some links mentioned during the presentation.

1) Geocoding addresses using Google See sample on Codeplex.com

2) BING maps SDK AJAX version

3) Bing maps SDK Silverlight version

4) Window Mobile 7 toolkit Download the Tools

Comments Off

SQL Saturday Tampa – Spatial Data

Thank you all for attending my session here are the files to download and get stated with spatial data with SQL Server 2008 and Virtual Earth.

Everything (PPT,ASP.NET,Database)

Just the ASP.Net code

Just database backup

Just the script to build the database

Just the PowerPoint

Bing Maps AJAX SDK

Bing Maps Silverlight SDK

Comments Off

Tampa Code Camp 2009

As promised here are the slides from the presentation.

PowerPoint Slides

PDF version on the slides

Comments Off

SQLSaturday #15 Jacksonville

Spatial data represents the shape and physical location of an object.  For example, the object can be a house, business, sub-division, or a county.  SSQL Server 2008 has two new data types GEOMETRY and GEOGRAPHY.  GEOMETRY works with flat objects. GEOGRAPHY considers the shape of the earth. 

GEOGRAPHY and GEOMETRY or CLR data types. Though to implement them you do not need to have CLR enabled on the SQL Server instance.  Microsoft has provided a long list of OGC methods.  These are methods that are part of the independent  Open Geospatial Consortium list of specifications.

Here is a PDF of my presentation SQLSaturday.pdf (806.55 kb)

Handler not working in shared hosting environment

If you are trying to reference a file that is generated with a handler and you are instead getting the file not found message.

The handle is working fine in Visual Studio but fails to work when deployed to a webserver.

Have your hoster perform the following

In IIS you right click on your App, go to properties, click Virtual Directory Tab, Configuration, Mapping Tab, Add, point the Executable to c:\windows\microsoft.net\framework\v2.0.50727\aspnet_isapi.dll and add the appropriate Extension (“georss”) . I had to remove Script Engine and Verify that file exists check boxes and it worked.
this is where I found it. http://forums.asp.net/t/1408510.aspx