{"guid":"59094ca3-e1f1-5b85-b233-d98777b557e0","title":"20 Jahre PostGIS - dazu 20 hilfreiche Tipps zu PostGIS und Neuigkeiten rund um das Projekt","subtitle":null,"slug":"fossgis2021-9040-20-jahre-postgis-dazu-20-hilfreiche-tipps-zu-postgis-und-neuigkeiten-rund-um-das-projekt","link":"https://pretalx.com/fossgis2021/talk/NL3FAN/","description":"PostGIS wird in diesem Jahr 20 Jahre alt. Dazu gibt es 20 hilfreiche Tipps rund um PostGIS - mehr wird noch nicht verraten.\nDann werden die Neuerungen der PostGIS-Version 3.1 Version, auf die die PostGIS Welt eine Weile gewartet hat vorgestellt.\n\nMit PostGIS 3.1 hat sich auch die GEOS Version geändert und hexagonale und quadratische Grids können erstellt werden. Dann geht der Blick ins Umfeld von PostGIS und die zwei Softwareprojeke pg_tileserv und pg_featureserv werden vorgestellt.","original_language":"deu","persons":["Astrid Emde"],"view_count":343,"promoted":false,"date":"2021-06-07T16:00:00.000+02:00","release_date":"2021-06-07T00:00:00.000+02:00","updated_at":"2026-03-19T12:30:09.501+01:00","tags":["fossgis2021","9040","2021","Neuigkeiten aus den Open-Source-Projekten","Geo","OpenStreeetMap","FOSS","Online"],"length":2814,"duration":2814,"thumb_url":"https://static.media.ccc.de/media/events/fossgis/2021/9040-59094ca3-e1f1-5b85-b233-d98777b557e0.jpg","poster_url":"https://static.media.ccc.de/media/events/fossgis/2021/9040-59094ca3-e1f1-5b85-b233-d98777b557e0_preview.jpg","timeline_url":"https://static.media.ccc.de/media/events/fossgis/2021/9040-59094ca3-e1f1-5b85-b233-d98777b557e0.timeline.jpg","thumbnails_url":"https://static.media.ccc.de/media/events/fossgis/2021/9040-59094ca3-e1f1-5b85-b233-d98777b557e0.thumbnails.vtt","frontend_link":"https://media.ccc.de/v/fossgis2021-9040-20-jahre-postgis-dazu-20-hilfreiche-tipps-zu-postgis-und-neuigkeiten-rund-um-das-projekt","url":"https://api.media.ccc.de/public/events/59094ca3-e1f1-5b85-b233-d98777b557e0","conference_title":"FOSSGIS 2021","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2021","related":[],"recordings":[{"size":189,"length":2814,"mime_type":"video/webm","language":"deu","filename":"fossgis2021-9040-deu-20_Jahre_PostGIS_-_dazu_20_hilfreiche_Tipps_zu_PostGIS_und_Neuigkeiten_rund_um_das_Projekt_webm-hd.webm","state":"new","folder":"webm-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2021-06-07T23:36:08.918+02:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2021/webm-hd/fossgis2021-9040-deu-20_Jahre_PostGIS_-_dazu_20_hilfreiche_Tipps_zu_PostGIS_und_Neuigkeiten_rund_um_das_Projekt_webm-hd.webm","url":"https://api.media.ccc.de/public/recordings/53405","event_url":"https://api.media.ccc.de/public/events/59094ca3-e1f1-5b85-b233-d98777b557e0","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2021"},{"size":94,"length":2814,"mime_type":"video/webm","language":"deu","filename":"fossgis2021-9040-deu-20_Jahre_PostGIS_-_dazu_20_hilfreiche_Tipps_zu_PostGIS_und_Neuigkeiten_rund_um_das_Projekt_webm-sd.webm","state":"new","folder":"webm-sd","high_quality":false,"width":720,"height":576,"updated_at":"2021-06-07T23:08:07.351+02:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2021/webm-sd/fossgis2021-9040-deu-20_Jahre_PostGIS_-_dazu_20_hilfreiche_Tipps_zu_PostGIS_und_Neuigkeiten_rund_um_das_Projekt_webm-sd.webm","url":"https://api.media.ccc.de/public/recordings/53404","event_url":"https://api.media.ccc.de/public/events/59094ca3-e1f1-5b85-b233-d98777b557e0","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2021"},{"size":68,"length":2814,"mime_type":"video/mp4","language":"deu","filename":"fossgis2021-9040-deu-20_Jahre_PostGIS_-_dazu_20_hilfreiche_Tipps_zu_PostGIS_und_Neuigkeiten_rund_um_das_Projekt_sd.mp4","state":"new","folder":"h264-sd","high_quality":false,"width":720,"height":576,"updated_at":"2021-06-07T22:33:35.736+02:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2021/h264-sd/fossgis2021-9040-deu-20_Jahre_PostGIS_-_dazu_20_hilfreiche_Tipps_zu_PostGIS_und_Neuigkeiten_rund_um_das_Projekt_sd.mp4","url":"https://api.media.ccc.de/public/recordings/53403","event_url":"https://api.media.ccc.de/public/events/59094ca3-e1f1-5b85-b233-d98777b557e0","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2021"},{"size":42,"length":2804,"mime_type":"audio/mpeg","language":"deu","filename":"fossgis2021-9040-deu-20_Jahre_PostGIS_-_dazu_20_hilfreiche_Tipps_zu_PostGIS_und_Neuigkeiten_rund_um_das_Projekt_mp3.mp3","state":"new","folder":"mp3","high_quality":false,"width":0,"height":0,"updated_at":"2021-06-07T22:30:04.636+02:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2021/mp3/fossgis2021-9040-deu-20_Jahre_PostGIS_-_dazu_20_hilfreiche_Tipps_zu_PostGIS_und_Neuigkeiten_rund_um_das_Projekt_mp3.mp3","url":"https://api.media.ccc.de/public/recordings/53402","event_url":"https://api.media.ccc.de/public/events/59094ca3-e1f1-5b85-b233-d98777b557e0","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2021"},{"size":30,"length":2804,"mime_type":"audio/opus","language":"deu","filename":"fossgis2021-9040-deu-20_Jahre_PostGIS_-_dazu_20_hilfreiche_Tipps_zu_PostGIS_und_Neuigkeiten_rund_um_das_Projekt_opus.opus","state":"new","folder":"opus","high_quality":false,"width":0,"height":0,"updated_at":"2021-06-07T22:28:44.812+02:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2021/opus/fossgis2021-9040-deu-20_Jahre_PostGIS_-_dazu_20_hilfreiche_Tipps_zu_PostGIS_und_Neuigkeiten_rund_um_das_Projekt_opus.opus","url":"https://api.media.ccc.de/public/recordings/53401","event_url":"https://api.media.ccc.de/public/events/59094ca3-e1f1-5b85-b233-d98777b557e0","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2021"},{"size":131,"length":2814,"mime_type":"video/mp4","language":"deu","filename":"fossgis2021-9040-deu-20_Jahre_PostGIS_-_dazu_20_hilfreiche_Tipps_zu_PostGIS_und_Neuigkeiten_rund_um_das_Projekt_hd.mp4","state":"new","folder":"h264-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2021-06-07T22:26:28.636+02:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2021/h264-hd/fossgis2021-9040-deu-20_Jahre_PostGIS_-_dazu_20_hilfreiche_Tipps_zu_PostGIS_und_Neuigkeiten_rund_um_das_Projekt_hd.mp4","url":"https://api.media.ccc.de/public/recordings/53400","event_url":"https://api.media.ccc.de/public/events/59094ca3-e1f1-5b85-b233-d98777b557e0","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2021"}]}