Re: [OSM-dev] OpenStreetMap Carto release v5.9.0
On 21/10/2024 15:15, Andy Townsend wrote: The documentation at https://switch2osm.org/serving-tiles/ for what you originally installed hasn't been updated yet. If anyone did fancy updating that, the relevant bit for is after: https://github.com/switch2osm/switch2osm/blob/master/serving-tiles/manually-building-a-tile-server-ubuntu-24-04-lts.md#creating-indexes and before https://github.com/switch2osm/switch2osm/blob/master/serving-tiles/manually-building-a-tile-server-ubuntu-24-04-lts.md#shapefile-download I'd suggest updating the Debian 12 and Ubuntu 24.04 guides, and possibly also Ubuntu 22.04 as well. If it makes sense to and is easy to do the Docker one, then that too. It's also worth doing a "follow the guide and seeing if it works" test in case anything underlying in any of the OSes has broken anything. Pull requests welcome! If no-one else steps forward I'll update these as and when time permits... Best Regards, Andy ___ dev mailing list [email protected] https://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] OpenStreetMap Carto release v5.9.0
On 10/21/2024 10:15 AM, Andy Townsend wrote: > map layer 'ajt' Ye gods that's old! Indeed it is! > function carto_path_type(text, text) does not exist My guess is that you need to have a look at the installation notes for the latest Carto release. See https://github.com/openstreetmap/chef/issues/700 I read the release notes, but not the comment on the actual PR. That's the bit I was missing and doing it resolved my renderd restart issue. The documentation at https://switch2osm.org/serving-tiles/ for what you originally installed hasn't been updated yet. Yep, that's the guide I originally followed. Documentation always seems to lag the reality of the code. Lynn (D) - Happy to have the v5.9.0 stylesheet up and running (and confirmed!) On 21/10/2024 15:02, Lynn W. Deffenbaugh (Mr) wrote: Thank you Michael, (snip) ___ dev mailing list [email protected] https://lists.openstreetmap.org/listinfo/dev ___ dev mailing list [email protected] https://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] OpenStreetMap Carto release v5.9.0
Hi Lynn,
Am 21.10.24 um 16:02 schrieb Lynn W. Deffenbaugh (Mr):
Thank you Michael,
I just did that, but renderd failed on the restart with the following in
syslog:
Oct 21 15:58:53 bee-osm renderd[303293]: An error occurred while
loading the map layer 'ajt': Postgis Plugin: ERROR: function
carto_path_type(text, text) does not exi st#012LINE 15: ...
'highway_' || (CASE WHEN highway = 'path' THEN carto_path...#012
^#012HINT: No funct ion matches the given name and argument
types. You might need to add explicit type casts.#012in executeQuery
Full sql was: 'SELECT * FROM (SELECT#012 way,#012 (C ASE WHEN
feature IN ('highway_motorway_link', 'highway_trunk_link',
'highway_primary_link', 'highway_secondary_link',
'highway_tertiary_link') THEN substr(feature, 0, length(feature)-4)
ELSE feature END)
This is a very old import that has been applying updates for 2 years
now. Maybe there's a script I need to re-run to get the Postgis Plugin
updated to include the (apparently new) carto_path)_type function?
The function carto_path_type is defined in functions.sql [1]. You have
to rerun this file against your database using
psql -d gis -f functions.sql
Depending on the owner of your database "gis", you might run this as
that user using the -U option (see manfile for details). If you use peer
authentication, you can run this at that user using "sudo -u USERNAME ...".
Best regards
Michael
[1]
https://github.com/gravitystorm/openstreetmap-carto/blob/v5.9.0/functions.sql#L28
--
Michael Reichert www.geofabrik.de
Geofabrik GmbHHandelsregister: HRB Mannheim 703657
Amalienstr. 44Geschaeftsfuehrung: C. Karch, F. Ramm
76133 Karlsruhe Tel: 0721-1803560-3
[email protected] Fax: 0721-1803560-9
___
dev mailing list
[email protected]
https://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] OpenStreetMap Carto release v5.9.0
> map layer 'ajt' Ye gods that's old! > function carto_path_type(text, text) does not exist My guess is that you need to have a look at the installation notes for the latest Carto release. See https://github.com/openstreetmap/chef/issues/700 The documentation at https://switch2osm.org/serving-tiles/ for what you originally installed hasn't been updated yet. On 21/10/2024 15:02, Lynn W. Deffenbaugh (Mr) wrote: Thank you Michael, (snip) ___ dev mailing list [email protected] https://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] OpenStreetMap Carto release v5.9.0
Ok, I located the missing function in functions.sql and did the command
from INSTALLmd to get it in place.
The new hearing-aids shop symbol WORKS! Thank you Michael for the
nudge into the right direction.
Is there a guide/ToDo/tutorial on all of the steps necessary to update
the carto stylesheet in an existing tile server? I tried searching but
came up empty which is why I resorted to posting the request here.
Lynn (D) - Seeming up and running with the v5.9.0 carto stylesheet!
Thank you Michael,
I just did that, but renderd failed on the restart with the following in
syslog:
Oct 21 15:58:53 bee-osm renderd[303293]: An error occurred while
loading the map layer 'ajt': Postgis Plugin: ERROR: function
carto_path_type(text, text) does not exi st#012LINE 15: ...
'highway_' || (CASE WHEN highway = 'path' THEN carto_path...#012
^#012HINT: No funct ion matches the given name and argument
types. You might need to add explicit type casts.#012in executeQuery
Full sql was: 'SELECT * FROM (SELECT#012 way,#012 (C ASE WHEN
feature IN ('highway_motorway_link', 'highway_trunk_link',
'highway_primary_link', 'highway_secondary_link',
'highway_tertiary_link') THEN substr(feature, 0,
length(feature)-4) ELSE feature END)
This is a very old import that has been applying updates for 2 years
now. Maybe there's a script I need to re-run to get the Postgis Plugin
updated to include the (apparently new) carto_path)_type function?
Lynn (D) - Getting closer than I was!
On 10/21/2024 9:44 AM, Michael Reichert wrote:
Hi Lynn,
Am 21.10.24 um 15:33 schrieb Lynn W. Deffenbaugh (Mr):
1) git pull on the carto repository. I confirmed that the new
hearing_aids.svg is present.
2) Confirmed that there are no other locations containing the
original svg symbols
to ensure that the renderer must be using this directory
3) Restarted renderd (probably not necessary, but did it anyway)
You have to regenerate the Mapnik XML style file using
carto project.mml > project.xml
and restart renderd afterwards.
(Tirex users have to restart tirex-backend-manager instead)
Best regards
Michael
___
dev mailing list
[email protected]
https://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] OpenStreetMap Carto release v5.9.0
Thank you Michael,
I just did that, but renderd failed on the restart with the following in
syslog:
Oct 21 15:58:53 bee-osm renderd[303293]: An error occurred while
loading the map layer 'ajt': Postgis Plugin: ERROR: function
carto_path_type(text, text) does not exi st#012LINE 15: ...
'highway_' || (CASE WHEN highway = 'path' THEN carto_path...#012
^#012HINT: No funct ion matches the given name and argument
types. You might need to add explicit type casts.#012in executeQuery
Full sql was: 'SELECT * FROM (SELECT#012 way,#012 (C ASE WHEN
feature IN ('highway_motorway_link', 'highway_trunk_link',
'highway_primary_link', 'highway_secondary_link',
'highway_tertiary_link') THEN substr(feature, 0,
length(feature)-4) ELSE feature END)
This is a very old import that has been applying updates for 2 years
now. Maybe there's a script I need to re-run to get the Postgis Plugin
updated to include the (apparently new) carto_path)_type function?
Lynn (D) - Getting closer than I was!
On 10/21/2024 9:44 AM, Michael Reichert wrote:
Hi Lynn,
Am 21.10.24 um 15:33 schrieb Lynn W. Deffenbaugh (Mr):
1) git pull on the carto repository. I confirmed that the new
hearing_aids.svg is present.
2) Confirmed that there are no other locations containing the
original svg symbols
to ensure that the renderer must be using this directory
3) Restarted renderd (probably not necessary, but did it anyway)
You have to regenerate the Mapnik XML style file using
carto project.mml > project.xml
and restart renderd afterwards.
(Tirex users have to restart tirex-backend-manager instead)
Best regards
Michael
___
dev mailing list
[email protected]
https://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] OpenStreetMap Carto release v5.9.0
Hi Lynn, Am 21.10.24 um 15:33 schrieb Lynn W. Deffenbaugh (Mr): 1) git pull on the carto repository. I confirmed that the new hearing_aids.svg is present. 2) Confirmed that there are no other locations containing the original svg symbols to ensure that the renderer must be using this directory 3) Restarted renderd (probably not necessary, but did it anyway) You have to regenerate the Mapnik XML style file using carto project.mml > project.xml and restart renderd afterwards. (Tirex users have to restart tirex-backend-manager instead) Best regards Michael -- Michael Reichert www.geofabrik.de Geofabrik GmbHHandelsregister: HRB Mannheim 703657 Amalienstr. 44Geschaeftsfuehrung: C. Karch, F. Ramm 76133 Karlsruhe Tel: 0721-1803560-3 [email protected] Fax: 0721-1803560-9 ___ dev mailing list [email protected] https://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] OpenStreetMap Carto release v5.9.0
Is there a reference to the proper way to update a local tile server for this release? I'm trying to verify the "shop=hearing_aids" change, but am not seeing it even though I've forced the affected tiles to re-render. I've done the following: 1) git pull on the carto repository. I confirmed that the new hearing_aids.svg is present. 2) Confirmed that there are no other locations containing the original svg symbols to ensure that the renderer must be using this directory 3) Restarted renderd (probably not necessary, but did it anyway) 4) Browsed to the individual PNGs shown below and confirmed that the shop was still a dot. 5) Added /dirty to the URLs to force a re-render, watched the logs to ensure that it was rendered 6) Forced browser refresh (Ctrl-F5 in Chrome) on the individual tiles but the shop is still a red dot. 7) Queried node 7655813854 in the points table and it shows the proper shop attributed name 8) Redid 5 & 6 several times, then used /status to find the .meta tile and confirmed a new date there as well. 9) Check the same tiles at tile.openstreetmap.org, but they still show red dot (but may not have updated their style yet) 18/231994/158226.png - About dead center between fork/spoon and coffee cup 19/463989/316453.png - Top left corner, above coffee cup 20/927978/632906.png - Top left, labelled "Hearing ..ds Specialists - Not available on tile.openstreetmap.org https://tile.openstreetmap.org/18/231994/158226.png https://tile.openstreetmap.org/19/463989/316453.png What am I missing to get the new hearing_aids shop symbol to show up? I'm using this as the litmus test before updating my planet-import-complete and re-rendering all of my pre-rendered tiles. Lynn (D) PS. Here's the other pages referenced above: https://www.openstreetmap.org/user/imagico/diary/405334 https://wiki.openstreetmap.org/wiki/Tag%3Ashop%3Dhearing_aids https://github.com/gravitystorm/openstreetmap-carto/pull/4909/files https://www.openstreetmap.org/node/7655813854#map=19/-34.906942/138.596110 PPS. I've been running this planetary tile server for years, but this is actually the first time I'm trying to positively confirm a stylesheet update before re-rendering. On 10/17/2024 6:21 AM, Christoph Hormann wrote: Dear all, Today, v5.9.0 of the OpenStreetMap Carto stylesheet (the default stylesheet on the OSM website) has been released. Once changes are deployed on openstreetmap.org it will take couple of days before all tiles show the new rendering. Changes include * Adding rendering of shop=hearing_aids with a dedicated symbol * Restoring rendering of name labels for natural=reef * Adding rendering of lines with barrier=jersey_barrier * Removing rendering of railway=preserved in favor of interpreting railway:preserved=yes on other railway=* * Removing rendering of shop=jewellery as synonym for shop=jewelry * Adding rendering of leisure=dance with a point symbol and label * Interpretation of transport mode specific access tags on roads/paths More details on these changes with sample pictures can be found on https://www.openstreetmap.org/user/imagico/diary/405334 Thanks to all the contributors for this release, including in particular the new contributors BubbaJuice, Maik Busch, sommerbe For a full list of commits, see https://github.com/gravitystorm/openstreetmap-carto/compare/v5.8.0...v5.9.0 As always, we welcome any bug reports at https://github.com/gravitystorm/openstreetmap-carto/issues -- Christoph Hormann https://www.imagico.de/ ___ dev mailing list [email protected] https://lists.openstreetmap.org/listinfo/dev ___ dev mailing list [email protected] https://lists.openstreetmap.org/listinfo/dev
