Mapping Open Data – An Easy How-To Guide

What is open data? This is any information online that you can use freely for your own purposes. Open data comes in different formats which are identifiable by their individual extensions, such as TXT, DOC, DOCX, and PDF extensions for document file formats; XLS and XLSX extensions for worksheet file formats; and JPEG, PNG, GIF, and PDF for image file formats. 

With ShowMyMap’s smart tools, you can use and manipulate any open data to unlock unique and powerful insights that you can use to suit your needs, whether they’re for your website, blog, or social media page. 

For this easy open-data mapping how-to guide, we’ll be using open data derived from Wikipedia that lists the tallest buildings in the world. We will walk you through the steps of mapping and visualizing any data set you can freely access and use online.

How To Map Open Data Using ShowMyMap

Here are the basic steps:

  1. You’ll copy the data from Wikipedia and paste it into a spreadsheet.
  2. The link to the Wikipedia data is here:  https://en.wikipedia.org/wiki/List_of_tallest_buildings
  3. Simply highlight and copy the data in the table. Go to your spreadsheet and paste the data as text into it. Pasting as text removes unnecessary hyperlinks and formats. Save your spreadsheet.
  4. And then you’ll have to clean up your data. This means removing anything you don’t need to ensure that your map will only show what’s relevant to your purposes. 

The first row of your data should contain your headings – these will be used by ShowMyMap when creating your map meta-data. 

Next, delete all the reference numbers in brackets, e.g. [4], [3], [13], etc. You don’t have to delete them one by one. 

  1. Type this keyboard shortcut: Ctrl + H
  2. Type [*] in the “Find what” field; leave the “Replace with” field blank. The “*” denotes the match you want to find within the brackets. 
  3. Click on “Find Next.”
  4. Click on “Replace” for each data match that needs to be removed. 

When you’re done removing the reference numbers, you can rearrange your data columns the way you want them to appear on your map. 

The next step is creating your map. 

  1. Select all the data in your spreadsheet and copy. 
  2. Open the ShowMyMap homepage. 
  3. Paste the copied data into ShowMyMap’s location data box. (Note: You don’t have to register to use our geocoding and mapping tools for data that is less than 250 lines.) 
  4. To ensure that the right values are in the right columns and to make other changes, use the “Validation and Set Options” button located below the location data box. For example, change the region section to “International” because your data set shows the tallest buildings worldwide. 
  5. Click “Make Map.” This will initiate the geocoding process. And then you’ll be shown a preview of your map. 
  6. Click “Save & Continue.” 
  7. You’ll be prompted to enter a map title and your email address so we can send you a direct link to your map, which you can access any time if you need to update it. You also have the option to make your map public or private. Note that for some sharing options, such as embedding, your map will have to be set to “public.”
  8. Now you’re ready to share your map. You can use the same link sent to your inbox to share your map with others. Or you can use the HTML snippet code, also included in your ShowMyMap email, to embed the map on your website. 

And that’s all there is to it! You’re done creating an interactive map using open data! Go ahead and search the world wide web for open data relevant to your interests or purposes and start generating your own interactive map via ShowMyMap!

Finding Other Open Data On The Web

Now that you’ve seen how easy it is to visualize and generate some cool analytics for an open data, from which valuable insights can be gotten, it’s high time you go hunting for more open data and see what you can do with it.

Start creating map

Drag and drop your file (xls, xlsx or csv) Use our sample data, by clicking here. Or

