1 # Customization of the Database
3 This section explains in detail how to configure a Nominatim import and
4 the various means to use external data.
6 ## External postcode data
8 Nominatim creates a table of known postcode centroids during import. This table
9 is used for searches of postcodes and for adding postcodes to places where the
10 OSM data does not provide one. These postcode centroids are mainly computed
11 from the OSM data itself. In addition, Nominatim supports reading postcode
12 information from an external CSV file, to supplement the postcodes that are
15 To enable external postcode support, simply put one CSV file per country into
16 your project directory and name it `<CC>_postcodes.csv`. `<CC>` must be the
17 two-letter country code for which to apply the file. The file may also be
18 gzipped. Then it must be called `<CC>_postcodes.csv.gz`.
20 The CSV file must use commas as a delimiter and have a header line. Nominatim
21 expects three columns to be present: `postcode`, `lat` and `lon`. All other
22 columns are ignored. `lon` and `lat` must describe the x and y coordinates of the
23 postcode centroids in WGS84.
25 The postcode files are loaded only when there is data for the given country
26 in your database. For example, if there is a `us_postcodes.csv` file in your
27 project directory but you import only an excerpt of Italy, then the US postcodes
28 will simply be ignored.
30 As a rule, the external postcode data should be put into the project directory
31 **before** starting the initial import. Still, you can add, remove and update the
32 external postcode data at any time. Simply
36 nominatim refresh --postcodes
39 to make the changes visible in your database. Be aware, however, that the changes
40 only have an immediate effect on searches for postcodes. Postcodes that were
41 added to places are only updated, when they are reindexed. That usually happens
42 only during replication updates.
44 ## Installing Tiger housenumber data for the US
46 Nominatim is able to use the official [TIGER](https://www.census.gov/geographies/mapping-files/time-series/geo/tiger-line-file.html)
47 address set to complement the OSM house number data in the US. You can add
48 TIGER data to your own Nominatim instance by following these steps. The
49 entire US adds about 10GB to your database.
51 1. Get preprocessed TIGER 2020 data:
54 wget https://nominatim.org/data/tiger2020-nominatim-preprocessed.csv.tar.gz
56 2. Import the data into your Nominatim database:
58 nominatim add-data --tiger-data tiger2020-nominatim-preprocessed.csv.tar.gz
60 3. Enable use of the Tiger data in your `.env` by adding:
62 echo NOMINATIM_USE_US_TIGER_DATA=yes >> .env
64 4. Apply the new settings:
66 nominatim refresh --functions
69 See the [developer's guide](../develop/data-sources.md#us-census-tiger) for more
70 information on how the data got preprocessed.
72 ## Special phrases import
74 As described in the [Importation chapter](Import.md), it is possible to
75 import special phrases from the wiki with the following command:
78 nominatim special-phrases --import-from-wiki
81 But, it is also possible to import some phrases from a csv file.
82 To do so, you have access to the following command:
85 nominatim special-phrases --import-from-csv <csv file>
88 Note that the 2 previous import commands will update the phrases from your database.
89 This means that if you import some phrases from a csv file, only the phrases
90 present in the csv file will be kept into the database. All other phrases will
93 If you want to only add new phrases and not update the other ones you can add
94 the argument `--no-replace` to the import command. For example:
97 nominatim special-phrases --import-from-csv <csv file> --no-replace
100 This will add the phrases present in the csv file into the database without
101 removing the other ones.