Advertisement
Guest User

Untitled

a guest
Jun 24th, 2019
153
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.97 KB | None | 0 0
  1. select st_numpoints(ST_Subdivide(wkb_geometry, 200)) from (select wkb_geometry from contour where st_numpoints(wkb_geometry) > 5000 limit 1) as foo;
  2.  
  3. st_numpoints
  4. --------------
  5. 2
  6. 80
  7. 158
  8. 19
  9. 99
  10. 93
  11. 142
  12. 2
  13. 92
  14. 125
  15. 20
  16. 132
  17. 132
  18. 6
  19. 126
  20. 51
  21. 182
  22. 191
  23. 101
  24. 2
  25. 145
  26. 78
  27. 21
  28. 77
  29. 31
  30. 77
  31. 170
  32. 153
  33. 106
  34. 11
  35. 25
  36. 85
  37. 106
  38. 91
  39. 38
  40. 124
  41. 37
  42. 174
  43. 179
  44. 7
  45. 82
  46. 40
  47. 90
  48. 11
  49. 69
  50. 2
  51. 113
  52. 114
  53. 4
  54. 153
  55. 130
  56. 87
  57. 145
  58. 69
  59. ...
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement