337
edits
Changes
Jump to navigation
Jump to search
Jeemin Sim (Work Log) (view source)
Revision as of 09:53, 19 September 2017
, 09:53, 19 September 2017→9/19/2017 TUESDAY'9AM-10:40AM & 1PM-2:20PM
* Continue reading from: http://workshops.boundlessgeo.com/postgis-intro/joins.html
====9/19/2017 TUESDAY''9AM-10:40AM & 1PM-2:20PM''====* Useful sum(expression): aggregate to return a sum for a set of recordscount(expression): aggregate to return the size of a set of recordsST_Area(geometry) returns the area of the polygonsST_AsText(geometry) returns WKT textST_Contains(geometry A, geometry B) returns the true if geometry A contains geometry B** SomethingST_Distance(geometry A, geometry B) returns the minimum distance between geometry A and geometry BST_DWithin(geometry A, geometry B, radius) returns the true if geometry A is radius distance or less from geometry BST_GeomFromText(text) returns geometryST_Intersects(geometry A, geometry B) returns the true if geometry A intersects geometry BST_Length(linestring) returns the length of the linestringST_Touches(geometry A, geometry B) returns the true if the boundary of geometry A touches geometry BST_Within(geometry A, geometry B) returns the true if geometry A is within geometry B
[[Category:Work Log]]
