Merge pull request #436 from lonvia/remove-location-property-tables

[nominatim.git] / tests / features / db / import / interpolation.feature

diff --git a/tests/features/db/import/interpolation.feature b/tests/features/db/import/interpolation.feature
index ad4bdf851875c4b25b7d73d1d4c42502cbde8c41..195cbfdf27cff359654e5ac88776d468ccdcf8ec 100644 (file)
--- a/tests/features/db/import/interpolation.feature
+++ b/tests/features/db/import/interpolation.feature
@@ -14,13 +14,9 @@ Feature: Import of address interpolations
           | id | nodes
           | 1  | 1,2
         When importing
           | id | nodes
           | 1  | 1,2
         When importing

-        Then node 1 expands to housenumbers
+        Then way 1 expands to housenumbers

           | housenumber | centroid
           | housenumber | centroid

-          | 2           | 1,1

           | 4           | 1,1.0005
           | 4           | 1,1.0005

-        And node 2 expands to housenumbers
-          | housenumber | centroid
-          | 6           | 1,1.001

 
     Scenario: Simple even two point interpolation with zero beginning
         Given the place nodes
 
     Scenario: Simple even two point interpolation with zero beginning
         Given the place nodes


@@ -34,15 +30,11 @@ Feature: Import of address interpolations
           | id | nodes
           | 1  | 1,2
         When importing
           | id | nodes
           | 1  | 1,2
         When importing

-        Then node 1 expands to housenumbers
+        Then way 1 expands to housenumbers

           | housenumber | centroid
           | housenumber | centroid

-          | 0           | 1,1

           | 2           | 1,1.00025
           | 4           | 1,1.0005
           | 6           | 1,1.00075
           | 2           | 1,1.00025
           | 4           | 1,1.0005
           | 6           | 1,1.00075

-        And node 2 expands to housenumbers
-          | housenumber | centroid
-          | 8           | 1,1.001

 
     Scenario: Backwards even two point interpolation
         Given the place nodes
 
     Scenario: Backwards even two point interpolation
         Given the place nodes


@@ -56,13 +48,9 @@ Feature: Import of address interpolations
           | id | nodes
           | 1  | 2,1
         When importing
           | id | nodes
           | 1  | 2,1
         When importing

-        Then node 1 expands to housenumbers
-          | housenumber | centroid
-          | 2           | 1,1
-        And node 2 expands to housenumbers
+        Then way 1 expands to housenumbers

           | housenumber | centroid
           | 4           | 1,1.0005
           | housenumber | centroid
           | 4           | 1,1.0005

-          | 6           | 1,1.001

 
     Scenario: Even two point interpolation with odd beginning
         Given the place nodes
 
     Scenario: Even two point interpolation with odd beginning
         Given the place nodes


@@ -76,14 +64,10 @@ Feature: Import of address interpolations
           | id | nodes
           | 1  | 1,2
         When importing
           | id | nodes
           | 1  | 1,2
         When importing

-        Then node 1 expands to housenumbers
+        Then way 1 expands to housenumbers

           | housenumber | centroid
           | housenumber | centroid

-          | 11          | 1,1

           | 12          | 1,1.0002
           | 14          | 1,1.0006
           | 12          | 1,1.0002
           | 14          | 1,1.0006

-        And node 2 expands to housenumbers
-          | housenumber | centroid
-          | 16          | 1,1.001

 
     Scenario: Even two point interpolation with odd end
         Given the place nodes
 
     Scenario: Even two point interpolation with odd end
         Given the place nodes


@@ -97,14 +81,10 @@ Feature: Import of address interpolations
           | id | nodes
           | 1  | 1,2
         When importing
           | id | nodes
           | 1  | 1,2
         When importing

-        Then node 1 expands to housenumbers
+        Then way 1 expands to housenumbers

           | housenumber | centroid
           | housenumber | centroid

-          | 10          | 1,1

           | 12          | 1,1.0004
           | 14          | 1,1.0008
           | 12          | 1,1.0004
           | 14          | 1,1.0008

