Skip to content

Instantly share code, notes, and snippets.

@booo
Created October 30, 2011 13:21
Show Gist options
  • Select an option

  • Save booo/1325891 to your computer and use it in GitHub Desktop.

Select an option

Save booo/1325891 to your computer and use it in GitHub Desktop.
SELECT ST_AsText(ST_Polygonize(linestring)) AS GEOM FROM (
SELECT linestring FROM ways, relations, relation_members
WHERE
relations.id = 162902
AND
relations.id = relation_members.relation_id
AND
ways.id = relation_members.member_id
ORDER BY relation_members.sequence_id
) AS foo;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment