Importing OSM Geofabrik data into Oracle database with GDAL/OGR


This post is the third in line of posts about Maps generally and Open Street Maps in particular. The previous one concentrates on building ogr2org on Linux platform, and this post is about using this tool. As this tool is not something completely new and unknown, there is a lot of information on different aspects of using it. So my task isn't to write a comprehensive guide on this topic, but only to highlight a few points and give a general understanding of this tool. And in this post, I will load OSM data into Oracle Database. Source data For my experiments I took a few .osm.pbf files from Geofabrik. My choice was based purely on the size of…

Continue Reading

GDAL/OGR with OCI support on Linux


This is a second post of the Maps series. It describes how to build a GDAL/OGR tool. GDAL - Geospatial Data Abstraction Library GDAL is a translator library for raster and vector geospatial data formats that is released under an X/MIT style Open Source licence by the Open Source Geospatial Foundation. As a library, it presents a single raster abstract data model and vector abstract data model to the calling application for all supported formats. It also comes with a variety of useful command line utilities for data translation and processing. In a nutshell, GDAL/OGR is a library and a set of command line tools for manipulating geodata. It is used as a library in many products…

Continue Reading

Maps starting post


Preface This post starts a series of posts about using GIS data for visualizing an information in OBIEE. I don't know how many of them will be and how much time will it take to write. Right now the plan is the following: Announce/contents [this post] Building GDAL/OGR with required features. Basics of using of GDAL/OGR to load OpenStreetMaps data into Oracle. Creating Layers/Maps with Oracle Map Builder Setup Mapviewer Setup OBIEE Using maps and layers for creating Analysis (very basic). [coming someday] That's the plan, but it's possible that other topics will emerge, or some of these will split or disappear, or something else will happen. I will update this post to reflect all changes.…

Continue Reading