API tools faq
paste
Advertisement
StrongJava

Untitled

StrongJava
Jun 1st, 2018
291
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.98 KB | None | 0 0
raw download clone embed print report
  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'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!