Czech Streets 1120 Portu Fix Site

To avoid needing a "fix" for any Prague street, including U Portu, follow these rules:

Czech mapping enthusiasts maintain a list of "poškozených ulic" (damaged/corrupted streets). U Portu is on that list due to a historical data import error from the Czech Land Registry (ČÚZK) in 2009. The "1120 portu fix" refers to a SQL script that updates the street_addresses table.

The word "fix" indicates that something is broken. Users searching for "czech streets 1120 portu fix" are likely experiencing:

If your map application, delivery system, or navigation device is showing errors for "1120 Portu" (or U Portu, 112 00), here is how to apply the fix. czech streets 1120 portu fix

For developers running local instances of Nominatim (the search engine for OpenStreetMap), here is the exact command to fix the "1120 portu" error.

Problem: Your geocoder returns U Portu, 112 00 Praha 12 when it should be 143 00.

SQL Fix for PostgreSQL/PostGIS:

-- Backup first
CREATE TABLE place_backup AS SELECT * FROM place_addressline;
-- Correct the postal code for U Portu (OSM ID 303648254)
UPDATE place_addressline
SET postcode = '14300'
WHERE osm_id = 303648254 AND osm_type = 'W' AND postcode = '11200';
-- Re-index the search table
REINDEX DATABASE nominatim;

Relevance of "1120" in this fix: The database likely stores postal codes as integers, dropping trailing zeros. So 11200 becomes 1120 in the index. The fix requires changing the integer value to 14300 (which renders in logs as 1430).

Problem: Your car GPS routes you to Strašnice instead of Modřany. Solution: