Changes

Jeemin Sim (Work Log) (view source)

803 bytes added , 14:06, 19 September 2017

'''ST_SRID(geometry)''': Returns the spatial reference identifier for the ST_Geometry as defined in spatial_ref_sys table.

'''ST_Transform(geometry, srid)''': Returns a new geometry with its coordinates transformed to the SRID referenced by the integer parameter.

*Native functions for geogrphy:

'''ST_AsText(geography) returns text

'''ST_GeographyFromText(text) returns geography

'''ST_AsBinary(geography) returns bytea

'''ST_GeogFromWKB(bytea) returns geography

'''ST_AsSVG(geography) returns text

'''ST_AsGML(geography) returns text

'''ST_AsKML(geography) returns text

'''ST_AsGeoJson(geography) returns text

'''ST_Distance(geography, geography) returns double

'''ST_DWithin(geography, geography, float8) returns boolean

ST_Area(geography) returns double

ST_Length(geography) returns double

ST_Covers(geography, geography) returns boolean

ST_CoveredBy(geography, geography) returns boolean

ST_Intersects(geography, geography) returns boolean

ST_Buffer(geography, float8) returns geography [1]

ST_Intersection(geography, geography) returns geography [1]

* Continue reading from: http://workshops.boundlessgeo.com/postgis-intro/joins_exercises.html

[[Category:Work Log]]

337

edits