Skip to content

Instantly share code, notes, and snippets.

@giacecco
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.
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