Skip to content

Instantly share code, notes, and snippets.

@giacecco

giacecco/3.sql

Created August 9, 2015 17:38
Show Gist options
  • Save giacecco/d30f1d6749aefa0cb74e to your computer and use it in GitHub Desktop.
Save giacecco/d30f1d6749aefa0cb74e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
3.sql
SELECT lr_town, ST_Union(mbr) AS geom
FROM os_open_names_with_towns
WHERE type = 'transportNetwork' AND lr_town = 'SOUTHAMPTON'
GROUP BY lr_town
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment