MapForums
Community of VE/MapPoint Users and Developers
Willing to Pay :)
This is a discussion on Willing to Pay :) within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; Have a simple "Dealer Locator Application" that I need in an ASP.NET application. I have a SQL server with 1.3 ...
| |||||||
| Register | Blogs | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
01-22-2003
| |||
| |||
| Willing to Pay :) I have a SQL server with 1.3 Million Dealers with exact street addresses. From ASP.NET page I want the user to type in their address... 100 S. Kentucky Ave Lakeland, FL 33801 From this we look into database for precise locations that match a two mile radius. I would like to display a map on the screen, but need a list of matches to be displayed. Would be nice to have both! We will pay for this application. The application would be very similar to http://demo.mappoint.net/fourthcoffee/locator.aspx The problem we ran into with MAPPOINT.NET is... A. Only has ability for 50,000 records (we need 1.3 million to start) B. We could not get the 50,000 records to upload because the site crapped out everytime we used their browser upload. rsell@4kicks.com (863) 409-8236 Thanks Ron Sell         |
|
01-26-2003
| |||
| |||
| An alternative!
Ron, How about working MP in a different fashion! Rather than load ALL your Dealers into one MP session, why not try the following: User enters address You verify address and obtain long/lat of users address You interogate your database for all dealers whose long/lat fall within a set range of users long/lat You then only populate MP with the dealers that fall close to the user. Regards, Andy Yule Revival Consultants Ltd PS: I am a database consultant, if I can assist you further then please email me at Andy@Revival.uk.com |
|
02-03-2003
| |||
| |||
|
no i dont! |
|
02-04-2003
| |||
| |||
| filter the db
I agree with Andy Yule that filtering the database and answering the query in 2 steps is a good solution. Let MapPoint do as little work as possible because its slow. If you have good addresses it shouldn't be necessary to go for lat/lon's though. Why not filter for all neighboring zip codes. Good to use index since db is not updated, right? Then let the map do only the work of displaying the results. To show a list you wouldn't even need a map. I am also a database consultant. (My wife thinks I'm very smart!)
__________________ David Kachuck dk0146@netscape.net Oracle Certified Professional Database Administrator (OCP) MS Access Certified Expert (MAUS) |
Linear Mode
