* Useful functions for spatial joins:
**'''sum(expression)''': aggregate to return a sum for a set of records **'''count(expression)''': aggregate to return the size of a set of records **'''ST_Area(geometry)''' returns the area of the polygons** '''ST_AsText(geometry)''' returns WKT text** '''ST_Contains(geometry A, geometry B)''' returns the true if geometry A contains geometry B** '''ST_Distance(geometry A, geometry B)''' returns the minimum distance between geometry A and geometry B** '''ST_DWithin(geometry A, geometry B, radius)''' returns the true if geometry A is radius distance or less from geometry B** '''ST_GeomFromText(text)''' returns geometry** '''ST_Intersects(geometry A, geometry B)''' returns the true if geometry A intersects geometry B** '''ST_Length(linestring)''' returns the length of the linestring** '''ST_Touches(geometry A, geometry B)''' returns the true if the boundary of geometry A touches geometry B** '''ST_Within(geometry A, geometry B)''' returns the true if geometry A is within geometry B
[[Category:Work Log]]