Skip to Content
0

Using st_buffer to expand the track to the polygon

Nov 08, 2016 at 08:52 AM

67

avatar image

Hello everybody !

i have a track

select NEW ST_LINESTRING('LINESTRING (37.684232 50.410424,

37.684164 50.410588,

37.682384 50.417252,

37.681664 50.41722,

37.6809 50.417188,

37.680192 50.417156,

37.67948 50.41712,

37.678776 50.417072,

37.678016 50.417008)') from dummy;

i need to get polygon.Track equipment expanded to the 1 meter.

select NEW ST_LINESTRING('LINESTRING (37.684232 50.410424,

37.684164 50.410588,

37.682384 50.417252,

37.681664 50.41722,

37.6809 50.417188,

37.680192 50.417156,

37.67948 50.41712,

37.678776 50.417072,

37.678016 50.417008)').st_buffer(1.0,'metre') sgeo from dummy;

i get a very large polygon , tell me what i doing wrong ?

may be i must using anover sql scenario and function ?

I will be glad to any answers. Thank you.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers