Bez tytułu

z Capacious Ostrich, 8 miesiące temu, napisane w Plain Text, wyświetlone 107 razy. [paste_expire] 2 miesiące.
URL https://pastebin.k4be.pl/view/de3504ea Udostępnij
Pobierz wklejkę lub Pokaż surowy tekst
  1. [1] Error creating or configuring Mapnik: [Error: Postgis Plugin: ERROR:  function first(geometry) does not exist
  2. [1] LINE 95:         first(geometry) AS geometry,
  3. [1]                  ^
  4. [1] HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
  5. [1] in executeQuery Full sql was: 'SELECT * FROM (
  6. [1]     SELECT
  7. [1]       ST_LineMerge(ST_Collect(geometry)) AS geometry,
  8. [1]       idx(arr1, 0) AS h_red,
  9. [1]       idx(arr1, 1) AS h_blue,
  10. [1]       idx(arr1, 2) AS h_green,
  11. [1]       idx(arr1, 3) AS h_yellow,
  12. [1]       idx(arr1, 4) AS h_black,
  13. [1]       idx(arr1, 5) AS h_white,
  14. [1]       idx(arr1, 6) AS h_orange,
  15. [1]       idx(arr1, 7) AS h_purple,
  16. [1]       idx(arr1, 8) AS h_none,
  17. [1]       idx(arr1, 10) AS h_red_loc,
  18. [1]       idx(arr1, 11) AS h_blue_loc,
  19. [1]       idx(arr1, 12) AS h_green_loc,
  20. [1]       idx(arr1, 13) AS h_yellow_loc,
  21. [1]       idx(arr1, 14) AS h_black_loc,
  22. [1]       idx(arr1, 15) AS h_white_loc,
  23. [1]       idx(arr1, 16) AS h_orange_loc,
  24. [1]       idx(arr1, 17) AS h_purple_loc,
  25. [1]       idx(arr1, 18) AS h_none_loc,
  26. [1]       idx(arr2, 20) AS b_red,
  27. [1]       idx(arr2, 21) AS b_blue,
  28. [1]       idx(arr2, 22) AS b_green,
  29. [1]       idx(arr2, 23) AS b_yellow,
  30. [1]       idx(arr2, 24) AS b_black,
  31. [1]       idx(arr2, 25) AS b_white,
  32. [1]       idx(arr2, 26) AS b_orange,
  33. [1]       idx(arr2, 27) AS b_purple,
  34. [1]       idx(arr2, 28) AS b_none,
  35. [1]       idx(arr2, 30) AS s_red,
  36. [1]       idx(arr2, 31) AS s_blue,
  37. [1]       idx(arr2, 32) AS s_green,
  38. [1]       idx(arr2, 33) AS s_yellow,
  39. [1]       idx(arr2, 34) AS s_black,
  40. [1]       idx(arr2, 35) AS s_white,
  41. [1]       idx(arr2, 36) AS s_orange,
  42. [1]       idx(arr2, 37) AS s_purple,
  43. [1]       idx(arr2, 38) AS s_none,
  44. [1]       idx(arr1, 40) AS r_red,
  45. [1]       idx(arr1, 41) AS r_blue,
  46. [1]       idx(arr1, 42) AS r_green,
  47. [1]       idx(arr1, 43) AS r_yellow,
  48. [1]       idx(arr1, 44) AS r_black,
  49. [1]       idx(arr1, 45) AS r_white,
  50. [1]       idx(arr1, 46) AS r_orange,
  51. [1]       idx(arr1, 47) AS r_purple,
  52. [1]       idx(arr1, 48) AS r_none,
  53. [1]       refs1,
  54. [1]       refs2,
  55. [1]       icount(arr1 - array[1000, 1010, 1020, 1030, 1040]) AS off1,
  56. [1]       icount(arr2 - array[1000, 1010, 1020, 1030, 1040]) AS off2
  57. [1]     FROM (
  58. [1]       SELECT
  59. [1]         array_to_string(
  60. [1]           array(
  61. [1]             SELECT distinct itm FROM unnest(
  62. [1]               array_agg(
  63. [1]                 CASE
  64. [1]                   WHEN
  65. [1]                     osm_routes.type IN ('hiking','foot','horse')
  66. [1]                   THEN
  67. [1]                     CASE
  68. [1]                       WHEN name <> '' AND ref <> ''
  69. [1]                       THEN name || ' (' || ref || ')'
  70. [1]                       ELSE COALESCE(NULLIF(name, ''), NULLIF(ref, '')) END
  71. [1]                   ELSE
  72. [1]                     null
  73. [1]                   END
  74. [1]               )
  75. [1]             ) AS itm ORDER BY itm
  76. [1]           ),
  77. [1]           ', '
  78. [1]         ) AS refs1,
  79. [1]         array_to_string(
  80. [1]           array(
  81. [1]             SELECT distinct itm FROM unnest(
  82. [1]               array_agg(
  83. [1]                 CASE
  84. [1]                   WHEN
  85. [1]                     osm_routes.type IN ('bicycle','mtb','ski','piste')
  86. [1]                   THEN
  87. [1]                     CASE
  88. [1]                       WHEN name <> '' AND ref <> ''
  89. [1]                       THEN name || ' (' || ref || ')'
  90. [1]                       ELSE COALESCE(NULLIF(name, ''), NULLIF(ref, '')) END
  91. [1]                   ELSE
  92. [1]                     null
  93. [1]                   END
  94. [1]               )
  95. [1]             ) AS itm ORDER BY itm
  96. [1]           ),
  97. [1]           ', '
  98. [1]         ) AS refs2,
  99. [1]         first(geometry) AS geometry,
  100. [1]         uniq(sort(array_agg(
  101. [1]           CASE
  102. [1]             WHEN osm_routes.type IN ('hiking','foot','horse') THEN
  103. [1]               CASE
  104. [1]                 WHEN true AND osm_routes.type = 'horse' THEN 40
  105. [1]                 WHEN true AND osm_routes.type IN ('hiking', 'foot') THEN (CASE WHEN network IN ('iwn', 'nwn', 'rwn') THEN 0 ELSE 10 END)
  106. [1]                 ELSE 1000
  107. [1]               END +
  108. [1]              
  109. [1]   CASE
  110. [1]     WHEN "osmc:symbol" LIKE 'red:%' THEN 0
  111. [1]     WHEN "osmc:symbol" LIKE 'blue:%' THEN 1
  112. [1]     WHEN "osmc:symbol" LIKE 'green:%' THEN 2
  113. [1]     WHEN "osmc:symbol" LIKE 'yellow:%' THEN 3
  114. [1]     WHEN "osmc:symbol" LIKE 'black:%' THEN 4
  115. [1]     WHEN "osmc:symbol" LIKE 'white:%' THEN 5
  116. [1]     WHEN "osmc:symbol" LIKE 'orange:%' THEN 6
  117. [1]     WHEN "osmc:symbol" LIKE 'violet:%' THEN 7
  118. [1]     WHEN "osmc:symbol" LIKE 'purple:%' THEN 7
  119. [1]     WHEN colour = 'red' THEN 0
  120. [1]     WHEN colour = 'blue' THEN 1
  121. [1]     WHEN colour = 'green' THEN 2
  122. [1]     WHEN colour = 'yellow' THEN 3
  123. [1]     WHEN colour = 'black' THEN 4
  124. [1]     WHEN colour = 'white' THEN 5
  125. [1]     WHEN colour = 'orange' THEN 6
  126. [1]     WHEN colour = 'violet' THEN 7
  127. [1]     WHEN colour = 'purple' THEN 7
  128. [1]     ELSE 8
  129. [1]   END
  130. [1]
  131. [1]             ELSE 1000
  132. [1]           END
  133. [1]         ))) AS arr1,
  134. [1]         uniq(sort(array_agg(
  135. [1]           CASE
  136. [1]             WHEN osm_routes.type IN ('bicycle','mtb','ski','piste') THEN
  137. [1]               CASE
  138. [1]                 WHEN true AND osm_routes.type IN ('bicycle', 'mtb') THEN 20
  139. [1]                 WHEN true AND osm_routes.type IN ('ski', 'piste') THEN 30
  140. [1]                 ELSE 1000
  141. [1]               END +
  142. [1]              
  143. [1]   CASE
  144. [1]     WHEN "osmc:symbol" LIKE 'red:%' THEN 0
  145. [1]     WHEN "osmc:symbol" LIKE 'blue:%' THEN 1
  146. [1]     WHEN "osmc:symbol" LIKE 'green:%' THEN 2
  147. [1]     WHEN "osmc:symbol" LIKE 'yellow:%' THEN 3
  148. [1]     WHEN "osmc:symbol" LIKE 'black:%' THEN 4
  149. [1]     WHEN "osmc:symbol" LIKE 'white:%' THEN 5
  150. [1]     WHEN "osmc:symbol" LIKE 'orange:%' THEN 6
  151. [1]     WHEN "osmc:symbol" LIKE 'violet:%' THEN 7
  152. [1]     WHEN "osmc:symbol" LIKE 'purple:%' THEN 7
  153. [1]     WHEN colour = 'red' THEN 0
  154. [1]     WHEN colour = 'blue' THEN 1
  155. [1]     WHEN colour = 'green' THEN 2
  156. [1]     WHEN colour = 'yellow' THEN 3
  157. [1]     WHEN colour = 'black' THEN 4
  158. [1]     WHEN colour = 'white' THEN 5
  159. [1]     WHEN colour = 'orange' THEN 6
  160. [1]     WHEN colour = 'violet' THEN 7
  161. [1]     WHEN colour = 'purple' THEN 7
  162. [1]     ELSE 8
  163. [1]   END
  164. [1]
  165. [1]             ELSE
  166. [1]               1000
  167. [1]             END
  168. [1]         ))) AS arr2
  169. [1]       FROM osm_route_members JOIN osm_routes ON (osm_route_members.osm_id = osm_routes.osm_id AND state <> 'proposed')
  170. [1]       WHERE network IN ('iwn','icn') AND geometry && ST_MakeEnvelope(-3.402823466385289e+38,-3.402823466385289e+38,3.402823466385289e+38,3.402823466385289e+38,3857)
  171. [1]       GROUP BY member
  172. [1]     ) AS aaa
  173. [1]     GROUP BY
  174. [1]       h_red, h_blue, h_green, h_yellow, h_black, h_white, h_orange, h_purple, h_none,
  175. [1]       h_red_loc, h_blue_loc, h_green_loc, h_yellow_loc, h_black_loc, h_white_loc, h_orange_loc, h_purple_loc, h_none_loc,
  176. [1]       b_red, b_blue, b_green, b_yellow, b_black, b_white, b_orange, b_purple, b_none,
  177. [1]       s_red, s_blue, s_green, s_yellow, s_black, s_white, s_orange, s_purple, s_none,
  178. [1]       r_red, r_blue, r_green, r_yellow, r_black, r_white, r_orange, r_purple, r_none,
  179. [1]       off1, off2, refs1, refs2
  180. [1]   ) AS foo LIMIT 0'
  181. [1]   encountered during parsing of layer 'Unnamed' in Layer]
  182. [1] Error in cleanupOutOfBoundTiles: [Error: ENOENT: no such file or directory, scandir 'tiles'] {
  183. [1]   errno: -2,
  184. [1]   code: 'ENOENT',
  185. [1]   syscall: 'scandir',
  186. [1]   path: 'tiles'
  187. [1] }
  188.  

odpowiedź "Bez tytułu"

Tutaj możesz odpowiedzieć na wklejkę z góry

captcha