{"guid":"76f90f6e-bf2c-5207-8ea6-4c52d5fb9f78","title":"PostGIS ST_Letters - Worte sagen manchmal mehr","subtitle":null,"slug":"fossgis2026-83718-postgis-stletters-worte-sagen-manchmal-mehr","link":"https://pretalx.com/fossgis2026/talk/AXWCQT/","description":"Warum nach Geodaten suchen, wo es doch die PostGIS-Funktion ST_Letters gibt, die im Nu Geometrien erzeugt?\n\nST_Letters ist eine recht unbekannte Funktion, die einen Text übergeben bekommt und diesen als Geometrie ausgibt. Genauer wird die Zeichenfolge von ST_Letters als Multipolygon ausgegeben. \n\nhttps://postgis.net/docs/ST_Letters.html\n\nWarum nach Geodaten suchen, wo es doch die PostGIS-Funktion ST_Letters gibt, die im Nu Geometrien erzeugt?\n\nST_Letters ist eine recht unbekannte Funktion, die einen Text übergeben bekommt und diesen als Geometrie ausgibt. Genauer wird die Zeichenfolge von ST_Letters als Multipolygon ausgegeben. \n\nSie haben gerade keine Geometrien zur Hand? Dann können Sie mit ST_Letters leicht Geometrien erzeugen und weitere PostGIS-Funktion ausprobieren.\n\nhttps://postgis.net/docs/ST_Letters.html\n\nLicensed to the public under https://creativecommons.org/licenses/by/4.0/","original_language":"deu","persons":["Astrid Emde"],"tags":["AXWCQT","2026","fossgis2026","Neuigkeiten und Interessantes aus den Open-Source-Projekten","HS3 (ZHG 009)","fossgis2026-deu","Day 3"],"view_count":53,"promoted":false,"date":"2026-03-26T15:25:00.000+01:00","release_date":"2026-03-26T00:00:00.000+01:00","updated_at":"2026-04-09T13:15:06.552+02:00","length":358,"duration":358,"thumb_url":"https://static.media.ccc.de/media/events/fossgis/2026/83718-76f90f6e-bf2c-5207-8ea6-4c52d5fb9f78.jpg","poster_url":"https://static.media.ccc.de/media/events/fossgis/2026/83718-76f90f6e-bf2c-5207-8ea6-4c52d5fb9f78_preview.jpg","timeline_url":"https://static.media.ccc.de/media/events/fossgis/2026/83718-76f90f6e-bf2c-5207-8ea6-4c52d5fb9f78.timeline.jpg","thumbnails_url":"https://static.media.ccc.de/media/events/fossgis/2026/83718-76f90f6e-bf2c-5207-8ea6-4c52d5fb9f78.thumbnails.vtt","frontend_link":"https://media.ccc.de/v/fossgis2026-83718-postgis-stletters-worte-sagen-manchmal-mehr","url":"https://api.media.ccc.de/public/events/76f90f6e-bf2c-5207-8ea6-4c52d5fb9f78","conference_title":"FOSSGIS 2026","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2026","related":[],"recordings":[{"size":49,"length":358,"mime_type":"video/webm;codecs=av01","language":"deu","filename":"fossgis2026-83718-deu-PostGIS_ST_Letters_-_Worte_sagen_manchmal_mehr_av1-hd.webm","state":"new","folder":"av1-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2026-04-03T15:26:08.887+02:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2026/av1-hd/fossgis2026-83718-deu-PostGIS_ST_Letters_-_Worte_sagen_manchmal_mehr_av1-hd.webm","url":"https://api.media.ccc.de/public/recordings/97071","event_url":"https://api.media.ccc.de/public/events/76f90f6e-bf2c-5207-8ea6-4c52d5fb9f78","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2026"},{"size":48,"length":358,"mime_type":"video/webm","language":"deu","filename":"fossgis2026-83718-deu-PostGIS_ST_Letters_-_Worte_sagen_manchmal_mehr_webm-hd.webm","state":"new","folder":"webm-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2026-04-03T15:23:47.812+02:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2026/webm-hd/fossgis2026-83718-deu-PostGIS_ST_Letters_-_Worte_sagen_manchmal_mehr_webm-hd.webm","url":"https://api.media.ccc.de/public/recordings/97076","event_url":"https://api.media.ccc.de/public/events/76f90f6e-bf2c-5207-8ea6-4c52d5fb9f78","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2026"},{"size":13,"length":358,"mime_type":"video/webm","language":"deu","filename":"fossgis2026-83718-deu-PostGIS_ST_Letters_-_Worte_sagen_manchmal_mehr_webm-sd.webm","state":"new","folder":"webm-sd","high_quality":false,"width":720,"height":576,"updated_at":"2026-04-03T15:24:21.900+02:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2026/webm-sd/fossgis2026-83718-deu-PostGIS_ST_Letters_-_Worte_sagen_manchmal_mehr_webm-sd.webm","url":"https://api.media.ccc.de/public/recordings/97068","event_url":"https://api.media.ccc.de/public/events/76f90f6e-bf2c-5207-8ea6-4c52d5fb9f78","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2026"},{"size":5,"length":358,"mime_type":"audio/mpeg","language":"deu","filename":"fossgis2026-83718-deu-PostGIS_ST_Letters_-_Worte_sagen_manchmal_mehr_mp3.mp3","state":"new","folder":"mp3","high_quality":false,"width":0,"height":0,"updated_at":"2026-04-03T15:21:18.357+02:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2026/mp3/fossgis2026-83718-deu-PostGIS_ST_Letters_-_Worte_sagen_manchmal_mehr_mp3.mp3","url":"https://api.media.ccc.de/public/recordings/97064","event_url":"https://api.media.ccc.de/public/events/76f90f6e-bf2c-5207-8ea6-4c52d5fb9f78","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2026"},{"size":3,"length":358,"mime_type":"audio/opus","language":"deu","filename":"fossgis2026-83718-deu-PostGIS_ST_Letters_-_Worte_sagen_manchmal_mehr_opus.opus","state":"new","folder":"opus","high_quality":false,"width":0,"height":0,"updated_at":"2026-04-03T15:20:53.311+02:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2026/opus/fossgis2026-83718-deu-PostGIS_ST_Letters_-_Worte_sagen_manchmal_mehr_opus.opus","url":"https://api.media.ccc.de/public/recordings/97063","event_url":"https://api.media.ccc.de/public/events/76f90f6e-bf2c-5207-8ea6-4c52d5fb9f78","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2026"},{"size":17,"length":358,"mime_type":"video/mp4","language":"deu","filename":"fossgis2026-83718-deu-PostGIS_ST_Letters_-_Worte_sagen_manchmal_mehr_sd.mp4","state":"new","folder":"h264-sd","high_quality":false,"width":720,"height":576,"updated_at":"2026-04-03T15:21:14.831+02:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2026/h264-sd/fossgis2026-83718-deu-PostGIS_ST_Letters_-_Worte_sagen_manchmal_mehr_sd.mp4","url":"https://api.media.ccc.de/public/recordings/97062","event_url":"https://api.media.ccc.de/public/events/76f90f6e-bf2c-5207-8ea6-4c52d5fb9f78","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2026"},{"size":84,"length":358,"mime_type":"video/mp4","language":"deu","filename":"fossgis2026-83718-deu-PostGIS_ST_Letters_-_Worte_sagen_manchmal_mehr_hd.mp4","state":"new","folder":"h264-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2026-04-03T15:20:44.540+02:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2026/h264-hd/fossgis2026-83718-deu-PostGIS_ST_Letters_-_Worte_sagen_manchmal_mehr_hd.mp4","url":"https://api.media.ccc.de/public/recordings/97051","event_url":"https://api.media.ccc.de/public/events/76f90f6e-bf2c-5207-8ea6-4c52d5fb9f78","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2026"}]}