SHARE
TWEET

Untitled

StrongJava Jun 1st, 2018 86 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. renderd[31304]: An error occurred while loading the map layer 'ajt': Postgis Plugin: ERROR:  column reference "surface" is ambiguous
  2. LINE 13:         WHEN surface IN ('unpaved', 'compacted', 'dirt', 'ea...
  3.                       ^
  4. in executeQuery Full sql was: 'SELECT * FROM (SELECT
  5.   way,
  6.   feature,
  7.   int_tc_type,
  8.   int_surface,
  9.   int_tc_service
  10. FROM
  11.   (SELECT DISTINCT on (p.way)
  12.       p.way AS way,
  13.       NULL::TEXT AS feature,
  14.       l.highway AS int_tc_type,
  15.       CASE
  16.         WHEN surface IN ('unpaved', 'compacted', 'dirt', 'earth', 'fine_gravel', 'grass', 'grass_paver', 'gravel', 'ground', 'mud', 'pebblestone', 'salt', 'sand', 'woodchips', 'clay') THEN 'unpaved'
  17.         WHEN surface IN ('paved', 'asphalt', 'cobblestone', 'cobblestone:flattened', 'sett', 'concrete', 'concrete:lanes', 'concrete:plates', 'paving_stones', 'metal', 'wood') THEN 'paved'
  18.         ELSE NULL
  19.       END AS int_surface,
  20.       CASE
  21.         WHEN l.service IN ('parking_aisle', 'drive-through', 'driveway') THEN 'INT-minor'::text
  22.         ELSE 'INT-normal'::text
  23.       END AS int_tc_service
  24.     FROM planet_osm_point p
  25.       JOIN planet_osm_line l
  26.         ON ST_DWithin(p.way, l.way, 0.1)
  27.       JOIN (VALUES
  28.         ('tertiary', 1),
  29.         ('unclassified', 2),
  30.         ('residential', 3),
  31.         ('living_street', 4),
  32.         ('service', 5),
  33.         ('track', 6)
  34.       ) AS v (highway, prio)
  35.         ON v.highway=l.highway
  36.     WHERE p.highway = 'turning_circle' OR p.highway = 'turning_loop'
  37.     ORDER BY p.way, v.prio
  38.   ) AS turning_circle_fill_inner_query
  39.   UNION ALL
  40.   (SELECT
  41.       ST_MakeEnvelope(-20037508.342789244, -20037508.342789244, 20037508.342789244, 20037508.342789244, 900913) AS way,
  42.       'globalboundingbox' AS feature,
  43.       NULL AS int_tc_type,
  44.       NULL AS int_surface,
  45.       NULL AS int_tc_service
  46.   )
  47. ) AS turning_circle_fill_outer_query LIMIT 0'
  48.   encountered during parsing of layer 'turning-circle-fill' in Layer at line 22178 of '/home/tileserver/src/openstreetmap-carto/mapnik.xml'
  49. renderd[31304]: An error occurred while loading the map layer 'ajt': Postgis Plugin: ERROR:  column reference "surface" is ambiguous
  50. LINE 13:         WHEN surface IN ('unpaved', 'compacted', 'dirt', 'ea...
  51.                       ^
  52. in executeQuery Full sql was: 'SELECT * FROM (SELECT
  53.   way,
  54.   feature,
  55.   int_tc_type,
  56.   int_surface,
  57.   int_tc_service
  58. FROM
  59.   (SELECT DISTINCT on (p.way)
  60.       p.way AS way,
  61.       NULL::TEXT AS feature,
  62.       l.highway AS int_tc_type,
  63.       CASE
  64.         WHEN surface IN ('unpaved', 'compacted', 'dirt', 'earth', 'fine_gravel', 'grass', 'grass_paver', 'gravel', 'ground', 'mud', 'pebblestone', 'salt', 'sand', 'woodchips', 'clay') THEN 'unpaved'
  65.         WHEN surface IN ('paved', 'asphalt', 'cobblestone', 'cobblestone:flattened', 'sett', 'concrete', 'concrete:lanes', 'concrete:plates', 'paving_stones', 'metal', 'wood') THEN 'paved'
  66.         ELSE NULL
  67.       END AS int_surface,
  68.       CASE
  69.         WHEN l.service IN ('parking_aisle', 'drive-through', 'driveway') THEN 'INT-minor'::text
  70.         ELSE 'INT-normal'::text
  71.       END AS int_tc_service
  72.     FROM planet_osm_point p
  73.       JOIN planet_osm_line l
  74.         ON ST_DWithin(p.way, l.way, 0.1)
  75.       JOIN (VALUES
  76.         ('tertiary', 1),
  77.         ('unclassified', 2),
  78.         ('residential', 3),
  79.         ('living_street', 4),
  80.         ('service', 5),
  81.         ('track', 6)
  82.       ) AS v (highway, prio)
  83.         ON v.highway=l.highway
  84.     WHERE p.highway = 'turning_circle' OR p.highway = 'turning_loop'
  85.     ORDER BY p.way, v.prio
  86.   ) AS turning_circle_fill_inner_query
  87.   UNION ALL
  88.   (SELECT
  89.       ST_MakeEnvelope(-20037508.342789244, -20037508.342789244, 20037508.342789244, 20037508.342789244, 900913) AS way,
  90.       'globalboundingbox' AS feature,
  91.       NULL AS int_tc_type,
  92.       NULL AS int_surface,
  93.       NULL AS int_tc_service
  94.   )
  95. ) AS turning_circle_fill_outer_query LIMIT 0'
  96.   encountered during parsing of layer 'turning-circle-fill' in Layer at line 22178 of '/home/tileserver/src/openstreetmap-carto/mapnik.xml'
  97. renderd[31304]: An error occurred while loading the map layer 'ajt': Postgis Plugin: ERROR:  column reference "surface" is ambiguous
  98. LINE 13:         WHEN surface IN ('unpaved', 'compacted', 'dirt', 'ea...
  99.                       ^
  100. in executeQuery Full sql was: 'SELECT * FROM (SELECT
  101.   way,
  102.   feature,
  103.   int_tc_type,
  104.   int_surface,
  105.   int_tc_service
  106. FROM
  107.   (SELECT DISTINCT on (p.way)
  108.       p.way AS way,
  109.       NULL::TEXT AS feature,
  110.       l.highway AS int_tc_type,
  111.       CASE
  112.         WHEN surface IN ('unpaved', 'compacted', 'dirt', 'earth', 'fine_gravel', 'grass', 'grass_paver', 'gravel', 'ground', 'mud', 'pebblestone', 'salt', 'sand', 'woodchips', 'clay') THEN 'unpaved'
  113.         WHEN surface IN ('paved', 'asphalt', 'cobblestone', 'cobblestone:flattened', 'sett', 'concrete', 'concrete:lanes', 'concrete:plates', 'paving_stones', 'metal', 'wood') THEN 'paved'
  114.         ELSE NULL
  115.       END AS int_surface,
  116.       CASE
  117.         WHEN l.service IN ('parking_aisle', 'drive-through', 'driveway') THEN 'INT-minor'::text
  118.         ELSE 'INT-normal'::text
  119.       END AS int_tc_service
  120.     FROM planet_osm_point p
  121.       JOIN planet_osm_line l
  122.         ON ST_DWithin(p.way, l.way, 0.1)
  123.       JOIN (VALUES
  124.         ('tertiary', 1),
  125.         ('unclassified', 2),
  126.         ('residential', 3),
  127.         ('living_street', 4),
  128.         ('service', 5),
  129.         ('track', 6)
  130.       ) AS v (highway, prio)
  131.         ON v.highway=l.highway
  132.     WHERE p.highway = 'turning_circle' OR p.highway = 'turning_loop'
  133.     ORDER BY p.way, v.prio
  134.   ) AS turning_circle_fill_inner_query
  135.   UNION ALL
  136.   (SELECT
  137.       ST_MakeEnvelope(-20037508.342789244, -20037508.342789244, 20037508.342789244, 20037508.342789244, 900913) AS way,
  138.       'globalboundingbox' AS feature,
  139.       NULL AS int_tc_type,
  140.       NULL AS int_surface,
  141.       NULL AS int_tc_service
  142.   )
  143. ) AS turning_circle_fill_outer_query LIMIT 0'
  144.   encountered during parsing of layer 'turning-circle-fill' in Layer at line 22178 of '/home/tileserver/src/openstreetmap-carto/mapnik.xml'
  145. renderd[31304]: An error occurred while loading the map layer 'ajt': Postgis Plugin: ERROR:  column reference "surface" is ambiguous
  146. LINE 13:         WHEN surface IN ('unpaved', 'compacted', 'dirt', 'ea...
  147.                       ^
  148. in executeQuery Full sql was: 'SELECT * FROM (SELECT
  149.   way,
  150.   feature,
  151.   int_tc_type,
  152.   int_surface,
  153.   int_tc_service
  154. FROM
  155.   (SELECT DISTINCT on (p.way)
  156.       p.way AS way,
  157.       NULL::TEXT AS feature,
  158.       l.highway AS int_tc_type,
  159.       CASE
  160.         WHEN surface IN ('unpaved', 'compacted', 'dirt', 'earth', 'fine_gravel', 'grass', 'grass_paver', 'gravel', 'ground', 'mud', 'pebblestone', 'salt', 'sand', 'woodchips', 'clay') THEN 'unpaved'
  161.         WHEN surface IN ('paved', 'asphalt', 'cobblestone', 'cobblestone:flattened', 'sett', 'concrete', 'concrete:lanes', 'concrete:plates', 'paving_stones', 'metal', 'wood') THEN 'paved'
  162.         ELSE NULL
  163.       END AS int_surface,
  164.       CASE
  165.         WHEN l.service IN ('parking_aisle', 'drive-through', 'driveway') THEN 'INT-minor'::text
  166.         ELSE 'INT-normal'::text
  167.       END AS int_tc_service
  168.     FROM planet_osm_point p
  169.       JOIN planet_osm_line l
  170.         ON ST_DWithin(p.way, l.way, 0.1)
  171.       JOIN (VALUES
  172.         ('tertiary', 1),
  173.         ('unclassified', 2),
  174.         ('residential', 3),
  175.         ('living_street', 4),
  176.         ('service', 5),
  177.         ('track', 6)
  178.       ) AS v (highway, prio)
  179.         ON v.highway=l.highway
  180.     WHERE p.highway = 'turning_circle' OR p.highway = 'turning_loop'
  181.     ORDER BY p.way, v.prio
  182.   ) AS turning_circle_fill_inner_query
  183.   UNION ALL
  184.   (SELECT
  185.       ST_MakeEnvelope(-20037508.342789244, -20037508.342789244, 20037508.342789244, 20037508.342789244, 900913) AS way,
  186.       'globalboundingbox' AS feature,
  187.       NULL AS int_tc_type,
  188.       NULL AS int_surface,
  189.       NULL AS int_tc_service
  190.   )
  191. ) AS turning_circle_fill_outer_query LIMIT 0'
  192.   encountered during parsing of layer 'turning-circle-fill' in Layer at line 22178 of '/home/tileserver/src/openstreetmap-carto/mapnik.xml'
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top