From 79aa74b7710f7381b71c89490fc7c9a34967e958 Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Thu, 29 Jun 2017 23:39:31 +0200 Subject: [PATCH] remove unused loaddata file Load data is being done in the setup script. --- sql/loaddata.sql | 16 ---------------- 1 file changed, 16 deletions(-) delete mode 100644 sql/loaddata.sql diff --git a/sql/loaddata.sql b/sql/loaddata.sql deleted file mode 100644 index a3c8914a..00000000 --- a/sql/loaddata.sql +++ /dev/null @@ -1,16 +0,0 @@ -TRUNCATE placex; -TRUNCATE search_name; -TRUNCATE place_addressline; -TRUNCATE location_area; - -DROP SEQUENCE seq_place; -CREATE SEQUENCE seq_place start 100000; - -insert into placex (osm_type, osm_id, class, type, name, admin_level, housenumber, street, isin, postcode, country_code, extratags, geometry) - select osm_type, osm_id, class, type, name, admin_level, housenumber, street, isin, postcode, country_code, extratags, geometry from place where osm_type = 'N'; -insert into placex (osm_type, osm_id, class, type, name, admin_level, housenumber, street, isin, postcode, country_code, extratags, geometry) - select osm_type, osm_id, class, type, name, admin_level, housenumber, street, isin, postcode, country_code, extratags, geometry from place where osm_type = 'W'; -insert into placex (osm_type, osm_id, class, type, name, admin_level, housenumber, street, isin, postcode, country_code, extratags, geometry) - select osm_type, osm_id, class, type, name, admin_level, housenumber, street, isin, postcode, country_code, extratags, geometry from place where osm_type = 'R'; - ---select count(*) from (select create_interpolation(osm_id, housenumber) from placex where indexed=false and class='place' and type='houses') as x; -- 2.39.5