Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 5 of 5

Willing to Pay :)

This is a discussion on Willing to Pay :) within the MapPoint Desktop 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 ...

  1. #1
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137

    Willing to Pay :)

    Have a simple "Dealer Locator Application" that I need in an ASP.NET application.

    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

  2. #2
    AndyYule is offline Junior Member White Belt
    Join Date
    Jan 2003
    Posts
    8

    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

  3. #3
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137

  4. #4
    larry_llama is offline Member Yellow Belt
    Join Date
    Dec 2002
    Posts
    35

  5. #5
    David Kachuck is offline Junior Member Yellow Belt
    Join Date
    Jul 2002
    Posts
    17

    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)

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83