What if I already have some map coordinates: latitude and longitude?

posted Mar 27, 2014, 9:01 AM by Faustino Rodriguez   [ updated Jun 24, 2014, 8:45 AM ]
The new feature allowing optional Latitude and Longitude columns on the Data sheet, is available since version 1.101sv9 (although not well documented until now)

This is how this feature works:
  • Assuming you already have a set of numeric map coordinates (Latitude and Longitude) for some or all your data
  • These two coordinates have to be in a valid numeric format (it is the only way it works)
    • example of valid numbers: 43.450471, -79.200666
    • but not in other formats like
    • 43.450471N, 79.200666W << invalid
    • 43°27'01.7"N 79°12'02.4"W << invalid
  • Latitude must be between -90 and 90, excluding the extremes
  • Longitude must be between -180 and 180, including the extremes
  • You need to add a couple of extra columns (Latitude and Longitude) on your Data sheet, and enter your coordinates there. The headers (in row #1) for these two extra columns must have exactly those names: Latitude and Longitude
  • The column you select for Location (Address) in the sidebar dialog will only be used if there is no Latitude / Longitude for that particular line
  • The table below is a valid example from a sample spreadsheet
    • in this case, the add-on will use the provided map coordinates (Latitude and Longitude) for Miles and Ferguson
    • but calculate (Geocoding) the coordinates for the other three addresses.
Miles LewisManagement Consultants865 Chestnut Street, Mississauga, ONLetpro43.450471-79.200666
Peggy McknightManagement Consultants313 Elliott Place, Mississauga, ONPolarax
Ferguson SparksTravel Agencies705 Canda Avenue, Mississauga, ONExtragene00
Forbes RiddleTravel Agencies234 Powers Street, Mississauga, ONEarthwax
Cornelia DanielAerospace and Aviation841 Murdock Court, Mississauga, ONDigiprint