{"guid":"a04687c3-a0e2-5487-927a-cc435396b8f6","title":"PostgreSQL und Postgis für Einsteiger","subtitle":null,"slug":"fossgis2026-84280-postgresql-und-postgis-fur-einsteiger","link":"https://pretalx.com/fossgis2026/talk/RHKSDK/","description":"Ein Einstieg in die Welt der Datenbanken. Der Vortrag gibt einen Überblick, was eine Datenbank überhaupt ist, erläutert die (für GIS-Anwendungen) wichtigsten Datentypen sowie die Erweiterungen durch Postgis und benennt einfache Beispiele für die Möglichkeiten, die das Werkzeug Postgis für die weitere Datenverarbeitung, insbesondere die Visualisierung mit QGIS, bietet.\n\nDer Vortrag richtet sich an Anfänger, die von SQL und Postgis bisher nur den Namen kennen. Er soll gerade für einen absoluten Anfänger verständlich und nachvollziehbar sein. \n\nVermittelt wird im Wesentlichen neben einem Überblick über die Technik der Datenbank und ihren Gestaltungsmöglichkeiten Verständnis für den Sinn eines Einsatzes von Postgis.\n\nDie Installation der Datenbank wird nicht thematisiert, da das je nach Betriebssystem stark variiert. Ausgegangen wird von einer Datenbank, wie sie osm2pgsql für den Anwender bereitstellt.\n\nLicensed to the public under https://creativecommons.org/licenses/by/4.0/","original_language":"deu","persons":["Wolfgang Hinsch"],"tags":["RHKSDK","2026","fossgis2026","Daten, Datenbanken und Datenprozessierung","HS3 (ZHG 009)","fossgis2026-deu","Day 2"],"view_count":378,"promoted":false,"date":"2026-03-25T17:40:00.000+01:00","release_date":"2026-03-25T00:00:00.000+01:00","updated_at":"2026-04-16T11:30:06.558+02:00","length":1512,"duration":1512,"thumb_url":"https://static.media.ccc.de/media/events/fossgis/2026/84280-a04687c3-a0e2-5487-927a-cc435396b8f6.jpg","poster_url":"https://static.media.ccc.de/media/events/fossgis/2026/84280-a04687c3-a0e2-5487-927a-cc435396b8f6_preview.jpg","timeline_url":"https://static.media.ccc.de/media/events/fossgis/2026/84280-a04687c3-a0e2-5487-927a-cc435396b8f6.timeline.jpg","thumbnails_url":"https://static.media.ccc.de/media/events/fossgis/2026/84280-a04687c3-a0e2-5487-927a-cc435396b8f6.thumbnails.vtt","frontend_link":"https://media.ccc.de/v/fossgis2026-84280-postgresql-und-postgis-fur-einsteiger","url":"https://api.media.ccc.de/public/events/a04687c3-a0e2-5487-927a-cc435396b8f6","conference_title":"FOSSGIS 2026","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2026","related":[],"recordings":[{"size":168,"length":1512,"mime_type":"video/webm;codecs=av01","language":"deu","filename":"fossgis2026-84280-deu-PostgreSQL_und_Postgis_fuer_Einsteiger_av1-hd.webm","state":"new","folder":"av1-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2026-03-25T19:08:53.097+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2026/av1-hd/fossgis2026-84280-deu-PostgreSQL_und_Postgis_fuer_Einsteiger_av1-hd.webm","url":"https://api.media.ccc.de/public/recordings/96762","event_url":"https://api.media.ccc.de/public/events/a04687c3-a0e2-5487-927a-cc435396b8f6","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2026"},{"size":62,"length":1512,"mime_type":"video/webm","language":"deu","filename":"fossgis2026-84280-deu-PostgreSQL_und_Postgis_fuer_Einsteiger_webm-sd.webm","state":"new","folder":"webm-sd","high_quality":false,"width":720,"height":576,"updated_at":"2026-03-25T19:24:32.221+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2026/webm-sd/fossgis2026-84280-deu-PostgreSQL_und_Postgis_fuer_Einsteiger_webm-sd.webm","url":"https://api.media.ccc.de/public/recordings/96780","event_url":"https://api.media.ccc.de/public/events/a04687c3-a0e2-5487-927a-cc435396b8f6","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2026"},{"size":182,"length":1512,"mime_type":"video/webm","language":"deu","filename":"fossgis2026-84280-deu-PostgreSQL_und_Postgis_fuer_Einsteiger_webm-hd.webm","state":"new","folder":"webm-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2026-03-25T19:18:50.477+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2026/webm-hd/fossgis2026-84280-deu-PostgreSQL_und_Postgis_fuer_Einsteiger_webm-hd.webm","url":"https://api.media.ccc.de/public/recordings/96773","event_url":"https://api.media.ccc.de/public/events/a04687c3-a0e2-5487-927a-cc435396b8f6","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2026"},{"size":57,"length":1512,"mime_type":"video/mp4","language":"deu","filename":"fossgis2026-84280-deu-PostgreSQL_und_Postgis_fuer_Einsteiger_sd.mp4","state":"new","folder":"h264-sd","high_quality":false,"width":720,"height":576,"updated_at":"2026-03-25T19:05:56.608+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2026/h264-sd/fossgis2026-84280-deu-PostgreSQL_und_Postgis_fuer_Einsteiger_sd.mp4","url":"https://api.media.ccc.de/public/recordings/96754","event_url":"https://api.media.ccc.de/public/events/a04687c3-a0e2-5487-927a-cc435396b8f6","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2026"},{"size":23,"length":1512,"mime_type":"audio/mpeg","language":"deu","filename":"fossgis2026-84280-deu-PostgreSQL_und_Postgis_fuer_Einsteiger_mp3.mp3","state":"new","folder":"mp3","high_quality":false,"width":0,"height":0,"updated_at":"2026-03-25T19:05:48.451+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2026/mp3/fossgis2026-84280-deu-PostgreSQL_und_Postgis_fuer_Einsteiger_mp3.mp3","url":"https://api.media.ccc.de/public/recordings/96752","event_url":"https://api.media.ccc.de/public/events/a04687c3-a0e2-5487-927a-cc435396b8f6","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2026"},{"size":14,"length":1512,"mime_type":"audio/opus","language":"deu","filename":"fossgis2026-84280-deu-PostgreSQL_und_Postgis_fuer_Einsteiger_opus.opus","state":"new","folder":"opus","high_quality":false,"width":0,"height":0,"updated_at":"2026-03-25T19:05:40.022+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2026/opus/fossgis2026-84280-deu-PostgreSQL_und_Postgis_fuer_Einsteiger_opus.opus","url":"https://api.media.ccc.de/public/recordings/96750","event_url":"https://api.media.ccc.de/public/events/a04687c3-a0e2-5487-927a-cc435396b8f6","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2026"},{"size":197,"length":1512,"mime_type":"video/mp4","language":"deu","filename":"fossgis2026-84280-deu-PostgreSQL_und_Postgis_fuer_Einsteiger_hd.mp4","state":"new","folder":"h264-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2026-03-25T19:05:16.342+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2026/h264-hd/fossgis2026-84280-deu-PostgreSQL_und_Postgis_fuer_Einsteiger_hd.mp4","url":"https://api.media.ccc.de/public/recordings/96746","event_url":"https://api.media.ccc.de/public/events/a04687c3-a0e2-5487-927a-cc435396b8f6","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2026"}]}