More spatial reference systems can be added in SAP HANA Cloud and on-prem SAP HANA 2.0 from SPS05 using CREATE PREDEFINED SPATIAL REFERENCE SYSTEM IDENTIFIED BY <srs-id>
statement.
For SAP HANA 2.0 prior to SPS05 more spatial reference systems can be manually created or loaded into the SAP HANA using separate Geospatial Metadata Installer. Geospatial Metadata Installer is available for registered customers and partners.
Let’s add the SRS used for the original World Mercator projection.
In SAP HANA Cloud and SAP HANA 2.0 starting from SPS05 execute the following statement.
CREATE PREDEFINED SPATIAL REFERENCE SYSTEM
IDENTIFIED BY 3395;
In SAP HANA 2.0 prior to SPS05 execute the following statement.
CREATE SPATIAL REFERENCE SYSTEM "WGS 84 / World Mercator"
IDENTIFIED BY 3395
DEFINITION 'PROJCS["WGS 84 / World Mercator",GEOGCS["WGS 84",DATUM["WGS_1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4326"]],PROJECTION["Mercator_1SP"],PARAMETER["central_meridian",0],PARAMETER["scale_factor",1],PARAMETER["false_easting",0],PARAMETER["false_northing",0],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["Easting",EAST],AXIS["Northing",NORTH],AUTHORITY["EPSG","3395"]]'
ORGANIZATION "EPSG" IDENTIFIED BY 3395
TRANSFORM DEFINITION '+proj=merc +lon_0=0 +k=1 +x_0=0 +y_0=0 +datum=WGS84 +units=m +no_defs '
TYPE PLANAR
COORDINATE X BETWEEN -20037508.342789248 AND 20037508.342789248
COORDINATE Y BETWEEN -15496570.739723722 AND 18764656.231380586
TOLERANCE DEFAULT
SNAP TO GRID DEFAULT
POLYGON FORMAT 'EvenOdd'
STORAGE FORMAT 'Internal';
Confused about the whole cryptic notation in the definition? No need to worry for now. All you need to know is that its definition comes from industry registry EPSG Geodetic Parameter Registry that you can search and download if needed.
Once SQL statements above are executed successfully you should see these new SRS
ids in ST_SPATIAL_REFERENCE_SYSTEMS
view.
What is the numeric id of the Spatial Reference System that implements geodetic coordinate system of the Global Positioning System (GPS
), known as WGS 84
?