X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/a06947934044a2d48f490580773aaeeaf7659e73..b427fc79656124cd91475ac26016f5865fbc04f3:/docs/develop/Database-Layout.md?ds=sidebyside diff --git a/docs/develop/Database-Layout.md b/docs/develop/Database-Layout.md index c2d4d465..98413a0b 100644 --- a/docs/develop/Database-Layout.md +++ b/docs/develop/Database-Layout.md @@ -119,19 +119,19 @@ to compute the address relations between places. These tables are partitioned. Each country is assigned a partition number in the country_name table (see below) and the data is then split between a set of tables, one for each partition. Note that Nominatim still manually manages partitioned tables. -Native support for partitions in PostgreSQL only became useable with version 13. +Native support for partitions in PostgreSQL only became usable with version 13. It will be a little while before Nominatim drops support for older versions. ![address tables](address-tables.svg) -The **search_name_X** table is used to look up streets that appear in the +The **search_name_X** tables are used to look up streets that appear in the `addr:street` tag. The **location_area_large_X** tables are used to look up larger areas (administrative boundaries and place nodes) either through their geographic closeness or through `addr:*` entries. -The **location_road** table is used to find the closest street for a +The **location_road_X** tables are used to find the closest street for a dependent place. All three table cache specific information from the placex table for their @@ -155,9 +155,9 @@ Nominatim also creates a number of static tables at import: default languages and saves the assignment of countries to partitions. * `country_osm_grid` provides a fallback for country geometries -## Auxilary data tables +## Auxiliary data tables -Finally there are some table for auxillary data: +Finally there are some table for auxiliary data: * `location_property_tiger` - saves housenumber from the Tiger import. Its layout is similar to that of `location_propoerty_osmline`.