Remove obsolete sql scripts.

Their functionality is now in selection.sql.

3 files changed, 0 insertions, 101 deletions

diff --git a/sources/master/frequent_tags.sql b/sources/master/frequent_tags.sql
deleted file mode 100644
index 87b6a46..0000000
--- a/sources/master/frequent_tags.sql
+++ /dev/null
@@ -1,30 +0,0 @@
--- ============================================================================
---
---  Taginfo
---
---  frequent_tags.sql
---
--- ============================================================================
-
-.bail ON
-
-ATTACH DATABASE '__DIR__/db/taginfo-db.db'                 AS db;
-
--- ============================================================================
-
-DROP TABLE IF EXISTS frequent_tags;
-CREATE TABLE frequent_tags (
-    key   TEXT,
-    value TEXT
-);
-
--- MIN_COUNT_FOR_MAP setting: sources.master.min_count_for_map
-INSERT INTO frequent_tags (key, value) SELECT key, value FROM db.tags WHERE count_all > __MIN_COUNT_FOR_MAP__;
-
-ANALYZE frequent_tags;
-
-.output __DIR__/db/frequent_tags.lst
-
-SELECT key || '=' || value FROM frequent_tags ORDER BY key, value;
-
--- ============================================================================
diff --git a/sources/master/interesting_relation_types.sql b/sources/master/interesting_relation_types.sql
deleted file mode 100644
index e2e7954..0000000
--- a/sources/master/interesting_relation_types.sql
+++ /dev/null
@@ -1,30 +0,0 @@
--- ============================================================================
---
---  Taginfo
---
---  interesting_relation_types.sql
---
--- ============================================================================
-
-.bail ON
-
-ATTACH DATABASE '__DIR__/db/taginfo-db.db' AS db;
-
--- ============================================================================
-
-DROP TABLE IF EXISTS interesting_relation_types;
-CREATE TABLE interesting_relation_types (
-    rtype TEXT
-);
-
--- MIN_COUNT_RELATIONS_PER_TYPE setting: sources.master.min_count_relations_per_type
-INSERT INTO interesting_relation_types (rtype)
-    SELECT value FROM db.tags WHERE key='type' AND count_relations > __MIN_COUNT_RELATIONS_PER_TYPE__;
-
-ANALYZE interesting_relation_types;
-
-.output __DIR__/db/interesting_relation_types.lst
-
-SELECT rtype FROM interesting_relation_types ORDER BY rtype;
-
--- ============================================================================
diff --git a/sources/master/interesting_tags.sql b/sources/master/interesting_tags.sql
deleted file mode 100644
index 406b525..0000000
--- a/sources/master/interesting_tags.sql
+++ /dev/null
@@ -1,41 +0,0 @@
--- ============================================================================
---
---  Taginfo
---
---  interesting_tags.sql
---
--- ============================================================================
-
-.bail ON
-
-ATTACH DATABASE '__DIR__/db/taginfo-db.db'                 AS db;
-ATTACH DATABASE '__DIR__/wiki/taginfo-wiki.db'             AS wiki;
-ATTACH DATABASE '__DIR__/josm/taginfo-josm.db'             AS josm; 
-ATTACH DATABASE '__DIR__/potlatch/taginfo-potlatch.db'     AS potlatch; 
-
--- ============================================================================
-
-DROP TABLE IF EXISTS interesting_tags;
-CREATE TABLE interesting_tags (
-    key   TEXT,
-    value TEXT
-);
-
--- MIN_COUNT_TAGS setting: sources.master.min_count_tags
-INSERT INTO interesting_tags (key, value)
-    SELECT DISTINCT key, NULL FROM db.keys WHERE count_all > __MIN_COUNT_TAGS__
-    UNION
-    SELECT key, value FROM db.tags WHERE count_all > __MIN_COUNT_TAGS__;
-
-DELETE FROM interesting_tags WHERE key IN ('created_by', 'ele', 'height', 'is_in', 'lanes', 'layer', 'maxspeed', 'name', 'ref', 'width') AND value IS NOT NULL;
-DELETE FROM interesting_tags WHERE value IS NOT NULL AND key LIKE '%:%';
-DELETE FROM interesting_tags WHERE value IS NOT NULL AND key LIKE 'fresno_%';
-
-ANALYZE interesting_tags;
-
-.output __DIR__/db/interesting_tags.lst
-
-SELECT key FROM interesting_tags WHERE value IS NULL ORDER BY key;
-SELECT key || '=' || value FROM interesting_tags WHERE value IS NOT NULL ORDER BY key, value;
-
--- ============================================================================