*.log
*.pyc
-build
-settings/local.php
+docs/develop/*.png
-data/wiki_import.sql
-data/wiki_specialphrases.sql
-data/osmosischange.osc
+build
.vagrant
data/country_osm_grid.sql.gz
--- /dev/null
+# Database Layout
+
+### Import tables
+
+OSM data is initially imported using [osm2pgsql](https://osm2pgsql.org).
+Nominatim uses its own data output style 'gazetteer', which differs from the
+output style created for map rendering.
+
+The import process creates the following tables:
+
+
+
+The `planet_osm_*` tables are the usual backing tables for OSM data. Note
+that Nominatim uses them to look up special relations and to find nodes on
+ways.
+
+The gazetteer style produces a single table `place` as output with the following
+columns:
+
+ * `osm_type` - kind of OSM object (**N** - node, **W** - way, **R** - relation)
+ * `osm_id` - original OSM ID
+ * `class` - key of principal tag defining the object type
+ * `type` - value of principal tag defining the object type
+ * `name` - collection of tags that contain a name or reference
+ * `admin_level` - numerical value of the tagged administrative level
+ * `address` - collection of tags defining the address of an object
+ * `extratags` - collection of additional interesting tags that are not
+ directly relevant for searching
+ * `geometry` - geometry of the object (in WGS84)
+
+A single OSM object may appear multiple times in this table when it is tagged
+with multiple tags that may constitute a principal tag. Take for example a
+motorway bridge. In OSM, this would be a way which is tagged with
+`highway=motorway` and `bridge=yes`. This way would appear in the `place` table
+once with `class` of `highway` and once with a `class` of `bridge`. Thus the
+*unique key* for `place` is (`osm_type`, `osm_id`, `class`).
+
+How raw OSM tags are mapped to the columns in the place table is to a certain
+degree configurable. See [Customizing Import Styles](../customize/Import-Styles.md)
+for more information.
+
+### Search tables
+
+The following tables carry all information needed to do the search:
+
+
+
+The **placex** table is the central table that saves all information about the
+searchable places in Nominatim. The basic columns are the same as for the
+place table and have the same meaning. The placex tables adds the following
+additional columns:
+
+ * `place_id` - the internal unique ID to identify the place
+ * `partition` - the id to use with partitioned tables (see below)
+ * `geometry_sector` - a location hash used for geographically close ordering
+ * `parent_place_id` - the next higher place in the address hierarchy, only
+ relevant for POI-type places (with rank 30)
+ * `linked_place_id` - place ID of the place this object has been merged with.
+ When this ID is set, then the place is invisible for search.
+ * `importance` - measure how well known the place is
+ * `rank_search`, `rank_address` - search and address rank (see [Customizing ranking](../customize/Ranking.md)
+ * `wikipedia` - the wikipedia page used for computing the importance of the place
+ * `country_code` - the country the place is located in
+ * `housenumber` - normalized housenumber, if the place has one
+ * `postcode` - computed postcode for the place
+ * `indexed_status` - processing status of the place (0 - ready, 1 - freshly inserted, 2 - needs updating, 100 - needs deletion)
+ * `indexed_date` - timestamp when the place was processed last
+ * `centroid` - a point feature for the place
+
+The **location_property_osmline** table is a special table for
+[address interpolations](https://wiki.openstreetmap.org/wiki/Addresses#Using_interpolation).
+The columns have the same meaning and use as the columns with the same name in
+the placex table. Only three columns are special:
+
+ * `startnumber` and `endnumber` - beginning and end of the number range
+ for the interpolation
+ * `interpolationtype` - a string `odd`, `even` or `all` to indicate
+ the interval between the numbers
+
+Address interpolations are always ways in OSM, which is why there is no column
+`osm_type`.
+
+The **location_postcode** table holds computed centroids of all postcodes that
+can be found in the OSM data. The meaning of the columns is again the same
+as that of the placex table.
+
+Every place needs an address, a set of surrounding places that describe the
+location of the place. The set of address places is made up of OSM places
+themselves. The **place_addressline** table cross-references for each place
+all the places that make up its address. Two columns define the address
+relation:
+
+ * `place_id` - reference to the place being addressed
+ * `address_place_id` - reference to the place serving as an address part
+
+The most of the columns cache information from the placex entry of the address
+part. The exceptions are:
+
+ * `fromarea` - is true if the address part has an area geometry and can
+ therefore be considered preceise
+ * `isaddress` - is true if the address part should show up in the address
+ output. Sometimes there are multiple places competing for for same address
+ type (e.g. multiple cities) and this field resolves the tie.
+
+The **search_name** table contains the search index proper. It saves for each
+place the terms with which the place can be found. The terms are split into
+the name itself and all terms that make up the address. The table mirrors some
+of the columns from placex for faster lookup.
+
+Search terms are not saved as strings. Each term is assigned an integer and those
+integers are saved in the name and address vectors of the search_name table. The
+**word** table serves as the lookup table from string to such a word ID. The
+exact content of the word table depends on the [tokenizer](Tokenizers.md) used.
+
+## Address computation tables
+
+Next to the main search tables, there is a set of secondary helper tables used
+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.
+It will be a little while before Nominatim drops support for older versions.
+
+
+
+The **search_name_X** table is 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
+dependent place.
+
+All three table cache specific information from the placex table for their
+selected subset of places:
+
+ * `keywords` and `name_vector` contain lists of term ids (from the word table)
+ that the full name of the place should match against
+ * `isguess` is true for places that are not described by an area
+
+All other columns reflect their counterpart in the placex table.
+
+## Static data tables
+
+Nominatim also creates a number of static tables at import:
+
+ * `nominatim_properties` saves settings that must not be changed after
+ import
+ * `address_levels` save the rank information from the
+ [ranking configuration](../customize/Ranking.md)
+ * `country_name` contains a fallback of names for all countries, their
+ default languages and saves the assignment of countries to partitions.
+ * `country_osm_grid` provides a fallback for country geometries
+
+## Auxilary data tables
+
+Finally there are some table for auxillary data:
+
+ * `location_property_tiger` - saves housenumber from the Tiger import. Its
+ layout is similar to that of `location_propoerty_osmline`.
+ * `place_class_*` tables are helper tables to facilitate lookup of POIs
+ by their class and type. They exist because it is not possible to create
+ combined indexes with geometries.
+
+++ /dev/null
-# OSM Data Import
-
-OSM data is initially imported using [osm2pgsql](https://osm2pgsql.org).
-Nominatim uses its own data output style 'gazetteer', which differs from the
-output style created for map rendering.
-
-## Database Layout
-
-The gazetteer style produces a single table `place` with the following rows:
-
- * `osm_type` - kind of OSM object (**N** - node, **W** - way, **R** - relation)
- * `osm_id` - original OSM ID
- * `class` - key of principal tag defining the object type
- * `type` - value of principal tag defining the object type
- * `name` - collection of tags that contain a name or reference
- * `admin_level` - numerical value of the tagged administrative level
- * `address` - collection of tags defining the address of an object
- * `extratags` - collection of additional interesting tags that are not
- directly relevant for searching
- * `geometry` - geometry of the object (in WGS84)
-
-A single OSM object may appear multiple times in this table when it is tagged
-with multiple tags that may constitute a principal tag. Take for example a
-motorway bridge. In OSM, this would be a way which is tagged with
-`highway=motorway` and `bridge=yes`. This way would appear in the `place` table
-once with `class` of `highway` and once with a `class` of `bridge`. Thus the
-*unique key* for `place` is (`osm_type`, `osm_id`, `class`).
--- /dev/null
+@startuml
+skinparam monochrome true
+skinparam ObjectFontStyle bold
+
+map search_name_X {
+ place_id => BIGINT
+ address_rank => SMALLINT
+ name_vector => INT[]
+ centroid => GEOMETRY
+}
+
+map location_area_large_X {
+ place_id => BIGINT
+ keywords => INT[]
+ partition => SMALLINT
+ rank_search => SMALLINT
+ rank_address => SMALLINT
+ country_code => VARCHR(2)
+ isguess => BOOLEAN
+ postcode => TEXT
+ centroid => POINT
+ geometry => GEOMETRY
+}
+
+map location_road_X {
+ place_id => BIGINT
+ partition => SMALLINT
+ country_code => VARCHR(2)
+ geometry => GEOMETRY
+}
+
+search_name_X -[hidden]> location_area_large_X
+location_area_large_X -[hidden]> location_road_X
+
+@enduml
--- /dev/null
+<?xml version="1.0" encoding="UTF-8" standalone="no"?><svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" contentScriptType="application/ecmascript" contentStyleType="text/css" height="195px" preserveAspectRatio="none" style="width:576px;height:195px;background:#FFFFFF;" version="1.1" viewBox="0 0 576 195" width="576px" zoomAndPan="magnify"><defs><filter height="300%" id="f16zzqerbmrtlv" width="300%" x="-1" y="-1"><feGaussianBlur result="blurOut" stdDeviation="2.0"/><feColorMatrix in="blurOut" result="blurOut2" type="matrix" values="0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 .4 0"/><feOffset dx="4.0" dy="4.0" in="blurOut2" result="blurOut3"/><feBlend in="SourceGraphic" in2="blurOut3" mode="normal"/></filter></defs><g><rect fill="#F8F8F8" filter="url(#f16zzqerbmrtlv)" height="80.5313" style="stroke:#383838;stroke-width:1.5;" width="142" x="7" y="52"/><text fill="#000000" font-family="sans-serif" font-size="12" font-weight="bold" lengthAdjust="spacing" textLength="108" x="24" y="65.1387">search_name_X</text><line style="stroke:#383838;stroke-width:1.0;" x1="7" x2="149" y1="69.9688" y2="69.9688"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="38" x="25" y="81.251">place_id</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="34" x="86" y="81.251">BIGINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="81" x2="81" y1="69.9688" y2="85.6094"/><line style="stroke:#383838;stroke-width:1.0;" x1="7" x2="149" y1="85.6094" y2="85.6094"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="64" x="12" y="96.8916">address_rank</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="51" x="86" y="96.8916">SMALLINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="81" x2="81" y1="85.6094" y2="101.25"/><line style="stroke:#383838;stroke-width:1.0;" x1="7" x2="149" y1="101.25" y2="101.25"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="64" x="12" y="112.5322">name_vector</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="24" x="86" y="112.5322">INT[]</text><line style="stroke:#383838;stroke-width:1.0;" x1="81" x2="81" y1="101.25" y2="116.8906"/><line style="stroke:#383838;stroke-width:1.0;" x1="7" x2="149" y1="116.8906" y2="116.8906"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="39" x="24.5" y="128.1729">centroid</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="58" x="86" y="128.1729">GEOMETRY</text><line style="stroke:#383838;stroke-width:1.0;" x1="81" x2="81" y1="116.8906" y2="132.5313"/><rect fill="#F8F8F8" filter="url(#f16zzqerbmrtlv)" height="174.375" style="stroke:#383838;stroke-width:1.5;" width="168" x="200" y="7"/><text fill="#000000" font-family="sans-serif" font-size="12" font-weight="bold" lengthAdjust="spacing" textLength="154" x="207" y="20.1387">location_area_large_X</text><line style="stroke:#383838;stroke-width:1.0;" x1="200" x2="368" y1="24.9688" y2="24.9688"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="38" x="218.5" y="36.251">place_id</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="34" x="280" y="36.251">BIGINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="275" x2="275" y1="24.9688" y2="40.6094"/><line style="stroke:#383838;stroke-width:1.0;" x1="200" x2="368" y1="40.6094" y2="40.6094"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="46" x="214.5" y="51.8916">keywords</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="24" x="280" y="51.8916">INT[]</text><line style="stroke:#383838;stroke-width:1.0;" x1="275" x2="275" y1="40.6094" y2="56.25"/><line style="stroke:#383838;stroke-width:1.0;" x1="200" x2="368" y1="56.25" y2="56.25"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="40" x="217.5" y="67.5322">partition</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="51" x="280" y="67.5322">SMALLINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="275" x2="275" y1="56.25" y2="71.8906"/><line style="stroke:#383838;stroke-width:1.0;" x1="200" x2="368" y1="71.8906" y2="71.8906"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="58" x="208.5" y="83.1729">rank_search</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="51" x="280" y="83.1729">SMALLINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="275" x2="275" y1="71.8906" y2="87.5313"/><line style="stroke:#383838;stroke-width:1.0;" x1="200" x2="368" y1="87.5313" y2="87.5313"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="64" x="205.5" y="98.8135">rank_address</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="51" x="280" y="98.8135">SMALLINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="275" x2="275" y1="87.5313" y2="103.1719"/><line style="stroke:#383838;stroke-width:1.0;" x1="200" x2="368" y1="103.1719" y2="103.1719"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="65" x="205" y="114.4541">country_code</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="58" x="280" y="114.4541">VARCHR(2)</text><line style="stroke:#383838;stroke-width:1.0;" x1="275" x2="275" y1="103.1719" y2="118.8125"/><line style="stroke:#383838;stroke-width:1.0;" x1="200" x2="368" y1="118.8125" y2="118.8125"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="35" x="220" y="130.0947">isguess</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="51" x="280" y="130.0947">BOOLEAN</text><line style="stroke:#383838;stroke-width:1.0;" x1="275" x2="275" y1="118.8125" y2="134.4531"/><line style="stroke:#383838;stroke-width:1.0;" x1="200" x2="368" y1="134.4531" y2="134.4531"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="44" x="215.5" y="145.7354">postcode</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="23" x="280" y="145.7354">TEXT</text><line style="stroke:#383838;stroke-width:1.0;" x1="275" x2="275" y1="134.4531" y2="150.0938"/><line style="stroke:#383838;stroke-width:1.0;" x1="200" x2="368" y1="150.0938" y2="150.0938"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="39" x="218" y="161.376">centroid</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="31" x="280" y="161.376">POINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="275" x2="275" y1="150.0938" y2="165.7344"/><line style="stroke:#383838;stroke-width:1.0;" x1="200" x2="368" y1="165.7344" y2="165.7344"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="48" x="213.5" y="177.0166">geometry</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="58" x="280" y="177.0166">GEOMETRY</text><line style="stroke:#383838;stroke-width:1.0;" x1="275" x2="275" y1="165.7344" y2="181.375"/><rect fill="#F8F8F8" filter="url(#f16zzqerbmrtlv)" height="80.5313" style="stroke:#383838;stroke-width:1.5;" width="143" x="419.5" y="52"/><text fill="#000000" font-family="sans-serif" font-size="12" font-weight="bold" lengthAdjust="spacing" textLength="111" x="435.5" y="65.1387">location_road_X</text><line style="stroke:#383838;stroke-width:1.0;" x1="419.5" x2="562.5" y1="69.9688" y2="69.9688"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="38" x="438" y="81.251">place_id</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="34" x="499.5" y="81.251">BIGINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="494.5" x2="494.5" y1="69.9688" y2="85.6094"/><line style="stroke:#383838;stroke-width:1.0;" x1="419.5" x2="562.5" y1="85.6094" y2="85.6094"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="40" x="437" y="96.8916">partition</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="51" x="499.5" y="96.8916">SMALLINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="494.5" x2="494.5" y1="85.6094" y2="101.25"/><line style="stroke:#383838;stroke-width:1.0;" x1="419.5" x2="562.5" y1="101.25" y2="101.25"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="65" x="424.5" y="112.5322">country_code</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="58" x="499.5" y="112.5322">VARCHR(2)</text><line style="stroke:#383838;stroke-width:1.0;" x1="494.5" x2="494.5" y1="101.25" y2="116.8906"/><line style="stroke:#383838;stroke-width:1.0;" x1="419.5" x2="562.5" y1="116.8906" y2="116.8906"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="48" x="433" y="128.1729">geometry</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="58" x="499.5" y="128.1729">GEOMETRY</text><line style="stroke:#383838;stroke-width:1.0;" x1="494.5" x2="494.5" y1="116.8906" y2="132.5313"/><!--MD5=[55995f5becd151159bf068365903d962]
+link search_name_X to location_area_large_X--><!--MD5=[fbe2ed848b29583363aa66cb2fc47582]
+link location_area_large_X to location_road_X--><!--MD5=[5b9f41070922970c85399fb1a55d3e53]
+@startuml\r
+skinparam monochrome true\r
+skinparam ObjectFontStyle bold\r
+\r
+map search_name_X {\r
+ place_id => BIGINT\r
+ address_rank => SMALLINT\r
+ name_vector => INT[]\r
+ centroid => GEOMETRY\r
+}\r
+\r
+map location_area_large_X {\r
+ place_id => BIGINT\r
+ keywords => INT[]\r
+ partition => SMALLINT\r
+ rank_search => SMALLINT\r
+ rank_address => SMALLINT\r
+ country_code => VARCHR(2)\r
+ isguess => BOOLEAN\r
+ postcode => TEXT\r
+ centroid => POINT\r
+ geometry => GEOMETRY\r
+}\r
+\r
+map location_road_X {\r
+ place_id => BIGINT\r
+ partition => SMALLINT\r
+ country_code => VARCHR(2)\r
+ geometry => GEOMETRY\r
+}\r
+\r
+search_name_X -[hidden]> location_area_large_X\r
+location_area_large_X -[hidden]> location_road_X\r
+\r
+@enduml\r
+
+PlantUML version 1.2021.12(Tue Oct 05 18:01:58 CEST 2021)
+(GPL source distribution)
+Java Runtime: OpenJDK Runtime Environment
+JVM: OpenJDK 64-Bit Server VM
+Default Encoding: UTF-8
+Language: en
+Country: US
+--></g></svg>
\ No newline at end of file
--- /dev/null
+@startuml
+skinparam monochrome true
+skinparam ObjectFontStyle bold
+
+map planet_osm_nodes #eee {
+ id => BIGINT
+ lat => INT
+ lon => INT
+}
+
+map planet_osm_ways #eee {
+ id => BIGINT
+ nodes => BIGINT[]
+ tags => TEXT[]
+}
+
+map planet_osm_rels #eee {
+ id => BIGINT
+ parts => BIGINT[]
+ members => TEXT[]
+ tags => TEXT[]
+ way_off => SMALLINT
+ rel_off => SMALLINT
+}
+
+map place {
+ osm_type => CHAR(1)
+ osm_id => BIGINT
+ class => TEXT
+ type => TEXT
+ name => HSTORE
+ address => HSTORE
+ extratags => HSTORE
+ admin_level => SMALLINT
+ geometry => GEOMETRY
+}
+
+planet_osm_nodes -[hidden]> planet_osm_ways
+planet_osm_ways -[hidden]> planet_osm_rels
+planet_osm_ways -[hidden]-> place
+
+planet_osm_nodes::id <- planet_osm_ways::nodes
+
+@enduml
--- /dev/null
+<?xml version="1.0" encoding="UTF-8" standalone="no"?><svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" contentScriptType="application/ecmascript" contentStyleType="text/css" height="354px" preserveAspectRatio="none" style="width:534px;height:354px;background:#FFFFFF;" version="1.1" viewBox="0 0 534 354" width="534px" zoomAndPan="magnify"><defs><filter height="300%" id="fofrw86h3kqrc" width="300%" x="-1" y="-1"><feGaussianBlur result="blurOut" stdDeviation="2.0"/><feColorMatrix in="blurOut" result="blurOut2" type="matrix" values="0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 .4 0"/><feOffset dx="4.0" dy="4.0" in="blurOut2" result="blurOut3"/><feBlend in="SourceGraphic" in2="blurOut3" mode="normal"/></filter></defs><g><rect fill="#EEEEEE" filter="url(#fofrw86h3kqrc)" height="64.8906" style="stroke:#383838;stroke-width:1.5;" width="145" x="7" y="29.5"/><text fill="#000000" font-family="sans-serif" font-size="12" font-weight="bold" lengthAdjust="spacing" textLength="131" x="14" y="42.6387">planet_osm_nodes</text><line style="stroke:#383838;stroke-width:1.0;" x1="7" x2="152" y1="47.4688" y2="47.4688"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="8" x="15" y="58.751">id</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="34" x="36" y="58.751">BIGINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="31" x2="31" y1="47.4688" y2="63.1094"/><line style="stroke:#383838;stroke-width:1.0;" x1="7" x2="152" y1="63.1094" y2="63.1094"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="12" x="13" y="74.3916">lat</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="16" x="36" y="74.3916">INT</text><line style="stroke:#383838;stroke-width:1.0;" x1="31" x2="31" y1="63.1094" y2="78.75"/><line style="stroke:#383838;stroke-width:1.0;" x1="7" x2="152" y1="78.75" y2="78.75"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="14" x="12" y="90.0322">lon</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="16" x="36" y="90.0322">INT</text><line style="stroke:#383838;stroke-width:1.0;" x1="31" x2="31" y1="78.75" y2="94.3906"/><rect fill="#EEEEEE" filter="url(#fofrw86h3kqrc)" height="64.8906" style="stroke:#383838;stroke-width:1.5;" width="138" x="203.5" y="29.5"/><text fill="#000000" font-family="sans-serif" font-size="12" font-weight="bold" lengthAdjust="spacing" textLength="124" x="210.5" y="42.6387">planet_osm_ways</text><line style="stroke:#383838;stroke-width:1.0;" x1="203.5" x2="341.5" y1="47.4688" y2="47.4688"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="8" x="219" y="58.751">id</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="34" x="247.5" y="58.751">BIGINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="242.5" x2="242.5" y1="47.4688" y2="63.1094"/><line style="stroke:#383838;stroke-width:1.0;" x1="203.5" x2="341.5" y1="63.1094" y2="63.1094"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="29" x="208.5" y="74.3916">nodes</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="42" x="247.5" y="74.3916">BIGINT[]</text><line style="stroke:#383838;stroke-width:1.0;" x1="242.5" x2="242.5" y1="63.1094" y2="78.75"/><line style="stroke:#383838;stroke-width:1.0;" x1="203.5" x2="341.5" y1="78.75" y2="78.75"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="21" x="212.5" y="90.0322">tags</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="31" x="247.5" y="90.0322">TEXT[]</text><line style="stroke:#383838;stroke-width:1.0;" x1="242.5" x2="242.5" y1="78.75" y2="94.3906"/><rect fill="#EEEEEE" filter="url(#fofrw86h3kqrc)" height="111.8125" style="stroke:#383838;stroke-width:1.5;" width="128" x="392.5" y="7"/><text fill="#000000" font-family="sans-serif" font-size="12" font-weight="bold" lengthAdjust="spacing" textLength="114" x="399.5" y="20.1387">planet_osm_rels</text><line style="stroke:#383838;stroke-width:1.0;" x1="392.5" x2="520.5" y1="24.9688" y2="24.9688"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="8" x="417" y="36.251">id</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="34" x="454.5" y="36.251">BIGINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="449.5" x2="449.5" y1="24.9688" y2="40.6094"/><line style="stroke:#383838;stroke-width:1.0;" x1="392.5" x2="520.5" y1="40.6094" y2="40.6094"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="25" x="408.5" y="51.8916">parts</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="42" x="454.5" y="51.8916">BIGINT[]</text><line style="stroke:#383838;stroke-width:1.0;" x1="449.5" x2="449.5" y1="40.6094" y2="56.25"/><line style="stroke:#383838;stroke-width:1.0;" x1="392.5" x2="520.5" y1="56.25" y2="56.25"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="47" x="397.5" y="67.5322">members</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="31" x="454.5" y="67.5322">TEXT[]</text><line style="stroke:#383838;stroke-width:1.0;" x1="449.5" x2="449.5" y1="56.25" y2="71.8906"/><line style="stroke:#383838;stroke-width:1.0;" x1="392.5" x2="520.5" y1="71.8906" y2="71.8906"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="21" x="410.5" y="83.1729">tags</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="31" x="454.5" y="83.1729">TEXT[]</text><line style="stroke:#383838;stroke-width:1.0;" x1="449.5" x2="449.5" y1="71.8906" y2="87.5313"/><line style="stroke:#383838;stroke-width:1.0;" x1="392.5" x2="520.5" y1="87.5313" y2="87.5313"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="39" x="401.5" y="98.8135">way_off</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="51" x="454.5" y="98.8135">SMALLINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="449.5" x2="449.5" y1="87.5313" y2="103.1719"/><line style="stroke:#383838;stroke-width:1.0;" x1="392.5" x2="520.5" y1="103.1719" y2="103.1719"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="31" x="405.5" y="114.4541">rel_off</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="51" x="454.5" y="114.4541">SMALLINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="449.5" x2="449.5" y1="103.1719" y2="118.8125"/><rect fill="#F8F8F8" filter="url(#fofrw86h3kqrc)" height="158.7344" style="stroke:#383838;stroke-width:1.5;" width="135" x="205" y="182"/><text fill="#000000" font-family="sans-serif" font-size="12" font-weight="bold" lengthAdjust="spacing" textLength="38" x="253.5" y="195.1387">place</text><line style="stroke:#383838;stroke-width:1.0;" x1="205" x2="340" y1="199.9688" y2="199.9688"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="48" x="214.5" y="211.251">osm_type</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="44" x="277" y="211.251">CHAR(1)</text><line style="stroke:#383838;stroke-width:1.0;" x1="272" x2="272" y1="199.9688" y2="215.6094"/><line style="stroke:#383838;stroke-width:1.0;" x1="205" x2="340" y1="215.6094" y2="215.6094"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="34" x="221.5" y="226.8916">osm_id</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="34" x="277" y="226.8916">BIGINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="272" x2="272" y1="215.6094" y2="231.25"/><line style="stroke:#383838;stroke-width:1.0;" x1="205" x2="340" y1="231.25" y2="231.25"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="23" x="227" y="242.5322">class</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="23" x="277" y="242.5322">TEXT</text><line style="stroke:#383838;stroke-width:1.0;" x1="272" x2="272" y1="231.25" y2="246.8906"/><line style="stroke:#383838;stroke-width:1.0;" x1="205" x2="340" y1="246.8906" y2="246.8906"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="22" x="227.5" y="258.1729">type</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="23" x="277" y="258.1729">TEXT</text><line style="stroke:#383838;stroke-width:1.0;" x1="272" x2="272" y1="246.8906" y2="262.5313"/><line style="stroke:#383838;stroke-width:1.0;" x1="205" x2="340" y1="262.5313" y2="262.5313"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="28" x="224.5" y="273.8135">name</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="42" x="277" y="273.8135">HSTORE</text><line style="stroke:#383838;stroke-width:1.0;" x1="272" x2="272" y1="262.5313" y2="278.1719"/><line style="stroke:#383838;stroke-width:1.0;" x1="205" x2="340" y1="278.1719" y2="278.1719"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="38" x="219.5" y="289.4541">address</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="42" x="277" y="289.4541">HSTORE</text><line style="stroke:#383838;stroke-width:1.0;" x1="272" x2="272" y1="278.1719" y2="293.8125"/><line style="stroke:#383838;stroke-width:1.0;" x1="205" x2="340" y1="293.8125" y2="293.8125"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="47" x="215" y="305.0947">extratags</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="42" x="277" y="305.0947">HSTORE</text><line style="stroke:#383838;stroke-width:1.0;" x1="272" x2="272" y1="293.8125" y2="309.4531"/><line style="stroke:#383838;stroke-width:1.0;" x1="205" x2="340" y1="309.4531" y2="309.4531"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="57" x="210" y="320.7354">admin_level</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="51" x="277" y="320.7354">SMALLINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="272" x2="272" y1="309.4531" y2="325.0938"/><line style="stroke:#383838;stroke-width:1.0;" x1="205" x2="340" y1="325.0938" y2="325.0938"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="48" x="214.5" y="336.376">geometry</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="58" x="277" y="336.376">GEOMETRY</text><line style="stroke:#383838;stroke-width:1.0;" x1="272" x2="272" y1="325.0938" y2="340.7344"/><!--MD5=[cfd242390168b76ecd29e738a0804d67]
+link planet_osm_nodes to planet_osm_ways--><!--MD5=[fa5350d6785809323ef22057335ae1c7]
+reverse link planet_osm_nodes to planet_osm_ways--><path codeLine="41" d="M153.5,53.5 C176.41,53.5 179.59,69.5 202.5,69.5 " fill="none" id="planet_osm_nodes-backto-planet_osm_ways" style="stroke:#383838;stroke-width:1.0;"/><polygon fill="#383838" points="153.5,53.5,162.5,57.5,158.5,53.5,162.5,49.5,153.5,53.5" style="stroke:#383838;stroke-width:1.0;"/><!--MD5=[fb2ee53a59aef357360ab5aad89040fd]
+link planet_osm_ways to planet_osm_rels--><!--MD5=[09a44a38c707cfce4bf3674282185755]
+link planet_osm_ways to place--><!--MD5=[ab53e24c49396b9d4317735d0a875517]
+@startuml\r
+skinparam monochrome true\r
+skinparam ObjectFontStyle bold\r
+\r
+map planet_osm_nodes #eee {\r
+ id => BIGINT\r
+ lat => INT\r
+ lon => INT\r
+}\r
+\r
+map planet_osm_ways #eee {\r
+ id => BIGINT\r
+ nodes => BIGINT[]\r
+ tags => TEXT[]\r
+}\r
+\r
+map planet_osm_rels #eee {\r
+ id => BIGINT\r
+ parts => BIGINT[]\r
+ members => TEXT[]\r
+ tags => TEXT[]\r
+ way_off => SMALLINT\r
+ rel_off => SMALLINT\r
+}\r
+\r
+map place {\r
+ osm_type => CHAR(1)\r
+ osm_id => BIGINT\r
+ class => TEXT\r
+ type => TEXT\r
+ name => HSTORE\r
+ address => HSTORE\r
+ extratags => HSTORE\r
+ admin_level => SMALLINT\r
+ geometry => GEOMETRY\r
+}\r
+\r
+planet_osm_nodes -[hidden]> planet_osm_ways\r
+planet_osm_ways -[hidden]> planet_osm_rels\r
+planet_osm_ways -[hidden]-> place\r
+\r
+planet_osm_nodes::id <- planet_osm_ways::nodes\r
+\r
+@enduml\r
+
+PlantUML version 1.2021.12(Tue Oct 05 18:01:58 CEST 2021)
+(GPL source distribution)
+Java Runtime: OpenJDK Runtime Environment
+JVM: OpenJDK 64-Bit Server VM
+Default Encoding: UTF-8
+Language: en
+Country: US
+--></g></svg>
\ No newline at end of file
--- /dev/null
+@startuml
+skinparam monochrome true
+skinparam ObjectFontStyle bold
+
+left to right direction
+
+map placex {
+ place_id => BIGINT
+ osm_type => CHAR(1)
+ osm_id => BIGINT
+ class => TEXT
+ type => TEXT
+ name => HSTORE
+ address => HSTORE
+ extratags => HSTORE
+ admin_level => SMALLINT
+ partition => SMALLINT
+ geometry_sector => INT
+ parent_place_id => BIGINT
+ linked_place_id => BIGINT
+ importance => DOUBLE
+ rank_search => SMALLINT
+ rank_address => SMALLINT
+ wikipedia => TEXT
+ country_code => VARCHAR(2)
+ housenumber => TEXT
+ postcode => TEXT
+ indexed_status => SMALLINT
+ indexed_date => TIMESTAMP
+ centroid => GEOMETRY
+ geometry => GEOMETRY
+}
+
+map search_name {
+ place_id => BIGINT
+ importance => DOUBLE
+ search_rank => SMALLINT
+ address_rank => SMALLINT
+ name_vector => INT[]
+ nameaddress_vector => INT[]
+ country_code => VARCHAR(2)
+ centroid => GEOMETRY
+}
+
+map word {
+ word_id => INT
+ word_token => TEXT
+ ... =>
+}
+
+map location_property_osmline {
+ place_id => BIGINT
+ osm_id => BIGINT
+ startnumber => INT
+ endnumber => INT
+ interpolationtype => TEXT
+ address => HSTORE
+ partition => SMALLINT
+ geometry_sector => INT
+ parent_place_id => BIGINT
+ country_code => VARCHAR(2)
+ postcode => text
+ indexed_status => SMALLINT
+ indexed_date => TIMESTAMP
+ linegeo => GEOMETRY
+}
+
+map place_addressline {
+ place_id => BIGINT
+ address_place_id => BIGINT
+ distance => DOUBLE
+ cached_rank_address => SMALLINT
+ fromarea => BOOLEAN
+ isaddress => BOOLEAN
+}
+
+map location_postcode {
+ place_id => BIGINT
+ postcode => TEXT
+ parent_place_id => BIGINT
+ rank_search => SMALLINT
+ rank_address => SMALLINT
+ indexed_status => SMALLINT
+ indexed_date => TIMESTAMP
+ geometry => GEOMETRY
+}
+
+placex::place_id <-- search_name::place_id
+placex::place_id <-- place_addressline::place_id
+placex::place_id <-- place_addressline::address_place_id
+
+search_name::name_vector --> word::word_id
+search_name::nameaddress_vector --> word::word_id
+
+place_addressline -[hidden]> location_property_osmline
+search_name -[hidden]> place_addressline
+location_property_osmline -[hidden]-> location_postcode
+
+@enduml
--- /dev/null
+<?xml version="1.0" encoding="UTF-8" standalone="no"?><svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" contentScriptType="application/ecmascript" contentStyleType="text/css" height="594px" preserveAspectRatio="none" style="width:695px;height:594px;background:#FFFFFF;" version="1.1" viewBox="0 0 695 594" width="695px" zoomAndPan="magnify"><defs><filter height="300%" id="f1abmn4sk1koxw" width="300%" x="-1" y="-1"><feGaussianBlur result="blurOut" stdDeviation="2.0"/><feColorMatrix in="blurOut" result="blurOut2" type="matrix" values="0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 .4 0"/><feOffset dx="4.0" dy="4.0" in="blurOut2" result="blurOut3"/><feBlend in="SourceGraphic" in2="blurOut3" mode="normal"/></filter></defs><g><rect fill="#F8F8F8" filter="url(#f1abmn4sk1koxw)" height="393.3438" style="stroke:#383838;stroke-width:1.5;" width="168" x="7" y="187"/><text fill="#000000" font-family="sans-serif" font-size="12" font-weight="bold" lengthAdjust="spacing" textLength="45" x="68.5" y="200.1387">placex</text><line style="stroke:#383838;stroke-width:1.0;" x1="7" x2="175" y1="204.9688" y2="204.9688"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="38" x="34.5" y="216.251">place_id</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="34" x="105" y="216.251">BIGINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="100" x2="100" y1="204.9688" y2="220.6094"/><line style="stroke:#383838;stroke-width:1.0;" x1="7" x2="175" y1="220.6094" y2="220.6094"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="48" x="29.5" y="231.8916">osm_type</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="44" x="105" y="231.8916">CHAR(1)</text><line style="stroke:#383838;stroke-width:1.0;" x1="100" x2="100" y1="220.6094" y2="236.25"/><line style="stroke:#383838;stroke-width:1.0;" x1="7" x2="175" y1="236.25" y2="236.25"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="34" x="36.5" y="247.5322">osm_id</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="34" x="105" y="247.5322">BIGINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="100" x2="100" y1="236.25" y2="251.8906"/><line style="stroke:#383838;stroke-width:1.0;" x1="7" x2="175" y1="251.8906" y2="251.8906"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="23" x="42" y="263.1729">class</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="23" x="105" y="263.1729">TEXT</text><line style="stroke:#383838;stroke-width:1.0;" x1="100" x2="100" y1="251.8906" y2="267.5313"/><line style="stroke:#383838;stroke-width:1.0;" x1="7" x2="175" y1="267.5313" y2="267.5313"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="22" x="42.5" y="278.8135">type</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="23" x="105" y="278.8135">TEXT</text><line style="stroke:#383838;stroke-width:1.0;" x1="100" x2="100" y1="267.5313" y2="283.1719"/><line style="stroke:#383838;stroke-width:1.0;" x1="7" x2="175" y1="283.1719" y2="283.1719"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="28" x="39.5" y="294.4541">name</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="42" x="105" y="294.4541">HSTORE</text><line style="stroke:#383838;stroke-width:1.0;" x1="100" x2="100" y1="283.1719" y2="298.8125"/><line style="stroke:#383838;stroke-width:1.0;" x1="7" x2="175" y1="298.8125" y2="298.8125"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="38" x="34.5" y="310.0947">address</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="42" x="105" y="310.0947">HSTORE</text><line style="stroke:#383838;stroke-width:1.0;" x1="100" x2="100" y1="298.8125" y2="314.4531"/><line style="stroke:#383838;stroke-width:1.0;" x1="7" x2="175" y1="314.4531" y2="314.4531"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="47" x="30" y="325.7354">extratags</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="42" x="105" y="325.7354">HSTORE</text><line style="stroke:#383838;stroke-width:1.0;" x1="100" x2="100" y1="314.4531" y2="330.0938"/><line style="stroke:#383838;stroke-width:1.0;" x1="7" x2="175" y1="330.0938" y2="330.0938"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="57" x="25" y="341.376">admin_level</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="51" x="105" y="341.376">SMALLINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="100" x2="100" y1="330.0938" y2="345.7344"/><line style="stroke:#383838;stroke-width:1.0;" x1="7" x2="175" y1="345.7344" y2="345.7344"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="40" x="33.5" y="357.0166">partition</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="51" x="105" y="357.0166">SMALLINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="100" x2="100" y1="345.7344" y2="361.375"/><line style="stroke:#383838;stroke-width:1.0;" x1="7" x2="175" y1="361.375" y2="361.375"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="83" x="12" y="372.6572">geometry_sector</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="16" x="105" y="372.6572">INT</text><line style="stroke:#383838;stroke-width:1.0;" x1="100" x2="100" y1="361.375" y2="377.0156"/><line style="stroke:#383838;stroke-width:1.0;" x1="7" x2="175" y1="377.0156" y2="377.0156"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="75" x="16" y="388.2979">parent_place_id</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="34" x="105" y="388.2979">BIGINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="100" x2="100" y1="377.0156" y2="392.6563"/><line style="stroke:#383838;stroke-width:1.0;" x1="7" x2="175" y1="392.6563" y2="392.6563"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="70" x="18.5" y="403.9385">linked_place_id</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="34" x="105" y="403.9385">BIGINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="100" x2="100" y1="392.6563" y2="408.2969"/><line style="stroke:#383838;stroke-width:1.0;" x1="7" x2="175" y1="408.2969" y2="408.2969"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="55" x="26" y="419.5791">importance</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="44" x="105" y="419.5791">DOUBLE</text><line style="stroke:#383838;stroke-width:1.0;" x1="100" x2="100" y1="408.2969" y2="423.9375"/><line style="stroke:#383838;stroke-width:1.0;" x1="7" x2="175" y1="423.9375" y2="423.9375"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="58" x="24.5" y="435.2197">rank_search</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="51" x="105" y="435.2197">SMALLINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="100" x2="100" y1="423.9375" y2="439.5781"/><line style="stroke:#383838;stroke-width:1.0;" x1="7" x2="175" y1="439.5781" y2="439.5781"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="64" x="21.5" y="450.8604">rank_address</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="51" x="105" y="450.8604">SMALLINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="100" x2="100" y1="439.5781" y2="455.2188"/><line style="stroke:#383838;stroke-width:1.0;" x1="7" x2="175" y1="455.2188" y2="455.2188"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="43" x="32" y="466.501">wikipedia</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="23" x="105" y="466.501">TEXT</text><line style="stroke:#383838;stroke-width:1.0;" x1="100" x2="100" y1="455.2188" y2="470.8594"/><line style="stroke:#383838;stroke-width:1.0;" x1="7" x2="175" y1="470.8594" y2="470.8594"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="65" x="21" y="482.1416">country_code</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="65" x="105" y="482.1416">VARCHAR(2)</text><line style="stroke:#383838;stroke-width:1.0;" x1="100" x2="100" y1="470.8594" y2="486.5"/><line style="stroke:#383838;stroke-width:1.0;" x1="7" x2="175" y1="486.5" y2="486.5"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="67" x="20" y="497.7822">housenumber</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="23" x="105" y="497.7822">TEXT</text><line style="stroke:#383838;stroke-width:1.0;" x1="100" x2="100" y1="486.5" y2="502.1406"/><line style="stroke:#383838;stroke-width:1.0;" x1="7" x2="175" y1="502.1406" y2="502.1406"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="44" x="31.5" y="513.4229">postcode</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="23" x="105" y="513.4229">TEXT</text><line style="stroke:#383838;stroke-width:1.0;" x1="100" x2="100" y1="502.1406" y2="517.7813"/><line style="stroke:#383838;stroke-width:1.0;" x1="7" x2="175" y1="517.7813" y2="517.7813"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="73" x="17" y="529.0635">indexed_status</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="51" x="105" y="529.0635">SMALLINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="100" x2="100" y1="517.7813" y2="533.4219"/><line style="stroke:#383838;stroke-width:1.0;" x1="7" x2="175" y1="533.4219" y2="533.4219"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="65" x="21" y="544.7041">indexed_date</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="59" x="105" y="544.7041">TIMESTAMP</text><line style="stroke:#383838;stroke-width:1.0;" x1="100" x2="100" y1="533.4219" y2="549.0625"/><line style="stroke:#383838;stroke-width:1.0;" x1="7" x2="175" y1="549.0625" y2="549.0625"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="39" x="34" y="560.3447">centroid</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="58" x="105" y="560.3447">GEOMETRY</text><line style="stroke:#383838;stroke-width:1.0;" x1="100" x2="100" y1="549.0625" y2="564.7031"/><line style="stroke:#383838;stroke-width:1.0;" x1="7" x2="175" y1="564.7031" y2="564.7031"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="48" x="29.5" y="575.9854">geometry</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="58" x="105" y="575.9854">GEOMETRY</text><line style="stroke:#383838;stroke-width:1.0;" x1="100" x2="100" y1="564.7031" y2="580.3438"/><rect fill="#F8F8F8" filter="url(#f1abmn4sk1koxw)" height="143.0938" style="stroke:#383838;stroke-width:1.5;" width="187" x="257.5" y="7"/><text fill="#000000" font-family="sans-serif" font-size="12" font-weight="bold" lengthAdjust="spacing" textLength="93" x="304.5" y="20.1387">search_name</text><line style="stroke:#383838;stroke-width:1.0;" x1="257.5" x2="444.5" y1="24.9688" y2="24.9688"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="38" x="294.5" y="36.251">place_id</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="34" x="374.5" y="36.251">BIGINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="369.5" x2="369.5" y1="24.9688" y2="40.6094"/><line style="stroke:#383838;stroke-width:1.0;" x1="257.5" x2="444.5" y1="40.6094" y2="40.6094"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="55" x="286" y="51.8916">importance</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="44" x="374.5" y="51.8916">DOUBLE</text><line style="stroke:#383838;stroke-width:1.0;" x1="369.5" x2="369.5" y1="40.6094" y2="56.25"/><line style="stroke:#383838;stroke-width:1.0;" x1="257.5" x2="444.5" y1="56.25" y2="56.25"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="58" x="284.5" y="67.5322">search_rank</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="51" x="374.5" y="67.5322">SMALLINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="369.5" x2="369.5" y1="56.25" y2="71.8906"/><line style="stroke:#383838;stroke-width:1.0;" x1="257.5" x2="444.5" y1="71.8906" y2="71.8906"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="64" x="281.5" y="83.1729">address_rank</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="51" x="374.5" y="83.1729">SMALLINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="369.5" x2="369.5" y1="71.8906" y2="87.5313"/><line style="stroke:#383838;stroke-width:1.0;" x1="257.5" x2="444.5" y1="87.5313" y2="87.5313"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="64" x="281.5" y="98.8135">name_vector</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="24" x="374.5" y="98.8135">INT[]</text><line style="stroke:#383838;stroke-width:1.0;" x1="369.5" x2="369.5" y1="87.5313" y2="103.1719"/><line style="stroke:#383838;stroke-width:1.0;" x1="257.5" x2="444.5" y1="103.1719" y2="103.1719"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="102" x="262.5" y="114.4541">nameaddress_vector</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="24" x="374.5" y="114.4541">INT[]</text><line style="stroke:#383838;stroke-width:1.0;" x1="369.5" x2="369.5" y1="103.1719" y2="118.8125"/><line style="stroke:#383838;stroke-width:1.0;" x1="257.5" x2="444.5" y1="118.8125" y2="118.8125"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="65" x="281" y="130.0947">country_code</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="65" x="374.5" y="130.0947">VARCHAR(2)</text><line style="stroke:#383838;stroke-width:1.0;" x1="369.5" x2="369.5" y1="118.8125" y2="134.4531"/><line style="stroke:#383838;stroke-width:1.0;" x1="257.5" x2="444.5" y1="134.4531" y2="134.4531"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="39" x="294" y="145.7354">centroid</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="58" x="374.5" y="145.7354">GEOMETRY</text><line style="stroke:#383838;stroke-width:1.0;" x1="369.5" x2="369.5" y1="134.4531" y2="150.0938"/><rect fill="#F8F8F8" filter="url(#f1abmn4sk1koxw)" height="64.8906" style="stroke:#383838;stroke-width:1.5;" width="99" x="554.5" y="76.5"/><text fill="#000000" font-family="sans-serif" font-size="12" font-weight="bold" lengthAdjust="spacing" textLength="36" x="586" y="89.6387">word</text><line style="stroke:#383838;stroke-width:1.0;" x1="554.5" x2="653.5" y1="94.4688" y2="94.4688"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="37" x="569" y="105.751">word_id</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="16" x="625.5" y="105.751">INT</text><line style="stroke:#383838;stroke-width:1.0;" x1="620.5" x2="620.5" y1="94.4688" y2="110.1094"/><line style="stroke:#383838;stroke-width:1.0;" x1="554.5" x2="653.5" y1="110.1094" y2="110.1094"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="56" x="559.5" y="121.3916">word_token</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="23" x="625.5" y="121.3916">TEXT</text><line style="stroke:#383838;stroke-width:1.0;" x1="620.5" x2="620.5" y1="110.1094" y2="125.75"/><line style="stroke:#383838;stroke-width:1.0;" x1="554.5" x2="653.5" y1="125.75" y2="125.75"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="9" x="583" y="137.0322">...</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="0" x="628.5" y="137.0322"/><line style="stroke:#383838;stroke-width:1.0;" x1="620.5" x2="620.5" y1="125.75" y2="141.3906"/><rect fill="#F8F8F8" filter="url(#f1abmn4sk1koxw)" height="236.9375" style="stroke:#383838;stroke-width:1.5;" width="200" x="251" y="337"/><text fill="#000000" font-family="sans-serif" font-size="12" font-weight="bold" lengthAdjust="spacing" textLength="186" x="258" y="350.1387">location_property_osmline</text><line style="stroke:#383838;stroke-width:1.0;" x1="251" x2="451" y1="354.9688" y2="354.9688"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="38" x="278.5" y="366.251">place_id</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="34" x="349" y="366.251">BIGINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="344" x2="344" y1="354.9688" y2="370.6094"/><line style="stroke:#383838;stroke-width:1.0;" x1="251" x2="451" y1="370.6094" y2="370.6094"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="34" x="280.5" y="381.8916">osm_id</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="34" x="349" y="381.8916">BIGINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="344" x2="344" y1="370.6094" y2="386.25"/><line style="stroke:#383838;stroke-width:1.0;" x1="251" x2="451" y1="386.25" y2="386.25"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="61" x="267" y="397.5322">startnumber</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="16" x="349" y="397.5322">INT</text><line style="stroke:#383838;stroke-width:1.0;" x1="344" x2="344" y1="386.25" y2="401.8906"/><line style="stroke:#383838;stroke-width:1.0;" x1="251" x2="451" y1="401.8906" y2="401.8906"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="56" x="269.5" y="413.1729">endnumber</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="16" x="349" y="413.1729">INT</text><line style="stroke:#383838;stroke-width:1.0;" x1="344" x2="344" y1="401.8906" y2="417.5313"/><line style="stroke:#383838;stroke-width:1.0;" x1="251" x2="451" y1="417.5313" y2="417.5313"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="82" x="256.5" y="428.8135">interpolationtype</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="23" x="349" y="428.8135">TEXT</text><line style="stroke:#383838;stroke-width:1.0;" x1="344" x2="344" y1="417.5313" y2="433.1719"/><line style="stroke:#383838;stroke-width:1.0;" x1="251" x2="451" y1="433.1719" y2="433.1719"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="38" x="278.5" y="444.4541">address</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="42" x="349" y="444.4541">HSTORE</text><line style="stroke:#383838;stroke-width:1.0;" x1="344" x2="344" y1="433.1719" y2="448.8125"/><line style="stroke:#383838;stroke-width:1.0;" x1="251" x2="451" y1="448.8125" y2="448.8125"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="40" x="277.5" y="460.0947">partition</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="51" x="349" y="460.0947">SMALLINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="344" x2="344" y1="448.8125" y2="464.4531"/><line style="stroke:#383838;stroke-width:1.0;" x1="251" x2="451" y1="464.4531" y2="464.4531"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="83" x="256" y="475.7354">geometry_sector</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="16" x="349" y="475.7354">INT</text><line style="stroke:#383838;stroke-width:1.0;" x1="344" x2="344" y1="464.4531" y2="480.0938"/><line style="stroke:#383838;stroke-width:1.0;" x1="251" x2="451" y1="480.0938" y2="480.0938"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="75" x="260" y="491.376">parent_place_id</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="34" x="349" y="491.376">BIGINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="344" x2="344" y1="480.0938" y2="495.7344"/><line style="stroke:#383838;stroke-width:1.0;" x1="251" x2="451" y1="495.7344" y2="495.7344"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="65" x="265" y="507.0166">country_code</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="65" x="349" y="507.0166">VARCHAR(2)</text><line style="stroke:#383838;stroke-width:1.0;" x1="344" x2="344" y1="495.7344" y2="511.375"/><line style="stroke:#383838;stroke-width:1.0;" x1="251" x2="451" y1="511.375" y2="511.375"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="44" x="275.5" y="522.6572">postcode</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="20" x="349" y="522.6572">text</text><line style="stroke:#383838;stroke-width:1.0;" x1="344" x2="344" y1="511.375" y2="527.0156"/><line style="stroke:#383838;stroke-width:1.0;" x1="251" x2="451" y1="527.0156" y2="527.0156"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="73" x="261" y="538.2979">indexed_status</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="51" x="349" y="538.2979">SMALLINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="344" x2="344" y1="527.0156" y2="542.6563"/><line style="stroke:#383838;stroke-width:1.0;" x1="251" x2="451" y1="542.6563" y2="542.6563"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="65" x="265" y="553.9385">indexed_date</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="59" x="349" y="553.9385">TIMESTAMP</text><line style="stroke:#383838;stroke-width:1.0;" x1="344" x2="344" y1="542.6563" y2="558.2969"/><line style="stroke:#383838;stroke-width:1.0;" x1="251" x2="451" y1="558.2969" y2="558.2969"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="34" x="280.5" y="569.5791">linegeo</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="58" x="349" y="569.5791">GEOMETRY</text><line style="stroke:#383838;stroke-width:1.0;" x1="344" x2="344" y1="558.2969" y2="573.9375"/><rect fill="#F8F8F8" filter="url(#f1abmn4sk1koxw)" height="111.8125" style="stroke:#383838;stroke-width:1.5;" width="174" x="264" y="187"/><text fill="#000000" font-family="sans-serif" font-size="12" font-weight="bold" lengthAdjust="spacing" textLength="128" x="287" y="200.1387">place_addressline</text><line style="stroke:#383838;stroke-width:1.0;" x1="264" x2="438" y1="204.9688" y2="204.9688"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="38" x="301.5" y="216.251">place_id</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="34" x="382" y="216.251">BIGINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="377" x2="377" y1="204.9688" y2="220.6094"/><line style="stroke:#383838;stroke-width:1.0;" x1="264" x2="438" y1="220.6094" y2="220.6094"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="81" x="280" y="231.8916">address_place_id</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="34" x="382" y="231.8916">BIGINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="377" x2="377" y1="220.6094" y2="236.25"/><line style="stroke:#383838;stroke-width:1.0;" x1="264" x2="438" y1="236.25" y2="236.25"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="40" x="300.5" y="247.5322">distance</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="44" x="382" y="247.5322">DOUBLE</text><line style="stroke:#383838;stroke-width:1.0;" x1="377" x2="377" y1="236.25" y2="251.8906"/><line style="stroke:#383838;stroke-width:1.0;" x1="264" x2="438" y1="251.8906" y2="251.8906"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="103" x="269" y="263.1729">cached_rank_address</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="51" x="382" y="263.1729">SMALLINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="377" x2="377" y1="251.8906" y2="267.5313"/><line style="stroke:#383838;stroke-width:1.0;" x1="264" x2="438" y1="267.5313" y2="267.5313"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="46" x="297.5" y="278.8135">fromarea</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="51" x="382" y="278.8135">BOOLEAN</text><line style="stroke:#383838;stroke-width:1.0;" x1="377" x2="377" y1="267.5313" y2="283.1719"/><line style="stroke:#383838;stroke-width:1.0;" x1="264" x2="438" y1="283.1719" y2="283.1719"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="45" x="298" y="294.4541">isaddress</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="51" x="382" y="294.4541">BOOLEAN</text><line style="stroke:#383838;stroke-width:1.0;" x1="377" x2="377" y1="283.1719" y2="298.8125"/><rect fill="#F8F8F8" filter="url(#f1abmn4sk1koxw)" height="143.0938" style="stroke:#383838;stroke-width:1.5;" width="154" x="527" y="382"/><text fill="#000000" font-family="sans-serif" font-size="12" font-weight="bold" lengthAdjust="spacing" textLength="129" x="539.5" y="395.1387">location_postcode</text><line style="stroke:#383838;stroke-width:1.0;" x1="527" x2="681" y1="399.9688" y2="399.9688"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="38" x="550.5" y="411.251">place_id</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="34" x="617" y="411.251">BIGINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="612" x2="612" y1="399.9688" y2="415.6094"/><line style="stroke:#383838;stroke-width:1.0;" x1="527" x2="681" y1="415.6094" y2="415.6094"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="44" x="547.5" y="426.8916">postcode</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="23" x="617" y="426.8916">TEXT</text><line style="stroke:#383838;stroke-width:1.0;" x1="612" x2="612" y1="415.6094" y2="431.25"/><line style="stroke:#383838;stroke-width:1.0;" x1="527" x2="681" y1="431.25" y2="431.25"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="75" x="532" y="442.5322">parent_place_id</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="34" x="617" y="442.5322">BIGINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="612" x2="612" y1="431.25" y2="446.8906"/><line style="stroke:#383838;stroke-width:1.0;" x1="527" x2="681" y1="446.8906" y2="446.8906"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="58" x="540.5" y="458.1729">rank_search</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="51" x="617" y="458.1729">SMALLINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="612" x2="612" y1="446.8906" y2="462.5313"/><line style="stroke:#383838;stroke-width:1.0;" x1="527" x2="681" y1="462.5313" y2="462.5313"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="64" x="537.5" y="473.8135">rank_address</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="51" x="617" y="473.8135">SMALLINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="612" x2="612" y1="462.5313" y2="478.1719"/><line style="stroke:#383838;stroke-width:1.0;" x1="527" x2="681" y1="478.1719" y2="478.1719"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="73" x="533" y="489.4541">indexed_status</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="51" x="617" y="489.4541">SMALLINT</text><line style="stroke:#383838;stroke-width:1.0;" x1="612" x2="612" y1="478.1719" y2="493.8125"/><line style="stroke:#383838;stroke-width:1.0;" x1="527" x2="681" y1="493.8125" y2="493.8125"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="65" x="537" y="505.0947">indexed_date</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="59" x="617" y="505.0947">TIMESTAMP</text><line style="stroke:#383838;stroke-width:1.0;" x1="612" x2="612" y1="493.8125" y2="509.4531"/><line style="stroke:#383838;stroke-width:1.0;" x1="527" x2="681" y1="509.4531" y2="509.4531"/><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="48" x="545.5" y="520.7354">geometry</text><text fill="#000000" font-family="sans-serif" font-size="10" lengthAdjust="spacing" textLength="58" x="617" y="520.7354">GEOMETRY</text><line style="stroke:#383838;stroke-width:1.0;" x1="612" x2="612" y1="509.4531" y2="525.0938"/><!--MD5=[2b322b975a43d887f4b5130fa1514430]
+reverse link placex to search_name--><path codeLine="87" d="M181.41,211.25 C259.75,203.85 171.16,31.5 257,31.5 " fill="none" id="placex-backto-search_name" style="stroke:#383838;stroke-width:1.0;"/><polygon fill="#383838" points="176,211.5,185.163,215.111,180.9954,211.2859,184.8205,207.1183,176,211.5" style="stroke:#383838;stroke-width:1.0;"/><!--MD5=[9225071ced1fa56d3be038aebaf7c111]
+reverse link placex to place_addressline--><path codeLine="88" d="M181.25,211.5 C215.64,211.5 226.15,211.5 263,211.5 " fill="none" id="placex-backto-place_addressline" style="stroke:#383838;stroke-width:1.0;"/><polygon fill="#383838" points="176,211.5,185,215.5,181,211.5,185,207.5,176,211.5" style="stroke:#383838;stroke-width:1.0;"/><!--MD5=[9225071ced1fa56d3be038aebaf7c111]
+reverse link placex to place_addressline--><path codeLine="89" d="M181.32,211.6 C216.1,212.87 225.6,226.5 263,226.5 " fill="none" id="placex-backto-place_addressline-1" style="stroke:#383838;stroke-width:1.0;"/><polygon fill="#383838" points="176,211.5,184.9301,215.6537,180.9993,211.5857,185.0672,207.6549,176,211.5" style="stroke:#383838;stroke-width:1.0;"/><!--MD5=[bd411bc1e40cdc9c35ac95f86ac574be]
+link search_name to word--><path codeLine="91" d="M446,92.5 C492.35,92.5 504.95,99.92 548.79,100.47 " fill="none" id="search_name-to-word" style="stroke:#383838;stroke-width:1.0;"/><polygon fill="#383838" points="554,100.5,545.023,96.4486,549.0001,100.4714,544.9773,104.4485,554,100.5" style="stroke:#383838;stroke-width:1.0;"/><!--MD5=[bd411bc1e40cdc9c35ac95f86ac574be]
+link search_name to word--><path codeLine="92" d="M446,107.5 C492.32,107.5 504.97,101.01 548.79,100.53 " fill="none" id="search_name-to-word-1" style="stroke:#383838;stroke-width:1.0;"/><polygon fill="#383838" points="554,100.5,544.9773,96.5515,549.0001,100.5286,545.023,104.5514,554,100.5" style="stroke:#383838;stroke-width:1.0;"/><!--MD5=[2026b97b8eebe17816bba28c4ad4b669]
+link place_addressline to location_property_osmline--><!--MD5=[a9348f7e9012ac5ef48544c7a8bc4c7c]
+link search_name to place_addressline--><!--MD5=[28ade17d5fbc4e5a643b9e72ecbc3cb5]
+link location_property_osmline to location_postcode--><!--MD5=[3778d5ad5451b5ba12005c60410924eb]
+@startuml\r
+skinparam monochrome true\r
+skinparam ObjectFontStyle bold\r
+\r
+left to right direction\r
+\r
+map placex {\r
+ place_id => BIGINT\r
+ osm_type => CHAR(1)\r
+ osm_id => BIGINT\r
+ class => TEXT\r
+ type => TEXT\r
+ name => HSTORE\r
+ address => HSTORE\r
+ extratags => HSTORE\r
+ admin_level => SMALLINT\r
+ partition => SMALLINT\r
+ geometry_sector => INT\r
+ parent_place_id => BIGINT\r
+ linked_place_id => BIGINT\r
+ importance => DOUBLE\r
+ rank_search => SMALLINT\r
+ rank_address => SMALLINT\r
+ wikipedia => TEXT\r
+ country_code => VARCHAR(2)\r
+ housenumber => TEXT\r
+ postcode => TEXT\r
+ indexed_status => SMALLINT\r
+ indexed_date => TIMESTAMP\r
+ centroid => GEOMETRY\r
+ geometry => GEOMETRY\r
+}\r
+\r
+map search_name {\r
+ place_id => BIGINT\r
+ importance => DOUBLE\r
+ search_rank => SMALLINT\r
+ address_rank => SMALLINT\r
+ name_vector => INT[]\r
+ nameaddress_vector => INT[]\r
+ country_code => VARCHAR(2)\r
+ centroid => GEOMETRY\r
+}\r
+\r
+map word {\r
+ word_id => INT\r
+ word_token => TEXT\r
+ ... =>\r
+}\r
+\r
+map location_property_osmline {\r
+ place_id => BIGINT\r
+ osm_id => BIGINT\r
+ startnumber => INT\r
+ endnumber => INT\r
+ interpolationtype => TEXT\r
+ address => HSTORE\r
+ partition => SMALLINT\r
+ geometry_sector => INT\r
+ parent_place_id => BIGINT\r
+ country_code => VARCHAR(2)\r
+ postcode => text\r
+ indexed_status => SMALLINT\r
+ indexed_date => TIMESTAMP\r
+ linegeo => GEOMETRY\r
+}\r
+\r
+map place_addressline {\r
+ place_id => BIGINT\r
+ address_place_id => BIGINT\r
+ distance => DOUBLE\r
+ cached_rank_address => SMALLINT\r
+ fromarea => BOOLEAN\r
+ isaddress => BOOLEAN\r
+}\r
+\r
+map location_postcode {\r
+ place_id => BIGINT\r
+ postcode => TEXT\r
+ parent_place_id => BIGINT\r
+ rank_search => SMALLINT\r
+ rank_address => SMALLINT\r
+ indexed_status => SMALLINT\r
+ indexed_date => TIMESTAMP\r
+ geometry => GEOMETRY\r
+}\r
+\r
+placex::place_id <- - search_name::place_id\r
+placex::place_id <- - place_addressline::place_id\r
+placex::place_id <- - place_addressline::address_place_id\r
+\r
+search_name::name_vector - -> word::word_id\r
+search_name::nameaddress_vector - -> word::word_id\r
+\r
+place_addressline -[hidden]> location_property_osmline\r
+search_name -[hidden]> place_addressline\r
+location_property_osmline -[hidden]-> location_postcode\r
+\r
+@enduml\r
+
+PlantUML version 1.2021.12(Tue Oct 05 18:01:58 CEST 2021)
+(GPL source distribution)
+Java Runtime: OpenJDK Runtime Environment
+JVM: OpenJDK 64-Bit Server VM
+Default Encoding: UTF-8
+Language: en
+Country: US
+--></g></svg>
\ No newline at end of file
- 'External data: US housenumbers from TIGER': 'customize/Tiger.md'
- 'External data: Postcodes': 'customize/Postcodes.md'
- 'Developers Guide':
- - 'Setup for Development' : 'develop/Development-Environment.md'
- 'Architecture Overview' : 'develop/overview.md'
- - 'OSM Data Import' : 'develop/Import.md'
+ - 'Database Layout' : 'develop/Database-Layout.md'
- 'Tokenizers' : 'develop/Tokenizers.md'
+ - 'Setup for Development' : 'develop/Development-Environment.md'
- 'Testing' : 'develop/Testing.md'
- 'External Data Sources': 'develop/data-sources.md'
- 'Appendix':
projects / nominatim.git / commitdiff