-        And node 2 expands to housenumbers
-          | housenumber | centroid
-          | 15          | 1,1.001

 
     Scenario: Reverse even two point interpolation with odd beginning
         Given the place nodes
 
     Scenario: Reverse even two point interpolation with odd beginning
         Given the place nodes


@@ -118,14 +98,10 @@ Feature: Import of address interpolations
           | id | nodes
           | 1  | 2,1
         When importing
           | id | nodes
           | 1  | 2,1
         When importing

-        Then node 1 expands to housenumbers
-          | housenumber | centroid
-          | 11          | 1,1
-        And node 2 expands to housenumbers
+        Then way 1 expands to housenumbers

           | housenumber | centroid
           | 12          | 1,1.0002
           | 14          | 1,1.0006
           | housenumber | centroid
           | 12          | 1,1.0002
           | 14          | 1,1.0006

-          | 16          | 1,1.001

 
     Scenario: Reverse even two point interpolation with odd end
         Given the place nodes
 
     Scenario: Reverse even two point interpolation with odd end
         Given the place nodes


@@ -139,14 +115,10 @@ Feature: Import of address interpolations
           | id | nodes
           | 1  | 2,1
         When importing
           | id | nodes
           | 1  | 2,1
         When importing

-        Then node 1 expands to housenumbers
-          | housenumber | centroid
-          | 10          | 1,1
-        And node 2 expands to housenumbers
+        Then way 1 expands to housenumbers

           | housenumber | centroid
           | 12          | 1,1.0004
           | 14          | 1,1.0008
           | housenumber | centroid
           | 12          | 1,1.0004
           | 14          | 1,1.0008

-          | 15          | 1,1.001

 
       Scenario: Simple odd two point interpolation
         Given the place nodes
 
       Scenario: Simple odd two point interpolation
         Given the place nodes


@@ -160,16 +132,12 @@ Feature: Import of address interpolations
           | id | nodes
           | 1  | 1,2
         When importing
           | id | nodes
           | 1  | 1,2
         When importing

-        Then node 1 expands to housenumbers
+        Then way 1 expands to housenumbers

           | housenumber | centroid
           | housenumber | centroid

-          | 1           | 1,1

           | 3           | 1,1.0002
           | 5           | 1,1.0004
           | 7           | 1,1.0006
           | 9           | 1,1.0008
           | 3           | 1,1.0002
           | 5           | 1,1.0004
           | 7           | 1,1.0006
           | 9           | 1,1.0008

-        And node 2 expands to housenumbers
-          | housenumber | centroid
-          | 11           | 1,1.001

 
       Scenario: Odd two point interpolation with even beginning
         Given the place nodes
 
       Scenario: Odd two point interpolation with even beginning
         Given the place nodes


@@ -183,14 +151,10 @@ Feature: Import of address interpolations
           | id | nodes
           | 1  | 1,2
         When importing
           | id | nodes
           | 1  | 1,2
         When importing

-        Then node 1 expands to housenumbers
+        Then way 1 expands to housenumbers

           | housenumber | centroid
           | housenumber | centroid

-          | 2           | 1,1

           | 3           | 1,1.0002
           | 5           | 1,1.0006
           | 3           | 1,1.0002
           | 5           | 1,1.0006

-        And node 2 expands to housenumbers
-          | housenumber | centroid
-          | 7           | 1,1.001

 
      Scenario: Simple all two point interpolation
         Given the place nodes
 
      Scenario: Simple all two point interpolation
         Given the place nodes


@@ -204,13 +168,9 @@ Feature: Import of address interpolations
           | id | nodes
           | 1  | 1,2
         When importing
           | id | nodes
           | 1  | 1,2
         When importing

-        Then node 1 expands to housenumbers
+        Then way 1 expands to housenumbers

           | housenumber | centroid
           | housenumber | centroid

-          | 1           | 1,1

           | 2           | 1,1.0005
           | 2           | 1,1.0005

-        And node 2 expands to housenumbers
-          | housenumber | centroid
-          | 3           | 1,1.001

 
     Scenario: Simple numbered two point interpolation
         Given the place nodes
 
     Scenario: Simple numbered two point interpolation
         Given the place nodes


@@ -224,13 +184,9 @@ Feature: Import of address interpolations
           | id | nodes
           | 1  | 1,2
         When importing
           | id | nodes
           | 1  | 1,2
         When importing

