Skip to content

Instantly share code, notes, and snippets.

@gannebamm

gannebamm/st_makeline_3d.sql

Created January 3, 2018 17:53
Show Gist options
  • Save gannebamm/c9c89df4188b45c43de474219e778f6c to your computer and use it in GitHub Desktop.
Save gannebamm/c9c89df4188b45c43de474219e778f6c to your computer and use it in GitHub Desktop.
Download ZIP
ST_MakeLine for samplepoints - does not create 3d Lines
Raw
st_makeline_3d.sql
SELECT ST_MAKELINE(
(SELECT geom
FROM samplepoints_xyz
WHERE name = 'al_01'),
(SELECT geom
FROM samplepoints_xyz
WHERE name = 'sound_01')), 's1' AS sample
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment