OSM Classic and Google Styling with PostGis and Geoserver

1 Get OSM data and prepare PostGIS and Geoserver

see prev post about it

install CSS-plugin

sudo mcedit /etc/postgresql/13/main/pg_hba.conf

# TYPE  DATABASE        USER            ADDRESS                 METHOD
# "local" is for Unix domain socket connections only
local   all             osmuser  md5

3 Important - tune Geoserver

Increase memory for drawing:

Services -> WMS ->

wms_tune

4 Google-styling Step 1: download styles

download css_google.rar 6kb

5 Google-styling Step 2: execute sql script

download script.sql 15kb

Important Script executing needed to perform through 'psql'-util with 'osmuser'-login

psql -U osmuser -W -h localhost -d <database_name> -a -f /home/user/script.sql

6 Google-styling Step 3: Styling now

Connect layers, add styles, create layer group:

layergroup

7 OSM-Classic styling Step 1: download SLD and Symbols

download sld_symbols.rar 209kb

8 OSM-Classic styling Step 2: install styles

Install SLD styles via Geoserver web-admin interface.

line for lines and roads polygon for polygon

Copy 'symbols' folder to ~/geoserver/data_dir/workspaces/{your_workspace}/styles

9 OSM-Classic styling Step 3: Styling now

Connect layers, add styles, create layer group