337
edits
Changes
Jump to navigation
Jump to search
Jeemin Sim (Work Log) (view source)
Revision as of 09:57, 21 September 2017
, 09:57, 21 September 2017no edit summary
* Updated above notes on GIS
* Continue reading from:
====9/21/2017 THURSDAY''9AM-12:30PM''====
* Functions for Linear Referencing:
'''ST_LineInterpolatePoint(geometry A, double measure)''': Returns a point interpolated along a line.
'''ST_LineLocatePoint(geometry A, geometry B)''': Returns a float between 0 and 1 representing the location of the closest point on LineString to the given Point.
'''ST_Line_Substring(geometry A, double from, double to)''': Return a linestring being a substring of the input one starting and ending at the given fractions of total 2d length.
'''ST_Locate_Along_Measure(geometry A, double measure)''': Return a derived geometry collection value with elements that match the specified measure.
'''ST_Locate_Between_Measures(geometry A, double from, double to)''': Return a derived geometry collection value with elements that match the specified range of measures inclusively.
'''ST_AddMeasure(geometry A, double from, double to)''': Return a derived geometry with measure elements linearly interpolated between the start and end points. If the geometry has no measure dimension, one is added.
[[Category:Work Log]]
