{"id":7105,"date":"2012-12-28T12:00:57","date_gmt":"2012-12-28T10:00:57","guid":{"rendered":"http:\/\/blog.openstreetmap.de\/?p=5489"},"modified":"2018-02-04T21:58:47","modified_gmt":"2018-02-04T20:58:47","slug":"osmde009-osm-talk-die-overpass-api","status":"publish","type":"podcast","link":"https:\/\/podcast.openstreetmap.de\/2012\/12\/28\/osmde009-osm-talk-die-overpass-api\/","title":{"rendered":"OSMDE009 OSM Talk: Die Overpass API"},"content":{"rendered":"<p><\/p>\n\n\n            <div class=\"podlove-web-player intrinsic-ignore podlove-web-player-loading\" id=\"player-632ee861c275d\"><root data-test=\"player--xl\" style=\"max-width:950px;min-width:260px;\">\n  <div class=\"tablet:px-6 tablet:pt-6 mobile:px-4 mobile:pt-4 flex flex-col\">\n    <div class=\"flex-col items-center mobile:flex tablet:hidden\">\n      <show-title class=\"text-sm\"><\/show-title>\n      <episode-title class=\"text-base mb-2\"><\/episode-title>\n      <subscribe-button class=\"mb-4 mobile:flex tablet:hidden\"><\/subscribe-button>\n      <poster class=\"rounded-sm w-48 shadow overflow-hidden\"><\/poster>\n      <divider class=\"w-full my-6\"><\/divider>\n    <\/div>\n\n    <div class=\"tablet:flex flex-grow\">\n      <div class=\"w-64 mobile:hidden tablet:block tablet:mr-6\">\n        <poster class=\"rounded-sm shadow overflow-hidden\"><\/poster>\n      <\/div>\n      <div class=\"w-full\">\n        <div class=\"hidden tablet:block\">\n          <show-title class=\"text-base\"><\/show-title>\n          <episode-title class=\"text-xl desktop:text-2xl\"><\/episode-title>\n          <divider class=\"w-full my-4\"><\/divider>\n        <\/div>\n        <div class=\"flex items-center justify-between\">\n          <div class=\"block\">\n            <play-state on=\"active\">\n              <speed-control class=\"flex items-center\"><\/speed-control>\n            <\/play-state>\n          <\/div>\n\n          <div class=\"flex\">\n            <play-state on=\"active\">\n              <chapter-previous class=\"mx-2 block\"><\/chapter-previous>\n            <\/play-state>\n            <play-state on=\"active\">\n              <step-backward class=\"mx-2 block\"><\/step-backward>\n            <\/play-state>\n\n            <play-button class=\"mx-2 block\" :label=\"$t('PLAYER.PLAY_EPISODE')\"><\/play-button>\n\n            <play-state on=\"active\">\n              <step-forward class=\"mx-2 block\"><\/step-forward>\n            <\/play-state>\n            <play-state on=\"active\">\n              <chapter-next class=\"mx-2 block\"><\/chapter-next>\n            <\/play-state>\n          <\/div>\n\n          <div class=\"block\">\n            <play-state on=\"active\">\n              <volume-control class=\"flex items-center\"><\/volume-control>\n            <\/play-state>\n          <\/div>\n        <\/div>\n        <div class=\"flex w-full\">\n          <progress-bar><\/progress-bar>\n        <\/div>\n        <div class=\"flex w-full -mt-2\">\n          <div class=\"w-3\/12 text-left\">\n            <timer-current class=\"text-sm\"><\/timer-current>\n          <\/div>\n          <div class=\"w-6\/12 text-center truncate\">\n            <play-state on=\"active\">\n              <current-chapter class=\"text-sm\"><\/current-chapter>\n            <\/play-state>\n          <\/div>\n          <div class=\"w-3\/12 text-right\">\n            <timer-duration class=\"text-sm\"><\/timer-duration>\n          <\/div>\n        <\/div>\n      <\/div>\n    <\/div>\n    <divider class=\"w-full mt-6 mb-3\"><\/divider>\n    <div class=\"flex justify-between\">\n      <div class=\"flex mobile:w-full tablet:w-3\/12 desktop:w-3\/12 justify-between\">\n        <tab-trigger tab=\"chapters\">\n          <icon type=\"chapter\"><\/icon>\n        <\/tab-trigger>\n        <tab-trigger tab=\"transcripts\">\n          <icon type=\"transcripts\"><\/icon>\n        <\/tab-trigger>\n        <tab-trigger tab=\"files\">\n          <icon type=\"download\"><\/icon>\n        <\/tab-trigger>\n        <tab-trigger tab=\"playlist\">\n          <icon type=\"playlist\"><\/icon>\n        <\/tab-trigger>\n        <tab-trigger tab=\"share\">\n          <icon type=\"share\"><\/icon>\n        <\/tab-trigger>\n      <\/div>\n      <subscribe-button class=\"mt-1 mobile:hidden tablet:flex\"><\/subscribe-button>\n    <\/div>\n  <\/div>\n  <div class=\"w-full relative overflow-hidden\">\n    <tab name=\"chapters\">\n      <tab-chapters><\/tab-chapters>\n    <\/tab>\n    <tab name=\"transcripts\">\n      <tab-transcripts><\/tab-transcripts>\n    <\/tab>\n    <tab name=\"files\">\n      <tab-files><\/tab-files>\n    <\/tab>\n    <tab name=\"playlist\">\n      <tab-playlist><\/tab-playlist>\n    <\/tab>\n    <tab name=\"share\">\n      <tab-share><\/tab-share>\n    <\/tab>\n    <tab-overflow><\/tab-overflow>\n  <\/div>\n  <error><\/error>\n<\/root>\n<\/div>\n            <script>\n              document.addEventListener(\"DOMContentLoaded\", function() {\n                var player = document.getElementById(\"player-632ee861c275d\");\n                podlovePlayerCache.add([{\"url\":\"https:\\\/\\\/podcast.openstreetmap.de\\\/wp-json\\\/podlove-web-player\\\/shortcode\\\/publisher\\\/7105\",\"data\":{\"version\":5,\"show\":{\"title\":\"Radio OSM\",\"subtitle\":\"Berichte und Neuigkeiten rund um OpenStreetMap, \\u200bdie freie Wiki-Weltkarte\",\"summary\":\"\",\"poster\":\"https:\\\/\\\/podcast.openstreetmap.de\\\/images\\\/radioosm-logo.png\",\"link\":\"https:\\\/\\\/podcast.openstreetmap.de\"},\"title\":\"OSMDE009 OSM Talk: Die Overpass API\",\"subtitle\":\"\",\"summary\":\"\",\"publicationDate\":\"2012-12-28T12:00:57+01:00\",\"duration\":\"02:50:38.000\",\"poster\":\"https:\\\/\\\/podcast.openstreetmap.de\\\/wp-content\\\/uploads\\\/sites\\\/3\\\/2012\\\/12\\\/700px-Overpass_API_logo.svg_.png\",\"link\":\"https:\\\/\\\/podcast.openstreetmap.de\\\/2012\\\/12\\\/28\\\/osmde009-osm-talk-die-overpass-api\\\/\",\"chapters\":[{\"start\":\"00:00:00.000\",\"title\":\"Begr\\u00fc\\u00dfung\",\"href\":\"\",\"image\":\"\"},{\"start\":\"00:04:43.075\",\"title\":\"Kurzvorstellung\",\"href\":\"\",\"image\":\"\"},{\"start\":\"00:16:26.233\",\"title\":\"API's bei OpenStreetMap - Ein \\u00dcberblick\",\"href\":\"\",\"image\":\"\"},{\"start\":\"00:22:24.039\",\"title\":\"Entstehungsgeschichte der Overpass API\",\"href\":\"\",\"image\":\"\"},{\"start\":\"00:28:52.160\",\"title\":\"Overpass API im Mapper-Alltag\",\"href\":\"\",\"image\":\"\"},{\"start\":\"00:36:36.079\",\"title\":\"Virtueller Kurzrundgang durch die Overpass API\",\"href\":\"\",\"image\":\"\"},{\"start\":\"00:41:06.776\",\"title\":\"Die Clientseite: Overpass API Query Language\",\"href\":\"\",\"image\":\"\"},{\"start\":\"01:26:14.429\",\"title\":\"Entwicklungsprinzipien und Softwareentwicklung\",\"href\":\"\",\"image\":\"\"},{\"start\":\"01:32:54.100\",\"title\":\"Die Serverseite\",\"href\":\"\",\"image\":\"\"},{\"start\":\"01:35:15.470\",\"title\":\"Serverkomponenten\",\"href\":\"\",\"image\":\"\"},{\"start\":\"01:39:45.868\",\"title\":\"Relationale Datenbanken und Geodaten\",\"href\":\"\",\"image\":\"\"},{\"start\":\"01:43:35.173\",\"title\":\"Datenbankbackend des Overpass Servers: TemplateDB\",\"href\":\"\",\"image\":\"\"},{\"start\":\"01:53:39.798\",\"title\":\"Lizenz des Quellcodes\",\"href\":\"\",\"image\":\"\"},{\"start\":\"01:55:53.385\",\"title\":\"Instanzen der Overpass API\",\"href\":\"\",\"image\":\"\"},{\"start\":\"01:58:15.377\",\"title\":\"Resourcenverbrauch, Traffic, Nutzerzahl, Vorf\\u00e4lle, Hosting\",\"href\":\"\",\"image\":\"\"},{\"start\":\"02:14:19.601\",\"title\":\"Mitstreiter gesucht\",\"href\":\"\",\"image\":\"\"},{\"start\":\"02:16:31.907\",\"title\":\"Quellcode-Kommentare\",\"href\":\"\",\"image\":\"\"},{\"start\":\"02:18:37.195\",\"title\":\"Hackweekends in Karlsruhe\",\"href\":\"\",\"image\":\"\"},{\"start\":\"02:19:09.920\",\"title\":\"Permanente IDs und OSM Wiki\",\"href\":\"\",\"image\":\"\"},{\"start\":\"02:23:45.197\",\"title\":\"\\u00dcber die technische Seite der OSM Community\",\"href\":\"\",\"image\":\"\"},{\"start\":\"02:26:12.897\",\"title\":\"Zukunftspl\\u00e4ne f\\u00fcr die Overpass API\",\"href\":\"\",\"image\":\"\"},{\"start\":\"02:27:37.009\",\"title\":\"Federated databases\",\"href\":\"\",\"image\":\"\"},{\"start\":\"02:31:12.069\",\"title\":\"64 Bit Node IDs\",\"href\":\"\",\"image\":\"\"},{\"start\":\"02:35:17.716\",\"title\":\"Dynamische Tagging-Bereinigung \\u00fcber die Overpass API\",\"href\":\"\",\"image\":\"\"},{\"start\":\"02:37:44.590\",\"title\":\"Augmented Diffs\",\"href\":\"\",\"image\":\"\"},{\"start\":\"02:45:24.237\",\"title\":\"R\\u00fcckmeldungen erw\\u00fcnscht\",\"href\":\"\",\"image\":\"\"}],\"audio\":[{\"url\":\"https:\\\/\\\/audio.podcast.openstreetmap.de\\\/OSMDE009.m4a\",\"size\":\"86369069\",\"title\":\"MPEG-4 AAC Audio (m4a)\",\"mimeType\":\"audio\\\/mp4\"},{\"url\":\"https:\\\/\\\/audio.podcast.openstreetmap.de\\\/OSMDE009.opus\",\"size\":\"63559113\",\"title\":\"Opus Audio (opus)\",\"mimeType\":\"audio\\\/opus\"},{\"url\":\"https:\\\/\\\/audio.podcast.openstreetmap.de\\\/OSMDE009.ogg\",\"size\":\"117289471\",\"title\":\"Ogg Vorbis Audio (ogg)\",\"mimeType\":\"audio\\\/ogg\"},{\"url\":\"https:\\\/\\\/audio.podcast.openstreetmap.de\\\/OSMDE009.mp3\",\"size\":\"122995169\",\"title\":\"MP3 Audio (mp3)\",\"mimeType\":\"audio\\\/mpeg\"}],\"files\":[{\"url\":\"https:\\\/\\\/audio.podcast.openstreetmap.de\\\/OSMDE009.mp3\",\"size\":\"122995169\",\"title\":\"MP3 (spielt \\u00fcberall)\",\"mimeType\":\"audio\\\/mpeg\"}],\"contributors\":[{\"id\":\"8\",\"name\":\"Stephan\",\"avatar\":\"data:image\\\/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIGNsYXNzPSJoLTYgdy02IiBmaWxsPSJub25lIiB2aWV3Qm94PSIwIDAgMjQgMjQiIHN0cm9rZT0iY3VycmVudENvbG9yIj4KICA8cGF0aCBzdHJva2UtbGluZWNhcD0icm91bmQiIHN0cm9rZS1saW5lam9pbj0icm91bmQiIHN0cm9rZS13aWR0aD0iMiIgZD0iTTUuMTIxIDE3LjgwNEExMy45MzcgMTMuOTM3IDAgMDExMiAxNmMyLjUgMCA0Ljg0Ny42NTUgNi44NzkgMS44MDRNMTUgMTBhMyAzIDAgMTEtNiAwIDMgMyAwIDAxNiAwem02IDJhOSA5IDAgMTEtMTggMCA5IDkgMCAwMTE4IDB6IiAvPgo8L3N2Zz4K\",\"role\":null,\"group\":{\"id\":\"1\",\"slug\":\"team\",\"title\":\"Team\"},\"comment\":null}]}}, {\"url\":\"https:\\\/\\\/podcast.openstreetmap.de\\\/wp-json\\\/podlove-web-player\\\/shortcode\\\/config\\\/default\\\/theme\\\/default\",\"data\":{\"activeTab\":\"chapters\",\"subscribe-button\":null,\"share\":{\"channels\":[\"twitter\",\"mail\",\"link\"],\"outlet\":\"https:\\\/\\\/podcast.openstreetmap.de\\\/wp-content\\\/plugins\\\/podlove-web-player\\\/web-player\\\/share.html\",\"sharePlaytime\":true},\"related-episodes\":{\"source\":\"disabled\",\"value\":null},\"version\":5,\"theme\":{\"tokens\":{\"brand\":\"#E64415\",\"brandDark\":\"#235973\",\"brandDarkest\":\"#1A3A4A\",\"brandLightest\":\"#E9F1F5\",\"shadeDark\":\"#807E7C\",\"shadeBase\":\"#807E7C\",\"contrast\":\"#000\",\"alt\":\"#fff\"},\"fonts\":{\"ci\":{\"name\":\"ci\",\"family\":[\"-apple-system\",\"BlinkMacSystemFont\",\"Segoe UI\",\"Roboto\",\"Helvetica\",\"Arial\",\"sans-serif\",\"Apple Color Emoji\",\"Segoe UI Emoji\\\", \\\"Segoe UI Symbol\"],\"src\":[],\"weight\":800},\"regular\":{\"name\":\"regular\",\"family\":[\"-apple-system\",\"BlinkMacSystemFont\",\"Segoe UI\",\"Roboto\",\"Helvetica\",\"Arial\",\"sans-serif\",\"Apple Color Emoji\",\"Segoe UI Emoji\\\", \\\"Segoe UI Symbol\"],\"src\":[],\"weight\":300},\"bold\":{\"name\":\"bold\",\"family\":[\"-apple-system\",\"BlinkMacSystemFont\",\"Segoe UI\",\"Roboto\",\"Helvetica\",\"Arial\",\"sans-serif\",\"Apple Color Emoji\",\"Segoe UI Emoji\\\", \\\"Segoe UI Symbol\"],\"src\":[],\"weight\":700}}},\"base\":\"https:\\\/\\\/podcast.openstreetmap.de\\\/wp-content\\\/plugins\\\/podlove-web-player\\\/web-player\\\/\"}}]);\n                podlovePlayer(player, \"https:\/\/podcast.openstreetmap.de\/wp-json\/podlove-web-player\/shortcode\/publisher\/7105\", \"https:\/\/podcast.openstreetmap.de\/wp-json\/podlove-web-player\/shortcode\/config\/default\/theme\/default\").then(function() {\n                  player && player.classList.remove(\"podlove-web-player-loading\");\n                });\n              });\n            <\/script>\n            <style>\n              .podlove-web-player.podlove-web-player-loading {\n                opacity: 0;\n              }\n            <\/style>\n        \n<ul class=\"episode_download_list\">\n\t<li>Download:<\/li>\n\t\t    \t    \t\t\t<li>\n\t\t\t\t<a href=\"https:\/\/audio.podcast.openstreetmap.de\/OSMDE009.mp3\">MP3 (spielt \u00fcberall)<span class=\"size\">117 MB<\/span><\/a>\n\t\t\t<\/li>\n\t    \t\t    \t    \t\t    \t    \t\t    \t    \t\t    \t    \t<\/ul>\n<div style=\"clear: both\"><\/div>\n\n\n\n\n\t<div class=\"podlove-contributors-cards\">\n\t\t\t\t\t\n\t\t\t\t<div class=\"podlove-contributors-card\">\n\t\t\t\t\t<div class=\"podlove-contributors-card-inner\">\n\t\t\t\t\t\t<div class=\"podlove-contributors-card-avatar\">\n\t\t\t\t\t\t\t\n<img alt=\"avatar\" width=\"50\" height=\"50\" src=\"data:image\/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIGNsYXNzPSJoLTYgdy02IiBmaWxsPSJub25lIiB2aWV3Qm94PSIwIDAgMjQgMjQiIHN0cm9rZT0iY3VycmVudENvbG9yIj4KICA8cGF0aCBzdHJva2UtbGluZWNhcD0icm91bmQiIHN0cm9rZS1saW5lam9pbj0icm91bmQiIHN0cm9rZS13aWR0aD0iMiIgZD0iTTUuMTIxIDE3LjgwNEExMy45MzcgMTMuOTM3IDAgMDExMiAxNmMyLjUgMCA0Ljg0Ny42NTUgNi44NzkgMS44MDRNMTUgMTBhMyAzIDAgMTEtNiAwIDMgMyAwIDAxNiAwem02IDJhOSA5IDAgMTEtMTggMCA5IDkgMCAwMTE4IDB6IiAvPgo8L3N2Zz4K\"\/>\n\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"podlove-contributors-card-person\">\n\t\t\t\t\t\t\t<div style=\"align-self: center\">\n\t\t\t\t\t\t\t\t<div style=\"font-weight: 400;\">Stephan<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"podlove-contributors-card-services\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"podlove-contributors-card-services-service\" target=\"_blank\" title=\"OpenStreetMap\" href=\"https:\/\/www.openstreetmap.org\/user\/SB79\">\n\t\t\t\t\t\t\t\t\t\t\n<img alt=\"OpenStreetMap Icon\" width=\"20\" src=\"https:\/\/podcast.openstreetmap.de\/wp-content\/plugins\/podlove-podcasting-plugin-for-wordpress\/lib\/modules\/social\/images\/icons\/openstreetmap.png\" srcset=\"https:\/\/podcast.openstreetmap.de\/wp-content\/plugins\/podlove-podcasting-plugin-for-wordpress\/lib\/modules\/social\/images\/icons\/openstreetmap.png 1x, https:\/\/podcast.openstreetmap.de\/wp-content\/plugins\/podlove-podcasting-plugin-for-wordpress\/lib\/modules\/social\/images\/icons\/openstreetmap.png 2x, https:\/\/podcast.openstreetmap.de\/wp-content\/plugins\/podlove-podcasting-plugin-for-wordpress\/lib\/modules\/social\/images\/icons\/openstreetmap.png 3x\"\/>\n\n\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"podlove-contributors-card-services-service\" target=\"_blank\" title=\"Website\" href=\"https:\/\/wiki.openstreetmap.org\/wiki\/User:SB79\">\n\t\t\t\t\t\t\t\t\t\t\n<img alt=\"Website Icon\" width=\"20\" src=\"https:\/\/podcast.openstreetmap.de\/wp-content\/plugins\/podlove-podcasting-plugin-for-wordpress\/lib\/modules\/social\/images\/icons\/www.png\" srcset=\"https:\/\/podcast.openstreetmap.de\/wp-content\/plugins\/podlove-podcasting-plugin-for-wordpress\/lib\/modules\/social\/images\/icons\/www.png 1x, https:\/\/podcast.openstreetmap.de\/wp-content\/plugins\/podlove-podcasting-plugin-for-wordpress\/lib\/modules\/social\/images\/icons\/www.png 2x, https:\/\/podcast.openstreetmap.de\/wp-content\/plugins\/podlove-podcasting-plugin-for-wordpress\/lib\/modules\/social\/images\/icons\/www.png 3x\"\/>\n\n\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"podlove-contributors-card-services-service\" target=\"_blank\" title=\"Flattr\" href=\"https:\/\/flattr.com\/profile\/SB79\">\n\t\t\t\t\t\t\t\t\t\t\n<img alt=\"Flattr Icon\" width=\"20\" src=\"https:\/\/podcast.openstreetmap.de\/wp-content\/plugins\/podlove-podcasting-plugin-for-wordpress\/lib\/modules\/social\/images\/icons\/flattr.png\" srcset=\"https:\/\/podcast.openstreetmap.de\/wp-content\/plugins\/podlove-podcasting-plugin-for-wordpress\/lib\/modules\/social\/images\/icons\/flattr.png 1x, https:\/\/podcast.openstreetmap.de\/wp-content\/plugins\/podlove-podcasting-plugin-for-wordpress\/lib\/modules\/social\/images\/icons\/flattr.png 2x, https:\/\/podcast.openstreetmap.de\/wp-content\/plugins\/podlove-podcasting-plugin-for-wordpress\/lib\/modules\/social\/images\/icons\/flattr.png 3x\"\/>\n\n\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\n\t\t\t\t\t\t<\/div>\n\n\t<style>\n\t\t.podlove-contributors-cards {\n\t\t\tmargin-bottom: 1rem;\n\t\t\tbackground: white;\n\t\t\toverflow: hidden;\n\t\t\tborder-radius: 0.375rem;\n\t\t\tbox-shadow: 0 1px 3px 0 rgba(0, 0, 0, 0.1), 0 1px 2px 0 rgba(0, 0, 0, 0.06);\n\t\t}\n\t\t.podlove-contributors-card {\n\t\t\tdisplay: flex;\n\t\t\talign-items: center;\n\t\t\tpadding: 1rem 1.5rem\n\t\t}\n\t\t.podlove-contributors-card-inner {\n\t\t\tdisplay: flex;\n\t\t\talign-items: center;\n\t\t\tflex: 1 1 0;\n\t\t\tmin-width: 0;\n\t\t}\n\t\t.podlove-contributors-card-avatar {\n\t\t\twidth: 50px;\n\t\t\theight: 50px;\n\t\t\tborder-radius: 0.25rem;\n\t\t\toverflow: hidden;\n\t\t\tflex-shrink: 0;\n\t\t}\n\t\t.podlove-contributors-card-person {\n\t\t\tflex: 1 1 0;\n\t\t\tmin-width: 0;\n\t\t\tpadding: 0 1rem;\n\t\t\tdisplay: grid;\n\t\t\tgrid-template-columns: repeat(2, minmax(0, 1fr));\n\t\t\tgap: 1rem;\n\t\t}\n\t\t.podlove-contributors-card-person-details {\n\t\t\tcolor: #999\n\t\t}\n\t\t.podlove-contributors-card-services {\n\t\t\tflex-wrap: wrap;\n\t\t\tdisplay: flex;\n\t\t\talign-items: center;\n\t\t\talign-content: center;\n\t\t\tjustify-content: flex-end;\n\t\t}\n\t\t.podlove-contributors-card-services-service {\n\t\t\tdisplay: inline-block;\n\t\t\tflex-shrink: 0;\n\t\t\tpadding-left: 0.5rem;\n\t\t\ttext-decoration: none;\n\t\t\tbox-shadow: none;\n\t\t}\n\t<\/style>\n\n\n<p><a href=\"http:\/\/blog.openstreetmap.de\/2012\/12\/osmde009-osm-talk-die-overpass-api\/700px-overpass_api_logo-svg\/\" rel=\"attachment wp-att-5492\"><img loading=\"lazy\" class=\"aligncenter size-full wp-image-5492\" src=\"http:\/\/podcast.openstreetmap.de\/wp-uploads\/2012\/12\/700px-Overpass_API_logo.svg_.png\" alt=\"Overpass API logo 700px\" width=\"700\" height=\"280\" srcset=\"https:\/\/podcast.openstreetmap.de\/wp-content\/uploads\/sites\/3\/2012\/12\/700px-Overpass_API_logo.svg_.png 700w, https:\/\/podcast.openstreetmap.de\/wp-content\/uploads\/sites\/3\/2012\/12\/700px-Overpass_API_logo.svg_-300x120.png 300w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>Das Podcast-Team und unser Gast-Podcaster\u00a0Stephan m\u00f6chten uns mit dieser Spezialausgabe des Radio OSM aus dem Jahr 2012 verabschieden und w\u00fcnschen allen Mappern einen guten Start in 2013. Wir m\u00f6chten uns bei euch f\u00fcr das reichliche und hilfreiche Feedback bedanken und w\u00fcnschen uns gleichzeitig noch mehr davon: Schreibt Kommentare oder eine E-Mail und kommt in den Live-Chat. Eure Nachrichten motivieren uns, weiter zu machen.<\/p>\n<p>&nbsp;<\/p>\n<p>Briefk\u00e4sten, Stra\u00dfen, Abbiegevorschriften &#8211; wie diese bei OpenStreetMap erfasst und in die Datenbank eingetragen werden k\u00f6nnen, wei\u00df der ambitionierte Mapper. Doch wie lassen sich solche Informationen gezielt wieder aus der Datenbank abfragen? In dieser Spezialausgabe des deutschen OpenStreetMap-Podcasts sprechen wir mit Roland Olbricht, dem Entwickler der Overpass API, die solche gezielten Abfragen erm\u00f6glicht und inzwischen eine wichtige Rolle f\u00fcr viele Programme und Dienste spielt. Roland gew\u00e4hrt uns dabei auch Einblicke dar\u00fcber, was die &#8222;Maschinisten&#8220; des OpenStreetMap-Universums, also unsere Softwareentwickler, momentan bewegt und motiviert.<\/p>\n<p><!--more--><\/p>\n<p>W\u00e4hrend das erste Drittel dieser Podcast-Episode so allgemeinverst\u00e4ndlich wie m\u00f6glich gehalten wurde und auch von interessierten und nicht-programmierenden Mappern verstanden werden kann, richten sich die letzten zwei Drittel dieser Podcast-Folge an die Technikverr\u00fcckten unter euch und auch an Softwareentwickler. Wer bei &#8222;augmented diffs&#8220;, &#8222;64 Bit Node Ids&#8220;, &#8222;Federated Databases&#8220;, &#8222;Permanente IDs&#8220;, &#8222;dynamische Tagging-Bereinigung&#8220; oder auch &#8222;\u00c4nderungsvisualisierungen&#8220; leuchtende Augen bekommt, sollte daneben auch auf keinen Fall das letzte Drittel dieser Folge verpassen.<\/p>\n<p><strong>Links:<\/strong><\/p>\n<ul>\n<li><a href=\"http:\/\/wiki.openstreetmap.org\/wiki\/Overpass_API\">Dokumentation der Overpass API<\/a><\/li>\n<li><a href=\"http:\/\/wiki.openstreetmap.org\/wiki\/Overpass_API\/Overpass_QL\">Referenz f\u00fcr die Abfragesprache<\/a><\/li>\n<li><a href=\"http:\/\/blog.openstreetmap.de\/2012\/11\/osm-talk-der-troisdorfer\/\">OSMDE006 OSM Talk: Der Troisdorfer<\/a><\/li>\n<li><a href=\"http:\/\/uni-wuppertal.de\">Universit\u00e4t Wuppertal<\/a><\/li>\n<li><a href=\"http:\/\/www.heise.de\/tp\/artikel\/16\/16851\/1.html\">Wegelagerei mit Kartenausschnitten<\/a><\/li>\n<li><a href=\"http:\/\/scai.fraunhofer.de\">Fraunhofer SCAI<\/a><\/li>\n<li><a href=\"http:\/\/www.osmfoundation.org\">OSM Foundation<\/a><\/li>\n<li><a href=\"http:\/\/overpass-api.de\/locate_me.html\">Overpass API: Locate Me<\/a><\/li>\n<li><a href=\"http:\/\/wiki.openstreetmap.org\/wiki\/API_v0.6\">API v0.6<\/a><\/li>\n<li><a href=\"http:\/\/wiki.openstreetmap.org\/wiki\/XAPI\">XAPI<\/a><\/li>\n<li><a href=\"http:\/\/wiki.openstreetmap.org\/wiki\/Nominatim\">Nominatim<\/a><\/li>\n<li><a href=\"http:\/\/wiki.openstreetmap.org\/wiki\/File:Overpass_API_logo.svg\">Overpass API Logo<\/a><\/li>\n<li><a href=\"http:\/\/osmbonnblog.blogspot.de\/2010\/06\/der-post-box-guesstimator-wo-fehlen.html\">Postbox Guesstimator<\/a><\/li>\n<li><a href=\"http:\/\/forum.openstreetmap.org\/viewtopic.php?id=762\">Landkarten f\u00fcr die Feuerwehr<\/a><\/li>\n<li><a href=\"http:\/\/wiki.openstreetmap.org\/wiki\/Overpass_API\/Overpass_QL\">Overpass QL<\/a><\/li>\n<li><a href=\"http:\/\/wiki.openstreetmap.org\/wiki\/MapCSS\">MapCSS<\/a><\/li>\n<li><a href=\"http:\/\/wiki.openstreetmap.org\/wiki\/OpenLayers_Marker_Example\">OpenLayers Marker Example<\/a><\/li>\n<li><a href=\"http:\/\/en.wikipedia.org\/wiki\/ISO_6709\">ISO 6709<\/a><\/li>\n<li><a href=\"http:\/\/de.wikipedia.org\/wiki\/SQL\">SQL<\/a><\/li>\n<li><a href=\"http:\/\/de.wikipedia.org\/wiki\/Imperative_Programmierung\">Imperative Programmierung<\/a><\/li>\n<li><a href=\"http:\/\/wiki.openstreetmap.org\/wiki\/Overpass_API\/Overpass_QL#Overview\">Variablen in der Overpass API<\/a><\/li>\n<li><a href=\"http:\/\/wiki.openstreetmap.org\/wiki\/Overpass_API\/Overpass_QL#Around\">Dokumentation von Around<\/a><\/li>\n<li><a href=\"http:\/\/en.wikipedia.org\/wiki\/Regular_expression#POSIX\">POSIX\u00a0Regular expression<\/a><\/li>\n<li><a href=\"http:\/\/de.wikipedia.org\/wiki\/Portable_Operating_System_Interface\">POSIX<\/a><\/li>\n<li><a href=\"http:\/\/wiki.openstreetmap.org\/wiki\/Overpass_API\/Overpass_QL#print\">Dokumentation von Out<\/a><\/li>\n<li><a href=\"http:\/\/wiki.openstreetmap.org\/wiki\/DE:JOSM\/Plugins\/mirrored_download\">JOSM-Plugin Mirrored Download<\/a><\/li>\n<li><a href=\"http:\/\/www.stroustrup.com\/dne.html\">Buch D&amp;E C++ von Stroustrup<\/a><\/li>\n<li><a href=\"http:\/\/wiki.openstreetmap.org\/wiki\/OpenLayers\">Open Layers<\/a><\/li>\n<li><a href=\"http:\/\/wiki.openstreetmap.org\/wiki\/Overpass_API#XAPI_Compatibility_Layer\">XAPI Compatibility Layer<\/a><\/li>\n<li><a href=\"http:\/\/sotm-eu.org\/talk?40\">Vortrag auf der SOTM-EU 2011<\/a><\/li>\n<li><a href=\"http:\/\/heise.de\/-1697694\">Torvalds vs. de Icaza<\/a><\/li>\n<li><a href=\"http:\/\/overpass-api.de\/query_form.html\">Eingabeformular f\u00fcr Queries<\/a><\/li>\n<li><a href=\"http:\/\/wiki.openstreetmap.org\/wiki\/DE:OpenSeaMap\">OpenSeaMap<\/a><\/li>\n<li><a href=\"http:\/\/overpass-api.de\/no_frills.html\">Installationsanleitung f\u00fcr den Server<\/a><\/li>\n<li><a href=\"http:\/\/de.wikipedia.org\/wiki\/Datenbank#Transaktionen\">Transaktionen (Datenbank)<\/a><\/li>\n<li><a href=\"http:\/\/de.wikipedia.org\/wiki\/Relationale_Datenbank\">Relationale Datenbank<\/a><\/li>\n<li><a href=\"http:\/\/wiki.openstreetmap.org\/wiki\/Overpass_API\/Technical_details\">Warum MySQL hier nicht hilft<\/a> (auf Deutsch s. Tagungsband)<\/li>\n<li><a href=\"http:\/\/wiki.openstreetmap.org\/wiki\/QuadTiles\">QuadTiles<\/a><\/li>\n<li><a href=\"http:\/\/de.wikipedia.org\/wiki\/Festplattenlaufwerk#Geschwindigkeit\">Latenzzeit bei Festplatten<\/a><\/li>\n<li><a href=\"http:\/\/wiki.openstreetmap.org\/wiki\/Planet.osm\">Planet.osm<\/a><\/li>\n<li><a href=\"https:\/\/github.com\/drolbr\/Overpass-API\/tree\/master\/src\/template_db\">Template DB<\/a><\/li>\n<li><a href=\"http:\/\/www.gnu.org\/licenses\/agpl-3.0.de.html\">AGPL 3.0<\/a><\/li>\n<li><a href=\"http:\/\/en.wikipedia.org\/wiki\/Free_software_licensing#Permissive_versus_Copyleft_opinions\">BSD-Lizenzen vs. GPL-Lizenzen<\/a><\/li>\n<li><a href=\"http:\/\/www.fossgis.de\/\">FOSSGIS eV.<\/a><\/li>\n<li><a href=\"http:\/\/overpass.osm.rambler.ru\">overpass.osm.rambler.ru<\/a><\/li>\n<li><a href=\"http:\/\/openstreetmap.fr\/\">openstreetmap.fr<\/a><\/li>\n<li><a href=\"http:\/\/blog.openstreetmap.de\/2012\/06\/overpass-api-wachst-um-eine-grosenordnung\/\">Wachstumsschmerzen<\/a><\/li>\n<li><a href=\"http:\/\/hetzner.de\">Hetzner<\/a><\/li>\n<li><a href=\"http:\/\/de.wikipedia.org\/wiki\/Domain_Name_System\">Domain Name System<\/a><\/li>\n<li><a href=\"http:\/\/overpass-api.de\/api\/ping\">Overpass API\u00a0Statustest<\/a><\/li>\n<li><a href=\"http:\/\/www.gnu.org\/software\/wget\/\">wget<\/a><\/li>\n<li><a href=\"http:\/\/overpass-api.de\/munin\/de\/overpass-api.de\/index.html#other\">Status-Grafik Munin<\/a><\/li>\n<li><a href=\"https:\/\/help.openstreetmap.org\/questions\/527\/how-can-i-make-sense-of-muninopenstreetmaporg\">Erl\u00e4uterung zu Munin<\/a><\/li>\n<li><a href=\"http:\/\/wiki.openstreetmap.org\/wiki\/Overpass_API\/Language_Guide\">Link zur Doku zwecks \u00dcbersetzung<\/a><\/li>\n<li><a href=\"https:\/\/github.com\/drolbr\/Overpass-API\/blob\/master\/konzeptheft.txt\">Das erw\u00e4hnte &#8222;Konzeptheft&#8220;<\/a><\/li>\n<li><a href=\"http:\/\/wiki.openstreetmap.org\/wiki\/Category:Hack_Day\">OSM\u00a0Hack Days<\/a><\/li>\n<li><a href=\"http:\/\/wiki.openstreetmap.org\/wiki\/Overpass_API\/Permanent_ID\">Permanent ID<\/a><\/li>\n<li><a href=\"http:\/\/wiki.openstreetmap.org\/wiki\/Overpass_API\/versions\">aktuelle und fr\u00fchere Versionen<\/a><\/li>\n<li><a href=\"http:\/\/de.wikipedia.org\/wiki\/Versionsverwaltung\">SVN vs. git<\/a><\/li>\n<li><a href=\"http:\/\/wiki.openstreetmap.org\/wiki\/Overpass_API\/Augmented_Diffs\">Augmented Diffs<\/a><\/li>\n<\/ul>\n<p><strong>Music by<\/strong> Dan-O at DanoSongs.com<br \/>\n<a href=\"http:\/\/danosongs.com\/danosongs.com-license.pdf\">http:\/\/danosongs.com\/danosongs.com-license.pdf<\/a>\u00a0(Title: Remember how it started)<\/p>\n    \n\n        \n","protected":false},"author":31,"featured_media":5492,"comment_status":"open","ping_status":"open","template":"","meta":{"inline_featured_image":false},"categories":[11],"tags":[],"_links":{"self":[{"href":"https:\/\/podcast.openstreetmap.de\/wp-json\/wp\/v2\/episodes\/7105"}],"collection":[{"href":"https:\/\/podcast.openstreetmap.de\/wp-json\/wp\/v2\/episodes"}],"about":[{"href":"https:\/\/podcast.openstreetmap.de\/wp-json\/wp\/v2\/types\/podcast"}],"author":[{"embeddable":true,"href":"https:\/\/podcast.openstreetmap.de\/wp-json\/wp\/v2\/users\/31"}],"replies":[{"embeddable":true,"href":"https:\/\/podcast.openstreetmap.de\/wp-json\/wp\/v2\/comments?post=7105"}],"version-history":[{"count":2,"href":"https:\/\/podcast.openstreetmap.de\/wp-json\/wp\/v2\/episodes\/7105\/revisions"}],"predecessor-version":[{"id":7842,"href":"https:\/\/podcast.openstreetmap.de\/wp-json\/wp\/v2\/episodes\/7105\/revisions\/7842"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/podcast.openstreetmap.de\/wp-json\/wp\/v2\/media\/5492"}],"wp:attachment":[{"href":"https:\/\/podcast.openstreetmap.de\/wp-json\/wp\/v2\/media?parent=7105"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/podcast.openstreetmap.de\/wp-json\/wp\/v2\/categories?post=7105"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/podcast.openstreetmap.de\/wp-json\/wp\/v2\/tags?post=7105"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}