Skip to Content
Previous

Load ESRI files via Eclipse

By Vitaliy Rudnytskiy

Load ESRI files via Eclipse

Details

You will learn

  • How to load ESRI shape files into SAP HANA using Eclipse

Add additional information: Background information, longer prerequisites


Step 1: Download Geotech files

Download two zip files from http://bit.ly/GeotechFiles to your computer.

Uncompress them.

Step 2: View file content with Mapshaper

Open Mapshaper web site and load Continents.zip file to check the content.

Step 3: Create a schema to load files

Create a schema GEOTECH using SQL.

CREATE SCHEMA "GEOTECH";
Step 4: Load files via Eclipse

In Eclipse in SAP HANA Administration go to File -> Import.

Select an import wizard for SAP HANA -> ESRI Shapefiles. Click Next

ESRI

Select you SAP HANA instance as a target, if asked by the wizard.

In Specify Location screen select the option to load from current client (i.e. from your laptop).

Click Browse and point to the directory Continets, where you uncompressed the zip file.

Find location

On Select ESRI Shapefiles to import you should see continent has been found in the directory and added to Selected Shapefiles.

Select shapes

On Options… screen type:
- Schema: GEOTECH
- Replace existing tables: checked
- Number of parallel threads: 4
- Spatial Reference Identifier: 1000004326

Select options

Click Finish

Step 5: Verify loaded data

Check there are 8 records loaded using SQL:

SELECT COUNT(*) FROM "GEOTECH"."continent";
Step 6: Load countries file

Repeat the same steps to load cntry00 data into "GEOTECH" schema as well.


Updated 09/13/2018

Time to Complete

20 Min.

Beginner

Prerequisites

  • Eclipse is setup for CodeJam exercises
Next
Back to top