IMPORT NATURAL_EARTH.NE_110M_LAND AS SHAPEFILE FROM '/usr/sap/HXE/HDB00/work/ne_110m_land' WITH SRID 1000004326 Obviously, the user running this and other SQL statements has to have developers rights in SAP HANA. WGS 1984 is the one supported by SAP HANA out of the box with two Spatial Reference Systems: 4326 for the round Earth and 1000004326 for the planar projection.Īll I needed was to load the content of this shapefile into a table with correct SRS id using the following SQL statement. prj file to make sure it is not using some exotic Geographic coordinate system. So, I downloaded the file ne_110m_land.zip from, copied it into /usr/sap/HXE/HDB00/work/ on my HANA Express host and unzipped. To start with my example I needed a shapefile with all Earth’s lands, which I found at a public domain project Natural Earth. You can try it out too, so follow along with me! And if you are not familiar with geospatial processing yet, just do introduction tutorials first. When I was thinking about an example to showcase the use of SRS, the idea of producing ASCII map from Earth shapefiles came to my mind.įor this showcase I used a free SAP HANA 1 SP12, express edition. It has geospatial processing enabled already as a part of the installation.
#One line ascii art series#
In addition to tutorials previously announced, recently I published last two tutorials in a series introducing SAP HANA geospatial processing: The ASCII art left a mark in the history of SAP UI too: Last year mankind celebrated 50th anniversary of the ASCII art: presenting graphics using only 95 printable characters defined by the ASCII Standard from 1963.
0 kommentar(er)
