* 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]]