Skip to Content
0
Sep 07, 2016 at 03:39 PM

st_buffer does not work ?

27 Views

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 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 ?