{"guid":"1738e945-6794-5d6d-b4da-d91eacd8f301","title":"Kurven nach SQL MM/3 in PostGIS, GeoServer und QGIS: Eine runde Sache","subtitle":null,"slug":"fossgis2022-14057-kurven-nach-sql-mm-3-in-postgis-geoserver-und-qgis-eine-runde-sache","link":"https://pretalx.com/fossgis2022/talk/RXNLBY/","description":"Zusammenfassung (100 - 500 chars):\nNeben den klassischen eckigen Geometrietypen wie LINESTRING und POLYGON gibt es auch die Möglichkeit, Geometrien mit Kurven und Bögen zu definieren. Wir stellen die verschiedenen Geometrie-Standards vor und geben einen Praxis-Einblick, wie PostGIS, GeoServer und QGIS damit umgehen und welche Fallstricke es zu umschiffen gilt.\n\nDie Klassiker in der Geometrien-Landschaft sind die eckigen POINT, LINESTRING, POLYGON und deren MULTI-formen. Im Standard SQL MM, Part 3 werden daneben auch Typen für kurvige Geometrien definiert. Wir geben zunächst einen Überblick über die verschiedenen Geometrie-Typen nebst anschaulichen Beispielen.\nAus der Praxis zeigen wir, wie diese Geometrien in der PostGIS-Datenbank verwaltet werden können, wie sie mit QGIS bearbeitet werden können und schließlich mit dem GeoServer gerendert werden können.\nWir erwähnen ferner ein paar Probleme, über die wir gestolpert sind, und wie man sie vermeiden kann.","original_language":"deu","persons":["Björn Höfling"],"view_count":87,"promoted":false,"date":"2022-03-09T15:00:00.000+01:00","release_date":"2022-03-10T00:00:00.000+01:00","updated_at":"2026-04-22T13:30:04.693+02:00","tags":["fossgis2022","14057","2022","Daten, Datenbanken und Datenprozessierung","Geo","OpenStreeetMap","FOSS","Online"],"length":1555,"duration":1555,"thumb_url":"https://static.media.ccc.de/media/events/fossgis/2022/14057-1738e945-6794-5d6d-b4da-d91eacd8f301.jpg","poster_url":"https://static.media.ccc.de/media/events/fossgis/2022/14057-1738e945-6794-5d6d-b4da-d91eacd8f301_preview.jpg","timeline_url":"https://static.media.ccc.de/media/events/fossgis/2022/14057-1738e945-6794-5d6d-b4da-d91eacd8f301.timeline.jpg","thumbnails_url":"https://static.media.ccc.de/media/events/fossgis/2022/14057-1738e945-6794-5d6d-b4da-d91eacd8f301.thumbnails.vtt","frontend_link":"https://media.ccc.de/v/fossgis2022-14057-kurven-nach-sql-mm-3-in-postgis-geoserver-und-qgis-eine-runde-sache","url":"https://api.media.ccc.de/public/events/1738e945-6794-5d6d-b4da-d91eacd8f301","conference_title":"FOSSGIS 2022","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2022","related":[],"recordings":[{"size":23,"length":1548,"mime_type":"audio/mpeg","language":"deu","filename":"fossgis2022-14057-deu-Kurven_nach_SQL_MM_3_in_PostGIS_GeoServer_und_QGIS_Eine_runde_Sache_mp3.mp3","state":"new","folder":"mp3","high_quality":false,"width":0,"height":0,"updated_at":"2022-03-10T08:57:34.884+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2022/mp3/fossgis2022-14057-deu-Kurven_nach_SQL_MM_3_in_PostGIS_GeoServer_und_QGIS_Eine_runde_Sache_mp3.mp3","url":"https://api.media.ccc.de/public/recordings/57971","event_url":"https://api.media.ccc.de/public/events/1738e945-6794-5d6d-b4da-d91eacd8f301","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2022"},{"size":112,"length":1555,"mime_type":"video/webm","language":"deu","filename":"fossgis2022-14057-deu-Kurven_nach_SQL_MM_3_in_PostGIS_GeoServer_und_QGIS_Eine_runde_Sache_webm-hd.webm","state":"new","folder":"webm-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2022-03-10T08:50:38.126+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2022/webm-hd/fossgis2022-14057-deu-Kurven_nach_SQL_MM_3_in_PostGIS_GeoServer_und_QGIS_Eine_runde_Sache_webm-hd.webm","url":"https://api.media.ccc.de/public/recordings/57969","event_url":"https://api.media.ccc.de/public/events/1738e945-6794-5d6d-b4da-d91eacd8f301","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2022"},{"size":53,"length":1555,"mime_type":"video/webm","language":"deu","filename":"fossgis2022-14057-deu-Kurven_nach_SQL_MM_3_in_PostGIS_GeoServer_und_QGIS_Eine_runde_Sache_webm-sd.webm","state":"new","folder":"webm-sd","high_quality":false,"width":720,"height":576,"updated_at":"2022-03-10T08:39:35.821+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2022/webm-sd/fossgis2022-14057-deu-Kurven_nach_SQL_MM_3_in_PostGIS_GeoServer_und_QGIS_Eine_runde_Sache_webm-sd.webm","url":"https://api.media.ccc.de/public/recordings/57966","event_url":"https://api.media.ccc.de/public/events/1738e945-6794-5d6d-b4da-d91eacd8f301","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2022"},{"size":37,"length":1555,"mime_type":"video/mp4","language":"deu","filename":"fossgis2022-14057-deu-Kurven_nach_SQL_MM_3_in_PostGIS_GeoServer_und_QGIS_Eine_runde_Sache_sd.mp4","state":"new","folder":"h264-sd","high_quality":false,"width":720,"height":576,"updated_at":"2022-03-10T08:37:04.665+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2022/h264-sd/fossgis2022-14057-deu-Kurven_nach_SQL_MM_3_in_PostGIS_GeoServer_und_QGIS_Eine_runde_Sache_sd.mp4","url":"https://api.media.ccc.de/public/recordings/57965","event_url":"https://api.media.ccc.de/public/events/1738e945-6794-5d6d-b4da-d91eacd8f301","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2022"},{"size":16,"length":1548,"mime_type":"audio/opus","language":"deu","filename":"fossgis2022-14057-deu-Kurven_nach_SQL_MM_3_in_PostGIS_GeoServer_und_QGIS_Eine_runde_Sache_opus.opus","state":"new","folder":"opus","high_quality":false,"width":0,"height":0,"updated_at":"2022-03-10T08:36:03.452+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2022/opus/fossgis2022-14057-deu-Kurven_nach_SQL_MM_3_in_PostGIS_GeoServer_und_QGIS_Eine_runde_Sache_opus.opus","url":"https://api.media.ccc.de/public/recordings/57963","event_url":"https://api.media.ccc.de/public/events/1738e945-6794-5d6d-b4da-d91eacd8f301","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2022"},{"size":77,"length":1555,"mime_type":"video/mp4","language":"deu","filename":"fossgis2022-14057-deu-Kurven_nach_SQL_MM_3_in_PostGIS_GeoServer_und_QGIS_Eine_runde_Sache_hd.mp4","state":"new","folder":"h264-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2022-03-10T08:15:35.894+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2022/h264-hd/fossgis2022-14057-deu-Kurven_nach_SQL_MM_3_in_PostGIS_GeoServer_und_QGIS_Eine_runde_Sache_hd.mp4","url":"https://api.media.ccc.de/public/recordings/57961","event_url":"https://api.media.ccc.de/public/events/1738e945-6794-5d6d-b4da-d91eacd8f301","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2022"}]}