StrongJava

Untitled

Jun 1st, 2018
181
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