Skip to Content
avatar image
Former Member

Using st_buffer to expand the track to the polygon

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers