GeoNames Home | Postal Codes | Download / Webservice | About 

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



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

I believe a large number of entries are misclassified as RSV instead of RSVT.

RSV reservoir(s) an artificial pond or lake
RSVT water tank a contained pool or tank of water at, below, or above ground level 


Code:
SELECT country, count(1)
 FROM geoname
 WHERE fcode = 'RSV' AND name LIKE '% Tank'
 GROUP BY country


'GY', 1
'IN', 55
'KE', 5
'LK', 87
'MM', 5
'US', 15623
marc



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

Thanks. I have changed the code for the US entries.

Marc

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