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((136.529999 -34.152002, 136.574402 -34.181426, 136.617174 -34.213174, 136.658196 -34.247153, 136.69735 -34.283269, 136.734525 -34.321419, 136.769617 -34.361494, 136.802524 -34.40338, 136.833155 -34.44696, 136.861421 -34.492109, 136.887243 -34.538698, 136.910548 -34.586597, 136.931269 -34.635669, 136.949348 -34.685774, 136.964733 -34.736771, 136.977381 -34.788515, 136.987256 -34.840859, 136.994329 -34.893654, 136.998581 -34.946752, 137 -35, 137 -35.2, 136.998646 -35.252013, 136.994589 -35.303886, 136.987839 -35.355478, 136.978415 -35.406648, 136.966342 -35.457259, 136.951653 -35.507174, 136.934388 -35.556257, 136.914593 -35.604375, 136.892322 -35.651399, 136.867635 -35.697201, 136.8406 -35.741657, 136.811289 -35.784646, 136.779781 -35.826052, 136.746162 -35.865764, 136.710524 -35.903673, 136.672961 -35.939678, 136.633577 -35.97368, 136.592478 -36.005587, 136.549774 -36.035313, 136.505583 -36.062778, 136.460022 -36.087907, 136.413216 -36.110633, 136.365292 -36.130893, 136.316378 -36.148633, 136.266608 -36.163805, 136.216117 -36.176368, 136.16504 -36.186287, 136.113516 -36.193536, 136.061685 -36.198096, 136.009687 -36.199953, 135.957663 -36.199103, 135.905754 -36.195549, 135.854099 -36.189299, 135.80284 -36.180371, 135.752114 -36.168789, 135.70206 -36.154584, 135.652812 -36.137795, 135.604504 -36.118468, 135.557266 -36.096653, 135.511228 -36.072411, 135.466512 -36.045808, 135.423241 -36.016914, 135.381531 -35.985809, 135.341495 -35.952577, 134.541495 -35.252577, 134.503051 -35.21712, 134.466512 -35.179703, 134.43198 -35.140426, 134.399548 -35.099397, 134.369306 -35.056729, 134.341336 -35.012539, 134.315714 -34.966946, 134.292511 -34.920076, 134.27179 -34.872058, 134.253608 -34.823021, 134.238015 -34.773102, 134.225052 -34.722435, 134.214757 -34.67116, 134.207156 -34.619416, 134.20227 -34.567346, 134.200114 -34.515092, 134.200692 -34.462797, 134.204004 -34.410603, 134.21004 -34.358654, 134.218783 -34.307091, 134.230211 -34.256056, 134.24429 -34.205689, 134.260984 -34.156126, 134.280246 -34.107504, 134.302024 -34.059955, 134.326258 -34.01361, 134.352882 -33.968595, 134.381823 -33.925034, 134.413001 -33.883046, 134.446332 -33.842744, 134.481725 -33.804241, 134.519082 -33.76764, 134.558301 -33.733043, 134.599276 -33.700543, 134.641894 -33.670231, 134.686038 -33.642187, 134.731588 -33.61649, 134.778419 -33.593209, 134.826403 -33.572409, 134.875409 -33.554145, 134.925303 -33.538469, 134.975949 -33.525423, 135.027207 -33.515042, 135.078937 -33.507355, 135.130999 -33.502383, 135.18325 -33.50014, 135.235546 -33.500632, 135.287745 -33.503857, 135.339704 -33.509807, 135.391281 -33.518465, 135.442335 -33.529807, 135.492726 -33.543804, 135.542316 -33.560415, 135.59097 -33.579597, 135.638555 -33.601296, 135.68494 -33.625453, 135.729999 -33.652002, 136.529999 -34.152002), (135.132863 -35.497419, 135.165007 -35.499388, 135.217358 -35.499849, 135.269663 -35.497571, 135.321776 -35.492558, 135.373556 -35.484824, 135.42486 -35.474391, 135.475547 -35.461288, 135.525479 -35.445549, 135.574519 -35.427219, 135.622533 -35.406347, 135.669389 -35.382992, 135.714958 -35.357216, 135.759115 -35.32909, 135.80174 -35.298692, 135.842716 -35.266105, 135.88193 -35.231418, 135.919275 -35.194726, 135.954648 -35.15613, 135.987953 -35.115736, 136.019098 -35.073653, 136.047998 -35.029999, 136.074574 -34.984892, 136.098753 -34.938456, 136.120468 -34.890818, 136.13966 -34.842108, 136.156277 -34.792462, 136.170273 -34.742013, 136.181609 -34.690901, 136.190255 -34.639266, 136.196187 -34.587249, 136.199388 -34.534993, 136.199849 -34.482642, 136.197571 -34.430337, 136.192558 -34.378224, 136.184824 -34.326444, 136.174391 -34.27514, 136.161288 -34.224453, 136.145549 -34.174521, 136.127219 -34.125481, 136.106347 -34.077467, 136.082992 -34.030611, 136.067137 -34.002581, 136.034993 -34.000612, 135.982642 -34.000151, 135.930337 -34.002429, 135.878224 -34.007442, 135.826444 -34.015176, 135.77514 -34.025609, 135.724453 -34.038712, 135.674521 -34.054451, 135.625481 -34.072781, 135.577467 -34.093653, 135.530611 -34.117008, 135.485042 -34.142784, 135.440885 -34.17091, 135.39826 -34.201308, 135.357284 -34.233895, 135.31807 -34.268582, 135.280725 -34.305274, 135.245352 -34.34387, 135.212047 -34.384264, 135.180902 -34.426347, 135.152002 -34.470001, 135.125426 -34.515108, 135.101247 -34.561544, 135.079532 -34.609182, 135.06034 -34.657892, 135.043723 -34.707538, 135.029727 -34.757987, 135.018391 -34.809099, 135.009745 -34.860734, 135.003813 -34.912751, 135.000612 -34.965007, 135.000151 -35.017358, 135.002429 -35.069663, 135.007442 -35.121776, 135.015176 -35.173556, 135.025609 -35.22486, 135.038712 -35.275547, 135.054451 -35.325479, 135.072781 -35.374519, 135.093653 -35.422533, 135.117008 -35.469389, 135.132863 -35.497419))
|