<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "Problem: More than one PREFERED_NAME for PLACE_ID and ISO_LANG"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "Problem: More than one PREFERED_NAME for PLACE_ID and ISO_LANG"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>Problem: More than one PREFERED_NAME for PLACE_ID and ISO_LANG</title>
				<description><![CDATA[ Hi, people!
We've been working for 5 months with your database and we haven't found any problems until now, but we do not know if this is really a problem.
The problem is that there are more than one preferred name for the same place with the same language. This caused problems with our queries, so we chose to uncheck the repeated preferred name randomly.

The query to know the repeated rows is this:

SELECT A.*
FROM ALTNAMES A
         INNER JOIN (SELECT PLACE_ID, ISO_LANG, COUNT(PREFERRED) AS COUNT
                            FROM ALTNAMES
                            WHERE IGNORED = 0 AND PREFERRED = 1
                            GROUP BY PLACE_ID, ISO_LANG
                            HAVING COUNT(PREFERRED) &gt; 1) AS TT
         ON A.PLACE_ID = TT.PLACE_ID
              AND A.ISO_LANG = TT.ISO_LANG
ORDER BY PLACE_ID

We want to know if this is an error or not
Thanks and happy new year!

Draco]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1196.page#5122</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1196.page#5122</link>
				<pubDate><![CDATA[Wed, 31 Dec 2008 18:11:30]]> GMT</pubDate>
				<author><![CDATA[ dracopql]]></author>
			</item>
			<item>
				<title>Re:Problem: More than one PREFERED_NAME for PLACE_ID and ISO_LANG</title>
				<description><![CDATA[ Hi Draco

If you think it is an error than you can help fix the duplicates ;-)

Best

Marc]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1196.page#5129</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1196.page#5129</link>
				<pubDate><![CDATA[Sat, 3 Jan 2009 17:07:44]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
			<item>
				<title>Re:Problem: More than one PREFERED_NAME for PLACE_ID and ISO_LANG</title>
				<description><![CDATA[ We already solve the problem in our database ... we just want to know if it is a real problem (corrupted data).
If that is the case, we'll be proud to help (we'll pass the query).
Just confirm that it is a real problem.

Thanks
Draco]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1196.page#5135</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1196.page#5135</link>
				<pubDate><![CDATA[Sun, 4 Jan 2009 19:17:02]]> GMT</pubDate>
				<author><![CDATA[ dracopql]]></author>
			</item>
			<item>
				<title>Re:Problem: More than one PREFERED_NAME for PLACE_ID and ISO_LANG</title>
				<description><![CDATA[ Hi Draco

The problem is not the query, the problem is to decide which one is the 'best' preferred name'. Someone would need to look at all the duplicates and take a n intelligent decision. It is not an issue of 'corrupt' data, it is an issue of nobody having chosen a single preferred name. 

Marc]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1196.page#5137</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1196.page#5137</link>
				<pubDate><![CDATA[Mon, 5 Jan 2009 07:31:55]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
			<item>
				<title>Re:Problem: More than one PREFERED_NAME for PLACE_ID and ISO_LANG</title>
				<description><![CDATA[ Hi, Marc

You're right, we'll going to make the human choices and, if you think is appropiated, we can make a new post with the remaining places and see if there are people who knows the right one.

Hugs
Draco]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1196.page#5138</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1196.page#5138</link>
				<pubDate><![CDATA[Mon, 5 Jan 2009 12:55:07]]> GMT</pubDate>
				<author><![CDATA[ dracopql]]></author>
			</item>
	</channel>
</rss>