GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
Recategorize as Airbase  XML
Forum Index -> Discussion of GeoNames Toponyms
Author Message
IndeedJimmy



Joined: 30/06/2009 23:53:22
Messages: 15
Offline

Can we recategorize all of the included entries as AIRB (Airbase)?

They are currently USGE, AIRP, DAM, STNM.

I used the following query on a slightly older version of a local geonames DB:
SELECT geonameid, name, fcode FROM geoname WHERE (name LIKE '% Air Force Base' OR name LIKE '% AFB' OR name LIKE '% Air Base') AND fcode IN ('USGE','STNM','AIRF','AIRP') order by geonameid
 Description [Disk] Download
 Filesize 3 Kbytes
 Downloaded:  1445 time(s)

marc



Joined: 08/12/2005 07:39:47
Messages: 4412
Offline

done.

Marc

[WWW]
 
Forum Index -> Discussion of GeoNames Toponyms
Go to:   
Powered by JForum 2.1.5 © JForum Team