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

mapping county data

This is a discussion on mapping county data within the MapPoint Desktop Discussion forums, part of the Map Forums category; When I used the data mapping wizard and mapped counts by county mp only mapped some of the data. I ...

  1. #1
    garon5 is offline Junior Member Yellow Belt
    Join Date
    Oct 2006
    Posts
    28

    mapping county data

    When I used the data mapping wizard and mapped counts by county mp only mapped some of the data. I had done a "Group by" and "count " in Access after importing data originally in Excel. I added teh county field twice to the query design grid in order to be able to do both a group by and count after clicking the totals button on teh tool bar in teh query design view. My guess is the county data wasn't unique since some states have the same county names.

    My question is: How do I run the query so I can get unique county values? If I add teh state field to the query it also has a "Group by" drop down so grouping by state wouldn't yield teh correct results either.

    IT was worse when I tried to have the data mapping wizard use teh count function.

    Gary

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

    Re: mapping county data

    You'll need to combine the state and county into a single field, such as "Calhoun, MI", in addition to keeping both State and County fields.

  3. #3
    garon5 is offline Junior Member Yellow Belt
    Join Date
    Oct 2006
    Posts
    28

    Re: mapping county data

    Thanks - my coworker just recommended the same thing.

    did you try out that link to claritas? I haven't tried it yet.

    Another question: the map turned out all right but I can't figure out how to have the actual value display in a sized or unsized circle. The book mentions it but doesn't actually tell you how.

    And I'd like to display ethnic population counts in the same map. I assume you can only map two variables in one map (one as shaded area and the other as data in a sized or unsized circle). In other words, popluations of Indians by zip code along with members by zip code. Is there any way to display (in a legible way) populations of Indian, ASian, Latino, E. European and members all in teh same map? I suppose I could do a bar or pie chart along with data in a circle.

    Gary

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

    Re: mapping county data

    Yes - I tried the link. It wasn't very helpful except to say that they have additional data for purchase.

    You can map many different datasets in a single map, although mapping more than a single shaded-area set can cause unreadable overlapping.

    To display the value in a sized/unsized circle, right-click the dataset in the legend pane, select Data Fields..., and select the column which has the data you'd like shown.

  5. #5
    garon5 is offline Junior Member Yellow Belt
    Join Date
    Oct 2006
    Posts
    28

    Re: mapping county data

    Thanks, and on to my next question:

    When I made a calculated field in the Access query grid for county & state so county data would be unique, I actually made it twice - one to choose "Group by" and one to choose "count." but Access didn't like it and said I have two of hte same field.

    It had worked using just hte county field twice for group by and count, it only didn't work when I did it as a calculated concatenation.

    As far as displaying data, then you agree taht the best way for four ethnicities plus a membership value would be a bar chart plus a sized circle iwth the value inside?

    Gary.

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

    Re: mapping county data

    I'd have to see your actual T-SQL query to evaulate it. Typically, there aren't any issues with multiple aggregates as long as coded properly. GIGO.

    Yes, although I typically would use shaded area as a base (membership, and then multiple (4) circle datasets (ethnicity) thereon.

    HTH
    Paul

  7. #7
    ThomCarr is offline Junior Member White Belt
    Join Date
    May 2007
    Location
    Washington, DC
    Posts
    4

    Re: mapping county data

    Quote Originally Posted by garon5 View Post
    Thanks, and on to my next question:

    When I made a calculated field in the Access query grid for county & state so county data would be unique, I actually made it twice - one to choose "Group by" and one to choose "count." but Access didn't like it and said I have two of hte same field.

    It had worked using just hte county field twice for group by and count, it only didn't work when I did it as a calculated concatenation.

    As far as displaying data, then you agree taht the best way for four ethnicities plus a membership value would be a bar chart plus a sized circle iwth the value inside?

    Gary.
    Gary, First in Access you need to create for crosstab query, the rows will be by State, then County. The columns will the ethnicity field, ideally this should be one field with a "code" in it. Access would create a "view" with a count of each code in different columns and a total column.

    You may have to "play" with it a few times and cross check the counts to the match your base data. Then create simply query of the crosstab query and edit it by adding the column Paul suggests so it is first, so MapPoint can geocode it. How may counties are you dealing with?

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Mapping GPS Data
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 6
    Last Post: 07-24-2009, 10:19 AM
  2. MapPoint.NET Data Mapping
    By Anonymous in forum Bing Maps and MapPoint Web Service
    Replies: 1
    Last Post: 10-29-2003, 10:33 AM
  3. mapping data to territories
    By Siteliner in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 02-10-2003, 05:11 PM
  4. When I imported data at the county level for MA as....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 08-20-2001, 10:18 PM
  5. How do I map county data? Do I put state and count....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 07-08-1999, 07:16 AM

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 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 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96