<!doctypehtml><html class=client-nojs dir=ltr lang=en><meta charset=utf-8><title>
   Databases and data access APIs - OpenStreetMap Wiki
  </title><script>document.documentElement.className="client-js";RLCONF={"wgBreakFrames":!1,"wgSeparatorTransformTable":["",""],"wgDigitTransformTable":["",""],"wgDefaultDateFormat":"dmy","wgMonthNames":["","January","February","March","April","May","June","July","August","September","October","November","December"],"wgRequestId":"356948a8121a990cc68a02c4","wgCSPNonce":!1,"wgCanonicalNamespace":"","wgCanonicalSpecialPageName":!1,"wgNamespaceNumber":0,"wgPageName":"Databases_and_data_access_APIs","wgTitle":"Databases and data access APIs","wgCurRevisionId":2213668,"wgRevisionId":2213668,"wgArticleId":36348,"wgIsArticle":!0,"wgIsRedirect":!1,"wgAction":"view","wgUserName":null,"wgUserGroups":["*"],"wgCategories":["Pages unavailable in German","Pages unavailable in Spanish","Pages unavailable in Italian","Pages unavailable in Dutch","Pages unavailable in Russian","Pages unavailable in Japanese"],"wgPageContentLanguage":"en","wgPageContentModel":"wikitext","wgRelevantPageName":
"Databases_and_data_access_APIs","wgRelevantArticleId":36348,"wgIsProbablyEditable":!1,"wgRelevantPageIsProbablyEditable":!1,"wgRestrictionEdit":[],"wgRestrictionMove":[],"wgMFDisplayWikibaseDescriptions":{"search":!1,"nearby":!1,"watchlist":!1,"tagline":!1},"wgULSAcceptLanguageList":[],"wgULSCurrentAutonym":"English","wgVisualEditor":{"pageLanguageCode":"en","pageLanguageDir":"ltr","pageVariantFallbacks":"en"},"wbUserSpecifiedLanguages":[],"wgULSPosition":"personal","wgEditSubmitButtonLabelPublish":!1};RLSTATE={"site.styles":"ready","noscript":"ready","user.styles":"ready","user":"ready","user.options":"loading","skins.vector.styles.legacy":"ready","jquery.tablesorter.styles":"ready","mediawiki.toc.styles":"ready","ext.OsmWikibase-all":"ready","ext.uls.pt":"ready","ext.visualEditor.desktopArticleTarget.noscript":"ready","wikibase.client.init":"ready"};RLPAGEMODULES=["site","mediawiki.page.startup","mediawiki.page.ready","jquery.tablesorter","mediawiki.toc",
"skins.vector.legacy.js","ext.gadget.taginfo","ext.gadget.dataitemlinks","ext.uls.interface","ext.visualEditor.desktopArticleTarget.init","ext.visualEditor.targetLoader"];</script><script>(RLQ=window.RLQ||[]).push(function(){mw.loader.implement("user.options@1hzgi",function($,jQuery,require,module){/*@nomin*/mw.user.tokens.set({"patrolToken":"+\\","watchToken":"+\\","csrfToken":"+\\"});
});});</script><link href=/w/load.php?lang=en&modules=ext.OsmWikibase-all%7Cext.uls.pt%7Cext.visualEditor.desktopArticleTarget.noscript%7Cjquery.tablesorter.styles%7Cmediawiki.toc.styles%7Cskins.vector.styles.legacy%7Cwikibase.client.init&only=styles&skin=vector rel=stylesheet><script async src=/w/load.php?lang=en&modules=startup&only=scripts&raw=1&skin=vector></script><meta name=ResourceLoaderDynamicStyles><link href=/w/load.php?lang=en&modules=site.styles&only=styles&skin=vector rel=stylesheet><noscript><link href=/w/load.php?lang=en&modules=noscript&only=styles&skin=vector rel=stylesheet></noscript><meta content="MediaWiki 1.35.4"name=generator><link rel="shortcut icon"href=/favicon.ico><link title="OpenStreetMap Wiki (en)"href=/w/opensearch_desc.php rel=search type=application/opensearchdescription+xml><link href=//wiki.openstreetmap.org/w/api.php?action=rsd rel=EditURI type=application/rsd+xml><link href=/wiki/Wiki_content_license rel=license><link title="OpenStreetMap Wiki Atom feed"href=/w/index.php?title=Special:RecentChanges&feed=atom rel=alternate type=application/atom+xml><body class="mediawiki ltr sitedir-ltr mw-hide-empty-elt ns-0 ns-subject page-Databases_and_data_access_APIs rootpage-Databases_and_data_access_APIs skin-vector action-view minerva--history-page-action-enabled skin-vector-legacy"><div class=noprint id=mw-page-base></div><div class=noprint id=mw-head-base></div><div class=mw-body id=content role=main><a id=top> </a><div class=mw-body-content id=siteNotice></div><div class="mw-indicators mw-body-content"></div><h1 class=firstHeading id=firstHeading lang=en>Databases and data access APIs</h1><div class=mw-body-content id=bodyContent><div class=noprint id=siteSub>From OpenStreetMap Wiki</div><div id=contentSub></div><div id=contentSub2></div><div id=jump-to-nav></div><a class=mw-jump-link href=#mw-head> Jump to navigation </a><a class=mw-jump-link href=#searchInput> Jump to search </a><div class=mw-content-ltr dir=ltr id=mw-content-text lang=en><div class=mw-parser-output><div class="languages noprint navigation-not-searchable"style="clear:both;font-size:95%;line-height:normal;margin:2px 0;border:1px solid #AAA"dir=ltr><div style=background:#EEE;padding:1px><div class=hlist style=float:right;margin-left:.25em;font-weight:normal;font-size:x-small><ul><li><bdi class="noprint plainlinks purgelink"> <a class="external text"href=//wiki.openstreetmap.org/w/index.php?title=Databases_and_data_access_APIs&action=purge rel=nofollow> <span title="Purge this page"> <span style="margin:0 2px"> <img srcset="https://upload.wikimedia.org/wikipedia/commons/thumb/1/1a/Octicons-sync.svg/15px-Octicons-sync.svg.png 1.5x, https://upload.wikimedia.org/wikipedia/commons/thumb/1/1a/Octicons-sync.svg/20px-Octicons-sync.svg.png 2x"alt decoding=async height=13 src=https://upload.wikimedia.org/wikipedia/commons/thumb/1/1a/Octicons-sync.svg/10px-Octicons-sync.svg.png width=10> </span> Purge </span> </a> </bdi><li><a title="Wiki Translation"href=/wiki/Wiki_Translation> Help </a></ul></div><div style=font-weight:bold;max-height:10000000px;text-align:center><bdi style=font-style:italic> Databases and data access APIs </bdi> - Other languages</div></div><div style="max-height:10000000px;padding:0 .25em"class=LanguageBar id=Languages><div class="hlist hlist-with-seps"><li lang=af><a title="Af:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Af:Databases_and_data_access_APIs&action=edit&redlink=1> Afrikaans </a> <span class=hlist-sep> </span><li lang=ast><a title="Ast:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Ast:Databases_and_data_access_APIs&action=edit&redlink=1> asturianu </a> <span class=hlist-sep> </span><li lang=az><a title="Az:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Az:Databases_and_data_access_APIs&action=edit&redlink=1> azərbaycanca </a> <span class=hlist-sep> </span><li lang=id><a title="Id:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Id:Databases_and_data_access_APIs&action=edit&redlink=1> Bahasa Indonesia </a> <span class=hlist-sep> </span><li lang=ms><a title="Ms:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Ms:Databases_and_data_access_APIs&action=edit&redlink=1> Bahasa Melayu </a> <span class=hlist-sep> </span><li lang=bs><a title="Bs:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Bs:Databases_and_data_access_APIs&action=edit&redlink=1> bosanski </a> <span class=hlist-sep> </span><li lang=br><a title="Br:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Br:Databases_and_data_access_APIs&action=edit&redlink=1> brezhoneg </a> <span class=hlist-sep> </span><li lang=ca><a title="Ca:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Ca:Databases_and_data_access_APIs&action=edit&redlink=1> català </a> <span class=hlist-sep> </span><li lang=cs><a title="Cs:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Cs:Databases_and_data_access_APIs&action=edit&redlink=1> čeština </a> <span class=hlist-sep> </span><li lang=da><a title="Da:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Da:Databases_and_data_access_APIs&action=edit&redlink=1> dansk </a> <span class=hlist-sep> </span><li lang=de><a title="DE:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=DE:Databases_and_data_access_APIs&action=edit&redlink=1> Deutsch </a> <span class=hlist-sep> </span><li lang=et><a title="Et:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Et:Databases_and_data_access_APIs&action=edit&redlink=1> eesti </a> <span class=hlist-sep> </span><li lang=en><a class="mw-selflink selflink"> English </a> <span class=hlist-sep> </span><li lang=es><a title="ES:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=ES:Databases_and_data_access_APIs&action=edit&redlink=1> español </a> <span class=hlist-sep> </span><li lang=eo><a title="Eo:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Eo:Databases_and_data_access_APIs&action=edit&redlink=1> Esperanto </a> <span class=hlist-sep> </span><li lang=eu><a title="Eu:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Eu:Databases_and_data_access_APIs&action=edit&redlink=1> euskara </a> <span class=hlist-sep> </span><li lang=fr><a title="FR:Databases and data access APIs"href=/wiki/FR:Databases_and_data_access_APIs> français </a> <span class=hlist-sep> </span><li lang=fy><a title="Fy:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Fy:Databases_and_data_access_APIs&action=edit&redlink=1> Frysk </a> <span class=hlist-sep> </span><li lang=gl><a title="Gl:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Gl:Databases_and_data_access_APIs&action=edit&redlink=1> galego </a> <span class=hlist-sep> </span><li lang=hr><a title="Hr:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Hr:Databases_and_data_access_APIs&action=edit&redlink=1> hrvatski </a> <span class=hlist-sep> </span><li lang=ia><a title="Ia:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Ia:Databases_and_data_access_APIs&action=edit&redlink=1> interlingua </a> <span class=hlist-sep> </span><li lang=is><a title="Is:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Is:Databases_and_data_access_APIs&action=edit&redlink=1> íslenska </a> <span class=hlist-sep> </span><li lang=it><a title="IT:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=IT:Databases_and_data_access_APIs&action=edit&redlink=1> italiano </a> <span class=hlist-sep> </span><li lang=ht><a title="Ht:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Ht:Databases_and_data_access_APIs&action=edit&redlink=1> Kreyòl ayisyen </a> <span class=hlist-sep> </span><li lang=gcf><a title="Gcf:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Gcf:Databases_and_data_access_APIs&action=edit&redlink=1> kréyòl gwadloupéyen </a> <span class=hlist-sep> </span><li lang=ku><a title="Ku:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Ku:Databases_and_data_access_APIs&action=edit&redlink=1> kurdî </a> <span class=hlist-sep> </span><li lang=lv><a title="Lv:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Lv:Databases_and_data_access_APIs&action=edit&redlink=1> latviešu </a> <span class=hlist-sep> </span><li lang=lb><a title="Lb:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Lb:Databases_and_data_access_APIs&action=edit&redlink=1> Lëtzebuergesch </a> <span class=hlist-sep> </span><li lang=lt><a title="Lt:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Lt:Databases_and_data_access_APIs&action=edit&redlink=1> lietuvių </a> <span class=hlist-sep> </span><li lang=hu><a title="Hu:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Hu:Databases_and_data_access_APIs&action=edit&redlink=1> magyar </a> <span class=hlist-sep> </span><li lang=nl><a title="NL:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=NL:Databases_and_data_access_APIs&action=edit&redlink=1> Nederlands </a> <span class=hlist-sep> </span><li lang=no><a title="No:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=No:Databases_and_data_access_APIs&action=edit&redlink=1> norsk </a> <span class=hlist-sep> </span><li lang=nn><a title="Nn:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Nn:Databases_and_data_access_APIs&action=edit&redlink=1> norsk nynorsk </a> <span class=hlist-sep> </span><li lang=oc><a title="Oc:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Oc:Databases_and_data_access_APIs&action=edit&redlink=1> occitan </a> <span class=hlist-sep> </span><li lang=pl><a title="Pl:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Pl:Databases_and_data_access_APIs&action=edit&redlink=1> polski </a> <span class=hlist-sep> </span><li lang=pt><a title="Pt:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Pt:Databases_and_data_access_APIs&action=edit&redlink=1> português </a> <span class=hlist-sep> </span><li lang=ro><a title="Ro:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Ro:Databases_and_data_access_APIs&action=edit&redlink=1> română </a> <span class=hlist-sep> </span><li lang=sq><a title="Sq:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Sq:Databases_and_data_access_APIs&action=edit&redlink=1> shqip </a> <span class=hlist-sep> </span><li lang=sk><a title="Sk:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Sk:Databases_and_data_access_APIs&action=edit&redlink=1> slovenčina </a> <span class=hlist-sep> </span><li lang=sl><a title="Sl:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Sl:Databases_and_data_access_APIs&action=edit&redlink=1> slovenščina </a> <span class=hlist-sep> </span><li lang=sr-latn><a title="Sr-latn:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Sr-latn:Databases_and_data_access_APIs&action=edit&redlink=1> srpski (latinica)‎ </a> <span class=hlist-sep> </span><li lang=fi><a title="Fi:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Fi:Databases_and_data_access_APIs&action=edit&redlink=1> suomi </a> <span class=hlist-sep> </span><li lang=sv><a title="Sv:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Sv:Databases_and_data_access_APIs&action=edit&redlink=1> svenska </a> <span class=hlist-sep> </span><li lang=tl><a title="Tl:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Tl:Databases_and_data_access_APIs&action=edit&redlink=1> Tagalog </a> <span class=hlist-sep> </span><li lang=vi><a title="Vi:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Vi:Databases_and_data_access_APIs&action=edit&redlink=1> Tiếng Việt </a> <span class=hlist-sep> </span><li lang=tr><a title="Tr:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Tr:Databases_and_data_access_APIs&action=edit&redlink=1> Türkçe </a> <span class=hlist-sep> </span><li lang=diq><a title="Diq:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Diq:Databases_and_data_access_APIs&action=edit&redlink=1> Zazaki </a> <span class=hlist-sep> </span><li lang=el><a title="El:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=El:Databases_and_data_access_APIs&action=edit&redlink=1> Ελληνικά </a> <span class=hlist-sep> </span><li lang=be><a title="Be:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Be:Databases_and_data_access_APIs&action=edit&redlink=1> беларуская </a> <span class=hlist-sep> </span><li lang=bg><a title="Bg:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Bg:Databases_and_data_access_APIs&action=edit&redlink=1> български </a> <span class=hlist-sep> </span><li lang=mk><a title="Mk:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Mk:Databases_and_data_access_APIs&action=edit&redlink=1> македонски </a> <span class=hlist-sep> </span><li lang=mn><a title="Mn:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Mn:Databases_and_data_access_APIs&action=edit&redlink=1> монгол </a> <span class=hlist-sep> </span><li lang=ru><a title="RU:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=RU:Databases_and_data_access_APIs&action=edit&redlink=1> русский </a> <span class=hlist-sep> </span><li lang=sr><a title="Sr:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Sr:Databases_and_data_access_APIs&action=edit&redlink=1> српски / srpski </a> <span class=hlist-sep> </span><li lang=uk><a title="Uk:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Uk:Databases_and_data_access_APIs&action=edit&redlink=1> українська </a> <span class=hlist-sep> </span><li lang=hy><a title="Hy:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Hy:Databases_and_data_access_APIs&action=edit&redlink=1> հայերեն </a> <span class=hlist-sep> </span><li lang=he><a title="He:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=He:Databases_and_data_access_APIs&action=edit&redlink=1> עברית </a> <span class=hlist-sep> </span><li lang=ar><a title="Ar:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Ar:Databases_and_data_access_APIs&action=edit&redlink=1> العربية </a> <span class=hlist-sep> </span><li lang=fa><a title="Fa:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Fa:Databases_and_data_access_APIs&action=edit&redlink=1> فارسی </a> <span class=hlist-sep> </span><li lang=ps><a title="Ps:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Ps:Databases_and_data_access_APIs&action=edit&redlink=1> پښتو </a> <span class=hlist-sep> </span><li lang=ne><a title="Ne:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Ne:Databases_and_data_access_APIs&action=edit&redlink=1> नेपाली </a> <span class=hlist-sep> </span><li lang=bn><a title="Bn:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Bn:Databases_and_data_access_APIs&action=edit&redlink=1> বাংলা </a> <span class=hlist-sep> </span><li lang=ta><a title="Ta:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Ta:Databases_and_data_access_APIs&action=edit&redlink=1> தமிழ் </a> <span class=hlist-sep> </span><li lang=ml><a title="Ml:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Ml:Databases_and_data_access_APIs&action=edit&redlink=1> മലയാളം </a> <span class=hlist-sep> </span><li lang=si><a title="Si:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Si:Databases_and_data_access_APIs&action=edit&redlink=1> සිංහල </a> <span class=hlist-sep> </span><li lang=th><a title="Th:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Th:Databases_and_data_access_APIs&action=edit&redlink=1> ไทย </a> <span class=hlist-sep> </span><li lang=my><a title="My:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=My:Databases_and_data_access_APIs&action=edit&redlink=1> မြန်မာဘာသာ </a> <span class=hlist-sep> </span><li lang=ka><a title="Ka:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Ka:Databases_and_data_access_APIs&action=edit&redlink=1> ქართული </a> <span class=hlist-sep> </span><li lang=ko><a title="Ko:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Ko:Databases_and_data_access_APIs&action=edit&redlink=1> 한국어 </a> <span class=hlist-sep> </span><li lang=tzm><a title="Tzm:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Tzm:Databases_and_data_access_APIs&action=edit&redlink=1> ⵜⴰⵎⴰⵣⵉⵖⵜ </a> <span class=hlist-sep> </span><li lang=zh-hans><a title="Zh-hans:Databases and data access APIs"href=/wiki/Zh-hans:Databases_and_data_access_APIs> 中文（简体）‎ </a> <span class=hlist-sep> </span><li lang=zh-hant><a title="Zh-hant:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Zh-hant:Databases_and_data_access_APIs&action=edit&redlink=1> 中文（繁體）‎ </a> <span class=hlist-sep> </span><li lang=ja><a title="JA:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=JA:Databases_and_data_access_APIs&action=edit&redlink=1> 日本語 </a> <span class=hlist-sep> </span><li lang=yue><a title="Yue:Databases and data access APIs (page does not exist)"class=new href=/w/index.php?title=Yue:Databases_and_data_access_APIs&action=edit&redlink=1> 粵語 </a> <span class=hlist-sep> </span></div></div><div class=nomobile style=background:#EEE;padding:1px><div class=hlist id=ExpandLanguages style=font-weight:bold;max-height:10000000px;text-align:center><ul><li><a href=#top> Other languages </a><li><a title="Wiki Translation"href=/wiki/Wiki_Translation> Translate </a></ul></div></div></div><p>This page provides an overview of the databases that could be used to store and manipulate OSM data, how to obtain data to populate the databases, and how to query them to find something useful.<p>It is intended as an overview for new developers who wish to write software to use OSM data, and not for end users of the information.<div aria-labelledby=mw-toc-heading class=toc id=toc role=navigation><input class=toctogglecheckbox id=toctogglecheckbox role=button style=display:none type=checkbox><div class=toctitle dir=ltr lang=en><h2 id=mw-toc-heading>Contents</h2><span class=toctogglespan> <label class=toctogglelabel for=toctogglecheckbox></label> </span></div><ul><li class="toclevel-1 tocsection-1"><a href=#Sources_of_OSM_Data> <span class=tocnumber> 1 </span> <span class=toctext> Sources of OSM Data </span> </a> <ul><li class="toclevel-2 tocsection-2"><a href=#Planet.osm.2F.pbf> <span class=tocnumber> 1.1 </span> <span class=toctext> Planet.osm/.pbf </span> </a><li class="toclevel-2 tocsection-3"><a href=#API> <span class=tocnumber> 1.2 </span> <span class=toctext> API </span> </a><li class="toclevel-2 tocsection-4"><a href=#Overpass_API> <span class=tocnumber> 1.3 </span> <span class=toctext> Overpass API </span> </a><li class="toclevel-2 tocsection-5"><a href=#XAPI> <span class=tocnumber> 1.4 </span> <span class=toctext> XAPI </span> </a></ul><li class="toclevel-1 tocsection-6"><a href=#Database_Schemas> <span class=tocnumber> 2 </span> <span class=toctext> Database Schemas </span> </a> <ul><li class="toclevel-2 tocsection-7"><a href=#osm2pgsql> <span class=tocnumber> 2.1 </span> <span class=toctext> osm2pgsql </span> </a><li class="toclevel-2 tocsection-8"><a href=#apidb> <span class=tocnumber> 2.2 </span> <span class=toctext> apidb </span> </a><li class="toclevel-2 tocsection-9"><a href=#pgsnapshot> <span class=tocnumber> 2.3 </span> <span class=toctext> pgsnapshot </span> </a><li class="toclevel-2 tocsection-10"><a href=#imposm> <span class=tocnumber> 2.4 </span> <span class=toctext> imposm </span> </a><li class="toclevel-2 tocsection-11"><a href=#nominatim> <span class=tocnumber> 2.5 </span> <span class=toctext> nominatim </span> </a><li class="toclevel-2 tocsection-12"><a href=#ogr2ogr> <span class=tocnumber> 2.6 </span> <span class=toctext> ogr2ogr </span> </a><li class="toclevel-2 tocsection-13"><a href=#overpass> <span class=tocnumber> 2.7 </span> <span class=toctext> overpass </span> </a><li class="toclevel-2 tocsection-14"><a href=#osmsharp> <span class=tocnumber> 2.8 </span> <span class=toctext> osmsharp </span> </a><li class="toclevel-2 tocsection-15"><a href=#mongosm> <span class=tocnumber> 2.9 </span> <span class=toctext> mongosm </span> </a><li class="toclevel-2 tocsection-16"><a href=#node-mongosm> <span class=tocnumber> 2.10 </span> <span class=toctext> node-mongosm </span> </a><li class="toclevel-2 tocsection-17"><a href=#osmium> <span class=tocnumber> 2.11 </span> <span class=toctext> osmium </span> </a><li class="toclevel-2 tocsection-18"><a href=#OSHDB> <span class=tocnumber> 2.12 </span> <span class=toctext> OSHDB </span> </a></ul><li class="toclevel-1 tocsection-19"><a href=#Choice_of_DBMS> <span class=tocnumber> 3 </span> <span class=toctext> Choice of DBMS </span> </a></ul></div><h2><span class=mw-headline id=Sources_of_OSM_Data> Sources of OSM Data </span></h2><p>See also <a title="Downloading data"href=/wiki/Downloading_data> Downloading data </a> for a run down of the basic options<p>The various sources of OSM data (either the whole world, or a small part of it) are identified below with links to other Wiki pages which provide more detail.<p>The most of the following methods of obtaining data return the data in the <a title="OSM XML"href=/wiki/OSM_XML> OSM XML </a> format that can be used by other tools to populate the database. The format of the data is described in <a title="Data Primitives"class=mw-redirect href=/wiki/Data_Primitives> Data Primitives </a> .<h3><span id=Planet.osm/.pbf> </span> <span class=mw-headline id=Planet.osm.2F.pbf> <a href=/wiki/Planet.osm title=Planet.osm> Planet.osm </a> /.pbf </span></h3><p>Every week a dump of the entire current OSM dataset is saved in <a title="OSM file formats"href=/wiki/OSM_file_formats> different formats </a> and made available as <a href=/wiki/Planet.osm title=Planet.osm> Planet.osm </a> . Quite a few people break this file down into smaller files for different regions and make extracts available separately on mirror servers. Various tools are available to cut the Planet file up into smaller areas if required, but are also available pre-cut e.g. from <a class="external text"href=https://download.geofabrik.de/ rel=nofollow> GeoFabrik </a> (pre-selected regions like by-state) or <a class="external text"href=https://protomaps.com/extracts rel=nofollow> ProtoMaps </a> (pbf data filtered by bounding polygon; provides time-limited link to re-download the same data). Some sources omit metadata from tag-less nodes to minimize space.<p>Differences between the live OSM data and the planet dump are also published each minute as <a href=/wiki/Changeset title=Changeset> changeset </a> , so it is possible to maintain an up-to date copy of the OSM dataset.<h3><span class=mw-headline id=API> <a href=/wiki/API title=API> API </a> </span></h3><p>The main <a href=/wiki/API title=API> API </a> is the method of obtaining OSM data used by <a href=/wiki/Editors title=Editors> editors </a> , as this is the only method of changing the OSM data in the live <a href=/wiki/Database title=Database> database </a> . The <a href=/wiki/API title=API> API </a> page provides a link to the specification of the protocol to be used to obtain data.<p>Its <b> limitations </b> are:<ul><li>it will only return <i> very small areas </i> < 0.25deg square.<li>This method of obtaining data should therefore be <i> reserved for editing </i> applications. Use other methods for <a href=/wiki/Rendering title=Rendering> rendering </a> , <a href=/wiki/Routing title=Routing> routing </a> or other purposes.</ul><h3><span class=mw-headline id=Overpass_API> <a title="Overpass API"href=/wiki/Overpass_API> Overpass API </a> </span></h3><p>The Overpass API is a read-only API that serves up custom selected parts of the OSM map data. In contrast to the editing API described in the previous API, the Overpass API is optimized for data consumers that need a few elements within a glimpse or up to roughly 10 million elements in some minutes, both selected by search criteria like e.g. location, type of objects, tag properties, proximity, or combinations of them. It acts as a database backend for <a title="Overpass API/Applications"href=/wiki/Overpass_API/Applications> various services </a> . It’s query language is documented at <a title="Overpass API/Overpass QL"href=/wiki/Overpass_API/Overpass_QL> Overpass QL guide/language reference </a> . It is highly recommended to get familiar with various features via <a title="Overpass turbo"href=/wiki/Overpass_turbo> overpass turbo </a> , an interactive Web-based frontend.<h3><span class=mw-headline id=XAPI> <a class=mw-redirect href=/wiki/XAPI title=XAPI> XAPI </a> </span></h3><p>XAPI is no longer recommended as none of the original native installations are available anymore. Legacy XAPI applications can still leverage the <a title="Overpass API/XAPI Compatibility Layer"href=/wiki/Overpass_API/XAPI_Compatibility_Layer> XAPI Compatibility Layer </a> , new projects should use <a title="Overpass API/Overpass QL"href=/wiki/Overpass_API/Overpass_QL> Overpass QL </a> instead. The <a href=/wiki/Xapi title=Xapi> Xapi </a> servers allowed OSM data to be downloaded in <a class=mw-redirect href=/wiki/XML title=XML> XML </a> format for a given region of the globe, filtered by tag – it was obsoleted by the Overpass API.<p><br><h2><span class=mw-headline id=Database_Schemas> Database Schemas </span></h2><p>The database schema for the main API database (openstreetmap.org) can be found here: <b> <a title="Rails port/Database schema"href=/wiki/Rails_port/Database_schema> Rails port/Database schema </a> </b> .<p>OSM uses different database schemas for different applications:<dl><dt>Updatable<dd>Whether the schema supports updating with <a href=/wiki/OsmChange title=OsmChange> OsmChange </a> format "diffs".<dd>This can be extremely important for keeping world-wide databases up-to-date, as it allows the database to be kept up-to-date without requiring a complete (and space- and time-consuming) <a href=/wiki/Planet.osm#Worldwide_data title=Planet.osm> full, worldwide </a> re-import. However, if you only need a small <a href=/wiki/Planet.osm#Country_and_area_extracts title=Planet.osm> extract </a> , then re-importing that extract may be a quicker and easier method to keep up-to-date than using the <a href=/wiki/OsmChange title=OsmChange> OsmChange </a> diffs.</dl><dl><dt>Geometries<dd>Whether the schema has pre-built geometries.<dd>Some database schemas provide native (e.g: PostGIS) geometries, which allows their use in other pieces of software which can read those geometry formats. Other database schemas may provide enough data to produce the geometries (e.g: nodes, ways, relations and their linkage) but not in a native format. Some can provide both. If you want to use the database with other bits of software such as a GIS editor then you probably want a schema with these geometries pre-built. However, if you are doing your own analysis, or are using software which is written to use OSM node/way/relations then you may not need the geometries.</dl><dl><dt>Lossless<dd>Whether the full set of OSM data is kept.<dd>Some schemas will retain the full set of OSM data, including versioning, user IDs, changeset information and all tags. This information is important for editors, and may be of importance to someone doing analysis. However, if it is not important then it may be better to choose a "lossy" schema, as it is likely to take up less disk space and may be quicker to import.</dl><dl><dt>hstore columns<dd>Whether the schema uses a key-value pair datatype for tags. (This datatype is called <a class="external text"href=http://www.postgresql.org/docs/9.1/static/hstore.html rel=nofollow> hstore </a> in PostgreSQL.)<dd>hstore is perhaps the most straightforward approach to represent OSM's freeform tagging in PostgreSQL. However, not all tools use it and other databases might not have (or need) an equivalent.</dl><p><br><table class="sortable wikitable"><tbody><tr><th>Schema name<th>Created with<th>Used by<th>Primary use case<th>Updatable<th>Geometries ( <a href=/wiki/PostGIS title=PostGIS> PostGIS </a> )<th>Lossless<th><a title="Hstore (page does not exist)"class=new href=/w/index.php?title=Hstore&action=edit&redlink=1> hstore </a> columns<th>Database<tr><td><a href=#osm2pgsql> osm2pgsql </a><td><a href=/wiki/Osm2pgsql title=Osm2pgsql> osm2pgsql </a><td><a href=/wiki/Mapnik title=Mapnik> Mapnik </a> , <a title="Kothic JS"href=/wiki/Kothic_JS> Kothic JS </a><td>Rendering<td class=table-yes style=background:#9F9;color:#000;vertical-align:middle;text-align:center;>﻿yes<td class=table-yes style=background:#9F9;color:#000;vertical-align:middle;text-align:center;>﻿yes<td class=table-no style=background:#F99;color:#000;vertical-align:middle;text-align:center;>﻿no<td class=table-yes style=background:#9F9;color:#000;vertical-align:middle;text-align:center;>optional<td>PostgreSQL<tr><td><a href=#apidb> apidb </a><td><a href=/wiki/Osmosis title=Osmosis> osmosis </a><td><a href=/wiki/API title=API> API </a><td>Mirroring<td class=table-yes style=background:#9F9;color:#000;vertical-align:middle;text-align:center;>﻿yes<td class=table-no style=background:#F99;color:#000;vertical-align:middle;text-align:center;>﻿no<td class=table-yes style=background:#9F9;color:#000;vertical-align:middle;text-align:center;>﻿yes<td class=table-no style=background:#F99;color:#000;vertical-align:middle;text-align:center;>﻿no<td>PostgreSQL, MySQL<tr><td><a href=#pgsnapshot> pgsnapshot </a><td><a href=/wiki/Osmosis title=Osmosis> osmosis </a><td><a href=/wiki/Xapi#jXAPI title=Xapi> jXAPI </a><td>Analysis<td class=table-yes style=background:#9F9;color:#000;vertical-align:middle;text-align:center;>﻿yes<td class=table-yes style=background:#9F9;color:#000;vertical-align:middle;text-align:center;>optional<td class=table-yes style=background:#9F9;color:#000;vertical-align:middle;text-align:center;>﻿yes<td class=table-yes style=background:#9F9;color:#000;vertical-align:middle;text-align:center;>﻿yes<td>PostgreSQL<tr><td><a href=#imposm> imposm </a><td><a href=/wiki/Imposm title=Imposm> Imposm </a><td><td>Rendering<td class=table-no style=background:#F99;color:#000;vertical-align:middle;text-align:center;>﻿no<td class=table-yes style=background:#9F9;color:#000;vertical-align:middle;text-align:center;>﻿yes<td class=table-no style=background:#F99;color:#000;vertical-align:middle;text-align:center;>﻿no<td>Imposm2: no, Imposm3: yes<td>PostgreSQL<tr><td><a href=#nominatim> nominatim </a><td><a href=/wiki/Osm2pgsql title=Osm2pgsql> osm2pgsql </a><td><a href=/wiki/Nominatim title=Nominatim> Nominatim </a><td>Search, Geocoding<td class=table-yes style=background:#9F9;color:#000;vertical-align:middle;text-align:center;>﻿yes<td class=table-yes style=background:#9F9;color:#000;vertical-align:middle;text-align:center;>﻿yes<td class=table-yes style=background:#9F9;color:#000;vertical-align:middle;text-align:center;>﻿yes<td>?<td>PostgreSQL<tr><td><a href=#ogr2ogr> ogr2ogr </a><td><a class=mw-redirect href=/wiki/Ogr2ogr title=Ogr2ogr> ogr2ogr </a><td><td>Analysis<td class=table-no style=background:#F99;color:#000;vertical-align:middle;text-align:center;>﻿no<td class=table-yes style=background:#9F9;color:#000;vertical-align:middle;text-align:center;>﻿yes<td class=table-no style=background:#F99;color:#000;vertical-align:middle;text-align:center;>﻿no<td class=table-yes style=background:#9F9;color:#000;vertical-align:middle;text-align:center;>optional<td><i> various </i><tr><td><a href=#osmsharp> osmsharp </a><td><a href=/wiki/OsmSharp title=OsmSharp> OsmSharp </a><td><td>Routing<td class=table-yes style=background:#9F9;color:#000;vertical-align:middle;text-align:center;>﻿yes<td class=table-no style=background:#F99;color:#000;vertical-align:middle;text-align:center;>﻿no<td>?<td>?<td>Oracle<tr><td><a href=#overpass> overpass </a><td><a title="Overpass API"href=/wiki/Overpass_API> Overpass API </a><td><td>Analysis<td class=table-yes style=background:#9F9;color:#000;vertical-align:middle;text-align:center;>﻿yes<td>?<td class=table-yes style=background:#9F9;color:#000;vertical-align:middle;text-align:center;>﻿yes<td>?<td><i> custom </i><tr><td><a href=#mongosm> mongosm </a><td><a class="external text"href=https://github.com/iandees/mongosm rel=nofollow> MongOSM </a><td><td>Analysis<td>maybe<td>?<td>?<td>?<td>MongoDB<tr><td><a href=#node-mongosm> node-mongosm </a><td><a class="external text"href=http://mongoosejs.com/ rel=nofollow> Mongoosejs </a><td><td>Analysis<td class=table-yes style=background:#9F9;color:#000;vertical-align:middle;text-align:center;>﻿yes<td class=table-yes style=background:#9F9;color:#000;vertical-align:middle;text-align:center;>﻿yes<td class=table-yes style=background:#9F9;color:#000;vertical-align:middle;text-align:center;>﻿yes<td>NA<td>MongoDB<tr><td><a href=#osmium> osmium </a><td><a href=/wiki/Osmium title=Osmium> Osmium </a><td><td>Analysis<td class=table-no style=background:#F99;color:#000;vertical-align:middle;text-align:center;>﻿no<td class=table-yes style=background:#9F9;color:#000;vertical-align:middle;text-align:center;>﻿yes<td class=table-no style=background:#F99;color:#000;vertical-align:middle;text-align:center;>﻿no<td class=table-yes style=background:#9F9;color:#000;vertical-align:middle;text-align:center;>﻿yes<td>PostgreSQL</table><h3><span class=mw-headline id=osm2pgsql> osm2pgsql </span></h3><p><a href=/wiki/Osm2pgsql title=Osm2pgsql> Osm2pgsql </a> schema has historically been the standard way to import OSM data for use in rendering software such as <a href=/wiki/Mapnik title=Mapnik> Mapnik </a> . It also has uses in analysis, although the schema does not support versioning or history directly. The import is handled by the <a href=/wiki/Osm2pgsql title=Osm2pgsql> Osm2pgsql </a> software, which has two modes of operation, slim and non-slim, which control the amount of memory used by the software during import and whether it can be updated. Slim mode supports updates, but time taken to import is highly dependent on disk speed and may take several days for the <a href=/wiki/Planet.osm title=Planet.osm> full planet </a> , even on a fast machine. Non-slim mode is faster, but does not support updates and requires a vast amount of memory.<p>The import process is lossy, and controlled by a configuration file in which the keys of elements of interest are listed. The values of these "interesting" elements are imported as columns in the points, lines and polygons tables. (Alternatively, values of all tags can be imported into a "hstore" type column.) These tables can be very large, and care must be paid to get good indexed performance. If the set of "interesting" keys changes after the import and no hstore column has been used, then the import must be re-run.<p>Starting with version 1.3.0, configuration became more flexible. A Lua script describes now the names, fields and types of database tables. For each processed OSM object, a Lua callback is called where you can describe which tables the object should be written to.<p>Osm2pgsql is used by Nominatim, too.<p>For more information, please see the <a class="external text"href=https://osm2pgsql.org/ rel=nofollow> Osm2pgsql website </a><h3><span class=mw-headline id=apidb> apidb </span></h3><p>ApiDB is a schema designed to replicate the storage of OSM data in the same manner as the <a title="Rails port/Database schema"href=/wiki/Rails_port/Database_schema> main API schema </a> and can be produced using the <a href=/wiki/Osmosis title=Osmosis> Osmosis </a> commands for <a title="Osmosis/Detailed Usage"class=mw-redirect href=/wiki/Osmosis/Detailed_Usage#--write-apidb_.28--wd.29> writing ApiDBs </a> or <a title="Osmosis/Detailed Usage"class=mw-redirect href=/wiki/Osmosis/Detailed_Usage#--write-apidb-change_.28--wdc.29> updating ApiDBs with changes </a> . This schema does not have any native geometry, although in the nodes, ways and relations tables there is enough data to reconstruct the geometries. This schema is not recommended for users who need geometries.<p>This schema does support history, although the import process does not, so it can be used for mirroring of the main OSM DB. A history will be generated as replication diffs are applied.<p>The import process, even on good hardware, can take several weeks for the <a href=/wiki/Planet.osm title=Planet.osm> full planet </a> . The database will take approximately 1 TB as of April 2012.<p>For more information, please see the <a title="Osmosis/Detailed Usage"class=mw-redirect href=/wiki/Osmosis/Detailed_Usage> detailed usage </a> page for <a href=/wiki/Osmosis title=Osmosis> Osmosis </a> .<h3><span class=mw-headline id=pgsnapshot> pgsnapshot </span></h3><p>The <a title="Osmosis/Detailed Usage"class=mw-redirect href=/wiki/Osmosis/Detailed_Usage#PostGIS_Tasks_.28Snapshot_Schema.29> pgsnapshot </a> schema is a modified and simplified version of the main OSM DB schema which provides a number of useful features, including generating geometries and storing tags in a single hstore column for easier use and indexing. <a class=mw-redirect href=/wiki/XAPI#Java title=XAPI> JXAPI </a> 's schema is built on pgsnapshot.<h3><span class=mw-headline id=imposm> imposm </span></h3><p><a href=/wiki/Imposm title=Imposm> Imposm </a> is an import tool, and is able to generate schemas using a <a class="external text"href=https://imposm.org/docs/imposm3/latest/mapping.html rel=nofollow> mapping </a> which is fully configurable. As such it really shouldn't count as its own schema, but it needed fitting in somehow. The ability to break data out thematically into different tables greatly simplifies the problem of indexing performance, and may result in smaller table and index sizes on-disk.<h3><span class=mw-headline id=nominatim> nominatim </span></h3><p><a href=/wiki/Nominatim title=Nominatim> Nominatim </a> is a forward and reverse geocoder. The database is produced by a special back-end of <a href=/wiki/Osm2pgsql title=Osm2pgsql> Osm2pgsql </a> . It is a special-purpose database, and may not be suitable for other problem domains such as rendering. <a class="external text"href=https://nominatim.org/ rel=nofollow> The Nominatim homepage </a> provides links to the detailed technical documentation, change logs, etc.<h3><span class=mw-headline id=ogr2ogr> ogr2ogr </span></h3><p>The <a href=/wiki/OGR title=OGR> OGR </a> library can read OSM data (XML and PBF) and can write into <a class="external text"href=http://www.gdal.org/ogr/ogr_formats.html rel=nofollow> various other formats </a> , including PostgreSQL/PostGIS, SQLite/Spatialite, and MS SQL databases (though I've tried only PostGIS). The <a class=mw-redirect href=/wiki/Ogr2ogr title=Ogr2ogr> ogr2ogr </a> utility can do the conversion without any programming necessary with a schema configuration that's reminiscent of <a href=/wiki/Osm2pgsql title=Osm2pgsql> osm2pgsql </a> . One interesting feature is that it resolves relations into geometries: OSM multipolygons and boundaries become OGC MultiPolygon, OSM multilinestrings and routes become OGC MultiLineString, and other OSM relations become OGC GeometryCollection.<p>It is listed as lossy because membership info, such as nodes in ways and relation members, is not preserved. Metadata is optional. Untagged/unused nodes and ways are optional.<h3><span class=mw-headline id=overpass> overpass </span></h3><p>The <a title="Overpass API"href=/wiki/Overpass_API> Overpass_API </a> is a query language built on top of a custom back-end database with software called OSM3S (see <a class=mw-redirect href=/wiki/OSM3S/install title=OSM3S/install> OSM3S/install </a> for install and setup instructions). This is a custom database engine and it is therefore hard to compare it with other database schemas. You could recreate the complete planet file from the database. It is geared to have good performance on locally concentrated datasets.<h3><span class=mw-headline id=osmsharp> osmsharp </span></h3><p><a href=/wiki/OsmSharp title=OsmSharp> OsmSharp </a> is a toolbox of OSM-related routines, including some to import OSM data into Oracle databases.<h3><span class=mw-headline id=mongosm> <a class="external text"href=https://github.com/iandees/mongosm rel=nofollow> mongosm </a> </span></h3><p><a class="external text"href=https://github.com/iandees/mongosm rel=nofollow> MongOSM </a> is a set of Python scripts for importing, querying and (maybe) keeping up-to-date OSM data in a MongoDB database.<h3><span class=mw-headline id=node-mongosm> <a class="external text"href=http://sammerry.github.io/node-mongosm/ rel=nofollow> node-mongosm </a> </span></h3><p>Inspired by mongOSM, Node-MongOSM uses Mongoose to provide schemas and insert vs upsert options via a command line interface.<h3><span class=mw-headline id=osmium> osmium </span></h3><p>The <a href=/wiki/Osmium title=Osmium> Osmium </a> toolset can read OSM data and with <a class="external text"href=https://docs.osmcode.org/osmium/latest/osmium-export.html rel=nofollow> osmium export </a> can write into PostgreSQL/PostGIS.<p>Objects are loaded into a single osmdata table with column geom and tags.<h3><span class=mw-headline id=OSHDB> OSHDB </span></h3><p>The <a href=/wiki/OSHDB title=OSHDB> OSHDB </a> is a high-performance data analysis framework for analysing OSM's <a href=/wiki/Planet.osm/full title=Planet.osm/full> full-history </a> data. Data can be stored in a relational (JDBC) or distributed database (Apache Ignite).<p><br><h2><span class=mw-headline id=Choice_of_DBMS> Choice of DBMS </span></h2><p>While OSM.org mainly uses PostgreSQL, several different databases systems used by OSM users:<table class=wikitable><tbody><tr><th>Database<th>Benefits<th>Disbenefits<th>Used By<tr><td><a href=/wiki/PostgreSQL title=PostgreSQL> PostgreSQL </a><td>Can handle large datasets. The <a href=/wiki/PostGIS title=PostGIS> PostGIS </a> extension allows the use geographic extensions<td>Requires database server to be installed, with associated administrative overhead<td><a href=/wiki/Database title=Database> Main OSM API </a> , <a href=/wiki/Mapnik title=Mapnik> Mapnik </a> renderer<tr><td><a href=/wiki/MySQL title=MySQL> MySQL </a><td>Can handle large datasets<td>Does not have geographic extensions. Requires database server to be installed, with associated administrative overhead<td>The main database API used MySQL until version 0.6, when it was changed to Postgresql<tr><td><a href=/wiki/SQLite title=SQLite> SQLite </a><td>Small, does not require a database server<td>May struggle with large datasets - See <a class="external text"href=http://www.google.com/url?sa=t&source=web&ct=res&cd=3&url=http%3A%2F%2Fwww.mail-archive.com%2Fdev%40openstreetmap.org%2Fmsg03703.html&ei=M4ZKSv3yBdKhjAeyr8XCBg&usg=AFQjCNGZuECrrgQcYI9YaJdAxUFLqSk0Xw&sig2=Zrr789n1l8mLqbw_ldJn8w rel=nofollow> Mail Archive </a> (from 2008, may not be current)<td><a href=/wiki/Microcosm title=Microcosm> Microcosm </a><tr><td><a class="external text"href=http://www.mongodb.org/ rel=nofollow> MongoDB </a><td>Native <a class="external text"href=http://docs.mongodb.org/manual/applications/geospatial-indexes/ rel=nofollow> Geospatial Indexes and Queries </a><td><td><a class="external text"href=https://github.com/iandees/mongosm rel=nofollow> MongOSM </a> , <a class="external text"href=https://github.com/sammerry/node-mongosm rel=nofollow> Node-Mongosm </a><tr><td><a class="external text"href=https://hadoop.apache.org/ rel=nofollow> Hadoop </a> / <a class="external text"href=https://hive.apache.org/ rel=nofollow> Hive </a><td>Can handle very large datasets (known as big data). Extensions available for geospatial queries (for example <i> ESRI GIS for Hadoop </i> )<td>Requires Hadoop cluster to be installed, with associated administrative overhead<td><a class="external text"href=https://github.com/PanierAvide/OSM2Hive rel=nofollow> OSM2Hive </a></table></div></div><div class=printfooter>Retrieved from " <a dir=ltr href=https://wiki.openstreetmap.org/w/index.php?title=Databases_and_data_access_APIs&oldid=2213668> https://wiki.openstreetmap.org/w/index.php?title=Databases_and_data_access_APIs&oldid=2213668 </a> "</div><div class="catlinks catlinks-allhidden"data-mw=interface id=catlinks><div class="mw-hidden-catlinks mw-hidden-cats-hidden"id=mw-hidden-catlinks>Hidden categories: <ul><li><a title="Category:Pages unavailable in German"href=/wiki/Category:Pages_unavailable_in_German> Pages unavailable in German </a><li><a title="Category:Pages unavailable in Spanish"href=/wiki/Category:Pages_unavailable_in_Spanish> Pages unavailable in Spanish </a><li><a title="Category:Pages unavailable in Italian"href=/wiki/Category:Pages_unavailable_in_Italian> Pages unavailable in Italian </a><li><a title="Category:Pages unavailable in Dutch"href=/wiki/Category:Pages_unavailable_in_Dutch> Pages unavailable in Dutch </a><li><a title="Category:Pages unavailable in Russian"href=/wiki/Category:Pages_unavailable_in_Russian> Pages unavailable in Russian </a><li><a title="Category:Pages unavailable in Japanese"href=/wiki/Category:Pages_unavailable_in_Japanese> Pages unavailable in Japanese </a></ul></div></div></div></div><div id=mw-navigation><h2>Navigation menu</h2><div id=mw-head><nav aria-labelledby=p-personal-label class=vector-menu id=p-personal role=navigation><h3 id=p-personal-label><span> Personal tools </span></h3><div class="body vector-menu-content"><ul class=vector-menu-content-list><li class=active id=pt-uls><a class=uls-trigger href=#> English </a><li id=pt-createaccount><a title="You are encouraged to create an account and log in; however, it is not mandatory"href=/w/index.php?title=Special:CreateAccount&returnto=Databases+and+data+access+APIs> Create account </a><li id=pt-login><a title="You are encouraged to log in; however, it is not mandatory [o]"accesskey=o href=/w/index.php?title=Special:UserLogin&returnto=Databases+and+data+access+APIs> Log in </a></ul></div></nav><div id=left-navigation><nav class="vector-menu vector-menu-tabs vectorTabs"aria-labelledby=p-namespaces-label id=p-namespaces role=navigation><h3 id=p-namespaces-label><span> Namespaces </span></h3><div class="body vector-menu-content"><ul class=vector-menu-content-list><li class=selected id=ca-nstab-main><a title="View the content page [c]"accesskey=c href=/wiki/Databases_and_data_access_APIs> Page </a><li id=ca-talk><a title="Discussion about the content page [t]"accesskey=t href=/wiki/Talk:Databases_and_data_access_APIs rel=discussion> Discussion </a></ul></div></nav><nav class="vector-menu-empty emptyPortlet vector-menu vector-menu-dropdown vectorMenu"aria-labelledby=p-variants-label id=p-variants role=navigation><input class="vector-menu-checkbox vectorMenuCheckbox"aria-labelledby=p-variants-label type=checkbox><h3 id=p-variants-label><span> Variants </span></h3><div class="body vector-menu-content"><ul class="menu vector-menu-content-list"></ul></div></nav></div><div id=right-navigation><nav class="vector-menu vector-menu-tabs vectorTabs"aria-labelledby=p-views-label id=p-views role=navigation><h3 id=p-views-label><span> Views </span></h3><div class="body vector-menu-content"><ul class=vector-menu-content-list><li class="collapsible selected"id=ca-view><a href=/wiki/Databases_and_data_access_APIs> Read </a><li class=collapsible id=ca-viewsource><a title="This page is protected.
You can view its source [e]"accesskey=e href=/w/index.php?title=Databases_and_data_access_APIs&action=edit> View source </a><li class=collapsible id=ca-history><a title="Past revisions of this page [h]"accesskey=h href=/w/index.php?title=Databases_and_data_access_APIs&action=history> View history </a></ul></div></nav><nav class="vector-menu-empty emptyPortlet vector-menu vector-menu-dropdown vectorMenu"aria-labelledby=p-cactions-label id=p-cactions role=navigation><input class="vector-menu-checkbox vectorMenuCheckbox"aria-labelledby=p-cactions-label type=checkbox><h3 id=p-cactions-label><span> More </span></h3><div class="body vector-menu-content"><ul class="menu vector-menu-content-list"></ul></div></nav><div id=p-search role=search><h3><label for=searchInput>Search</label></h3><form action=/w/index.php id=searchform><div id=simpleSearch><input placeholder="Search OpenStreetMap Wiki"title="Search OpenStreetMap Wiki [f]"accesskey=f id=searchInput name=search type=search><input name=title type=hidden value=Special:Search><input class="searchButton mw-fallbackSearchButton"title="Search the pages for this text"id=mw-searchButton name=fulltext type=submit value=Search><input title="Go to a page with this exact name if it exists"class=searchButton id=searchButton name=go type=submit value=Go></div></form></div></div></div><div id=mw-panel><div id=p-logo role=banner><a title="Visit the main page"class=mw-wiki-logo href=/wiki/Main_Page> </a></div><nav class="vector-menu vector-menu-portal portal portal-first"aria-labelledby=p-site-label id=p-site role=navigation><h3 id=p-site-label><span> site </span></h3><div class="body vector-menu-content"><ul class=vector-menu-content-list><li id=n-mainpage><a title="Visit the main page [z]"accesskey=z href=/wiki/Main_Page> Main Page </a><li id=n-map><a href=https://www.openstreetmap.org/> The map </a><li id=n-mapfeatures><a href=/wiki/Map_Features> Map Features </a><li id=n-contributors><a href=/wiki/Contributors> Contributors </a><li id=n-help><a title="The place to find out"href=/wiki/Get_help> Help </a><li id=n-blogs><a href=/wiki/OSM_Blogs> Blogs </a><li id=n-Shop><a href=/wiki/Merchandise> Shop </a><li id=n-sitesupport><a href=/wiki/Donations> Donations </a><li id=n-talk-wiki><a href=/wiki/Talk:Wiki> Wiki discussion </a><li id=n-recentchanges><a title="A list of recent changes in the wiki [r]"accesskey=r href=/wiki/Special:RecentChanges> Recent changes </a></ul></div></nav><nav class="vector-menu vector-menu-portal portal"aria-labelledby=p-tb-label id=p-tb role=navigation><h3 id=p-tb-label><span> Tools </span></h3><div class="body vector-menu-content"><ul class=vector-menu-content-list><li id=t-whatlinkshere><a title="A list of all wiki pages that link here [j]"accesskey=j href=/wiki/Special:WhatLinksHere/Databases_and_data_access_APIs> What links here </a><li id=t-recentchangeslinked><a title="Recent changes in pages linked from this page [k]"accesskey=k href=/wiki/Special:RecentChangesLinked/Databases_and_data_access_APIs rel=nofollow> Related changes </a><li id=t-specialpages><a title="A list of all special pages [q]"accesskey=q href=/wiki/Special:SpecialPages> Special pages </a><li id=t-print><a title="Printable version of this page [p]"accesskey=p href=javascript:print(); rel=alternate> Printable version </a><li id=t-permalink><a title="Permanent link to this revision of the page"href=/w/index.php?title=Databases_and_data_access_APIs&oldid=2213668> Permanent link </a><li id=t-info><a title="More information about this page"href=/w/index.php?title=Databases_and_data_access_APIs&action=info> Page information </a><li id=t-cite><a title="Information on how to cite this page"href=/w/index.php?title=Special:CiteThisPage&page=Databases_and_data_access_APIs&id=2213668&wpFormIdentifier=titleform> Cite this page </a></ul></div></nav><nav class="vector-menu vector-menu-portal portal"aria-labelledby=p-lang-label id=p-lang role=navigation><h3 id=p-lang-label><span> In other languages </span></h3><div class="body vector-menu-content"><ul class=vector-menu-content-list></ul><div class="after-portlet after-portlet-lang"><span class="wb-langlinks-add wb-langlinks-link"> <a title="Add interlanguage links"class=wbc-editpage href=//wiki.openstreetmap.org/wiki/Special:NewItem?site=wiki&page=Databases+and+data+access+APIs> Add links </a> </span></div></div></nav></div></div><footer class=mw-footer id=footer role=contentinfo><ul id=footer-info><li id=footer-info-lastmod>This page was last edited on 30 October 2021, at 11:06.<li id=footer-info-copyright>Content is available under <a title="Wiki content license"href=/wiki/Wiki_content_license> Creative Commons Attribution-ShareAlike 2.0 license </a> unless otherwise noted.</ul><ul id=footer-places><li id=footer-places-privacy><a title="osmf:Privacy Policy"class=extiw href=http://www.osmfoundation.org/wiki/Privacy_Policy> Privacy policy </a><li id=footer-places-about><a class=mw-redirect href=/wiki/About title=About> About OpenStreetMap Wiki </a><li id=footer-places-disclaimer><a href=/wiki/Disclaimer title=Disclaimer> Disclaimers </a><li id=footer-places-mobileview><a class="noprint stopMobileRedirectToggle"href=//wiki.openstreetmap.org/w/index.php?title=Databases_and_data_access_APIs&mobileaction=toggle_view_mobile> Mobile view </a></ul><ul class=noprint id=footer-icons><li id=footer-copyrightico><a href=https://creativecommons.org/licenses/by-sa/2.0/> <img alt="Creative Commons Attribution-ShareAlike 2.0 license"height=31 loading=lazy src=/cc-wiki.png width=88> </a><li id=footer-poweredbyico><a href=https://www.mediawiki.org/> <img alt="Powered by MediaWiki"srcset="/w/resources/assets/poweredby_mediawiki_132x47.png 1.5x, /w/resources/assets/poweredby_mediawiki_176x62.png 2x"height=31 loading=lazy src=/w/resources/assets/poweredby_mediawiki_88x31.png width=88> </a></ul><div style="clear: both;"></div></footer><script>(RLQ=window.RLQ||[]).push(function(){mw.config.set({"wgPageParseReport":{"limitreport":{"cputime":"0.169","walltime":"0.249","ppvisitednodes":{"value":724,"limit":1000000},"postexpandincludesize":{"value":21069,"limit":2097152},"templateargumentsize":{"value":28,"limit":2097152},"expansiondepth":{"value":10,"limit":40},"expensivefunctioncount":{"value":7,"limit":500},"unstrip-depth":{"value":0,"limit":20},"unstrip-size":{"value":0,"limit":5000000},"entityaccesscount":{"value":0,"limit":250},"timingprofile":["100.00%  129.859      1 -total"," 71.28%   92.558      1 Template:Languages"," 21.15%   27.461      2 Template:LangSwitch"," 17.70%   22.986     23 Template:Yes","  8.71%   11.316     10 Template:No","  8.04%   10.438      2 Template:Langcode","  2.68%    3.479      1 Template:Purge/sandbox"]},"scribunto":{"limitreport-timeusage":{"value":"0.050","limit":"15"},"limitreport-virtmemusage":{"value":6471680,"limit":52428800},"limitreport-estmemusage":0},"cachereport":{"timestamp":"20211031175926","ttl":86400,"transientcontent":false}}});mw.config.set({"wgBackendResponseTime":463});});</script>