Visokio website     Downloads     Video tutorials     KnowledgeBase  
Problem using Geocodelat and Geocodelon - Visokio Forums
Problem using Geocodelat and Geocodelon
  • DarrenElding August 2, 2012 5:33AM
    Hi, I am using the formulas Geocodelat and Geocodelon to find the X and Y coordinates of some world cities. As far as i understand the input we give to the formulas is a location field which is a text field and can be forulated such as (Postcode, City, Country) or (City, Region) for example. The problem is that there does not seem to be a way to define which fields you are using and the result is that the web based geocoding application (Yahoo) often treats my country name as the city name and I get sites located on the wrong side of the world. As an example, I have a site with the location (Rangel, Angola) where Rangel is the city and Angola is the country. The geocoder locates this to Indiana, USA as there is a city called Angola in Indiana.

    Is there a way to tell it the the first field (before the comma) is the city and the second field (after the comma) is the country?

  • 3 Comments
  •     paola August 2, 2012 5:53AM
    Hi Darren,
    It might be a good idea to separate Postcode/City/Country field into 3 fields, and then use one of our merge files to add coordinates.
    On merge you will get few mis-matches, that you can fix manually. Please make sure that in the Merge operation block you leave in the mismatches from your location list.

    This is the link to find merge files + instructions
    http://www.visokio.com/merge-files

    Related posts can also be found on our Forum
    http://forums.visokio.com/discussion/comment/649/#Comment_649
  • DarrenElding August 2, 2012 7:14AM
    Hi Paola, I am already using the merge files and was using the formulas only to clear up the sites that were not found in the merge file. So I assume there is no way of defining what fields form the Location field.
  •     paola August 2, 2012 2:23PM
    Hi Darren,
    Location for GEOCODExxx functions can be town, postcode, country, area, or combination of all 4 in one field. I tried using following values in [Location] field, and apart from Chile (which ended up in sea near Chile), all other locations were placed successfully on the map:
    London
    SW3 3NR, UK
    55 Markham street, london, england
    Chile
    Alaska
    Bern, Switzerland
    zagreb
    sofia
    bogota
    devon, england

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership