import TIGER data into temporary table

[nominatim.git] / sql / tiger_import_finish.sql

diff --git a/sql/tiger_import_finish.sql b/sql/tiger_import_finish.sql
new file mode 100644 (file)
index 0000000..a0f4efc
--- /dev/null
+++ b/sql/tiger_import_finish.sql
@@ -0,0 +1,12 @@
+CREATE INDEX idx_location_property_tiger_housenumber_parent_place_id_imp ON location_property_tiger_import (parent_place_id, housenumber);
+CREATE UNIQUE INDEX idx_location_property_tiger_place_id_imp ON location_property_tiger_import (place_id);
+
+GRANT SELECT ON location_property_tiger_import TO "www-data";
+
+DROP TABLE location_property_tiger;
+ALTER TABLE location_property_tiger_import RENAME TO location_property_tiger;
+
+ALTER INDEX idx_location_property_tiger_housenumber_parent_place_id_imp RENAME TO idx_location_property_tiger_housenumber_parent_place_id;
+ALTER INDEX idx_location_property_tiger_place_id_imp RENAME TO idx_location_property_tiger_place_id;
+
+DROP FUNCTION tigger_create_interpolation (linegeo geometry, in_startnumber integer, in_endnumber integer, interpolationtype text, in_street text, in_isin text, in_postcode text);