From 7c54c81b77c21bbd9551920c0f0c444e7d3d3d6d Mon Sep 17 00:00:00 2001 From: Brian Quinion Date: Thu, 26 Jun 2014 17:12:39 +0100 Subject: [PATCH] update tiger import for changes to functions.sql --- sql/tiger_import_start.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/sql/tiger_import_start.sql b/sql/tiger_import_start.sql index d9def2b4..a6f417f2 100644 --- a/sql/tiger_import_start.sql +++ b/sql/tiger_import_start.sql @@ -53,12 +53,12 @@ BEGIN END IF; place_centroid := ST_Centroid(linegeo); - out_partition := get_partition(place_centroid, 'us'); + out_partition := get_partition('us'); out_parent_place_id := null; address_street_word_id := get_name_id(make_standard_name(in_street)); IF address_street_word_id IS NOT NULL THEN - FOR location IN SELECT * from getNearestNamedRoadFeature(out_partition, place_centroid, address_street_word_id) LOOP + FOR location IN SELECT * from getNearestNamedRoadFeature(out_partition, place_centroid, ARRAY[address_street_word_id]) LOOP out_parent_place_id := location.place_id; END LOOP; END IF; -- 2.39.5