John Sample

Bits and Bytes
posts - 103, comments - 354, trackbacks - 16


Big update coming tonight.

I think the new version of the DLL is pretty much feature complete:
Address parsing
Lookup by city, state
Zip to City, State resolution
Fall through address finding
Suggested addresses.
Results are bindable to datagrid

posted on Thursday, September 15, 2005 7:11 AM


# re: Tonight

Hi John:

I'll try again later tonight after you finish posting up the latest version... I'm not sure if I downloaded the .05 version, so that may explain the 404 error I was having during the install last time.

I have three questions:

1. Will you have at some point any example examples written in C# that would be a comprehensive overview of using your geocoding solution?

2. By using your solution, is it possible to supply the lat/long coordinates and have the results return the closest street to that location? The reason I ask is that I'm working on a map application where many of the locations are out in the sticks in rural areas (but I have the lat/long coords) and I need to be able to provide the nearest street / road to that location.

3. Is it possible in your solution to do a radius search around an origin point / street address? For example if I had a small database with street addresses in it for local businesses and I wanted to know which business were within 1 mile radius of a particular homes street address, could such an search be easily performed using an SQL query?


9/15/2005 6:37 PM | Mark Chipman

# re: Tonight

1. Yes, but organization will probably be my first priority.
I'm having a hard enough time trying to keep from getting lost.
I can't imagine what its like for anyone else trying to keep up with the updates the way everything is scattered around.
Once I get everything organized I'll start adding examples.

2. Absolutely. Check out GeoUtils.ReverseGeocode in the new DLL.

3. Maybe. I'll look into it, but it won't be possible with the current version.

9/15/2005 6:51 PM | John Sample

# re: Tonight


I have been following the amazing progress for a while now. Great job. I think that I have a SQL Function that can be easily altered to solve #3. I am not at all familiar with the table structure, however I'm sure someone more experenced in SQL can modify this. Should I post the code here?
9/23/2005 3:05 AM | Tim

# re: Tonight

Sure Tim, you can post it here or email me.
9/23/2005 7:28 AM | John Sample

# re: Tonight


John, I emailed that query to your gmail account. I hope it helps. Let me know if ou have any questions. Good luck!


9/23/2005 4:34 PM | Tim

# re: Tonight

Did anyone ever figure out the distance calculation? Do a google on the Haversine formula, and you'll see how to do distance measurements between lat/lon coordinates.
10/13/2005 11:08 AM | Corey

Post Comment

Enter the code you see: