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

Retail locations data

This is a discussion on Retail locations data within the MapPoint Desktop Discussion forums, part of the Map Forums category; Anyone have an idea as to where I may find Wal-mart, etc. store locations data in a format MP can ...

  1. #1
    cableghost is offline Junior Member Yellow Belt
    Join Date
    Feb 2003

    Retail locations data

    Anyone have an idea as to where I may find Wal-mart, etc. store locations data in a format MP can import?


  2. #2
    calv1ns's Avatar
    calv1ns is offline Member Green Belt
    Join Date
    Mar 2005

    This is will work but... a lot of work

    Hey cableghost

    I did this with Starbucks locations this way.

    a) go to walmarts www site and find the page with the store locator service.

    b) do some examples - with the following URL


    if you replace the search_city and search_state runing through the alphabet and states you'll get them all. i.e. A CA, B CA, A OR, Z WA, ....

    c) now you see the type of results you are going to get write a VB Program to run through all 59 state abr. and 26 letters of the alphabet (1539 combinations). Use this type of code inside a two loops and run through the letters and states:

    Dim xobj As Object

    xurl = "http://www.walmart.com/storeLocator/ca_storefinder_results.do?" _
    & "sfsearch_city=" & this_alpha & "sfsearch_state=" _
    & this_state & " &sfsearch_zip=&continue=35&x=29&y=17"

    Rsp_Text = ""
    Set xobj = CreateObject("MSXML2.XMLHTTP")

    xobj.Open "GET", xurl, False
    xobj.SetRequestHeader "Content-type", "text/html"

    Rsp_Text = xobj.ResponseText
    rsp_status = xobj.Status


    You'll have to mess with the xurl string to get the quotes just right and set the two varriables for this_letter and this_state. Once it works...

    You can now parse the results of the Rsp_Text string to get the details of the stores returned and the fields you want - they seem to have Store Name, Store Number, Street Address (Street, City, Region, ZIP) and Phone Number). You likely want to dump this data into Excel or Access then do some deletion of duplicate store numbers. The whole effort shouldn't take you more than a day and a half. A day to get the programming and 1/2 a day to run it.

    You could do the same approach and loop through the vaild zip codes. While that maybe a easier program (i.e. one loop). The execution might take longer as you have a lot more vaild zips. You can find a table of valid zip codes here. http://phaster.com/zip_code.html

    If you like I can do this and give you an MS Access MDB with all the USA WallyMart Stores. Drop me a line and we can agree on a price.

    Good Luck,

  3. #3
    chrishathaway is offline Junior Member White Belt
    Join Date
    Dec 2006

    Re: Retail locations data

    It looks like someone has already gone through the steps, and is selling them in CSV format for cheap, which you can import into Excel and then put into MapPoint. I found Walmart, Best Buy, and a bunch of others. They've all got longitude/latitude coordinates, too.

    AggData | All the data you need.

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

    Re: Retail locations data

    It looks like that someone is you?
    About the Site | AggData
    hehe. Good luck.

    I have done some work with a company DataSource Technologies, Inc. :: Your GIS Solution that has well over 1M retail location records in a wide range of industries.


Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Microsoft Moves to Small Business Accounting/Retail Market
    By Andrew Karasev in forum News and Announcements
    Replies: 0
    Last Post: 08-11-2005, 07:23 PM
  2. Problem with locations
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 09-12-2004, 09:34 AM
  3. Incorrect locations?
    By harris00 in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 05-25-2004, 10:40 PM
  4. Import locations
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 09-10-2002, 04:20 PM
  5. I have 2 sets of data detailing locations. The fi....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 08-28-2001, 09:30 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