Results on Local Nominatim Different Than OpenStreetMap.org

[rmmays]

Hi Everyone,
I have deployed a local install of Nominatim. Loading the globe, wiki, tiger data all went well with no errors. However, when I search an address (e.g. 4922 N Harbor Dr, San Diego, CA 92106) it shows up "close" to the correct spot, but the openstreetmap.org site shows exactly the right spot. I am wondering if there's something I can do to reload my data or re-index it for better results? I am wondering if it is ignoring the house address (4922). It seems to just be finding the street name and showing where it starts.

Correct Result on openstreetmaps.org

My Local Deployment "Incorrect" Result

My Local Deployment "See More" for Incorrect Result

[mtmail]

That looks like TIGER data isn't imported or queried.

• Does the debug output (e.g. https://nominatim.openstreetmap.org/search.php?q=4922%20N%20Harbor%20Dr%2C%20San%20Diego%2C%20CA%2092106&polygon_geojson=1&format=jsonv2&debug=1) show location_property_tiger being queried?

• Can you check the number of rows in the location_property_tiger table? Should be about 30 million.

• Do you have @define('CONST_Use_US_Tiger_Data', true); enabled in build/settings/local.php (might require restart of the webserver).

[mtmail]

Can you check build/settings/setting-frontend.php?

It gets created by utils/setup.php --setup-website (see https://nominatim.org/release-docs/3.6.0/appendix/Install-on-Ubuntu-20/#setting-up-a-webserver) and takes values from the existing configuration to create this new configuration file, code is at https://github.com/osm-search/Nominatim/blob/v3.6.0/lib/setup/SetupClass.php#L705 It's possible if you had CONST_Use_US_Tiger_Data set to false during the initial setup then the value in settings-frontend.php is still false.

[rmmays]

i'm not sure i know how to properly print out the CONST_ variables. I used PHP like 15 years ago and haven't touched it since, so I have no idea what I'm doing.... :-)

// If nothing found then search in Tiger data (location_property_tiger)
echo "TigerDebug: CONST_Use_US_Tiger_Data: " . CONST_Use_US_Tiger_Data . ", bIsIntHouseNumber: " . $bIsIntHouseNumber . ", empty(aResults):" . empty($aResults) . "
";
echo "CONST_Pyosmium_Binary: " . constant(CONST_Pyosmium_Binary) . "
";
echo "CONST_Osm2pgsql_Flatnode_File: " . constant(CONST_Osm2pgsql_Flatnode_File) . "
";
echo "CONST_Debug: " . CONST_Debug . "
";
echo "CONST_Search_BatchMode: " . CONST_Search_BatchMode . "
";
echo "CONST_BasePath: " . CONST_BasePath . "
";
echo "CONST_Database_Web_User: " . CONST_Database_Web_User . "
";
echo "CONST_Import_Style: " . CONST_Import_Style . "
";
echo "CONST_Use_US_Tiger_Data: " . CONST_Use_US_Tiger_Data . "
";

Produces......

TigerDebug: CONST_Use_US_Tiger_Data: , bIsIntHouseNumber: 1, empty(aResults):1
CONST_Pyosmium_Binary:
CONST_Osm2pgsql_Flatnode_File:
CONST_Debug: 1
CONST_Search_BatchMode: 1
CONST_BasePath: /home/nominatim/Nominatim-3.6.0
CONST_Database_Web_User: CONST_Database_Web_User
CONST_Import_Style: CONST_Import_Style
CONST_Use_US_Tiger_Data:

In my debug output

[rmmays]

OOOH!!!!! In my settings-frontend.php is is FALSE!!!!

@define('CONST_BasePath', '/home/nominatim/Nominatim-3.6.0');
if (file_exists(getenv('NOMINATIM_SETTINGS'))) require_once(getenv('NOMINATIM_SETTINGS'));

@define('CONST_Database_DSN', 'pgsql:dbname=nominatim');
@define('CONST_Default_Language', false);
@define('CONST_Log_DB', false);
@define('CONST_Log_File', false);
@define('CONST_Max_Word_Frequency', '50000');
@define('CONST_NoAccessControl', 1);
@define('CONST_Places_Max_ID_count', 50);
@define('CONST_PolygonOutput_MaximumTypes', 1);
@define('CONST_Search_AreaPolygons', 1);
@define('CONST_Search_BatchMode', true);
@define('CONST_Search_NameOnlySearchFrequencyThreshold', 500);
@define('CONST_Search_ReversePlanForAll', 1);
@define('CONST_Term_Normalization_Rules', ":: NFD (); [[:Nonspacing Mark:] [:Cf:]] >; :: lower (); [[:Punctuation:][:Space:]]+ > ' '; :: NFC ();");
@define('CONST_Use_Aux_Location_data', false);
@define('CONST_Use_US_Tiger_Data', false);
@define('CONST_MapIcon_URL', false);

[rmmays]

I updated to true in my settings-frontend.php and that was it!!!! It works now and shows the properly placed spot on the address!!!

Now, do I need to re-run some of the setup stuff to make sure I don't have something else messed up? I tried to follow all the directions, but it seems like some of the procedures are for older versions. I don't know how to get GB tiger data in and i'm not sure if the wiki data worked either....

if i want ALL available data in there, what do i need to download and run?

[mtmail]

Great. US TIGER will work now, no further changes needed.

For wikipedia/wikidata see https://nominatim.org/release-docs/3.6.0/admin/Import/#wikipediawikidata-rankings There is a "If you forgot to download" section.

For US or GB postcode data you can download

cd $NOMINATIM_SOURCE_DIR/data
wget https://www.nominatim.org/data/gb_postcode_data.sql.gz
wget https://www.nominatim.org/data/us_postcode_data.sql.gz

and pipe the data into the database, e.g. zcat $file | pql nominatim to fill the database tables. After run build/utils/update.php --calculate-postcodes, which processes the data into the location_postcodes table.