Advanced Search

"Clean" geonames

/ Published in: SQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. DELETE FROM "alternatename" WHERE geonameid IN 
  2.   (SELECT geonameid FROM geoname WHERE fclass='H');
  3. DELETE FROM geoname WHERE fclass='H';
  4.  
  5. DELETE FROM "alternatename" WHERE geonameid IN 
  6.   (SELECT geonameid FROM geoname WHERE fcode='ADM3');
  7. DELETE FROM geoname WHERE fcode='ADM3';
  8.  
  9. DELETE FROM "alternatename" WHERE geonameid IN 
  10.   (SELECT geonameid FROM geoname WHERE fcode='ADM4');
  11. DELETE FROM geoname WHERE fcode='ADM4';
  12.  
  13. DELETE FROM "alternatename" WHERE geonameid IN 
  14.   (SELECT geonameid FROM geoname WHERE fclass='R');
  15. DELETE FROM geoname WHERE fclass='R';
  16.  
  17. DELETE FROM "alternatename" WHERE geonameid IN 
  18.   (SELECT geonameid FROM geoname WHERE fclass='S');
  19. DELETE FROM geoname WHERE fclass='S';
  20.  
  21. DELETE FROM "alternatename" WHERE geonameid IN 
  22.   (SELECT geonameid FROM geoname WHERE fclass='T');
  23. DELETE FROM geoname WHERE fclass='T';
  24.  
  25. DELETE FROM "alternatename" WHERE geonameid IN 
  26.   (SELECT geonameid FROM geoname WHERE fclass='U');
  27. DELETE FROM geoname WHERE fclass='U';
  28.  
  29. DELETE FROM "alternatename" WHERE geonameid IN 
  30.   (SELECT geonameid FROM geoname WHERE fclass='V');
  31. DELETE FROM geoname WHERE fclass='V';

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.