John Sample

# 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 asp.net 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?

Thanks.

-Mark

# 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.

# re: Tonight

Hi...

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?

# re: Tonight

Sure Tim, you can post it here or email me.

# re: Tonight

Hi..

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

Thanks

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.