Merge commit '8c7f8165bdb611f48c0ae63f9318c8490138ffea'

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

@DB
Feature: Import into placex
    Tests that data in placex is completed correctly.

    Scenario: No country code tag is available
        Given the place nodes
          | osm_id | class   | type     | name           | geometry
          | 1      | highway | primary  | 'name' : 'A1'  | country:us
        When importing
        Then table placex contains
          | object | country_code | calculated_country_code |
          | N1     | None         | us                      |

    Scenario: Location overwrites country code tag
        Given the scene country
        And the place nodes
          | osm_id | class   | type     | name           | country_code | geometry
          | 1      | highway | primary  | 'name' : 'A1'  | de           | :us
        When importing
        Then table placex contains
          | object | country_code | calculated_country_code |
          | N1     | de           | us                      |

    Scenario: Country code tag overwrites location for countries
        Given the place areas
          | osm_type | osm_id | class    | type            | admin_level | name            | country_code | geometry
          | R        | 1      | boundary | administrative  | 2           | 'name' : 'foo'  | de           | (-100 40, -101 40, -101 41, -100 41, -100 40)
        When importing
        Then table placex contains
          | object | country_code | calculated_country_code |
          | R1     | de           | de                      |

    Scenario: Illegal country code tag for countries is ignored
        And the place areas
          | osm_type | osm_id | class    | type            | admin_level | name            | country_code | geometry
          | R        | 1      | boundary | administrative  | 2           | 'name' : 'foo'  | xx          | (-100 40, -101 40, -101 41, -100 41, -100 40)
        When importing
        Then table placex contains
          | object | country_code | calculated_country_code |
          | R1     | xx           | us                      |

    Scenario: admin level is copied over
        Given the place nodes
          | osm_id | class | type      | admin_level | name
          | 1      | place | state     | 3           | 'name' : 'foo'
        When importing
        Then table placex contains
          | object | admin_level |
          | N1     | 3           |

    Scenario: admin level is default 15
        Given the place nodes
          | osm_id | class   | type      | name
          | 1      | amenity | prison    | 'name' : 'foo'
        When importing
        Then table placex contains
          | object | admin_level |
          | N1     | 15          |

    Scenario: admin level is never larger than 15
        Given the place nodes
          | osm_id | class   | type      | name           | admin_level
          | 1      | amenity | prison    | 'name' : 'foo' | 16
        When importing
        Then table placex contains
          | object | admin_level |
          | N1     | 15          |


    Scenario: postcode node without postcode is dropped
        Given the place nodes
          | osm_id | class   | type
          | 1      | place   | postcode
        When importing
        Then table placex has no entry for N1

    Scenario: postcode boundary without postcode is dropped
        Given the place areas
          | osm_type | osm_id | class    | type        | geometry
          | R        | 1      | boundary | postal_code | poly-area:0.1
        When importing
        Then table placex has no entry for R1

    Scenario: search and address ranks for GB post codes correctly assigned
        Given the place nodes
         | osm_id  | class | type     | postcode | geometry
         | 1       | place | postcode | E45 2CD  | country:gb
         | 2       | place | postcode | E45 2    | country:gb
         | 3       | place | postcode | Y45      | country:gb
        When importing
        Then table placex contains
         | object | postcode | calculated_country_code | rank_search | rank_address
         | N1     | E45 2CD  | gb                      | 25          | 5
         | N2     | E45 2    | gb                      | 23          | 5
         | N3     | Y45      | gb                      | 21          | 5

    Scenario: wrongly formatted GB postcodes are down-ranked
        Given the place nodes
         | osm_id  | class | type     | postcode | geometry
         | 1       | place | postcode | EA452CD  | country:gb
         | 2       | place | postcode | E45 23   | country:gb
         | 3       | place | postcode | y45      | country:gb
        When importing
        Then table placex contains
         | object | calculated_country_code | rank_search | rank_address
         | N1     | gb                      | 30          | 30
         | N2     | gb                      | 30          | 30
         | N3     | gb                      | 30          | 30

    Scenario: search and address rank for DE postcodes correctly assigned
        Given the place nodes
         | osm_id  | class | type     | postcode | geometry
         | 1       | place | postcode | 56427    | country:de
         | 2       | place | postcode | 5642     | country:de
         | 3       | place | postcode | 5642A    | country:de
         | 4       | place | postcode | 564276   | country:de
        When importing
        Then table placex contains
         | object | calculated_country_code | rank_search | rank_address
         | N1     | de                      | 21          | 11
         | N2     | de                      | 30          | 30
         | N3     | de                      | 30          | 30
         | N4     | de                      | 30          | 30

    Scenario: search and address rank for other postcodes are correctly assigned
        Given the place nodes
         | osm_id  | class | type     | postcode | geometry
         | 1       | place | postcode | 1        | country:ca
         | 2       | place | postcode | X3       | country:ca
         | 3       | place | postcode | 543      | country:ca
         | 4       | place | postcode | 54dc     | country:ca
         | 5       | place | postcode | 12345    | country:ca
         | 6       | place | postcode | 55TT667  | country:ca
         | 7       | place | postcode | 123-65   | country:ca
         | 8       | place | postcode | 12 445 4 | country:ca
         | 9       | place | postcode | A1:bc10  | country:ca
        When importing
        Then table placex contains
         | object | calculated_country_code | rank_search | rank_address
         | N1     | ca                      | 21          | 11
         | N2     | ca                      | 21          | 11
         | N3     | ca                      | 21          | 11
         | N4     | ca                      | 21          | 11
         | N5     | ca                      | 21          | 11
         | N6     | ca                      | 21          | 11
         | N7     | ca                      | 25          | 11
         | N8     | ca                      | 25          | 11
         | N9     | ca                      | 25          | 11


    Scenario: search and address ranks for places are correctly assigned
        Given the named place nodes
          | osm_id | class     | type      | 
          | 1      | foo       | bar       |
          | 11     | place     | Continent |
          | 12     | place     | continent |
          | 13     | place     | sea       |
          | 14     | place     | country   |
          | 15     | place     | state     |
          | 16     | place     | region    |
          | 17     | place     | county    |
          | 18     | place     | city      |
          | 19     | place     | island    |
          | 20     | place     | town      |
          | 21     | place     | village   |
          | 22     | place     | hamlet    |
          | 23     | place     | municipality |
          | 24     | place     | district     |
          | 25     | place     | unincorporated_area |
          | 26     | place     | borough             |
          | 27     | place     | suburb              |
          | 28     | place     | croft               |
          | 29     | place     | subdivision         |
          | 30     | place     | isolated_dwelling   |
          | 31     | place     | farm                |
          | 32     | place     | locality            |
          | 33     | place     | islet               |
          | 34     | place     | mountain_pass       |
          | 35     | place     | neighbourhood       |
          | 36     | place     | house               |
          | 37     | place     | building            |
          | 38     | place     | houses              |
        And the named place nodes
          | osm_id | class     | type      | extratags
          | 100    | place     | locality  | 'locality' : 'townland'
          | 101    | place     | city      | 'capital' : 'yes'
        When importing
        Then table placex contains
          | object | rank_search | rank_address |
          | N1     | 30          | 30 |
          | N11    | 30          | 30 |
          | N12    | 2           | 2 |
          | N13    | 2           | 0 |
          | N14    | 4           | 4 |
          | N15    | 8           | 8 |
          | N16    | 18          | 0 |
          | N17    | 12          | 12 |
          | N18    | 16          | 16 |
          | N19    | 17          | 0 |
          | N20    | 18          | 16 |
          | N21    | 19          | 16 |
          | N22    | 19          | 16 |
          | N23    | 19          | 16 |
          | N24    | 19          | 16 |
          | N25    | 19          | 16 |
          | N26    | 19          | 16 |
          | N27    | 20          | 20 |
          | N28    | 20          | 20 |
          | N29    | 20          | 20 |
          | N30    | 20          | 20 |
          | N31    | 20          | 0 |
          | N32    | 20          | 0 |
          | N33    | 20          | 0 |
          | N34    | 20          | 0 |
          | N100   | 20          | 20 |
          | N101   | 15          | 16 |
          | N35    | 22          | 22 |
          | N36    | 30          | 30 |
          | N37    | 30          | 30 |
          | N38    | 28          | 0 |

    Scenario: search and address ranks for boundaries are correctly assigned
        Given the named place nodes
          | osm_id | class    | type
          | 1      | boundary | administrative
        And the named place ways
          | osm_id | class    | type           | geometry
          | 10     | boundary | administrative | 10 10, 11 11
        And the named place areas
          | osm_type | osm_id | class    | type           | admin_level | geometry
          | R        | 20     | boundary | administrative | 2           | (1 1, 2 2, 1 2, 1 1)
          | R        | 21     | boundary | administrative | 32          | (3 3, 4 4, 3 4, 3 3)
          | R        | 22     | boundary | nature_park    | 6           | (0 0, 1 0, 0 1, 0 0)
          | R        | 23     | boundary | natural_reserve| 10          | (0 0, 1 1, 1 0, 0 0)
        When importing
        Then table placex has no entry for N1
        And table placex has no entry for W10
        And table placex contains
          | object | rank_search | rank_address
          | R20    | 4           | 4
          | R21    | 30          | 30
          | R22    | 12          | 0
          | R23    | 20          | 0

    Scenario Outline: minor highways droped without name, included with
        Given the scene roads-with-pois
        And a wiped database
        And the place ways
          | osm_id | class    | type   | geometry
          | 1      | highway  | <type> | :w-south
        And the named place ways
          | osm_id | class    | type   | geometry
          | 2      | highway  | <type> | :w-north
        When importing
        Then table placex has no entry for W1
        And table placex contains
          | object | rank_search | rank_address
          | W2     | <rank>      | <rank>
          
    Examples:
          | type          | rank
          | service       | 27
          | cycleway      | 27
          | path          | 27
          | footway       | 27
          | steps         | 27
          | bridleway     | 27
          | track         | 26
          | byway         | 26
          | motorway_link | 27
          | primary_link  | 27
          | trunk_link    | 27
          | secondary_link| 27
          | tertiary_link | 27

    Scenario: search and address ranks for highways correctly assigned
        Given the scene roads-with-pois
        And the place nodes
          | osm_id | class    | type 
          | 1      | highway  | bus_stop
        And the place ways
          | osm_id | class    | type         | geometry
          | 1      | highway  | primary      | :w-south
          | 2      | highway  | secondary    | :w-south
          | 3      | highway  | tertiary     | :w-south
          | 4      | highway  | residential  | :w-north
          | 5      | highway  | unclassified | :w-north
          | 6      | highway  | something    | :w-north
        When importing
        Then table placex contains
          | object | rank_search | rank_address
          | N1     | 30          | 30
          | W1     | 26          | 26
          | W2     | 26          | 26
          | W3     | 26          | 26
          | W4     | 26          | 26
          | W5     | 26          | 26
          | W6     | 26          | 26

    Scenario: rank and inclusion of landuses
        Given the place nodes
          | osm_id | class   | type       
          | 1      | landuse | residential
        And the named place nodes
          | osm_id | class   | type       
          | 2      | landuse | residential
        And the place ways
          | osm_id | class   | type        | geometry
          | 1      | landuse | residential | 0 0, 0 1
        And the named place ways
          | osm_id | class   | type        | geometry
          | 2      | landuse | residential | 1 1, 1 1.1
        And the place areas
          | osm_type | osm_id | class   | type        | geometry
          | W        | 3      | landuse | residential | poly-area:0.1
          | R        | 1      | landuse | residential | poly-area:0.01
          | R        | 10     | landuse | residential | poly-area:0.5
        And the named place areas
          | osm_type | osm_id | class   | type        | geometry
          | W        | 4      | landuse | residential | poly-area:0.1
          | R        | 2      | landuse | residential | poly-area:0.05
        When importing
        Then table placex has no entry for N1
        And table placex has no entry for W1
        And table placex has no entry for W3
        And table placex has no entry for R1
        And table placex has no entry for R10
        And table placex contains
          | object | rank_search | rank_address
          | N2     | 30          | 30
          | W2     | 30          | 30
          | W4     | 22          | 22
          | R2     | 22          | 22

    Scenario: rank and inclusion of naturals
       Given the place nodes
          | osm_id | class   | type
          | 1      | natural | peak
          | 3      | natural | volcano
       And the named place nodes
          | osm_id | class   | type
          | 2      | natural | peak
          | 4      | natural | volcano
          | 5      | natural | foobar
       And the place ways
          | osm_id | class   | type           | geometry
          | 1      | natural | mountain_range | 10 10,11 11
       And the named place ways
          | osm_id | class   | type           | geometry
          | 2      | natural | mountain_range | 12 12,11 11
          | 3      | natural | foobar         | 13 13,13.1 13
          | 4      | natural | coastline      | 14 14,14.1 14
       And the place areas
          | osm_type | osm_id | class   | type           | geometry
          | R        | 1      | natural | volcano        | poly-area:0.1
          | R        | 2      | natural | volcano        | poly-area:1.0
       And the named place areas
          | osm_type | osm_id | class   | type           | geometry
          | R        | 3      | natural | volcano        | poly-area:0.1
          | R        | 4      | natural | foobar         | poly-area:0.5
          | R        | 5      | natural | sea            | poly-area:5.0
          | R        | 6      | natural | sea            | poly-area:0.01
          | R        | 7      | natural | coastline      | poly-area:1.0
       When importing
       Then table placex has no entry for N1
       And table placex has no entry for N3
       And table placex has no entry for W1
       And table placex has no entry for R1
       And table placex has no entry for R2
       And table placex has no entry for R7
       And table placex has no entry for W4
       And table placex contains
          | object | rank_search | rank_address
          | N2     | 18          | 0
          | N4     | 18          | 0
          | N5     | 30          | 30
          | W2     | 18          | 0
          | R3     | 18          | 0
          | R4     | 22          | 22
          | R5     | 4           | 4
          | R6     | 4           | 4
          | W3     | 30          | 30