postgis-workshop

joins_exercises

English

Translate

Zen

	English	Actions
	Spatial Joins Exercises
	Here's a reminder of some of the functions we have seen. Hint: 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_Area(geometry)` returns the area of the polygons
	:command:`ST_AsText(geometry)` returns WKT ``text``
	:command:`ST_Contains(geometry A, geometry B)` returns the true if geometry A contains geometry B
	:command:`ST_Distance(geometry A, geometry B)` returns the minimum distance between geometry A and geometry B
	:command:`ST_DWithin(geometry A, geometry B, radius)` returns the true if geometry A is radius distance or less from geometry B
	:command:`ST_GeomFromText(text)` returns ``geometry``
	:command:`ST_Intersects(geometry A, geometry B)` returns the true if geometry A intersects geometry B
	:command:`ST_Length(linestring)` returns the length of the linestring
	:command:`ST_Touches(geometry A, geometry B)` returns the true if the boundary of geometry A touches geometry B
	:command:`ST_Within(geometry A, geometry B)` returns the true if geometry A is within geometry B
	Also remember the tables we have available:
	``nyc_census_blocks``
	name, popn_total, boroname, geom
	``nyc_streets``
	name, type, geom

Loading…

No matching activity found.

Browse all string changes

Things to check

Multiple failing checks

Following checks are failing:
Reused translation: Ukrainian, Spanish

Glossary

English	English
No related strings found in the glossary.

String information

Flags

read-only

Source string location

../../en/joins_exercises.rst:9

String age

3 years ago

Last updated

a year ago

Source string age

3 years ago

Translation file

postgis-intro/sources/locale/pot/joins_exercises.pot, string 4