All we have to do is concoct a simple Excel formula that reads the "alt" field and adds it to the end of the existing "desc" field.
Since the column with the formulas in it will need to be called "desc" in order for GPS Visualizer to recognize it, we'll rename the original "desc" column to "full name," which GPS Visualizer will ignore. In the screen shot below, you can see the formula in cell C2 laid bare for the world to see; in cells C3 through C5, the results of the formula are visible. Maybe we should have just put the altitude by itself in the description field; it's getting a little messy.
Oh well, there's no harm in experimenting. Note that if your output format supports HTML in waypoint names or descriptions i. One more thing: you can give instructions to GPS Visualizer to synthesize a name or description based on your fields look for synthesize name and synthesize description in the "Advanced waypoint options".
With this feature, you can create interesting names and descriptions without having to use Excel formulas. Click here for an example using dynamic data and the "synthesize" variables.
Each of your points can have its own color, defined by a "color" field. In our example data, we'll assign red to peaks over 14, feet high, green to peaks that are at least 11, feet, and blue to the rest.
Colors can be either "named" HTML color values blue, green, red, black, fuchsia, olive, skyblue, papayawhip, etc.
In Leaflet, Google Maps, and Google Earth, however, you can use a different marker style, either for all points or each point individually. So, let's make a map using triangles and squares.
Click here to pre-fill the map input form with this data. The map on the left is a live, interactive map; note that if you put your mouse pointer over one of the markers, the name shows up. If you click on a marker, an info window pops up with the name of the point in bold at the top, and the description below. This is where including HTML in a description could come in handy.
If you need to, you can also define a whole set of custom markers in various colors, but for each new marker you need to create the main graphic and an optional "shadow" , and then repeat the process for however many different colors you want available.
Then you have to add some JavaScript code to the guts of your map page that defines certain parameters of the new icon. It's powerful, but a pain to set up; send an e-mail if you want to give it a try.
Google Earth makes it very easy to incorporate custom icons into your maps: all you need to supply is the URL of the icon graphic even photograph thumbnails will work , and GE will take care of the rest. Google Earth can even colorize them if you supply a "color" field. Google Earth also has hundreds of "standard" icons that you can easily use. To see all of them, click here ; to find the URL of one of the icons on that page, right-click on the graphic and choose the appropriate command to find its URL.
In Firefox, it's "Copy image location. This could be useful if you want to put a visible label on a track in Google Earth something GE does not normally allow , or to put any sort of label on a map without a specific icon attached to it. Using the "quantitative data" input form , you can have GPS Visualizer resize or colorize your waypoints based on a field or fields of your choice. It's not hard to do, but this feature is important enough to warrant its own tutorial.
ZIP code, Canadian postal code, or airport code. For street addresses, you will need to use GPS Visualizer's Batch Geocoder to add coordinates to your points before proceeding. As always, the header row on your data is important, and preserving the structure of the columns is crucial: you can't put an airport code in the "latitude" column or a city name under "airport.
For Seattle, we've supplied a city and state; for Portland, just its airport code. The unknown fields are left blank. In the. The resulting map is just as you'd expect: a yellow pin on Seattle, and a yellow airport icon on Portland at the location of PDX, Portland's airport. Ben C.
They are in a non-standard format, with two decimal points. Download version 3. Before copying and pasting the coordinate data from Excel into ExpertGPs, I followed these instructions for adding a new coordinate format to ExpertGPS , and selected degrees and minutes hddd mm. I copied the three columns of data from Excel, starting on the second line since the first line contained a title that spanned all three columns.
ExpertGPS wants to see actual data or a header row on the first line of the pasted data. Wayne S. Follow the directions in this tutorial on how to add a new coordinate format to ExpertGPS.
You only need to do this step once. The next step is to receive the waypoints from your GPS. If you only want to export waypoints to DXF, click once in the Waypoint List on the left side of the screen. Otherwise, click on the map, and all of your waypoints and tracks will be exported.
0コメント