-        Then node 1 expands to housenumbers
+        Then way 1 expands to housenumbers

           | housenumber | centroid
           | housenumber | centroid

-          | 3           | 1,1

           | 6           | 1,1.0005
           | 6           | 1,1.0005

-        And node 2 expands to housenumbers
-          | housenumber | centroid
-          | 9           | 1,1.001

 
     Scenario: Even two point interpolation with intermediate empty node
         Given the place nodes
 
     Scenario: Even two point interpolation with intermediate empty node
         Given the place nodes


@@ -244,15 +200,11 @@ Feature: Import of address interpolations
           | id | nodes
           | 1  | 1,3,2
         When importing
           | id | nodes
           | 1  | 1,3,2
         When importing

-        Then node 1 expands to housenumbers
+        Then way 1 expands to housenumbers

           | housenumber | centroid
           | housenumber | centroid

-          | 2           | 1,1

           | 4           | 1,1.0005
           | 6           | 1,1.001
           | 8           | 1.0005,1.001
           | 4           | 1,1.0005
           | 6           | 1,1.001
           | 8           | 1.0005,1.001

-        And node 2 expands to housenumbers
-          | housenumber | centroid
-          | 10          | 1.001,1.001

 
 
     Scenario: Even two point interpolation with intermediate duplicated empty node
 
 
     Scenario: Even two point interpolation with intermediate duplicated empty node


@@ -267,22 +219,18 @@ Feature: Import of address interpolations
           | id | nodes
           | 1  | 1,3,3,2
         When importing
           | id | nodes
           | 1  | 1,3,3,2
         When importing

-        Then node 1 expands to housenumbers
+        Then way 1 expands to housenumbers

           | housenumber | centroid
           | housenumber | centroid

-          | 2           | 1,1

           | 4           | 1,1.0005
           | 6           | 1,1.001
           | 8           | 1.0005,1.001
           | 4           | 1,1.0005
           | 6           | 1,1.001
           | 8           | 1.0005,1.001

-        And node 2 expands to housenumbers
-          | housenumber | centroid
-          | 10          | 1.001,1.001

 
     Scenario: Simple even three point interpolation
         Given the place nodes
           | osm_id | class | type  | housenumber | geometry
           | 1      | place | house | 2           | 1 1
 
     Scenario: Simple even three point interpolation
         Given the place nodes
           | osm_id | class | type  | housenumber | geometry
           | 1      | place | house | 2           | 1 1

-          | 2      | place | house | 8           | 1.001 1.001
-          | 3      | place | house | 4           | 1 1.001
+          | 2      | place | house | 14          | 1.001 1.001
+          | 3      | place | house | 10          | 1 1.001

         And the place ways
           | osm_id | class | type   | housenumber | geometry
           | 1      | place | houses | even        | 1 1, 1 1.001, 1.001 1.001
         And the place ways
           | osm_id | class | type   | housenumber | geometry
           | 1      | place | houses | even        | 1 1, 1 1.001, 1.001 1.001


@@ -290,16 +238,54 @@ Feature: Import of address interpolations
           | id | nodes
           | 1  | 1,3,2
         When importing
           | id | nodes
           | 1  | 1,3,2
         When importing

-        Then node 1 expands to housenumbers
+        Then way 1 expands to housenumbers

           | housenumber | centroid
           | housenumber | centroid

-          | 2           | 1,1
-        Then node 3 expands to housenumbers
+          | 4           | 1,1.00025
+          | 6           | 1,1.0005
+          | 8           | 1,1.00075
+          | 12          | 1.0005,1.001
+
+     Scenario: Simple even four point interpolation
+        Given the place nodes
+          | osm_id | class | type  | housenumber | geometry
+          | 1      | place | house | 2           | 1 1
+          | 2      | place | house | 14          | 1.001 1.001
+          | 3      | place | house | 10          | 1 1.001
+          | 4      | place | house | 18          | 1.001 1.002
+        And the place ways
+          | osm_id | class | type   | housenumber | geometry
+          | 1      | place | houses | even        | 1 1, 1 1.001, 1.001 1.001, 1.001 1.002
+        And the ways
+          | id | nodes
+          | 1  | 1,3,2,4
+        When importing
+        Then way 1 expands to housenumbers

           | housenumber | centroid
           | housenumber | centroid

