Sarah Hoffmann
32728d6c89
Merge pull request #3693 from lonvia/remove-unused-sql
...
Remove SQL function for address lookup
2025-03-31 17:11:39 +02:00
Sarah Hoffmann
bbadc62371
remove SQL function for address lookup
...
This is now done in Python.
2025-03-31 15:09:40 +02:00
Sarah Hoffmann
3cb183ffb0
add lookup word to variants in word table
2025-03-31 14:52:50 +02:00
Sarah Hoffmann
58ef032a2b
do not write any word counts on initial word insert
2025-03-31 14:52:50 +02:00
Thomas Butz
d86d491f2e
Mark functions as PARALLEL SAFE
2025-03-13 10:53:11 +01:00
Sarah Hoffmann
267e5dac0d
split up MultiPolygons before adding them to large_areas table
2024-12-22 09:15:16 +01:00
Sarah Hoffmann
32d3eb46d5
move geometry split into insertLocationAreaLarge()
...
thus insert only needs to be called once.
2024-12-22 09:15:16 +01:00
Sarah Hoffmann
c8a0dc8af1
more efficient belongs-to-address determination
2024-12-22 09:15:16 +01:00
Sarah Hoffmann
98c1b923fc
remove code only needed for older PostgreSQL/PostGIS versions
2024-11-18 10:11:09 +01:00
Sarah Hoffmann
981b879830
do not rename parameters in existing SQL function
2024-11-04 09:46:20 +01:00
Sarah Hoffmann
7b21354a8a
avoid multiple centroid computations
2024-11-03 22:06:36 +01:00
Sarah Hoffmann
ad50016c49
use line interpolation to create centroid for lines
...
ST_PointOnSurface always returns one of the vertices of a line.
This means that a two-point line will have the centroid at
one of the ends, which is less then ideal.
2024-11-03 22:06:36 +01:00
Sarah Hoffmann
b87d6226fb
remove legacy tokenizer and direct tests
2024-09-21 11:38:08 +02:00
Sarah Hoffmann
0efdd1b9a6
restrict interpolation housenumbers to 0-999999
...
Ensures that the numbers fit into integers.
2024-08-19 20:40:25 +02:00
Sarah Hoffmann
054efc8311
ensure consistent country assignments
...
When OSM data has areas with overlapping countries, use the country
assignments from the pre-defined country grid for tie-breaking.
If that fails, fall back to the country with the smaller partition
number.
2024-08-15 14:26:09 +02:00
Sarah Hoffmann
9659afbade
port code to psycopg3
2024-07-29 08:50:19 +02:00
Sarah Hoffmann
350bb0e1cd
restrict invalidation of child objects on large street features
...
When streets become very large, it is more likely a mapping error.
So ignore such changes.
2024-06-19 14:23:29 +02:00
Sarah Hoffmann
5b02cd22b9
add tests for new importance CSV import
2024-05-16 15:23:54 +02:00
Sarah Hoffmann
60b03d506f
add CSV format for importance import
2024-05-16 15:23:54 +02:00
Sarah Hoffmann
01f0f453dd
drop interpolations when no parent can be found
...
A housenumber without the place it refers to is of only limited use.
2024-05-14 11:35:14 +02:00
Sarah Hoffmann
77631f90fd
reindex postcodes that loose their parents
...
When the parent place of a postcode is deleted, it needs to
be reindexed to get a new parent. Otherwise displaying of
results is broken.
2024-05-04 12:33:26 +02:00
Sarah Hoffmann
d2bf986eae
unlisted place names need to go into the address
...
Housenumbers with unlisted place names should be handled like
any ither housenumbers with missing address terms.
2024-05-02 11:47:35 +02:00
Sarah Hoffmann
dc7cfd1708
look for postcode areas when finding something in the postcode table
2024-03-11 14:48:24 +01:00
Sarah Hoffmann
dd2c794de5
Merge pull request #3350 from lonvia/improve-postcode-handling
...
Improve handling of postcode areas
2024-02-28 18:45:31 +01:00
Sarah Hoffmann
62b7670e0c
for postcodes use rank_search as base rank for finding addresses
...
The rank_address reflects the position in the address which is
usually lower than what one would expect for a postcode area.
2024-02-28 14:40:36 +01:00
Sarah Hoffmann
d7bb449e74
drop lower-rank-ways index after import
...
The index becomes quite big and is only needed during import
because the full geometry import does not exist yet.
2024-02-28 14:35:56 +01:00
Sarah Hoffmann
247065ff6f
Merge pull request #3342 from mtmail/tyops
...
Correct some typos
2024-02-28 14:25:16 +01:00
Sarah Hoffmann
1879cf902c
Merge pull request #3346 from lonvia/reduce-artificial-importance
...
Reduce default importance
2024-02-28 14:21:46 +01:00
Sarah Hoffmann
019a68a4bb
Merge pull request #3345 from lonvia/simplify-large-geometries
...
Simplify very large polygons that are not used in addresses
2024-02-28 12:06:49 +01:00
Sarah Hoffmann
36b1660121
add support for new middle table format of osm2pgsql
...
Functions are adapted according to the format detected from the
osm2pgsql property table.
2024-02-27 18:18:19 +01:00
Sarah Hoffmann
56201feb28
simplify very large polygons non used in addresses
...
Polygons with rank_address = 0 are only used in search and (rarely)
for reverse lookup. Geometries do not need to be precise for that
because topology does not matter. OSM has some very large polygons
of natural features with sizes of more than 10MB. Simplify these
polygons to keep the database and indexes smaller.
2024-02-27 10:16:18 +01:00
Sarah Hoffmann
c6d40d4bf4
reduce importance when computed from search rank
2024-02-27 10:15:54 +01:00
marc tobias
7205491b84
Correct some typos
2024-02-26 18:13:30 +01:00
Sarah Hoffmann
4c19762e33
extratags should become null when empty
...
Removing the artifical entries in the extratags may lead to
an empty hstore. Set it to null in that case.
Fixes #3055 .
2024-02-08 10:21:48 +01:00
Sarah Hoffmann
81eed0680c
recreate word table when refreshing counts
...
The counting touches a large part of the word table, leaving
bloated tables and indexes. Thus recreate the table instead and
swap it in.
2024-02-04 21:35:10 +01:00
Sarah Hoffmann
9627352ee4
search postcodes for highway areas around the area
...
So far the code would only accept postcodes that are inside the area.
Fixes #3304 .
2024-01-26 18:14:11 +01:00
Sarah Hoffmann
af85ad390f
Merge pull request #3273 from lonvia/search-with-sqlite
...
Add forward search capability for SQLite databases
2023-12-12 12:15:22 +01:00
Sarah Hoffmann
c41f2fed21
simplify weigh_search() function
...
Use JSON arrays which can have mixed types and therefore have
a more logical structure than separate arrays. Avoid JSON dicts
because of their verboseness.
2023-12-07 09:31:00 +01:00
Sarah Hoffmann
8c7140d92b
Merge pull request #3108 from mtmail/remove-legacy-wikipedia-tag-syntax
...
These days the OSM wikipedia tab no longer contains URLs
2023-12-07 09:24:32 +01:00
Sarah Hoffmann
383e3ccd25
php frontend: fix on-the-fly lookup of postcode areas
2023-11-15 17:45:12 +01:00
lujoh
06204dfcd8
moved sql function flush_deleted_places() to utils
2023-10-17 18:22:27 -04:00
Sarah Hoffmann
7fcbe13669
move get_addressdata() implementation to Python
...
The pgsql function get_addressdata() does a lookup of a lot of data
that is already available in Python.
2023-09-26 11:21:36 +02:00
Sarah Hoffmann
c5f5ab5363
be more strict about removal from place_to_be_deleted
...
If the type of a place is changed and then the same insert issued
again, the old data will effectively remain in the table.
Fixed #3168 .
2023-08-25 14:22:49 +02:00
Sarah Hoffmann
7c79b07817
fix parameter use for ST_Project
...
Before postgis 3.4 ST_Project required a geography as input and seemed
to have implicitly converted to geography. Since 3.4 geometry input
is supported but leads to a completely different result.
2023-08-20 13:52:03 +02:00
Marc Tobias
f59a072aa6
These days the OSM wikipedia tab no longer contains URLs
2023-07-07 17:36:11 +02:00
Sarah Hoffmann
ce17b0eeca
Merge pull request #3101 from lonvia/custom-geometry-type
...
Improve use of SQLAlchemy statement cache with search queries
2023-07-03 11:03:26 +02:00
Sarah Hoffmann
5135041405
replace CASE construct with plpgsql function
2023-07-01 18:15:22 +02:00
Sarah Hoffmann
a873f260cf
fix merging of linked names into unnamed boundaries
...
The NULL value of the boundaries' name field was erasing all
content when used in SQL operations.
2023-06-30 22:14:11 +02:00
Sarah Hoffmann
d7a3039c2a
also switch legacy tokenizer to new street/place choice behaviour
2023-06-30 17:03:17 +02:00
Sarah Hoffmann
645ea5a057
use information from tokenizer to determine street vs. place address
...
So far the SQL logic used the information from the address field
to determine if an address is attached to a street or place.
This changes the logic to use the information provided in the
token_info. This allows sanitizers to enforce a certain parenting
without changing the visible address information.
2023-06-30 11:08:25 +02:00
