Enterprise Application Architecture with LINQ to SQL - The Code Project - Design and Architecture

 

Contents

• Introduction
• System Requirements
• A Note on Performance Aspects
• Design and Architecture
  • SOA and scope of this article
  • Common Design Elements : DLinq and CRUD operations
    • Paging and Sorting
    • Insert and Update Operations
    • Concurrency patterns for Write operations
  • Section A: Classic 3-tier Architecture
    • Page Transition
    • Flow and Call Stack
  • Section B: MVP Architecture
    • Layers
    • Flow and Call Stack
      • View and View Initializer
      • View-Presenter Initialization Pattern
      • Business Layer Encapsulates Business Rules
      • Data Access Layer and Abstract Factory Pattern
      • Transfer Objects for Shared Data
• Conclusion

Via Enterprise Application Architecture with LINQ to SQL - The Code Project - Design and Architecture

How to convert a street address to longitude and latitude (geocoding) via web services « Jim 2.0’s Blog

string geocoderUri = string.Format(
    “http://rpc.geocoder.us/service/rest?address={0},{1},{2}”,
    street, city, state);
XmlDocument geocoderXmlDoc = new XmlDocument();
geocoderXmlDoc.Load(geocoderUri);

XmlNamespaceManager nsMgr =
    new XmlNamespaceManager(geocoderXmlDoc.NameTable);
nsMgr.AddNamespace(“geo”,
    @”http://www.w3.org/2003/01/geo/wgs84_pos#”);

string sLong = geocoderXmlDoc.DocumentElement.SelectSingleNode(
        @”//geo:long”, nsMgr).InnerText;
string sLat = geocoderXmlDoc.DocumentElement.SelectSingleNode(
        @”//geo:lat”, nsMgr).InnerText;

double latitude = Double.Parse(sLat);
double longitude = Double.Parse(sLong);

Console.WriteLine(“Lat: “ + latitude + ” Lon: “ + longitude);

 

Result:

Lat: 41.947372 Lon: -87.655788

 

Once you have the coordinates, you can perform radius searching. Troy DeMonbreun provides an example of how to calculate the distance between two geographic coordinates using a SQL Server UDF (User Defined Function). The GeoCoder.us blog also discusses how to calculate distances using two geographic coordinates.

Via How to convert a street address to longitude and latitude (geocoding) via web services « Jim 2.0’s Blog