-          | 4           | 1,1.001
-          | 6           | 1.0005,1.001
-        And node 2 expands to housenumbers
+          | 4           | 1,1.00025
+          | 6           | 1,1.0005
+          | 8           | 1,1.00075
+          | 12          | 1.0005,1.001
+          | 16          | 1.001,1.0015
+
+    Scenario: Reverse simple even three point interpolation
+        Given the place nodes
+          | osm_id | class | type  | housenumber | geometry
+          | 1      | place | house | 2           | 1 1
+          | 2      | place | house | 14          | 1.001 1.001
+          | 3      | place | house | 10          | 1 1.001
+        And the place ways
+          | osm_id | class | type   | housenumber | geometry
+          | 1      | place | houses | even        | 1.001 1.001, 1 1.001, 1 1
+        And the ways
+          | id | nodes
+          | 1  | 2,3,1
+        When importing
+        Then way 1 expands to housenumbers

           | housenumber | centroid
           | housenumber | centroid

-          | 8           | 1.001,1.001
+          | 4           | 1,1.00025
+          | 6           | 1,1.0005
+          | 8           | 1,1.00075
+          | 12          | 1.0005,1.001

 
     Scenario: Even three point interpolation with odd center point
         Given the place nodes
 
     Scenario: Even three point interpolation with odd center point
         Given the place nodes


@@ -314,17 +300,10 @@ Feature: Import of address interpolations
           | id | nodes
           | 1  | 1,3,2
         When importing
           | id | nodes
           | 1  | 1,3,2
         When importing

-        Then node 1 expands to housenumbers
+        Then way 1 expands to housenumbers

           | housenumber | centroid
           | housenumber | centroid

-          | 2           | 1,1

           | 4           | 1,1.0004
           | 6           | 1,1.0008
           | 4           | 1,1.0004
           | 6           | 1,1.0008

-        Then node 3 expands to housenumbers
-          | housenumber | centroid
-          | 7           | 1,1.001
-        And node 2 expands to housenumbers
-          | housenumber | centroid
-          | 8           | 1.001,1.001

 
     Scenario: Interpolation on self-intersecting way
         Given the place nodes
 
     Scenario: Interpolation on self-intersecting way
         Given the place nodes


@@ -339,17 +318,9 @@ Feature: Import of address interpolations
           | id | nodes
           | 1  | 1,2,3,2
         When importing
           | id | nodes
           | 1  | 1,2,3,2
         When importing

-        Then node 1 expands to housenumbers
+        Then way 1 expands to housenumbers

           | housenumber | centroid
           | housenumber | centroid

-          | 2           | 0,0

           | 4           | 0,0.0005
           | 4           | 0,0.0005

-        Then node 2 expands to housenumbers
-          | housenumber | centroid
-          | 6           | 0,0.001
-          | 8           | 0,0.0015
-        Then node 3 expands to housenumbers
-          | housenumber | centroid
-          | 10          | 0,0.002

           | 8           | 0,0.0015
 
     Scenario: Interpolation on self-intersecting way II
           | 8           | 0,0.0015
 
     Scenario: Interpolation on self-intersecting way II


@@ -364,12 +335,107 @@ Feature: Import of address interpolations
           | id | nodes
           | 1  | 1,2,3,2
         When importing
           | id | nodes
           | 1  | 1,2,3,2
         When importing

-        Then node 1 expands to housenumbers
+        Then way 1 expands to housenumbers

           | housenumber | centroid
           | housenumber | centroid

-          | 2           | 0,0

           | 4           | 0,0.0005
           | 4           | 0,0.0005

-        Then node 2 expands to housenumbers
-          | housenumber | centroid
-          | 6           | 0,0.001

 
 
 
 

