on 11-08-2016 8:52 AM
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.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.