Guest User

Untitled

a guest
Apr 23rd, 2018
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.50 KB | None | 0 0
  1. SELECT COUNT(ST_Contains(a.location, b.location))
  2. FROM wards a, cycle_stations b;
  3.  
  4. ERROR: Unknown geometry type: 13 - PolyhedralSurface
  5.  
  6. SELECT
  7. ST_AStext(
  8. ST_Extent(
  9. ST_Force3d(
  10. ST_Extrude(
  11. ST_Expand(
  12. ST_MakePoint(0,0),
  13. 10, 10),
  14. 0, 0, 20)
  15. )
  16. )
  17. );
  18.  
  19. SELECT
  20. a.name,
  21. COUNT(b.location)
  22. FROM
  23. wards a, cycle_stations b
  24. WHERE ST_Contains(a.location, b.location);
Add Comment
Please, Sign In to add comment