<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "database model"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "database model"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>database model</title>
				<description><![CDATA[ Hello everybody,

Can somebody tell me if there are ADMs which have cities as well as deeper ADMs (e.g. parent ADM1, child ADM2) as children? Or are the children of an ADM always either only ADMs or only cities?

I've tried to work on a SQL query but somehow can not seem to crack this problem.

Thanks,
Jonas]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1307.page#5519</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1307.page#5519</link>
				<pubDate><![CDATA[Thu, 5 Mar 2009 08:49:37]]> GMT</pubDate>
				<author><![CDATA[ Jonas]]></author>
			</item>
			<item>
				<title>Re:database model</title>
				<description><![CDATA[ both is possible. For two reasons.

- the data is not complete. for some cities we don't know the low level admin divisions.
- for historic reasons not all cities in a country are on the same admin level.


Marc]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1307.page#5522</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1307.page#5522</link>
				<pubDate><![CDATA[Thu, 5 Mar 2009 21:16:47]]> GMT</pubDate>
				<author><![CDATA[ marc]]></author>
			</item>
			<item>
				<title>Re:database model</title>
				<description><![CDATA[ Ok, thanks for the info Marc! :-)]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/1307.page#5525</guid>
				<link>http://forum.geonames.org/gforum/posts/list/1307.page#5525</link>
				<pubDate><![CDATA[Fri, 6 Mar 2009 01:10:24]]> GMT</pubDate>
				<author><![CDATA[ Jonas]]></author>
			</item>
	</channel>
</rss>