AddressCityStateZipcodeNamePhone NumberGroupURLEmail
12032 SE Sunnyside rdClackamasOR97015Safeway Clackamas(503) 698-1121Group Bhttps://local.safeway.com/safeway/or/clackamas/12032-se-sunnyside-rd.html[email protected]
4715 SE Cesar Estrada Chavez BlvdPortlandOR97202Trader Joe's Portland SE(503) 777-1601Group Chttps://locations.traderjoes.com/or/portland/143/[email protected]
3380 Lancaster Dr NESalemOR 97305Safeway Salem(503) 399-1502Group Bhttps://local.safeway.com/safeway/or/salem/3380-lancaster-dr-ne.html[email protected]
12220 SW Scholls Ferry RdTigardOR97223Whole Foods Market Greenway(971) 371-7000Group Ahttps://www.wholefoodsmarket.com/stores/greenway[email protected]
8145 SW Barbur BlvdPortlandOR97219Safeway Barbur(503) 452-6068Group Bhttps://local.safeway.com/safeway/or/portland/8145-sw-barbur-blvd.html[email protected]
1550 NW 9th St Ste 100CorvallisOR97330Trader Joe's Corvallis(541) 753-0048Group Chttps://locations.traderjoes.com/or/corvallis/154/[email protected]
1210 NW Couch StPortlandOR97209Whole Foods Market Pearl(503) 525-4343Group Ahttps://www.wholefoodsmarket.com/stores/pearl[email protected]
353 E Broadway EugeneOR97401Whole Foods Market Eugene(541) 434-8820Group Ahttps://www.wholefoodsmarket.com/stores/eugene[email protected]
3527 SE 122nd AvePortlandOR97236Safeway 122nd(503) 760-5448Group Bhttps://local.safeway.com/safeway/or/portland/3527-se-122nd-ave.html[email protected]
9940 NE Cornell RdHillsboro OR97124Whole Foods Market Tanasbourne(503) 645-9200Group Ahttps://www.wholefoodsmarket.com/stores/tanasbourne[email protected]
15391 Bangy RdLake OswegoOR97035Trader Joe's Oswego(503) 639-3238Group Chttps://locations.traderjoes.com/or/lake-oswego/142/[email protected]
2490 OR-99WMcMinnivilleOR97128Safeway McMinniville(503) 435-3120Group Bhttps://local.safeway.com/safeway/or/mcminnville/2490-n-hwy-99-w.html[email protected]
4121 NE Halsey StPortlandOR97232Trader Joe's Portland Hollywood(503) 284-4232Group Chttps://locations.traderjoes.com/or/portland/144/[email protected]
Drag and drop your file here

- OR -

Copy + paste your data include column files

AddressCityStateZipcodeNamePhone NumberGroupURLEmail
12032 SE Sunnyside rdClackamasOR97015Safeway Clackamas(503) 698-1121Group Bhttps://local.safeway.com/safeway/or/clackamas/12032-se-sunnyside-rd.html[email protected]
4715 SE Cesar Estrada Chavez BlvdPortlandOR97202Trader Joe's Portland SE(503) 777-1601Group Chttps://locations.traderjoes.com/or/portland/143/[email protected]
3380 Lancaster Dr NESalemOR 97305Safeway Salem(503) 399-1502Group Bhttps://local.safeway.com/safeway/or/salem/3380-lancaster-dr-ne.html[email protected]
12220 SW Scholls Ferry RdTigardOR97223Whole Foods Market Greenway(971) 371-7000Group Ahttps://www.wholefoodsmarket.com/stores/greenway[email protected]
8145 SW Barbur BlvdPortlandOR97219Safeway Barbur(503) 452-6068Group Bhttps://local.safeway.com/safeway/or/portland/8145-sw-barbur-blvd.html[email protected]
1550 NW 9th St Ste 100CorvallisOR97330Trader Joe's Corvallis(541) 753-0048Group Chttps://locations.traderjoes.com/or/corvallis/154/[email protected]
1210 NW Couch StPortlandOR97209Whole Foods Market Pearl(503) 525-4343Group Ahttps://www.wholefoodsmarket.com/stores/pearl[email protected]
353 E Broadway EugeneOR97401Whole Foods Market Eugene(541) 434-8820Group Ahttps://www.wholefoodsmarket.com/stores/eugene[email protected]
3527 SE 122nd AvePortlandOR97236Safeway 122nd(503) 760-5448Group Bhttps://local.safeway.com/safeway/or/portland/3527-se-122nd-ave.html[email protected]
9940 NE Cornell RdHillsboro OR97124Whole Foods Market Tanasbourne(503) 645-9200Group Ahttps://www.wholefoodsmarket.com/stores/tanasbourne[email protected]
15391 Bangy RdLake OswegoOR97035Trader Joe's Oswego(503) 639-3238Group Chttps://locations.traderjoes.com/or/lake-oswego/142/[email protected]
2490 OR-99WMcMinnivilleOR97128Safeway McMinniville(503) 435-3120Group Bhttps://local.safeway.com/safeway/or/mcminnville/2490-n-hwy-99-w.html[email protected]
4121 NE Halsey StPortlandOR97232Trader Joe's Portland Hollywood(503) 284-4232Group Chttps://locations.traderjoes.com/or/portland/144/[email protected]
Copy + paste your data
Configuration

Map Fields

+ Add Custom Field
Show More

    Oh no!

    On the free tier you can only map up to 150 locations at one time. Please add a plan if you wish to map more than 150 locations.

    Related Articles