<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "Allcountries.zip vs single country . zip"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "Allcountries.zip vs single country . zip"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>Allcountries.zip vs single country . zip</title>
				<description><![CDATA[ Hi again,

Does the allcountries file gather exactly all the separate country files ?

For example i notice that be.zip offers the adm2 and adm3 fields which are not fullfilled in the allcountries file for Belgium places ?

Would it be better for users to use each country file instead of working with the big allcountries file ?

If it's not a bug, do you need help to agregate all the last versions of the different countries files in one ?

Seb H, France]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1116.page#4875</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1116.page#4875</link>
				<pubDate><![CDATA[Wed, 29 Oct 2008 23:30:16]]> GMT</pubDate>
				<author><![CDATA[ sebh]]></author>
			</item>
			<item>
				<title>Re:Allcountries.zip vs single country . zip</title>
				<description><![CDATA[ Can you check again and give us an example record? I can't believe this.

Marc]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1116.page#4876</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1116.page#4876</link>
				<pubDate><![CDATA[Thu, 30 Oct 2008 06:58:09]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
			<item>
				<title>Re:Allcountries.zip vs single country . zip</title>
				<description><![CDATA[ Shame on me  :roll: 

I did work probably with an old file. I have deleted them all then load once more the allcountries file, import it to access then from access to sql server and i now have the adm2,3 fields fullfilled for belgium... I'm very sorry Marc. Hope you did not waste your time on my thoughtlessness mistake  :oops: 

one question perhaps :
I'm trying to develop my own chidren / parent sql requests. I'm a little new with the geonames files structure and at certain moments lost with adm1,2,3,4 and fcode which can have different administrative level from a country to another.

In a portal of mine with cities and adm zones, i managed to be sure of the parent / children just adding a "ParentId" field.

Couldn't it be a solution to add a ParentId field in the allcountries file just to be able to have quick sql request instead of trying to see if it exists adm4, adm3, adm2 etc... ?

Hope this could help for future, and sorry again for my mistake about belgium adm fields.

Seb H, France
]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1116.page#4879</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1116.page#4879</link>
				<pubDate><![CDATA[Thu, 30 Oct 2008 17:11:09]]> GMT</pubDate>
				<author><![CDATA[ sebh]]></author>
			</item>
	</channel>
</rss>