MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




Using MapPoint to write to database

This is a discussion on Using MapPoint to write to database within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; How do I use MapPoint to divide clients into zipcode regions and write that regional info back INTO my database? ...


Go Back   MapPoint Forums > Map Forums > MapPoint 2006/2009 Discussion

Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read



Click here to register

Reply

 

LinkBack (1) Thread Tools Display Modes
  1 links from elsewhere to this Post. Click to view. #1 (permalink)  
Old 11-22-2003
Junior Member
White Belt
 
Join Date: Nov 2003
Posts: 3
Using MapPoint to write to database

How do I use MapPoint to divide clients into zipcode regions and write that regional info back INTO my database? I want to use MapPoint's visual ability to create regions but then save that information into my database so I can run reports based on those regions. Update Linked Data just refreshes the view MapPoint sees, it does not write to my database.

Thanks in advance...
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2 (permalink)  
Old 11-22-2003
Junior Member
Yellow Belt
 
Join Date: Feb 2003
Posts: 28
If you want to do this through the standard MapPoint menus:
If you have territories by postal codes and your imported data contains postal codes (plot client by street address or by postal code), you can export to Excel. One worksheet provides the territory name and zip code pairings. Another worksheet has the matched address and the other fields that were imported to MapPoint. Make sure that the data you import has some key, Client_ID for example, that you can use to match data back to your database. You can then run a query to match the territory name with the address using the postal code. The downside is that the export to Excel can take a while if you are dealing with large datasets.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3 (permalink)  
Old 11-22-2003
Junior Member
White Belt
 
Join Date: Nov 2003
Posts: 3
Using MapPoint to write to database

Thank you for your prompt answer.

Can you create subterritories in MapPoint?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #4 (permalink)  
Old 11-22-2003
Junior Member
White Belt
 
Join Date: Nov 2003
Posts: 3
Using MapPoint to write to database

Subterritories - No.

I found a similar thread from just a few days ago that seems to say there is no way to do subterritories.

Thanks...
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #5 (permalink)  
Old 11-24-2003
Junior Member
Yellow Belt
 
Join Date: Feb 2003
Posts: 28
Sub-Territories

Well, there is not an "easy" way of creating the sub-territories. If you are basing your territories off of postal codes you can simulate sub-territories by building the right queries. You will need to layer your data.

Let's say you want to see a count of clients by sub-territory within a larger territory as well as see the client locations by address.

First import your main territory (by zip/postal code). Then have a second query that groups ZIPs or postal codes into your sub-territories. Import this second query as a shaded area dataset. Plot the data by zip, not by territory. Your third query could plot client location by address. Plot this as a pushpin dataset and use a symbol like a large or small square. Build a fourth query that sums your client count by zipcode or assign one zip in each sub-territory as the "display" zip. Use a count of client id to get the total number of clients by zip or by your display zip. Import this query as a shaded circle dataset.

Downside to all of this is the limitation on the unique values that can be imported at once. I have had to split this into multiple queries and datasets as well as add some text boxes and symbols of my own.

Sometimes you just have to get creative with how you push your datasets around. Let me know if you want to see a small sample of how the output and datasets might look.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Tags
database, mappoint, write


LinkBacks (?)
LinkBack to this Thread: http://www.mapforums.com/using-mappoint-write-database-2142.html

Posted By For Type Date
Car Insurance Cheap - policies insurance, car This thread Refback 08-20-2007 11:01 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
I am trying to write code that centers the map on .... Anonymous MapPoint 2006/2009 Discussion 1 06-19-2002 04:18 AM
I write an application that similar to find functi.... Anonymous MapPoint 2006/2009 Discussion 1 03-09-2002 10:48 PM
I am trying to write some code which mimicks the b.... Anonymous MapPoint 2006/2009 Discussion 1 11-24-2001 03:22 PM
I'm trying to write a VB MapPoint app that assists.... Anonymous MapPoint 2006/2009 Discussion 1 08-26-2001 09:56 AM
I am attempting to write a com addin for mappoint .... Anonymous MapPoint 2006/2009 Discussion 1 03-14-2001 09:44 AM


All times are GMT -5. The time now is 06:43 AM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0
MP2K Magazine
Visitor Map

Catered Chalet
Book a catered chalet online through Holiday Hypermarket. It's easy to use the ski holidays search to find the right holiday for you.

Personal Travel Advisor
Let a personal Travel Advisor help with your travel plans. Travel Counsellors were voted UK's Best Travel Agent at the Guardian Unlimited travel awards

Portugal Holiday
For such a small country, you have many options from which to choose. A Portugal Holiday can include fantastic beaches and stunning scenery. Check out our great deals.

Maldives Holidays
If you are looking for a serene, laid back break in the sunshine, Maldives holidays are the choice for you. Be enchanted by the Maldives!

Morocco
Gain insight on your holiday destination with the ULookUBook travel guides. Find out about Morocco and its customs online. Make an informed decision when you make a booking.

Cheap holiday comparison
Travel.co.uk is a comparison service which makes it easy to search and find your cheap holiday options.

Cheap Holidays in Portugal
Don't spend your hard earned money on travelling agents! Come to On The Beach, and see information on cheap holidays in Portugal.


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