{"guid":"4bc3aaf8-4ca2-524b-a197-d55ad8f46b3f","title":"Ideen zur Kartographische Generalisierung mit PostgreSQL und PostGIS","subtitle":null,"slug":"fossgis2022-14095-ideen-zur-kartographische-generalisierung-mit-postgresql-und-postgis","link":"https://pretalx.com/fossgis2022/talk/WXYHCQ/","description":"PostgreSQL bildet mit seiner räumlichen Erweiterung PostGIS die Grundlage für viele Webkarten und eignet sich hervorragend für die Verarbeitung von großen Datensätzen und damit für die Generalisierung. Anhand von OpenStreetMap-Daten sollen Ansätze für die Lösung von Generalisierungproblemen wie Auswahl und Vereinfachung mittels relativer Maße vorgestellt werden.\n\nPostgreSQL bildet mit seiner räumlichen Erweiterung PostGIS die Grundlage für viele Webkarten und eignet sich hervorragend für die Verarbeitung von großen Datensätzen und damit für die Generalisierung. Anhand von OpenStreetMap-Daten sollen Ansätze für die Lösung von Generalisierungproblemen wie Auswahl und Vereinfachung mittels relativer Maße vorgestellt werden.","original_language":"deu","persons":["Mathias Gröbe"],"tags":["fossgis2022","14095","2022","Kartographie und Visualisierung","Geo","OpenStreeetMap","FOSS","Online"],"view_count":164,"promoted":false,"date":"2022-03-09T16:00:00.000+01:00","release_date":"2022-03-16T00:00:00.000+01:00","updated_at":"2026-01-05T10:00:14.715+01:00","length":3271,"duration":3271,"thumb_url":"https://static.media.ccc.de/media/events/fossgis/2022/14095-4bc3aaf8-4ca2-524b-a197-d55ad8f46b3f.jpg","poster_url":"https://static.media.ccc.de/media/events/fossgis/2022/14095-4bc3aaf8-4ca2-524b-a197-d55ad8f46b3f_preview.jpg","timeline_url":"https://static.media.ccc.de/media/events/fossgis/2022/14095-4bc3aaf8-4ca2-524b-a197-d55ad8f46b3f.timeline.jpg","thumbnails_url":"https://static.media.ccc.de/media/events/fossgis/2022/14095-4bc3aaf8-4ca2-524b-a197-d55ad8f46b3f.thumbnails.vtt","frontend_link":"https://media.ccc.de/v/fossgis2022-14095-ideen-zur-kartographische-generalisierung-mit-postgresql-und-postgis","url":"https://api.media.ccc.de/public/events/4bc3aaf8-4ca2-524b-a197-d55ad8f46b3f","conference_title":"FOSSGIS 2022","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2022","related":[],"recordings":[{"size":398,"length":3271,"mime_type":"video/webm","language":"deu","filename":"fossgis2022-14095-deu-Ideen_zur_Kartographische_Generalisierung_mit_PostgreSQL_und_PostGIS_webm-hd.webm","state":"new","folder":"webm-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2022-03-16T02:37:48.808+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2022/webm-hd/fossgis2022-14095-deu-Ideen_zur_Kartographische_Generalisierung_mit_PostgreSQL_und_PostGIS_webm-hd.webm","url":"https://api.media.ccc.de/public/recordings/58433","event_url":"https://api.media.ccc.de/public/events/4bc3aaf8-4ca2-524b-a197-d55ad8f46b3f","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2022"},{"size":127,"length":3271,"mime_type":"video/webm","language":"deu","filename":"fossgis2022-14095-deu-Ideen_zur_Kartographische_Generalisierung_mit_PostgreSQL_und_PostGIS_webm-sd.webm","state":"new","folder":"webm-sd","high_quality":false,"width":720,"height":576,"updated_at":"2022-03-16T01:21:38.725+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2022/webm-sd/fossgis2022-14095-deu-Ideen_zur_Kartographische_Generalisierung_mit_PostgreSQL_und_PostGIS_webm-sd.webm","url":"https://api.media.ccc.de/public/recordings/58410","event_url":"https://api.media.ccc.de/public/events/4bc3aaf8-4ca2-524b-a197-d55ad8f46b3f","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2022"},{"size":107,"length":3271,"mime_type":"video/mp4","language":"deu","filename":"fossgis2022-14095-deu-Ideen_zur_Kartographische_Generalisierung_mit_PostgreSQL_und_PostGIS_sd.mp4","state":"new","folder":"h264-sd","high_quality":false,"width":720,"height":576,"updated_at":"2022-03-16T01:20:37.253+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2022/h264-sd/fossgis2022-14095-deu-Ideen_zur_Kartographische_Generalisierung_mit_PostgreSQL_und_PostGIS_sd.mp4","url":"https://api.media.ccc.de/public/recordings/58409","event_url":"https://api.media.ccc.de/public/events/4bc3aaf8-4ca2-524b-a197-d55ad8f46b3f","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2022"},{"size":49,"length":3264,"mime_type":"audio/mpeg","language":"deu","filename":"fossgis2022-14095-deu-Ideen_zur_Kartographische_Generalisierung_mit_PostgreSQL_und_PostGIS_mp3.mp3","state":"new","folder":"mp3","high_quality":false,"width":0,"height":0,"updated_at":"2022-03-16T01:14:13.619+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2022/mp3/fossgis2022-14095-deu-Ideen_zur_Kartographische_Generalisierung_mit_PostgreSQL_und_PostGIS_mp3.mp3","url":"https://api.media.ccc.de/public/recordings/58408","event_url":"https://api.media.ccc.de/public/events/4bc3aaf8-4ca2-524b-a197-d55ad8f46b3f","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2022"},{"size":30,"length":3264,"mime_type":"audio/opus","language":"deu","filename":"fossgis2022-14095-deu-Ideen_zur_Kartographische_Generalisierung_mit_PostgreSQL_und_PostGIS_opus.opus","state":"new","folder":"opus","high_quality":false,"width":0,"height":0,"updated_at":"2022-03-16T00:41:15.878+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2022/opus/fossgis2022-14095-deu-Ideen_zur_Kartographische_Generalisierung_mit_PostgreSQL_und_PostGIS_opus.opus","url":"https://api.media.ccc.de/public/recordings/58406","event_url":"https://api.media.ccc.de/public/events/4bc3aaf8-4ca2-524b-a197-d55ad8f46b3f","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2022"},{"size":366,"length":3271,"mime_type":"video/mp4","language":"deu","filename":"fossgis2022-14095-deu-Ideen_zur_Kartographische_Generalisierung_mit_PostgreSQL_und_PostGIS_hd.mp4","state":"new","folder":"h264-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2022-03-16T00:31:23.395+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2022/h264-hd/fossgis2022-14095-deu-Ideen_zur_Kartographische_Generalisierung_mit_PostgreSQL_und_PostGIS_hd.mp4","url":"https://api.media.ccc.de/public/recordings/58403","event_url":"https://api.media.ccc.de/public/events/4bc3aaf8-4ca2-524b-a197-d55ad8f46b3f","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2022"}]}