{"guid":"05a3b34b-338f-5e86-b71e-8ba2b7019bc3","title":"Füge Geokoordinaten zu deinen Adressen in PostgreSQL hinzu","subtitle":null,"slug":"clt24-126-fuge-geokoordinaten-zu-deinen-adressen-in-postgresql-hinzu","link":"https://chemnitzer.linux-tage.de/2024/de/programm/beitrag/126","description":"Geolokalisierungsdaten sind ein heißes Thema. Zu vielen Daten gehört eine Adresse, ein Straßenname, eine Postleitzahl und ein Land. Aber wo genau ist diese Adresse? Und was befindet sich in der Nähe dieser Adresse?\n\nUm diese Fragen zu lösen, müssen Adressen in Geokoordinaten aufgelöst werden. Je besser und genauer die Adressdaten sind, desto größer ist die Chance, die richtigen Koordinaten zu finden.\n\nDieser Vortrag zeigt, wie Adressen mithilfe von OpenSteetMap-Daten aus der Datenbank heraus mithilfe von Python-Funktionen aufgelöst werden können.\n\nWir sprechen auch über die Genauigkeit der Daten, indem wir die Ergebnisse verschiedener Adressformate mit bekannten Koordinaten vergleichen.","original_language":"deu","persons":["Andreas Scherbaum"],"view_count":117,"promoted":false,"date":"2024-03-16T12:30:00.000+01:00","release_date":"2024-03-16T00:00:00.000+01:00","updated_at":"2026-01-15T16:15:10.980+01:00","tags":["clt24","126","2024","Vortrag"],"length":2737,"duration":2737,"thumb_url":"https://static.media.ccc.de/media/events/clt/2024/126-05a3b34b-338f-5e86-b71e-8ba2b7019bc3.jpg","poster_url":"https://static.media.ccc.de/media/events/clt/2024/126-05a3b34b-338f-5e86-b71e-8ba2b7019bc3_preview.jpg","timeline_url":"https://static.media.ccc.de/media/events/clt/2024/126-05a3b34b-338f-5e86-b71e-8ba2b7019bc3.timeline.jpg","thumbnails_url":"https://static.media.ccc.de/media/events/clt/2024/126-05a3b34b-338f-5e86-b71e-8ba2b7019bc3.thumbnails.vtt","frontend_link":"https://media.ccc.de/v/clt24-126-fuge-geokoordinaten-zu-deinen-adressen-in-postgresql-hinzu","url":"https://api.media.ccc.de/public/events/05a3b34b-338f-5e86-b71e-8ba2b7019bc3","conference_title":"Chemnitzer Linux-Tage 2024","conference_url":"https://api.media.ccc.de/public/conferences/clt24","related":[],"recordings":[{"size":225,"length":2737,"mime_type":"video/webm","language":"deu","filename":"clt24-126-deu-Fuege_Geokoordinaten_zu_deinen_Adressen_in_PostgreSQL_hinzu_webm-hd.webm","state":"new","folder":"webm-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2024-03-16T19:04:47.860+01:00","recording_url":"https://cdn.media.ccc.de/events/clt/2024/webm-hd/clt24-126-deu-Fuege_Geokoordinaten_zu_deinen_Adressen_in_PostgreSQL_hinzu_webm-hd.webm","url":"https://api.media.ccc.de/public/recordings/75534","event_url":"https://api.media.ccc.de/public/events/05a3b34b-338f-5e86-b71e-8ba2b7019bc3","conference_url":"https://api.media.ccc.de/public/conferences/clt24"},{"size":105,"length":2737,"mime_type":"video/webm","language":"deu","filename":"clt24-126-deu-Fuege_Geokoordinaten_zu_deinen_Adressen_in_PostgreSQL_hinzu_webm-sd.webm","state":"new","folder":"webm-sd","high_quality":false,"width":720,"height":576,"updated_at":"2024-03-16T16:30:06.656+01:00","recording_url":"https://cdn.media.ccc.de/events/clt/2024/webm-sd/clt24-126-deu-Fuege_Geokoordinaten_zu_deinen_Adressen_in_PostgreSQL_hinzu_webm-sd.webm","url":"https://api.media.ccc.de/public/recordings/75459","event_url":"https://api.media.ccc.de/public/events/05a3b34b-338f-5e86-b71e-8ba2b7019bc3","conference_url":"https://api.media.ccc.de/public/conferences/clt24"},{"size":92,"length":2737,"mime_type":"video/mp4","language":"deu","filename":"clt24-126-deu-Fuege_Geokoordinaten_zu_deinen_Adressen_in_PostgreSQL_hinzu_sd.mp4","state":"new","folder":"h264-sd","high_quality":false,"width":720,"height":576,"updated_at":"2024-03-16T15:53:31.911+01:00","recording_url":"https://cdn.media.ccc.de/events/clt/2024/h264-sd/clt24-126-deu-Fuege_Geokoordinaten_zu_deinen_Adressen_in_PostgreSQL_hinzu_sd.mp4","url":"https://api.media.ccc.de/public/recordings/75443","event_url":"https://api.media.ccc.de/public/events/05a3b34b-338f-5e86-b71e-8ba2b7019bc3","conference_url":"https://api.media.ccc.de/public/conferences/clt24"},{"size":29,"length":2737,"mime_type":"audio/opus","language":"deu","filename":"clt24-126-deu-Fuege_Geokoordinaten_zu_deinen_Adressen_in_PostgreSQL_hinzu_opus.opus","state":"new","folder":"opus","high_quality":false,"width":0,"height":0,"updated_at":"2024-03-16T15:51:01.502+01:00","recording_url":"https://cdn.media.ccc.de/events/clt/2024/opus/clt24-126-deu-Fuege_Geokoordinaten_zu_deinen_Adressen_in_PostgreSQL_hinzu_opus.opus","url":"https://api.media.ccc.de/public/recordings/75436","event_url":"https://api.media.ccc.de/public/events/05a3b34b-338f-5e86-b71e-8ba2b7019bc3","conference_url":"https://api.media.ccc.de/public/conferences/clt24"},{"size":41,"length":2737,"mime_type":"audio/mpeg","language":"deu","filename":"clt24-126-deu-Fuege_Geokoordinaten_zu_deinen_Adressen_in_PostgreSQL_hinzu_mp3.mp3","state":"new","folder":"mp3","high_quality":false,"width":0,"height":0,"updated_at":"2024-03-16T15:50:33.883+01:00","recording_url":"https://cdn.media.ccc.de/events/clt/2024/mp3/clt24-126-deu-Fuege_Geokoordinaten_zu_deinen_Adressen_in_PostgreSQL_hinzu_mp3.mp3","url":"https://api.media.ccc.de/public/recordings/75435","event_url":"https://api.media.ccc.de/public/events/05a3b34b-338f-5e86-b71e-8ba2b7019bc3","conference_url":"https://api.media.ccc.de/public/conferences/clt24"},{"size":226,"length":2737,"mime_type":"video/mp4","language":"deu","filename":"clt24-126-deu-Fuege_Geokoordinaten_zu_deinen_Adressen_in_PostgreSQL_hinzu_hd.mp4","state":"new","folder":"h264-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2024-03-16T15:47:12.879+01:00","recording_url":"https://cdn.media.ccc.de/events/clt/2024/h264-hd/clt24-126-deu-Fuege_Geokoordinaten_zu_deinen_Adressen_in_PostgreSQL_hinzu_hd.mp4","url":"https://api.media.ccc.de/public/recordings/75426","event_url":"https://api.media.ccc.de/public/events/05a3b34b-338f-5e86-b71e-8ba2b7019bc3","conference_url":"https://api.media.ccc.de/public/conferences/clt24"}]}