Skip to content

Commit 1242f04

Browse files
Streamlining Spatial tuts 1,2,3
1 parent 3402f45 commit 1242f04

3 files changed

Lines changed: 9 additions & 11 deletions

File tree

tutorials/hana-spatial-intro1-point/hana-spatial-intro1-point.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,6 @@
11
---
22
title: Intro to SAP HANA Spatial: Points
3-
description: The spatial point type is a 0-dimensional geometry and represents a single location
3+
description: A point is a 0-dimensional geometry representing a single location
44
tags: [ tutorial>beginner, topic>big-data, topic>sql, products>sap-hana, products>sap-hana,-express-edition ]
55
---
66
## Prerequisites

tutorials/hana-spatial-intro2-string/hana-spatial-intro2-string.md

Lines changed: 3 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -1,15 +1,14 @@
11
---
22
title: Intro to SAP HANA Spatial: Strings
3-
description: Strings (curves in more general) in spatial connect points
3+
description: A string ('a curve' in more general) connects points
44
tags: [ tutorial>beginner, topic>big-data, topic>sql, products>sap-hana, products>sap-hana,-express-edition ]
55
---
66
## Prerequisites
77
- **Proficiency:** Beginner
88
- **Tutorials:** [Intro to SAP HANA Spatial: Points](http://go.sap.com/developer/tutorials/hana-spatial-intro1-point.html)
99

1010
## Next Steps
11-
- Intro to SAP HANA Spatial: Polygons (coming soon), or
12-
- Select a tutorial from the [Tutorial Navigator](http://go.sap.com/developer/tutorial-navigator.html) or the [Tutorial Catalog](http://go.sap.com/developer/tutorials.html)
11+
- [Intro to SAP HANA Spatial: Polygons](http://go.sap.com/developer/tutorials/hana-spatial-intro3-polygon.html)
1312

1413
## Details
1514
### You will learn
@@ -131,5 +130,4 @@ You will continue learning basics of spatial processing now with ___strings___ (
131130
- Check SAP HANA Spatial Reference at http://help.sap.com/hana_platform
132131

133132
## Next Steps
134-
- Intro to SAP HANA Spatial: Polygons (coming soon), or
135-
- Select a tutorial from the [Tutorial Navigator](http://go.sap.com/developer/tutorial-navigator.html) or the [Tutorial Catalog](http://go.sap.com/developer/tutorials.html)
133+
- [Intro to SAP HANA Spatial: Polygons](http://go.sap.com/developer/tutorials/hana-spatial-intro3-polygon.html)

tutorials/hana-spatial-intro3-polygon/hana-spatial-intro3-polygon.md

Lines changed: 5 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -62,13 +62,13 @@ You will continue learning basics of spatial processing now with ___polygons___
6262
SELECT NEW ST_Polygon('Polygon ((0 0, 4 0, 0 3, 0 0), (0.5 0.5, 0.5 1.5, 1.5 1.5, 1 0.5, 0.5 0.5))').ST_Boundary().ST_asWKT() FROM dummy;
6363
```
6464

65-
![Boundary of the polygon](spatial0302.jpg)
65+
![Boundary of the polygon](spatial0303.jpg)
6666

6767
The result is a `MultiLineString` containing two `LineStrings`. One representing a triangle and another representing a square.
6868

6969
`MultiLineString` is another spatial type, which is a collection of line strings. There are two more spatial collection types supported by SAP HANA: `MultiPoint` and `MultiPolygon`. Names are intuitive enough to understand what they represent.
7070

71-
Strings too have their boundaries, represented by their endpoints, except when they are rings. Rings - curves where the start point is the same as the end point and there are no self-intersections have no boundaries.
71+
Strings too have their boundaries, represented by their endpoints, except when they are rings. Rings - curves where the start point is the same as the end point and there are no self-intersections - have no boundaries.
7272

7373
Check boundaries of a triangle string from the previous query.
7474

@@ -86,7 +86,7 @@ You will continue learning basics of spatial processing now with ___polygons___
8686
SELECT NEW ST_LineString('LineString (0 0,4 0,0 3,1 0)').ST_Boundary().ST_asWKT() FROM dummy;
8787
```
8888

89-
The result is a `MultiPoint` containing two end points.
89+
The result is a `MultiPoint` collection containing two end points.
9090

9191
![Multipoint boundary](spatial0305.jpg)
9292

@@ -102,11 +102,11 @@ You will continue learning basics of spatial processing now with ___polygons___
102102
SELECT NEW ST_Point (1,1).ST_Within(NEW ST_Polygon('Polygon ((0 0, 4 0, 0 3, 0 0), (0.5 0.5, 0.5 1.5, 1.5 1.5, 1 0.5, 0.5 0.5))')) FROM dummy;
103103
```
104104
105-
Indeed the point (1, 1) is not within interior of your polygon form the earlier exercise, defined by external ring in the shape of triangle and internal ring in the shape of a square. An are within a square is the ___exterior___ of that geometry.
105+
Indeed the point (1, 1) is not within ___interior___ of your polygon form the earlier exercise, defined by external ring in the shape of triangle and internal ring in the shape of a square. An area inside a square is the ___exterior___ of this particular geometry.
106106
107107
![Within linestring polygon](spatial0307.jpg)
108108
109-
7. To check if a point is within a circle you use `ST_Boundary()` method defining the area of a particular distance from a circle's center point.
109+
7. To check if a point is within a given disk you use `ST_Boundary()` method defining the circle around an area of a particular distance from a central point.
110110
111111
```sql
112112
SELECT NEW ST_Point (1,1).ST_Within(NEW ST_Point(0, 0).ST_Buffer(2)) FROM dummy;

0 commit comments

Comments
 (0)