[Geocoding] Empty search_name in Nominatim DB

Dmitry Dzhus dima at dzhus.org
Mon Oct 29 13:36:58 GMT 2012


29.10.2012, 16:13, "Sarah Hoffmann" <lonvia at denofr.de>:
> This all looks all good on a quick glance. A more basic question: are
> you sure that your import actually finishes? You should have seen
> lots of lines like this:
>
> Done 216 in 10 @ 21.600000 per second - Rank 26 ETA (seconds): 72.916664
>
> And the final output should be a whole bunch of CREATE INDEX.

I can see bunch of CREATE INDEX both in setup.php log and htop, but the final
lines are different. Here's the last part of my import log:


--------- 8< -----------
    ...
    ...
                            addgeometrycolumn                        
    -----------------------------------------------------------------
     public.location_road_0.geometry SRID:4326 TYPE:GEOMETRY DIMS:2 
    (1 row)

    CREATE INDEX
    CREATE INDEX
    CREATE FUNCTION
    CREATE FUNCTION
    CREATE FUNCTION
    CREATE FUNCTION
    CREATE FUNCTION
    CREATE FUNCTION
    CREATE FUNCTION
    CREATE FUNCTION
    CREATE FUNCTION
    CREATE FUNCTION
    CREATE FUNCTION
    CREATE FUNCTION
    WARNING: wikipedia article dump file not found - places will have default importance
    WARNING: wikipedia redirect dump file not found - some place importance values may be missing
    Drop old Data
    .....................................................................................................................................................................................................................................................................
    Loading word list
    SET
    SET
    SET
    SET
    SET
    SET
    SET
    SET
    CREATE TABLE
     count 
    -------
     32621
    (1 row)

     count 
    -------
       703
    (1 row)

     count 
    -------
     11445
    (1 row)

    UPDATE 5092
    DROP TABLE
    Load Data
    .................................
    Reanalysing database...
    NOTICE:   no notnull values, invalid stats
    NOTICE:   no notnull values, invalid stats
    ANALYZE
    settings/configuration.txt already exists
    Getting state file: http://planet.openstreetmap.org/replication/minute/000/065/479.state.txt
    Updating DB status
-------- >8 ------------

And that's it.



More information about the Geocoding mailing list