Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT distinct on(B.id) B.id,
- sum("count") OVER (PARTITION BY B.id) as point_count
- FROM P1
- INNER JOIN LATERAL (SELECT id FROM T1 ORDER BY P1.wkb_geometry <->
- T1.wkb_geometry LIMIT 1) B
- ON TRUE
Add Comment
Please, Sign In to add comment