ST_LineFromEncodedPolyline — 從編碼折線建立 LineString。
geometry ST_LineFromEncodedPolyline(
text polyline, integer precision=5)
;
從編碼折線字串建立 LineString。
可選的 precision
指定編碼折線中將保留的小數位數。編碼和解碼時此值應相同,否則坐標將不正確。
請參閱 http://developers.google.com/maps/documentation/utilities/polylinealgorithm
可用性: 2.2.0
-- Create a line string from a polyline SELECT ST_AsEWKT(ST_LineFromEncodedPolyline('_p~iF~ps|U_ulLnnqC_mqNvxq`@')); -- result -- SRID=4326;LINESTRING(-120.2 38.5,-120.95 40.7,-126.453 43.252) -- Select different precision that was used for polyline encoding SELECT ST_AsEWKT(ST_LineFromEncodedPolyline('_p~iF~ps|U_ulLnnqC_mqNvxq`@',6)); -- result -- SRID=4326;LINESTRING(-12.02 3.85,-12.095 4.07,-12.6453 4.3252)