+     Scenario: addr:street on interpolation way
+       Given the scene parallel-road
+       And the place nodes
+          | osm_id | class | type  | housenumber | geometry
+          | 1      | place | house | 2           | :n-middle-w
+          | 2      | place | house | 6           | :n-middle-e
+          | 3      | place | house | 12          | :n-middle-w
+          | 4      | place | house | 16          | :n-middle-e
+       And the place ways
+          | osm_id | class   | type    | housenumber | street       | geometry
+          | 10     | place   | houses  | even        |              | :w-middle
+          | 11     | place   | houses  | even        | Cloud Street | :w-middle
+       And the place ways
+          | osm_id | class   | type     | name                    | geometry
+          | 2      | highway | tertiary | 'name' : 'Sun Way'      | :w-north
+          | 3      | highway | tertiary | 'name' : 'Cloud Street' | :w-south
+        And the ways
+          | id | nodes
+          | 10  | 1,100,101,102,2
+          | 11  | 3,200,201,202,4
+       When importing
+       Then table placex contains
+          | object | parent_place_id
+          | N1     | W2
+          | N2     | W2
+          | N3     | W3
+          | N4     | W3
+          | W10    | W2
+          | W11    | W3
+       And way 10 expands exactly to housenumbers 4
+       And way 11 expands exactly to housenumbers 14
+
+     Scenario: addr:street on housenumber way
+       Given the scene parallel-road
+       And the place nodes
+          | osm_id | class | type  | housenumber | street       | geometry
+          | 1      | place | house | 2           |              | :n-middle-w
+          | 2      | place | house | 6           |              | :n-middle-e
+          | 3      | place | house | 12          | Cloud Street | :n-middle-w
+          | 4      | place | house | 16          | Cloud Street | :n-middle-e
+       And the place ways
+          | osm_id | class   | type    | housenumber | geometry
+          | 10     | place   | houses  | even        | :w-middle
+          | 11     | place   | houses  | even        | :w-middle
+       And the place ways
+          | osm_id | class   | type     | name                    | geometry
+          | 2      | highway | tertiary | 'name' : 'Sun Way'      | :w-north
+          | 3      | highway | tertiary | 'name' : 'Cloud Street' | :w-south
+        And the ways
+          | id | nodes
+          | 10  | 1,100,101,102,2
+          | 11  | 3,200,201,202,4
+       When importing
+       Then table placex contains
+          | object | parent_place_id
+          | N1     | W2
+          | N2     | W2
+          | N3     | W3
+          | N4     | W3
+          | W10    | W2
+          | W11    | W3
+       And way 10 expands exactly to housenumbers 4
+       And way 11 expands exactly to housenumbers 14
+
+    Scenario: Geometry of points and way don't match (github #253)
+        Given the place nodes
+          | osm_id | class | type   | housenumber | geometry
+          | 1      | place | house  | 10          | 144.9632341 -37.76163
+          | 2      | place | house  | 6           | 144.9630541 -37.7628174
+          | 3      | shop  | supermarket | 2      | 144.9629794 -37.7630755
+        And the place ways
+          | osm_id | class | type   | housenumber | geometry
+          | 1      | place | houses | even        | 144.9632341 -37.76163,144.9630541 -37.7628172,144.9629794 -37.7630755
+        And the ways
+          | id | nodes
+          | 1  | 1,2,3
+        When importing
+        Then way 1 expands to housenumbers
+          | housenumber  | centroid
+          | 4            | 144.963016723312,-37.7629464422819+-0.000005
+          | 8            | 144.9631440856,-37.762223694978+-0.000005
+
+    Scenario: Place with missing address information
+        Given the place nodes
+          | osm_id | class   | type   | housenumber | geometry
+          | 1      | place   | house  | 23          | 0.0001 0.0001
+          | 2      | amenity | school |             | 0.0001 0.0002
+          | 3      | place   | house  | 29          | 0.0001 0.0004
+        And the place ways
+          | osm_id | class | type   | housenumber | geometry
+          | 1      | place | houses | odd         | 0.0001 0.0001,0.0001 0.0002,0.0001 0.0004
+        And the ways
+          | id | nodes
+          | 1  | 1,2,3
+        When importing
+        Then way 1 expands to housenumbers
+          | housenumber | centroid
+          | 25          | 0.0001,0.0002
+          | 27          | 0.0001,0.0003