NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

I have imported entire planet data using the following query.

sudo osm2pgsql --drop --hstore --slim -r pbf -C 32000 --flat-nodes node.cache --number-processes 8 -d gis -U root /mnt/data/planetdata/planet-latest.osm.pbf

But whenever I am testing rendered using-

renderd -f -c /usr/local/etc/renderd.conf

It is logging the following errors-

renderd[17978]: An error occurred while loading the map layer 'osm': Postgis Plugin: ERROR:  COALESCE types text and integer cannot be matched
LINE 18:   ORDER BY COALESCE(layer,0), way_area DESC
                               ^
in executeQuery Full sql was: 'SELECT * FROM (SELECT
way,
"natural",
waterway,
landuse,
name,
way_area/NULLIF(0::real*0::real,0) AS way_pixels,
CASE WHEN tags->'intermittent' IN ('yes')
  OR tags->'seasonal' IN ('yes', 'spring', 'summer', 'autumn', 'winter', 'wet_season', 'dry_season')
  THEN 'yes' ELSE 'no' END AS int_intermittent
FROM planet_osm_polygon
WHERE
(waterway IN ('dock', 'riverbank')
  OR landuse IN ('reservoir', 'basin')
  OR "natural" IN ('water', 'glacier'))
AND building IS NULL
AND way_area > 1*0::real*0::real
ORDER BY COALESCE(layer,0), way_area DESC
) AS water_areas LIMIT 0'
encountered during parsing of layer 'water-areas' in Layer at line 8298 of 
'/mnt/data/styles/osm/openstreetmap-carto-master/osm.xml'
debug: init_storage_backend: initialising file storage backend at: /var/lib/mod_tile
renderd[17978]: Loading parameterization function for 
renderd[17978]: An error occurred while loading the map layer 'osm': Postgis Plugin: ERROR:  COALESCE 
types text and integer cannot be matched
LINE 18:   ORDER BY COALESCE(layer,0), way_area DESC
                               ^
in executeQuery Full sql was: 'SELECT * FROM (SELECT
way,
"natural",
waterway,
landuse,
name,
way_area/NULLIF(0::real*0::real,0) AS way_pixels,
CASE WHEN tags->'intermittent' IN ('yes')
  OR tags->'seasonal' IN ('yes', 'spring', 'summer', 'autumn', 'winter', 'wet_season', 'dry_season')
  THEN 'yes' ELSE 'no' END AS int_intermittent
FROM planet_osm_polygon
WHERE
(waterway IN ('dock', 'riverbank')
  OR landuse IN ('reservoir', 'basin')
  OR "natural" IN ('water', 'glacier'))
AND building IS NULL
AND way_area > 1*0::real*0::real
ORDER BY COALESCE(layer,0), way_area DESC
) AS water_areas LIMIT 0'
encountered during parsing of layer 'water-areas' in Layer at line 8298 of 
'/mnt/data/styles/osm/openstreetmap-carto-master/osm.xml'

When I googled for this error.I found a this link referencing the same issue- link

But I am using style from openstreetmap-carto-master and mapbox-carto(osm-bright) both.

openstreetmap-carto-master - link

mapbox-carto - link

So, In my case how can I specify two style file in my query? Or How can I solve this issue?

If anyone have solved this issue ,please let me know.

asked 09 Jul '18, 15:16

anuranpal's gravatar image

anuranpal
21101215
accept rate: 0%

edited 10 Jul '18, 11:34

Can you explain what you mean by "I am using style from openstreetmap-carto-master and maknik-carto both"? Can you link to both styles?

(09 Jul '18, 16:42) SomeoneElse ♦

I mean my tileserver can supply multiple carto styles as base map.

(09 Jul '18, 16:59) anuranpal
1

Can you link to both styles? That'll help people tell if they can share a database or not.

(09 Jul '18, 17:17) SomeoneElse ♦

I have updated the question. @SomeoneElse

(10 Jul '18, 06:32) anuranpal

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×710
×263
×105
×22
×4

question asked: 09 Jul '18, 15:16

question was seen: 2,373 times

last updated: 10 Jul '18, 11:34

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum