337
edits
Changes
Jump to navigation
Jump to search
Jeemin Sim (Work Log) (view source)
Revision as of 09:58, 19 September 2017
, 09:58, 19 September 2017→9/19/2017 TUESDAY9AM-10:40AM & 1PM-2:20PM
* 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
