hi Steve,guys<br>I really don't know where the coordinates are truncated or not. In facct, I couldn't find the reason cause the output problem.<br>the output is as flowings:<br>{<br> "type": "FeatureCollection",<br>
"features": [<br> {<br> "type": "Feature",<br> "id": "1",<br> "geometry": {<br> "type": "MultiLineString",<br> "coordinates": [<br>
"coordinates": [[84,42 84,42 84,42 84,42 83,42 83,42 83,42 83,42<br>83,42 83,42]] <br> ]<br> },<br> "properties": {<br> "gid": "1",<br> "type": "70",<br>
"name": "name111"<br> }<br> },<br>...<br>{<br> "type": "Feature",<br> "id": "3",<br> "geometry": {<br> "type": "MultiLineString",<br>
"coordinates": [<br> "coordinates": [[83,42 83,42 83,42 83,42 83,42]]<br> ]<br> },<br> "properties": {<br> "gid": "3",<br> "type": "70",<br>
"name": "name333"<br> }<br> },<br> ....<br>........<br> ]<br>}<br>But I exectue the SQL from pgAdmin III,select gid,type,ST_AsGeoJSON(the_geom) from tielu<br><img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAABBoAAAA3CAIAAAAtw77zAAAV5klEQVR4nO1dzbmkIBA0LRIiHbPxvHkYjHtQpIFqQJ3Rdl7VYb/ZFul/pAGfw2IP//79e1oEc6BNCIIgCIIgCIMYnhYAgFPnErQJQRAEQRAEYRAsJ94B2oQgCIIgCIIwCJYT7wBtQhAEQRAEQRgEy4l3gDYhCIIgCIIgDEKWE5MfhmHw02PCbBBT51WkACFauPC8tPegLCcmn6g/j24YBj9l5M+jn1HRcvLDMLhxbzC65L8Zjrl4Hl1hDXx/2vIYYr/OOTfO53o4yf2C5b+OnNMVI1/DUd1Xj2YN+4ghQtMYjtRWeIRgknxgn2BklhEuOSHuWE4N8+iQSD3ePGAQXfecUffteMQwTBQabaTelLklFJelCAYUdfgZfSQ+MXeDxNIgFdySR2pqd3K3kQi/nUeq30PjvVvMvTrWJSI97w4ptJ+W0T0/QU/Kid2ycxQtzlUmf2pO9z6U5UTuqckPg5+WycsQm7/gT8ios+XknQsSyd86cgUOaCSC50MY9xJiHt0gft+TNFcs/318zAoX7XlQd8ishzj5bRCaY1gE5vKygniXaAn7hCOzbCBFKrnDPnVM3o2SV/9zod8gUHfIqP92+FAwSKxESH/c3xCKS5Bb8kIhpD6jO+NT86Y1IjSIjjvySE/tLu4Gs+P38kjzu5hA1LhrjwmYR4/7KD/sZKyciJBzDPHz81NGm2iXE/Po3LiE8F2WfNkoxt9e/obf6y7B3nzvV6wwicgvGYnG5ZQnE8l5vwo+uu1nXEaWskE1oUZKrQxjo2w5j24YnMvXCbDu8GGKRAqaTMnyRz93sfgwxlV2xfIAuOUuq/Pei7oIuTgnYo0WETS7p84YefeU4mI1FEM7l05kSiuB+FyW5VI5Ua0nW88euRIiTKf22VNOQO4NOVOsTdDDr2ca1GsQqHuDUet2+FAwSIQaNXQvcEMoLigY6lEnmZ+JT5gIZojQIBruzqO0ZSd3g9nxk3kERELr4JB7pc9MJAs+ek05kZba+PcPo11OQKCskAEafscp/bJMfp2xhWnZ1k+rbNOmayXv0fkp/pPpko8X/bsTxQW11GyvgGq6a5NvJNLkQ7N07OjiHgxZPw92CLHTuLUSfJ0whUSk0ZyVrrUBFK/xTNMuUW1LTXFHtGvsXcXHywkcDJHeU/GFZafE4KhPVE4UNZfCXe8TygQ07R9t+gyCddcY9d0OHwoGiVAjVXcFN4ViEQxq1BVS9ccn5G6QWMkOaFDY8rN5pD6P+rgbzI4fzCPEaB6998UZJsRd7bMQyYKPXlJOpDMMlhPtSnkFnOnuxHg17W3ybpzl86BrLtKDdQIY5p5mygmxBu/GJX0WYt3lPFstJ7DFerhnD1uoxTEoyy1SxK0JJILmWZd5QDbVXFI7V8oJ1R1iK+P0KHC6nJhHv2s0la3bCRo3i/b3cCp96gMd4pRsglflTG4CU/MW94gjBgG6Nxi1brfwNO0hKhpVdS9wQyhWggF3qo7MjfhUgsEcsWUQqdxNeQRb9nM3mB2/l0eQkVh9i50q3NU+M5Es+Ogl5YS6vvtHDzv1vuiqDPFrxZttqcXLYdL/iQIixb4bMk1Suq+XE439gWKm26F78wwJy4mGkWVJJrsuRW2644KVTpcTiWFwlh1+qlX6rPRWl7Ypp7glKdk6uaM2BwxSmeIcuh2OIQaJFY1OT4O+E4pqMOA+9SQ9nWKmiE2DiFtuyiPYsp+7wez4vTyC/xUHAGD5d2b8tOCjd5QTxTwmnvz2H5/ymsT53YnN3+lxkMm7cRSZmWykiRNQB4Kh/7CTvCWUE3tGtcZfTaPPlhNQ93TOGjtRRDpdTqTnedqHncqDRhDyPFEYzpLROQgGiUijtNRoHXZCaopHYLa/m3YKQzF/d7Ku/hfenShHf/GYmLx0XCU75EEv1Cfknh5Ii+YC3LU+K2FTql9SSo0OGaTUvaFm63b4ULBHrGlUGlnz0Q2hiHjBqNuvyVsPxGedu0FiOTV8Ko8qw0UPd3vZ8bN5pE9jJKeaN0WfWCQLPkr+spPAk0UFmDpnQ0//aeBfwcl3J7ZEApZK/7DA5NcXsjPnJ+/FNti1y4nda2GGGOUCbx5n7+QmU+GUBFoWx2NSNqCln/arYVKd6z5n6z7JwzMh4pYHuMcOvG/tv3VWE6lUYh5eagSIiu7ytJHbSsEDasp93AHFHfB6lP5IdH6hnEiU3y8oQ1PJXTas94lHZu3YdEnER8K0sImpWOMO7dltEKh7v5rYdP0GMUjcLFAsiGAf3RKKst/6y2Nry55ndLc3DRKxQR7NIyW1u7kbTISfy6O63xMa4v6ysa408ePgJ9tKnC4nNOSrgH/jzNj7oB/uig3+TFH9DVw8C/FWMGzsASxhKj76qVB8NZhH9sA8egosJ96B5mfsugFK4LJOJh5G9FLrWXXsSBqRA/7Njn7iW8GwMYUt34u1UsVHPxWKrwbzyBSYR4+C5cQ7QJsQBEEQBEEQBjH8IwiCIAiCIAiCOAXuTrwDtAlBEARBEARhECwn3gHahCAIgiAIgjAIlhPvAG1CEARBEARBGATLiXeANiEIgiAIgiAMguXEO0CbEARBEARBEAbBcuIdoE0IgiAIgiAIg5DlxP7prIe/8iimzuKba+nnRsKFv/IFkrKcyD5jFz75fvbrdt3oZ1S0nHz5/Xn9a9zHXDyPDn7Bvrw/bXkM4vPyzp1KkwvcL1j+68g5XTHyNRzV/cJn7EKEpjEcqa3wQBEOB+GSqA2MKx122JtM8+hQD73eDBkS5Q8UnJ57O0hcalbKRSoZmSSisIGf39JhKRQ3FGFj0PJXiVBNDU/lkSYnDIYqEd5uh4jsaTGPSiIck+tD+oDTMJXz+ZSR/4l66ZO8G5CUE7skc/wgepyrTP6PfOC+LCfy78NPfhj8tExext38ha/IQ0adLSfvnNvDLP7WkStwQCMRPB/CuJcQ8+gG8fuemfMVy38fH7PCRXse1B0y6yHu31qdY1gE5vKyAjiIwUEYEfHAuLZM5cQtdUzejbId6lOFyIrIc8/93SDSYqBlStSslInUYGSGCMMm6NU/DbITioFbGjYGLX+RCNXU8VgeQe4wGCARBoNBYsWepvIIEeGYXBvSN+6hAZTTQsrAw06fn4cdAjzYIx+F4ufDot6Gdjkxj86NSxZ/Zb27Elejhd/rLsHefO9XLH6IUatkJBqXT/hMJOf9Kvjotp9xGVnKBtWEGilLAjA2ypbz6IbBuWIpCOoORm8sUtBkSpY/+rmL1YcxrrIrlgfALeM6h/de1EXIxTkRa7SIoBHj4nEj755SXKyGYmgXK9P++FyW5VI5Ua0nW8+e1iDWSyyZa0/TnmpibVM27HpCo8UdSds76S8nKlZS3SEumSYW/rgwDXo4FMuwsWLkzxGhmhoezKOGnDAYBBEGg0FicalBhLghj+rJBfkoA3W8HcppIWVAOXHbYqsGWE6khT7+/cNolxMQyJcyGsJveTJk8uuMLUzLtn5aZZs2XSt5j85P8Z9Ml9Z4oUdncUEtNcs1iXz5QdNdm3wr4/bWLH08dHEPhqyfBzuE2GncWgm+TphCItJozkrXRK+2msuyTBN4Lpb2VNwhl3uaoffxcgIHQ6Q35KkPYv2Pmf4pS3vEiJXYmWnQPHrv813wZCkrGEoe0pAtS2LFSrXdCcHIGlENmwvToIdDEYWNQct/wHFKdgDrPJdHKncYDAURBoNBIvxvhQhxQx7Vk6tf/jzjCjktpExeTqwzDdVgtwCUE+mQxnKiXSmvqD8K5EZbuortxlkOVfDhdwbrBDDMPc2UE2IN3o1LOkxj3eU8u7KYgCzWw718NlyFstwiRdyaQCJonnWZB2RTzSW1c6WcUN0htjJOjwKny4l59LtGU9n6wFIWmBmXgzAemZFbcTh2rBLtPjo3DRIlZVIy7nti6HWjxmLpkZkEZGSOWAmb09OgZ0NRCRtzlr9IrGRHhmfzqCHngd0JK5XDbeXEN/KoNlntXjTKMk6R00DKSKHXYkM3100A5YS6vvtHDzv1vuiqzCHW8jLbKIuXw6T/EwVEin03ZJqkdF8vJxr7A8VMt0P3xsYoy4mmkWVJJrsuRW2644KVTpcTiWFwltVyVIt5OAirIzOyzLFwTG4cIjoOFZRCJj4uuJ0w9YGR4Rqj24iVsDk9DXo2FCthU+H+OmJTTXHLk3l00R0wGAwSe3Rp4oY8qk1WoXcLIsq4M3LeQExexT6/xPdRoL9ilM1j4slv//Epr0mc353Y391M/1qAG0cR3HJPN875u1gIVkPfYSd5Sygn9gWV1virafTZcgLqns5ZYyeKSKfLifQ8T7vCLw8aQcjzROGJlQxwQTBIRBqlpUbrsBNSMzRJXj0E9mwtqV04jHd66BQD+f5TzAQmn64n5dzhIAYH4crI3D/bKFtWwqZnVRXYM4lb0D4xzZzdAom1oV57tCcH5+wRUdioGmk+MhiKUP7FkuU/RSyMbyqPIC8YDDhCYDAYJBY61ogP5lFF+J5qAmZcZQxZHs2OIV4ZJJ4sLMDUOUsV/fjpr+LkuxNyXyrPw/TN3/WF7Mz54jDJ6bPpeYshzhCjXPE/+5vHCW8pfqERaFkcj0nZgJZ+2q+GSXWu+5yt+0R75iLhlge4xw68b+2/dVYTqVRiHl5qBIiK7vK0kdtKwQNqyk3TAcUd8HqU/kh0fqGcSJTfLyhDE540ZC3hIFwbmcu1ut6WetjEVKz3Ce0p4rYIMCkAtFI3EYoEGRkk4rDZ9CoWRLCPTIZiqqlBy191HFLTYh5BOa9lnEGiPtZZyiP9djQmF0Qt45CcJlKm0Od58JNtJU6XExrS2//KmbH3oTz5Uzb4M0X1N3Bxt/etYNjYA9iJVXz0U6H4ajCP7IF59BRYTrwDzc/YdQMUtsVSCPE0opdaz6pjR9KIHPBvdvQT3wqGjSls+V6slSo++qlQfDWYR6bAPHoULCfeAdqEIAiCIAiCMIjhH0EQBEEQBEEQxClwd+IdoE0IgiAIgiAIg2A58Q7QJgRBEARBEIRBsJx4B2gTgiAIgiAIwiBYTrwDtAlBEARBEARhECwn3gHahCAIgiAIgjAIlhPvAG1CEARBEARBGERSTsQvsz/6lUcxdRbfXEs/NxIu/JUvkJTlRPYZu/DJ97Nft+tGP6Oi5eTTD7OPLvlvhmMunkdXWAPfn7Y8BvF9eedOpckF7hcs/3XknK4Y+RqO6n7hM3ZxvJTN+kdRGOHw9qKlNjBeFWnZDChFWu/u9WbIkMgrUE4Kj/rEIlXtaZAo3AE/v6XjllDc3ZTcXnhTJS5qLGlyGvQRfqb0JNJzeYRvR8SrLjZHfE0eQUbVlu3bDbgjEXC9+vSHHpNyYrfXHD+IHucqk/8jH7gvy4n8+/Cb/yYv427+wlfkIaPOlpN3Lkgkf+vIFTigkQieD2HcS4h5dIP4fU++XLH89/ExK1y050HdIbMe4j5MzjEsDoyicBCDt6OWeGC8KNLes9R0Zd7pEpEVUbo994eY+b3Cwz6hSNCeBokVd/TH/Q2hGNcDJr/PWpA3MXEJ3UlRoZwGfaQRj4ylj+URvB0SL7rYIDHoZT2PICPYsv92C+5Ah50MlRMRMl/Ez89PGW2iXU7Mo3PjksVfuXqxElejhd/rLsHefO9XrMeIgahkJBrnT/hCJOf9Kvjotp9xGVnKBtWEGinLSzA2lDUn54q1HKg7eKBgkYImU7L80c9drD6McZVdsTwAbhnXObz3oi5CLs6JWKNFBM3oDqsp+VTtqYdiaBcr0/74XJblUjlRrSdbo2hjEBO311vO2eULIu33lTd3PaHR4o6klZ20hdcXjLLeoJUMEiM+OQ36ZigKIvSm5uIylqCcBn0EiYfKiQfzCKdMY+H1jIsNEuF/K3g+j/Da2ZnbLbgjLSdmuMl/N2A5kRb6+PcPo11OQKBgldEQfscp/VYFz3FatvXTKtu06VrJe3R+iv9kuuSJ1L87UVxQS81yTSJfftB01ybfSKTJh2bpUN7FPRiyfh7sEGKncWsl+DphColIozkrXWtjOl7jmaZdotqWmuIOuVjfDL2PlxM4GJbeUVQdxIrb68MduvekSKISOzMNmkfvfb4LnixlFWumTeFhn1AkaCWDRKHpqbkmbPmlUAx91L2JXQxjCclp0EeQKFY0+ldzHsgj5XY1j5azLjZI7DcybnlXHqmMypbdt1twx0t2J/K9PJYTfU6qB2a8mvY2eTfOcvTU4v4w1glgmHuaKSfEGrwbl/TJgXWX82y1nMAW6+GeDBwfKSeU5RYp4tYEEkHzrMs8IJtqLqmdK+WE6g6xlXF6FDhdTsyj3zWaytYHlrIQO7w70UiHiyLtPjo3DRIlZVIy7nti+etGHcIrfQKRDE5A+12stlFwWyiuKw9pX6U3ARHGEpTToI9aE4yGQZ/NI3h7JY9Ou9gksdfIsOVteVRhVLij/3YD7mja5X6AckJd3/2jh516X3RVZrpreZltlMXLYdL/iQIixb4bMk1Suq+XE439gWKm26F7a7+S5UTLyLIkk12XojbdccFKp8uJxDA4y2o52hzE0OSmaFkZGM+IlJRs/TcGlkPi48JjeScdwlf6rLnDxvGYfhfD/1ZwTyiui4+dMmREGEtQToM+Ouq44uqTeQRv1/q84mKzRPt5pDGC7ui/vS7nDcS9nBDxJt75eATorxhl85h48tt/fMprEud3JzZXpsdBJu/GUUR8sl8oTkAdqCr7DzvJW0I5sS/ntMZfTaPPlhNQ93TOGjtRRDpdTqTnedqHncqDRhDyPFHI9mTUC4JBItIoLTVah52QmnFKke/app3CUMxfBKur//HDTmIg33+qo2jJHQ1i+PbKcJd55JBIlbDpWVUF9kziFrR3h4Wv9amuLAor2SPWnrOlkTUffT8Ul/zvEqUovakR0wEEuNiej1qOS0cba3mEb0fET7nYGtF+HsFEgC37b5eCPWX5Ibm4F9SPTtHB1DmbK5gR9TacfHdiSyRgqfTvPEx+fSF7RTJHHAoqRruc2L0WZohRrvif/c3jhLcUv9AItCyOx6RsQEs/7VfDpDrXfc5WnZIFoYSIWx7gHjvwvrX/1llNpFKJp0ypESAqusvTRm4rBQ+oKTdNBxR3wOtR+iPR+YVyIlF+v6AMTXjSULbsJ64SFJsV3SJpYRNTMWgtvZn3mnUg4rYIsDyM+4RHfWKRLtrzWeKmV7Eggn30/VDMB9CtOfRmzcUZvV/OtxAN5hG6HRAvu9ggMZjaeh4BRrBl/+1PW34jliZ+HPxkW4nT5YSG9Pa/cmbsfYCHlLIGf6ao/gYu7va+FQwbewA7sYqPfioUXw3mkT0wj54Cy4l3oPkZu26AwhatZRCPInqp9ax6+g8nvB3wb3b0E98Kho0pbPlerJUqPvqpUHw1mEemwDx6FCwn3gHahCAIgiAIgjCI4R9BEARBEARBEMQpcHfiHaBNCIIgCIIgCINgOfEO0CYEQRAEQRCEQfwHaXPXRmjuTG4AAAAASUVORK5CYII=" alt=""><br>
IN pgAdmin I output the SQL so you can see the output exactely,<br>{"type":"MultiLineString","coordinates":[[[83.981538,41.839139000000003],[83.945753999999994,41.838410000000003],[83.916893000000002,41.834904999999999],[83.687324000000004,41.810006000000001],[83.232517999999999,41.753878999999998],[83.223220999999995,41.752234000000001],[83.221637999999999,41.750559000000003],[83.216065999999998,41.741002999999999],[83.144756999999998,41.724834000000001],[83.030783,41.697861000000003]]]}<br>
{"type":"MultiLineString","coordinates":[[[83.022717,41.695501999999998],[83.022499999999994,41.695433000000001],[83.007728999999998,41.691218999999997]]]}<br>{"type":"MultiLineString","coordinates":[[[83.030783,41.697861000000003],[83.029948000000005,41.697662999999999],[83.028228999999996,41.697189000000002],[83.025898999999995,41.696514000000001],[83.022717,41.695501999999998]]]}<br>
.....<br>.....<br>If there is nothing wrong with my template file xj1JSON.tmpl, the "coordinates" of GeoJSON output should match with the ST_AsGeoJSON(the_geom).I have no clue.<br><br>