1
2
3
4
5
6
7
|
buffer7
:memory: #use in-memory database
SELECT AsText(ST_ForceLHR(Buffer(GeomFromText('POLYGON((136 -35, 135.2 -34.5, 136 -35.2, 136 -35, 135.2 -34.5))'), 1)));
1 # rows (not including the header row)
1 # columns
AsText(ST_ForceLHR(Buffer(GeomFromText('POLYGON((136 -35, 135.2 -34.5, 136 -35.2, 136 -35, 135.2 -34.5))'), 1)))
POLYGON((134.670001 -35.347998, 134.626347 -35.319098, 134.584264 -35.287953, 134.54387 -35.254648, 134.505274 -35.219275, 134.468582 -35.18193, 134.433895 -35.142716, 134.401308 -35.10174, 134.37091 -35.059115, 134.342784 -35.014958, 134.317008 -34.969389, 134.293653 -34.922533, 134.272781 -34.874519, 134.254451 -34.825479, 134.238712 -34.775547, 134.225609 -34.72486, 134.215176 -34.673556, 134.207442 -34.621776, 134.202429 -34.569663, 134.200151 -34.517358, 134.200612 -34.465007, 134.203813 -34.412751, 134.209745 -34.360734, 134.218391 -34.309099, 134.229727 -34.257987, 134.243723 -34.207538, 134.26034 -34.157892, 134.279532 -34.109182, 134.301247 -34.061544, 134.325426 -34.015108, 134.352002 -33.970001, 134.380902 -33.926347, 134.412047 -33.884264, 134.445352 -33.84387, 134.480725 -33.805274, 134.51807 -33.768582, 134.557284 -33.733895, 134.59826 -33.701308, 134.640885 -33.67091, 134.685042 -33.642784, 134.730611 -33.617008, 134.777467 -33.593653, 134.825481 -33.572781, 134.874521 -33.554451, 134.924453 -33.538712, 134.97514 -33.525609, 135.026444 -33.515176, 135.078224 -33.507442, 135.130337 -33.502429, 135.182642 -33.500151, 135.234993 -33.500612, 135.287249 -33.503813, 135.339266 -33.509745, 135.390901 -33.518391, 135.442013 -33.529727, 135.492462 -33.543723, 135.542108 -33.56034, 135.590818 -33.579532, 135.638456 -33.601247, 135.684892 -33.625426, 135.729999 -33.652002, 136.529999 -34.152002, 136.573653 -34.180902, 136.615736 -34.212047, 136.65613 -34.245352, 136.694726 -34.280725, 136.731418 -34.31807, 136.766105 -34.357284, 136.798692 -34.39826, 136.82909 -34.440885, 136.857216 -34.485042, 136.882992 -34.530611, 136.906347 -34.577467, 136.927219 -34.625481, 136.945549 -34.674521, 136.961288 -34.724453, 136.974391 -34.77514, 136.984824 -34.826444, 136.992558 -34.878224, 136.997571 -34.930337, 136.999849 -34.982642, 136.999388 -35.034993, 136.996187 -35.087249, 136.990255 -35.139266, 136.981609 -35.190901, 136.970273 -35.242013, 136.956277 -35.292462, 136.93966 -35.342108, 136.920468 -35.390818, 136.898753 -35.438456, 136.874574 -35.484892, 136.847998 -35.529999, 136.819098 -35.573653, 136.787953 -35.615736, 136.754648 -35.65613, 136.719275 -35.694726, 136.68193 -35.731418, 136.642716 -35.766105, 136.60174 -35.798692, 136.559115 -35.82909, 136.514958 -35.857216, 136.469389 -35.882992, 136.422533 -35.906347, 136.374519 -35.927219, 136.325479 -35.945549, 136.275547 -35.961288, 136.22486 -35.974391, 136.173556 -35.984824, 136.121776 -35.992558, 136.069663 -35.997571, 136.017358 -35.999849, 135.965007 -35.999388, 135.912751 -35.996187, 135.860734 -35.990255, 135.809099 -35.981609, 135.757987 -35.970273, 135.707538 -35.956277, 135.657892 -35.93966, 135.609182 -35.920468, 135.561544 -35.898753, 135.515108 -35.874574, 135.470001 -35.847998, 134.670001 -35.347998))
|
