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 |
|
Download
|
Filesize |
3 Kbytes
|
Downloaded: |
1454 time(s) |
|