]> git.openstreetmap.org Git - nominatim.git/blob - sql/loaddata.sql
Merge remote-tracking branch 'upstream/master'
[nominatim.git] / sql / loaddata.sql
1 TRUNCATE placex;
2 TRUNCATE search_name;
3 TRUNCATE place_addressline;
4 TRUNCATE location_area;
5
6 DROP SEQUENCE seq_place;
7 CREATE SEQUENCE seq_place start 100000;
8
9 insert into placex (osm_type, osm_id, class, type, name, admin_level, housenumber, street, isin, postcode, country_code, extratags, geometry)
10              select osm_type, osm_id, class, type, name, admin_level, housenumber, street, isin, postcode, country_code, extratags, geometry from place where osm_type = 'N';
11 insert into placex (osm_type, osm_id, class, type, name, admin_level, housenumber, street, isin, postcode, country_code, extratags, geometry)
12              select osm_type, osm_id, class, type, name, admin_level, housenumber, street, isin, postcode, country_code, extratags, geometry from place where osm_type = 'W';
13 insert into placex (osm_type, osm_id, class, type, name, admin_level, housenumber, street, isin, postcode, country_code, extratags, geometry)
14              select osm_type, osm_id, class, type, name, admin_level, housenumber, street, isin, postcode, country_code, extratags, geometry from place where osm_type = 'R';
15
16 --select count(*) from (select create_interpolation(osm_id, housenumber) from placex where indexed=false and class='place' and type='houses') as x;