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

Finding addresses within drivetime zone

This is a discussion on Finding addresses within drivetime zone within the MapPoint Desktop Discussion forums, part of the Map Forums category; I am an amateur programmer in VB and am pretty proficient in database design and programming in SQL. I also ...

  1. #1
    BigBen is offline Junior Member White Belt
    Join Date
    Jan 2006
    Posts
    2

    Finding addresses within drivetime zone

    I am an amateur programmer in VB and am pretty proficient in database design and programming in SQL. I also do some website design. I am currently working on a project for a restaurant delivery business and recently purchased mappoint.

    I generated a drive time zone and am currently working on refining the delivery area. What I need to do now is to create a program that can be used to verify if an address is within the delivery area. I see two solutions to this:

    1) Simply have the program generate a pushpin at the delivery location and then generate coordinates to see if they are within the delivery zone.

    2) Generate a database/spreadsheet of all street address ranges within the delivery zone.

    I found one post discussing this, but it didn't go into enough detail. Here are the pro's and con's I see with each solution:

    1) Pros: It would be easy to update. It would be rather accurate. Cons: I don't know anything about programming in mappoint. I would have to have mappoint running on each computer running the program. I would either have to integrate mappoint into the ordering software (meaning it couldn't be used without it, unless I wrote code to go around it) or I would have to write an entirely seperate program to do the calculation and then intergrate that into my ordering software.

    2) Pros: I know how to work with DBs rather well. I can simply keep the DB on the systems running my order software and not need mappoint. I could also keep a printed list of all street numbers in a delivery area. Cons: It would require me to regenerate the DB if the delivery area is changed.

    I would really like to go with option 2 since it would be easier on myself. So, is there a way to export a list of all address ranges in a selected area? If not, what information (book or articles on here) do I need to read to be able to use mappoint in my VB projects.

  2. #2
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60
    I think you're going to be out of luck. MapPoint could export all pushpins within a polygon, but not all addresses. Assuming this was possible, I doubt it would be allowed in the EULA. The EULA or api tend to restrict large data extraction due to data licensing issues.

    Also, there's quite a bit of evidence that MapPoint does not store the location of every single address - instead it only stores basic street number info. Eg. "houses on this side of the road run from A to B between these two locations". So the houses would appear to be evenly spaced and not take into account gaps, fields, etc.


    Richard
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

  3. #3
    BigBen is offline Junior Member White Belt
    Join Date
    Jan 2006
    Posts
    2
    I didn't think that it was going to be possible to export all the data. However I think most street number data that is stored by blocks (within metro areas anyway) so I think it would be fairly accurate.

    So.... That leaves option number one. Where do I need to get started reading to learn how to have my apps interact with MapPoint? Any tutorials online or should I buy a book?

  4. #4
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60
    The Help that comes with MapPoint 2004 is actually a pretty good start - you say you know VB already, so it should be easy enough. The main gotchas involve things like recordsets and variants - all things you will already be familiar with (the documentation assumes you know about certain things in VB).

    This site has quite a few articles about performing different actions.
    Then there are two books. The latest is Chandu Thota's "MapPoint in .NET" book in the O'Reilly series. Eric Frost (owner of this site) has some for sale. This has just been published. Don't be discouraged by the title, it also covers the desktop version of MapPoint.

    The other book in existence is the "MapPoint for Dummies" book. It is based on the 2002 version and only gives an introduction to the api. On the positive side, the api has barely changed between 2002 and 2004. 2006 should also be backwards compatible when it is released.


    Richard
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

  5. #5
    DL
    DL is offline Junior Member White Belt
    Join Date
    Jan 2006
    Posts
    1
    I've been throught something like that in the past. Not the same kind of project, but mapping is mapping

    So first, (after getting MapPoint) I've bought a "National ZIP+4 Address Database" from www.zipinfo.com

    Then I've found the Location of the lowest address of every street address range in the needed cities with: oMap.FindAddressResults([Street], [City], [OtherCity], [Region], [PostalCode], [Country])

    Then, you can put on the map all your Locations (found previously) with the oMap.AddPushpin(AtLocation, [Name]) method and move the pushpins in a dataset. (I would put some kind of ID of the street address range in the [Name] property so you can refer it later)

    You have to create an Shape object that will hold your DrivingTimeZone and then you can query your dataset with the oDataSet.QueryShape(oDrivingTimeZoneShape)

    This will return a recordset that will hold all your street address range pushpin that you had created.

    With this recordset you can then go through all the records and get all your street address range that is within your driving time zone.

    I hope it was clear

    If you need help with the Methods/Objects I have written, you can take a look at MSDN Library for the MapPoint Visual Basic Reference at: http://msdn.microsoft.com/library/de...MMMoveNext.asp

    Have fun!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Exporting Drivetime Zone coordinates
    By karlski in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 05-18-2011, 11:37 AM
  2. drivetime zone export problems
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 4
    Last Post: 06-18-2003, 04:00 AM
  3. export drivetime zone
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 05-19-2003, 10:25 AM
  4. Find all zip codes in a drivetime zone
    By SolverDS in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 09-28-2002, 01:40 PM
  5. Find all zip codes within drivetime zone
    By SolverDS in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 09-28-2002, 01:39 PM

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