<![CDATA[Latest posts for the topic "alternatenames *column* versus alternateNames *table*"]]> http://forum.geonames.org/gforum/posts/list/4.page JForum - http://www.jforum.net alternatenames *column* versus alternateNames *table* http://forum.geonames.org/gforum/posts/list/1950.page#7918 http://forum.geonames.org/gforum/posts/list/1950.page#7918 GMT Re:alternatenames *column* versus alternateNames *table* http://forum.geonames.org/gforum/posts/list/1950.page#7919 http://forum.geonames.org/gforum/posts/list/1950.page#7919 GMT Re:alternatenames *column* versus alternateNames *table* Remark : the field 'alternatenames' in the table 'geoname' is a short version of the 'alternatenames' table. You probably don't need both. If you don't need to know the language of a name variant, the field 'alternatenames' will be sufficient. If you need to know the language of a name variant, then you will need to load the table 'alternatenames' and you can drop the column in the geoname table.   What that statement tells me is that the alternatenames field is a subset of the data contained in the alternatenames table. However, that doesn't appear to be the case. Using the postgresql functions string_to_array and unnest, I believe the following query returns the alternatenames that are present in an import of the 'allcountries' table, but which are not present in the 'alternatenames' table (using a case-insensitive comparison): Code:
SELECT FOO.* FROM 
  (SELECT DISTINCT 
    unnest(string_to_array(alternatenames, ',')) AS name 
    FROM allcountries) FOO 
  WHERE NOT EXISTS 
    (SELECT 1 
     FROM alternatenames 
     WHERE lower(alternatenames.name) = lower(FOO.name));
That query results in some 777315 values from the 'alternatenames' column that are not present in the 'alternatenames' table. With respect to the example 'Serbia and Montenegro', that appears to have been an error on my part, however this example: Residence du Ruanda is present in allcountries.txt but is not present in alternatenames.txt (geonameid 49518). ]]> http://forum.geonames.org/gforum/posts/list/1950.page#7920 http://forum.geonames.org/gforum/posts/list/1950.page#7920 GMT Re:alternatenames *column* versus alternateNames *table* http://forum.geonames.org/gforum/posts/list/1950.page#7923 http://forum.geonames.org/gforum/posts/list/1950.page#7923 GMT Re:alternatenames *column* versus alternateNames *table* http://forum.geonames.org/gforum/posts/list/1950.page#7931 http://forum.geonames.org/gforum/posts/list/1950.page#7931 GMT Re:alternatenames *column* versus alternateNames *table* http://forum.geonames.org/gforum/posts/list/1950.page#7936 http://forum.geonames.org/gforum/posts/list/1950.page#7936 GMT