From: Sarah Hoffmann Date: Thu, 29 Jun 2017 21:39:31 +0000 (+0200) Subject: remove unused loaddata file X-Git-Tag: v3.1.0~88^2~36 X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/79aa74b7710f7381b71c89490fc7c9a34967e958?ds=inline remove unused loaddata file Load data is being done in the setup script. --- 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;