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

Sum of Items within a Radius?

This is a discussion on Sum of Items within a Radius? within the MapPoint Desktop Discussion forums, part of the Map Forums category; Relatively new to mappoint - question is this: IS there a way to count up the number of items within ...

  1. #1
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137

    Sum of Items within a Radius?

    Relatively new to mappoint - question is this:
    IS there a way to count up the number of items within a selected radius? I am asking this to find a way to count sales within a radius or any item.

    I know mappoint can sum the imported data through metro areas, but I didn't know if there was a way within mappoint, or a plugin or tool, that would allow me to do this.

    thanks!

    mc

  2. #2
    Wilfried is offline Senior Member Black Belt
    Join Date
    Nov 2004
    Location
    Belgium
    Posts
    2,433
    Hi,

    Yes very easy to do. I just made this testcode to see if it works:

    Code:
            private void selectedareaToolStripMenuItem_Click(object sender, EventArgs e)
            {
                MapPoint.SelectedArea sa = MP.ActiveMap.SelectedArea;
                Location[] loc = new Location[5];
    
                loc[0] = MP.ActiveMap.XYToLocation(sa.Left, sa.Top);
                loc[1] = MP.ActiveMap.XYToLocation(sa.Left + sa.Width, sa.Top);
                loc[2] = MP.ActiveMap.XYToLocation(sa.Left + sa.Width, sa.Top + sa.Height);
                loc[3] = MP.ActiveMap.XYToLocation(sa.Left, sa.Top + sa.Height);
                loc[4] = loc[0];
    
                MP.ActiveMap.Shapes.AddPolyline(loc);
    
                int PPCount = 0;
                foreach (MapPoint.DataSet ds in MP.ActiveMap.DataSets) {
                    MapPoint.Recordset rs = ds.QueryPolygon(loc);
                    rs.MoveFirst();
                    while (!rs.EOF) {
                        PPCount++;
                        rs.MoveNext();
                    }
                }
                Console.WriteLine("Record count " + Convert.ToString(PPCount));
            }

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. MapPoint Wish List Items
    By Harv in forum Wish List
    Replies: 1
    Last Post: 07-08-2003, 02:28 PM
  2. Remove items from the menu
    By Zanzibar in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 12-23-2002, 05:39 AM
  3. Non Mapped Items
    By Anonymous in forum Wish List
    Replies: 0
    Last Post: 12-17-2002, 03:33 AM
  4. Not mapped items
    By Anonymous in forum Wish List
    Replies: 0
    Last Post: 11-15-2002, 01:18 PM
  5. After you geocode a list of items from an excel fi....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 06-29-2000, 08:00 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 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