Advanced Search

Return to Snippet

Revision: 5553
at March 15, 2008 10:00 by guidoderosa
Initial Code 
DELETE FROM "alternatename" WHERE geonameid IN 
  (SELECT geonameid FROM geoname WHERE fclass='H');
DELETE FROM geoname WHERE fclass='H';

DELETE FROM "alternatename" WHERE geonameid IN 
  (SELECT geonameid FROM geoname WHERE fcode='ADM3');
DELETE FROM geoname WHERE fcode='ADM3';

DELETE FROM "alternatename" WHERE geonameid IN 
  (SELECT geonameid FROM geoname WHERE fcode='ADM4');
DELETE FROM geoname WHERE fcode='ADM4';

DELETE FROM "alternatename" WHERE geonameid IN 
  (SELECT geonameid FROM geoname WHERE fclass='R');
DELETE FROM geoname WHERE fclass='R';

DELETE FROM "alternatename" WHERE geonameid IN 
  (SELECT geonameid FROM geoname WHERE fclass='S');
DELETE FROM geoname WHERE fclass='S';

DELETE FROM "alternatename" WHERE geonameid IN 
  (SELECT geonameid FROM geoname WHERE fclass='T');
DELETE FROM geoname WHERE fclass='T';

DELETE FROM "alternatename" WHERE geonameid IN 
  (SELECT geonameid FROM geoname WHERE fclass='U');
DELETE FROM geoname WHERE fclass='U';

DELETE FROM "alternatename" WHERE geonameid IN 
  (SELECT geonameid FROM geoname WHERE fclass='V');
DELETE FROM geoname WHERE fclass='V';
Initial URL 









Initial Description














Initial Title





"Clean" geonames









Initial Tags














Initial Language





SQL