<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Messages posted by "marinheiro"]]></title>
		<link>http://forum.geonames.org/gforum/posts/listByUser/544.page</link>
		<description><![CDATA[Messages posted by "marinheiro"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>Re:UK codes (again)</title>
				<description><![CDATA[ OK, so I have more or less what I need, but I think it's probably not good enough quality to feed back into geonames.

The admin classification I went with is:

ADM1: Government Office Regions. For these I visually estimated the centroids for lat/lon. As with the statistics.gov data, Scotland and Wales are treated 'as if' GORs and have a GOR code. For some reason NI is not included in their data.

ADM2: Metropolitan districts, Counties, (Quasi)Unitary Authorities, London Boroughs: these were all in the geonames database anyway

ADM3: Districts. Most of these were not in the geonames database. For the missing ones I again estimated centroids by eye. The result is not very accurate at all; I realise later it would have been better to establish the town which is the seat of the District Council in each case, then look up the lat/lon of that. But the result is good enough for my own purposes, so I probably won't redo them.

ADM4: Parishes. I matched the government parish names against population centres in geonames (including alternatenames), disambiguating where several have the same name by finding the closest to the district centroid and rejecting if none was within 50 miles.
After that I have 7,319 parishes identified with the geoname equivalents (and so with lat/lon) , but still have 3,969 that don't appear to be in geonames. I'm surprised the number is so high. 

I tried identifying the missing parishes using the data from openstreetmap, but that only gets me another 238. So there are still 3000 or so UK parishes that don't seem to be in any free datasets (unless I have got something wrong somewhere)

Another route to achieve the same thing would be simply to use the district shapefiles to identify all parishes within their boundaries. But I don't have them... 

Graham 


  ]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/preList/614/2850.page#2850</guid>
				<link>http://forum.geonames.org/gforum/posts/preList/614/2850.page#2850</link>
				<pubDate><![CDATA[Wed, 26 Sep 2007 13:18:06]]> GMT</pubDate>
				<author><![CDATA[ marinheiro]]></author>
			</item>
			<item>
				<title>Re:UK codes (again)</title>
				<description><![CDATA[ I'll try to maintain my information in a separate table so I can feed it back to you if you decide to change from FIPs in the future.  I'll mail you off line when I have some data - at the moment this is all hypothetical...

I assume there are no copyirght issues in combining openstreetmap and geonames information?

Graham]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/preList/614/2824.page#2824</guid>
				<link>http://forum.geonames.org/gforum/posts/preList/614/2824.page#2824</link>
				<pubDate><![CDATA[Thu, 20 Sep 2007 09:22:02]]> GMT</pubDate>
				<author><![CDATA[ marinheiro]]></author>
			</item>
			<item>
				<title>Re:UK codes (again)</title>
				<description><![CDATA[ OK, that's fine. In that case I will create my own local version.  At a quick look it seems most of the missing lat/long information  is for the districts, and I may be able to approximate those for myself. If there are any missing for the parishes I'll try to pull the info from openstreetmap. I don't need total acccuracy on the physical positions, just on the nesting of the admin areas, so that should be enough for my needs

Thanks
Graham  

]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/preList/614/2822.page#2822</guid>
				<link>http://forum.geonames.org/gforum/posts/preList/614/2822.page#2822</link>
				<pubDate><![CDATA[Thu, 20 Sep 2007 00:42:32]]> GMT</pubDate>
				<author><![CDATA[ marinheiro]]></author>
			</item>
			<item>
				<title>UK codes (again)</title>
				<description><![CDATA[ Reading over bits and pieces here, on the mailing list and on the blog I'm a little confused about the current state of the UK administrative fields.

I've seen several suggestions that people should make manual corrections,  but there still seem to be errors in the data while the whole set of UK data is available (in rdf form) from the site Marc mentioned on his blog:

http://www.ordnancesurvey.co.uk/oswebsite/ontology/

Is there any reason not to upload that file? Are they different codes from the ones that are currently in use (so I'm seeing data errors when they're actually a different set of codes)?

Secondly, for my own purposes I could really do with something at a higher level than counties. Mark mentioned the OS are standardizing on GORs as a top level administrative descriptor and hinted at the possibility of shifting the UK administrative fields along by one to make room for them; is there still any plan to do that?

I'm new to all this, let me know if I've got the wrong end of the stick.. 

Graham

]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/preList/614/2819.page#2819</guid>
				<link>http://forum.geonames.org/gforum/posts/preList/614/2819.page#2819</link>
				<pubDate><![CDATA[Wed, 19 Sep 2007 19:38:05]]> GMT</pubDate>
				<author><![CDATA[ marinheiro]]></author>
			</item>
			<item>
				<title>Re:Import GeoNames dump into Postgres</title>
				<description><![CDATA[ Just had the same problem with the countryInfo upload claiming that column geonameId doesn't exist. I'm completely new to postgres, but it appears to be a capitalization issue. The sample 'create.sql' file at the head of this thread quotes the field names for the countryInfo table, forcing the I in geonameId to uppercase. psql appears to lowercase field names typed in (I'm using 8.2.4 on debian testing), so it never matches the stored field name.

To fix, just remove the quotes round the field names before creating the table.

Graham 

]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/preList/67/2816.page#2816</guid>
				<link>http://forum.geonames.org/gforum/posts/preList/67/2816.page#2816</link>
				<pubDate><![CDATA[Wed, 19 Sep 2007 13:30:07]]> GMT</pubDate>
				<author><![CDATA[ marinheiro]]></author>
			</item>
	</channel>
</rss>