Advertisement
Guest User

Untitled

a guest
Jun 19th, 2019
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.22 KB | None | 0 0
  1. street1, pages: 1,2
  2. street2, pages: 2,3
  3.  
  4. or
  5.  
  6. page1, streets: 1,2,3,5
  7. page2, streets: 2,4,5,6
  8.  
  9. select page.number, street.number, street.name
  10. from
  11. street, page
  12. where
  13. ST_INTERSECTS(street.geom, page.geom)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement