Guest User

osm2psql output

a guest
Aug 31st, 2017
435
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. osm2pgsql SVN version 0.88.1 (64bit id space)
  2.  
  3. Using lua based tag processing pipeline with script openstreetmap-carto.lua
  4. Using projection SRS 900913 (Spherical Mercator)
  5. Setting up table: planet_osm_point
  6. Setting up table: planet_osm_line
  7. Setting up table: planet_osm_polygon
  8. Setting up table: planet_osm_roads
  9. Allocating memory for dense node cache
  10. Allocating dense node cache in one big chunk
  11. Allocating memory for sparse node cache
  12. Sharing dense sparse
  13. Node-cache: cache=18000MB, maxblocks=2304000*8192, allocation method=11
  14. Mid: loading persistent node cache from /mnt/db/Tileserver/flatnode.bin
  15. Allocated space for persistent node cache file
  16. Maximum node in persistent node cache: 0
  17. Mid: pgsql, scale=100 cache=18000
  18. Setting up table: planet_osm_nodes
  19. Setting up table: planet_osm_ways
  20. Setting up table: planet_osm_rels
  21.  
  22. Reading in file: /mnt/db/planet.osm.pbf
  23. Processing: Node(4035672k 631.6k/s) Way(431724k 8.69k/s) Relation(5175690 159.05/s)  parse time: 88597s
  24. Node stats: total(4035672578), max(5047121925) in 6390s
  25. Way stats: total(431724615), max(517122423) in 49665s
  26. Relation stats: total(5175696), max(7492976) in 32542s
  27. Maximum node in persistent node cache: 5047844863
  28. Committing transaction for planet_osm_point
  29. Committing transaction for planet_osm_line
  30. Committing transaction for planet_osm_polygon
  31. Committing transaction for planet_osm_roads
  32. Mid: loading persistent node cache from /mnt/db/Tileserver/flatnode.bin
  33. Maximum node in persistent node cache: 5047844863
  34. Setting up table: planet_osm_nodes
  35. Setting up table: planet_osm_ways
  36. Setting up table: planet_osm_rels
  37. Using lua based tag processing pipeline with script openstreetmap-carto.lua
  38. Mid: loading persistent node cache from /mnt/db/Tileserver/flatnode.bin
  39. Maximum node in persistent node cache: 5047844863
  40. Setting up table: planet_osm_nodes
  41. Setting up table: planet_osm_ways
  42. Setting up table: planet_osm_rels
  43. Using lua based tag processing pipeline with script openstreetmap-carto.lua
  44. Mid: loading persistent node cache from /mnt/db/Tileserver/flatnode.bin
  45. Maximum node in persistent node cache: 5047844863
  46. Setting up table: planet_osm_nodes
  47. Setting up table: planet_osm_ways
  48. Setting up table: planet_osm_rels
  49. Using lua based tag processing pipeline with script openstreetmap-carto.lua
  50. Mid: loading persistent node cache from /mnt/db/Tileserver/flatnode.bin
  51. Maximum node in persistent node cache: 5047844863
  52. Setting up table: planet_osm_nodes
  53. Setting up table: planet_osm_ways
  54. Setting up table: planet_osm_rels
  55. Using lua based tag processing pipeline with script openstreetmap-carto.lua
  56. Mid: loading persistent node cache from /mnt/db/Tileserver/flatnode.bin
  57. Maximum node in persistent node cache: 5047844863
  58. Setting up table: planet_osm_nodes
  59. Setting up table: planet_osm_ways
  60. Setting up table: planet_osm_rels
  61. Using lua based tag processing pipeline with script openstreetmap-carto.lua
  62. Mid: loading persistent node cache from /mnt/db/Tileserver/flatnode.bin
  63. Maximum node in persistent node cache: 5047844863
  64. Setting up table: planet_osm_nodes
  65. Setting up table: planet_osm_ways
  66. Setting up table: planet_osm_rels
  67. Using lua based tag processing pipeline with script openstreetmap-carto.lua
  68. Mid: loading persistent node cache from /mnt/db/Tileserver/flatnode.bin
  69. Maximum node in persistent node cache: 5047844863
  70. Setting up table: planet_osm_nodes
  71. Setting up table: planet_osm_ways
  72. Setting up table: planet_osm_rels
  73. Using lua based tag processing pipeline with script openstreetmap-carto.lua
  74. Mid: loading persistent node cache from /mnt/db/Tileserver/flatnode.bin
  75. Maximum node in persistent node cache: 5047844863
  76. Setting up table: planet_osm_nodes
  77. Setting up table: planet_osm_ways
  78. Setting up table: planet_osm_rels
  79. Using lua based tag processing pipeline with script openstreetmap-carto.lua
  80. Mid: loading persistent node cache from /mnt/db/Tileserver/flatnode.bin
  81. Maximum node in persistent node cache: 5047844863
  82. Setting up table: planet_osm_nodes
  83. Setting up table: planet_osm_ways
  84. Setting up table: planet_osm_rels
  85. Using lua based tag processing pipeline with script openstreetmap-carto.lua
  86. Mid: loading persistent node cache from /mnt/db/Tileserver/flatnode.bin
  87. Maximum node in persistent node cache: 5047844863
  88. Setting up table: planet_osm_nodes
  89. Setting up table: planet_osm_ways
  90. Setting up table: planet_osm_rels
  91. Using lua based tag processing pipeline with script openstreetmap-carto.lua
  92.  
  93. Going over pending ways...
  94.     287961768 ways are pending
  95.  
  96. Using 10 helper-processes
  97. Finished processing 287961768 ways in 24511 sec
  98.  
  99. 287961768 Pending ways took 24511s at a rate of 11748.27/s
  100. Committing transaction for planet_osm_point
  101. Committing transaction for planet_osm_line
  102. Committing transaction for planet_osm_polygon
  103. Committing transaction for planet_osm_roads
  104. Committing transaction for planet_osm_point
  105. Committing transaction for planet_osm_line
  106. Committing transaction for planet_osm_polygon
  107. Committing transaction for planet_osm_roads
  108. Committing transaction for planet_osm_point
  109. Committing transaction for planet_osm_line
  110. Committing transaction for planet_osm_polygon
  111. Committing transaction for planet_osm_roads
  112. Committing transaction for planet_osm_point
  113. Committing transaction for planet_osm_line
  114. Committing transaction for planet_osm_polygon
  115. Committing transaction for planet_osm_roads
  116. Committing transaction for planet_osm_point
  117. Committing transaction for planet_osm_line
  118. Committing transaction for planet_osm_polygon
  119. Committing transaction for planet_osm_roads
  120. Committing transaction for planet_osm_point
  121. Committing transaction for planet_osm_line
  122. Committing transaction for planet_osm_polygon
  123. Committing transaction for planet_osm_roads
  124. Committing transaction for planet_osm_point
  125. Committing transaction for planet_osm_line
  126. Committing transaction for planet_osm_polygon
  127. Committing transaction for planet_osm_roads
  128. Committing transaction for planet_osm_point
  129. Committing transaction for planet_osm_line
  130. Committing transaction for planet_osm_polygon
  131. Committing transaction for planet_osm_roads
  132. Committing transaction for planet_osm_point
  133. Committing transaction for planet_osm_line
  134. Committing transaction for planet_osm_polygon
  135. Committing transaction for planet_osm_roads
  136. Committing transaction for planet_osm_point
  137. Committing transaction for planet_osm_line
  138. Committing transaction for planet_osm_polygon
  139. Committing transaction for planet_osm_roads
  140.  
  141. Going over pending relations...
  142.     0 relations are pending
  143.  
  144. Using 10 helper-processes
  145. Finished processing 0 relations in 0 sec
  146.  
  147. Committing transaction for planet_osm_point
  148. WARNING:  there is no transaction in progress
  149. Committing transaction for planet_osm_line
  150. WARNING:  there is no transaction in progress
  151. Committing transaction for planet_osm_polygon
  152. WARNING:  there is no transaction in progress
  153. Committing transaction for planet_osm_roads
  154. WARNING:  there is no transaction in progress
  155. Committing transaction for planet_osm_point
  156. WARNING:  there is no transaction in progress
  157. Committing transaction for planet_osm_line
  158. WARNING:  there is no transaction in progress
  159. Committing transaction for planet_osm_polygon
  160. WARNING:  there is no transaction in progress
  161. Committing transaction for planet_osm_roads
  162. WARNING:  there is no transaction in progress
  163. Committing transaction for planet_osm_point
  164. WARNING:  there is no transaction in progress
  165. Committing transaction for planet_osm_line
  166. WARNING:  there is no transaction in progress
  167. Committing transaction for planet_osm_polygon
  168. WARNING:  there is no transaction in progress
  169. Committing transaction for planet_osm_roads
  170. WARNING:  there is no transaction in progress
  171. Committing transaction for planet_osm_point
  172. WARNING:  there is no transaction in progress
  173. Committing transaction for planet_osm_line
  174. WARNING:  there is no transaction in progress
  175. Committing transaction for planet_osm_polygon
  176. WARNING:  there is no transaction in progress
  177. Committing transaction for planet_osm_roads
  178. WARNING:  there is no transaction in progress
  179. Committing transaction for planet_osm_point
  180. WARNING:  there is no transaction in progress
  181. Committing transaction for planet_osm_line
  182. WARNING:  there is no transaction in progress
  183. Committing transaction for planet_osm_polygon
  184. WARNING:  there is no transaction in progress
  185. Committing transaction for planet_osm_roads
  186. WARNING:  there is no transaction in progress
  187. Committing transaction for planet_osm_point
  188. WARNING:  there is no transaction in progress
  189. Committing transaction for planet_osm_line
  190. WARNING:  there is no transaction in progress
  191. Committing transaction for planet_osm_polygon
  192. WARNING:  there is no transaction in progress
  193. Committing transaction for planet_osm_roads
  194. WARNING:  there is no transaction in progress
  195. Committing transaction for planet_osm_point
  196. WARNING:  there is no transaction in progress
  197. Committing transaction for planet_osm_line
  198. WARNING:  there is no transaction in progress
  199. Committing transaction for planet_osm_polygon
  200. WARNING:  there is no transaction in progress
  201. Committing transaction for planet_osm_roads
  202. WARNING:  there is no transaction in progress
  203. Committing transaction for planet_osm_point
  204. WARNING:  there is no transaction in progress
  205. Committing transaction for planet_osm_line
  206. WARNING:  there is no transaction in progress
  207. Committing transaction for planet_osm_polygon
  208. WARNING:  there is no transaction in progress
  209. Committing transaction for planet_osm_roads
  210. WARNING:  there is no transaction in progress
  211. Committing transaction for planet_osm_point
  212. WARNING:  there is no transaction in progress
  213. Committing transaction for planet_osm_line
  214. WARNING:  there is no transaction in progress
  215. Committing transaction for planet_osm_polygon
  216. WARNING:  there is no transaction in progress
  217. Committing transaction for planet_osm_roads
  218. WARNING:  there is no transaction in progress
  219. Committing transaction for planet_osm_point
  220. WARNING:  there is no transaction in progress
  221. Committing transaction for planet_osm_line
  222. WARNING:  there is no transaction in progress
  223. Committing transaction for planet_osm_polygon
  224. WARNING:  there is no transaction in progress
  225. Committing transaction for planet_osm_roads
  226. WARNING:  there is no transaction in progress
  227. Sorting data and creating indexes for planet_osm_point
  228. Sorting data and creating indexes for planet_osm_line
  229. Sorting data and creating indexes for planet_osm_polygon
  230. Sorting data and creating indexes for planet_osm_roads
  231. Stopping table: planet_osm_nodes
  232. Stopping table: planet_osm_ways
  233. Building index on table: planet_osm_ways
  234. Stopping table: planet_osm_rels
  235. Building index on table: planet_osm_rels
  236. Stopped table: planet_osm_nodes in 0s
RAW Paste Data