Advertisement
Guest User

Untitled

a guest
Feb 8th, 2016
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1. SELECT polygon.id,
  2. polygon.lib, -- Place here any field releveant for you (they must also be in grouping clauses, see below)
  3. group_concat(line.id,',') as list_id_line -- this function concatenate the id of every line that touch you polygon
  4. FROM polygon LEFT OUTER JOIN line
  5. ON Intersects(polygon.geom,line.geom) -- Spatial Dabatabase Rule !
  6. GROUP BY polygon.id, polygon.lib -- theses are the grouping clauses
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement