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

VBA - Mapping by congressional districts/custom geographic areas

This is a discussion on VBA - Mapping by congressional districts/custom geographic areas within the Development forums, part of the MapPoint Desktop Discussion category; Hi All, I have been able to automate map creation through excel for mapping by zip code, county, state, etc. ...

  1. #1
    mforando is offline Junior Member White Belt
    Join Date
    Dec 2011
    Posts
    1

    VBA - Mapping by congressional districts/custom geographic areas

    Hi All,

    I have been able to automate map creation through excel for mapping by zip code, county, state, etc. Recently, I have been using the Spatial Data Importer to import MapInfo shape files containing shapes for CBSA's and HRRs (Health regions defined by CMS). Both of these match up directy to county lines, so as a work around I create shaded maps by mapping by county, and then overlay the CBSA/HRR region outline on top of the shaded area map. I turn off the county borders, and since the counties contained in each CBSA/HRR have the same data, they are the same color. With the CBSA outline on top of this, it creates some nice looking maps.

    However, I would really like to create shaded maps by congressional district. I was able to obtain the shape files for these regions. However, since they do not line up directly with zip codes, county lines, or any other geographic region available in Mappoint, I dont think I can use the same method.

    Has anyone come across any other methods to graph using regions not included in MapPoint 2011?

    I am familiar and comfortable using the QueryShape method, and have used this to display pushpins within each shape as I cycle through different regions. Is there anyway to use this to later create shaded maps?

    Thank you,
    -Mason

  2. #2
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    4,565
    Blog Entries
    4

    Re: VBA - Mapping by congressional districts/custom geographic areas

    Hello Mason,

    Welcome to the Forums! Although from your PM, it sounds like you've already been here a while --

    Thank you for all of your postings in the forums. They have been incredibly useful to me learning mappoint's object model and all the features available.
    Anyway, you're welcome and glad you decided to participate in the forums. Hopefully you will find an acceptable solution.

    You said you found shape files.

    There are tools for importing from shape files into MapPoint shape objects. You can't really manipulate shape objects like you can with other datasets using the Map Data Wizard, but it works.

    There is this old "developer sample" VBA code --

    Download: MapPoint Spatial Data Import COM Add-in - Microsoft Download Center - Download Details

    It's buggy, but it has source code so you can modify it however you want e.g. to shape based on certain characteristics (red or blue, etc.)

    The people MS hired to write the above "developer sample" polished the tool off a little and made a commercial tool for end-users --

    Microsoft MapPoint

    Also, Richard Marsden who is very active in here developed MPSuperShape a few years ago that has a number of features for working with shapes in MapPoint including the ability to import from shape files.

    http://www.mpsupershape.com/

    hope this helps and let us know how it goes!
    Eric
    ~ Order MapPoint MapPoint 2011 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Mapping Areas based on Postal Code / Zip Code?
    By toncm1 in forum General Chat
    Replies: 4
    Last Post: 05-30-2009, 05:43 PM
  2. Mapping shaded areas with VBA
    By notaphilic in forum MapPoint Desktop Discussion
    Replies: 11
    Last Post: 03-29-2009, 11:07 PM
  3. Congressional Districts
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 08-03-2004, 09:04 PM
  4. Defining Mapping Areas by Lat/Long
    By amyles in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 10-27-2002, 04:13 PM
  5. Congressional Districts
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 10-10-2002, 10:27 AM

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