Wednesday, November 8, 2017

Maps - How to convert a Map Shapefile to geoJSON for use in Oracle DV

Have geographic map layer data sitting in a shapefile format and would like to visualize it in Oracle Data Visualization? In this blog we will discuss how to use Oracle tools to convert a shapefile into geoJSON format for use in Oracle Data Visualization.

Shapefile format is a digital vector storage format for storing geometric location and associated attribute information. The shapefile format can spatially describe vector features like points, lines, and polygons representing different kind of geographies.  File name extension of shapefiles is .shpMore information on shapefiles can be found here. 



GeoJSON is a format for encoding a variety of geographic data structures like maps of Cities, State, countries etc. Oracle DV supports custom map layers defined in GeoJSON formats.   

Using Oracle Map Builder you can convert shapefiles to geoJSON files. GeoJSON can be directly uploaded into OracleDV as a custom map layer and the data can be visualized directly on top of the Map layer. See detailed instructions here

Overview of steps involved:

1) Install Oracle Map Builder .
2) Use Export to JSON feature in Map Builder and use ShapefileSDP as source type and use the shape file to convert.
3) Choose appropriate key columns and SRID to do the conversion.

Are you an Oracle Analytics customer or user?

We want to hear your story!

Please voice your experience and provide feedback with a quick product review for Oracle Analytics Cloud!
 
.

2 comments:

Post a Comment