postgis-workshop

geometries_exercises

English

Translate

Zen

	English	Actions
	Geometry Exercises
	Here's a reminder of all the functions we have seen so far. They should be useful for the exercises!
	:command:`sum(expression)` aggregate to return a sum for a set of records
	:command:`count(expression)` aggregate to return the size of a set of records
	:command:`ST_GeometryType(geometry)` returns the type of the geometry
	:command:`ST_NDims(geometry)` returns the number of dimensions of the geometry
	:command:`ST_SRID(geometry)` returns the spatial reference identifier number of the geometry
	:command:`ST_X(point)` returns the X ordinate
	:command:`ST_Y(point)` returns the Y ordinate
	:command:`ST_Length(linestring)` returns the length of the linestring
	:command:`ST_StartPoint(geometry)` returns the first coordinate as a point
	:command:`ST_EndPoint(geometry)` returns the last coordinate as a point
	:command:`ST_NPoints(geometry)` returns the number of coordinates in the linestring
	:command:`ST_Area(geometry)` returns the area of the polygons
	:command:`ST_NRings(geometry)` returns the number of rings (usually 1, more if there are holes)
	:command:`ST_ExteriorRing(polygon)` returns the outer ring as a linestring
	:command:`ST_InteriorRingN(polygon, integer)` returns a specified interior ring as a linestring
	:command:`ST_Perimeter(geometry)` returns the length of all the rings

Loading…

No matching activity found.

Browse all string changes

Things to check

Multiple failing checks

Following checks are failing:
Reused translation: Ukrainian, Chinese (Simplified)

Glossary

English	English
No related strings found in the glossary.

String information

Flags

read-only

Source string location

../../en/geometries_exercises.rst:8

String age

3 years ago

Last updated

a year ago

Source string age

3 years ago

Translation file

postgis-intro/sources/locale/pot/geometries_exercises.pot, string 3