{"action":"created","issue":{"url":"https://api.github.com/repos/TileStache/TileStache/issues/301","repository_url":"https://api.github.com/repos/TileStache/TileStache","labels_url":"https://api.github.com/repos/TileStache/TileStache/issues/301/labels{/name}","comments_url":"https://api.github.com/repos/TileStache/TileStache/issues/301/comments","events_url":"https://api.github.com/repos/TileStache/TileStache/issues/301/events","html_url":"https://github.com/TileStache/TileStache/issues/301","id":247669738,"number":301,"title":"Tilestache: Not able to render data from postGIS SQL","user":{"login":"Akulkarni1","id":17604602,"avatar_url":"https://avatars3.githubusercontent.com/u/17604602?v=4","gravatar_id":"","url":"https://api.github.com/users/Akulkarni1","html_url":"https://github.com/Akulkarni1","followers_url":"https://api.github.com/users/Akulkarni1/followers","following_url":"https://api.github.com/users/Akulkarni1/following{/other_user}","gists_url":"https://api.github.com/users/Akulkarni1/gists{/gist_id}","starred_url":"https://api.github.com/users/Akulkarni1/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Akulkarni1/subscriptions","organizations_url":"https://api.github.com/users/Akulkarni1/orgs","repos_url":"https://api.github.com/users/Akulkarni1/repos","events_url":"https://api.github.com/users/Akulkarni1/events{/privacy}","received_events_url":"https://api.github.com/users/Akulkarni1/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2017-08-03T10:59:29Z","updated_at":"2017-08-04T05:16:01Z","closed_at":null,"body":"my tilestache.cfg is as below:\r\n{\r\n  \"cache\": {\r\n        \"name\": \"Disk\",\r\n        \"path\": \"mnt/tile-cache/\"\r\n    }\r\n    ,    \r\n  \"layers\":\r\n  {  \r\n     \"countries\":\r\n    {\r\n      \"provider\": {\r\n            \"name\": \"vector\", \r\n            \"driver\": \"PostgreSQL\",\r\n            \"parameters\": \r\n             {\r\n            \"dbname\": \"test1\",\r\n            \"host\" : \"localhost\",\r\n            \"port\" : \"5432\",\r\n            \"user\": \"postgres\",\r\n                        \"password\":\"postgres\",\r\n                        \"table\": \"ne_110m_admin_0_countries\",\r\n                         \"query\":\"SELECT admin, ST_Y(ST_Centroid(wkb_geometry)) as lattitude FROM ne_110m_admin_0_countries;\"\r\n\r\n             }}}}}\r\n\r\nI am getting error as\r\n\r\nFile \"/usr/local/lib/python2.7/dist-packages/TileStache-1.51.6-py2.7.egg/TileStache/__init__.py\", line 303, in requestHandler2\r\n    print >> out, 'Known unknown!'\r\n\r\nURL using is as below\r\n\r\nI am using URL as localhost:8080/countries/1/1/1.json\r\n\r\nNot able to render data."},"comment":{"url":"https://api.github.com/repos/TileStache/TileStache/issues/comments/320158462","html_url":"https://github.com/TileStache/TileStache/issues/301#issuecomment-320158462","issue_url":"https://api.github.com/repos/TileStache/TileStache/issues/301","id":320158462,"user":{"login":"Akulkarni1","id":17604602,"avatar_url":"https://avatars3.githubusercontent.com/u/17604602?v=4","gravatar_id":"","url":"https://api.github.com/users/Akulkarni1","html_url":"https://github.com/Akulkarni1","followers_url":"https://api.github.com/users/Akulkarni1/followers","following_url":"https://api.github.com/users/Akulkarni1/following{/other_user}","gists_url":"https://api.github.com/users/Akulkarni1/gists{/gist_id}","starred_url":"https://api.github.com/users/Akulkarni1/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Akulkarni1/subscriptions","organizations_url":"https://api.github.com/users/Akulkarni1/orgs","repos_url":"https://api.github.com/users/Akulkarni1/repos","events_url":"https://api.github.com/users/Akulkarni1/events{/privacy}","received_events_url":"https://api.github.com/users/Akulkarni1/received_events","type":"User","site_admin":false},"created_at":"2017-08-04T05:16:01Z","updated_at":"2017-08-04T05:16:01Z","body":"Hi, \r\nI am using python 2.7.x.\r\nI tried with below query.\r\nSelect gid,geom AS __geometry__ from public.be-water-area_multiploygon\r\nfrom the table below.\r\n![image](https://user-images.githubusercontent.com/17604602/28954870-d1390a52-78ff-11e7-8c31-bbf506ec1f59.png)\r\nbelow is the response \r\n![image](https://user-images.githubusercontent.com/17604602/28955150-e7da2a28-7901-11e7-95bb-a756d4e35d33.png)\r\n\r\n![image](https://user-images.githubusercontent.com/17604602/28955161-ff21842e-7901-11e7-836e-989243b2127a.png)\r\n\r\n\r\nPlease help me with the above.\r\n\r\nThanks in advance.\r\nBest regards,\r\nAmit.\r\n"}}
{"actor":{"display_login":"Akulkarni1"}}