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.