Daten-Ansicht
Datensatz einfügen Tabellenstruktur bearbeiten
Tabelle `configDB`.`help_topic`
Datensätze 1 - 30 von insgesamt 802 << < > >>
Ansicht: kompakt Die Abfrage enthält 1 Spalten | ||
# | description | |
---|---|---|
1. | Help Contents generated from the MariaDB Knowledge Base on 23 January 2023. | |
2. | A synonym for ST_AREA.
URL: https://mariadb.com/kb/en/polygon-properties-area/ | |
3. | A synonym for ST_CENTROID.
URL: https://mariadb.com/kb/en/centroid/ | |
4. | A synonym for ST_ExteriorRing.
URL: https://mariadb.com/kb/en/polygon-properties-exteriorring/ | |
5. | A synonym for ST_InteriorRingN.
URL: https://mariadb.com/kb/en/polygon-properties-interiorringn/ | |
6. | A synonym for ST_NumInteriorRings.
URL: https://mariadb.com/kb/en/polygon-properties-numinteriorrings/ | |
7. | Syntax
------
ST_Area(poly)
Area(poly)
Description
-----------
Returns as a double-precision number the area of the Polygon value poly, as
measured in its spatial reference system.
ST_Area() and Area() are synonyms.
Examples
--------
SET @poly = 'Polygon((0 0,0 3,3 0,0 0),(1 1,1 2,2 1,1 1))';
SELECT Area(GeomFromText(@poly));
+---------------------------+
| Area(GeomFromText(@poly)) |
+---------------------------+
| 4 |
+---------------------------+
URL: https://mariadb.com/kb/en/st_area/ | |
8. | Syntax
------
ST_Centroid(mpoly)
Centroid(mpoly)
Description
-----------
Returns a point reflecting the mathematical centroid (geometric center) for
the MultiPolygon mpoly. The resulting point will not necessarily be on the
MultiPolygon.
ST_Centroid() and Centroid() are synonyms.
Examples
--------
SET @poly = ST_GeomFromText('POLYGON((0 0,20 0,20 20,0 20,0 0))');
SELECT ST_AsText(ST_Centroid(@poly)) AS center;
+--------------+
| center |
+--------------+
| POINT(10 10) |
+--------------+
URL: https://mariadb.com/kb/en/st_centroid/ | |
9. | Syntax
------
ST_ExteriorRing(poly)
ExteriorRing(poly)
Description
-----------
Returns the exterior ring of the Polygon value poly as a LineString.
ST_ExteriorRing() and ExteriorRing() are synonyms.
Examples
--------
SET @poly = 'Polygon((0 0,0 3,3 3,3 0,0 0),(1 1,1 2,2 2,2 1,1 1))';
SELECT AsText(ExteriorRing(GeomFromText(@poly)));
+-------------------------------------------+
| AsText(ExteriorRing(GeomFromText(@poly))) |
+-------------------------------------------+
| LINESTRING(0 0,0 3,3 3,3 0,0 0) |
+-------------------------------------------+
URL: https://mariadb.com/kb/en/st_exteriorring/ | |
10. | Syntax
------
ST_InteriorRingN(poly,N)
InteriorRingN(poly,N)
Description
-----------
Returns the N-th interior ring for the Polygon value poly as a LineString.
Rings are numbered beginning with 1.
ST_InteriorRingN() and InteriorRingN() are synonyms.
Examples
--------
SET @poly = 'Polygon((0 0,0 3,3 3,3 0,0 0),(1 1,1 2,2 2,2 1,1 1))';
SELECT AsText(InteriorRingN(GeomFromText(@poly),1));
+----------------------------------------------+
| AsText(InteriorRingN(GeomFromText(@poly),1)) |
+----------------------------------------------+
| LINESTRING(1 1,1 2,2 2,2 1,1 1) |
+----------------------------------------------+
URL: https://mariadb.com/kb/en/st_interiorringn/ | |
11. | Syntax
------
ST_NumInteriorRings(poly)
NumInteriorRings(poly)
Description
-----------
Returns an integer containing the number of interior rings in the Polygon
value poly.
Note that according the the OpenGIS standard, a POLYGON should have exactly
one ExteriorRing and all other rings should lie within that ExteriorRing and
thus be the InteriorRings. Practically, however, some systems, including
MariaDB's, permit polygons to have several 'ExteriorRings'. In the case of
there being multiple, non-overlapping exterior rings ST_NumInteriorRings()
will return 1.
ST_NumInteriorRings() and NumInteriorRings() are synonyms.
Examples
--------
SET @poly = 'Polygon((0 0,0 3,3 3,3 0,0 0),(1 1,1 2,2 2,2 1,1 1))';
SELECT NumInteriorRings(GeomFromText(@poly));
+---------------------------------------+
| NumInteriorRings(GeomFromText(@poly)) |
+---------------------------------------+
| 1 |
+---------------------------------------+
Non-overlapping 'polygon':
SELECT ST_NumInteriorRings(ST_PolyFromText('POLYGON((0 0,10 0,10 10,0 10,0 0),
(-1 -1,-5 -1,-5 -5,-1 -5,-1 -1))')) AS NumInteriorRings;
+------------------+
| NumInteriorRings |
+------------------+
| 1 |
+------------------+
URL: https://mariadb.com/kb/en/st_numinteriorrings/ | |
12. | Description
-----------
The Well-Known Text (WKT) representation of Geometry is designed to exchange
geometry data in ASCII form. Examples of the basic geometry types include:
+-----------------------------------------------------------------------------+
| Geometry Types |
+-----------------------------------------------------------------------------+
| POINT |
+-----------------------------------------------------------------------------+
| LINESTRING |
+-----------------------------------------------------------------------------+
| POLYGON |
+-----------------------------------------------------------------------------+
| MULTIPOINT |
+-----------------------------------------------------------------------------+
| MULTILINESTRING |
+-----------------------------------------------------------------------------+
| MULTIPOLYGON |
+-----------------------------------------------------------------------------+
| GEOMETRYCOLLECTION |
+-----------------------------------------------------------------------------+
| GEOMETRY |
+-----------------------------------------------------------------------------+
URL: https://mariadb.com/kb/en/wkt-definition/ | |
13. | A synonym for ST_AsText().
URL: https://mariadb.com/kb/en/wkt-astext/ | |
14. | A synonym for ST_AsText().
URL: https://mariadb.com/kb/en/wkt-aswkt/ | |
15. | A synonym for ST_GeomCollFromText.
URL: https://mariadb.com/kb/en/wkt-geomcollfromtext/ | |
16. | A synonym for ST_GeomCollFromText.
URL: https://mariadb.com/kb/en/geometrycollectionfromtext/ | |
17. | A synonym for ST_GeomFromText.
URL: https://mariadb.com/kb/en/geometryfromtext/ | |
18. | A synonym for ST_GeomFromText.
URL: https://mariadb.com/kb/en/wkt-geomfromtext/ | |
19. | A synonym for ST_LineFromText.
URL: https://mariadb.com/kb/en/wkt-linefromtext/ | |
20. | A synonym for ST_LineFromText.
URL: https://mariadb.com/kb/en/linestringfromtext/ | |
21. | Syntax
------
MLineFromText(wkt[,srid])
MultiLineStringFromText(wkt[,srid])
Description
-----------
Constructs a MULTILINESTRING value using its WKT representation and SRID.
MLineFromText() and MultiLineStringFromText() are synonyms.
Examples
--------
CREATE TABLE gis_multi_line (g MULTILINESTRING);
SHOW FIELDS FROM gis_multi_line;
INSERT INTO gis_multi_line VALUES
(MultiLineStringFromText('MULTILINESTRING((10 48,10 21,10 0),(16 0,16
23,16 48))')),
(MLineFromText('MULTILINESTRING((10 48,10 21,10 0))')),
(MLineFromWKB(AsWKB(MultiLineString(
LineString(Point(1, 2), Point(3, 5)),
LineString(Point(2, 5), Point(5, 8), Point(21, 7))))));
URL: https://mariadb.com/kb/en/mlinefromtext/ | |
22. | Syntax
------
MPointFromText(wkt[,srid])
MultiPointFromText(wkt[,srid])
Description
-----------
Constructs a MULTIPOINT value using its WKT representation and SRID.
MPointFromText() and MultiPointFromText() are synonyms.
Examples
--------
CREATE TABLE gis_multi_point (g MULTIPOINT);
SHOW FIELDS FROM gis_multi_point;
INSERT INTO gis_multi_point VALUES
(MultiPointFromText('MULTIPOINT(0 0,10 10,10 20,20 20)')),
(MPointFromText('MULTIPOINT(1 1,11 11,11 21,21 21)')),
(MPointFromWKB(AsWKB(MultiPoint(Point(3, 6), Point(4, 10)))));
URL: https://mariadb.com/kb/en/mpointfromtext/ | |
23. | Syntax
------
MPolyFromText(wkt[,srid])
MultiPolygonFromText(wkt[,srid])
Description
-----------
Constructs a MULTIPOLYGON value using its WKT representation and SRID.
MPolyFromText() and MultiPolygonFromText() are synonyms.
Examples
--------
CREATE TABLE gis_multi_polygon (g MULTIPOLYGON);
SHOW FIELDS FROM gis_multi_polygon;
INSERT INTO gis_multi_polygon VALUES
(MultiPolygonFromText('MULTIPOLYGON(
((28 26,28 0,84 0,84 42,28 26),(52 18,66 23,73 9,48 6,52 18)),
((59 18,67 18,67 13,59 13,59 18)))')),
(MPolyFromText('MULTIPOLYGON(
((28 26,28 0,84 0,84 42,28 26),(52 18,66 23,73 9,48 6,52 18)),
((59 18,67 18,67 13,59 13,59 18)))')),
(MPolyFromWKB(AsWKB(MultiPolygon(Polygon(
LineString(Point(0, 3), Point(3, 3), Point(3, 0), Point(0, 3)))))));
URL: https://mariadb.com/kb/en/mpolyfromtext/ | |
24. | A synonym for MLineFromText.
URL: https://mariadb.com/kb/en/multilinestringfromtext/ | |
25. | A synonym for MPointFromText.
URL: https://mariadb.com/kb/en/multipointfromtext/ | |
26. | A synonym for MPolyFromText.
URL: https://mariadb.com/kb/en/multipolygonfromtext/ | |
27. | A synonym for ST_PointFromText.
URL: https://mariadb.com/kb/en/wkt-pointfromtext/ | |
28. | A synonym for ST_PolyFromText.
URL: https://mariadb.com/kb/en/wkt-polyfromtext/ | |
29. | A synonym for ST_PolyFromText.
URL: https://mariadb.com/kb/en/polygonfromtext/ | |
30. | Syntax
------
ST_AsText(g)
AsText(g)
ST_AsWKT(g)
AsWKT(g)
Description
-----------
Converts a value in internal geometry format to its WKT representation and
returns the string result.
ST_AsText(), AsText(), ST_AsWKT() and AsWKT() are all synonyms.
Examples
--------
SET @g = 'LineString(1 1,4 4,6 6)';
SELECT ST_AsText(ST_GeomFromText(@g));
+--------------------------------+
| ST_AsText(ST_GeomFromText(@g)) |
+--------------------------------+
| LINESTRING(1 1,4 4,6 6) |
+--------------------------------+
URL: https://mariadb.com/kb/en/st_astext/ |
Datensätze 1 - 30 von insgesamt 802 << < > >>