Sarah Hoffmann
70b9140f13
pass reverse-only as a separate parameter
...
... instead of hacking the internal structures of SQLPreprocessor
2026-02-13 11:12:23 +01:00
Sarah Hoffmann
aa42dc8a93
fix potential cancelling race with full queue
2026-02-12 20:44:04 +01:00
Sarah Hoffmann
b995803c66
Merge pull request #3979 from jayaddison/issue-2714-prep/extract-rank-zero-specialcasing
...
Indexer: relocate zero-ranked-address indexing
2026-02-11 15:05:28 +01:00
James Addison
310d6e3c92
Indexer: relocate zero-ranked-address indexing
2026-02-10 11:51:18 +00:00
Sarah Hoffmann
7a3ea55f3d
ignore tables with odd names in SQLPreprocessor
2026-02-10 11:40:52 +01:00
Sarah Hoffmann
73590baf15
use psycopg.sql for SQL building in tokenizer
2026-02-10 11:39:19 +01:00
Sarah Hoffmann
e17d0cb5cf
only allow alphanumeric and dash in DATABASE_WEBUSER
...
This variable is used a lot in raw SQL. Avoid injection issues.
2026-02-10 11:39:17 +01:00
Sarah Hoffmann
615804b1b3
Merge pull request #3978 from jayaddison/issue-2714-prep/index-boundaries-method-signature-nitpick
...
Refactor: add default params to Indexer.index_boundaries
2026-02-10 09:45:29 +01:00
Sarah Hoffmann
79bbdfd55c
Merge pull request #3975 from kad-link/fix/utf8-encoding-clean
...
Fix: Enforce explicit UTF-8 encoding in file I/O
2026-02-10 09:32:06 +01:00
James Addison
509f59b193
Refactor: add default params to index_boundaries
2026-02-09 21:36:30 +00:00
Sri CHaRan
f84b279540
fix: add utf-8 encoding in read-write files
2026-02-10 00:38:40 +05:30
remo-lab
ae7301921a
Fix SQL injection in truncate_data_tables
...
Signed-off-by: remo-lab <remopanda7@gmail.com >
2026-02-05 17:04:10 +05:30
Sarah Hoffmann
cc9c8963f3
Merge pull request #3949 from Itz-Agasta/try
...
Feat: Add admin function for granting access to read-only user
2026-02-02 09:53:24 +01:00
Itz-Agasta
45972811e3
Preserve import error tables during freeze
...
- Remove 'import_polygon_%' from UPDATE_TABLES to keep import_polygon_error
and import_polygon_delete tables in frozen databases.
- These tables contain permanent import error tracking data and should not
be deleted during freeze. The ro-access grant system expects them to exist
in all database states.
2026-01-31 22:50:18 +05:30
Itz-Agasta
e021f558bf
Restore grants for dynamic tables in tokenizer, migration, and tiger import
2026-01-30 20:43:57 +05:30
AmmarYasser455
fcc5ce3f92
docs: fix multiple typos in documentation and source code
2026-01-30 12:13:23 +02:00
Itz-Agasta
6ad87db1eb
Updates layer selection to allow optional default
...
- Modifies layer argument handling to permit no default layers appropriate.
- Update the help text for the layer parameter in the reverse command
2026-01-29 11:33:21 +05:30
Itz-Agasta
bf6eb01d68
Adds layer filtering option to search command
...
Introduces a cli argument to restrict search results
to specified data layers, enabling more targeted queries.
2026-01-28 12:16:43 +05:30
Itz-Agasta
58cae70596
Adds option to grant web user read-only DB access
...
Introduces a command-line flag to grant read-only access to the web user for all tables, improving ease of permissions management during refresh operations.
2026-01-27 17:54:10 +05:30
Itz-Agasta
bf0ee6685b
Grants read-only access after import
...
Adds execution of grant statements to provide read-only privileges
for the web user following table creation or via a dedicated function.
Facilitates easier post-import permission management.
2026-01-27 17:53:25 +05:30
Itz-Agasta
ff1f1b06d9
Moves db grant statements to dedicated script
...
Centralizes all read-only access grants into a single SQL script, ensuring permissions are managed in one place.
2026-01-27 17:49:51 +05:30
Sarah Hoffmann
fe773c12b2
Merge pull request #3946 from lonvia/enable-entrances-for-reverse
...
Enable entrance lookup for reverse and lookup
2026-01-23 22:10:43 +01:00
Sarah Hoffmann
cc96912580
Merge pull request #3906 from AyushDharDubey/fix/issue_2463-Use-search_name-table-for-TIGER-data-imports-on-'dropped'-databases
...
Use `search_name` as fallback for TIGER imports when update tables are dropped
2026-01-23 20:52:40 +01:00
Sarah Hoffmann
6a6a064ef7
enable entrances for reverse and lookup
2026-01-23 17:38:47 +01:00
Sri Charan Chittineni
c4dc2c862e
fix mypy typing for Starlette state object ( #3944 )
2026-01-22 13:21:34 +01:00
Ayush Dhar Dubey
2698382552
permit import of tiger after freeze
2026-01-09 17:35:01 +05:30
Sarah Hoffmann
a4a2176ded
immediately terminate indexing when a task catches an exception
2026-01-07 09:58:40 +01:00
Sarah Hoffmann
2e2ce2c979
fix version counts
2026-01-01 14:42:12 +01:00
Sarah Hoffmann
99643aa0e9
ignore postcode areas in countries without postcodes properly
2026-01-01 11:21:40 +01:00
Sarah Hoffmann
c05b8f241c
make sure we use exactly the same table structure as osm2pgsql
2025-12-31 00:21:27 +01:00
Sarah Hoffmann
da94d7eea3
need an analyse after the migration
2025-12-30 19:49:07 +01:00
Sarah Hoffmann
f9864b7ec7
grant access right to www user for new postcode table
2025-12-30 17:48:33 +01:00
Sarah Hoffmann
42d139a5d0
analyze postcode table during import
2025-12-30 15:21:20 +01:00
Sarah Hoffmann
f2110e12d6
simplify postcode area for lookups
2025-12-30 15:21:20 +01:00
Sarah Hoffmann
deb6654cfd
add migration for new postcode table
2025-12-30 15:20:46 +01:00
Sarah Hoffmann
6a67cfcddf
adapt search frontend to new postcode table
2025-12-30 15:20:46 +01:00
Sarah Hoffmann
d1cb578535
rework postcode computation
...
Now adds areas to location_postcodes, ignores postcode points
inside areas and supports customizable extents.
2025-12-30 15:20:46 +01:00
Sarah Hoffmann
a97b5d97cb
add support for custom per-country postcode extents
2025-12-30 15:20:46 +01:00
Sarah Hoffmann
9ec607b556
change confusing value in debug output for missing importance
2025-12-30 15:20:46 +01:00
Sarah Hoffmann
89821d01e0
reorganise layout of location_postcode table
...
Also renames the table as this will make it easier to migrate.
2025-12-30 15:20:46 +01:00
Sarah Hoffmann
7ef3f99fa4
drop new place sub-tables on freezing
2025-12-30 15:20:46 +01:00
Sarah Hoffmann
0aa9eee3e7
remove special casing for postcodes in trigger code
2025-12-30 15:20:46 +01:00
Ayush Dhar Dubey
4fd616254a
update Locales constructor:
...
expect output names as argument and avoid redundant configuration initialization
2025-12-20 19:15:33 +05:30
Ayush Dhar Dubey
049164086a
fix: ensure Locales is not initialized when provided in options
2025-12-20 19:12:15 +05:30
Sarah Hoffmann
58e56ec53d
Merge pull request #3901 from AyushDharDubey/fix/issue_3829-use-mwparserfromhell-to-parse-sp-wiki-page
...
Replace regex with `mwparserfromhell` based MW WikiCode Parsing for Special Phrases
2025-12-08 11:51:50 +01:00
Ayush Dhar Dubey
49454048c4
use mwparserfromhell to parse SP wiki page reliably
2025-12-08 11:01:14 +05:30
Sarah Hoffmann
35060164ab
reverse: only return housenumbers near street
2025-12-07 11:00:23 +01:00
Sarah Hoffmann
3bb5d00848
avoid extra query for finding closest housenumber in reverse
2025-12-05 17:09:13 +01:00
Sarah Hoffmann
b366b9df6f
reverse: avoid interpolation lookup when result is already perfect
2025-12-05 17:08:46 +01:00
Sarah Hoffmann
ffd5c32f17
fix comparision between countr tokens and country restriction
2025-12-04 18:29:25 +01:00
