In this tutorial, I’ll be creating a system map for Boston’s MBTA system, the oldest subway in the world. By placing your custom map symbols online, anyone who uses ExpertGPS, EasyGPS, or Google Earth can view your maps with the custom markers you created. ExpertGPS allows you to create your own custom map symbols, which you can use on your own maps. You can double-click any waypoint to view it on the map, or send the entire list to your GPS receiver.ExpertGPS comes with several hundred waypoint symbols you can use on your maps, but sometimes you need to create a map with your own custom symbology. When you’re done, click OK and ExpertGPS will create new waypoints for each address. I put the store name data in ExpertGPS’ Label field, and the address in Description.

Match up bg_lat to Latitude, bg_long with Longitude. Make sure you’re working with hddd.ddddd coordinates, WGS84 datum in ExpertGPS! Check the box that says your data has a header row. When you paste the geocoded results into the Waypoint List in ExpertGPS, you’ll need to match up the columns in your geocoded data with the data columns in ExpertGPS. The geocoded results should look like the ones below: Geocoded Results: CA Walmart Stores with Latitude/Longitude Press Validate Source, and then Run Geocoder.Īfter the geocoder finishes geocoding your addresses, select the output (Step #6 at ) and paste it into the Waypoint List in ExpertGPS.

Go to a batch geocoding service, and paste your delimited address data into the form in Step #2.

Sample Excel Address Data: All Walmart Stores in California I found some Excel data listing all of the Walmart stores in California – the sample data is listed below. Here are the steps I used to convert the address data below into GPS waypoints I could view on the map in ExpertGPS or send to the GPS receiver in my car as Points of Interest (POIs):Īrrange your data in Excel, and make sure it has a header row.

Paste in a list of addresses, geocode them, and then paste the result into the Waypoint List in ExpertGPS. But if you have more than a few addresses to convert to GPS coordinates, especially if they are in an Excel spreadsheet or some other delimited format, you might be better off using a free batch geocoder. ExpertGPS has a built-in geocoder, the Go to Address command on the Help menu. The process of converting street addresses (17150 East Gale Avenue, City Of Industry CA 91745) into GPS waypoints with latitude and longitude (N34.00016 W117.93220) is called geocoding. I’m trying to punch in multiple locations like 60-80 addresses in the US at a time and be able to see those locations on my computer.īatch Geocoding: Converting Addresses to GPS Coordinates

Expertgps tutorial