SapHanaTutorial.Com HOME     Learning-Materials Interview-Q&A Certifications Quiz Online-Courses Forum Jobs Trendz FAQs  
     Explore The World of Hana With Us     
About Us
Contact Us
 Apps
X
HANA App
>>>
Hadoop App
>>>
Tutorial App on SAP HANA
This app is an All-In-One package to provide everything to HANA Lovers.

It contains
1. Courses on SAP HANA - Basics, Modeling and Administration
2. Multiple Quizzes on Overview, Modelling, Architeture, and Administration
3. Most popular articles on SAP HANA
4. Series of Interview questions to brushup your HANA skills
Tutorial App on Hadoop
This app is an All-In-One package to provide everything to Hadoop Lovers.

It contains
1. Courses on Hadoop - Basics and Advanced
2. Multiple Quizzes on Basics, MapReduce and HDFS
3. Most popular articles on Hadoop
4. Series of Interview questions to brushup your skills
Apps
HANA App
Hadoop App
';
Search
Stay Connected
Search Topics
Topic Index
+
-
SAP HANA Modeling
+
-
Spatial Processing
+
-
Predictive Analysis

Accessing and Manipulating Spatial Data

In previous article SAP HANA Spatial Processing, we explained main features of Spatial processing in HANA.
In this article, we will describes the types, methods, and constructors you can use to access, manipulate, and analyze spatial data. The spatial data types can be considered like data types or classes. Each spatial data type has associated methods and constructors you use to access the data.

ST_Geometry Type:

The ST_Geometry type is the maximal supertype of the geometry type hierarchy.
Direct subtypes:
  • ST_LineString type
  • ST_MultiLineString type
  • ST_MultiPoint type
  • ST_MultiPolygon type
  • ST_Point type
  • ST_Polygon type
  • ST_GeometryCollection type
  • ST_CircularString type

Methods of ST_Geometry:
ST_AsBinary
ST_AsEWKB
ST_AsEWKT
ST_AsGeoJSON
ST_AsText
ST_AsWKB
ST_AsWKT
ST_AsSVG
ST_AsSVGAggr
ST_Boundary
ST_Buffer
ST_Contains
ST_CoveredBy
ST_Covers
ST_ConvexHull
ST_Crosses
ST_Difference
ST_Dimension
ST_Disjoint
ST_Distance
ST_Envelope
ST_Equals
ST_GeomFromEWKB
ST_GeomFromEWKT
ST_GeomFromText
ST_GeomFromWKB
ST_GeomFromWKT
ST_GeometryType
ST_Intersection
ST_Intersects
ST_IntersectsFilter
ST_IntersectsRect
ST_Is3D
ST_IsEmpty
ST_IsMeasured
ST_IsSimple
ST_IsValid
ST_MMax
ST_MMin
ST_NumInteriorRings
ST_NumInteriorRing
ST_OrderingEquals
ST_Overlaps
ST_PointOnSurface
ST_Relate
ST_SRID
ST_SnapToGrid
ST_SymDifference
ST_Touches
ST_Transform
ST_UnionAggr
ST_WithinDistance
ST_Within
ST_XMax
ST_XMin
ST_YMax
ST_YMin
ST_ZMax
ST_ZMin




ST_Point Type:

The ST_Point type is a 0-dimensional geometry and represents a single location.

Methods of ST_Point:
ST_M
ST_X
ST_Y
ST_Z

All methods of ST_Geometry can also be called on a ST_Point type:
ST_AsBinary
ST_AsGeoJSON
ST_AsText
ST_AsWKB
ST_AsWKT
ST_Contains
ST_ConvexHull
ST_Crosses
ST_Dimension
ST_Distance
ST_Envelope
ST_Equals
ST_GeomFromText
ST_GeometryType
ST_Intersection
ST_Intersects
ST_IntersectsRect
ST_Is3D
ST_IsEmpty
ST_IsValid
ST_OrderingEquals
ST_SRID
ST_SnapToGrid
ST_WithinDistance
ST_XMax
ST_XMin
ST_YMax
ST_YMin


To see list of all supported types and methods refer to the link SAP HANA Spatial Reference.



Support us by sharing this article.



Explore More
Close X
Close X

Leave a Reply

Your email address will not be published. Required fields are marked *

Current day month ye@r *

 © 2017 : saphanatutorial.com, All rights reserved.  Privacy Policy