API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 30th, 2017
69
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.05 KB | None | 0 0
raw download clone embed print report
  1. {
  2. "type": "FeatureCollection",
  3. "crs": { "type": "name", "properties": { "name": "urn:ogc:def:crs:OGC:1.3:CRS84" } },
  4.  
  5. "features": [
  6. { "type": "Feature", "properties": { "id": 433775, "clazz": 72, "flags": 7, "source": 26697, "target": 48416, "kmh": 10, "time": 1 }, "geometry": { "type": "LineString", "coordinates": [ [ 13.3782144, 52.516451399999973, 0.0 ], [ 13.3782407, 52.5163161, 0.0 ] ] } },
  7. { /* [... around 13k features ...] */ },
  8. { "type": "Feature", "properties": { "id": 377768, "clazz": 51, "flags": 7, "source": 270569, "target": 270570, "kmh": 5, "time": 600 }, "geometry": { "type": "LineString", "coordinates": [ [ 13.388153799999985, 52.492538299999971, 0.0 ], [ 13.3881033, 52.4924441, 0.0 ] ] } }
  9. ]
  10. }
  11.  
  12. ./12/2200/1343.json
  13. ./12/2200/1344.json
  14. [...]
  15. ./14/8800/5372.json
  16. ./14/8800/5373.json
  17.  
  18. #!/usr/bin/env ruby
  19.  
  20. require 'mkmf'
  21. require 'fileutils'
  22. require './tiler/geojson.rb'
  23.  
  24. geojson_tiler = Tiler::GeoJson.new
  25.  
  26. geojson_tiler.set_basedir "/path/to/my/tiles"
  27.  
  28. geojson_tiler.debug true
  29.  
  30. connection = "'PG:host=localhost dbname=distance user=qwertyu password=asdfghj'"
  31. sql_query = "'SELECT id,flags,kmh,geom_way_web_mercator,time FROM streets WHERE time <= 600 ORDER BY time ASC'"
  32. geojson_tiler.setup_db connection, sql_query
  33.  
  34. (0..3).each do |zoom|
  35. geojson_tiler.write_tiles zoom
  36. end
  37.  
  38. geojson_tiler.write_tiles 8, 136, 138, 82, 84
  39.  
  40. /path/to/my/tiles/0/0/0.json
  41. /path/to/my/tiles/1/0/0.json
  42. /path/to/my/tiles/1/0/1.json
  43. /path/to/my/tiles/1/1/0.json
  44. /path/to/my/tiles/1/1/1.json
  45. /path/to/my/tiles/2/0/0.json
  46. /path/to/my/tiles/2/0/1.json
  47. /path/to/my/tiles/2/0/2.json
  48. /path/to/my/tiles/2/0/3.json
  49. /path/to/my/tiles/2/1/0.json
  50. /path/to/my/tiles/2/1/1.json
  51. /path/to/my/tiles/2/1/2.json
  52. /path/to/my/tiles/2/1/3.json
  53. /path/to/my/tiles/2/2/0.json
  54. /path/to/my/tiles/2/2/1.json
  55. /path/to/my/tiles/2/2/2.json
  56. /path/to/my/tiles/2/2/3.json
  57. /path/to/my/tiles/2/3/0.json
  58. /path/to/my/tiles/2/3/1.json
  59. /path/to/my/tiles/2/3/2.json
  60. /path/to/my/tiles/2/3/3.json
  61. /path/to/my/tiles/3/0/0.json
  62. /path/to/my/tiles/3/0/1.json
  63. /path/to/my/tiles/3/0/2.json
  64. /path/to/my/tiles/3/0/3.json
  65. /path/to/my/tiles/3/0/4.json
  66. /path/to/my/tiles/3/0/5.json
  67. /path/to/my/tiles/3/0/6.json
  68. /path/to/my/tiles/3/0/7.json
  69. /path/to/my/tiles/3/1/0.json
  70. /path/to/my/tiles/3/1/1.json
  71. /path/to/my/tiles/3/1/2.json
  72. /path/to/my/tiles/3/1/3.json
  73. /path/to/my/tiles/3/1/4.json
  74. /path/to/my/tiles/3/1/5.json
  75. /path/to/my/tiles/3/1/6.json
  76. /path/to/my/tiles/3/1/7.json
  77. /path/to/my/tiles/3/2/0.json
  78. /path/to/my/tiles/3/2/1.json
  79. /path/to/my/tiles/3/2/2.json
  80. /path/to/my/tiles/3/2/3.json
  81. /path/to/my/tiles/3/2/4.json
  82. /path/to/my/tiles/3/2/5.json
  83. /path/to/my/tiles/3/2/6.json
  84. /path/to/my/tiles/3/2/7.json
  85. /path/to/my/tiles/3/3/0.json
  86. /path/to/my/tiles/3/3/1.json
  87. /path/to/my/tiles/3/3/2.json
  88. /path/to/my/tiles/3/3/3.json
  89. /path/to/my/tiles/3/3/4.json
  90. /path/to/my/tiles/3/3/5.json
  91. /path/to/my/tiles/3/3/6.json
  92. /path/to/my/tiles/3/3/7.json
  93. /path/to/my/tiles/3/4/0.json
  94. /path/to/my/tiles/3/4/1.json
  95. /path/to/my/tiles/3/4/2.json
  96. /path/to/my/tiles/3/4/3.json
  97. /path/to/my/tiles/3/4/4.json
  98. /path/to/my/tiles/3/4/5.json
  99. /path/to/my/tiles/3/4/6.json
  100. /path/to/my/tiles/3/4/7.json
  101. /path/to/my/tiles/3/5/0.json
  102. /path/to/my/tiles/3/5/1.json
  103. /path/to/my/tiles/3/5/2.json
  104. /path/to/my/tiles/3/5/3.json
  105. /path/to/my/tiles/3/5/4.json
  106. /path/to/my/tiles/3/5/5.json
  107. /path/to/my/tiles/3/5/6.json
  108. /path/to/my/tiles/3/5/7.json
  109. /path/to/my/tiles/3/6/0.json
  110. /path/to/my/tiles/3/6/1.json
  111. /path/to/my/tiles/3/6/2.json
  112. /path/to/my/tiles/3/6/3.json
  113. /path/to/my/tiles/3/6/4.json
  114. /path/to/my/tiles/3/6/5.json
  115. /path/to/my/tiles/3/6/6.json
  116. /path/to/my/tiles/3/6/7.json
  117. /path/to/my/tiles/3/7/0.json
  118. /path/to/my/tiles/3/7/1.json
  119. /path/to/my/tiles/3/7/2.json
  120. /path/to/my/tiles/3/7/3.json
  121. /path/to/my/tiles/3/7/4.json
  122. /path/to/my/tiles/3/7/5.json
  123. /path/to/my/tiles/3/7/6.json
  124. /path/to/my/tiles/3/7/7.json
  125. /path/to/my/tiles/8/136/82.json
  126. /path/to/my/tiles/8/136/83.json
  127. /path/to/my/tiles/8/136/84.json
  128. /path/to/my/tiles/8/137/82.json
  129. /path/to/my/tiles/8/137/83.json
  130. /path/to/my/tiles/8/137/84.json
  131. /path/to/my/tiles/8/138/82.json
  132. /path/to/my/tiles/8/138/83.json
  133. /path/to/my/tiles/8/138/84.json
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!