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 3 of 3

Draw shape, select zip codes and export to SQL

This is a discussion on Draw shape, select zip codes and export to SQL within the MapPoint Desktop Discussion forums, part of the Map Forums category; Hello people... Any ideas on how to draw a polygon on a geomap of zip codes, have the user select ...

  1. #1
    mmartin is offline Member Yellow Belt
    Join Date
    Apr 2007
    Posts
    30

    Cool Draw shape, select zip codes and export to SQL

    Hello people...

    Any ideas on how to draw a polygon on a geomap of zip codes, have
    the user select the area,trap the zips in the shape and export to a dataset?

    I am using mappoint 2006 in visual studio 2005 via activex, VB.

    Best
    M. Martin

  2. #2
    Paul Larson is offline Senior Member Green Belt
    Join Date
    Sep 2005
    Location
    Battle Creek, Michigan
    Posts
    136

    Re: Draw shape, select zip codes and export to SQL

    1) Display the drawing toolbar, which allows the user to activate the polygon tool. See the Control.Toolbars property.
    2) Check to see which shape (polygon) is selected using the Selection property. Or in a click event, use ObjectsFromPoint to get the underlying shape.
    3) Assuming you have coded pushpins for all zipcodes (easily done using the data mapping wizard and a demographic set), you can retrieve all zipcodes within the selected shape using the QueryShape method.
    4) Use your favorite VB ADO method to export the returned pushpin information to a dataset.

    HTH
    Paul

  3. #3
    mmartin is offline Member Yellow Belt
    Join Date
    Apr 2007
    Posts
    30

    Re: Draw shape, select zip codes and export to SQL

    Thanks Paul. The info is a tremendous help.
    Best,
    M.Martin

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Start Draw shape (freeform)
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 10-24-2006, 07:37 PM
  2. Export Zip Codes To Excel
    By JimS in forum MapPoint Desktop Discussion
    Replies: 4
    Last Post: 01-24-2006, 02:46 PM
  3. zip codes within a shape or radius
    By rforkner in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 01-12-2005, 08:25 PM
  4. Find and Export of ZIP Codes
    By Anonymous in forum Wish List
    Replies: 1
    Last Post: 01-16-2003, 07:22 PM
  5. If I draw a closed shape around some pushpins, and....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 03-09-2002, 11:48 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