Advertisement
N3x_

another paste

May 3rd, 2019
160
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. #the error I get from running renderd
  2. renderd[14875]: An error occurred while loading the map layer 'default': Could not create datasource for type: 'postgis' (no datasource plugin directories have been successfully registered) encountered during parsing of layer 'landcover-low-zoom' in Layer at line 755 of '/home/betrieb/src/openstreetmap-carto/mapnik.xml'
  3.  
  4.  
  5.  
  6. #line 755 of that file
  7. <Layer maximum-scale-denominator="25000000" minimum-scale-denominator="750000" name="landcover-low-zoom" srs="+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over">
  8.  
  9.  
  10.  
  11. #whole layer
  12. <Layer maximum-scale-denominator="25000000" minimum-scale-denominator="750000" name="landcover-low-zoom" srs="+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over">
  13. <StyleName><![CDATA[landcover-low-zoom-low-zoom]]></StyleName>
  14. <Datasource>
  15. <Parameter name="type"><![CDATA[postgis]]></Parameter>
  16. <Parameter name="dbname"><![CDATA[gis]]></Parameter>
  17. <Parameter name="key_field"><![CDATA[]]></Parameter>
  18. <Parameter name="geometry_field"><![CDATA[way]]></Parameter>
  19. <Parameter name="extent"><![CDATA[-20037508,-20037508,20037508,20037508]]></Parameter>
  20. <Parameter name="table"><![CDATA[(SELECT
  21. way, way_pixels,
  22. COALESCE(wetland, landuse, "natural") AS feature
  23. FROM (SELECT
  24. way,
  25. ('landuse_' || (CASE WHEN landuse IN ('forest', 'farmland', 'residential', 'commercial', 'retail', 'industrial',
  26. 'meadow', 'grass', 'village_green', 'vineyard', 'orchard') THEN landuse ELSE NULL END)) AS landuse,
  27. ('natural_' || (CASE WHEN "natural" IN ('wood', 'sand', 'scree', 'shingle', 'bare_rock', 'heath', 'grassland', 'scrub') THEN "natural" ELSE NULL END)) AS "natural",
  28. ('wetland_' || (CASE WHEN "natural" IN ('wetland', 'mud') THEN (CASE WHEN "natural" IN ('mud') THEN "natural" ELSE tags->'wetland' END) ELSE NULL END)) AS wetland,
  29. way_area/NULLIF(POW(!scale_denominator!*0.001*0.28,2),0) AS way_pixels,
  30. way_area
  31. FROM planet_osm_polygon
  32. WHERE (landuse IN ('forest', 'farmland', 'residential', 'commercial', 'retail', 'industrial', 'meadow', 'grass', 'village_green', 'vineyard', 'orchard')
  33. OR "natural" IN ('wood', 'wetland', 'mud', 'sand', 'scree', 'shingle', 'bare_rock', 'heath', 'grassland', 'scrub'))
  34. AND way_area > 0.01*!pixel_width!::real*!pixel_height!::real
  35. AND building IS NULL
  36. ) AS features
  37. ORDER BY way_area DESC, feature
  38. ) AS landcover_low_zoom]]></Parameter>
  39. </Datasource>
  40. </Layer>
Advertisement
RAW Paste Data Copied
Advertisement