1buffer2
2:memory: #use in-memory database
3SELECT AsText(Buffer(GeomFromText('LINESTRING(0 0, 100 0)'), 1));
41 # rows (not including the header row)
51 # columns
6AsText(Buffer(GeomFromText('LINESTRING(0 0, 100 0)'), 1))
7POLYGON((100 1, 100.052336 0.99863, 100.104528 0.994522, 100.156434 0.987688, 100.207912 0.978148, 100.258819 0.965926, 100.309017 0.951057, 100.358368 0.93358, 100.406737 0.913545, 100.45399 0.891007, 100.5 0.866025, 100.544639 0.838671, 100.587785 0.809017, 100.62932 0.777146, 100.669131 0.743145, 100.707107 0.707107, 100.743145 0.669131, 100.777146 0.62932, 100.809017 0.587785, 100.838671 0.544639, 100.866025 0.5, 100.891007 0.45399, 100.913545 0.406737, 100.93358 0.358368, 100.951057 0.309017, 100.965926 0.258819, 100.978148 0.207912, 100.987688 0.156434, 100.994522 0.104528, 100.99863 0.052336, 101 0, 100.99863 -0.052336, 100.994522 -0.104528, 100.987688 -0.156434, 100.978148 -0.207912, 100.965926 -0.258819, 100.951057 -0.309017, 100.93358 -0.358368, 100.913545 -0.406737, 100.891007 -0.45399, 100.866025 -0.5, 100.838671 -0.544639, 100.809017 -0.587785, 100.777146 -0.62932, 100.743145 -0.669131, 100.707107 -0.707107, 100.669131 -0.743145, 100.62932 -0.777146, 100.587785 -0.809017, 100.544639 -0.838671, 100.5 -0.866025, 100.45399 -0.891007, 100.406737 -0.913545, 100.358368 -0.93358, 100.309017 -0.951057, 100.258819 -0.965926, 100.207912 -0.978148, 100.156434 -0.987688, 100.104528 -0.994522, 100.052336 -0.99863, 100 -1, 0 -1, -0.052336 -0.99863, -0.104528 -0.994522, -0.156434 -0.987688, -0.207912 -0.978148, -0.258819 -0.965926, -0.309017 -0.951057, -0.358368 -0.93358, -0.406737 -0.913545, -0.45399 -0.891007, -0.5 -0.866025, -0.544639 -0.838671, -0.587785 -0.809017, -0.62932 -0.777146, -0.669131 -0.743145, -0.707107 -0.707107, -0.743145 -0.669131, -0.777146 -0.62932, -0.809017 -0.587785, -0.838671 -0.544639, -0.866025 -0.5, -0.891007 -0.45399, -0.913545 -0.406737, -0.93358 -0.358368, -0.951057 -0.309017, -0.965926 -0.258819, -0.978148 -0.207912, -0.987688 -0.156434, -0.994522 -0.104528, -0.99863 -0.052336, -1 0, -0.99863 0.052336, -0.994522 0.104528, -0.987688 0.156434, -0.978148 0.207912, -0.965926 0.258819, -0.951057 0.309017, -0.93358 0.358368, -0.913545 0.406737, -0.891007 0.45399, -0.866025 0.5, -0.838671 0.544639, -0.809017 0.587785, -0.777146 0.62932, -0.743145 0.669131, -0.707107 0.707107, -0.669131 0.743145, -0.62932 0.777146, -0.587785 0.809017, -0.544639 0.838671, -0.5 0.866025, -0.45399 0.891007, -0.406737 0.913545, -0.358368 0.93358, -0.309017 0.951057, -0.258819 0.965926, -0.207912 0.978148, -0.156434 0.987688, -0.104528 0.994522, -0.052336 0.99863, 0 1, 100 1))
8
9