1buffer - linestringz
2:memory: #use in-memory database
3SELECT AsText(Buffer(GeomFromText('LINESTRINGZ(1 2 1, 4 6 3)'), 1))
41 # rows (not including the header row)
51 # columns
6AsText(Buffer(GeomFromText('LINESTRINGZ(1 2 1, 4 6 3)'), 1))
7POLYGON Z((3.2 6.6 0, 3.232498 6.641046 0, 3.2671 6.680336 0, 3.30371 6.717761 0, 3.342229 6.753218 0, 3.382551 6.786611 0, 3.424565 6.817848 0, 3.468156 6.846843 0, 3.513206 6.873517 0, 3.559589 6.897796 0, 3.60718 6.919615 0, 3.655847 6.938914 0, 3.705458 6.955638 0, 3.755875 6.969744 0, 3.806963 6.981191 0, 3.858579 6.989949 0, 3.910582 6.995994 0, 3.962831 6.999309 0, 4.015182 6.999885 0, 4.067491 6.99772 0, 4.119615 6.99282 0, 4.171412 6.9852 0, 4.222738 6.974878 0, 4.273454 6.961885 0, 4.32342 6.946255 0, 4.3725 6.928032 0, 4.420559 6.907265 0, 4.467465 6.884011 0, 4.51309 6.858335 0, 4.557309 6.830305 0, 4.6 6.8 0, 4.641046 6.767502 0, 4.680336 6.7329 0, 4.717761 6.69629 0, 4.753218 6.657771 0, 4.786611 6.617449 0, 4.817848 6.575435 0, 4.846843 6.531844 0, 4.873517 6.486794 0, 4.897796 6.440411 0, 4.919615 6.39282 0, 4.938914 6.344153 0, 4.955638 6.294542 0, 4.969744 6.244125 0, 4.981191 6.193037 0, 4.989949 6.141421 0, 4.995994 6.089418 0, 4.999309 6.037169 0, 4.999885 5.984818 0, 4.99772 5.932509 0, 4.99282 5.880385 0, 4.9852 5.828588 0, 4.974878 5.777262 0, 4.961885 5.726546 0, 4.946255 5.67658 0, 4.928032 5.6275 0, 4.907265 5.579441 0, 4.884011 5.532535 0, 4.858335 5.48691 0, 4.830305 5.442691 0, 4.8 5.4 0, 1.8 1.4 0, 1.767502 1.358954 0, 1.7329 1.319664 0, 1.69629 1.282239 0, 1.657771 1.246782 0, 1.617449 1.213389 0, 1.575435 1.182152 0, 1.531844 1.153157 0, 1.486794 1.126483 0, 1.440411 1.102204 0, 1.39282 1.080385 0, 1.344153 1.061086 0, 1.294542 1.044362 0, 1.244125 1.030256 0, 1.193037 1.018809 0, 1.141421 1.010051 0, 1.089418 1.004006 0, 1.037169 1.000691 0, 0.984818 1.000115 0, 0.932509 1.00228 0, 0.880385 1.00718 0, 0.828588 1.0148 0, 0.777262 1.025122 0, 0.726546 1.038115 0, 0.67658 1.053745 0, 0.6275 1.071968 0, 0.579441 1.092735 0, 0.532535 1.115989 0, 0.48691 1.141665 0, 0.442691 1.169695 0, 0.4 1.2 0, 0.358954 1.232498 0, 0.319664 1.2671 0, 0.282239 1.30371 0, 0.246782 1.342229 0, 0.213389 1.382551 0, 0.182152 1.424565 0, 0.153157 1.468156 0, 0.126483 1.513206 0, 0.102204 1.559589 0, 0.080385 1.60718 0, 0.061086 1.655847 0, 0.044362 1.705458 0, 0.030256 1.755875 0, 0.018809 1.806963 0, 0.010051 1.858579 0, 0.004006 1.910582 0, 0.000691 1.962831 0, 0.000115 2.015182 0, 0.00228 2.067491 0, 0.00718 2.119615 0, 0.0148 2.171412 0, 0.025122 2.222738 0, 0.038115 2.273454 0, 0.053745 2.32342 0, 0.071968 2.3725 0, 0.092735 2.420559 0, 0.115989 2.467465 0, 0.141665 2.51309 0, 0.169695 2.557309 0, 0.2 2.6 0, 3.2 6.6 0))
8