GIS main purpose is to show correlation among spatial data, analyze spatial information, query geographic data and show the results in form of reports, maps, tables or any other output is suitable for you. So, this time I want to introduce another visual that goes beyond the simple concept of mapping as it provides tools and features for spatial analysis: ArcGIS.Ī GIS (Geographical Information System) is a computer-based tool that analyzes, stores, manipulates and visualizes geographic information on a map. In the ToC below the article you can find out references to the previous article and the project’s goal.
Of course, added benefit of this option 2) is that you can just as easily access the same data from QGIS.This is the fourth article of a series dedicated to discovering geographic map tools in Power BI. Query Layers can access the data without an ArcSDE Repository, so directly. Please note it doesn't require you to enable the database as an ESRI Enterprise Geodatabase.
However, I have successfully setup an Oracle Virtualbox virtual machine with Ubuntu 18.04 running such setup on my laptop, and then I access the data from the Windows 10 host system on my laptop using Query Layers, so this is definitely possible.īut this option requires considerably more knowledge and experience to setup and run than simple installing the Editor as in 1).
While this option gives you great flexibility, and the benefit of osm2pgsql's superior import speeds, you will need to handle the extra burden of managing an enterprise database system (PostgreSQL) and install appropriate ODBC drivers etc.
Using the " OSM Attribute Selector" tool of the same toolbox, you can add tags at will as additional fields in the File Geodatabase, no matter what tag it is, as full tagging information is stored in the binary field.īoth tools also properly handle OSM multipolygons and route relations.Ģ) Use osm2pgsql to import your data into a PostGIS database, and access the data through ArcGIS Query Layers ( ).
A special binary field stores all tag data for any imported object. The good thing about both tools is that ESRI implemented its own tag storage similar to PostgreSQL's HSTORE. Both tools can import datasets up to country size with ease, and I have used the OSM File Loader (Load Only) tool even to load entire Africa or South America. It is thus comparable to osm2pgsql, although not nearly as fast (although it really does do a reasonable job if you are not in an extreme hurry). The OSM File Loader (Load Only) tool was the last addition to the toolbox, and is capable of multi-core processing if you set an appropriate Parallel Processing Factor in the environment settings of the tool. Both tools read *.osm XML files, not PBF! You can easily download zipped *.osm XML files from the Geofabrik website. There are two tools in the toolbox that allow you to properly import large scale data into a File Geodatabase (please forget about the "Download and Symbolize" option in the toolbox, it is not suited to any significantly sized data extract): the " Load OSM File" tool and the " OSM File Loader (Load Only)". The two options I have found best and most reliable are:ġ) Use the ArcGIS Editor for OpenStreetMap's import tools ( ). The options in there are not scalable or crash with OpenStreetMap data. How did you actually open the PBF File in ArcMap? Using the Interoperability Extension? To be honest, I have had bad experience using the Interoperability extensions options.