Skip to content

Instantly share code, notes, and snippets.

@fujimura

fujimura/st_astext_empty.sql

Created December 26, 2017 10:10
Show Gist options
  • Save fujimura/67f490b8fafdfe63c83a0baa6bb4a1b3 to your computer and use it in GitHub Desktop.
Save fujimura/67f490b8fafdfe63c83a0baa6bb4a1b3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
st_astext_empty.sql
SELECT
ST_ASText(
ST_GeometryN(
ST_GeneratePoints(
ST_GeomFromText('MULTIPOLYGON (((102.7687 35.07, 104.4969 35.07, 104.4969 35.06, 102.7687 35.06, 102.7687 35.07)))', 4326),
1
),
1
)
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment